Changeset 365 for trunk/banners

Timestamp:

Mar 9, 2010, 11:29:05 AM (15 years ago)

Author:

george

Message:

• Upraveno: Jména tabulek v databází upraveny na stejná s prvními velkými písmeny.
• Upraveno: Doplněny SQL uvozovky do mnoha SQL dotazů.

File:

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

trunk/banners/banner.php

@@ -16 +16 @@
     {
       $Referer = 'http://'.$HostName.'/';
-      $DbResult = $System->Database->query('SELECT * FROM `banner` WHERE `Web` = "'.$Referer.'"');
+      $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']).'")');
+      $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']).'")');
     }