if (($curr != getConfig('last_month')) && (getConfig('bonus_ranks') > 0) && ($CSS != 1)) {
// Extension "autopurge" is inactive or purging of inactive accounts is deactivated
- $whereStatement1 = "WHERE status='CONFIRMED'";
+ $whereStatement1 = "WHERE `status`='CONFIRMED'";
$whereStatement2 = bigintval(getConfig('bonus_ranks'));
// Shall I keep inactive members away from here? (mostly wanted in an "active-rallye" ...)
// Use last online stamp only when autopurge for inactive members is activated
if (getConfig('ap_inactive_since') > 0) {
// Okay, include last online timestamp
- $whereStatement1 = sprintf("WHERE status='CONFIRMED' AND last_online >= (UNIX_TIMESTAMP() - %s)", getConfig('ap_inactive_since'));
+ $whereStatement1 = sprintf("WHERE `status`='CONFIRMED' AND last_online >= (UNIX_TIMESTAMP() - %s)", getConfig('ap_inactive_since'));
$whereStatement2 = bigintval(getConfig('bonus_ranks'));
} // END - if
} // END - if
// Run SQL string to check for accounts
$result_main = SQL_QUERY_ESC("SELECT userid, email, gender, surname, family, (0".$ADD.") AS points
-FROM "._MYSQL_PREFIX."_user_data
+FROM `{!_MYSQL_PREFIX!}_user_data`
".$whereStatement1."".$ADD."
ORDER BY points DESC, userid
LIMIT %s",
} // END - while
// Reset accounts
- $result = SQL_QUERY("UPDATE "._MYSQL_PREFIX."_user_data
+ $result = SQL_QUERY("UPDATE `{!_MYSQL_PREFIX!}_user_data`
SET turbo_bonus=0, login_bonus=0, bonus_order=0, bonus_stats=0, bonus_ref=0", __FILE__, __LINE__);
} // END - if