X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Flibs%2Fbonus_functions.php;h=058770d3252916309fc60051333caa557b2a3d63;hb=b8c86fa12322603c24a88ea2b0fd3dbeba612752;hp=c428208c1192a99e4055a3c5d97f22d01e994f70;hpb=cca98f57dff720b174d21d071cee8303462485d7;p=mailer.git diff --git a/inc/libs/bonus_functions.php b/inc/libs/bonus_functions.php index c428208c11..058770d325 100644 --- a/inc/libs/bonus_functions.php +++ b/inc/libs/bonus_functions.php @@ -38,11 +38,9 @@ if (!defined('__SECURITY')) { } // This function must be run *BEFORE* a link is removed from table 'mxchange_user_links' ! -function BONUS_ADD_TURBO_POINTS($mid, $uid, $type) { - global $_CONFIG; - +function BONUS_ADD_TURBO_POINTS ($mid, $uid, $type) { // Shall we add bonus points? - if (getConfig('bonus_active') == "N") return false; + if (getConfig('bonus_active') != "Y") return false; // Init variables $SQL = ""; $bonys = 0; $mail = 0; $column = ""; @@ -72,8 +70,8 @@ function BONUS_ADD_TURBO_POINTS($mid, $uid, $type) { } // END - if // Check for entry - $result = SQL_QUERY_ESC("SELECT COUNT(id) AS cnt FROM `{!MYSQL_PREFIX!}_bonus_turbo` WHERE userid=%s AND %s=%s LIMIT 1", - array($uid, $column, $mid), __FILE__, __LINE__); + $result = SQL_QUERY_ESC("SELECT COUNT(id) AS cnt FROM `{!_MYSQL_PREFIX!}_bonus_turbo` WHERE userid=%s AND %s=%s LIMIT 1", + array($uid, $column, $mid), __FUNCTION__, __LINE__); // Load clicks from table as current rank list($rank) = SQL_FETCHROW($result); @@ -101,26 +99,25 @@ function BONUS_ADD_TURBO_POINTS($mid, $uid, $type) { } // Add points to his account directly - SQL_QUERY_ESC("UPDATE `{!MYSQL_PREFIX!}_user_data` SET turbo_bonus=turbo_bonus+".$points." WHERE userid=%s LIMIT 1", - array(bigintval($uid)), __FILE__, __LINE__); + SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET turbo_bonus=turbo_bonus+".$points." WHERE userid=%s LIMIT 1", + array(bigintval($uid)), __FUNCTION__, __LINE__); // Rember this whole data for displaying ranking list - SQL_QUERY_ESC("INSERT INTO `{!MYSQL_PREFIX!}_bonus_turbo` (userid, mail_id, bonus_id, level, points, timemark) VALUES ('%s', '%s', '%s', '%s', '%s', UNIX_TIMESTAMP())", - array(bigintval($uid), bigintval($mail), bigintval($bonus), $rank, $points), __FILE__, __LINE__); + SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_bonus_turbo` (userid, mail_id, bonus_id, level, points, timemark) VALUES ('%s', '%s', '%s', '%s', '%s', UNIX_TIMESTAMP())", + array(bigintval($uid), bigintval($mail), bigintval($bonus), $rank, $points), __FUNCTION__, __LINE__); if ((GET_EXT_VERSION("bonus") >= "0.3.5") && (getConfig('bonus_mode') != "ADD") && ($points > 0)) BONUS_POINTS_HANDLER($points); } // function BONUS_MAKE_RANK_ROWS ($data, $type, $uid) { - global $_CONFIG; $self = false; $OUT = ""; // How many ranks do we have? $ranks = sizeof(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", - array($type, $data, $uid), __FILE__, __LINE__); + $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); @@ -138,8 +135,8 @@ function BONUS_MAKE_RANK_ROWS ($data, $type, $uid) { } // END - if // Load rankings - $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')), __FILE__, __LINE__); + $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 $max = SQL_NUMROWS($result); @@ -147,8 +144,8 @@ function BONUS_MAKE_RANK_ROWS ($data, $type, $uid) { $SW = 2; for ($rank = 1; $rank <= $max; $rank++) { // Load data - $result_users = SQL_QUERY_ESC("SELECT userid, points, timemark FROM `{!MYSQL_PREFIX!}_bonus_turbo` WHERE %s=%s AND level=%s LIMIT 1", - array($type, $data, $rank), __FILE__, __LINE__); + $result_users = SQL_QUERY_ESC("SELECT userid, points, timemark FROM `{!_MYSQL_PREFIX!}_bonus_turbo` WHERE %s=%s AND level=%s LIMIT 1", + array($type, $data, $rank), __FUNCTION__, __LINE__); // Nothing found by default $userid = "---"; $points = "---"; @@ -188,18 +185,13 @@ function BONUS_MAKE_RANK_ROWS ($data, $type, $uid) { } // function BONUS_POINTS_HANDLER ($MODE) { - global $_CONFIG; - // Shall we add bonus points? - if (getConfig('bonus_active') == "N") return; + 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")) { - // Update database - UPDATE_CONFIG(array('bonus_mode'), array("JACKPOT")); - - // Update configuration - $_CONFIG['bonus_mode'] = "JACKPOT"; + // Update database & config + UPDATE_CONFIG('bonus_mode', "JACKPOT"); } // END - if if ($MODE == "login_bonus") { @@ -237,13 +229,11 @@ function BONUS_POINTS_HANDLER ($MODE) { break; } } -// -function BONUS_PURGE_EXPIRED_TURBO_BONUS() -{ - global $_CONFIG; +// +function BONUS_PURGE_EXPIRED_TURBO_BONUS() { // Remove entries - $result = SQL_QUERY("DELETE LOW_PRIORITY FROM `{!MYSQL_PREFIX!}_bonus_turbo` WHERE timemark < (UNIX_TIMESTAMP() - ".getConfig('bonus_timeout').")", __FILE__, __LINE__); + $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(), "");