X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=doubler.php;h=8c56144ccf589fb3c87e1e410d36067905e706f7;hp=214641567f67f94afa68f2ce3e51f95e1fe5a435;hb=b3f82be7e5ecc294acfe9c00ef75e3dc0c8b43d1;hpb=60494e212a67fe360bfbb481eb4928480a6f379b

diff --git a/doubler.php b/doubler.php
index 214641567f..8c56144ccf 100644
--- a/doubler.php
+++ b/doubler.php
@@ -37,34 +37,31 @@ require_once("inc/libs/security_functions.php");
 // Init "action" and "what"
 global $what, $action, $startTime;
 $GLOBALS['startTime'] = microtime(true);
-$GLOBALS['what'] = ""; $GLOBALS['action'] = "";
+$GLOBALS['what'] = "";
+$GLOBALS['action'] = "";
 
 // Set module
 $GLOBALS['module'] = "doubler";
 $GLOBALS['refid'] = 0;
-$CSS = "0";
+$CSS = 0;
 
 // Load the required file(s)
 require ("inc/config.php");
 
 // Is the script installed?
-if (defined('mxchange_installed') && (mxchange_installed))
-{
+if (isBooleanConstantAndTrue('mxchange_installed')) {
 	// Probe for referral ID
 	if (!empty($_GET['refid'])) $GLOBALS['refid'] = bigintval($_GET['refid']);
 
 	// Probe for nickname extension and if a nickname was supplied by URL
 	$probe_nickname = ((EXT_IS_ACTIVE("nickname")) && (("".round($GLOBALS['refid'])."") != $GLOBALS['refid']));
-	if ($probe_nickname)
-	{
+	if ($probe_nickname) {
 		// Nickname in URL, so load the ID
 		$result = SQL_QUERY_ESC("SELECT userid, status FROM "._MYSQL_PREFIX."_user_data WHERE nickname='%s' LIMIT 1",
 		 array(bigintval($GLOBALS['refid'])), __FILE__, __LINE__);
-	}
-	 else
-	{
+	} else {
 		// Direct userid entered
-		$result = SQL_QUERY_ESC("SELECT userid, status FROM "._MYSQL_PREFIX."_user_data WHERE userid=%d LIMIT 1",
+		$result = SQL_QUERY_ESC("SELECT userid, status FROM "._MYSQL_PREFIX."_user_data WHERE userid=%s LIMIT 1",
 		 array(bigintval($GLOBALS['refid'])), __FILE__, __LINE__);
 	}
 
@@ -77,29 +74,27 @@ if (defined('mxchange_installed') && (mxchange_installed))
 	$uid = 0;
 
 	// If no account was found set default refid and status to CONFIRMED
-	if (empty($GLOBALS['refid'])) { $GLOBALS['refid'] = $_CONFIG['def_refid']; $status = "CONFIRMED"; }
+	if (empty($GLOBALS['refid'])) {
+		$GLOBALS['refid'] = $_CONFIG['def_refid'];
+		$status = "CONFIRMED";
+	} // END - if
 
 	// Begin with doubler script...
-	if (isset($_POST['ok']))
-	{
+	if (isset($_POST['ok'])) {
 		// Secure points (so only integer/double values are allowed
 		$_POST['points'] = bigintval($_POST['points']);
 
 		// Begin with doubling process
-		if ((!empty($_POST['userid'])) && (!empty($_POST['pass'])) && (!empty($_POST['points'])))
-		{
+		if ((!empty($_POST['userid'])) && (!empty($_POST['pass'])) && (!empty($_POST['points']))) {
 			// Probe for nickname extension and if a nickname was entered
 			$probe_nickname = ((EXT_IS_ACTIVE("nickname")) && (("".round($_POST['userid'])."") != $_POST['userid']));
-			if ($probe_nickname)
-			{
+			if ($probe_nickname) {
 				// Nickname in URL, so load the ID
 				$result = SQL_QUERY_ESC("SELECT userid, status, password FROM "._MYSQL_PREFIX."_user_data WHERE nickname='%s' LIMIT 1",
 				 array($_POST['userid']), __FILE__, __LINE__);
-			}
-			 else
-			{
+			} else {
 				// Direct userid entered
-				$result = SQL_QUERY_ESC("SELECT userid, status, password FROM "._MYSQL_PREFIX."_user_data WHERE userid=%d LIMIT 1",
+				$result = SQL_QUERY_ESC("SELECT userid, status, password FROM "._MYSQL_PREFIX."_user_data WHERE userid=%s LIMIT 1",
 				 array(bigintval($_POST['userid'])), __FILE__, __LINE__);
 			}
 
@@ -111,14 +106,13 @@ if (defined('mxchange_installed') && (mxchange_installed))
 			SQL_FREERESULT($result);
 
 			// Remove any dots and unwanted chars from the points
-			$_POST['points'] = bigintval(round(str_replace(",", ".", $_POST['points'])));
+			$_POST['points'] = bigintval(round(REVERT_COMMA($_POST['points'])));
 
 			// Probe for enough points
 			$probe_points = (($_POST['points'] >= $_CONFIG['doubler_min']) && ($_POST['points'] <= $_CONFIG['doubler_max']));
 
 			// Check all together
-			if ((!empty($uid)) && ($password == generateHash($_POST['pass'], substr($password, 0, -40))) && ($status == "CONFIRMED") && ($probe_points))
-			{
+			if ((!empty($uid)) && ($password == generateHash($_POST['pass'], substr($password, 0, -40))) && ($status == "CONFIRMED") && ($probe_points)) {
 				// Nickname resolved to a unique userid or direct userid entered by the member
 				$DOUBLER_UID = $uid;
 
@@ -130,104 +124,65 @@ if (defined('mxchange_installed') && (mxchange_installed))
 				{
 					// Enough points are left so let's continue with the doubling process
 					// Create doubling "account" width *DOUBLED* points
-					$result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_doubler (userid, refid, points, remote_ip, timemark, completed, is_ref) VALUES ('%s', '%s', '%s', '".$_SERVER['REMOTE_ADDR']."', UNIX_TIMESTAMP(), 'N', 'N')",
+					$result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_doubler (userid, refid, points, remote_ip, timemark, completed, is_ref) VALUES ('%s','%s','%s','".GET_REMOTE_ADDR()."', UNIX_TIMESTAMP(), 'N','N')",
 					 array($uid, bigintval($GLOBALS['refid']), bigintval($_POST['points'] * 2)), __FILE__, __LINE__);
 
 					// Subtract entered points
-					$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET used_points=used_points+%s WHERE userid=%d LIMIT 1",
-					 array($_POST['points'], $uid), __FILE__, __LINE__);
-
-					// Update mediadata as well
-					if (GET_EXT_VERSION("mediadata") >= "0.0.4")
-					{
-						// Update database
-						MEDIA_UPDATE_ENTRY(array("total_points"), "sub", $_POST['points']);
-					}
+					SUB_POINTS($uid, $_POST['points']);
 
 					// Add points to "total payed" including charge
 					$points = $_POST['points'] - $_POST['points'] * $_CONFIG['doubler_charge'];
-					$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_config SET doubler_points=doubler_points+%s WHERE config='0' LIMIT 1",
-					 array($points), __FILE__, __LINE__);
+					UPDATE_CONFIG("doubler_points", $points, "+");
 					$_CONFIG['doubler_points'] += $points;
 
-					// Destroy cache
-					if (GET_EXT_VERSION("cache") >= "0.1.2")
-					{
-						if ($CACHE->cache_file("config", true)) $CACHE->cache_destroy();
-					}
-
 					// Add second line for the referral but only when uid != refid
-					if (($GLOBALS['refid'] > 0) && ($GLOBALS['refid'] != $uid))
-					{
+					if (($GLOBALS['refid'] > 0) && ($GLOBALS['refid'] != $uid)) {
 						// Okay add a refid line and apply refid percents
-						$result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_doubler (userid, refid, points, remote_ip, timemark, completed, is_ref) VALUES ('%s', '0', '%s', '".$_SERVER['REMOTE_ADDR']."', UNIX_TIMESTAMP(), 'N', 'Y')",
-						 array(bigintval($GLOBALS['refid']), bigintval($_POST['points'] * 2 * $_CONFIG['doubler_ref'])), __FILE__, __LINE__);
+						$result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_doubler (userid,refid,points,remote_ip,timemark,completed,is_ref) VALUES ('%s',0,'%s','".GET_REMOTE_ADDR()."',UNIX_TIMESTAMP(),'N','Y')",
+							array(bigintval($GLOBALS['refid']), bigintval($_POST['points'] * 2 * $_CONFIG['doubler_ref'])), __FILE__, __LINE__);
 
 						// And that's why we dont't want to you more than one referral level of doubler-points. ^^^
-					}
+					} // END - if
 
 					// Update usage counter
-					$result = SQL_QUERY("UPDATE "._MYSQL_PREFIX."_config SET doubler_counter=doubler_counter+1 WHERE config='0' LIMIT 1", __FILE__, __LINE__);
+					UPDATE_CONFIG("doubler_counter", 1, "+");
 					$_CONFIG['doubler_counter']++;
 
 					// Set constant
 					define('__DOUBLER_MSG', LOAD_TEMPLATE("doubler_reflink", true, $_POST['userid']));
-				}
-				 else
-				{
+				} else {
 					// Not enougth points left
 					define('__ERROR_MSG', DOUBLER_FORM_NO_POINTS_LEFT);
 				}
-
-			}
-			 elseif ($status == "CONFIRMED")
-			{
+			} elseif ($status == "CONFIRMED") {
 				// Account is unconfirmed!
 				define('__ERROR_MSG', DOUBLER_FORM_WRONG_PASS);
-			}
-			 elseif ($status == "UNCONFIRMED")
-			{
+			} elseif ($status == "UNCONFIRMED") {
 				// Account is unconfirmed!
 				define('__ERROR_MSG', DOUBLER_FORM_STATUS_UNCONFIRMED);
-			}
-			 elseif ($status == "LOCKED")
-			{
+			} elseif ($status == "LOCKED") {
 				// Account is locked by admin / holiday!
 				define('__ERROR_MSG', DOUBLER_FORM_STATUS_LOCKED);
-			}
-			 elseif ($_POST['points'] < $_CONFIG['doubler_min'])
-			{
+			} elseif ($_POST['points'] < $_CONFIG['doubler_min']) {
 				// Not enougth points entered
 				define('__ERROR_MSG', DOUBLER_FORM_POINTS_MIN);
-			}
-			 elseif ($_POST['points'] > $_CONFIG['doubler_max'])
-			{
+			} elseif ($_POST['points'] > $_CONFIG['doubler_max']) {
 				// Too much points entered
 				define('__ERROR_MSG', DOUBLER_FORM_POINTS_MAX);
-			}
-			 elseif ($probe_nickname)
-			{
+			} elseif ($probe_nickname) {
 				// Cannot resolv nickname -> userid
 				define('__ERROR_MSG', DOUBLER_FORM_404_NICKNAME);
-			}
-			 else
-			{
+			} else {
 				// Wrong password or account not found
 				define('__ERROR_MSG', DOUBLER_FORM_404_MEMBER);
 			}
-		}
-		 elseif (empty($_POST['userid']))
-		{
+		} elseif (empty($_POST['userid'])) {
 			// Login not entered
 			define('__ERROR_MSG', DOUBLER_FORM_404_LOGIN);
-		}
-		 elseif (empty($_POST['pass']))
-		{
+		} elseif (empty($_POST['pass'])) {
 			// Password not entered
 			define('__ERROR_MSG', DOUBLER_FORM_404_PASSWORD);
-		}
-		 elseif (empty($_POST['points']))
-		{
+		} elseif (empty($_POST['points'])) {
 			// points not entered
 			define('__ERROR_MSG', DOUBLER_FORM_404_POINTS);
 		}
@@ -250,18 +205,13 @@ if (defined('mxchange_installed') && (mxchange_installed))
 	define('__DOUBLER_HEADER', LOAD_TEMPLATE("doubler_header", true));
 	define('__DOUBLER_FOOTER', LOAD_TEMPLATE("doubler_footer", true));
 
-	if (!empty($uid))
-	{
+	if (!empty($uid)) {
 		// Transfer userid/nickname to constant
 		define('__REFID', $uid);
-	}
-	 elseif (!empty($GLOBALS['refid']))
-	{
+	} elseif (!empty($GLOBALS['refid'])) {
 		// Transfer userid/nickname to constant
 		define('__REFID', $GLOBALS['refid']);
-	}
-	 else
-	{
+	} else {
 		// Transfer default refid to constant
 		define('__REFID', $_CONFIG['def_refid']);
 	}
@@ -274,13 +224,10 @@ if (defined('mxchange_installed') && (mxchange_installed))
 	define('__MAX_VALUE'   , TRANSLATE_COMMA($_CONFIG['doubler_max']));
 
 	// Text "Enter login"
-	if (EXT_IS_ACTIVE("nickname"))
-	{
+	if (EXT_IS_ACTIVE("nickname")) {
 		// Choose login/nickname
 		define('DOUBLER_ENTER_LOGIN', GUEST_ENTER_LOGIN_NICKNAME);
-	}
-	 else
-	{
+	} else {
 		// Simple login ID
 		define('DOUBLER_ENTER_LOGIN', GUEST_ENTER_LOGIN);
 	}
@@ -298,7 +245,7 @@ if (defined('mxchange_installed') && (mxchange_installed))
 	}
 
 	// Generate table with already payed out doubles
-	define('__DOUBLER_PAYOUT_HISTORY', DOUBLER_GENERATE_TABLE("0", 'Y', 'N', "DESC"));
+	define('__DOUBLER_PAYOUT_HISTORY', DOUBLER_GENERATE_TABLE("0", "Y", "N", "DESC"));
 
 	// Generate timemark
 	define('__TIMEOUT_MARK', CREATE_FANCY_TIME($_CONFIG['doubler_timeout']));
@@ -314,9 +261,7 @@ if (defined('mxchange_installed') && (mxchange_installed))
 
 	// Output footer
 	include(PATH."inc/footer.php");
-}
- else
-{
+} else {
 	// You have to configure first!
 	LOAD_URL("install.php");
 }