function zen_visitors_purchase_clean_up_visitors_ordrs() { global $db; if (defined('MODULE_VISITORS_PURCHASE_ORDERS_DATA_KEEP_DAYS') && trim(MODULE_VISITORS_PURCHASE_ORDERS_DATA_KEEP_DAYS) != '') { $query = "\r\n select\r\n orders_id, visitors_id, last_modified, date_purchased\r\n from\r\n " . TABLE_VISITORS_ORDERS . "\r\n where\r\n date_purchased < subdate(now(),INTERVAL " . MODULE_VISITORS_PURCHASE_ORDERS_DATA_KEEP_DAYS . " DAY)\r\n and (\r\n last_modified is null\r\n or last_modified < subdate(now(),INTERVAL " . MODULE_VISITORS_PURCHASE_ORDERS_DATA_KEEP_DAYS . " DAY)\r\n )\r\n ;"; $result = $db->Execute($query); while (!$result->EOF) { zen_remove_order($result->fields['orders_id'], false); zen_visitors_purchase_delete_visitors_order($result->fields['orders_id']); $result->MoveNext(); } } }
/** * visitors purchase modules init admin file * see {@link http://www.zen-cart.com/wiki/index.php/Developers_API_Tutorials#InitSystem wikitutorials} for more details. * * @package initSystem * @copyright Portions Copyright 2003-2005 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0 * @version $Id: init_admin.php $ */ if (!defined('IS_ADMIN_FLAG')) { die('Illegal Access'); } zen_visitors_purchase_clean_up_visitors_ordrs(); if (basename($PHP_SELF) == FILENAME_ORDERS . '.php') { switch ($_GET['action']) { case 'update_order': // demo active test if (!zen_admin_demo()) { zen_visitors_purchase_update_visitors_order($_GET['oID']); } break; case 'deleteconfirm': // demo active test if (!zen_admin_demo()) { zen_visitors_purchase_delete_visitors_order($_GET['oID']); } break; } }