Changeset 484 for trunk/banners.php

Timestamp:

Jun 18, 2010, 7:17:46 AM (15 years ago)

Author:

george

Message:

• Opraveno: Zobrazení odkazů na weby odkud přišli a zobrazení počtu návštěv.

File:

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

trunk/banners.php

@@ -24 +24 @@
 
 
-$Query = 'SELECT *, (`Hits` + (SELECT SUM(`Hits`) FROM `Referrer` AS `T1` WHERE `T1`.`Parent` = `T2`.`Id`)) AS `TotalHits` FROM `Referrer` AS `T2` WHERE (`Show`=1) AND (`Parent`=0) AND (`DateLast` > (NOW() - INTERVAL '.$MonthAge.' MONTH))';
+$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))';
   
 
@@ -47 +47 @@
 while($Line = $DbResult->fetch_assoc()) 
 {
-  echo('<tr><td>'.$Line['Web'].'</td>'.
+  echo('<tr><td><a href="'.$Line['LastURL'].'">'.$Line['Web'].'</a></td>'.
     '<td>'.HumanDate($Line['DateLast']).'</td>'.
     '<td>'.$Line['TotalHits'].'</td></tr>');