Changeset 185 for trunk/banners

Timestamp:

Apr 22, 2009, 10:58:57 AM (16 years ago)

Author:

george

Message:

• Upraveno: Lepší filtrování vkládání adres odkazů na banner a záznam plného posledního URL z dané domény.

File:

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

trunk/banners/banner.php

@@ -6 +6 @@
 $Referer = addslashes($_SERVER['HTTP_REFERER']);
 $Referer = substr($Referer, strpos($Referer, '/') + 2);
-$Referer = 'http://'.substr($Referer, 0, strpos($Referer, '/')).'/';
-$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);
+$HostName = substr($Referer, 0, strpos($Referer, '/'));
+if(substr($HostName, -1) == '.') $HostName = substr($HostName, 0, -1);
+if($HostName != gethostbyname($HostName))
+{
+  $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);
+}
+
 $Image = imagecreatefromjpeg(addslashes($_GET['image']));
 imagepng($Image);