X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=doubler.php;h=ca2934f7b6cd3e9f1d2fb759a8dd4394b3b38cff;hp=e8a088bc8cefdef9885e7ab482571898e9d1dcf1;hb=7f5d2604c2b0bfa6983ece1d58febabc5159d25a;hpb=58b29a924c48e7c1ce38c435c92e541b53984c56

diff --git a/doubler.php b/doubler.php
index e8a088bc8c..ca2934f7b6 100644
--- a/doubler.php
+++ b/doubler.php
@@ -64,7 +64,7 @@ if (defined('mxchange_installed') && (isBooleanConstantAndTrue('mxchange_install
 	 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__);
 	}
 
@@ -99,7 +99,7 @@ if (defined('mxchange_installed') && (isBooleanConstantAndTrue('mxchange_install
 			 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__);
 			}
 
@@ -134,15 +134,7 @@ if (defined('mxchange_installed') && (isBooleanConstantAndTrue('mxchange_install
 					 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'];