- Timestamp:
- May 29, 2024, 1:45:09 PM (6 months ago)
- Location:
- trunk
- Files:
-
- 6 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/admin/versione.php
r417 r418 1 1 <?php 2 2 3 $versione = "3.0 rev 41 7";3 $versione = "3.0 rev 418"; 4 4 $version_number = $versione; 5 $datarel = "2 4maggio 2024";5 $datarel = "29 maggio 2024"; 6 6 $version = "Eleonline $version_number (<i>Data Release: $datarel</i>)"; 7 7 -
trunk/client/modules/Elezioni/index.php
r416 r418 1387 1387 ########## icona rss da sistemare in un altra parte con calma... 1388 1388 global $circo; 1389 if($genere!=0 && $id_circ==''){ // no referendum ne circoscrizioni1390 echo "<div align=\"right\"><a href=\"modules.php? id_cons_gen=$id_cons_gen&name=Elezioni&id_comune=$id_comune&file=index&op=rss&rss=1\"><img class =\"nobordo\" width=\"60\" src=\"modules/Elezioni/images/valid-rss.png\" alt=\"rss\"/></a></div>";1389 if($genere!=0 && !$circo){ // no referendum ne circoscrizioni 1390 echo "<div align=\"right\"><a href=\"modules.php?op=rss&rss=1&id_cons_gen=$id_cons_gen&name=Elezioni&id_comune=$id_comune&file=index\"><img class =\"nobordo\" width=\"60\" src=\"modules/Elezioni/images/valid-rss.png\" alt=\"rss\"/></a></div>"; 1391 1391 } 1392 1392 -
trunk/client/modules/Elezioni/rss.php
r390 r418 27 27 28 28 list($descr_com) = $res->fetch(PDO::FETCH_NUM); 29 30 31 32 echo "<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n"; 29 //URL 30 $PHP_SELF=$_SERVER['PHP_SELF']; 31 $siteurl.=$PHP_SELF; 32 33 echo "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n"; 33 34 echo "<rss version=\"2.0\" \n"; 34 35 echo " xmlns:dc=\"http://purl.org/dc/elements/1.1/\"\n"; 35 36 echo " xmlns:sy=\"http://purl.org/rss/1.0/modules/syndication/\"\n"; 36 37 echo " xmlns:admin=\"http://webns.net/mvcb/\"\n"; 38 echo " xmlns:atom=\"http://www.w3.org/2005/Atom\"\n"; 37 39 echo " xmlns:rdf=\"http://www.w3.org/1999/02/22-rdf-syntax-ns#\">\n\n"; 38 40 echo "<channel>\n"; 39 41 echo "<title>".htmlspecialchars($descr_com)." - $descr_cons</title>\n"; 40 echo "<link> ".htmlspecialchars($siteurl)."</link>\n";42 echo "<link>https://".htmlspecialchars($siteurl)."</link>\n"; 41 43 echo "<description>".$sitename."</description>\n"; 42 44 echo "<dc:language>it-IT</dc:language>\n"; … … 46 48 echo "<sy:updateFrequency>1</sy:updateFrequency>\n"; 47 49 echo "<sy:updateBase>".$now."</sy:updateBase>\n\n"; 48 49 list ($gruppo,$pro,$titolo)=grupporss(); 50 echo "<atom:link href=\"https://$siteurl?op=rss&rss=1&name=Elezioni&id_comune=$id_comune&file=index&id_cons_gen=$id_cons_gen\" rel=\"self\" type=\"application/rss+xml\" />\n"; 51 52 list ($gruppo,$pro,$titolo,$idg)=grupporss(); 50 53 51 54 … … 58 61 echo "<item>\n"; 59 62 echo "<title>".$gruppo[$x]." ".$pro[$x] ."% </title>\n"; 60 echo "<link>$siteurl/modules.php?id_cons_gen=$id_cons_gen&name=Elezioni&id_comune=$id_comune&file=index</link>\n"; 63 echo "<link>https://$siteurl?op=rss&rss=1&name=Elezioni&id_comune=$id_comune&file=index&id_cons_gen=$id_cons_gen</link>\n"; 64 echo "<guid>https://$siteurl?op=rss&rss=1&name=Elezioni&id_comune=$id_comune&file=index&id_cons_gen=$id_cons_gen&gruppo=$idg[$x]</guid>\n"; 61 65 62 66 # echo "<description><![CDATA['aa']]></description>\n"; … … 89 93 if ($genere==4){$tab="ele_voti_lista";} 90 94 if ($votog){$tab="ele_voti_lista";} 91 $sql="select *from ".$prefix."_$tab where id_cons='$id_cons' group by id_sez ";95 $sql="select id_sez from ".$prefix."_$tab where id_cons='$id_cons' group by id_sez "; 92 96 $res = $dbi->prepare("$sql"); 93 97 $res->execute(); … … 138 142 left join ".$prefix."_$tab as t2 on (t1.id_gruppo=t2.id_gruppo) 139 143 where t1.id_cons='$id_cons' and t1.id_cons=t2.id_cons $circondt1 140 group by t 2.id_gruppo144 group by t1.id_gruppo,t1.num_gruppo,t1.descrizione 141 145 order by somma desc"; 142 146 $res = $dbi->prepare("$sql"); … … 151 155 left join ".$prefix."_$tab as t2 on (t1.id_lista=t2.id_lista) 152 156 where t1.id_cons='$id_cons' and t1.id_cons=t2.id_cons 153 group by t 2.id_lista157 group by t1.id_lista,t1.num_lista,t1.descrizione 154 158 order by somma desc"; 155 159 $res = $dbi->prepare("$sql"); … … 176 180 177 181 178 182 $idg[$i]=$id; 179 183 180 184 … … 196 200 197 201 198 return array($gruppo,$pro,$titolo );202 return array($gruppo,$pro,$titolo,$idg); 199 203 200 204 -
trunk/client/temi/Futura2/function_theme.php
r376 r418 975 975 if ($circo) $circos="and t2.id_circ='$id_circ'"; 976 976 else $circos=""; 977 if (!$csv) 978 979 980 // numero sezioni scrutinate 981 //if ($circo)$circos="and id_circ='$id_circ'"; 982 if (!isset($data1)) $data1=''; 983 if (!isset($ora_ril)) $ora_ril=''; 984 $sql="SELECT count(data) FROM ".$prefix."_ele_voti_parziale as t3 left join ".$prefix."_ele_sezioni as t1 on t3.id_sez=t1.id_sez left join ".$prefix."_ele_sede as t2 on t1.id_sede=t2.id_sede where t1.id_cons='$id_cons' and data='$data1' and orario='$ora_ril' $circos group by t3.id_gruppo"; 985 $res1 = $dbi->prepare("$sql"); 986 $res1->execute(); 987 # mysql_query("select * from ".$prefix."_ele_voti_parziale where id_cons='$id_cons' $circos group by id_sez ",$dbi); 988 $numero=$res1->rowCount(); 989 $sql="SELECT t1.* FROM ".$prefix."_ele_sezioni as t1, ".$prefix."_ele_sede as t2 where t1.id_cons='$id_cons' and t1.id_sede=t2.id_sede $circos order by num_sez"; 977 $sql="SELECT t1.* FROM ".$prefix."_ele_sezioni as t1, ".$prefix."_ele_sede as t2 where t1.id_cons='$id_cons' and t1.id_sede=t2.id_sede $circos order by num_sez"; 990 978 $res2 = $dbi->prepare("$sql"); 991 979 $res2->execute(); 992 #mysql_query("select * from ".$prefix."_ele_sezioni where id_cons='$id_cons' $circos",$dbi); 993 $sezioni=$res2->rowCount(); 994 995 996 997 998 980 $sezioni=$res2->rowCount(); 981 999 982 // barre 1000 983 $l_size = getimagesize("modules/Elezioni/images/barre/leftbar.gif"); -
trunk/client/versione.php
r417 r418 1 1 <?php 2 2 3 $versione = "3.0 rev 41 7";3 $versione = "3.0 rev 418"; 4 4 $version_number = $versione; 5 $datarel = "2 4maggio 2024";5 $datarel = "29 maggio 2024"; 6 6 $version = "Eleonline $version_number (<i>Data Release: $datarel</i>)"; 7 7 -
trunk/install/sql/eleonline.sql
r413 r418 8 8 /*!40101 SET NAMES utf8mb4 */; 9 9 10 CREATE DATABASE IF NOT EXISTS `eleonline` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;10 /* CREATE DATABASE IF NOT EXISTS `eleonline` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; 11 11 USE `eleonline`; 12 12 */ 13 13 CREATE TABLE `soraldo_access` ( 14 14 `access_id` int(10) NOT NULL, … … 185 185 `solo_gruppo` enum('0','1') DEFAULT '0', 186 186 `disgiunto` enum('0','1') NOT NULL DEFAULT '0', 187 `proiezione` ENUM('0','1') NOT NULL DEFAULT '0' ;187 `proiezione` ENUM('0','1') NOT NULL DEFAULT '0' 188 188 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; 189 189
Note:
See TracChangeset
for help on using the changeset viewer.