Changeset 258 for trunk/admin/modules/Elezioni/ele_associazioni.php

Timestamp:

Apr 4, 2019, 11:16:00 PM (5 years ago)

Author:

roby

Message:

 

File:

• trunk/admin/modules/Elezioni/ele_associazioni.php (modified) (3 diffs)

trunk/admin/modules/Elezioni/ele_associazioni.php

@@ -252 +252 @@
         echo "</td></tr></table></form>";
         echo "<hr><br><table width=\"100%\" border=\"3\">";
-        echo "<tr align=\"center\"><td width=\"15%\" bgcolor=\"$bgcolor1\"><b>"._CONSULTA."TEST:$id_cons_comu</b></td>";
+        echo "<tr align=\"center\"><td width=\"15%\" bgcolor=\"$bgcolor1\"><b>"._CONSULTA."</b></td>";
         echo "<td width=\"20%\" bgcolor=\"$bgcolor1\"><b>"._DEFCOMUNE."</b></td>";
         echo "<td width=\"10%\" bgcolor=\"$bgcolor1\"><b>"._PREFERENZE."</b></td>";
@@ -325 +325 @@
         $delcons=0;
         if ($do !="" and $id_cons_gen>0 and $idcomunenew>0) {
-                $sql="SELECT id_cons from ".$prefix."_ele_cons_comune where id_cons_gen='$id_cons_gen' and id_comune='$idcomunenew'"; 
+                $sql="SELECT id_cons from ".$prefix."_ele_cons_comune where id_cons_gen='$id_cons_gen' and id_comune='$idcomunenew'";
                 $rescomu = $dbi->prepare("$sql");
                 $rescomu->execute();    
@@ -351 +351 @@
                         if ($idcomunenew>0) $newid=", id_comune = $idcomunenew ";
                         else $newid='';
-                        $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());
-                        $result = $dbi->prepare("$sql");
-                        $result->execute();     
-                        if (!$result->rowCount()) return;
+                        $sql="update ".$prefix."_ele_comu_collegi set id_collegio= '$id_collegio' $newid where id_comune='$id_comune' and id_cons_gen='$id_cons_gen'";
+                        $result = $dbi->prepare("$sql");
+                        $result->execute();     
                         $sql="update ".$prefix."_ele_cons_comune set id_conf='$id_conf', chiusa= '$chiusa', preferenze='$preferenze',id_fascia='$idfascia',vismf='$vismf',solo_gruppo='$sg',disgiunto='$disgiunto' where id_comune='$id_comune' and id_cons_gen='$id_cons_gen'";
                         $result = $dbi->prepare("$sql");