Esempio n. 1
0
 public static function execute()
 {
     $db = array('DB_SERVER' => trim(urldecode($_POST['server'])), 'DB_SERVER_USERNAME' => trim(urldecode($_POST['username'])), 'DB_SERVER_PASSWORD' => trim(urldecode($_POST['password'])), 'DB_DATABASE' => trim(urldecode($_POST['name'])), 'DB_SERVER_PORT' => trim(urldecode($_POST['port'])), 'DB_DATABASE_CLASS' => trim(urldecode(str_replace('_', '\\', $_POST['class']))), 'DB_INSERT_SAMPLE_DATA' => trim(urldecode($_POST['import'])) == '1' ? 'true' : 'false', 'DB_TABLE_PREFIX' => trim(urldecode($_POST['prefix'])));
     Registry::set('Database', Database::initialize($db['DB_SERVER'], $db['DB_SERVER_USERNAME'], $db['DB_SERVER_PASSWORD'], $db['DB_DATABASE'], $db['DB_SERVER_PORT'], $db['DB_DATABASE_CLASS']));
     $OSCOM_Database = Registry::get('Database');
     if (!$OSCOM_Database->isError()) {
         $sql_file = OSCOM::BASE_DIRECTORY . 'Core/Site/Setup/sql/oscommerce.sql';
         $OSCOM_Database->importSQL($sql_file, $db['DB_DATABASE'], $db['DB_TABLE_PREFIX']);
     }
     if (!$OSCOM_Database->isError()) {
         define('DB_TABLE_PREFIX', $db['DB_TABLE_PREFIX']);
         // HPDL to remove
         foreach (Registry::get('Language')->extractDefinitions('en_US.xml') as $def) {
             $Qdef = $OSCOM_Database->query('insert into :table_languages_definitions (languages_id, content_group, definition_key, definition_value) values (:languages_id, :content_group, :definition_key, :definition_value)');
             $Qdef->bindInt(':languages_id', 1);
             $Qdef->bindValue(':content_group', $def['group']);
             $Qdef->bindValue(':definition_key', $def['key']);
             $Qdef->bindValue(':definition_value', $def['value']);
             $Qdef->execute();
         }
         $OSCOM_DirectoryListing = new DirectoryListing(OSCOM::BASE_DIRECTORY . 'Core/Site/Shop/Languages/en_US');
         $OSCOM_DirectoryListing->setRecursive(true);
         $OSCOM_DirectoryListing->setIncludeDirectories(false);
         $OSCOM_DirectoryListing->setAddDirectoryToFilename(true);
         $OSCOM_DirectoryListing->setCheckExtension('xml');
         foreach ($OSCOM_DirectoryListing->getFiles() as $files) {
             foreach (Registry::get('Language')->extractDefinitions('en_US/' . $files['name']) as $def) {
                 $Qdef = $OSCOM_Database->query('insert into :table_languages_definitions (languages_id, content_group, definition_key, definition_value) values (:languages_id, :content_group, :definition_key, :definition_value)');
                 $Qdef->bindInt(':languages_id', 1);
                 $Qdef->bindValue(':content_group', $def['group']);
                 $Qdef->bindValue(':definition_key', $def['key']);
                 $Qdef->bindValue(':definition_value', $def['value']);
                 $Qdef->execute();
             }
         }
     }
     if (!$OSCOM_Database->isError()) {
         $services = array('OutputCompression', 'Session', 'Language', 'Debug', 'Currencies', 'Core', 'SimpleCounter', 'CategoryPath', 'Breadcrumb', 'WhosOnline', 'Specials', 'Reviews', 'RecentlyVisited');
         $installed = array();
         foreach ($services as $service) {
             $class = 'osCommerce\\OM\\Core\\Site\\Admin\\Module\\Service\\' . $service;
             $module = new $class();
             $module->install();
             if (isset($module->depends)) {
                 if (is_string($module->depends) && ($key = array_search($module->depends, $installed)) !== false) {
                     if (isset($installed[$key + 1])) {
                         array_splice($installed, $key + 1, 0, $service);
                     } else {
                         $installed[] = $service;
                     }
                 } elseif (is_array($module->depends)) {
                     foreach ($module->depends as $depends_module) {
                         if (($key = array_search($depends_module, $installed)) !== false) {
                             if (!isset($array_position) || $key > $array_position) {
                                 $array_position = $key;
                             }
                         }
                     }
                     if (isset($array_position)) {
                         array_splice($installed, $array_position + 1, 0, $service);
                     } else {
                         $installed[] = $service;
                     }
                 }
             } elseif (isset($module->precedes)) {
                 if (is_string($module->precedes)) {
                     if (($key = array_search($module->precedes, $installed)) !== false) {
                         array_splice($installed, $key, 0, $service);
                     } else {
                         $installed[] = $service;
                     }
                 } elseif (is_array($module->precedes)) {
                     foreach ($module->precedes as $precedes_module) {
                         if (($key = array_search($precedes_module, $installed)) !== false) {
                             if (!isset($array_position) || $key < $array_position) {
                                 $array_position = $key;
                             }
                         }
                     }
                     if (isset($array_position)) {
                         array_splice($installed, $array_position, 0, $service);
                     } else {
                         $installed[] = $service;
                     }
                 }
             } else {
                 $installed[] = $service;
             }
             unset($array_position);
         }
         $Qs = $OSCOM_Database->query('insert into :table_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ("Service Modules", "MODULE_SERVICES_INSTALLED",  :configuration_value, "Installed services modules", "6", "0", now())');
         $Qs->bindValue(':configuration_value', implode(';', $installed));
         $Qs->execute();
         define('DEFAULT_ORDERS_STATUS_ID', 1);
         // HPDL to remove
         $module = new \osCommerce\OM\Core\Site\Admin\Module\Payment\COD();
         $module->install();
         $Qupdate = $OSCOM_Database->query('update :table_configuration set configuration_value = 1 where configuration_key = :configuration_key');
         $Qupdate->bindValue(':configuration_key', 'MODULE_PAYMENT_COD_STATUS');
         $Qupdate->execute();
         $module = new \osCommerce\OM\Core\Site\Admin\Module\Shipping\Flat();
         $module->install();
         $module = new \osCommerce\OM\Core\Site\Admin\Module\OrderTotal\SubTotal();
         $module->install();
         $module = new \osCommerce\OM\Core\Site\Admin\Module\OrderTotal\Shipping();
         $module->install();
         $module = new \osCommerce\OM\Core\Site\Admin\Module\OrderTotal\Tax();
         $module->install();
         $module = new \osCommerce\OM\Core\Site\Admin\Module\OrderTotal\Total();
         $module->install();
     }
     if (!$OSCOM_Database->isError() && $db['DB_DATABASE_CLASS'] == 'mysql_innodb') {
         $Qinno = $OSCOM_Database->query('show variables like "have_innodb"');
         if ($Qinno->numberOfRows() === 1 && strtolower($Qinno->value('Value')) == 'yes') {
             $innodb_sql_file = OSCOM::BASE_DIRECTORY . 'Core/Site/Setup/sql/oscommerce_innodb.sql';
             $OSCOM_Database->importSQL($innodb_sql_file, $db['DB_DATABASE'], $db['DB_TABLE_PREFIX']);
         }
     }
     if (!$OSCOM_Database->isError()) {
         echo '[[1]]';
     } else {
         echo '[[0|' . $OSCOM_Database->getError() . ']]';
     }
 }
