Changeset 301 for trunk/banners

Timestamp:

Dec 28, 2009, 9:06:44 PM (15 years ago)

Author:

george

Message:

• Opraveno: Zaznamenávání odkazujících webů na bannery

File:

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

trunk/banners/banner.php

@@ -16 +16 @@
     {
       $Referer = 'http://'.$HostName.'/';
-      $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(), `LastURL` = "'.addslashes($_SERVER['HTTP_REFERER']).'" WHERE `Web` = "'.$Referer.'"');
-        else mysql_query('INSERT INTO `banner` (`Web`, `DateFirst`, `DateLast`, LastURL`) VALUES ("'.$Referer.'", NOW(), NOW( ), "'.addslashes($_SERVER['HTTP_REFERER']).'")', $Database->id_connection);
+      $DbResult = $System->Database->query('SELECT * FROM `banner` WHERE `Web` = "'.$Referer.'"');
+      if($DbResult->num_rows > 0)
+      $System->Database->query('UPDATE `banner` SET `DateLast` = NOW(), `LastURL` = "'.addslashes($_SERVER['HTTP_REFERER']).'" WHERE `Web` = "'.$Referer.'"');
+        else $System->Database->query('INSERT INTO `banner` (`Web`, `DateFirst`, `DateLast`, `LastURL`) VALUES ("'.$Referer.'", NOW(), NOW( ), "'.addslashes($_SERVER['HTTP_REFERER']).'")');
     }