diff options
| author | Dries Buytaert <dries@buytaert.net> | 2002-08-19 18:00:50 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2002-08-19 18:00:50 +0000 |
| commit | afd87425d98ee62864911a2ccd29beb0eea843cb (patch) | |
| tree | baca839e2ee1e54d6337417b75c62832b1c20107 /modules/statistics.module | |
| parent | c34d77854d3e2cab323b8db9841fa3785f3db597 (diff) | |
| download | brdo-afd87425d98ee62864911a2ccd29beb0eea843cb.tar.gz brdo-afd87425d98ee62864911a2ccd29beb0eea843cb.tar.bz2 | |
- Replaced MySQL-ism by its ANSI SQL counterpart. Patch by jaa.
Diffstat (limited to 'modules/statistics.module')
| -rw-r--r-- | modules/statistics.module | 6 |
1 files changed, 3 insertions, 3 deletions
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 +?> |