Changeset 503 for trunk/banners.php

Timestamp:

Feb 3, 2013, 1:15:07 AM (12 years ago)

Author:

chronos

Message:

• Opraveno: Zobrazování vnějších odkazujících adres na projekt.

File:

• trunk/banners.php (modified) (1 diff)

trunk/banners.php

@@ -24 +24 @@
 
 
-$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))';
+$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` IS NULL)) AS `T3` '.
+'WHERE (`T3`.`MaxDateLast` > (NOW() - INTERVAL '.$MonthAge.' MONTH))';