X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=view.php;h=a22e83582c555b0b8226fc406004e3133b41da0a;hb=5bdeaf8b452206598b6c6cd4f941145b11a0eccc;hp=6993c8ba37ec5f075784e1b7149e259828c61ae1;hpb=d798a412acb8c1263933bd7f7a0fd9aa251495a7;p=mailer.git

diff --git a/view.php b/view.php
index 6993c8ba37..a22e83582c 100644
--- a/view.php
+++ b/view.php
@@ -49,11 +49,13 @@ if (((!empty($_GET['user'])) || (!empty($_GET['reseller']))) && (!empty($_GET['b
 	$VIEW = 1;
 
 	// for later things... ;-)
-	$result = SQL_QUERY_ESC("SELECT url FROM "._MYSQL_PREFIX."_refbanner WHERE id=%s LIMIT 1", array(bigintval($_GET['banner'])), __FILE__, __LINE__);
+	$result = SQL_QUERY_ESC("SELECT url FROM `{!_MYSQL_PREFIX!}_refbanner` WHERE id=%s LIMIT 1",
+		array(bigintval($_GET['banner'])), __FILE__, __LINE__);
 	if (SQL_NUMROWS($result) == 1) 	{
 		list($url) = SQL_FETCHROW($result);
 		SQL_FREERESULT($result);
-		$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_refbanner SET counter=counter+1 WHERE id=%s LIMIT 1", array(bigintval($_GET['banner'])), __FILE__, __LINE__);
+		SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_refbanner` SET counter=counter+1 WHERE id=%s LIMIT 1",
+			array(bigintval($_GET['banner'])), __FILE__, __LINE__);
 
 		$type = substr($url, -3);
 		@header ("Content-Type: image/".$type);