Changeset 253 for trunk/admin/admin.php

Timestamp:

Mar 12, 2018, 8:53:21 PM (6 years ago)

Author:

roby

Message:

 

File:

• trunk/admin/admin.php (modified) (2 diffs)

trunk/admin/admin.php

@@ -133 +133 @@
 
 
-
-
-
-                $dbi=mysql_connect($dbhost, $dbuname, $dbpass) or die("Connessione non riuscita: " . mysql_error());
-                mysql_select_db($dbname)or die("Connessione non riuscita:" . mysql_error());
-        mysql_query("SET NAMES 'utf8'", $dbi);
+        try{
+        $dbi = new PDO("mysql:host=$dbhost;charset=latin1", $dbuname, $dbpass, array(PDO::ATTR_EMULATE_PREPARES => false, PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION)); 
+        $sql = "use $dbname";
+        $dbi->exec($sql);
+        }
+        catch(PDOException $e)
+        {
+            echo $sql . "<br>" . $e->getMessage();
+        }                                                                                               
+
+
+
+#               $dbi=mysql_connect($dbhost, $dbuname, $dbpass) or die("Connessione non riuscita: " . mysql_error());
+#               mysql_select_db($dbname)or die("Connessione non riuscita:" . mysql_error());
+##      mysql_query("SET NAMES 'utf8'", $dbi);
 //---10/05/2009  gestione consultazione predefinita
-                $res_config = mysql_query("select * from ".$prefix."_config ",$dbi);
-                list ($sitename,$siteurl,$site_logo,$slogan,$startdate,$adminmail,$tema,$foot,$language,$blocco
-,$testata,$logo,$fileout,$copyright,$versione,$patch,$id_comune,$multicomune,$flash,$displayerrors,$editor,$tema_on,$ed_user) = mysql_fetch_row($res_config);
-                $siteistat=$id_comune;
+        $sth = $dbi->prepare("select * from ".$prefix."_config");
+        $sth->execute();
+        
+        $row = $sth->fetch(PDO::FETCH_ASSOC);   
+#               $res_config = mysql_query("select * from ".$prefix."_config ",$dbi);
+#               list ($sitename,$siteurl,$site_logo,$slogan,$startdate,$adminmail,$tema,$foot,$language,$blocco,$testata,$logo,$fileout,$copyright,$versione,$patch,$id_comune,$multicomune,$flash,$displayerrors,$editor,$tema_on,$ed_user) = ($res_config->fetch());
+                $siteistat=$row['siteistat'];
 if (!isset($_SESSION['id_comune'])){
-        $_SESSION['sitename']=$sitename;
-        $_SESSION['siteurl']=$siteurl;
-        $_SESSION['site_logo']=$site_logo;
-        $_SESSION['slogan']=$slogan;
-        $_SESSION['startdate']=$startdate;
-        $_SESSION['adminmail']=$adminmail;
+        $_SESSION['sitename']=$row['sitename'];
+        $_SESSION['siteurl']=$row['siteurl'];
+        $_SESSION['site_logo']=$row['site_logo'];
+        $_SESSION['slogan']=$row['slogan'];
+        $_SESSION['startdate']=$row['startdate'];
+        $_SESSION['adminmail']=$row['adminmail'];
         if ($tema=='facebook')
-                $_SESSION['tema']=$tema;
+                $_SESSION['tema']=$row['tema'];
         else $_SESSION['tema']='default';
-        $_SESSION['foot']=$foot;
-        $_SESSION['lang']=$language;
-        $_SESSION['blocco']=$blocco;
-        $_SESSION['testata']=$testata;
-        $_SESSION['logo']=$logo;
-        $_SESSION['fileout']=$fileout;
-        $_SESSION['copyright']=$copyright;
-        $_SESSION['versione']=$versione;
-        $_SESSION['patch']=$patch;
-        $_SESSION['id_comune']=$id_comune;
+        $_SESSION['foot']=$row['foot'];
+        $_SESSION['lang']=$row['language'];
+        $_SESSION['blocco']=$row['blocco'];
+        $_SESSION['testata']=$row['testata'];
+        $_SESSION['logo']=$row['logo'];
+        $_SESSION['fileout']=$row['fileout'];
+        $_SESSION['copyright']=$row['copyright'];
+        $_SESSION['versione']=$row['versione'];
+        $_SESSION['patch']=$row['patch'];
+        $_SESSION['id_comune']=$row['siteistat'];
         $_SESSION['multicomune']=$multicomune;
         $_SESSION['flash']=$flash;
@@ -227 +239 @@
 $dbi=$_SESSION['dbi'];
 $prefix=$_SESSION['prefix'];
-$id_comune=$_SESSION['id_comune'];
+$id_comune=$_SESSION['id_comune'];die("qui");
 if (isset($_GET['id_cons_gen'])) $id_cons_gen=intval($_GET['id_cons_gen']);
 else {