X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=view.php;h=ce508be7981a28486bd3cdf6382870f99773f6f4;hp=90441e0055b84f68ea79ea83b82e5c157be301ca;hb=24d88ff55d8797b8624ed0efb6cdfb3cd1e2fa68;hpb=2ec9007220186d54f84846871ed1f7638c29baf7

diff --git a/view.php b/view.php
index 90441e0055..ce508be798 100644
--- a/view.php
+++ b/view.php
@@ -48,13 +48,13 @@ require('inc/config-global.php');
 
 if (((REQUEST_ISSET_GET('user')) || (REQUEST_ISSET_GET('reseller'))) && (REQUEST_ISSET_GET('banner'))) {
 	// for later things... ;-)
-	$result = SQL_QUERY_ESC("SELECT url FROM `{!_MYSQL_PREFIX!}_refbanner` WHERE `id`=%s LIMIT 1",
-	array(bigintval(REQUEST_GET('banner'))), __FILE__, __LINE__);
+	$result = SQL_QUERY_ESC("SELECT `url` FROM `{!_MYSQL_PREFIX!}_refbanner` WHERE `id`=%s LIMIT 1",
+		array(bigintval(REQUEST_GET('banner'))), __FILE__, __LINE__);
 	if (SQL_NUMROWS($result) == 1) 	{
 		list($url) = SQL_FETCHROW($result);
 		SQL_FREERESULT($result);
-		SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_refbanner` SET counter=counter+1 WHERE `id`=%s LIMIT 1",
-		array(bigintval(REQUEST_GET('banner'))), __FILE__, __LINE__);
+		SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_refbanner` SET `counter`=`counter`+1 WHERE `id`=%s LIMIT 1",
+			array(bigintval(REQUEST_GET('banner'))), __FILE__, __LINE__);
 
 		$type = substr($url, -3);
 		sendHeader('Content-Type: image/' . $type);
@@ -71,5 +71,5 @@ if (((REQUEST_ISSET_GET('user')) || (REQUEST_ISSET_GET('reseller'))) && (REQUEST
 // Shutdown
 shutdown();
 
-//
+// [EOF]
 ?>