$ranks = count(explode(';', getConfig('turbo_rates'))) + 1;
// Load current user's data
- $result = SQL_QUERY_ESC("SELECT level, points, timemark FROM `{!_MYSQL_PREFIX!}_bonus_turbo` WHERE %s=%s AND userid=%s LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT level, points, timemark FROM `{!_MYSQL_PREFIX!}_bonus_turbo` WHERE %s=%s AND `userid`=%s LIMIT 1",
array($type, $data, $uid), __FUNCTION__, __LINE__);
if (SQL_NUMROWS($result) == 1) {
// Load data
list($rank, $points, $mark) = SQL_FETCHROW($result);
// Remember all values for later use
- $self = true; $points = TRANSLATE_COMMA($points);
+ $self = true; $points = translateComma($points);
// Transfer data to template
define('__YR_LEVEL' , $rank);
define('__YR_POINTS', $points);
- define('__YR_TMARK' , MAKE_DATETIME($mark, "1"));
+ define('__YR_TMARK' , generateDateTime($mark, "1"));
// Load template
define('__YOUR_RANKING_LINE', LOAD_TEMPLATE("show_bonus_yr", true));
} // END - if
// Load rankings
- $result = SQL_QUERY_ESC("SELECT id FROM `{!_MYSQL_PREFIX!}_bonus_turbo` WHERE %s=%s ORDER BY level LIMIT %s",
+ $result = SQL_QUERY_ESC("SELECT `id` FROM `{!_MYSQL_PREFIX!}_bonus_turbo` WHERE %s=%s ORDER BY level LIMIT %s",
array($type, $data, getConfig('bonus_lines')), __FUNCTION__, __LINE__);
if (SQL_NUMROWS($result) > 0) {
// Start generating the ranking list
list($userid, $points, $mark) = SQL_FETCHROW($result_users);
// Translate comma
- $points = TRANSLATE_COMMA($points);
+ $points = translateComma($points);
} // END - if
// Output row
if (getConfig('bonus_active') != 'Y') return;
// Switch to jackpot-mode when no UID is supplied but userid-mode is selected
- if ((getConfig('bonus_mode') == "UID") && (getConfig('bonus_uid') == "0")) {
+ if ((getConfig('bonus_mode') == "UID") && (getConfig('bonus_uid') == '0')) {
// Update database & config
- UPDATE_CONFIG('bonus_mode', "JACKPOT");
+ updateConfiguration('bonus_mode', 'JACKPOT');
} // END - if
if ($mode == "login_bonus") {
// Subtract points from...
switch (getConfig('bonus_mode'))
{
- case "JACKPOT": // ... jackpot
+ case 'JACKPOT': // ... jackpot
if ((SUB_JACKPOT($points) == -1) && (getConfig('bonus_uid') > 0)) {
// Check points amount first...
$total = GET_TOTAL_DATA(getConfig('bonus_uid'), "user_points", "points") - GET_TOTAL_DATA(getConfig('bonus_uid'), "user_data", "used_points");
$result = SQL_QUERY("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_bonus_turbo` WHERE timemark < (UNIX_TIMESTAMP() - ".getConfig('bonus_timeout').")", __FUNCTION__, __LINE__);
if (SQL_AFFECTEDROWS() > 0) {
// Send out email to admin
- SEND_ADMIN_NOTIFICATION(AUTOPURGE_ADMIN_TURBO_SUBJECT, "admin_autopurge_turbo", SQL_AFFECTEDROWS(), '');
+ sendAdminNotification(AUTOPURGE_ADMIN_TURBO_SUBJECT, "admin_autopurge_turbo", SQL_AFFECTEDROWS(), '');
}
}
//