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

diff --git a/view.php b/view.php
index 90441e0055..cf6207ed84 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);