diff options
| author | Dries Buytaert <dries@buytaert.net> | 2001-12-02 21:28:43 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2001-12-02 21:28:43 +0000 |
| commit | cd58e22e3e7bbda2600165db563976e54c83194f (patch) | |
| tree | df9d31a1fa47d02fae28f08744ba4dfc985e4b50 /modules | |
| parent | 9cb3430e8b744927765217045eb2d20fe260f58d (diff) | |
| download | brdo-cd58e22e3e7bbda2600165db563976e54c83194f.tar.gz brdo-cd58e22e3e7bbda2600165db563976e54c83194f.tar.bz2 | |
- Tiny improvement to the order of the results.
Diffstat (limited to 'modules')
| -rw-r--r-- | modules/statistics.module | 4 | ||||
| -rw-r--r-- | modules/statistics/statistics.module | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/modules/statistics.module b/modules/statistics.module index 4e4f2fb8c..c2011a235 100644 --- a/modules/statistics.module +++ b/modules/statistics.module @@ -61,7 +61,7 @@ function statistics_referer_internal() { $output .= statistics_table_1("SELECT url, timestamp FROM referer WHERE url LIKE '%". check_input($HTTP_HOST) ."%' ORDER BY timestamp DESC LIMIT 15"); $output .= "<h3>Internal referers of the last ". format_interval(variable_get("referer_clear", 604800)) ."</h3>\n"; - $output .= statistics_table_2("SELECT url, COUNT(url) AS count FROM referer WHERE url LIKE '%". check_input($HTTP_HOST) ."%' GROUP BY url ORDER BY count DESC"); + $output .= statistics_table_2("SELECT url, COUNT(url) AS count FROM referer WHERE url LIKE '%". check_input($HTTP_HOST) ."%' GROUP BY url ORDER BY count DESC, timestamp"); return $output; } @@ -73,7 +73,7 @@ function statistics_referer_external() { $output .= statistics_table_1("SELECT url, timestamp FROM referer WHERE url NOT LIKE '%". check_input($HTTP_HOST) ."%' ORDER BY timestamp DESC LIMIT 15"); $output .= "<h3>External referers of the last ". format_interval(variable_get("referer_clear", 604800)) ."</h3>\n"; - $output .= statistics_table_2("SELECT url, COUNT(url) AS count FROM referer WHERE url NOT LIKE '%". check_input($HTTP_HOST) ."%' GROUP BY url ORDER BY count DESC"); + $output .= statistics_table_2("SELECT url, COUNT(url) AS count FROM referer WHERE url NOT LIKE '%". check_input($HTTP_HOST) ."%' GROUP BY url ORDER BY count DESC, timestamp"); return $output; } diff --git a/modules/statistics/statistics.module b/modules/statistics/statistics.module index 4e4f2fb8c..c2011a235 100644 --- a/modules/statistics/statistics.module +++ b/modules/statistics/statistics.module @@ -61,7 +61,7 @@ function statistics_referer_internal() { $output .= statistics_table_1("SELECT url, timestamp FROM referer WHERE url LIKE '%". check_input($HTTP_HOST) ."%' ORDER BY timestamp DESC LIMIT 15"); $output .= "<h3>Internal referers of the last ". format_interval(variable_get("referer_clear", 604800)) ."</h3>\n"; - $output .= statistics_table_2("SELECT url, COUNT(url) AS count FROM referer WHERE url LIKE '%". check_input($HTTP_HOST) ."%' GROUP BY url ORDER BY count DESC"); + $output .= statistics_table_2("SELECT url, COUNT(url) AS count FROM referer WHERE url LIKE '%". check_input($HTTP_HOST) ."%' GROUP BY url ORDER BY count DESC, timestamp"); return $output; } @@ -73,7 +73,7 @@ function statistics_referer_external() { $output .= statistics_table_1("SELECT url, timestamp FROM referer WHERE url NOT LIKE '%". check_input($HTTP_HOST) ."%' ORDER BY timestamp DESC LIMIT 15"); $output .= "<h3>External referers of the last ". format_interval(variable_get("referer_clear", 604800)) ."</h3>\n"; - $output .= statistics_table_2("SELECT url, COUNT(url) AS count FROM referer WHERE url NOT LIKE '%". check_input($HTTP_HOST) ."%' GROUP BY url ORDER BY count DESC"); + $output .= statistics_table_2("SELECT url, COUNT(url) AS count FROM referer WHERE url NOT LIKE '%". check_input($HTTP_HOST) ."%' GROUP BY url ORDER BY count DESC, timestamp"); return $output; } |