Changeset 282 for trunk/admin/modules/Elezioni

Timestamp:

Apr 21, 2019, 9:46:30 PM (6 years ago)

Author:

roby

Message:

 

Location:

trunk/admin/modules/Elezioni

Files:

• ele_associazioni.php (modified) (4 diffs)
• query.sql (modified) (1 diff)

trunk/admin/modules/Elezioni/ele_associazioni.php

@@ -18 +18 @@
 $prefix=$_SESSION['prefix'];
 $id_comune=$_SESSION['id_comune'];
+$sql = $dbi->prepare("SELECT * FROM ".$prefix."_config");
+$sql->execute();
+$riga = $sql->fetchAll(PDO::FETCH_ASSOC);
+$row=$riga[0];
+$language = $row['language'];
 $id_cons_gen=intval($_GET['id_cons_gen']);
 $perms=ChiSei(0);
@@ -37 +42 @@
 if (isset($_GET['do'])) get_magic_quotes_gpc() ? $do=$param['do']:$do=addslashes($param['do']); else $do='';
 if (isset($_GET['ok'])) $ok=intval($_GET['ok']); else $ok='';
-if (isset($_GET['id_cons_comu'])) $id_cons_comu=intval($_GET['id_cons_comu']); else $id_cons_comu='';
-if (isset($_GET['id_collegio'])) $id_collegio=intval($_GET['id_collegio']); else $id_collegio='';
+if (isset($_GET['id_cons_comu'])) $id_cons_comu=intval($_GET['id_cons_comu']); else $id_cons_comu='0';
+if (isset($_GET['id_collegio'])) $id_collegio=intval($_GET['id_collegio']); else $id_collegio='0';
 if (isset($_GET['idcomune'])) $idcomune=intval($_GET['idcomune']); else $idcomune='';
-if (isset($_GET['idcomunenew'])) $idcomunenew=intval($_GET['idcomunenew']); else $idcomunenew='';
-if (isset($_GET['chiusa'])) $chiusa=intval($_GET['chiusa']); else $chiusa='';
+if (isset($_GET['idcomunenew'])) $idcomunenew=intval($_GET['idcomunenew']); else $idcomunenew='0';
+if (isset($_GET['chiusa'])) $chiusa=intval($_GET['chiusa']); else $chiusa='0';
 if (isset($_GET['id_conf'])) $id_conf=intval($_GET['id_conf']);  else $id_conf=0;
 if (isset($_GET['idfascia'])) $idfascia=intval($_GET['idfascia']);  else $idfascia=0;
 if (isset($_GET['min'])) $min=intval($_GET['min']); else $min=0;
-if (isset($_GET['help'])) $help=intval($_GET['help']);
-if (isset($_GET['pwd4'])) $pwd4=intval($_GET['pwd4']);
+if (isset($_GET['help'])) $help=intval($_GET['help']); else $help='';
+if (isset($_GET['pwd4'])) $pwd4=intval($_GET['pwd4']); else $pwd4='';
 if (isset($_GET['preferenze'])) $preferenze=intval($_GET['preferenze']); else $preferenze=1;
 if (isset($_GET['vismf'])) $vismf=intval($_GET['vismf']); else $vismf=0;
@@ -117 +122 @@
 
 #########################
-        if (isset($help)) include("language/$language/ele_associazioni.html");
+        if ($help) include("language/$language/ele_associazioni.html");
         OpenTable();
         echo "<tr><td><hr><br>";        
@@ -214 +219 @@
         }
         unset($sel);
-        $sql = "SELECT vismf,vismf,solo_gruppo,disgiunto from ".$prefix."_ele_cons_comune where id_cons='$id_cons_comu'";
+        $sql = "SELECT vismf,solo_gruppo,disgiunto from ".$prefix."_ele_cons_comune where id_cons='$id_cons_comu'";
         $rescomu = $dbi->prepare("$sql");
         $rescomu->execute();    

trunk/admin/modules/Elezioni/query.sql

@@ -87 +87 @@
         $sth->execute();        
         if ($sth->rowCount()){
-                $row2 = $sth->fetchAll();
-                $limite=$row2[0];
-        }
+                $limite = $sth->fetch(PDO::FETCH_NUM); 
+        } else $limite=0;
         return($row);
 }