$database_tables = array('address_book', 'categories', 'categories_description', 'customers', 'manufacturers', 'manufacturers_info', 'orders', 'orders_products', 'orders_status', 'orders_status_history', 'orders_products_attributes', 'orders_products_download', 'orders_total', 'products', 'products_attributes', 'products_attributes_download', 'products_description', 'products_options', 'products_options_values', 'products_options_values_to_products_options', 'products_to_categories', 'reviews', 'shopping_carts', 'shopping_carts_custom_variants_values', 'weight_classes', 'weight_classes_rules'); foreach ($database_tables as $table) { $lC_Database->simpleQuery('alter table ' . $db['DB_TABLE_PREFIX'] . $table . ' type = innodb'); } } } if ($lC_Database->isError()) { echo '[[0|' . $lC_Database->getError() . ']]'; } else { echo '[[1]]'; } exit; break; case 'dbImportSample': $db = array('DB_SERVER' => trim(urldecode($_GET['server'])), 'DB_SERVER_USERNAME' => trim(urldecode($_GET['username'])), 'DB_SERVER_PASSWORD' => trim(urldecode($_GET['password'])), 'DB_DATABASE' => trim(urldecode($_GET['name'])), 'DB_DATABASE_CLASS' => trim(urldecode($_GET['class'])), 'DB_TABLE_PREFIX' => trim(urldecode($_GET['prefix']))); $lC_Database = lC_Database::connect($db['DB_SERVER'], $db['DB_SERVER_USERNAME'], $db['DB_SERVER_PASSWORD'], $db['DB_DATABASE_CLASS']); if ($lC_Database->isError() === false) { $lC_Database->selectDatabase($db['DB_DATABASE']); } if ($lC_Database->isError() === false) { $sql_file = $dir_fs_www_root . '/loadedcommerce_sample_data.sql'; $lC_Database->importSQL($sql_file, $db['DB_DATABASE'], $db['DB_TABLE_PREFIX']); } if ($lC_Database->isError()) { echo '[[0|' . $lC_Database->getError() . ']]'; } else { echo '[[1]]'; } exit; break; case 'checkWorkDir':
// include the list of project filenames require $lC_Vqmod->modCheck(DIR_FS_CATALOG . 'includes/filenames.php'); // include the list of project database tables require $lC_Vqmod->modCheck(DIR_FS_CATALOG . 'includes/database_tables.php'); // include the utility class require $lC_Vqmod->modCheck(DIR_FS_CATALOG . 'includes/classes/utility.php'); // initialize the message stack for output messages require $lC_Vqmod->modCheck(DIR_FS_CATALOG . 'includes/classes/message_stack.php'); $lC_MessageStack = new lC_MessageStack(); // initialize the cache class require $lC_Vqmod->modCheck(DIR_FS_CATALOG . 'includes/classes/cache.php'); $lC_Cache = new lC_Cache(); // include the database class require $lC_Vqmod->modCheck(DIR_FS_CATALOG . 'includes/classes/database.php'); // make a connection to the database... now $lC_Database = lC_Database::connect(DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD); $lC_Database->selectDatabase(DB_DATABASE); // set the application parameters $Qcfg = $lC_Database->query('select configuration_key as cfgKey, configuration_value as cfgValue from :table_configuration'); $Qcfg->bindTable(':table_configuration', TABLE_CONFIGURATION); $Qcfg->setCache('configuration'); $Qcfg->execute(); while ($Qcfg->next()) { if (!defined($Qcfg->value('cfgKey'))) { define($Qcfg->value('cfgKey'), $Qcfg->value('cfgValue')); } } $Qcfg->freeResult(); // include functions require $lC_Vqmod->modCheck(DIR_FS_CATALOG . 'includes/functions/general.php'); require $lC_Vqmod->modCheck(DIR_FS_CATALOG . 'includes/functions/html_output.php');