Changeset 42 for banners/banner.php

Timestamp:

Jan 29, 2009, 12:18:39 PM (15 years ago)

Author:

george

Message:

• Opraveno: Sledování odkazovaných adres na bannery.

File:

• banners/banner.php (modified) (1 diff)

banners/banner.php

@@ -8 +8 @@
 $Database->SelectDatabase($Config['Database']['Database']);   
 
-header('Content-Type: image/png');
+//header('Content-Type: image/png');
 $Referer = addslashes($_SERVER['HTTP_REFERER']);
-$Database->SQLCommand('REPLACE INTO `banner` (`Web`, `DateLast`) VALUES ("'.$Referer.'",NOW() )');
+$DbResult = mysql_query('SELECT * FROM `banner` WHERE `Web` = "'.$Referer.'"', $Database->id_connection);
+if(mysql_num_rows($DbResult) > 0)
+  $Database->SQLCommand('UPDATE `banner` SET `DateLast` = NOW() WHERE `Web` = "'.$Referer.'"');
+  else mysql_query('INSERT INTO `banner` (`Web`, `DateFirst`, `DateLast`) VALUES ("'.$Referer.'", NOW(), NOW( ))', $Database->id_connection);
 $Image = imagecreatefromjpeg(addslashes($_GET['image']));
 imagepng($Image);