// Then check for outdated mail order. We don't delete them just the confirmation links will be deleted.
$result = SQL_QUERY_ESC("SELECT s.id, s.userid, s.pool_id, t.price
// Then check for outdated mail order. We don't delete them just the confirmation links will be deleted.
$result = SQL_QUERY_ESC("SELECT s.id, s.userid, s.pool_id, t.price
while(list($mid, $sender, $pool, $price) = SQL_FETCHROW($result))
{
// Check if confirmation links are purged or not
while(list($mid, $sender, $pool, $price) = SQL_FETCHROW($result))
{
// Check if confirmation links are purged or not
{
// Directly add points back to senders account
AUTOPURGE_ADD_POINTS($uid, $points);
{
// Directly add points back to senders account
AUTOPURGE_ADD_POINTS($uid, $points);
while (list($bid, $price) = SQL_FETCHROW($result))
{
// Check if confirmation links are purged or not
while (list($bid, $price) = SQL_FETCHROW($result))
{
// Check if confirmation links are purged or not
// Okay, let's check for them...
$since = bigintval(time() - $_CONFIG['ap_dm_timeout']);
$result_mails = SQL_QUERY_ESC("SELECT sender FROM "._MYSQL_PREFIX."_pool WHERE data_type='DELETED' AND timestamp <= %s ORDER BY sender",
// Okay, let's check for them...
$since = bigintval(time() - $_CONFIG['ap_dm_timeout']);
$result_mails = SQL_QUERY_ESC("SELECT sender FROM "._MYSQL_PREFIX."_pool WHERE data_type='DELETED' AND timestamp <= %s ORDER BY sender",
// Check now...
$fount = SQL_NUMROWS(SQL_QUERY_ESC("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE userid=%s LIMIT 1", array(bigintval($sender)), __FILE__, __LINE__));
// Check now...
$fount = SQL_NUMROWS(SQL_QUERY_ESC("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE userid=%s LIMIT 1", array(bigintval($sender)), __FILE__, __LINE__));
// Okay we found some mails!
$result_remove = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_pool WHERE sender=%s",
array(bigintval($sender)), __FILE__, __LINE__);
// Okay we found some mails!
$result_remove = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_pool WHERE sender=%s",
array(bigintval($sender)), __FILE__, __LINE__);
array($since), __FILE__, __LINE__);
// Do we have "purged" mails?
array($since), __FILE__, __LINE__);
// Do we have "purged" mails?
// Check now...
$found = SQL_NUMROWS(SQL_QUERY_ESC("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE userid=%s LIMIT 1", array(bigintval($sender)), __FILE__, __LINE__));
// Check now...
$found = SQL_NUMROWS(SQL_QUERY_ESC("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE userid=%s LIMIT 1", array(bigintval($sender)), __FILE__, __LINE__));
// Okay we found some mails!
$result_remove = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_stats WHERE sender=%s", array(bigintval($sender)), __FILE__, __LINE__);
$DELETED += SQL_AFFECTEDROWS();
// Okay we found some mails!
$result_remove = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_stats WHERE sender=%s", array(bigintval($sender)), __FILE__, __LINE__);
$DELETED += SQL_AFFECTEDROWS();
SQL_FREERESULT($result_mails);
// Do we have deleted mails and the admin want's to receive a notification
SQL_FREERESULT($result_mails);
// Do we have deleted mails and the admin want's to receive a notification
// Send out email to admin
SEND_ADMIN_NOTIFICATION(AUTOPURGE_ADMIN_DEL_MAILS_SUBJECT, "admin_autopurge_del_mails", $DELETED, "");
}
}
// Send out email to admin
SEND_ADMIN_NOTIFICATION(AUTOPURGE_ADMIN_DEL_MAILS_SUBJECT, "admin_autopurge_del_mails", $DELETED, "");
}
}
// Check expired rallyes (hard-coded 3 days limit for displaying expired rallyes!)
require_once(PATH."inc/libs/rallye_functions.php");
RALLYE_DELETE_EXPIRED_RALLYES();
}
// Check expired rallyes (hard-coded 3 days limit for displaying expired rallyes!)
require_once(PATH."inc/libs/rallye_functions.php");
RALLYE_DELETE_EXPIRED_RALLYES();
}
// Check for expired turbo bonus lines
require_once(PATH."inc/libs/bonus_functions.php");
BONUS_PURGE_EXPIRED_TURBO_BONUS();
}
// Check for expired turbo bonus lines
require_once(PATH."inc/libs/bonus_functions.php");
BONUS_PURGE_EXPIRED_TURBO_BONUS();
}