Changeset 485

Timestamp:

Jun 18, 2010, 7:33:21 AM (14 years ago)

Author:

george

Message:

• Upraveno: Zahrnutí sloučeného posledního data návštěvy z poddomén.

File:

• trunk/banners.php (modified) (3 diffs)

trunk/banners.php

@@ -24 +24 @@
 
 
-$Query = 'SELECT *, (`Hits` + COALESCE((SELECT SUM(`Hits`) FROM `Referrer` AS `T1` WHERE `T1`.`Parent` = `T2`.`Id`), 0)) AS `TotalHits` FROM `Referrer` AS `T2` WHERE (`Show`=1) AND (`Parent`=0) AND (`DateLast` > (NOW() - INTERVAL '.$MonthAge.' MONTH))';
+$Query = 'SELECT * FROM (SELECT *, (`Hits` + COALESCE((SELECT SUM(`Hits`) FROM `Referrer` AS `T1` WHERE `T1`.`Parent` = `T2`.`Id`), 0)) AS `TotalHits`, GREATEST(`DateLast`, COALESCE((SELECT MAX(`DateLast`) FROM `Referrer` AS `T1` WHERE `T1`.`Parent` = `T2`.`Id`), 0)) AS `MaxDateLast` FROM `Referrer` AS `T2` WHERE (`Show`=1) AND (`Parent`=0)) AS `T3` WHERE (`T3`.`MaxDateLast` > (NOW() - INTERVAL '.$MonthAge.' MONTH))';
   
 
@@ -36 +36 @@
 $TableColumns = array(
   array('Name' => 'Web', 'Title' => 'Adresa'), 
-  array('Name' => 'DateLast', 'Title' => 'Naposledy'), 
+  array('Name' => 'MaxDateLast', 'Title' => 'Naposledy'), 
   array('Name' => 'TotalHits', 'Title' => 'Příchodů'), 
 );
-$Order = GetOrderTableHeader($TableColumns, 'DateLast', 1);
+$Order = GetOrderTableHeader($TableColumns, 'MaxDateLast', 1);
 echo($Order['Output']);
 
@@ -48 +48 @@
 {
   echo('<tr><td><a href="'.$Line['LastURL'].'">'.$Line['Web'].'</a></td>'.
-    '<td>'.HumanDate($Line['DateLast']).'</td>'.
+    '<td>'.HumanDate($Line['MaxDateLast']).'</td>'.
     '<td>'.$Line['TotalHits'].'</td></tr>');
 }