// Okay, let's check for them...
$since = bigintval(getConfig('ap_dm_timeout'));
$result_mails = SQL_QUERY_ESC("SELECT sender\
-FROM "._MYSQL_PREFIX."_pool
+FROM `{!MYSQL_PREFIX!}_pool`
WHERE data_type='DELETED' AND timestamp <= (UNIX_TIMESTAMP() - %s)
ORDER BY sender ASC",
array($since), __FILE__, __LINE__);
// Okay, check for their sender's
while(list($sender) = SQL_FETCHROW($result_mails)) {
// Check now...
- $fount = SQL_NUMROWS(SQL_QUERY_ESC("SELECT userid FROM `"._MYSQL_PREFIX."_user_data` WHERE userid=%s LIMIT 1",
+ $fount = SQL_NUMROWS(SQL_QUERY_ESC("SELECT userid FROM `{!MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1",
array(bigintval($sender)), __FILE__, __LINE__));
if ($found == 0) {
// Okay we found some mails!
- SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_pool WHERE sender=%s",
+ SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!MYSQL_PREFIX!}_pool` WHERE sender=%s",
array(bigintval($sender)), __FILE__, __LINE__);
$DELETED += SQL_AFFECTEDROWS();
// Reset query (to prevent possible errors) ...
$since = bigintval(getConfig('ap_dm_timeout'));
$result_mails = SQL_QUERY_ESC("SELECT sender
-FROM "._MYSQL_PREFIX."_pool
+FROM `{!MYSQL_PREFIX!}_pool`
WHERE data_type='DELETED' AND timestamp <= (UNIX_TIMESTAMP() - %s)
ORDER BY sender ASC",
array($since), __FILE__, __LINE__);
// Now let's check for stats entries as well
$since = bigintval(getConfig('ap_dm_timeout'));
$result_mails = SQL_QUERY_ESC("SELECT sender
-FROM "._MYSQL_PREFIX."_user_stats
+FROM `{!MYSQL_PREFIX!}_user_stats`
WHERE data_type='DELETED' AND timestamp_send <= (UNIX_TIMESTAMP() - %s)
ORDER BY sender ASC",
array($since), __FILE__, __LINE__);
// Okay, check for their sender's
while(list($sender) = SQL_FETCHROW($result_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__));
+ $found = SQL_NUMROWS(SQL_QUERY_ESC("SELECT userid FROM `{!MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1", array(bigintval($sender)), __FILE__, __LINE__));
if ($found == 0) {
// Okay we found some mails!
- SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_stats WHERE sender=%s", array(bigintval($sender)), __FILE__, __LINE__);
+ SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!MYSQL_PREFIX!}_user_stats` WHERE sender=%s", array(bigintval($sender)), __FILE__, __LINE__);
$DELETED += SQL_AFFECTEDROWS();
// Reset query (to prevent possible errors) ...
$since = bigintval(getConfig('ap_dm_timeout'));
$result_mails = SQL_QUERY_ESC("SELECT sender
-FROM "._MYSQL_PREFIX."_user_stats
+FROM `{!MYSQL_PREFIX!}_user_stats`
WHERE data_type='DELETED' AND timestamp_send <= (UNIX_TIMESTAMP() - %s)
ORDER BY sender ASC",
array($since), __FILE__, __LINE__);