// 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__);
// Do we have "purged" mails?
if (SQL_NUMROWS($result_mails) > 0) {
// Okay, check for their sender's
- while(list($sender) = SQL_FETCHROW($result_mails)) {
+ 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__);
// Do we have "purged" mails?
if (SQL_NUMROWS($result_mails) > 0) {
// Okay, check for their sender's
- while(list($sender) = SQL_FETCHROW($result_mails)) {
+ 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__);