$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');
