X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-refbanner.php;h=1d8c3605fbbc690cbcedb39205b174b5b2ab6112;hb=efe6057fdb1c02a518172e985298e66accef90d0;hp=9b0b8fa371691e43f970a78ab755bf9fd4776f5c;hpb=75ad748a68473ace540251427a74fb781b1145e9;p=mailer.git

diff --git a/inc/modules/admin/what-refbanner.php b/inc/modules/admin/what-refbanner.php
index 9b0b8fa371..1d8c3605fb 100644
--- a/inc/modules/admin/what-refbanner.php
+++ b/inc/modules/admin/what-refbanner.php
@@ -82,8 +82,8 @@ VALUES ('%s', '%s', '%s')",
 			$id = bigintval($id);
 
 			// Update entry
-			$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_refbanner SET url='%s', alternate='%s', visible='%s' WHERE id=%d LIMIT 1",
-			 array(stripslashes($_POST['url'][$id]), $_POST['alternate'][$id], $_POST['visible'], $id), __FILE__, __LINE__);
+			$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_refbanner SET url='%s', alternate='%s', visible='%s' WHERE id=%s LIMIT 1",
+			 array($_POST['url'][$id], $_POST['alternate'][$id], $_POST['visible'], $id), __FILE__, __LINE__);
 		}
 		break;
 	}
@@ -104,7 +104,7 @@ VALUES ('%s', '%s', '%s')",
 	foreach ($_POST['sel'] as $id=>$sel)
 	{
 		// Load data
-		$result = SQL_QUERY_ESC("SELECT url, alternate, visible FROM "._MYSQL_PREFIX."_refbanner WHERE id=%d LIMIT 1",
+		$result = SQL_QUERY_ESC("SELECT url, alternate, visible FROM "._MYSQL_PREFIX."_refbanner WHERE id=%s LIMIT 1",
 		 array(bigintval($id)), __FILE__, __LINE__);
 		list($url, $alt, $vis) = SQL_FETCHROW($result);
 		SQL_FREERESULT($result);
@@ -134,7 +134,7 @@ VALUES ('%s', '%s', '%s')",
 		// Delete banner
 		foreach ($_POST['sel'] as $id=>$sel)
 		{
-			$result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_refbanner WHERE id=%d LIMIT 1",
+			$result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_refbanner WHERE id=%s LIMIT 1",
 			 array(bigintval($id)), __FILE__, __LINE__);
 		}
 	}