// 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 = "WHERE `status`='CONFIRMED' AND `last_online` >= (UNIX_TIMESTAMP() - {?ap_inactive_since?})";
$whereStatement2 = getConfig('bonus_ranks');
} // END - if
} // END - if
`points` DESC,
`userid` ASC
LIMIT %s",
- array($whereStatement2), __FILE__, __LINE__);
+ array($whereStatement2), __FILE__, __LINE__);
// Some entries were found?
if (SQL_NUMROWS($result_main) > 0) {
addPointsDirectly('monthly_bonus', $content['userid'], $content['points']);
// Translate gender/points
- $content['gender'] = translateGender($content['gender']);
+ $content['gender'] = translateGender($content['gender']);
$content['points'] = translateComma($content['points']);
// Load email template and email it away
} // END - while
// Reset accounts
- $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__);
+ $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
// Free memory