X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=mailid_top.php;h=f2829ac315747378c7ca9d3a050d83a7eec579b6;hp=63e498998fc367d0ba8e7d83c00d8a512e251727;hb=51d65692668408a44920ce069a37c5fa4f5ba257;hpb=c72c89ffa5f7f5444d7fd47021db520b77738d9e

diff --git a/mailid_top.php b/mailid_top.php
index 63e498998f..f2829ac315 100644
--- a/mailid_top.php
+++ b/mailid_top.php
@@ -39,12 +39,12 @@ global $what, $action;
 $GLOBALS['what'] = ""; $GLOBALS['action'] = "";
 
 // Tell everyone we are in this module
-$GLOBALS['module'] = "mailid";  $CSS = "0";
+$GLOBALS['module'] = "mailid";  $CSS = 0;
 
 // Load the required file(s)
 require ("inc/config.php");
 
-if (defined('mxchange_installed') && (isBooleanConstantAndTrue('mxchange_installed')))
+if (isBooleanConstantAndTrue('mxchange_installed'))
 {
 	// Is the extension active
 	if (!EXT_IS_ACTIVE("mailid", true)) {
@@ -53,7 +53,7 @@ if (defined('mxchange_installed') && (isBooleanConstantAndTrue('mxchange_install
 	}
 
 	// Secure all data
-	$url_uid = "0"; $url_bid = "0"; $url_mid = "0"; $code = "0"; $mode = "";
+	$url_uid = 0; $url_bid = 0; $url_mid = 0; $code = 0; $mode = "";
 	if (!empty($_GET['uid']))     $url_uid = bigintval($_GET['uid']);
 	if (!empty($_GET['mailid']))  $url_mid = bigintval($_GET['mailid']);
 	if (!empty($_GET['bonusid'])) $url_bid = bigintval($_GET['bonusid']);
@@ -68,30 +68,30 @@ if (defined('mxchange_installed') && (isBooleanConstantAndTrue('mxchange_install
 		// Maybe he wants to confirm an email?
 		if ($url_mid > 0)
 		{
-			$result = SQL_QUERY_ESC("SELECT id, link_type FROM "._MYSQL_PREFIX."_user_links WHERE stats_id=%d AND userid=%d LIMIT 1",
+			$result = SQL_QUERY_ESC("SELECT id, link_type FROM "._MYSQL_PREFIX."_user_links WHERE stats_id=%s AND userid=%s LIMIT 1",
 			 array($url_mid, $url_uid), __FILE__, __LINE__);
 			$type = "mailid"; $DATA = $url_mid;
 		}
 		 elseif ($url_bid > 0)
 		{
-			$result = SQL_QUERY_ESC("SELECT id, link_type FROM "._MYSQL_PREFIX."_user_links WHERE bonus_id=%d AND userid=%d LIMIT 1",
+			$result = SQL_QUERY_ESC("SELECT id, link_type FROM "._MYSQL_PREFIX."_user_links WHERE bonus_id=%s AND userid=%s LIMIT 1",
 			 array($url_bid, $url_uid), __FILE__, __LINE__);
 			$type = "bonusid"; $DATA = $url_bid;
 		}
 		if (SQL_NUMROWS($result) == 1)
 		{
 			// Is the stats ID valid?
-			list($link_id, $ltype) = SQL_FETCHROW($result);
+			list($lid, $ltype) = SQL_FETCHROW($result);
 			SQL_FREERESULT($result);
 			switch ($ltype)
 			{
 			case "NORMAL":
-				$result_mailid = SQL_QUERY_ESC("SELECT pool_id, userid, id FROM "._MYSQL_PREFIX."_user_stats WHERE id=%d LIMIT 1",
+				$result_mailid = SQL_QUERY_ESC("SELECT pool_id, userid, id FROM "._MYSQL_PREFIX."_user_stats WHERE id=%s LIMIT 1",
 				 array($url_mid), __FILE__, __LINE__);
 				break;
 
 			case "BONUS":
-				$result_mailid = SQL_QUERY_ESC("SELECT id, id, is_notify FROM "._MYSQL_PREFIX."_bonus WHERE id=%d LIMIT 1",
+				$result_mailid = SQL_QUERY_ESC("SELECT id, id, is_notify FROM "._MYSQL_PREFIX."_bonus WHERE id=%s LIMIT 1",
 				 array($url_bid), __FILE__, __LINE__);
 				break;
 			}
@@ -109,25 +109,25 @@ if (defined('mxchange_installed') && (isBooleanConstantAndTrue('mxchange_install
 				if ($ltype == "BONUS") $sender = 0;
 
 				// Is the user's ID unlocked?
-				$result = SQL_QUERY_ESC("SELECT status, sex, surname, family, ref_payout FROM "._MYSQL_PREFIX."_user_data WHERE userid=%d LIMIT 1",
+				$result = SQL_QUERY_ESC("SELECT status, gender, surname, family, ref_payout FROM "._MYSQL_PREFIX."_user_data WHERE userid=%s LIMIT 1",
 				 array($url_uid), __FILE__, __LINE__);
 				if (SQL_NUMROWS($result) == 1)
 				{
 					// Load data
-					list($status, $sex, $sname, $fname, $ref_pay) = SQL_FETCHROW($result);
+					list($status, $gender, $sname, $fname, $ref_pay) = SQL_FETCHROW($result);
 					SQL_FREERESULT($result);
 
 					if ($status == "CONFIRMED")
 					{
 						// Update last activity
-						$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET last_online=UNIX_TIMESTAMP(), last_module='mailid_top' WHERE userid=%d LIMIT 1",
+						$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET last_online=UNIX_TIMESTAMP(), last_module='mailid_top' WHERE userid=%s LIMIT 1",
 						 array($url_uid), __FILE__, __LINE__);
 
 						// User has confirmed his account so we can procede...
 						switch ($ltype)
 						{
 						case "NORMAL":
-							$result = SQL_QUERY_ESC("SELECT payment_id FROM "._MYSQL_PREFIX."_user_stats WHERE pool_id=%d LIMIT 1",
+							$result = SQL_QUERY_ESC("SELECT payment_id FROM "._MYSQL_PREFIX."_user_stats WHERE pool_id=%s LIMIT 1",
 							 array(bigintval($pool)), __FILE__, __LINE__);
 							if (SQL_NUMROWS($result) == 1)
 							{
@@ -142,7 +142,7 @@ if (defined('mxchange_installed') && (isBooleanConstantAndTrue('mxchange_install
 							break;
 
 						case "BONUS":
-							$result = SQL_QUERY_ESC("SELECT time, points FROM "._MYSQL_PREFIX."_bonus WHERE id=%d LIMIT 1",
+							$result = SQL_QUERY_ESC("SELECT time, points FROM "._MYSQL_PREFIX."_bonus WHERE id=%s LIMIT 1",
 							 array(bigintval($pool)), __FILE__, __LINE__);
 							if (SQL_NUMROWS($result) == 1)
 							{
@@ -172,7 +172,7 @@ if (defined('mxchange_installed') && (isBooleanConstantAndTrue('mxchange_install
 									switch ($ltype)
 									{
 									case "NORMAL":
-										$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_stats SET clicks=clicks+1 WHERE id=%d LIMIT 1",
+										$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_stats SET clicks=clicks+1 WHERE id=%s LIMIT 1",
 										 array($url_mid), __FILE__, __LINE__);
 
 										// Update mediadata as well
@@ -184,7 +184,7 @@ if (defined('mxchange_installed') && (isBooleanConstantAndTrue('mxchange_install
 										break;
 
 									case "BONUS":
-										$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_bonus SET clicks=clicks+1 WHERE id=%d LIMIT 1",
+										$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_bonus SET clicks=clicks+1 WHERE id=%s LIMIT 1",
 										 array($url_bid), __FILE__, __LINE__);
 
 										// Update mediadata as well
@@ -204,7 +204,7 @@ if (defined('mxchange_installed') && (isBooleanConstantAndTrue('mxchange_install
 									if (GET_EXT_VERSION("user") >= "0.1.2")
 									{
 										// Update counter
-										$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET mails_confirmed=mails_confirmed+1 WHERE userid=%d LIMIT 1",
+										$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET mails_confirmed=mails_confirmed+1 WHERE userid=%s LIMIT 1",
 										 array($url_uid), __FILE__, __LINE__);
 									}
 
@@ -226,7 +226,7 @@ if (defined('mxchange_installed') && (isBooleanConstantAndTrue('mxchange_install
 										}
 
 										// Count down ref_payout value
-										$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET ref_payout=ref_payout-1 WHERE userid=%d AND ref_payout > 0 LIMIT 1",
+										$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET ref_payout=ref_payout-1 WHERE userid=%s AND ref_payout > 0 LIMIT 1",
 										 array($url_uid), __FILE__, __LINE__);
 
 										// Add points
@@ -256,8 +256,8 @@ if (defined('mxchange_installed') && (isBooleanConstantAndTrue('mxchange_install
 										}
 
 										// Remove link from table
-										$result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_links WHERE id=%d LIMIT 1",
-										 array(bigintval($link_id)), __FILE__, __LINE__);
+										$result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_links WHERE id=%s LIMIT 1",
+										 array(bigintval($lid)), __FILE__, __LINE__);
 
 										// Load total points
 										define('__TOTAL_POINTS', TRANSLATE_COMMA(
@@ -275,8 +275,8 @@ if (defined('mxchange_installed') && (isBooleanConstantAndTrue('mxchange_install
 										ADD_POINTS_REFSYSTEM($sender, $payment, false, 0, false, "direct");
 
 										// Remove link from table
-										$result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_links WHERE id=%d LIMIT 1",
-										 array(bigintval($link_id)), __FILE__, __LINE__);
+										$result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_links WHERE id=%s LIMIT 1",
+										 array(bigintval($lid)), __FILE__, __LINE__);
 
 										// Load template
 										LOAD_TEMPLATE("mailid_points_failed");