Changeset 253 for trunk/install/install2.php

Timestamp:

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

Author:

roby

Message:

 

File:

• trunk/install/install2.php (modified) (2 diffs)

trunk/install/install2.php

@@ -26 +26 @@
 $Capoluogo = mosGetParam( $_POST, 'Capoluogo', '' );
 $Lingua = mosGetParam( $_POST, 'Lingua', '' );
-$Multicomune = mosGetParam( $_POST, 'Multicomune', '' );
+$Multicomune = mosGetParam( $_POST, 'Multicomune', '0' );
 $Replica = mosGetParam( $_POST, 'Replica', '' );
 //tema
@@ -54 +54 @@
                 db_err ('stepBack','Non avete indicato il prefisso tabelle database.');
         }
-        
-        $database = new database( $DBhostname, $DBuserName, $DBpassword, '', '', false );
-        $test = $database->getErrorMsg();
-
-        if (!$database->_resource) {
-                db_err ('stepBack2','password ed username inseriti non sono corretti.');
-        }
-
-        // Does this code actually do anything???
-        $configArray['DBhostname'] = $DBhostname;
-        $configArray['DBuserName'] = $DBuserName;
-        $configArray['DBpassword'] = $DBpassword;
-        $configArray['DBname']   = $DBname;
-        $configArray['DBPrefix']= $DBPrefix;
-
-        $sql = "CREATE DATABASE `$DBname`";
-        $database->setQuery( $sql );
-        $database->query();
-        $test = $database->getErrorNum();
-
-        if ($test != 0 && $test != 1007) {
-                db_err( 'stepBack', 'Avvenuto un errore database: ' . $database->getErrorMsg() );
-        }
-
-        // db is now new or existing, create the db object connector to do the serious work
-        $database = new database( $DBhostname, $DBuserName, $DBpassword, $DBname, $DBPrefix );
-
-        // delete existing mos table if exists
-        $query = "SHOW TABLES FROM `$DBname`";
-        $database->setQuery( $query );
-        $errors = array();
-        if ($tables = $database->loadResultArray()) {
-                foreach ($tables as $table) {
-                                $query = "DROP TABLE IF EXISTS `$table`";
-                                $database->setQuery( $query );
-                                $database->query();
-                                if ($database->getErrorNum()) {
-                                        $errors[$database->getQuery()] = $database->getErrorMsg();
-                                }
-                }
-        }
-
-        populate_db( $database, 'eleonline.sql' );
+        try{
+        $database = new PDO("mysql:host=$DBhostname;charset=latin1", $DBuserName, $DBpassword, array(PDO::ATTR_EMULATE_PREPARES => false, 
+                                                                                                PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION));    
+        $sql = "CREATE DATABASE IF NOT EXISTS $DBname;
+        CREATE USER `$DBuserName`@'$DBhostname' IDENTIFIED BY '$DBpassword';
+        GRANT ALL ON `$DBname`.* TO `$DBuserName`@'$DBhostname';
+        FLUSH PRIVILEGES;";
+        $database->exec($sql);
+        $sql = "use $DBname";
+        $database->exec($sql);
+        $sql = file_get_contents('sql/eleonline.sql');
+        $qr = $database->exec($sql);
         $DBcreated = 1;
+        }
+        catch(PDOException $e)
+        {
+            echo $sql . "<br>" . $e->getMessage();die();
+        }
 }