function zen_visitors_clean_up_visitors() { global $db; if (defined('MODULE_VISITORS_CUSTOMERS_DATA_KEEP_DAYS') && trim(MODULE_VISITORS_CUSTOMERS_DATA_KEEP_DAYS) != '') { $query = "\r\n select\r\n visitors_id, visitors_email_address,\r\n visitors_info_date_account_created,\r\n visitors_info_date_account_last_modified\r\n from\r\n " . TABLE_VISITORS . "\r\n where\r\n visitors_info_date_account_created < subdate(now(),INTERVAL " . MODULE_VISITORS_CUSTOMERS_DATA_KEEP_DAYS . " DAY)\r\n and (\r\n visitors_info_date_account_last_modified is null\r\n or visitors_info_date_account_last_modified < subdate(now(),INTERVAL " . MODULE_VISITORS_CUSTOMERS_DATA_KEEP_DAYS . " DAY)\r\n )\r\n ;"; $result = $db->Execute($query); while (!$result->EOF) { zen_visitors_delete_visitor($result->fields['visitors_id']); $result->MoveNext(); } } }
function _cleanUpVisitors() { global $db; if (isset($_POST['email_address']) && $_POST['email_address'] != '') { $email_address = zen_db_prepare_input($_POST['email_address']); $query = "\r\n select visitors_id\r\n from " . TABLE_VISITORS . "\r\n where visitors_email_address = :email\r\n ;"; $query = $db->bindVars($query, ':email', $email_address, 'string'); $result = $db->Execute($query); while (!$result->EOF) { zen_visitors_delete_visitor($result->fields['visitors_id']); $result->moveNext(); } } }