Changeset 185

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.

Location:

trunk

Files:

• banners.php (modified) (1 diff)
• banners/banner.php (modified) (1 diff)
• sql/updates/185.sql (added)

trunk/banners.php

@@ -5 +5 @@
 ShowPage();
   
-$ID = $Database->SQLCommand("SELECT * FROM `banner` WHERE `Show`=1 AND `DateLast` > (NOW() - INTERVAL 3 MONTH)");
+$ID = $Database->SQLCommand('SELECT * FROM `banner` WHERE `Show`=1 AND `DateLast` > (NOW() - INTERVAL 3 MONTH)');
   
 echo('<strong>Servery odkazující na nás:</strong> <br />
 <div style="font-size: 10px;">Seznam je automaticky aktualizován a zobrazeny jsou servery s aktivní bannerem mladším než tři měsíce.</div><br />');
-while($Line = mysql_fetch_array($ID)) 
+while($Line = mysql_fetch_assoc($ID)) 
 {
-  echo('<a href="'.$Line['Web'].'">'.$Line['Web'].'</a> '.$Line['Description'].' <br />');      
+  echo('<a href="'.$Line['Web'].'">'.$Line['LastURL'].'</a> '.$Line['Description'].' <br />');          
 }
   

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);