Changeset 282 for trunk/admin


Ignore:
Timestamp:
Apr 21, 2019, 9:46:30 PM (6 years ago)
Author:
roby
Message:
 
Location:
trunk/admin/modules/Elezioni
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • trunk/admin/modules/Elezioni/ele_associazioni.php

    r258 r282  
    1818$prefix=$_SESSION['prefix'];
    1919$id_comune=$_SESSION['id_comune'];
     20$sql = $dbi->prepare("SELECT * FROM ".$prefix."_config");
     21$sql->execute();
     22$riga = $sql->fetchAll(PDO::FETCH_ASSOC);
     23$row=$riga[0];
     24$language = $row['language'];
    2025$id_cons_gen=intval($_GET['id_cons_gen']);
    2126$perms=ChiSei(0);
     
    3742if (isset($_GET['do'])) get_magic_quotes_gpc() ? $do=$param['do']:$do=addslashes($param['do']); else $do='';
    3843if (isset($_GET['ok'])) $ok=intval($_GET['ok']); else $ok='';
    39 if (isset($_GET['id_cons_comu'])) $id_cons_comu=intval($_GET['id_cons_comu']); else $id_cons_comu='';
    40 if (isset($_GET['id_collegio'])) $id_collegio=intval($_GET['id_collegio']); else $id_collegio='';
     44if (isset($_GET['id_cons_comu'])) $id_cons_comu=intval($_GET['id_cons_comu']); else $id_cons_comu='0';
     45if (isset($_GET['id_collegio'])) $id_collegio=intval($_GET['id_collegio']); else $id_collegio='0';
    4146if (isset($_GET['idcomune'])) $idcomune=intval($_GET['idcomune']); else $idcomune='';
    42 if (isset($_GET['idcomunenew'])) $idcomunenew=intval($_GET['idcomunenew']); else $idcomunenew='';
    43 if (isset($_GET['chiusa'])) $chiusa=intval($_GET['chiusa']); else $chiusa='';
     47if (isset($_GET['idcomunenew'])) $idcomunenew=intval($_GET['idcomunenew']); else $idcomunenew='0';
     48if (isset($_GET['chiusa'])) $chiusa=intval($_GET['chiusa']); else $chiusa='0';
    4449if (isset($_GET['id_conf'])) $id_conf=intval($_GET['id_conf']);  else $id_conf=0;
    4550if (isset($_GET['idfascia'])) $idfascia=intval($_GET['idfascia']);  else $idfascia=0;
    4651if (isset($_GET['min'])) $min=intval($_GET['min']); else $min=0;
    47 if (isset($_GET['help'])) $help=intval($_GET['help']);
    48 if (isset($_GET['pwd4'])) $pwd4=intval($_GET['pwd4']);
     52if (isset($_GET['help'])) $help=intval($_GET['help']); else $help='';
     53if (isset($_GET['pwd4'])) $pwd4=intval($_GET['pwd4']); else $pwd4='';
    4954if (isset($_GET['preferenze'])) $preferenze=intval($_GET['preferenze']); else $preferenze=1;
    5055if (isset($_GET['vismf'])) $vismf=intval($_GET['vismf']); else $vismf=0;
     
    117122
    118123#########################
    119         if (isset($help)) include("language/$language/ele_associazioni.html");
     124        if ($help) include("language/$language/ele_associazioni.html");
    120125        OpenTable();
    121126        echo "<tr><td><hr><br>";       
     
    214219        }
    215220        unset($sel);
    216         $sql = "SELECT vismf,vismf,solo_gruppo,disgiunto from ".$prefix."_ele_cons_comune where id_cons='$id_cons_comu'";
     221        $sql = "SELECT vismf,solo_gruppo,disgiunto from ".$prefix."_ele_cons_comune where id_cons='$id_cons_comu'";
    217222        $rescomu = $dbi->prepare("$sql");
    218223        $rescomu->execute();   
  • trunk/admin/modules/Elezioni/query.sql

    r257 r282  
    8787        $sth->execute();       
    8888        if ($sth->rowCount()){
    89                 $row2 = $sth->fetchAll();
    90                 $limite=$row2[0];
    91         }
     89                $limite = $sth->fetch(PDO::FETCH_NUM);
     90        } else $limite=0;
    9291        return($row);
    9392}
Note: See TracChangeset for help on using the changeset viewer.