- // SQL string to check for accounts
- $result_main = SQL_QUERY_ESC("SELECT userid, email, gender, surname, family, (turbo_bonus + login_bonus + bonus_order + bonus_stats + bonus_ref) AS points
-FROM "._MYSQL_PREFIX."_user_data
-".$whereStatement1."".$ADD."
-ORDER BY active_bonus DESC, userid LIMIT %s",
- array($whereStatement2), __FILE__, __LINE__);
+ // Run SQL string to check for accounts
+ $result_main = SQL_QUERY('SELECT
+ `userid`, `email`, `gender`, `surname`, `family`, (0' . $add . ') AS points
+FROM
+ `{?_MYSQL_PREFIX?}_user_data`
+' . $whereStatement1 . '
+ORDER BY
+ `points` DESC,
+ `userid` ASC
+LIMIT {?bonus_ranks?}', __FILE__, __LINE__);