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

diff --git a/view.php b/view.php
index a4dae48a75..ce508be798 100644
--- a/view.php
+++ b/view.php
@@ -39,10 +39,6 @@
 // Load security stuff here
 require('inc/libs/security_functions.php');
 
-// Init "action" and "what"
-$GLOBALS['what'] = '';
-$GLOBALS['action'] = '';
-
 // Set module
 $GLOBALS['module'] = 'view';
 $GLOBALS['output_mode'] = -1;
@@ -50,15 +46,15 @@ $GLOBALS['output_mode'] = -1;
 // Load the required file(s)
 require('inc/config-global.php');
 
-if (((REQUEST_ISSET_GET(('user'))) || (REQUEST_ISSET_GET(('reseller')))) && (REQUEST_ISSET_GET(('banner')))) {
+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);
@@ -75,5 +71,5 @@ if (((REQUEST_ISSET_GET(('user'))) || (REQUEST_ISSET_GET(('reseller')))) && (REQ
 // Shutdown
 shutdown();
 
-//
+// [EOF]
 ?>