prepare("$sql");
$res->execute();
list($tipo_cons) = $res->fetch(PDO::FETCH_NUM);
$hiddenInfo = "";
/******************************************************/
/*Funzione di visualizzazione globale */
/******************************************************/
//crea la pagina delle affluenze
function all() {
global $bgcolor1, $bgcolor2, $prefix,$aid2,$perms,$id_sede,$id_comune2,$id_cons_gen;
$aid=$_SESSION['aid'];
$dbi=$_SESSION['dbi'];
$prefix=$_SESSION['prefix'];
OpenTable();
$sql="SELECT id_comune,permessi FROM ".$prefix."_ele_operatori where id_cons='0' and aid='$aid' and id_comune='0'";
$resmod = $dbi->prepare("$sql");
$resmod->execute();
list ($id_comu,$permessi) = $resmod->fetch(PDO::FETCH_NUM);
if ($perms!=256)
{
Closetable();
return;
}
$sql="SELECT * FROM ".$prefix."_ele_operatori where id_cons=0 and id_comune>0";
$resmod = $dbi->prepare("$sql");
$resmod->execute();
echo "
";
echo "
"._UTENTE."
"
."
"._DEFCOMUNE."
"
."
"._PERMESSI."
";
echo "
"._FUNZIONI."
";
echo "";
}else{
echo "";
echo "
";
}
$i=1;
while (list($id_cons2,$id_sede2,$id_comune2,$perm,$utente) = $resmod->fetch(PDO::FETCH_NUM)){ //elenco dei modelli inseriti
$bgcolor1=($bgcolor1==$_SESSION['bgcolor1'])?$_SESSION['bgcolor2']:$_SESSION['bgcolor1'];
echo "";
$i++;
}
echo "
";
CloseTable();
}
function oper_admin() {
global $bgcolor1, $bgcolor2, $prefix, $dbi,$id_cons_gen;
$aid=$_SESSION['aid'];
$dbi=$_SESSION['dbi'];
$prefix=$_SESSION['prefix'];
$pwd=$_SESSION['pwd'];
$perms=ChiSei(0);
if ($perms==256) {
$aid2=$_GET['aid2'];
$do=$_GET['do'];
$id_comune2=$_GET['id_comune2'];
$permessi=$_GET['permessi'];
if ($do == "add") {
if ($aid2) {
# $result = mysql_query("select * from ".$prefix."_ele_operatori where aid='$aid2'", $dbi);
$sql="insert into ".$prefix."_ele_operatori (id_cons,id_sede,id_comune,permessi,aid) values ('0','0','$id_comune2','$permessi','$aid2')";
$res = $dbi->prepare("$sql");
$res->execute();
Header("Location: admin.php?op=oper_admin&id_cons_gen=$id_cons_gen");
} else {
OpenTable();
echo "