| [2] | 1 | <?php
|
|---|
| 2 |
|
|---|
| 3 | /************************************************************************/
|
|---|
| 4 | /* Eleonline - Raccolta e diffusione dei dati elettorali */
|
|---|
| 5 | /* by Roberto Gigli & Luciano Apolito */
|
|---|
| 6 | /* http://www.eleonline.it */
|
|---|
| 7 | /* info@eleonline.it luciano@aniene.net rgigli@libero.it */
|
|---|
| 8 | /************************************************************************/
|
|---|
| 9 | /* Modulo Autorizzazione Comuni */
|
|---|
| 10 | /* Amministrazione */
|
|---|
| 11 | /************************************************************************/
|
|---|
| 12 | # e' l'unico file in cui Ú presente un controllo su tipo_cons, per ora va bene così. Per toglierlo va inserito un campo-flag in ele_tipo per indicare se per il tipo di consultazione si dovra' procedere al calcolo dell'assegnazione dei seggi
|
|---|
| 13 | if (!defined('ADMIN_FILE')) {
|
|---|
| 14 | die ("You can't access this file directly...");
|
|---|
| 15 | }
|
|---|
| 16 |
|
|---|
| 17 | $aid=$_SESSION['aid'];
|
|---|
| 18 | $dbi=$_SESSION['dbi'];
|
|---|
| 19 | $prefix=$_SESSION['prefix'];
|
|---|
| 20 | $id_comune=$_SESSION['id_comune'];
|
|---|
| 21 | $id_cons_gen=intval($_GET['id_cons_gen']);
|
|---|
| 22 | $perms=ChiSei(0);
|
|---|
| 23 | if ($perms<128 or !$id_cons_gen) die("$perms Non hai i permessi per inserire dati, o non hai scelto la consultazione!");
|
|---|
| 24 | $res = mysql_query("SELECT t1.tipo_cons,t1.descrizione,t2.id_cons,t2.id_conf FROM ".$prefix."_ele_consultazione as t1, ".$prefix."_ele_cons_comune as t2 where t1.id_cons_gen=t2.id_cons_gen and t2.id_comune='$id_comune' " , $dbi);
|
|---|
| 25 | list($tipo_cons,$descr_cons,$id_cons,$id_conf) = mysql_fetch_row($res);
|
|---|
| 26 |
|
|---|
| 27 | $res = mysql_query("SELECT genere FROM ".$prefix."_ele_tipo where tipo_cons='$tipo_cons' " , $dbi);
|
|---|
| 28 | list($genere) = mysql_fetch_row($res);
|
|---|
| 29 |
|
|---|
| 30 | include("modules/Elezioni/funzionidata.php");
|
|---|
| 31 | include("modules/Elezioni/ele.php");
|
|---|
| 32 | if (isset($_GET['descr_comu'])) get_magic_quotes_gpc() ? $descr_comu=$param['descr_comu']:$descr_comu=addslashes($param['descr_comu']); else $descr_comu='';
|
|---|
| 33 | if (isset($_GET['do'])) get_magic_quotes_gpc() ? $do=$param['do']:$do=addslashes($param['do']); else $do='';
|
|---|
| 34 | if (isset($_GET['ok'])) $ok=intval($_GET['ok']); else $ok='';
|
|---|
| 35 | if (isset($_GET['id_cons_comu'])) $id_cons_comu=intval($_GET['id_cons_comu']); else $id_cons_comu='';
|
|---|
| 36 | if (isset($_GET['id_collegio'])) $id_collegio=intval($_GET['id_collegio']); else $id_collegio='';
|
|---|
| 37 | if (isset($_GET['idcomune'])) $idcomune=intval($_GET['idcomune']); else $idcomune='';
|
|---|
| 38 | if (isset($_GET['idcomunenew'])) $idcomunenew=intval($_GET['idcomunenew']); else $idcomunenew='';
|
|---|
| 39 | if (isset($_GET['chiusa'])) $chiusa=intval($_GET['chiusa']); else $chiusa='';
|
|---|
| 40 | if (isset($_GET['id_conf'])) $id_conf=intval($_GET['id_conf']); else $id_conf=0;
|
|---|
| 41 | if (isset($_GET['min'])) $min=intval($_GET['min']); else $min=0;
|
|---|
| [86] | 42 | if (isset($_GET['help'])) $help=intval($_GET['help']);
|
|---|
| 43 | if (isset($_GET['pwd4'])) $pwd4=intval($_GET['pwd4']);
|
|---|
| [2] | 44 |
|
|---|
| 45 | $offset=15;
|
|---|
| 46 | $hiddenInfo = "<input type=\"hidden\" name=\"min\" value=\"$min\">";
|
|---|
| 47 |
|
|---|
| 48 |
|
|---|
| 49 | /******************************************************/
|
|---|
| 50 | /*Funzione di visualizzazione globale */
|
|---|
| 51 | /*****************************************************/
|
|---|
| [77] | 52 | //
|
|---|
| [2] | 53 | function all() {
|
|---|
| [45] | 54 | global $user, $admin, $bgcolor1, $bgcolor2, $prefix,$descr_cons, $dbi,$id_cons,$desc,$indirizzo,$centralino,$fax,$id_cons_gen,$id_collegio,$idcomune,$chiusa,$id_conf,$tipo_cons,$language,$help;
|
|---|
| [2] | 55 | $aid=$_SESSION['aid'];
|
|---|
| 56 | $dbi=$_SESSION['dbi'];
|
|---|
| [86] | 57 | $prefix=$_SESSION['prefix'];
|
|---|
| 58 | ############# Controllo flag per cancellazione consultazione
|
|---|
| [87] | 59 | echo "<SCRIPT type=\"text/javascript\">\n\n<!--\n"
|
|---|
| 60 | ."//-->\n";
|
|---|
| 61 | echo "function del_cons() {\n";
|
|---|
| 62 | echo "if (document.getElementById('pwd3').checked==false) {\n";
|
|---|
| 63 | echo "if (document.getElementById('chiusa').selectedIndex==3) document.getElementById('chiusa').options[0].selected=true \n";
|
|---|
| 64 | echo "document.getElementById('pwd4').checked=false \n";
|
|---|
| 65 | echo "document.getElementById('trspunta').style.visibility='hidden' \n";
|
|---|
| 66 | echo "} \n";
|
|---|
| 67 | echo "else document.getElementById('trspunta').style.visibility='visible' \n";
|
|---|
| 68 | # echo "if (document.getElementById('chiusa').options[3].selected==false) { \n";
|
|---|
| 69 | echo "if (document.getElementById('chiusa').selectedIndex!=3) { \n";
|
|---|
| 70 | echo "document.getElementById('add').value=\""._MODIFY."\" \n";
|
|---|
| 71 | echo "document.getElementById('do').value=\"update\" \n";
|
|---|
| 72 | echo "}else{\n";
|
|---|
| 73 | echo "if (document.getElementById('pwd4').checked==false) \n";
|
|---|
| 74 | echo "document.getElementById('add').value=\""._DELETE." "._DATI."\" \n";
|
|---|
| 75 | echo "else document.getElementById('add').value=\""._DELETE." "._CONSULTA."\" \n";
|
|---|
| 76 | echo "document.getElementById('do').value=\"delete\" \n";
|
|---|
| 77 | echo "} \n";
|
|---|
| 78 | echo "} \n";
|
|---|
| 79 | echo "</script>\n";
|
|---|
| 80 |
|
|---|
| 81 |
|
|---|
| [77] | 82 | #########################
|
|---|
| [86] | 83 | if (isset($help)) include("language/$language/ele_associazioni.html");
|
|---|
| 84 | OpenTable();
|
|---|
| [77] | 85 | echo "<tr><td><hr><br>";
|
|---|
| [2] | 86 | $res = mysql_query("SELECT descrizione FROM ".$prefix."_ele_consultazione where id_cons_gen='$id_cons_gen'" , $dbi);
|
|---|
| 87 | list ($descr_cons) = mysql_fetch_row($res);
|
|---|
| 88 | //inserire avviso su mancanza dei permessi
|
|---|
| 89 | echo "<form name=\"model\" action=\"admin.php\">";
|
|---|
| [77] | 90 | echo "<table width=\"100%\" border=\"3\">";
|
|---|
| [2] | 91 | echo "<tr align=\"center\"><td bgcolor=\"$bgcolor1\"><b>"._CONSULTA."</b></td>";
|
|---|
| 92 | # echo "<td bgcolor=\"$bgcolor1\"><b>"._COLLEGI."</b></td>";
|
|---|
| 93 | echo "<td bgcolor=\"$bgcolor1\"><b>"._DEFCOMUNE."</b></td>";
|
|---|
| [77] | 94 | echo "<td bgcolor=\"$bgcolor1\"><b>"._STATO."</b></td><td bgcolor=\"$bgcolor1\">";
|
|---|
| [2] | 95 | if($tipo_cons==3)
|
|---|
| [77] | 96 | echo "<b>"._CONF."</b>";
|
|---|
| [2] | 97 | echo "<input type=\"hidden\" name=\"op\" value=\"associazioni\">";
|
|---|
| [77] | 98 | # echo "<input type=\"hidden\" name=\"pag_cons\" value=\"admin.php?op=associazioni&id_cons_gen=\">";
|
|---|
| 99 | echo "</td></tr>";
|
|---|
| 100 | echo "<tr align=\"center\"><td>";
|
|---|
| 101 | echo "<input type=\"hidden\" name=\"id_cons_gen\" value=\"$id_cons_gen\">$descr_cons</td>";
|
|---|
| [2] | 102 | # $ressede = mysql_query("SELECT id_collegio, descrizione from ".$prefix."_ele_collegi where id_cons_gen='$id_cons_gen' order by descrizione desc", $dbi);
|
|---|
| 103 | # if ($num_coll=mysql_num_rows($ressede)){
|
|---|
| 104 | # echo "<td><select name=\"id_collegio\">";
|
|---|
| 105 | # while(list($id,$descr_coll)=mysql_fetch_row($ressede)){
|
|---|
| 106 | # $sel= ($id == $id_collegio) ? "selected":"";
|
|---|
| 107 | # echo "<option value=\"$id\" $sel>$descr_coll";
|
|---|
| 108 | # }
|
|---|
| 109 | # echo "</select></td>";
|
|---|
| 110 | # } else echo "<td></td>";
|
|---|
| [86] | 111 | $rescomu = mysql_query("SELECT id_comune, descrizione from ".$prefix."_ele_comuni order by descrizione asc", $dbi);
|
|---|
| 112 | echo "<td>";
|
|---|
| 113 | if($idcomune) {
|
|---|
| 114 | while ($listele=mysql_fetch_array($rescomu))
|
|---|
| 115 | if($listele['id_comune']==$idcomune) {
|
|---|
| 116 | echo $listele['descrizione'];
|
|---|
| 117 | echo "<input type=\"hidden\" name=\"idcomunenew\" value=\"$idcomune\">";
|
|---|
| 118 | }
|
|---|
| 119 |
|
|---|
| 120 | }else{
|
|---|
| [77] | 121 | echo "<select name=\"idcomunenew\">";
|
|---|
| [2] | 122 | echo "<option value=\"0\"> ";
|
|---|
| 123 | while(list($id,$descr_comu)=mysql_fetch_row($rescomu)){
|
|---|
| 124 | $sel= ($id == $idcomune) ? "selected":"";
|
|---|
| 125 | echo "<option value=\"$id\" $sel>$descr_comu";
|
|---|
| 126 | }
|
|---|
| [86] | 127 | echo "</select>";
|
|---|
| 128 | }
|
|---|
| [77] | 129 | echo "</td>";
|
|---|
| [2] | 130 | $selez['0']='';
|
|---|
| 131 | $selez['1']='';
|
|---|
| [86] | 132 | $selez['2']='';
|
|---|
| [77] | 133 | $selez['3']='';
|
|---|
| [2] | 134 | $selez[$chiusa]="selected";
|
|---|
| [87] | 135 | echo "<td><select name=\"chiusa\" id=\"chiusa\" onChange=\"javascript:del_cons()\">";
|
|---|
| [2] | 136 | echo "<option value=\"0\" ".$selez[0].">"._ATTIVA;
|
|---|
| 137 | echo "<option value=\"1\" ".$selez[1].">"._CHIUSA;
|
|---|
| 138 | echo "<option value=\"2\" ".$selez[2].">"._NULLA;
|
|---|
| [86] | 139 |
|
|---|
| [77] | 140 | if($idcomune) echo "<option value=\"3\" ".$selez[3].">"._ELIMINA;
|
|---|
| [2] | 141 | echo "</select></td>";
|
|---|
| 142 | if($tipo_cons==3){
|
|---|
| 143 | $rescomu = mysql_query("SELECT id_conf, descrizione from ".$prefix."_ele_conf order by descrizione asc", $dbi);
|
|---|
| 144 | echo "<td><select name=\"id_conf\">";
|
|---|
| 145 | echo "<option value=\"0\"> ";
|
|---|
| 146 | while(list($id,$descr_conf)=mysql_fetch_row($rescomu)){
|
|---|
| 147 | $sel='';
|
|---|
| 148 | if ($idcomune and $id == $id_conf) $sel="selected"; elseif ($id==1) $sel="selected";
|
|---|
| 149 | echo "<option value=\"$id\" $sel>$descr_conf";
|
|---|
| 150 | }
|
|---|
| 151 | echo "</select></td>";
|
|---|
| 152 | }
|
|---|
| 153 | unset($sel);
|
|---|
| [77] | 154 | echo "<td><input type=\"hidden\" name=\"ok\" value=0>";
|
|---|
| [2] | 155 | echo "<input type=\"hidden\" name=\"id_cons_gen\" value=\"$id_cons_gen\">";
|
|---|
| 156 | if ($idcomune) {
|
|---|
| [87] | 157 | echo "<input type=\"hidden\" id=\"do\" name=\"do\" value=\"update\">";
|
|---|
| [2] | 158 | echo "<input type=\"hidden\" name=\"idcomune\" value=\"$idcomune\">";
|
|---|
| [87] | 159 | echo "<input type=\"submit\" id=\"add\" name=\"add\" value=\""._MODIFY."\" ></td></tr>";
|
|---|
| 160 | echo "<tr><td colspan=\"4\"><fieldset><legend>"._SPUNTALABEL1."</legend><label id=\"prov1\">"._SPUNTAELIMINA." <input type=\"checkbox\" id=\"pwd3\" name=\"pwd3\" value=\"\" onclick=\"javascript:del_cons()\"></label></fieldset></td></tr>";
|
|---|
| 161 | # <div id=\"trspunta\" style=\"visibility:hidden\"> </div>
|
|---|
| 162 | echo "<tr id=\"trspunta\" style=\"visibility:hidden\"><td colspan=\"4\"><fieldset><legend>"._SPUNTALABEL2."</legend><label id=\"prov\">"._VIASPUNTAELIMINA." <input type=\"checkbox\" id=\"pwd4\" name=\"pwd4\" value=\"1\" onclick=\"javascript:del_cons()\"></label></fieldset>";
|
|---|
| [2] | 163 | }else{
|
|---|
| 164 | echo "<input type=\"hidden\" name=\"do\" value=\"add\">";
|
|---|
| [77] | 165 | echo "<input type=\"submit\" name=\"add\" value=\""._ADD."\">";
|
|---|
| [2] | 166 | }
|
|---|
| [86] | 167 | $i=0;
|
|---|
| [77] | 168 | echo "</td></tr></table></form>";
|
|---|
| [86] | 169 | ############
|
|---|
| [77] | 170 | echo "<hr><br><table width=\"100%\" border=\"3\">";
|
|---|
| 171 | echo "<tr align=\"center\"><td width=\"25%\" bgcolor=\"$bgcolor1\"><b>"._CONSULTA."</b></td>";
|
|---|
| 172 | # echo "<td bgcolor=\"$bgcolor1\"><b>"._COLLEGI."</b></td>";
|
|---|
| 173 | echo "<td width=\"25%\" bgcolor=\"$bgcolor1\"><b>"._DEFCOMUNE."</b></td>";
|
|---|
| 174 | echo "<td width=\"15%\" bgcolor=\"$bgcolor1\"><b>"._STATO."</b></td>";
|
|---|
| 175 | if($tipo_cons==3)
|
|---|
| [86] | 176 | echo "<td bgcolor=\"$bgcolor1\"><b>"._CONF."</b></td>";
|
|---|
| [77] | 177 | echo "<td></td></tr>";
|
|---|
| [86] | 178 | ###############
|
|---|
| 179 |
|
|---|
| [2] | 180 | # if ($num_coll>0)
|
|---|
| 181 | # $resmod = mysql_query("SELECT t1.id_collegio,t1.id_comune,t2.descrizione as descr,t1.id_cons, t3.descrizione, t4.chiusa,t4.id_conf FROM ".$prefix."_ele_comu_collegi as t1, ".$prefix."_ele_collegi as t2, ".$prefix."_ele_comuni as t3, ".$prefix."_ele_cons_comune as t4 where t1.id_cons_gen='$id_cons_gen' and t1.id_collegio=t2.id_collegio and t1.id_comune=t3.id_comune and t1.id_comune=t4.id_comune and t2.id_cons_gen=t4.id_cons_gen order by t2.descrizione, t3.descrizione", $dbi);
|
|---|
| 182 | # else
|
|---|
| 183 | $resmod = mysql_query("SELECT '',t1.id_comune,'',t1.id_cons, t2.descrizione, t1.chiusa, t1.id_conf FROM ".$prefix."_ele_cons_comune as t1, ".$prefix."_ele_comuni as t2 where t1.id_cons_gen='$id_cons_gen' and t1.id_comune=t2.id_comune order by t2.descrizione", $dbi);
|
|---|
| 184 | while (list($id_collegio,$id_comune2,$descr_coll,$id_cons_comu,$descr_comu, $chiusa,$id_conf) = mysql_fetch_row($resmod)){ //elenco dei modelli inseriti
|
|---|
| 185 | $resconf = mysql_query("SELECT descrizione FROM ".$prefix."_ele_conf where id_conf='$id_conf'", $dbi);
|
|---|
| 186 | list($descr_conf) = mysql_fetch_row($resconf);
|
|---|
| 187 | $i++;
|
|---|
| [86] | 188 | $bgcolor1=($bgcolor1==$_SESSION['bgcolor1'])?$_SESSION['bgcolor2']:$_SESSION['bgcolor1'];
|
|---|
| [77] | 189 | echo "<tr><td colspan=\"5\">";
|
|---|
| [2] | 190 | echo "<form name=\"modello$i\" action=\"admin.php\">"
|
|---|
| 191 | ."<input type=\"hidden\" name=\"op\" value=\"associazioni\">";
|
|---|
| 192 | // echo "<input type=\"hidden\" name=\"do\" value=\"update\">";
|
|---|
| [77] | 193 | # echo "<input type=\"hidden\" name=\"id_collegio\" value=\"$id_collegio\">";
|
|---|
| [2] | 194 | echo "<input type=\"hidden\" name=\"idcomune\" value=\"$id_comune2\">";
|
|---|
| 195 | echo "<input type=\"hidden\" name=\"id_cons_comu\" value=\"$id_cons_comu\">";
|
|---|
| 196 | echo "<input type=\"hidden\" name=\"id_cons_gen\" value=\"$id_cons_gen\">";
|
|---|
| 197 | echo "<input type=\"hidden\" name=\"desc\" value=\"$descr_cons\">";
|
|---|
| 198 | echo "<input type=\"hidden\" name=\"chiusa\" value=\"$chiusa\">";
|
|---|
| [77] | 199 | echo "<table width=\"100%\"><tr align=\"center\" bgcolor=\"$bgcolor1\">";
|
|---|
| 200 | echo "<td width=\"25%\"><b>$descr_coll</b></td>";
|
|---|
| 201 | echo "<td width=\"25%\"><b>$descr_comu</b></td>";
|
|---|
| [2] | 202 | $stato['0']=_ATTIVA;
|
|---|
| 203 | $stato['1']=_CHIUSA;
|
|---|
| 204 | $stato['2']=_NULLA;
|
|---|
| [77] | 205 | echo "<td width=\"15%\"><b>".$stato[$chiusa]."</b></td>";
|
|---|
| [2] | 206 | if($tipo_cons==3)
|
|---|
| [77] | 207 | echo "<td width=\"25%\"><input type=\"hidden\" name=\"id_conf\" value=\"$id_conf\"><b>".$descr_conf."</b></td>";
|
|---|
| 208 | echo "<td width=\"10\"><input type=\"hidden\" name=\"ok\" value=0><input type=\"submit\" name=\"edit$i\" value=\""._EDIT."\">"
|
|---|
| 209 | ."</td></tr></table></form></td></tr>\n";
|
|---|
| [2] | 210 | }
|
|---|
| [77] | 211 | echo "</table></td></tr>";
|
|---|
| 212 | echo "</table></td></tr>";
|
|---|
| [86] | 213 | CloseTable();
|
|---|
| [87] | 214 | # echo "</div>";
|
|---|
| [2] | 215 | }
|
|---|
| 216 |
|
|---|
| 217 | function associazioni($ok, $do,$descr_comu,$id_cons_comu,$id_collegio,$id_comune,$chiusa,$id_conf) {
|
|---|
| [86] | 218 | global $admin, $bgcolor1, $bgcolor2, $prefix, $dbi, $descr_cons,$genere,$id_cons_gen,$idcomunenew,$pwd4;
|
|---|
| 219 | $delcons=0;
|
|---|
| [2] | 220 | if ($do !="" and $id_cons_gen>0 and $idcomunenew>0) {
|
|---|
| [77] | 221 | $rescomu = mysql_query("SELECT id_cons from ".$prefix."_ele_cons_comune where id_cons_gen='$id_cons_gen' and id_comune='$idcomunenew'", $dbi);
|
|---|
| [2] | 222 | $max = mysql_num_rows($rescomu); //esiste autorizzazione?
|
|---|
| [86] | 223 | list($delcons)=mysql_fetch_row($rescomu);
|
|---|
| [77] | 224 | if (!$max){ //se no la inserisce
|
|---|
| [2] | 225 | $result = mysql_query("insert into ".$prefix."_ele_cons_comune (chiusa,id_comune,id_cons_gen,id_conf) values ('0','$idcomunenew','$id_cons_gen','$id_conf')", $dbi) || die("<br><br>Errore di inserimento: ".mysql_error());
|
|---|
| 226 | $rescomu = mysql_query("SELECT id_cons from ".$prefix."_ele_cons_comune where id_cons_gen='$id_cons_gen' and id_comune='$idcomunenew'", $dbi);
|
|---|
| [95] | 227 | list($id_cons_comu)=mysql_fetch_row($rescomu);
|
|---|
| 228 | $res = mysql_query("SELECT id_cons FROM ".$prefix."_ele_comuni where id_comune='$idcomunenew' ", $dbi);
|
|---|
| 229 | list($id_cons_pred)=mysql_fetch_row($res);
|
|---|
| 230 | if (!$id_cons_pred)
|
|---|
| 231 | $res = mysql_query("update ".$prefix."_ele_comuni set id_cons='$id_cons_comu' where id_comune='$idcomunenew' ", $dbi);
|
|---|
| 232 |
|
|---|
| [2] | 233 | }
|
|---|
| 234 | if ($do == "update") {
|
|---|
| 235 | if ($idcomunenew>0) $newid=", id_comune = $idcomunenew ";
|
|---|
| 236 | else $newid='';
|
|---|
| 237 | $result = mysql_query("update ".$prefix."_ele_comu_collegi set id_collegio= '$id_collegio' $newid where id_comune='$id_comune' and id_cons_gen='$id_cons_gen'", $dbi) || die(mysql_error());
|
|---|
| 238 | if (!$result) return;
|
|---|
| 239 | $result = mysql_query("update ".$prefix."_ele_cons_comune set id_conf='$id_conf', chiusa= '$chiusa' where id_comune='$id_comune' and id_cons_gen='$id_cons_gen'", $dbi)|| die(mysql_error());
|
|---|
| 240 | Header("Location: admin.php?op=associazioni&id_cons_gen=$id_cons_gen");
|
|---|
| 241 | }elseif ($do == "add") {
|
|---|
| [95] | 242 | if ($id_collegio){
|
|---|
| [2] | 243 | $result = mysql_query("insert into ".$prefix."_ele_comu_collegi (id_collegio,id_cons,id_comune,id_cons_gen) values ('$id_collegio','$id_cons_comu','$idcomunenew','$id_cons_gen')", $dbi) || die("<br><br>Errore di inserimento: ".mysql_error());
|
|---|
| [95] | 244 | }
|
|---|
| [2] | 245 | Header("Location: admin.php?op=associazioni&id_cons_gen=$id_cons_gen");
|
|---|
| [86] | 246 | }elseif ($do == "delete" and $delcons>0) {
|
|---|
| [77] | 247 | $idcns=$delcons;
|
|---|
| 248 | $res_del = mysql_query("delete from ".$prefix."_ele_voti_ref where id_cons=$idcns" ,$dbi);
|
|---|
| 249 | $res_del = mysql_query("delete from ".$prefix."_ele_voti_candidati where id_cons=$idcns" ,$dbi);
|
|---|
| 250 | $res_del = mysql_query("delete from ".$prefix."_ele_voti_lista where id_cons=$idcns" ,$dbi);
|
|---|
| 251 | $res_del = mysql_query("delete from ".$prefix."_ele_voti_gruppo where id_cons=$idcns" ,$dbi);
|
|---|
| 252 | $res_del = mysql_query("delete from ".$prefix."_ele_voti_parziale where id_cons=$idcns" ,$dbi);
|
|---|
| [86] | 253 | if ($pwd4==1){
|
|---|
| [77] | 254 | $res_del = mysql_query("delete from ".$prefix."_ele_candidati where id_cons=$idcns" ,$dbi);
|
|---|
| 255 | $res_del = mysql_query("delete from ".$prefix."_ele_lista where id_cons=$idcns" ,$dbi);
|
|---|
| [86] | 256 | $res_del = mysql_query("delete from ".$prefix."_ele_gruppo where id_cons=$idcns" ,$dbi);
|
|---|
| [77] | 257 | $res_del = mysql_query("delete from ".$prefix."_ele_sezioni where id_cons=$idcns" ,$dbi);
|
|---|
| 258 | $res_del = mysql_query("delete from ".$prefix."_ele_cons_comune where id_cons=$idcns" ,$dbi);
|
|---|
| [95] | 259 | $res = mysql_query("SELECT id_cons FROM ".$prefix."_ele_comuni where id_comune='$id_comune' ", $dbi);
|
|---|
| 260 | list($id_cons_pred)=mysql_fetch_row($res);
|
|---|
| 261 | if ($idcns==$id_cons_pred) {
|
|---|
| 262 | $res = mysql_query("select id_cons from ".$prefix."_ele_cons_comune where id_comune=$id_comune order by id_cons desc limit 0,1" ,$dbi);
|
|---|
| 263 | list($id_cons_pred)=mysql_fetch_row($res);
|
|---|
| 264 | $res = mysql_query("update ".$prefix."_ele_comuni set id_cons='$id_cons_pred' where id_comune='$id_comune' ", $dbi);
|
|---|
| 265 | }
|
|---|
| [86] | 266 | }else{
|
|---|
| 267 | $res_del = mysql_query("update ".$prefix."_ele_sezioni set validi='0', nulli='0', bianchi='0', contestati='0', solo_gruppo='0', autorizzati_m='0', autorizzati_f='0', voti_nulli='0', validi_lista='0', contestati_lista='0', voti_nulli_lista='0' where id_cons=$idcns" ,$dbi);
|
|---|
| [77] | 268 |
|
|---|
| [86] | 269 | }
|
|---|
| [77] | 270 | Header("Location: admin.php?op=associazioni&id_cons_gen=$id_cons_gen");
|
|---|
| [2] | 271 | }
|
|---|
| 272 | }
|
|---|
| 273 | }
|
|---|
| 274 |
|
|---|
| [86] | 275 |
|
|---|
| 276 |
|
|---|
| 277 |
|
|---|
| [77] | 278 | # die ("do:$do - id_cons:$id_cons_comu - idcomune:$id_comune - new: $idcomunenew");
|
|---|
| [2] | 279 |
|
|---|
| 280 | //****************************
|
|---|
| 281 | // switch
|
|---|
| 282 | //****************************
|
|---|
| 283 | if ($op=="associazioni"){
|
|---|
| 284 | associazioni($ok, $do,$descr_comu,$id_cons_comu,$id_collegio,$idcomune,$chiusa,$id_conf);
|
|---|
| 285 | }
|
|---|
| 286 | ele();
|
|---|
| 287 | if (isset($_GET['id_cons_gen'])) $id_cons_gen=intval($_GET['id_cons_gen']); else $id_cons_gen='0';
|
|---|
| 288 | all();
|
|---|
| 289 | include("footer.php");
|
|---|
| 290 |
|
|---|
| 291 | ?>
|
|---|
| 292 |
|
|---|
| [87] | 293 |
|
|---|
