X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Flibs%2Fbonus_functions.php;h=a90b50b6c57c55c2a8b86c38292f7261bb23a0a7;hp=888ecab50391bb7b4cb94539cc9a09aa68f29bc5;hb=aa27f7442553d0a8341e5611d70b8e4521bbce03;hpb=75ad748a68473ace540251427a74fb781b1145e9

diff --git a/inc/libs/bonus_functions.php b/inc/libs/bonus_functions.php
index 888ecab503..a90b50b6c5 100644
--- a/inc/libs/bonus_functions.php
+++ b/inc/libs/bonus_functions.php
@@ -32,85 +32,96 @@
  ************************************************************************/
 
 // Some security stuff...
-if (ereg(basename(__FILE__), $_SERVER['PHP_SELF']))
-{
+if (!defined('__SECURITY')) {
 	$INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
 	require($INC);
 }
+
 // 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) {
+	global $_CONFIG;
 
 	// Shall we add bonus points?
-	if ($CONFIG['bonus_active'] == "N") return;
+	if ($_CONFIG['bonus_active'] == "N") return false;
+
+	// Init variables
+	$SQL = ""; $bonys = 0; $mail = 0; $column = "";
 
 	// Select SQL command
-	$SQL = "";
 	switch ($type)
 	{
 	case "bonusid":
-		$result = SQL_QUERY_ESC("SELECT clicks FROM "._MYSQL_PREFIX."_bonus WHERE id=%d LIMIT 1",
-		 array($mid), __FILE__, __LINE__);
-		$bonus = $mid; $mail = "0";
+		$column = "bonus_id";
+		$bonus = $mid;
 		break;
 
 	case "mailid" :
-		$result = SQL_QUERY_ESC("SELECT clicks FROM "._MYSQL_PREFIX."_user_stats WHERE id=%d LIMIT 1",
-		 array($mid), __FILE__, __LINE__);
-		$bonus = "0"; $mail = $mid;
+		$column = "mail_id";
+		$mail = $mid;
+		break;
+
+	default:
+		DEBUG_LOG(__FUNCTION__, __LINE__, sprintf("Invalid type %s detected.", $type));
 		break;
 	}
 
+	// Is a column name set?
+	if (empty($column)) {
+		// No, then abort here
+		return false;
+	} // 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__);
+
 	// Load clicks from table as current rank
 	list($rank) = SQL_FETCHROW($result);
 
-	if ($rank == 1)
-	{
+	// Add one line
+	$rank++;
+
+	// Free result
+	SQL_FREERESULT($result);
+
+	// Which rank?
+	if ($rank == 1) {
 		// First rank!
-		$rank = 1;
-		$points = $CONFIG['turbo_bonus'];
-	}
-	 else
-	{
+		$points = $_CONFIG['turbo_bonus'];
+	} else {
 		// Anything else so let's explode all entered rank points
-		$test = explode(";", $CONFIG['bonus_rates']);
-		if (!empty($test[$rank - 2]))
-		{
+		$test = explode(";", $_CONFIG['turbo_rates']);
+		if (!empty($test[$rank - 2])) {
 			// Level found
 			$points = $test[$rank - 2];
-		}
-		 else
-		{
+		} else {
 			// Level not found!
 			$points = "0.00000";
 		}
 	}
 
 	// Add points to his account directly
-	$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET turbo_bonus=turbo_bonus+".$points." WHERE userid=%d LIMIT 1",
-	 array(bigintval($uid)), __FILE__, __LINE__);
+	$result = 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
-	$result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_bonus_turbo (userid, mail_id, bonus_id, level, points, timemark) VALUES ('%s', '%s', '%s', '".$rank."', '".$points."', UNIX_TIMESTAMP())",
-	 array(bigintval($uid), bigintval($mail), bigintval($bonus)), __FILE__, __LINE__);
+	$result = 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") && ($CONFIG['bonus_mode'] != "ADD") && ($points > 0)) BONUS_POINTS_HANDLER($points);
+	if ((GET_EXT_VERSION("bonus") >= "0.3.5") && ($_CONFIG['bonus_mode'] != "ADD") && ($points > 0)) BONUS_POINTS_HANDLER($points);
 }
 //
