X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=view.php;h=3432fb354803a255e0241fb39e0c9c838610b3f9;hp=cf6207ed84794531ea3be78b62f0e3c8e9ce108d;hb=2abf1ab70c824b92934910d9f5da3c37fe089c47;hpb=f75ece45874353859d07849cc9c6f79f76f76aa8

diff --git a/view.php b/view.php
index cf6207ed84..3432fb3548 100644
--- a/view.php
+++ b/view.php
@@ -17,7 +17,7 @@
  * Needs to be in all Files and every File needs "svn propset           *
  * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
  * -------------------------------------------------------------------- *
- * Copyright (c) 2003 - 2008 by Roland Haeder                           *
+ * Copyright (c) 2003 - 2009 by Roland Haeder                           *
  * For more information visit: http://www.mxchange.org                  *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -46,23 +46,35 @@ $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'))) {
-	// 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__);
+if (((isGetRequestElementSet('user')) || (isGetRequestElementSet('reseller'))) && (isGetRequestElementSet('banner'))) {
+	// For later things... ;-)
+	$result = SQL_QUERY_ESC("SELECT `url` FROM `{?_MYSQL_PREFIX?}_refbanner` WHERE `id`=%s LIMIT 1",
+		array(bigintval(getRequestElement('banner'))), __FILE__, __LINE__);
+
+	// Do we have the banner?
 	if (SQL_NUMROWS($result) == 1) 	{
+		// Load the URL
 		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__);
 
+		// Update counter
+		SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_refbanner` SET `counter`=`counter`+1 WHERE `id`=%s LIMIT 1",
+			array(bigintval(getRequestElement('banner'))), __FILE__, __LINE__);
+
+		// Extract type (last 3 chars should be okay)
 		$type = substr($url, -3);
+
+		// Set header and ...
 		sendHeader('Content-Type: image/' . $type);
+
+		// Redirect
 		redirectToUrl($url, false);
 	} else {
-		// Free memory
-		SQL_FREERESULT($result);
+		// @TODO No banner found, output some default banner
+		logDebugMessage(__FILE__, __LINE__, 'Banner ' . bigintval(getRequestElement('banner')) . ' not dound.');
 	}
+
+	// Free memory
+	SQL_FREERESULT($result);
 } else {
 	// Do nothing for now
 	redirectToUrl('index.php');
@@ -71,5 +83,5 @@ if (((REQUEST_ISSET_GET('user')) || (REQUEST_ISSET_GET('reseller'))) && (REQUEST
 // Shutdown
 shutdown();
 
-//
+// [EOF]
 ?>