285 lines
11 KiB
PHP
285 lines
11 KiB
PHP
<?php
|
|
/*
|
|
+--------------------------------------------------------------------------
|
|
| CubeCart 4
|
|
| ========================================
|
|
| CubeCart is a registered trade mark of Devellion Limited
|
|
| Copyright Devellion Limited 2006. All rights reserved.
|
|
| Devellion Limited,
|
|
| 5 Bridge Street,
|
|
| Bishops Stortford,
|
|
| HERTFORDSHIRE.
|
|
| CM23 2JU
|
|
| UNITED KINGDOM
|
|
| http://www.devellion.com
|
|
| UK Private Limited Company No. 5323904
|
|
| ========================================
|
|
| Web: http://www.cubecart.com
|
|
| Email: info (at) cubecart (dot) com
|
|
| License Type: CubeCart is NOT Open Source Software and Limitations Apply
|
|
| Licence Info: http://www.cubecart.com/site/faq/license.php
|
|
+--------------------------------------------------------------------------
|
|
| rebuild.inc.php
|
|
| ========================================
|
|
| Used to rebuild/recount things
|
|
+--------------------------------------------------------------------------
|
|
*/
|
|
|
|
if(!defined('CC_INI_SET')){ die("Access Denied"); }
|
|
|
|
|
|
|
|
permission("maintenance", 'read', true);
|
|
|
|
$lang = getLang("admin".CC_DS."admin_misc.inc.php");
|
|
|
|
if($_GET['emptyTransLogs']==1) {
|
|
|
|
$truncate = $db->misc("TRUNCATE TABLE `".$glob['dbprefix']."CubeCart_transactions`");
|
|
|
|
if($truncate == TRUE) {
|
|
|
|
$msg = "<p class='infoText'>".$lang['admin']['misc_trans_logs_emptied']."</p>";
|
|
|
|
} else {
|
|
|
|
$msg = "<p class='warnText'>".$lang['admin']['misc_trans_logs_not_emptied']."</p>";
|
|
|
|
}
|
|
|
|
} elseif($_GET['clearCache']==1){
|
|
|
|
$cache = new cache();
|
|
$cache->clearCache();
|
|
|
|
$msg = "<p class='infoText'>".$lang['admin']['misc_cache_cleared']."</p>";
|
|
|
|
} elseif($_GET['removeKey']==1) {
|
|
|
|
$config = fetchDbConfig("config");
|
|
$newConfig = $config;
|
|
unset($newConfig['lk'],$newConfig['lkv']);
|
|
$msg = writeDbConf($newConfig,"config", $newConfig, TRUE);
|
|
unset($config);
|
|
$config = fetchDbConfig("config");
|
|
|
|
} elseif($_GET['uploadSize']==1) {
|
|
$dirArray = walkDir(CC_ROOT_DIR .CC_DS."images".CC_DS."uploads", true, 0, 0, false, $int = 0);
|
|
$size = 0;
|
|
|
|
if(is_array($dirArray)){
|
|
|
|
foreach($dirArray as $file) {
|
|
|
|
if(file_exists($file)){
|
|
$size = filesize($file) + $size;
|
|
}
|
|
|
|
}
|
|
|
|
}
|
|
|
|
$rebuild['uploadSize'] = $size;
|
|
$msg = writeDbConf($rebuild,"config", $config, true);
|
|
|
|
} else if ($_GET['catCount'] == 1) {
|
|
|
|
if ($config['cache']) {
|
|
## Purge the Cache
|
|
$cache = new cache();
|
|
$cache->clearCache();
|
|
$msg = "<p class='infoText'>".$lang['admin']['misc_cache_cleared']."</p>";
|
|
}
|
|
|
|
## Set the number of products in all categories to 0
|
|
$record['noProducts'] = 0;
|
|
$update = $db->update($glob['dbprefix'].'CubeCart_category', $record, '');
|
|
|
|
## Get all productId's from the database
|
|
$products = $db->select("SELECT productId FROM ".$glob['dbprefix']."CubeCart_inventory WHERE disabled = '0'");
|
|
|
|
## Get a list of all existing products from the inventory
|
|
if ($products) {
|
|
foreach ($products as $product) {
|
|
$currentProducts[] = $product['productId'];
|
|
}
|
|
|
|
## Delete all records from cats_idx where the productId is NOT in the inventory
|
|
$delQuery = sprintf("DELETE FROM %sCubeCart_cats_idx WHERE productId NOT IN (%s)", $glob['dbprefix'], implode(',', $currentProducts));
|
|
$db->misc($delQuery);
|
|
|
|
## Count the number of products in the cats_idx table by category
|
|
$countQuery = sprintf("SELECT COUNT(cat_id) as count, cat_id FROM %1\$sCubeCart_cats_idx WHERE cat_id IN(SELECT DISTINCT cat_id FROM %1\$sCubeCart_cats_idx WHERE 1) GROUP BY cat_id", $glob['dbprefix']);
|
|
$catCount = $db->select($countQuery);
|
|
|
|
foreach ($catCount as $category) {
|
|
## Set the number of products by category
|
|
$db->categoryNos($category['cat_id'], '+', $category['count']);
|
|
}
|
|
$msg .= "<p class='infoText'>".$lang['admin']['misc_cat_count_success']."</p>";
|
|
} else {
|
|
$msg .= "<p class='warnText'>".$lang['admin']['misc_cat_count_no_prod']."</p>";
|
|
}
|
|
|
|
} else if ($_GET['prodViews'] == 1) {
|
|
|
|
|
|
$msg = "";
|
|
|
|
if ($config['cache']==true) {
|
|
|
|
$cache = new cache();
|
|
$cache->clearCache();
|
|
|
|
$msg = "<p class='infoText'>".$lang['admin']['misc_cache_cleared']."</p>";
|
|
|
|
}
|
|
|
|
// set noProducts in all categories to 0
|
|
$record['popularity'] = $db->mySQLSafe(0);
|
|
$update = $db->update($glob['dbprefix']."CubeCart_inventory", $record, $where="");
|
|
|
|
if($update == TRUE) {
|
|
|
|
$msg .= "<p class='infoText'>".$lang['admin']['misc_prod_views_zero']."</p>";
|
|
|
|
} else {
|
|
|
|
$msg .= "<p class='warnText'>".$lang['admin']['misc_prod_views_not_reset']."</p>";
|
|
|
|
}
|
|
|
|
} elseif($_GET['clearSearch']==1) {
|
|
// set noProducts in all categories to 0
|
|
$truncate = $db->misc("TRUNCATE TABLE `".$glob['dbprefix']."CubeCart_search`");
|
|
|
|
if($truncate == TRUE) {
|
|
|
|
$msg = "<p class='infoText'>".$lang['admin']['misc_search_terms_reset']."</p>";
|
|
|
|
} else {
|
|
|
|
$msg = "<p class='warnText'>".$lang['admin']['misc_search_terms_not_reset']."</p>";
|
|
|
|
}
|
|
|
|
} elseif($_GET['orderCount']==1) {
|
|
// set noOrders for all products to 0
|
|
$record['noOrders'] = $db->mySQLSafe(0);
|
|
$update = $db->update($glob['dbprefix']."CubeCart_customer", $record, $where="");
|
|
|
|
// get all customers
|
|
$customers = $db->select("SELECT * FROM ".$glob['dbprefix']."CubeCart_customer");
|
|
|
|
if($customers==TRUE){
|
|
for ($i=0; $i<count($customers); $i++){
|
|
$noOrders = $db->numrows("SELECT * FROM ".$glob['dbprefix']."CubeCart_order_sum WHERE customer_id=".$db->mySQLSafe($customers[$i]['customer_id']));
|
|
$record['noOrders'] = $noOrders;
|
|
$result = $db->update($glob['dbprefix']."CubeCart_customer", $record, "customer_id=".$db->mySQLSafe($customers[$i]['customer_id']));
|
|
|
|
}
|
|
|
|
$msg = "<p class='infoText'>".$lang['admin']['misc_customers_orders_counted']."</p>";
|
|
} else {
|
|
$msg = "<p class='warnText'>".$lang['admin']['misc_no_customers_exist']."</p>";
|
|
}
|
|
|
|
} else if ($_GET['thumbs'] == 1) {
|
|
$path = CC_ROOT_DIR .CC_DS."images".CC_DS."uploads".CC_DS."thumbs";
|
|
$dirArray = walkDir($path, false, 0, 0, false, $int = 0);
|
|
unset($dirArray['max']);
|
|
if (is_array($dirArray)) {
|
|
foreach ($dirArray as $file) {
|
|
$masterFilename = str_replace(CC_ROOT_DIR .CC_DS."images".CC_DS."uploads".CC_DS."thumbs".CC_DS."thumb_","",$file);
|
|
// delete files that dont contain thumb_
|
|
if (!ereg("thumb_",$file)) {
|
|
unlink($file);
|
|
} else if (!file_exists(CC_ROOT_DIR .CC_DS."images".CC_DS."uploads".CC_DS. $masterFilename)) {
|
|
unlink($file);
|
|
}
|
|
}
|
|
$msg = "<p class='infoText'>".$lang['admin']['misc_redundant_thumbs_gone']."</p>";
|
|
} else {
|
|
$msg = "<p class='warnText'>".$lang['admin']['misc_thumbs_folder_empty']."</p>";
|
|
}
|
|
|
|
} else if ($_GET['clearLogs'] == 1) {
|
|
$sql = sprintf("TRUNCATE TABLE %sCubeCart_admin_log", $glob['dbprefix']);
|
|
$db->misc($sql);
|
|
|
|
$msg = '<p class="warnText">'.$lang['admin']['misc_clear_logs_empty'].'</p>';
|
|
|
|
} else if ($_GET['clearSession'] == 1) {
|
|
$sql = sprintf('TRUNCATE TABLE %sCubeCart_admin_sessions', $glob['dbprefix']);
|
|
$db->misc($sql);
|
|
|
|
$msg = '<p class="warnText">'.$lang['admin']['misc_clear_sessions_empty'].'</p>';
|
|
}
|
|
|
|
require $glob['adminFolder'].CC_DS."includes".CC_DS."header.inc.php";
|
|
|
|
?>
|
|
<p class="pageTitle"><?php echo $lang['admin']['misc_title_recount']; ?></p>
|
|
|
|
<?php if (isset($msg)) echo msg($msg); ?>
|
|
<table border="0" cellspacing="1" cellpadding="3" class="mainTable">
|
|
<tr>
|
|
<td class="tdTitle" colspan="2"><?php echo $lang['admin']['misc_operation']; ?></td>
|
|
</tr>
|
|
<tr>
|
|
<td class="tdText"><?php echo $lang['admin']['misc_recalculate_upload_size']; ?></td>
|
|
<td class="tdText"><input name="button" type="button" value="<?php echo $lang['admin_common']['update'];?>" class="submit" onclick="goToURL('parent','<?php echo $glob['adminFile']; ?>?_g=maintenance/rebuild&uploadSize=1');return document.returnValue" /></td>
|
|
</tr>
|
|
<tr>
|
|
<td class="tdText"><?php echo $lang['admin']['misc_recalc_cat_prod_count']; ?></td>
|
|
<td class="tdText"><input name="button" type="button" value="<?php echo $lang['admin_common']['update'];?>" class="submit" onclick="goToURL('parent','<?php echo $glob['adminFile']; ?>?_g=maintenance/rebuild&catCount=1');return document.returnValue" /></td>
|
|
</tr>
|
|
<tr>
|
|
<td class="tdText"><?php echo $lang['admin']['misc_rebuild_no_cust_orders']; ?></td>
|
|
<td class="tdText"><input name="button" type="button" value="<?php echo $lang['admin_common']['update'];?>" class="submit" onclick="goToURL('parent','<?php echo $glob['adminFile']; ?>?_g=maintenance/rebuild&orderCount=1');return document.returnValue" /></td>
|
|
</tr>
|
|
<tr>
|
|
<td class="tdText"><?php echo $lang['admin']['misc_reset_prod_views']; ?></td>
|
|
<td class="tdText"><input name="button" type="button" value="<?php echo $lang['admin_common']['update'];?>" class="submit" onclick="goToURL('parent','<?php echo $glob['adminFile']; ?>?_g=maintenance/rebuild&prodViews=1');return document.returnValue" /></td>
|
|
</tr>
|
|
<tr>
|
|
<td class="tdText"><?php echo $lang['admin']['misc_del_orphaned_thumbs']; ?></td>
|
|
<td class="tdText"><input name="button" type="button" value="<?php echo $lang['admin_common']['update'];?>" class="submit" onclick="goToURL('parent','<?php echo $glob['adminFile']; ?>?_g=maintenance/rebuild&thumbs=1');return document.returnValue" /></td>
|
|
</tr>
|
|
<tr>
|
|
<td class="tdText"><?php echo $lang['admin']['misc_clear_search_cache']; ?><strong></strong></td>
|
|
<td class="tdText"><input name="button" type="button" value="<?php echo $lang['admin_common']['update'];?>" class="submit" onclick="goToURL('parent','<?php echo $glob['adminFile']; ?>?_g=maintenance/rebuild&clearSearch=1');return document.returnValue" /></td>
|
|
</tr>
|
|
|
|
<tr>
|
|
<td class="tdText"><?php echo $lang['admin']['misc_clear_logs']; ?><strong></strong></td>
|
|
<td class="tdText"><input name="button" type="button" value="<?php echo $lang['admin_common']['update'];?>" class="submit" onclick="goToURL('parent','<?php echo $glob['adminFile']; ?>?_g=maintenance/rebuild&clearLogs=1');return document.returnValue" /></td>
|
|
</tr>
|
|
<tr>
|
|
<td class="tdText"><?php echo $lang['admin']['misc_clear_sessions']; ?><strong></strong></td>
|
|
<td class="tdText"><input name="button" type="button" value="<?php echo $lang['admin_common']['update'];?>" class="submit" onclick="goToURL('parent','<?php echo $glob['adminFile']; ?>?_g=maintenance/rebuild&clearSession=1');return document.returnValue" /></td>
|
|
</tr>
|
|
|
|
<?php if (isset($config['lkv']) && $config['lkv']>0 && ereg("^([0-9]{6})+[-]+([0-9])+[-]+([0-9]{4})$",$config['lk'])) { ?>
|
|
<tr>
|
|
<td class="tdText"><?php echo $lang['admin']['misc_remove_copy_key'];?></td>
|
|
<td class="tdText">
|
|
<input name="button" type="button" value="<?php echo $lang['admin_common']['remove'];?>" class="submit" onclick="goToURL('parent','<?php echo $glob['adminFile']; ?>?_g=maintenance/rebuild&removeKey=1');return document.returnValue" />
|
|
</td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
if ($config['cache'] ==1) {
|
|
?>
|
|
<tr>
|
|
<td class="tdText"><?php echo $lang['admin']['misc_clear_sql_cache'];?></td>
|
|
<td class="tdText"><input name="button" type="button" value="<?php echo $lang['admin_common']['update'];?>" class="submit" onclick="goToURL('parent','<?php echo $glob['adminFile']; ?>?_g=maintenance/rebuild&clearCache=1');return document.returnValue" /></td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
<tr>
|
|
<td class="tdText"><?php echo $lang['admin']['misc_empty_translogs']; ?><strong></strong></td>
|
|
<td class="tdText"><input name="button" type="button" value="<?php echo $lang['admin_common']['update'];?>" class="submit" onclick="goToURL('parent','<?php echo $glob['adminFile']; ?>?_g=maintenance/rebuild&emptyTransLogs=1');return document.returnValue" /></td>
|
|
</tr>
|
|
</table>
|