X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-config_points.php;h=b11990bec1aca02cdd27ff76bc657f306d32cef7;hp=f9728a8ff2cc28f2c50620cc2a240f0dc0ac23ed;hb=43885129ac24cee5545a8a5ad51e90aa182fdf46;hpb=7d563ebac402d78ee8f5cdf9b0a15eff19c5ff7c

diff --git a/inc/modules/admin/what-config_points.php b/inc/modules/admin/what-config_points.php
index f9728a8ff2..b11990bec1 100644
--- a/inc/modules/admin/what-config_points.php
+++ b/inc/modules/admin/what-config_points.php
@@ -95,7 +95,7 @@ if (isset($_POST['ok']))
 				$id = bigintval($id);
 
 				// Update entry
-				$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_refdepths SET level='%s', percents='%s' WHERE id=%d LIMIT 1",
+				$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_refdepths SET level='%s', percents='%s' WHERE id=%s LIMIT 1",
 				 array(bigintval($value), $_POST['perc'][$id], $id), __FILE__, __LINE__);
 			}
 			$TEXT = REF_DEPTHS_SAVED;
@@ -104,7 +104,7 @@ if (isset($_POST['ok']))
 		case "del":
 			foreach ($_POST['id'] as $id=>$value)
 			{
-				$result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_refdepths WHERE id=%d LIMIT 1",
+				$result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_refdepths WHERE id=%s LIMIT 1",
 				 array(bigintval($id)), __FILE__, __LINE__);
 			}
 			$TEXT = REF_DEPTHS_DELETED;
@@ -123,7 +123,7 @@ if (isset($_POST['ok']))
 		$SQL[] = sprintf("UPDATE "._MYSQL_PREFIX."_config SET
 allow_direct_pay='%s',
 reg_points_mode='%s',
-ref_payout='%d'
+ref_payout='%s'
 WHERE config=0 LIMIT 1",
  $_POST['allow_direct_pay'],
  $_POST['reg_points_mode'],
@@ -132,8 +132,8 @@ WHERE config=0 LIMIT 1",
 		if (($_CONFIG['ref_payout'] == 0) && ($_POST['ref_payout'] > 0))
 		{
 			// Update account's ref_payout for "must-confirm"
-			$SQL[] = sprintf("UPDATE "._MYSQL_PREFIX."_user_data SET ref_payout=(%d - mails_confirmed)
-WHERE mails_confirmed < %d", $REF, $REF);
+			$SQL[] = sprintf("UPDATE "._MYSQL_PREFIX."_user_data SET ref_payout=(%s - mails_confirmed)
+WHERE mails_confirmed < %s", $REF, $REF);
 		}
 		 elseif (($_CONFIG['ref_payout'] > 0) && ($_POST['ref_payout'] == 0))
 		{
@@ -219,7 +219,7 @@ WHERE mails_confirmed < %d", $REF, $REF);
 		$SW = 2; $OUT = "";
 		foreach ($_POST['sel'] as $id=>$value)
 		{
-			$result = SQL_QUERY_ESC("SELECT level, percents FROM "._MYSQL_PREFIX."_refdepths WHERE id=%d LIMIT 1",
+			$result = SQL_QUERY_ESC("SELECT level, percents FROM "._MYSQL_PREFIX."_refdepths WHERE id=%s LIMIT 1",
 			 array(bigintval($id)), __FILE__, __LINE__);
 			list($lvl, $perc) = SQL_FETCHROW($result);
 			SQL_FREERESULT($result);
@@ -247,7 +247,7 @@ WHERE mails_confirmed < %d", $REF, $REF);
 		$SW = 2; $OUT = "";
 		foreach ($_POST['sel'] as $id=>$value)
 		{
-			$result = SQL_QUERY_ESC("SELECT level, percents FROM "._MYSQL_PREFIX."_refdepths WHERE id=%d LIMIT 1",
+			$result = SQL_QUERY_ESC("SELECT level, percents FROM "._MYSQL_PREFIX."_refdepths WHERE id=%s LIMIT 1",
 			 array(bigintval($id)), __FILE__, __LINE__);
 			list($lvl, $perc) = SQL_FETCHROW($result);
 			SQL_FREERESULT($result);