- 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__);
+ // Load the URL
+ $data = SQL_FETCHARRAY($result);
+
+ // Update counter
+ SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_refbanner` SET `counter`=`counter`+1 WHERE `id`=%s LIMIT 1",
+ array(bigintval(getRequestParameter('banner'))), __FILE__, __LINE__);
+
+ // Set header and ...
+ setContentType('image/' . substr($data['url'], -3, 3));