Default refid is always fallback now, or 0 if sql_patches is absend

[mailer.git] / view.php

diff --git a/view.php b/view.php
index 536b8257ac37c45783416bacb603071f742b7d9d..cf6207ed84794531ea3be78b62f0e3c8e9ce108d 100644 (file)
--- 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;
@@ -52,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);