diff options
author | Dries Buytaert <dries@buytaert.net> | 2001-07-03 19:16:20 +0000 |
---|---|---|
committer | Dries Buytaert <dries@buytaert.net> | 2001-07-03 19:16:20 +0000 |
commit | 43db9cf86fdfba736117cda501c6eb1d31d04693 (patch) | |
tree | 3cd7a03007285b6b4ff3119f30c69484358b55c7 /modules/statistics.module | |
parent | 6a21940c762cce2b777a2fe9102c675e7db9f6e2 (diff) | |
download | brdo-43db9cf86fdfba736117cda501c6eb1d31d04693.tar.gz brdo-43db9cf86fdfba736117cda501c6eb1d31d04693.tar.bz2 |
- common.inc:
+ Made '$na' translatable on popular demand.
- node.module:
+ replaced a confusing configuration description, as suggested by
Remco.
- statistics.module:
+ Added a 'most recent referers'-table sorted by timestamp.
- drupal.module:
+ Small update of the links.
Diffstat (limited to 'modules/statistics.module')
-rw-r--r-- | modules/statistics.module | 38 |
1 files changed, 28 insertions, 10 deletions
diff --git a/modules/statistics.module b/modules/statistics.module index d23e7b22c..f5acfaacc 100644 --- a/modules/statistics.module +++ b/modules/statistics.module @@ -29,25 +29,21 @@ function statistics_conf_options() { return $output; } -function statistics_referer_internal() { - $result = db_query("SELECT url, COUNT(url) AS count FROM referer WHERE url LIKE '". path_uri() ."%' GROUP BY url ORDER BY count DESC"); - - $output .= "<P>Internal referers of the last ". format_interval(variable_get("referer_clear", 604800)) .":</P>\n"; +function statistics_table_1($query) { + $result = db_query($query); $output .= "<TABLE BORDER=\"1\" CELLPADDING=\"3\" CELLSPACING=\"0\">\n"; - $output .= " <TR><TH>URL</TH><TH>number</TH></TR>\n"; + $output .= " <TR><TH>URL</TH><TH>date</TH></TR>\n"; while ($referer = db_fetch_object($result)) { - $output .= "<TR><TD><A HREF=\"". check_output($referer->url) ."\">". substr(check_output($referer->url), 0, 100) ."</A></TD><TD>". check_output($referer->count) ."</TD></TR>"; + $output .= "<TR><TD><A HREF=\"". check_output($referer->url) ."\">". substr(check_output($referer->url), 0, 100) ."</A></TD><TD>". format_date($referer->timestamp, "small") ."</TD></TR>"; } $output .= "</TABLE>\n"; return $output; } -function statistics_referer_external() { - $result = db_query("SELECT url, COUNT(url) AS count FROM referer WHERE url NOT LIKE '". path_uri() ."%' GROUP BY url ORDER BY count DESC"); - - $output .= "<P>External referers of the last ". format_interval(variable_get("referer_clear", 604800)) .":</P>\n"; +function statistics_table_2($query) { + $result = db_query($query); $output .= "<TABLE BORDER=\"1\" CELLPADDING=\"3\" CELLSPACING=\"0\">\n"; $output .= " <TR><TH>URL</TH><TH>number</TH></TR>\n"; @@ -59,6 +55,28 @@ function statistics_referer_external() { return $output; } +function statistics_referer_internal() { + $output .= "<H3>Most recent referers</H3>\n"; + $output .= statistics_table_1("SELECT url, timestamp FROM referer WHERE url LIKE '". path_uri() ."%' ORDER BY timestamp DESC LIMIT 15"); + + $output .= "<H3>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 '". path_uri() ."%' GROUP BY url ORDER BY count DESC"); + + return $output; +} + +function statistics_referer_external() { + $result = db_query("SELECT url, COUNT(url) AS count FROM referer WHERE url NOT LIKE '". path_uri() ."%' GROUP BY url ORDER BY count DESC"); + + $output .= "<H3>Most recent referers</H3>\n"; + $output .= statistics_table_1("SELECT url, timestamp FROM referer WHERE url NOT LIKE '". path_uri() ."%' ORDER BY timestamp DESC LIMIT 15"); + + $output .= "<H3>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 '". path_uri() ."%' GROUP BY url ORDER BY count DESC"); + + return $output; +} + function statistics_admin() { global $type; |