} // END - if
// Add more bonus points here
- $ADD = "";
- if (getConfig('bonus_click_yn') == "Y") $ADD .= " + turbo_bonus";
- if (getConfig('bonus_login_yn') == "Y") $ADD .= " + login_bonus";
- if (getConfig('bonus_order_yn') == "Y") $ADD .= " + bonus_order";
- if (getConfig('bonus_stats_yn') == "Y") $ADD .= " + bonus_stats";
- if (getConfig('bonus_ref_yn') == "Y") $ADD .= " + bonus_ref";
+ $add = "";
+ if (getConfig('bonus_click_yn') == "Y") $add .= " + turbo_bonus";
+ if (getConfig('bonus_login_yn') == "Y") $add .= " + login_bonus";
+ if (getConfig('bonus_order_yn') == "Y") $add .= " + bonus_order";
+ if (getConfig('bonus_stats_yn') == "Y") $add .= " + bonus_stats";
+ if (getConfig('bonus_ref_yn') == "Y") $add .= " + bonus_ref";
// Shall we add some entries?
- if (!empty($ADD)) {
- $whereStatement1 .= " AND (0".$ADD.") > 0";
+ if (!empty($add)) {
+ $whereStatement1 .= " AND (0".$add.") > 0";
} // END - if
// Run SQL string to check for accounts
- $result_main = SQL_QUERY_ESC("SELECT userid, email, gender, surname, family, (0".$ADD.") AS points
+ $result_main = SQL_QUERY_ESC("SELECT userid, email, gender, surname, family, (0".$add.") AS points
FROM `{!_MYSQL_PREFIX!}_user_data`
-".$whereStatement1."".$ADD."
+".$whereStatement1."".$add."
ORDER BY points DESC, userid
LIMIT %s",
array($whereStatement2), __FILE__, __LINE__);