-function BONUS_MAKE_RANK_ROWS($data, $type, $uid)
-{
-	global $CONFIG;
+function BONUS_MAKE_RANK_ROWS ($data, $type, $uid) {
+	global $_CONFIG;
 	$self = false; $OUT = "";
 
 	// How many ranks do we have?
-	$ranks = sizeof(explode(";", $CONFIG['bonus_rates'])) + 1;
+	$ranks = sizeof(explode(";", $_CONFIG['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=%d LIMIT 1",
-	 array($type, $data, $uid), __FILE__, __LINE__);
-	if (SQL_NUMROWS($result) == 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
 		list($rank, $points, $mark) = SQL_FETCHROW($result);
 
@@ -124,35 +135,32 @@ function BONUS_MAKE_RANK_ROWS($data, $type, $uid)
 
 		// 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",
-	 array($type, $data, $CONFIG['bonus_lines']), __FILE__, __LINE__);
-	if (SQL_NUMROWS($result) > 0)
-	{
+		array($type, $data, $_CONFIG['bonus_lines']), __FILE__, __LINE__);
+	if (SQL_NUMROWS($result) > 0) {
 		// Start generating the ranking list
 		$max = SQL_NUMROWS($result);
 
 		$SW = 2;
-		for ($rank = 1; $rank <= $max; $rank++)
-		{
+		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__);
-			list($userid, $points, $mark) = SQL_FETCHROW($result_users);
+			$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
+			$userid = "---"; $points = "---";
 
 			// Are you one of them?
-			if (empty($userid))
-			{
-				// Nothing found
-				$userid = "---"; $points = "---";
-			}
-			 else
-			{
+			if (SQL_NUMROWS($result_users) == 1) {
+				// Load data
+				list($userid, $points, $mark) = SQL_FETCHROW($result_users);
+
 				// Translate comma
 				$points = TRANSLATE_COMMA($points);
-			}
+			} // END - if
 
 			// Output row
 			$OUT .= "<TR>
@@ -161,15 +169,13 @@ function BONUS_MAKE_RANK_ROWS($data, $type, $uid)
   <TD class=\"bonus_rank_".$rank." bottom2 switch_sw".$SW."\" align=\"center\">".$points."</TD>
 </TR>\n";
 			$SW = 3 - $SW;
-		}
-		if (!$self)
-		{
+		} // END - for
+
+		if (!$self) {
 			// If current user was not found set constant
 			define('__YOUR_RANKING_LINE', BONUS_RANK_YOU_ARE_NOT_FOUND);
-		}
-	}
-	 else
-	{
+		} // END - if
+	} else {
 		// No entries found!
 		$OUT = "<TR>
   <TD colspan=\"3\" align=\"center\" height=\"30\" class=\"bottom2\">
@@ -181,71 +187,52 @@ function BONUS_MAKE_RANK_ROWS($data, $type, $uid)
 	return $OUT;
 }
 //
-function BONUS_POINTS_HANDLER($MODE)
-{
-	global $CONFIG;
+function BONUS_POINTS_HANDLER($MODE) {
+	global $_CONFIG;
 
 	// Shall we add bonus points?
-	if ($CONFIG['bonus_active'] == "N") return;
+	if ($_CONFIG['bonus_active'] == "N") return;
 
 	// Switch to jackpot-mode when no UID is supplied but userid-mode is selected
-	if (($CONFIG['bonus_mode'] == "UID") && ($CONFIG['bonus_uid'] == "0")) $CONFIG['bonus_mode'] = "JACKPOT";
+	if (($_CONFIG['bonus_mode'] == "UID") && ($_CONFIG['bonus_uid'] == "0")) {
+		// Update database
+		UPDATE_CONFIG(array('bonus_mode'), array("JACKPOT"));
 
-	if ($MODE == "login_bonus")
-	{
+		// Update configuration
+		$_CONFIG['bonus_mode'] = "JACKPOT";
+	} // END - if
+
+	if ($MODE == "login_bonus") {
 		// Login bonus detected
-		$POINTS = $CONFIG['login_bonus'];
-	}
-	 else
-	{
+		$points = $_CONFIG['login_bonus'];
+	} else {
 		// Direct points supplied
-		$POINTS = $MODE;
+		$points = $MODE;
 	}
 
 	// Subtract points from...
-	switch ($CONFIG['bonus_mode'])
+	switch ($_CONFIG['bonus_mode'])
 	{
 	case "JACKPOT": // ... jackpot
-		if ((SUB_JACKPOT($POINTS) == -1) && ($CONFIG['bonus_uid'] > 0))
-		{
+		if ((SUB_JACKPOT($points) == -1) && ($_CONFIG['bonus_uid'] > 0)) {
 			// Check points amount first...
-			$TOTAL = GET_TOTAL_DATA($CONFIG['bonus_uid'], "user_points", "points") - GET_TOTAL_DATA($CONFIG['bonus_uid'], "user_data", "used_points");
-			if ($TOTAL >= $POINTS)
-			{
+			$TOTAL = GET_TOTAL_DATA($_CONFIG['bonus_uid'], "user_points", "points") - GET_TOTAL_DATA($_CONFIG['bonus_uid'], "user_data", "used_points");
+			if ($TOTAL >= $points) {
 				// Subtract points from userid's account
-				$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET used_points=used_points+%s WHERE userid=%d LIMIT 1",
-				 array(bigintval($POINTS), bigintval($CONFIG['bonus_uid'])), __FILE__, __LINE__);
-
-				// Update mediadata as well
-				if (GET_EXT_VERSION("mediadata") >= "0.0.4")
-				{
-					// Update database
-					MEDIA_UPDATE_ENTRY(array("total_points"), "sub", $POINTS);
-				}
-			}
-		}
+				SUB_POINTS("bonus_payout_jackpot", $_CONFIG['bonus_uid'], $points);
+			} // END - if
+		} // END - if
 		break;
 
 	case "UID": // ... userid's account
 		// Check his amount first
-		$TOTAL = GET_TOTAL_DATA($CONFIG['bonus_uid'], "user_points", "points") - GET_TOTAL_DATA($CONFIG['bonus_uid'], "user_data", "used_points");
-		if ($TOTAL >= $POINTS)
-		{
+		$TOTAL = GET_TOTAL_DATA($_CONFIG['bonus_uid'], "user_points", "points") - GET_TOTAL_DATA($_CONFIG['bonus_uid'], "user_data", "used_points");
+		if ($TOTAL >= $points) {
 			// Subtract points from userid's account
-			$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET used_points=used_points+%s WHERE userid=%d LIMIT 1",
-			 array(bigintval($POINTS), bigintval($CONFIG['bonus_uid'])),  __FILE__, __LINE__);
-
-			// Update mediadata as well
-			if (GET_EXT_VERSION("mediadata") >= "0.0.4")
-			{
-				// Update database
-				MEDIA_UPDATE_ENTRY(array("total_points"), "sub", $POINTS);
-			}
-		}
-		 else
-		{
+			SUB_POINTS("bonus_payout_uid", $_CONFIG['bonus_uid'], $points);
+		} else {
 			// Try to subtract from jackpot
-			$DUMMY = SUB_JACKPOT($POINTS);
+			$dummy = SUB_JACKPOT($points);
 		}
 		break;
 	}
@@ -253,22 +240,13 @@ function BONUS_POINTS_HANDLER($MODE)
 //
 function BONUS_PURGE_EXPIRED_TURBO_BONUS()
 {
-	global $CONFIG;
+	global $_CONFIG;
+
 	// Remove entries
-	$result = SQL_QUERY("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_bonus_turbo WHERE timemark < ".(time() - $CONFIG['bonus_timeout']), __FILE__, __LINE__);
-	$DELETED = SQL_AFFECTEDROWS($result);
-	if ($DELETED > 0)
-	{
+	$result = SQL_QUERY("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_bonus_turbo WHERE timemark < (UNIX_TIMESTAMP() - ".$_CONFIG['bonus_timeout'].")", __FILE__, __LINE__);
+	if (SQL_AFFECTEDROWS() > 0) {
 		// Send out email to admin
-		if (GET_EXT_VERSION("admins") >= "0.4.1")
-		{
-			SEND_ADMIN_EMAILS_PRO(AUTOPURGE_ADMIN_TURBO_SUBJECT, "admin_autopurge_turbo", $DELETED, "");
-		}
-		 else
-		{
-			$msg = LOAD_EMAIL_TEMPLATE("admin_autopurge_turbo", $DELETED, "");
-			SEND_ADMIN_EMAILS(AUTOPURGE_ADMIN_TURBO_SUBJECT, $msg);
-		}
+		SEND_ADMIN_NOTIFICATION(AUTOPURGE_ADMIN_TURBO_SUBJECT, "admin_autopurge_turbo", SQL_AFFECTEDROWS(), "");
 	}
 }
 //