Esempio n. 2
0
 public static function execute($data)
 {
     Registry::set('PDO', PDO::initialize($data['server'], $data['username'], $data['password'], $data['database'], $data['port'], $data['class']));
     // Import SQL queries
     OSCOM::callDB('Setup\\Install\\ImportSQL', array('table_prefix' => $data['table_prefix']));
     // Import language definitions
     OSCOM::setConfig('db_table_prefix', $data['table_prefix'], 'Admin');
     OSCOM::setConfig('db_table_prefix', $data['table_prefix'], 'Shop');
     OSCOM::setConfig('db_table_prefix', $data['table_prefix'], 'Setup');
     foreach (Language::extractDefinitions('en_US.xml') as $def) {
         $def['id'] = 1;
         OSCOM::callDB('Admin\\InsertLanguageDefinition', $def, 'Site');
     }
     $DL_lang = new DirectoryListing(OSCOM::BASE_DIRECTORY . 'Core/Site/Shop/Languages/en_US');
     $DL_lang->setRecursive(true);
     $DL_lang->setIncludeDirectories(false);
     $DL_lang->setAddDirectoryToFilename(true);
     $DL_lang->setCheckExtension('xml');
     foreach ($DL_lang->getFiles() as $files) {
         foreach (Language::extractDefinitions('en_US/' . $files['name']) as $def) {
             $def['id'] = 1;
             OSCOM::callDB('Admin\\InsertLanguageDefinition', $def, 'Site');
         }
     }
     // Import Service modules
     $services = array('OutputCompression', 'Session', 'Language', 'Debug', 'Currencies', 'Core', 'SimpleCounter', 'CategoryPath', 'Breadcrumb', 'WhosOnline', 'Specials', 'Reviews', 'RecentlyVisited');
     $installed = array();
     foreach ($services as $service) {
         $class = 'osCommerce\\OM\\Core\\Site\\Admin\\Module\\Service\\' . $service;
         $module = new $class();
         $module->install();
         if (isset($module->depends)) {
             if (is_string($module->depends) && ($key = array_search($module->depends, $installed)) !== false) {
                 if (isset($installed[$key + 1])) {
                     array_splice($installed, $key + 1, 0, $service);
                 } else {
                     $installed[] = $service;
                 }
             } elseif (is_array($module->depends)) {
                 foreach ($module->depends as $depends_module) {
                     if (($key = array_search($depends_module, $installed)) !== false) {
                         if (!isset($array_position) || $key > $array_position) {
                             $array_position = $key;
                         }
                     }
                 }
                 if (isset($array_position)) {
                     array_splice($installed, $array_position + 1, 0, $service);
                 } else {
                     $installed[] = $service;
                 }
             }
         } elseif (isset($module->precedes)) {
             if (is_string($module->precedes)) {
                 if (($key = array_search($module->precedes, $installed)) !== false) {
                     array_splice($installed, $key, 0, $service);
                 } else {
                     $installed[] = $service;
                 }
             } elseif (is_array($module->precedes)) {
                 foreach ($module->precedes as $precedes_module) {
                     if (($key = array_search($precedes_module, $installed)) !== false) {
                         if (!isset($array_position) || $key < $array_position) {
                             $array_position = $key;
                         }
                     }
                 }
                 if (isset($array_position)) {
                     array_splice($installed, $array_position, 0, $service);
                 } else {
                     $installed[] = $service;
                 }
             }
         } else {
             $installed[] = $service;
         }
         unset($array_position);
     }
     $cfg_data = array('title' => 'Service Modules', 'key' => 'MODULE_SERVICES_INSTALLED', 'value' => implode(';', $installed), 'description' => 'Installed services modules', 'group_id' => '6');
     OSCOM::callDB('Admin\\InsertConfigurationParameters', $cfg_data, 'Site');
     // Import Payment modules
     define('DEFAULT_ORDERS_STATUS_ID', 1);
     $module = new \osCommerce\OM\Core\Site\Admin\Module\Payment\COD();
     $module->install();
     $pm_data = array('key' => 'MODULE_PAYMENT_COD_STATUS', 'value' => '1');
     OSCOM::callDB('Admin\\UpdateConfigurationParameters', $pm_data, 'Site');
     // Import Shipping modules
     $module = new \osCommerce\OM\Core\Site\Admin\Module\Shipping\Flat();
     $module->install();
     // Import Order Total modules
     $module = new \osCommerce\OM\Core\Site\Admin\Module\OrderTotal\SubTotal();
     $module->install();
     $module = new \osCommerce\OM\Core\Site\Admin\Module\OrderTotal\Shipping();
     $module->install();
     $module = new \osCommerce\OM\Core\Site\Admin\Module\OrderTotal\Tax();
     $module->install();
     $module = new \osCommerce\OM\Core\Site\Admin\Module\OrderTotal\Total();
     $module->install();
     // Import Foreign Keys
     OSCOM::callDB('Setup\\Install\\ImportFK', array('table_prefix' => $data['table_prefix']));
 }