Execute("select p.products_id, pa.products_attributes_id from " .
TABLE_PRODUCTS . " p, " .
TABLE_PRODUCTS_ATTRIBUTES . " pa " . "
where p.products_id= pa.products_id"
);
while (!$all_products_attributes->EOF)
{
$count++;
$product_id_updated .= ' - ' . $all_products_attributes->fields['products_id'] . ':' . $all_products_attributes->fields['products_attributes_id'];
zen_update_attributes_products_option_values_sort_order($all_products_attributes->fields['products_id']);
$all_products_attributes->MoveNext();
}
$messageStack->add_session(SUCCESS_PRODUCT_UPDATE_SORT_ALL, 'success');
$action='';
zen_redirect(zen_href_link(FILENAME_STORE_MANAGER));
}
break;
case ('update_all_products_price_sorter'):
if (isset($_POST['confirm']) && $_POST['confirm'] == 'yes')
{
// reset products_price_sorter for searches etc.
$sql = "select products_id from " . TABLE_PRODUCTS;
$update_prices = $db->Execute($sql);
while (!$update_prices->EOF)
{
zen_update_products_price_sorter($update_prices->fields['products_id']);
$update_prices->MoveNext();
}
$messageStack->add_session(SUCCESS_PRODUCT_UPDATE_PRODUCTS_PRICE_SORTER, 'success');
$action='';
zen_redirect(zen_href_link(FILENAME_STORE_MANAGER));
}
break;
case ('update_all_products_viewed'):
// reset products_viewed to 0
if (isset($_POST['confirm']) && $_POST['confirm'] == 'yes')
{
$sql = "update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed= '0'";
$update_viewed = $db->Execute($sql);
$messageStack->add_session(SUCCESS_PRODUCT_UPDATE_PRODUCTS_VIEWED, 'success');
$action='';
zen_redirect(zen_href_link(FILENAME_STORE_MANAGER));
}
break;
case ('update_all_products_ordered'):
if (isset($_POST['confirm']) && $_POST['confirm'] == 'yes')
{
// reset products_ordered to 0
$sql = "update " . TABLE_PRODUCTS . " set products_ordered= '0'";
$update_viewed = $db->Execute($sql);
$messageStack->add_session(SUCCESS_PRODUCT_UPDATE_PRODUCTS_ORDERED, 'success');
$action='';
zen_redirect(zen_href_link(FILENAME_STORE_MANAGER));
}
break;
case ('update_counter'):
if ($_POST['new_counter'] == '' || strval($_POST['new_counter']) != strval((int)$_POST['new_counter'])) break;
$sql = "update " . TABLE_COUNTER . " set counter= '" . (int)$_POST['new_counter'] . "'";
$update_counter = $db->Execute($sql);
$messageStack->add_session(SUCCESS_UPDATE_COUNTER . (int)$_POST['new_counter'], 'success');
$action='';
zen_redirect(zen_href_link(FILENAME_STORE_MANAGER));
break;
case ('optimize_db_start'):
$processing_message = TEXT_INFO_OPTIMIZING_DATABASE_TABLES;
$processing_action_url = zen_href_link(FILENAME_STORE_MANAGER, 'action=optimize_db_do');
break;
case ('optimize_db_do'):
// clean out unused space in database
if (isset($_POST['confirm']) && $_POST['confirm'] == 'yes')
{
$sql = "SHOW TABLE STATUS FROM `" . DB_DATABASE ."`";
$tables = $db->Execute($sql);
while(!$tables->EOF) {
// skip tables not matching prefixes
if (DB_PREFIX != '' && substr($tables->fields['Name'], 0, strlen(DB_PREFIX)) != DB_PREFIX) {
$tables->MoveNext();
continue;
}
zen_set_time_limit(600);
$db->Execute("OPTIMIZE TABLE `" . $tables->fields['Name'] . "`");
$i++;
if ($i/7 == (int)($i/7)) sleep(2);
$tables->MoveNext();
}
$messageStack->add_session(SUCCESS_DB_OPTIMIZE . ' ' . $i, 'success');
$action='';
zen_redirect(zen_href_link(FILENAME_STORE_MANAGER));
}
break;
// clean out old DEBUG logfiles
case 'clean_debug_files':
foreach(array(DIR_FS_LOGS, DIR_FS_SQL_CACHE, DIR_FS_CATALOG . '/includes/modules/payment/paypal/logs') as $purgeFolder) {
$purgeFolder = rtrim($purgeFolder, '/');
$dir = dir($purgeFolder);
while ($file = $dir->read()) {
if ( ($file != '.') && ($file != '..') && substr($file, 0, 1) != '.') {
if (preg_match('/^(myDEBUG-|AIM_Debug_|SIM_Debug_|FirstData_Debug_|Linkpoint_Debug_|Paypal|paypal|ipn_|zcInstall).*\.log$/', $file)) {
if (is_writeable($purgeFolder . '/' . $file)) {
zen_remove($purgeFolder . '/' . $file);
}
}
}
}
$dir->close();
unset($dir);
}
$messageStack->add_session(SUCCESS_CLEAN_DEBUG_FILES, 'success');
zen_redirect(zen_href_link(FILENAME_STORE_MANAGER));
break;
case ('update_all_master_categories_id'):
// reset products master categories ID
if (isset($_POST['confirm']) && $_POST['confirm'] == 'yes')
{
$sql = "select products_id from " . TABLE_PRODUCTS;
$check_products = $db->Execute($sql);
while (!$check_products->EOF) {
$sql = "select products_id, categories_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id='" . $check_products->fields['products_id'] . "'";
$check_category = $db->Execute($sql);
$sql = "update " . TABLE_PRODUCTS . " set master_categories_id='" . $check_category->fields['categories_id'] . "' where products_id='" . $check_products->fields['products_id'] . "'";
$update_viewed = $db->Execute($sql);
$check_products->MoveNext();
}
$messageStack->add_session(SUCCESS_UPDATE_ALL_MASTER_CATEGORIES_ID, 'success');
$action='';
zen_redirect(zen_href_link(FILENAME_STORE_MANAGER));
}
break;
case ('update_orders_id'):
global $db;
$new_orders_id = zen_db_prepare_input((int)$_POST['new_orders_id']);
$result = $db->Execute("select max(orders_id) as maxorder from " . TABLE_ORDERS);
$max_order1 = $result->fields['maxorder'];
$result = $db->Execute("select max(orders_id) as maxorder from " . TABLE_ORDERS_PRODUCTS);
$max_order2 = $result->fields['maxorder'];
if ($new_orders_id <= $max_order1 || $new_orders_id <= $max_order2)
{
$new_orders_id = max($max_order1, $max_order2) + 1;
$messageStack->add_session(sprintf(TEXT_MSG_NEXT_ORDER_MAX, $new_orders_id), 'caution');
} elseif ($new_orders_id > 2000000000) {
$messageStack->add_session(TEXT_MSG_NEXT_ORDER_TOO_LARGE, 'error');
} else {
$db->Execute("ALTER TABLE " . TABLE_ORDERS . " AUTO_INCREMENT = " . $new_orders_id);
$messageStack->add_session(sprintf(TEXT_MSG_NEXT_ORDER, $new_orders_id), 'success');
}
zen_redirect(zen_href_link(FILENAME_STORE_MANAGER));
break;
} // eof: action
?>
>
'; ?>
|
|
|
|
|
|
|
|
|
|
|
|
|
' . zen_draw_separator('pixel_black.gif', '100%', '2'); ?> |
|