Exemplos de zen_visitors_delete_visitor em PHP

Exemplo n.º 1

Arquivo: functions.php Projeto: homework-bazaar/zencart-sugu

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();
        }
    }
}

Exemplo n.º 2

Arquivo: module.php Projeto: homework-bazaar/zencart-sugu

 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();
         }
     }
 }