Changeset 253 for trunk/install/install4.php

Timestamp:

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

Author:

roby

Message:

 

File:

• trunk/install/install4.php (modified) (4 diffs)

trunk/install/install4.php

@@ -25 +25 @@
 $nomecomune = mosGetParam( $_POST, 'nomecomune', '' ) ;
 $istat =  mosGetParam( $_POST, 'istat', '' ) ;
-$Capoluogo = mosGetParam( $_POST, 'Capoluogo', '' );
+$Capoluogo = mosGetParam( $_POST, 'Capoluogo', '0' );
 $Lingua = mosGetParam( $_POST, 'Lingua', '' );
-$Multicomune = mosGetParam( $_POST, 'Multicomune', '' );
+$Multicomune = mosGetParam( $_POST, 'Multicomune', '0' );
 $Replica = mosGetParam( $_POST, 'Replica', '' );
 
@@ -295 +295 @@
 
 
-
-        $database = new database( $DBhostname, $DBuserName, $DBpassword, $DBname );
-        $nullDate = $database->getNullDate();
+        $database = new PDO("mysql:host=$DBhostname;charset=latin1", $DBuserName, $DBpassword, array(PDO::ATTR_EMULATE_PREPARES => false, 
+                                                                                                PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION));    
+        $sql = "use $DBname";
+        $database->exec($sql);
 
         // create the admin user
@@ -303 +304 @@
         //$query = "INSERT INTO {$configArray['DBPrefix']}_authors VALUES ('$adminName', '$adminName', '0', '$adminEmail', '$cryptpass','1','0','0','1','it')";
         $query = "UPDATE {$configArray['DBPrefix']}_authors SET aid='$adminName', name='$adminName', email='$adminEmail', pwd= '$cryptpass' WHERE aid='suser'";
-        $database->setQuery( $query );
-        $database->query();
+        $database->exec( $query );
         
         // create Comune
+        try{
+        $query = "INSERT INTO {$configArray['DBPrefix']}_ele_comuni VALUES ('$istat', '$nomecomune', '','','','','$Limite','$Capoluogo','','','0','')";
+        $database->exec( $query );
+        } catch(PDOException $e) {}
+        $query = "UPDATE {$configArray['DBPrefix']}_config SET sitename='$sitename', siteurl='$siteUrl', adminmail='$adminEmail', tema='$tema', foot='',language='$Lingua',blocco='$blocco',fileout='$Replica',Versione='3', siteistat='$istat',multicomune='$Multicomune',flash='$flash', tema_on='$sceltatema'   WHERE sitename=''";
         
-        $query = "INSERT INTO {$configArray['DBPrefix']}_ele_comuni VALUES ('$istat', '$nomecomune', '','','','','$Limite','$Capoluogo','','','')";
-        
-        $database->setQuery( $query );
-        $database->query();
-        
-        $query = "UPDATE {$configArray['DBPrefix']}_config SET sitename='$sitename', siteurl='$siteUrl', adminmail='$adminEmail', tema='$tema', foot='',language='$Lingua',blocco='$blocco',fileout='$Replica',Versione='2.0 beta', siteistat='$istat',multicomune='$Multicomune',flash='$flash', tema_on='$sceltatema'   WHERE sitename=''";
-        
-
-        $database->setQuery( $query );
-        $database->query();
+        $database->exec( $query );
 
 
         // touch config table
         $date = date("F Y");
-        $query = "UPDATE {$configArray['DBPrefix']}_config SET sitename='$sitename', nukeurl='$siteUrl', startdate='$date', adminmail='$adminEmail', backend_title='$sitename', notify_email='$adminEmail'";
-        $database->setQuery( $query );
-        $database->query();
+        $query = "UPDATE {$configArray['DBPrefix']}_config SET sitename='$sitename', siteurl='$siteUrl', startdate='$date', adminmail='$adminEmail'";
+        $database->exec( $query );
 
 } else {
@@ -407 +402 @@
 da quella di amministrazione (admin)<br/>
 od anche l'utenza del database pubblico in sola lettura<br/> 
-e altri accorgimenti che riterrai necessarie<br/>
+e altri accorgimenti che riterrai necessari<br/>