X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Flibs%2Fbonus_functions.php;h=266866130f5455344450cb2e255e51e7858960dd;hb=700bc24c3ab00d51273e93cdc816e177bac34aa5;hp=c52b7a9bbdb06b8e91abe77564de6aac08a891c2;hpb=60494e212a67fe360bfbb481eb4928480a6f379b;p=mailer.git

diff --git a/inc/libs/bonus_functions.php b/inc/libs/bonus_functions.php
index c52b7a9bbd..266866130f 100644
--- a/inc/libs/bonus_functions.php
+++ b/inc/libs/bonus_functions.php
@@ -43,20 +43,20 @@ 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;
 
 	// Select SQL command
 	$SQL = "";
 	switch ($type)
 	{
 	case "bonusid":
-		$result = SQL_QUERY_ESC("SELECT clicks FROM "._MYSQL_PREFIX."_bonus WHERE id=%d LIMIT 1",
+		$result = SQL_QUERY_ESC("SELECT clicks FROM "._MYSQL_PREFIX."_bonus WHERE id=%s LIMIT 1",
 		 array($mid), __FILE__, __LINE__);
 		$bonus = $mid; $mail = "0";
 		break;
 
 	case "mailid" :
-		$result = SQL_QUERY_ESC("SELECT clicks FROM "._MYSQL_PREFIX."_user_stats WHERE id=%d LIMIT 1",
+		$result = SQL_QUERY_ESC("SELECT clicks FROM "._MYSQL_PREFIX."_user_stats WHERE id=%s LIMIT 1",
 		 array($mid), __FILE__, __LINE__);
 		$bonus = "0"; $mail = $mid;
 		break;
@@ -88,7 +88,7 @@ function BONUS_ADD_TURBO_POINTS($mid, $uid, $type)
 	}
 
 	// 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",
+	$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
@@ -107,7 +107,7 @@ function BONUS_MAKE_RANK_ROWS($data, $type, $uid)
 	$ranks = sizeof(explode(";", $_CONFIG['bonus_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",
+	$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)
 	{
@@ -186,7 +186,7 @@ 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";
@@ -213,15 +213,7 @@ function BONUS_POINTS_HANDLER($MODE)
 			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($_CONFIG['bonus_uid'], $points);
 			}
 		}
 		break;
@@ -232,20 +224,12 @@ function BONUS_POINTS_HANDLER($MODE)
 		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($_CONFIG['bonus_uid'], $points);
 		}
 		 else
 		{
 			// Try to subtract from jackpot
-			$DUMMY = SUB_JACKPOT($points);
+			$dummy = SUB_JACKPOT($points);
 		}
 		break;
 	}
@@ -260,15 +244,7 @@ function BONUS_PURGE_EXPIRED_TURBO_BONUS()
 	if ($DELETED > 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", $DELETED, "");
 	}
 }
 //