Changeset 462 for trunk/includes/global_function.php

Timestamp:

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

Author:

george

Message:

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

File:

• trunk/includes/global_function.php (modified) (1 diff)

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).'")');
+    }
   }
 }