Changeset 462

Timestamp:

Apr 14, 2010, 6:58:33 AM (14 years ago)

Author:

george

Message:

• Opraveno: Zaznamenávání odkazovaných stránek.

Location:

trunk

Files:

• banners.php (modified) (1 diff)
• includes/global.php (modified) (1 diff)
• includes/global_function.php (modified) (1 diff)
• sql/updates/462.sql (added)

trunk/banners.php

@@ -18 +18 @@
 echo($BannerSmall.' &nbsp;&nbsp;<textarea rows="2" cols="30">'.htmlspecialchars($BannerSmall).'</textarea><br />');
   
-$DbResult = $System->Database->query('SELECT * FROM `Referal` WHERE `Show`=1 AND `DateLast` > (NOW() - INTERVAL 3 MONTH)');
+$DbResult = $System->Database->query('SELECT * FROM `Referrer` WHERE `Show`=1 AND `DateLast` > (NOW() - INTERVAL 3 MONTH)');
   
 echo('<br/><strong>Servery odkazující na nás:</strong> <br />

trunk/includes/global.php

@@ -30 +30 @@
 $LanguageList = GetLanguageList();
 
-LogReferal();
+LogReferrer();
 
 function GetMicrotime()

trunk/includes/global_function.php

@@ -536 +536 @@
 }
 
-function LogReferal()
+function LogReferrer()
 {
   global $System;
 
-  if(array_key_exists('HTTP_REFERER', $_SERVER)) $Referer = addslashes($_SERVER['HTTP_REFERER']);
-    else $Referer = '';
-  $Referer = substr($Referer, strpos($Referer, '/') + 2);
-  $HostName = substr($Referer, 0, strpos($Referer, '/'));
-  if(substr($HostName, -1) == '.') $HostName = substr($HostName, 0, -1);
-  //if($HostName != gethostbyname($HostName))
-  {
-    $Referer = 'http://'.$HostName.'/';
-    $System->Database->query('REPLACE INTO `Referal` (`Web`, `DateFirst`, `DateLast`, `LastURL`) VALUES ("'.$Referer.'", NOW(), NOW( ), "'.addslashes($_SERVER['HTTP_REFERER']).'")');
+  if(array_key_exists('HTTP_REFERER', $_SERVER)) 
+  {
+    $Referrer = addslashes($_SERVER['HTTP_REFERER']);
+    $HostName = substr($Referrer, strpos($Referrer, '/') + 2);
+    $HostName = substr($HostName, 0, strpos($HostName, '/'));
+    if($HostName != $System->Config['Web']['Host'])
+    {
+      $DbResult = $System->Database->query('SELECT `Id` FROM `Referrer` WHERE `Web` = "'.$HostName.'"');
+      if($DbResult->num_rows > 0)
+      {
+        $DbRow = $DbResult->fetch_assoc();
+        $System->Database->query('UPDATE `Referrer` SET `DateLast` = NOW(), `LastURL` = "'.addslashes($Referrer).'" WHERE `Id` = '.$DbRow['Id']);
+      } else $System->Database->query('INSERT INTO `Referrer` (`Web`, `DateFirst`, `DateLast`, `LastURL`) VALUES ("'.$HostName.'", NOW(), NOW( ), "'.addslashes($Referrer).'")');
+    }
   }
 }