X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fbonus_functions.php;h=f97467bf1bc37c71e0cec5d5fecb1215045ec220;hb=f18a3b60125c8c65861e3205da40447b227f89c9;hp=649f086c3a0c60145bdea192bb9ea5cc667e3ce0;hpb=bfbf712685680761babfd9ea059a224a4aa244bf;p=mailer.git

diff --git a/inc/libs/bonus_functions.php b/inc/libs/bonus_functions.php
index 649f086c3a..f97467bf1b 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,7 +70,7 @@ 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",
+	$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__);
 
 	// Load clicks from table as current rank
@@ -101,25 +99,24 @@ 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",
+	SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET turbo_bonus=turbo_bonus+".$points." WHERE userid=%s LIMIT 1",
 		array(bigintval($uid)), __FILE__, __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())",
+	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__);
 
 	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",
+	$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__);
 	if (SQL_NUMROWS($result) == 1) {
 		// Load data
@@ -138,7 +135,7 @@ 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",
+	$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__);
 	if (SQL_NUMROWS($result) > 0) {
 		// Start generating the ranking list
@@ -147,7 +144,7 @@ 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",
+			$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__);
 
 			// Nothing found by default
@@ -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').")", __FILE__, __LINE__);
 	if (SQL_AFFECTEDROWS() > 0) {
 		// Send out email to admin
 		SEND_ADMIN_NOTIFICATION(AUTOPURGE_ADMIN_TURBO_SUBJECT, "admin_autopurge_turbo", SQL_AFFECTEDROWS(), "");