die();
} elseif ((!isExtensionActive('autopurge')) || (!isAutoPurgingActive())) {
// Abort here
- return false;
+ return FALSE;
}
if (getAutoPurge() > 0) {
// Then check for outdated mail order. We don't delete them just the confirmation links will be deleted.
$result = SQL_QUERY('SELECT
- s.id, s.userid, s.pool_id, t.price
+ `s`.`id`,
+ `s`.`userid`,
+ `s`.`pool_id`,
+ `t`.`price`
FROM
- `{?_MYSQL_PREFIX?}_user_stats` AS s
+ `{?_MYSQL_PREFIX?}_user_stats` AS `s`
LEFT JOIN
- `{?_MYSQL_PREFIX?}_payments` AS t
+ `{?_MYSQL_PREFIX?}_payments` AS `t`
ON
- s.`payment_id`=t.`id`
+ `s`.`payment_id`=`t`.`id`
WHERE
- (UNIX_TIMESTAMP() - s.`timestamp_ordered`) >= {?auto_purge?}
+ (UNIX_TIMESTAMP() - `s`.`timestamp_ordered`) >= {?auto_purge?}
ORDER BY
- s.userid ASC', __FILE__, __LINE__);
+ `s`.`userid` ASC', __FILE__, __LINE__);
if (!SQL_HASZERONUMS($result)) {
// Start deleting procedure
$userid = NULL;
SQL_FREERESULT($result_links);
// At least one link was found, enougth to pay back the points
- if (($userid != $content['userid']) && (isValidUserId($userid)) && ($points > 0)) {
+ if (($userid != $content['userid']) && (isValidId($userid)) && ($points > 0)) {
// Directly add points back to senders account
addPointsAutoPurge($userid, $points);
$points = '0';
// Remove confirmation links from queue
addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `stats_id`=%s",
- array(bigintval($content['id'])), __FILE__, __LINE__, false));
+ array(bigintval($content['id'])), __FILE__, __LINE__, FALSE));
// Update status of order
addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_pool` SET `data_type`='DELETED' WHERE `id`=%s LIMIT 1",
- array(bigintval($content['pool_id'])), __FILE__, __LINE__, false));
+ array(bigintval($content['pool_id'])), __FILE__, __LINE__, FALSE));
} // END - if
} // END - while
SQL_FREERESULT($result);
// Is the 'bonus' extension installed and activated?
- if (isExtensionActive('bonus', true)) {
+ if (isExtensionActive('bonus', TRUE)) {
// Check for bonus campaigns
$result = SQL_QUERY("SELECT `id`, `points` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `data_type`='SEND' AND `timestamp` <= {?auto_purge?} ORDER BY `id` ASC", __FILE__, __LINE__);
if (!SQL_HASZERONUMS($result)) {
// Remove confirmation links from queue
addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `bonus_id`=%s",
- array(bigintval($content['id'])), __FILE__, __LINE__, false));
+ array(bigintval($content['id'])), __FILE__, __LINE__, FALSE));
// Update status of order
addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_bonus` SET `data_type`='DELETED' WHERE `id`=%s LIMIT 1",
- array(bigintval($content['id'])), __FILE__, __LINE__, false));
+ array(bigintval($content['id'])), __FILE__, __LINE__, FALSE));
} // END - if
} // END - while