// Purge expired transfer entries
function autoPurgeTransfers ($max, $age) {
// First get total in-going lines
- $result = SQL_QUERY('SELECT `id` FROM `{?_MYSQL_PREFIX?}_user_transfers_in` ORDER BY `id` ASC', __FUNCTION__, __LINE__);
- if (SQL_NUMROWS($result) > $max) {
+ $result = sqlQuery('SELECT `id` FROM `{?_MYSQL_PREFIX?}_user_transfers_in` ORDER BY `id` ASC', __FUNCTION__, __LINE__);
+ if (sqlNumRows($result) > $max) {
// Update overdue transfers
- $remove = SQL_NUMROWS($result) - $max;
+ $remove = sqlNumRows($result) - $max;
// This will make it really old, so the final removal query will find it
- $result = SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_transfers_in` SET `time_trans`=0 ORDER BY `id` ASC LIMIT %s",
+ $result = sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_user_transfers_in` SET `time_trans`=0 ORDER BY `id` ASC LIMIT %s",
array($remove), __FUNCTION__, __LINE__);
} // END - if
// Second get total out-going lines
- $result = SQL_QUERY('SELECT `id` FROM `{?_MYSQL_PREFIX?}_user_transfers_out` ORDER BY `id` ASC', __FUNCTION__, __LINE__);
- if (SQL_NUMROWS($result) > $max) {
+ $result = sqlQuery('SELECT `id` FROM `{?_MYSQL_PREFIX?}_user_transfers_out` ORDER BY `id` ASC', __FUNCTION__, __LINE__);
+ if (sqlNumRows($result) > $max) {
// Update overdue transfers
- $remove = SQL_NUMROWS($result) - $max;
+ $remove = sqlNumRows($result) - $max;
// This will make it really old, so the final removal query will find it
- $result = SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_transfers_out` SET `time_trans`=0 ORDER BY `id` ASC LIMIT %s",
+ $result = sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_user_transfers_out` SET `time_trans`=0 ORDER BY `id` ASC LIMIT %s",
array($remove), __FUNCTION__, __LINE__);
} // END - if
// Remove old in-going transfers
- $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_transfers_in` WHERE `time_trans` < (UNIX_TIMESTAMP() - %s)",
+ $result = sqlQueryEscaped("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_transfers_in` WHERE `time_trans` < (UNIX_TIMESTAMP() - %s)",
array($age), __FUNCTION__, __LINE__);
- $removed = SQL_AFFECTEDROWS();
+ $removed = sqlAffectedRows();
// Remove old out-going transfers
- $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_transfers_out` WHERE `time_trans` < (UNIX_TIMESTAMP() - %s)",
+ $result = sqlQueryEscaped("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_transfers_out` WHERE `time_trans` < (UNIX_TIMESTAMP() - %s)",
array($age), __FUNCTION__, __LINE__);
- $removed += SQL_AFFECTEDROWS();
+ $removed += sqlAffectedRows();
// Only send email to admin(s) when we have removed entries
if ($removed > 0) {