X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=view.php;h=b102474925457cbb0cf90a9a72ae5171b4f514f2;hb=a12bb20268fe0d586c434eea2c1fdf9c65a45bbb;hp=cf6207ed84794531ea3be78b62f0e3c8e9ce108d;hpb=f75ece45874353859d07849cc9c6f79f76f76aa8;p=mailer.git diff --git a/view.php b/view.php index cf6207ed84..b102474925 100644 --- a/view.php +++ b/view.php @@ -47,22 +47,34 @@ $GLOBALS['output_mode'] = -1; require('inc/config-global.php'); if (((REQUEST_ISSET_GET('user')) || (REQUEST_ISSET_GET('reseller'))) && (REQUEST_ISSET_GET('banner'))) { - // for later things... ;-) + // 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__); + + // Do we have the banner? if (SQL_NUMROWS($result) == 1) { + // Load the URL list($url) = SQL_FETCHROW($result); - SQL_FREERESULT($result); + + // Update counter SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_refbanner` SET `counter`=`counter`+1 WHERE `id`=%s LIMIT 1", array(bigintval(REQUEST_GET('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 + DEBUG_LOG(__FILE__, __LINE__, 'Banner ' . bigintval(REQUEST_GET('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] ?>