From afd87425d98ee62864911a2ccd29beb0eea843cb Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Mon, 19 Aug 2002 18:00:50 +0000
Subject: - Replaced MySQL-ism by its ANSI SQL counterpart.  Patch by jaa.

---
 modules/statistics.module | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

(limited to 'modules/statistics.module')

diff --git a/modules/statistics.module b/modules/statistics.module
index da8be898d..ad832e3e3 100644
--- a/modules/statistics.module
+++ b/modules/statistics.module
@@ -75,7 +75,7 @@ function statistics_referrer_internal() {
   $output .= statistics_table_1("SELECT url, timestamp FROM referrer WHERE url LIKE '%". check_input($HTTP_HOST) ."%' ORDER BY timestamp DESC LIMIT 15");
 
   $output .= "<h3>Internal referrers of the last ". format_interval(variable_get("referrer_clear", 604800)) ."</h3>\n";
-  $output .= statistics_table_2("SELECT url, COUNT(url) AS count FROM referrer WHERE url LIKE '%". check_input($HTTP_HOST) ."%' GROUP BY url ORDER BY count DESC, timestamp");
+  $output .= statistics_table_2("SELECT url, COUNT(url) AS count FROM referrer WHERE url LIKE '%". check_input($HTTP_HOST) ."%' GROUP BY url, timestamp ORDER BY count DESC, timestamp");
 
   return $output;
 }
@@ -87,7 +87,7 @@ function statistics_referrer_external() {
   $output .= statistics_table_1("SELECT url, timestamp FROM referrer WHERE url NOT LIKE '%". check_input($HTTP_HOST) ."%' ORDER BY timestamp DESC LIMIT 15");
 
   $output .= "<h3>External referrers of the last ". format_interval(variable_get("referrer_clear", 604800)) ."</h3>\n";
-  $output .= statistics_table_2("SELECT url, COUNT(url) AS count FROM referrer WHERE url NOT LIKE '%". check_input($HTTP_HOST) ."%' GROUP BY url ORDER BY count DESC, timestamp");
+  $output .= statistics_table_2("SELECT url, COUNT(url) AS count FROM referrer WHERE url NOT LIKE '%". check_input($HTTP_HOST) ."%' GROUP BY url, timestamp ORDER BY count DESC, timestamp");
 
   return $output;
 }
@@ -117,4 +117,4 @@ function statistics_admin() {
   }
 }
 
-?>
\ No newline at end of file
+?>
-- 
cgit v1.2.3