| 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 | /* Admin */
|
|---|
| 10 | /* Amministrazione */
|
|---|
| 11 | /************************************************************************/
|
|---|
| 12 |
|
|---|
| 13 | /* Descrizione file admin.php =
|
|---|
| 14 | effettua il login o il rilancio alla gestione */
|
|---|
| 15 |
|
|---|
| 16 | define('ADMIN_FILE', true);
|
|---|
| 17 | #$LIMITE=3; //fascia di separazione del maggioritario (15.000 abitanti)
|
|---|
| 18 | # tempo di sessione: ini_set('session.gc_maxlifetime','3600');
|
|---|
| 19 | global $multicomune,$msglogout,$language,$id_sez;
|
|---|
| 20 |
|
|---|
| 21 | // Adattamento variabili superglobal
|
|---|
| 22 | // Versione di php
|
|---|
| 23 | $phpver = phpversion();
|
|---|
| 24 | global $dbi;
|
|---|
| 25 | // converte superglobal se php e' < 4.1.0
|
|---|
| 26 |
|
|---|
| 27 | if ($phpver < '4.1.0') {
|
|---|
| 28 | $_GET = $HTTP_GET_VARS;
|
|---|
| 29 | $_POST = $HTTP_POST_VARS;
|
|---|
| 30 | $_SERVER = $HTTP_SERVER_VARS;
|
|---|
| 31 | $_FILES = $HTTP_POST_FILES;
|
|---|
| 32 | $_ENV = $HTTP_ENV_VARS;
|
|---|
| 33 | if($_SERVER['REQUEST_METHOD'] == "POST") {
|
|---|
| 34 | $_REQUEST = $_POST;
|
|---|
| 35 | } elseif($_SERVER['REQUEST_METHOD'] == "GET") {
|
|---|
| 36 | $_REQUEST = $_GET;
|
|---|
| 37 | }
|
|---|
| 38 | if(isset($HTTP_COOKIE_VARS)) {
|
|---|
| 39 | $_COOKIE = $HTTP_COOKIE_VARS;
|
|---|
| 40 | }
|
|---|
| 41 | if(isset($HTTP_SESSION_VARS)) {
|
|---|
| 42 | $_SESSION = $HTTP_SESSION_VARS;
|
|---|
| 43 | }
|
|---|
| 44 | }
|
|---|
| 45 |
|
|---|
| 46 | $param=strtolower($_SERVER['REQUEST_METHOD']) == 'get' ? $_GET : $_POST;
|
|---|
| 47 | if (isset($param['aid'])) $aid=addslashes($param['aid']); else $aid='';
|
|---|
| 48 | if (isset($param['pwd'])) $pwd2=addslashes($param['pwd']); else $pwd2='';
|
|---|
| 49 | if(isset($param['msglogout'])) $msglogout=intval($param['msglogout']); else $msglogout=0;
|
|---|
| 50 |
|
|---|
| 51 | // Additional security (Union, CLike, XSS)
|
|---|
| 52 |
|
|---|
| 53 | // We want to use the function stripos,
|
|---|
| 54 | // but thats only available since PHP5.
|
|---|
| 55 | // So we cloned the function...
|
|---|
| 56 | if(!function_exists('stripos')) {
|
|---|
| 57 | function stripos_clone($haystack, $needle, $offset=0) {
|
|---|
| 58 | return strpos(strtoupper($haystack), strtoupper($needle), $offset);
|
|---|
| 59 | }
|
|---|
| 60 | } else {
|
|---|
| 61 | // But when this is PHP5, we use the original function
|
|---|
| 62 | function stripos_clone($haystack, $needle, $offset=0) {
|
|---|
| 63 | return stripos($haystack, $needle, $offset=0);
|
|---|
| 64 | }
|
|---|
| 65 | }
|
|---|
| 66 |
|
|---|
| 67 | if(isset($_SERVER['QUERY_STRING']) && (!stripos_clone($_SERVER['QUERY_STRING'], "ad_click") || !stripos_clone($_SERVER['QUERY_STRING'], "url"))) {
|
|---|
| 68 | $queryString = $_SERVER['QUERY_STRING'];
|
|---|
| 69 | if (stripos_clone($queryString,'%20union%20') OR stripos_clone($queryString,'/*') OR stripos_clone($queryString,'*/union/*') OR stripos_clone($queryString,'c2nyaxb0') OR stripos_clone($queryString,'+union+') OR stripos_clone($queryString,'http://') OR (stripos_clone($queryString,'cmd=') AND !stripos_clone($queryString,'&cmd')) OR (stripos_clone($queryString,'exec') AND !stripos_clone($queryString,'execu')) OR stripos_clone($queryString,'concat')) {
|
|---|
| 70 | die('Operazione non consentita');
|
|---|
| 71 | }
|
|---|
| 72 | }
|
|---|
| 73 |
|
|---|
| 74 |
|
|---|
| 75 | foreach ($_GET as $sec_key => $secvalue) {
|
|---|
| 76 | if ((preg_match("/<[^>]*script*\"?[^>]*>/i",$secvalue)) ||
|
|---|
| 77 | (preg_match("/<[^>]*object*\"?[^>]*>/i", $secvalue)) ||
|
|---|
| 78 | (preg_match("/<[^>]*iframe*\"?[^>]*>/i", $secvalue)) ||
|
|---|
| 79 | (preg_match("/<[^>]*applet*\"?[^>]*>/i", $secvalue)) ||
|
|---|
| 80 | (preg_match("/<[^>]*meta*\"?[^>]*>/i", $secvalue)) ||
|
|---|
| 81 | (preg_match("/<[^>]*style*\"?[^>]*>/i", $secvalue)) ||
|
|---|
| 82 | (preg_match("/<[^>]*form*\"?[^>]*>/i", $secvalue)) ||
|
|---|
| 83 | (preg_match("/<[^>]*img*\"?[^>]*>/i", $secvalue)) ||
|
|---|
| 84 | (preg_match("/<[^>]*onmouseover*\"?[^>]*>/i", $secvalue)) ||
|
|---|
| 85 | (preg_match("/<[^>]*body*\"?[^>]*>/i", $secvalue)) ||
|
|---|
| 86 | (preg_match("/\"/", $secvalue)) ||
|
|---|
| 87 | (preg_match("/inside_mod/i", $sec_key))) {
|
|---|
| 88 | die ("Operazione non consentita");
|
|---|
| 89 | }
|
|---|
| 90 | }
|
|---|
| 91 |
|
|---|
| 92 | foreach ($_POST as $secvalue) {
|
|---|
| 93 | if ((preg_match("/<[^>]*onmouseover*\"?[^>]*>/i", $secvalue)) || (preg_match("/<[^>]script*\"?[^>]*>/i", $secvalue)) || (preg_match("/<[^>]*body*\"?[^>]*>/i", $secvalue)) || (preg_match("/<[^>]style*\"?[^>]*>/i", $secvalue))) {
|
|---|
| 94 | die ('Operazione non consentita');
|
|---|
| 95 | }
|
|---|
| 96 | }
|
|---|
| 97 |
|
|---|
| 98 | // Posting from other servers in not allowed
|
|---|
| 99 | // Fix by Quake
|
|---|
| 100 | // Bug found by PeNdEjO
|
|---|
| 101 |
|
|---|
| 102 | if ($_SERVER['REQUEST_METHOD'] == "POST") {
|
|---|
| 103 | if (isset($_SERVER['HTTP_REFERER'])) {
|
|---|
| 104 | if (!stripos_clone($_SERVER['HTTP_REFERER'], $_SERVER['HTTP_HOST'])) {
|
|---|
| 105 | die('Posting da un altro server non consentito!');
|
|---|
| 106 | }
|
|---|
| 107 | } else {
|
|---|
| 108 | # die('<b>Attenzione:</b> il tuo browser non puo inviare gli header HTTP_REFERER al website.<br>'.$_SERVER['HTTP_REFERER']);
|
|---|
| 109 | }
|
|---|
| 110 | }
|
|---|
| 111 |
|
|---|
| 112 |
|
|---|
| 113 |
|
|---|
| 114 |
|
|---|
| 115 |
|
|---|
| 116 |
|
|---|
| 117 |
|
|---|
| 118 | //===================================================================
|
|---|
| 119 | session_name('sesadmin');
|
|---|
| 120 | #session_start();//MODIFICHE PER GESTIONE SESSIONI
|
|---|
| 121 | // gestione sessione
|
|---|
| 122 | $a = session_id();
|
|---|
| 123 | if(empty($a)) session_start();
|
|---|
| 124 | #echo "SID: ".SID."<br>session_id(): ".session_id()."<br>COOKIE: ".$_COOKIE["PHPSESSID"];
|
|---|
| 125 |
|
|---|
| 126 | if (file_exists("config.php")){
|
|---|
| 127 | $install="0"; @require_once("config.php");
|
|---|
| 128 | }else{
|
|---|
| 129 | $install="1";
|
|---|
| 130 | }
|
|---|
| 131 |
|
|---|
| 132 | # verifica se effettuata la configurazione
|
|---|
| 133 | if(empty($dbname) || $install=="1") {
|
|---|
| 134 | die("<html><body><div style=\"text-align:center\"><br /><br /><img src=\"modules/Elezioni/images/logo.jpg\" alt=\"Eleonline\" title=\"Eleonline\"><br /><br /><strong>Sembra che <a href='http://www.eleonline.it' title='Eleonline'>Eleonline</a> non sia stato ancora installato.<br /><br />Puoi procedere <a href='../install/index.php'>cliccando qui</a> per iniziare l'installazione</strong></div></body></html>");
|
|---|
| 135 | }
|
|---|
| 136 |
|
|---|
| 137 | $dsn = "mysql:host=$dbhost";
|
|---|
| 138 | $opt = array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_EMULATE_PREPARES => false);
|
|---|
| 139 | if($prefix == '') {
|
|---|
| 140 | db_err ('stepBack','Non avete indicato il prefisso tabelle database.');
|
|---|
| 141 | }
|
|---|
| 142 | try
|
|---|
| 143 | {
|
|---|
| 144 | $dbi = new PDO($dsn, $dbuname, $dbpass, $opt);
|
|---|
| 145 | }
|
|---|
| 146 | catch(PDOException $e)
|
|---|
| 147 | {
|
|---|
| 148 | echo $sql . "<br>" . $e->getMessage();die();
|
|---|
| 149 | }
|
|---|
| 150 | $sql = "use $dbname";
|
|---|
| 151 | try
|
|---|
| 152 | {
|
|---|
| 153 | $dbi->exec($sql);
|
|---|
| 154 | }
|
|---|
| 155 | catch(PDOException $e)
|
|---|
| 156 | {
|
|---|
| 157 | echo $sql . "<br>" . $e->getMessage();
|
|---|
| 158 | }
|
|---|
| 159 | $sth = $dbi->prepare("SET SESSION character_set_connection = 'utf8' ");
|
|---|
| 160 | $sth->execute();
|
|---|
| 161 | $sth = $dbi->prepare("SET SESSION character_set_client = 'utf8' ");
|
|---|
| 162 | $sth->execute();
|
|---|
| 163 | $sth = $dbi->prepare("SET SESSION character_set_database = 'utf8' ");
|
|---|
| 164 | $sth->execute();
|
|---|
| 165 | $sth = $dbi->prepare("SET CHARACTER SET utf8");
|
|---|
| 166 | $sth->execute();
|
|---|
| 167 |
|
|---|
| 168 | $sth = $dbi->prepare("SET NAMES 'utf8'");
|
|---|
| 169 | $sth->execute();
|
|---|
| 170 | $sth = $dbi->prepare("select * from ".$prefix."_config");
|
|---|
| 171 | $sth->execute();
|
|---|
| 172 |
|
|---|
| 173 | # $dbi=mysql_connect($dbhost, $dbuname, $dbpass) or die("Connessione non riuscita: " . mysql_error());
|
|---|
| 174 | # mysql_select_db($dbname)or die("Connessione non riuscita:" . mysql_error());
|
|---|
| 175 | ## mysql_query("SET NAMES 'utf8'", $dbi);
|
|---|
| 176 | //---10/05/2009 gestione consultazione predefinita
|
|---|
| 177 | $sth = $dbi->prepare("select * from ".$prefix."_config");
|
|---|
| 178 | $sth->execute();
|
|---|
| 179 | $row = $sth->fetch(PDO::FETCH_ASSOC);
|
|---|
| 180 | #$row = $sth->fetchAll();
|
|---|
| 181 | $siteistat=$row['siteistat'];
|
|---|
| 182 | if (!isset($_SESSION['id_comune'])){
|
|---|
| 183 | $_SESSION['sitename']=$row['sitename'];
|
|---|
| 184 | $_SESSION['siteurl']=$row['siteurl'];
|
|---|
| 185 | $_SESSION['site_logo']=$row['site_logo'];
|
|---|
| 186 | $_SESSION['slogan']=$row['slogan'];
|
|---|
| 187 | $_SESSION['startdate']=$row['startdate'];
|
|---|
| 188 | $_SESSION['adminmail']=$row['adminmail'];
|
|---|
| 189 | # if (isset($tema) and $tema=='facebook')
|
|---|
| 190 | # $_SESSION['tema']=$row['tema'];
|
|---|
| 191 | $_SESSION['foot']=$row['foot'];
|
|---|
| 192 | $_SESSION['lang']=$row['language'];
|
|---|
| 193 | $_SESSION['blocco']=$row['blocco'];
|
|---|
| 194 | $_SESSION['testata']=$row['testata'];
|
|---|
| 195 | # $_SESSION['logo']=$row['logo'];
|
|---|
| 196 | $_SESSION['fileout']=$row['fileout'];
|
|---|
| 197 | $_SESSION['copyright']=$row['copyright'];
|
|---|
| 198 | $_SESSION['versione']=$row['versione'];
|
|---|
| 199 | $_SESSION['patch']=$row['patch'];
|
|---|
| 200 | $_SESSION['id_comune']=$row['siteistat'];
|
|---|
| 201 | $_SESSION['multicomune']=$row['multicomune'];
|
|---|
| 202 | $_SESSION['flash']=$row['flash'];
|
|---|
| 203 | $_SESSION['displayerrors']=$row['displayerrors'];
|
|---|
| 204 | $_SESSION['editor']=$row['editor'];
|
|---|
| 205 | $_SESSION['tema_on']=$row['tema_on'];
|
|---|
| 206 | $_SESSION['ed_user']=$row['ed_user'];
|
|---|
| 207 | $multicomune=$row['multicomune'];
|
|---|
| 208 | }
|
|---|
| 209 |
|
|---|
| 210 | //fine
|
|---|
| 211 | if (isset($param['tema'])) $_SESSION['tema']=$param['tema'];
|
|---|
| 212 | if (!isset($_SESSION['tema']))
|
|---|
| 213 | $_SESSION['tema']='default';
|
|---|
| 214 | $tema=$_SESSION['tema'];
|
|---|
| 215 |
|
|---|
| 216 | if (isset($param['aid'])) {
|
|---|
| 217 | if (strlen($aid)>25 ) { die ("Nome utente troppo lungo: $aid"); }
|
|---|
| 218 | if (!isset($param['id_ses']) or $param['id_ses'] != session_id()) logout();
|
|---|
| 219 | if (strstr( $aid," ")) { die ("Gli spazi non sono ammessi nel nome utente: $aid"); }
|
|---|
| 220 | if (isset($_SESSION['aid'])){
|
|---|
| 221 | logout();//se hai gia' una sessione aperta non puoi postare 'aid'
|
|---|
| 222 | }else{
|
|---|
| 223 |
|
|---|
| 224 | // $pwd2=$param['pwd'];
|
|---|
| 225 | $mpwd=md5($pwd2);
|
|---|
| 226 |
|
|---|
| 227 | // se superUserAdmin
|
|---|
| 228 | ########
|
|---|
| 229 | # $sth = $dbi->prepare("select adminsuper from ".$prefix."_authors where aid='$aid' and pwd='$mpwd'");
|
|---|
| 230 | # $sth->execute();
|
|---|
| 231 | # $row = $sth->fetch(PDO::FETCH_ASSOC);
|
|---|
| 232 | if (isset($param['id_comune']) and intval($param['id_comune'])>0) $id_comune=intval($param['id_comune']); else $id_comune=0;;
|
|---|
| 233 | # if ($adminsuper==1) $id_comune2=0; else
|
|---|
| 234 | $id_comune2=$id_comune;
|
|---|
| 235 | $sth = $dbi->prepare("select pwd,adminop,adminsuper,counter,admlanguage from ".$prefix."_authors where aid='$aid' and (id_comune='$id_comune2' or adminsuper='1')");
|
|---|
| 236 | $sth->execute();
|
|---|
| 237 | $esiste=$sth->rowCount();
|
|---|
| 238 | # $adminsuper=$row['adminsuper'];
|
|---|
| 239 | $row = $sth->fetch(PDO::FETCH_ASSOC);
|
|---|
| 240 | if(!$esiste) {
|
|---|
| 241 | $msglogout=2;
|
|---|
| 242 | logout();
|
|---|
| 243 | }else{
|
|---|
| 244 | if ($row['pwd']!=$mpwd) {
|
|---|
| 245 | $msglogout=3;
|
|---|
| 246 | logout();
|
|---|
| 247 | }elseif($row['adminop']==1) {
|
|---|
| 248 | $msglogout=1;
|
|---|
| 249 | logout();
|
|---|
| 250 | }
|
|---|
| 251 | $counter=$row['counter'];
|
|---|
| 252 | $tmplang=$row['admlanguage'];
|
|---|
| 253 | if(strlen($tmplang)==2) $language=$tmplang;
|
|---|
| 254 | $sth = $dbi->prepare("update ".$prefix."_authors set counter=$counter where aid='$aid' and pwd='$mpwd' and id_comune='$id_comune2'");
|
|---|
| 255 | $sth->execute();
|
|---|
| 256 | # $row = $sth->fetch(PDO::FETCH_ASSOC);
|
|---|
| 257 | if ($esiste==1) {
|
|---|
| 258 | # $_SESSION['dbi']=$dbi;
|
|---|
| 259 | $_SESSION['aid']="$aid";
|
|---|
| 260 | $_SESSION['pwd']="$mpwd";
|
|---|
| 261 | $_SESSION['lang']="$language";
|
|---|
| 262 | $_SESSION['id_comune']="$id_comune";
|
|---|
| 263 | $_SESSION['prefix']="soraldo";
|
|---|
| 264 | $_SESSION['remote']=$_SERVER['REMOTE_ADDR'];
|
|---|
| 265 | $_SESSION['bgcolor1']='#ffffff';
|
|---|
| 266 | $_SESSION['bgcolor2']='#c5c5c5';
|
|---|
| 267 | if (!isset($op)) $op='consultazione';
|
|---|
| 268 | session_regenerate_id();
|
|---|
| 269 | }
|
|---|
| 270 | }
|
|---|
| 271 | }
|
|---|
| 272 | }else{
|
|---|
| 273 | #$_SESSION['dbi']=$dbi;
|
|---|
| 274 |
|
|---|
| 275 | }
|
|---|
| 276 | # si settano le variabili per il controllo degli aggiornamenti
|
|---|
| 277 | if(!isset($_SESSION['localrev']) and isset($_SESSION['aid']) and ChiSei(0)==256)
|
|---|
| 278 | {
|
|---|
| 279 | $sql="SELECT COLUMN_NAME
|
|---|
| 280 | FROM INFORMATION_SCHEMA.COLUMNS
|
|---|
| 281 | WHERE TABLE_SCHEMA = '$dbname'
|
|---|
| 282 | AND TABLE_NAME = '".$prefix."_config'
|
|---|
| 283 | AND COLUMN_NAME = 'aggiornamento'";
|
|---|
| 284 | $sth = $dbi->prepare($sql);
|
|---|
| 285 | $sth->execute();
|
|---|
| 286 | if($sth->rowCount())
|
|---|
| 287 | {
|
|---|
| 288 | $sql="ALTER TABLE `soraldo_config` DROP `aggiornamento`;";
|
|---|
| 289 | $sth = $dbi->prepare($sql);
|
|---|
| 290 | $sth->execute();
|
|---|
| 291 | }
|
|---|
| 292 | /* $sth = $dbi->prepare("select aggiornamento from ".$prefix."_config");
|
|---|
| 293 | $sth->execute();
|
|---|
| 294 | list($agg)=$sth->fetch(PDO::FETCH_NUM);
|
|---|
| 295 | $_SESSION['aggiornamento']=$agg;*/
|
|---|
| 296 | ###########
|
|---|
| 297 | $righe='';
|
|---|
| 298 | if(phpversion()<5.6) $host="http://80.211.143.127";
|
|---|
| 299 | else $host="https://trac.eleonline.it";
|
|---|
| 300 | $headers=get_headers("$host/ele3/changeset/");
|
|---|
| 301 | $testurl=strlen($headers[0])>0?true:false;
|
|---|
| 302 | if(!$testurl){
|
|---|
| 303 | $newrev=0;
|
|---|
| 304 | }else{
|
|---|
| 305 | $file = file("$host/ele3/changeset/");
|
|---|
| 306 | $cntFile = count($file);
|
|---|
| 307 | $fine=0;
|
|---|
| 308 | $currentLine=0;
|
|---|
| 309 |
|
|---|
| 310 | foreach ($file as $line_num => $line) {
|
|---|
| 311 | if(strpos($line,'<title>') ) {$fine=1; continue;}
|
|---|
| 312 | if ($fine){
|
|---|
| 313 | $newrev=(int) filter_var($line, FILTER_SANITIZE_NUMBER_INT);
|
|---|
| 314 | break;
|
|---|
| 315 | }
|
|---|
| 316 | }
|
|---|
| 317 | }
|
|---|
| 318 | include('versione.php');
|
|---|
| 319 | $myrev=intval(substr($versione,-4,4));
|
|---|
| 320 | # $_SESSION['aggiornamento']=$agg;
|
|---|
| 321 | $_SESSION['localrev']=$myrev;
|
|---|
| 322 | $_SESSION['remoterev']=$newrev;
|
|---|
| 323 | unset($file);
|
|---|
| 324 | # if($agg) include('aggiornamento.php');
|
|---|
| 325 | #die("local: ".$_SESSION['localrev'].$_SESSION['remoterev']);
|
|---|
| 326 | }
|
|---|
| 327 | if(!isset($_SESSION['BASE'])) $_SESSION['BASE']=substr($_SERVER['PHP_SELF'], 0, strrpos($_SERVER['REQUEST_URI'], "/")-16);
|
|---|
| 328 | if(!isset($language)) $language=$_SESSION['lang'];
|
|---|
| 329 | if (! isset($_SESSION['lang'])) $_SESSION['lang']=$language;
|
|---|
| 330 | $currentlang=strlen($_SESSION['lang'])==2 ? $_SESSION['lang']: $language;
|
|---|
| 331 |
|
|---|
| 332 | if (isset($_SESSION['aid']))
|
|---|
| 333 | {
|
|---|
| 334 | //lettura sessione
|
|---|
| 335 | $aid=$_SESSION['aid'];
|
|---|
| 336 | #$dbi=$_SESSION['dbi'];
|
|---|
| 337 | $prefix=$_SESSION['prefix'];
|
|---|
| 338 | $id_comune=$_SESSION['id_comune'];
|
|---|
| 339 | if($id_comune==0) $rifcomune='58047'; else $rifcomune=$id_comune;
|
|---|
| 340 | if (isset($_GET['id_cons_gen'])) {$id_cons_gen=intval($_GET['id_cons_gen']);}
|
|---|
| 341 | else {
|
|---|
| 342 | $oggi=date("Y-m-d",mktime(0,0,0,date("m"),date("d")-3,date("Y")));
|
|---|
| 343 | $sql="select t1.id_cons_gen 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 and t1.data_fine>'$oggi' and t2.id_cons in (select id_cons from ".$prefix."_ele_operatori where aid='$aid' and permessi>0) limit 0,1"; # TEST: and id_sez>0
|
|---|
| 344 | $rese = $dbi->prepare("$sql");
|
|---|
| 345 | $rese->execute();
|
|---|
| 346 | if($rese->rowCount())
|
|---|
| 347 | {list($id_cons_gen)=$rese->fetch(PDO::FETCH_NUM); }
|
|---|
| 348 | else {
|
|---|
| 349 | $sql="SELECT t1.id_cons_gen FROM ".$prefix."_ele_cons_comune as t1, ".$prefix."_ele_comuni as t2 where t1.id_cons=t2.id_cons and t2.id_comune='$id_comune'";
|
|---|
| 350 | $sth = $dbi->prepare($sql);
|
|---|
| 351 | $sth->execute();
|
|---|
| 352 | $row = $sth->fetch(PDO::FETCH_BOTH);
|
|---|
| 353 | if($sth->rowCount())
|
|---|
| 354 | $id_cons_gen=$row[0];
|
|---|
| 355 | else
|
|---|
| 356 | $id_cons_gen=0; #die("TEST IN CORSO : idconsgen: $id_cons_gen -- sql:$sql");
|
|---|
| 357 | }
|
|---|
| 358 | }
|
|---|
| 359 | $currentlang=$_SESSION['lang'];
|
|---|
| 360 | #$bgcolor1=$_SESSION['bgcolor1'];
|
|---|
| 361 | $bgcolor2=$_SESSION['bgcolor2'];
|
|---|
| 362 | $bgcolor1='#e7e7e7';
|
|---|
| 363 | $session=$_SESSION['remote'];
|
|---|
| 364 |
|
|---|
| 365 | }
|
|---|
| 366 |
|
|---|
| 367 |
|
|---|
| 368 |
|
|---|
| 369 | /*********************************************************/
|
|---|
| 370 | /* Login Function */
|
|---|
| 371 | /*********************************************************/
|
|---|
| 372 | function ChiSei($id_cons_gen){
|
|---|
| 373 | global $dbi, $msglogout;
|
|---|
| 374 |
|
|---|
| 375 | $aid=$_SESSION['aid'];
|
|---|
| 376 | $prefix=$_SESSION['prefix'];
|
|---|
| 377 | $pwd=$_SESSION['pwd'];
|
|---|
| 378 | $id_comune=$_SESSION['id_comune'];
|
|---|
| 379 |
|
|---|
| 380 | $perms=0;
|
|---|
| 381 | $sql="select adminsuper, admincomune, adminop from ".$prefix."_authors where aid='$aid' and pwd='$pwd' and (id_comune='$id_comune' or id_comune=0)";
|
|---|
| 382 | $sth = $dbi->prepare("$sql");
|
|---|
| 383 | $sth->execute();
|
|---|
| 384 | $row = $sth->fetch(PDO::FETCH_BOTH);
|
|---|
| 385 |
|
|---|
| 386 | $adminsuper=$row[0];
|
|---|
| 387 | $admincomune=$row[1];
|
|---|
| 388 | $oper=$row[2];
|
|---|
| 389 | if ($adminsuper==1)
|
|---|
| 390 | return 256;
|
|---|
| 391 | elseif ($admincomune==1)
|
|---|
| 392 | return 64;
|
|---|
| 393 | # $sth = $dbi->prepare("select permessi from ".$prefix."_ele_operatori where id_cons='0' and aid='$aid' and id_comune='$id_comune'");
|
|---|
| 394 | elseif($oper) {$msglogout=1; return 0;} # id_cons='$id_cons' and
|
|---|
| 395 | else {
|
|---|
| 396 | $oggi=date("Y-m-d",mktime(0,0,0,date("m"),date("d")-3,date("Y")));
|
|---|
| 397 | $sql="select t1.id_cons from ".$prefix."_ele_cons_comune as t1, ".$prefix."_ele_consultazione as t2 where t1.id_cons_gen=t2.id_cons_gen and t1.id_cons_gen='$id_cons_gen' and t1.chiusa='0' and t1.id_comune='$id_comune' and t2.data_fine>$oggi";
|
|---|
| 398 | $sth = $dbi->prepare("$sql");
|
|---|
| 399 | $sth->execute(); #die("TEST: $sql");
|
|---|
| 400 | if(!$sth->rowCount()) {$msglogout=1; $perms=0; return $perms;}
|
|---|
| 401 | list($id_cons) = $sth->fetch(PDO::FETCH_NUM);
|
|---|
| 402 | $sql="select permessi from ".$prefix."_ele_operatori where id_cons='$id_cons' and aid='$aid'";
|
|---|
| 403 | $sth = $dbi->prepare("$sql");
|
|---|
| 404 | $sth->execute(); #die("TEST: $sql");
|
|---|
| 405 | list($perms) = $sth->fetch(PDO::FETCH_NUM);
|
|---|
| 406 | }
|
|---|
| 407 | }
|
|---|
| 408 |
|
|---|
| 409 | function OpenTable(){
|
|---|
| 410 | echo "<table width=\"100%\" cellpadding=\"0\" cellspacing=\"2\" BORDER=\"0\">";
|
|---|
| 411 | }
|
|---|
| 412 |
|
|---|
| 413 | function CloseTable(){
|
|---|
| 414 | echo "</table>";
|
|---|
| 415 | }
|
|---|
| 416 |
|
|---|
| 417 | function login() {
|
|---|
| 418 | global $param,$prefix,$dbi,$multicomune,$siteistat,$language,$tema, $id_cons_gen, $perms, $msglogout;
|
|---|
| 419 | if (isset($param['id_comune'])) $id_comune=intval($param['id_comune']);
|
|---|
| 420 | if (!isset($id_comune)) $id_comune=0;
|
|---|
| 421 | if(isset($_SESSION['aid'])){
|
|---|
| 422 | session_regenerate_id();
|
|---|
| 423 | }
|
|---|
| 424 | $lang=(isset($_SESSION['lang']) and strlen($_SESSION['lang'])==2) ? $_SESSION['lang']: $language;
|
|---|
| 425 | $id_ses=session_id();
|
|---|
| 426 |
|
|---|
| 427 | //include("modules/Elezioni/language/lang-$lang.php");
|
|---|
| 428 | if($multicomune==''){
|
|---|
| 429 | $sth = $dbi->prepare("select multicomune from ".$prefix."_config");
|
|---|
| 430 | $sth->execute();
|
|---|
| 431 | list($multicomune) = $sth->fetch(PDO::FETCH_NUM);
|
|---|
| 432 | }
|
|---|
| 433 | include ("header.php");
|
|---|
| 434 | echo "<div align=\"middle\"><font class=\"title\"><b>"._GESTIONE."</b></font></center>";
|
|---|
| 435 | echo "<br>"; # method=\"post\"
|
|---|
| 436 | if ($msglogout==1) echo "<h1 style=\"color:red;\">Utente non autorizzato</h1><br>";
|
|---|
| 437 | elseif ($msglogout==2) echo "<h1 style=\"color:red;\">Nome Utente non presente in archivio</h1><br>";
|
|---|
| 438 | elseif ($msglogout==3) echo "<h1 style=\"color:red;\">Password Errata</h1><br>";
|
|---|
| 439 | elseif ($msglogout==4) echo "<h1 style=\"color:red;\">Accesso non ammesso da cellulare</h1><br>";
|
|---|
| 440 | echo "<form name=\"login\" data-ajax=\"false\" method=\"post\" action=\"admin.php\">"
|
|---|
| 441 | ."<table class=\"table-menu\">"
|
|---|
| 442 | ."<tr><td>"._ADMINID."</td>"
|
|---|
| 443 | ."<td><input type=\"text\" NAME=\"aid\" SIZE=\"20\" MAXLENGTH=\"25\"></td></tr>"
|
|---|
| 444 | ."<tr><td>"._PASSWORD."</td>"
|
|---|
| 445 | ."<td><input type=\"password\" NAME=\"pwd\" SIZE=\"20\" MAXLENGTH=\"18\"></td></tr>"
|
|---|
| 446 | ."<tr><td>";
|
|---|
| 447 | // scelta comune
|
|---|
| 448 | if($multicomune=='1'){
|
|---|
| 449 | echo ""._COMUNE."</td><td>";
|
|---|
| 450 | $sql="select * from ".$prefix."_ele_comuni order by descrizione asc";
|
|---|
| 451 | $sth = $dbi->prepare("$sql");
|
|---|
| 452 | $sth->execute();
|
|---|
| 453 | $row = $sth->fetchAll();
|
|---|
| 454 | echo "<select name=\"id_comune\">";
|
|---|
| 455 | foreach($row as $comuni)
|
|---|
| 456 | {$id=$comuni[0];$descrizione=$comuni[1];
|
|---|
| 457 | $sel=($id == $id_comune) ? "selected":"";
|
|---|
| 458 | echo "<option value=\"$id\" $sel>$descrizione";
|
|---|
| 459 | }
|
|---|
| 460 | }else{
|
|---|
| 461 | echo "<input type=\"hidden\" name=\"id_comune\" value=\"$siteistat\">";
|
|---|
| 462 | }
|
|---|
| 463 | // echo "<input type=\"hidden\" name=\"id_comune\" value=\"$id_comune\">";
|
|---|
| 464 | if(strlen($lang)==2) echo "<input type=\"hidden\" name=\"language\" value=\"$lang\">";
|
|---|
| 465 | echo "</td></tr><tr><td>";
|
|---|
| 466 | echo "<input type=\"hidden\" name=\"id_ses\" value=\"$id_ses\">";
|
|---|
| 467 | echo "<input type=\"submit\" VALUE=\""._OK."\">"
|
|---|
| 468 | ."</td></tr></table>"
|
|---|
| 469 | ."</form></div>";
|
|---|
| 470 |
|
|---|
| 471 | include ("footer.php");
|
|---|
| 472 | }
|
|---|
| 473 |
|
|---|
| 474 | function logout()
|
|---|
| 475 | {
|
|---|
| 476 | /* $lang=$_SESSION['lang'];
|
|---|
| 477 | $id_comune=$_SESSION['id_comune'];
|
|---|
| 478 | // setcookie ("PHPSESSID", "", time() - 3600);
|
|---|
| 479 | session_cache_expire (0);
|
|---|
| 480 | $_SESSION=array(); //MODIFICHE PER GESTIONE SESSIONI
|
|---|
| 481 | session_unset();
|
|---|
| 482 | session_destroy();
|
|---|
| 483 | Header("Location: admin.php?id_comune=$id_comune&language=$lang");
|
|---|
| 484 | */
|
|---|
| 485 |
|
|---|
| 486 | global $siteistat,$perms,$msglogout;
|
|---|
| 487 | $language=$_SESSION['lang'];
|
|---|
| 488 | $ref="Location: admin.php?";
|
|---|
| 489 | #$ref="Location: https://www.eleonline.it/adminmob/admin.php?";
|
|---|
| 490 | if (isset($_SESSION['id_comune']))
|
|---|
| 491 | $id_comune=$_SESSION['id_comune'];
|
|---|
| 492 | else
|
|---|
| 493 | $id_comune=$siteistat;
|
|---|
| 494 | $ref=$ref."id_comune=".$id_comune;
|
|---|
| 495 |
|
|---|
| 496 | if (isset($_SESSION['lang']))
|
|---|
| 497 | $ref=$ref."&language=$language";
|
|---|
| 498 | $ref.="&msglogout=$msglogout";
|
|---|
| 499 | $_SESSION=array();
|
|---|
| 500 | session_unset();
|
|---|
| 501 | session_destroy();
|
|---|
| 502 | session_cache_expire (0);
|
|---|
| 503 | Header($ref);
|
|---|
| 504 |
|
|---|
| 505 | }
|
|---|
| 506 | #include("TEST tema: $tema--");
|
|---|
| 507 | #include("modules/Elezioni/language/lang-".$_SESSION['lang'].".php");
|
|---|
| 508 |
|
|---|
| 509 | if(isset($id_cons_gen) and isset($id_comune)){
|
|---|
| 510 | if(!isset($id_cons)){
|
|---|
| 511 | # $sql = "SELECT t2.id_cons FROM ".$prefix."_ele_consultazione as t1, ".$prefix."_ele_cons_comune as t2 where t1.id_cons_gen=t2.id_cons_gen and t2.id_cons_gen='$id_cons_gen' and t2.id_comune='$id_comune'";
|
|---|
| 512 | $sql = "SELECT id_cons from ".$prefix."_ele_comuni where id_comune='$id_comune'";
|
|---|
| 513 | $sth = $dbi->prepare("$sql");
|
|---|
| 514 | $sth->execute();
|
|---|
| 515 | if ($sth->rowCount()) {
|
|---|
| 516 | list($id_cons) = $sth->fetch(PDO::FETCH_NUM);
|
|---|
| 517 | $_SESSION['id_cons']=$id_cons;
|
|---|
| 518 | }
|
|---|
| 519 | }
|
|---|
| 520 | if(isset($id_cons)) {
|
|---|
| 521 | $sql="SELECT id_sez FROM ".$prefix."_ele_operatori where id_sez>0 and aid='$aid' and id_comune=$id_comune";
|
|---|
| 522 | try {
|
|---|
| 523 | $resmod = $dbi->prepare("$sql");
|
|---|
| 524 | $resmod->execute();
|
|---|
| 525 | }catch(PDOException $e)
|
|---|
| 526 | {
|
|---|
| 527 | # echo "Viene eseguito un aggiornamento forzato del db<br>";
|
|---|
| 528 | $_SESSION['forzadb']=1;
|
|---|
| 529 | include("modules/Elezioni/aggiornamento.php");
|
|---|
| 530 |
|
|---|
| 531 | die();
|
|---|
| 532 | }
|
|---|
| 533 | list($id_sez) = $resmod->fetch(PDO::FETCH_NUM); #die("qui:$id_sez:$sql");
|
|---|
| 534 | if($id_sez) {
|
|---|
| 535 | $oggi=date("Y-m-d",mktime(0,0,0,date("m"),date("d")-3,date("Y")));
|
|---|
| 536 | $sql="select t1.id_cons_gen,t1.descrizione,t2.id_cons 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 and t1.data_fine>'$oggi' and t2.id_cons in (select id_cons from ".$prefix."_ele_operatori where aid='$aid' and id_sez>0 and permessi>0)";
|
|---|
| 537 | $resmod = $dbi->prepare("$sql");
|
|---|
| 538 | $resmod->execute();
|
|---|
| 539 | if ($resmod->rowCount()>0) {
|
|---|
| 540 | $tema='Futura2'; #die( "TEST id_cons:$id_cons:".$_SESSION['aid']);
|
|---|
| 541 | $_SESSION['tema']=$tema;
|
|---|
| 542 | } #else {die("TEST: $sql"); logout();}
|
|---|
| 543 | }
|
|---|
| 544 | }
|
|---|
| 545 | $perms=ChiSei($id_cons_gen); #die("qui".$_SESSION['aid']);
|
|---|
| 546 | if($perms==0) {logout();}
|
|---|
| 547 | }
|
|---|
| 548 |
|
|---|
| 549 | #echo "op:".$param['op']." -- aid:".$_SESSION['aid']."remote:".$_SESSION['remote']."REMOTE:".$_SERVER['REMOTE_ADDR'];
|
|---|
| 550 | if (isset($param['op'])) $op=addslashes($param['op']); else $op='ele';
|
|---|
| 551 | //if (isset($param['op'])) $op=$param['op']; else $op='ele';
|
|---|
| 552 | #
|
|---|
| 553 | #die("TEST: qui $aid $id_cons $id_sez ".$_SESSION['aid']);
|
|---|
| 554 |
|
|---|
| 555 | if (isset($_SESSION['aid']) AND $_SESSION['remote']==$_SERVER['REMOTE_ADDR']) {
|
|---|
| 556 | if($tema=='Futura2' and $op!='logout')
|
|---|
| 557 | {
|
|---|
| 558 | include("temi/$tema/index.php");
|
|---|
| 559 | }else
|
|---|
| 560 | switch($op) {
|
|---|
| 561 | case "tipo":
|
|---|
| 562 | include("modules/Elezioni/ele_tipi.php");
|
|---|
| 563 | break;
|
|---|
| 564 | case "aggiorna":
|
|---|
| 565 | include("modules/Elezioni/aggiornamento.php");
|
|---|
| 566 | break;
|
|---|
| 567 | case "constipi":
|
|---|
| 568 | include("modules/Elezioni/ele_consultazionitipi.php");
|
|---|
| 569 | break;
|
|---|
| 570 | case "parziali":
|
|---|
| 571 | include("modules/Elezioni/ele_parziali.php");
|
|---|
| 572 | break;
|
|---|
| 573 | case "ele":
|
|---|
| 574 | include("modules/Elezioni/ele.php");
|
|---|
| 575 | break;
|
|---|
| 576 | case "consultazione":
|
|---|
| 577 | include("modules/Elezioni/ele_consultazioni.php");
|
|---|
| 578 | break;
|
|---|
| 579 | case "configurazione":
|
|---|
| 580 | include("modules/Elezioni/ele_configurazione.php");
|
|---|
| 581 | break;
|
|---|
| 582 | case "cons_comuni":
|
|---|
| 583 | include("modules/Elezioni/ele_cons_comuni.php");
|
|---|
| 584 | break;
|
|---|
| 585 | case "confconsiglio":
|
|---|
| 586 | include("modules/Elezioni/ele_confcons.php");
|
|---|
| 587 | break;
|
|---|
| 588 | case "inscomuni":
|
|---|
| 589 | include("modules/Elezioni/ele_comuni.php");
|
|---|
| 590 | break;
|
|---|
| 591 | case "oper_admin":
|
|---|
| 592 | include("modules/Elezioni/ele_operatori.php");
|
|---|
| 593 | break;
|
|---|
| 594 | case "inscollegi":
|
|---|
| 595 | include("modules/Elezioni/ele_collegi.php");
|
|---|
| 596 | break;
|
|---|
| 597 | case "associazioni":
|
|---|
| 598 | include("modules/Elezioni/ele_associazioni.php");
|
|---|
| 599 | break;
|
|---|
| 600 | case "operatori":
|
|---|
| 601 | include("modules/Elezioni/ele_operatori.php");
|
|---|
| 602 | break;
|
|---|
| 603 | case "permessi":
|
|---|
| 604 | include("modules/Elezioni/ele_permessi.php");
|
|---|
| 605 | break;
|
|---|
| 606 | case "circo":
|
|---|
| 607 | include("modules/Elezioni/ele_circo.php");
|
|---|
| 608 | break;
|
|---|
| 609 | case "sede":
|
|---|
| 610 | include("modules/Elezioni/ele_sede.php");
|
|---|
| 611 | break;
|
|---|
| 612 | case "sezione":
|
|---|
| 613 | include("modules/Elezioni/ele_sezione.php");
|
|---|
| 614 | break;
|
|---|
| 615 | case "gruppo":
|
|---|
| 616 | include("modules/Elezioni/ele_gruppo.php");
|
|---|
| 617 | break;
|
|---|
| 618 | case "rec_add_aff":
|
|---|
| 619 | include("modules/Elezioni/ele_affluenze.php");
|
|---|
| 620 | break;
|
|---|
| 621 | case "rec_add_mod":
|
|---|
| 622 | include("modules/Elezioni/ele_modelli.php");
|
|---|
| 623 | break;
|
|---|
| 624 | case "upgruppo":
|
|---|
| 625 | include("modules/Elezioni/ele_gruppo.php");
|
|---|
| 626 | break;
|
|---|
| 627 | case "delimggruppo":
|
|---|
| 628 | include("modules/Elezioni/ele_gruppo.php");
|
|---|
| 629 | break;
|
|---|
| 630 | case "lista":
|
|---|
| 631 | include("modules/Elezioni/ele_lista.php");
|
|---|
| 632 | break;
|
|---|
| 633 | case "uplista":
|
|---|
| 634 | include("modules/Elezioni/ele_lista.php");
|
|---|
| 635 | break;
|
|---|
| 636 | case "delimglista":
|
|---|
| 637 | include("modules/Elezioni/ele_lista.php");
|
|---|
| 638 | break;
|
|---|
| 639 | case "candidato":
|
|---|
| 640 | include("modules/Elezioni/ele_candidato.php");
|
|---|
| 641 | break;
|
|---|
| 642 | case "upcandidato":
|
|---|
| 643 | include("modules/Elezioni/ele_candidato.php");
|
|---|
| 644 | break;
|
|---|
| 645 | case "delimgcandidato":
|
|---|
| 646 | include("modules/Elezioni/ele_candidato.php");
|
|---|
| 647 | break;
|
|---|
| 648 |
|
|---|
| 649 | case "voti":
|
|---|
| 650 | include("modules/Elezioni/ele_voti.php");
|
|---|
| 651 | break;
|
|---|
| 652 | case "sezioni_voti":
|
|---|
| 653 | include("modules/Elezioni/ele_voti.php");
|
|---|
| 654 | break;
|
|---|
| 655 | case "rec_voti":
|
|---|
| 656 | include("modules/Elezioni/ele_voti.php");
|
|---|
| 657 | break;
|
|---|
| 658 | case "rec_voti_gruppi":
|
|---|
| 659 | include("modules/Elezioni/ele_voti.php");
|
|---|
| 660 | break;
|
|---|
| 661 | case "rec_add_votanti":
|
|---|
| 662 | include("modules/Elezioni/ele_voti.php");
|
|---|
| 663 | break;
|
|---|
| 664 | case "rec_finale":
|
|---|
| 665 | include("modules/Elezioni/ele_voti.php");
|
|---|
| 666 | break;
|
|---|
| 667 | case "controllo_voti":
|
|---|
| 668 | include("modules/Elezioni/controllo_voti.php");
|
|---|
| 669 | break;
|
|---|
| 670 | case "controllo_votanti":
|
|---|
| 671 | include("modules/Elezioni/controllo_votanti.php");
|
|---|
| 672 | break;
|
|---|
| 673 | case "come":
|
|---|
| 674 | include("modules/Elezioni/ele_come.php");
|
|---|
| 675 | break;
|
|---|
| 676 | case "numeri":
|
|---|
| 677 | include("modules/Elezioni/ele_come.php");
|
|---|
| 678 | break;
|
|---|
| 679 | case "servizi":
|
|---|
| 680 | include("modules/Elezioni/ele_come.php");
|
|---|
| 681 | break;
|
|---|
| 682 | case "link":
|
|---|
| 683 | include("modules/Elezioni/ele_come.php");
|
|---|
| 684 | break;
|
|---|
| 685 | case "conf":
|
|---|
| 686 | include("modules/Elezioni/ele_conf.php");
|
|---|
| 687 | break;
|
|---|
| 688 | case "stampa":
|
|---|
| 689 | include("modules/Elezioni/ele_stampe.php");
|
|---|
| 690 | break;
|
|---|
| 691 | case "cambiopwd":
|
|---|
| 692 | include("modules/Elezioni/ele_pwd.php");
|
|---|
| 693 | break;
|
|---|
| 694 | case "eletti":
|
|---|
| 695 | include("modules/Elezioni/ele_eletti.php");
|
|---|
| 696 | break;
|
|---|
| 697 | case "foto":
|
|---|
| 698 | include("modules/Elezioni/foto.php");
|
|---|
| 699 | break;
|
|---|
| 700 | case "consiglieri":
|
|---|
| 701 | include("modules/Elezioni/ele_consiglieri.php");
|
|---|
| 702 | break;
|
|---|
| 703 | case "backup":
|
|---|
| 704 | include("modules/Elezioni/backup.php");
|
|---|
| 705 | break;
|
|---|
| 706 | case "restore":
|
|---|
| 707 | include("modules/Elezioni/restore.php");
|
|---|
| 708 | break;
|
|---|
| 709 | case "scarica":
|
|---|
| 710 | include("modules/Elezioni/scarica.php");
|
|---|
| 711 | break;
|
|---|
| 712 | case "importa":
|
|---|
| 713 | include("modules/Elezioni/importa.php");
|
|---|
| 714 | break;
|
|---|
| 715 | case "widget":
|
|---|
| 716 | include("modules/Elezioni/ele_widget.php");
|
|---|
| 717 | break;
|
|---|
| 718 | case "riepilogo":
|
|---|
| 719 | include("modules/Elezioni/ele_riepilogo.php");
|
|---|
| 720 | break;
|
|---|
| 721 | case "riepilogovoti":
|
|---|
| 722 | include("modules/Elezioni/ele_riepilogovoti.php");
|
|---|
| 723 | break;
|
|---|
| 724 | case "logout":
|
|---|
| 725 | logout();
|
|---|
| 726 | break;
|
|---|
| 727 | }
|
|---|
| 728 |
|
|---|
| 729 | }else {
|
|---|
| 730 |
|
|---|
| 731 | login();
|
|---|
| 732 |
|
|---|
| 733 | }
|
|---|
| 734 |
|
|---|
| 735 | ?>
|
|---|
