diff options
| author | Dries Buytaert <dries@buytaert.net> | 2001-06-24 12:06:40 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2001-06-24 12:06:40 +0000 |
| commit | 4c50ea277662e08e266c806dffc3995a74b97ba6 (patch) | |
| tree | 11a7efe2d471bc5499d39ab75e5ae70f6ec62f85 | |
| parent | 4ace70a120c79924833a1653df1e56b06dbb7226 (diff) | |
| download | brdo-4c50ea277662e08e266c806dffc3995a74b97ba6.tar.gz brdo-4c50ea277662e08e266c806dffc3995a74b97ba6.tar.bz2 | |
- Small updates to statistics.module.
| -rw-r--r-- | modules/statistics.module | 20 | ||||
| -rw-r--r-- | modules/statistics/statistics.module | 20 | ||||
| -rw-r--r-- | updates/2.00-to-x.xx.sql | 4 |
3 files changed, 34 insertions, 10 deletions
diff --git a/modules/statistics.module b/modules/statistics.module index ba578e5b9..dac0694b9 100644 --- a/modules/statistics.module +++ b/modules/statistics.module @@ -21,13 +21,25 @@ function statistics_conf_options() { } function statistics_referer() { - $result = db_query("SELECT url, COUNT(url) AS count FROM referer GROUP BY url ORDER BY count"); + $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>Referers of the last ". format_interval(variable_get("referer_clear", 604800)) .":</P>\n"; + + $output .= "<H3>External referers</H3>\n"; + $output .= "<TABLE BORDER=\"1\" CELLPADDING=\"3\" CELLSPACING=\"0\">\n"; + $output .= " <TR><TH>URL</TH><TH>number</TH></TR>\n"; + while ($referer = db_fetch_object($result)) { + $output .= "<TR><TD><A HREF=\"". check_output($referer->url) ."\">". check_output($referer->url) ."</A></TD><TD>". check_output($referer->count) ."</TD></TR>"; + } + $output .= "</TABLE>\n"; + + $result = db_query("SELECT url, COUNT(url) AS count FROM referer WHERE url LIKE '". path_uri() ."%' GROUP BY url ORDER BY count DESC"); + + $output .= "<H3>Internal referers</H3>\n"; $output .= "<TABLE BORDER=\"1\" CELLPADDING=\"3\" CELLSPACING=\"0\">\n"; $output .= " <TR><TH>URL</TH><TH>number</TH></TR>\n"; while ($referer = db_fetch_object($result)) { - if (!ereg("^http://", $referer->url)) { - $output .= "<TR><TD><A HREF=\"". check_output($referer->url) ."\">". check_output($referer->url) ."</A></TD><TD>". check_output($referer->count) ."</TD></TR>"; - } + $output .= "<TR><TD><A HREF=\"". check_output($referer->url) ."\">". check_output($referer->url) ."</A></TD><TD>". check_output($referer->count) ."</TD></TR>"; } $output .= "</TABLE>\n"; diff --git a/modules/statistics/statistics.module b/modules/statistics/statistics.module index ba578e5b9..dac0694b9 100644 --- a/modules/statistics/statistics.module +++ b/modules/statistics/statistics.module @@ -21,13 +21,25 @@ function statistics_conf_options() { } function statistics_referer() { - $result = db_query("SELECT url, COUNT(url) AS count FROM referer GROUP BY url ORDER BY count"); + $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>Referers of the last ". format_interval(variable_get("referer_clear", 604800)) .":</P>\n"; + + $output .= "<H3>External referers</H3>\n"; + $output .= "<TABLE BORDER=\"1\" CELLPADDING=\"3\" CELLSPACING=\"0\">\n"; + $output .= " <TR><TH>URL</TH><TH>number</TH></TR>\n"; + while ($referer = db_fetch_object($result)) { + $output .= "<TR><TD><A HREF=\"". check_output($referer->url) ."\">". check_output($referer->url) ."</A></TD><TD>". check_output($referer->count) ."</TD></TR>"; + } + $output .= "</TABLE>\n"; + + $result = db_query("SELECT url, COUNT(url) AS count FROM referer WHERE url LIKE '". path_uri() ."%' GROUP BY url ORDER BY count DESC"); + + $output .= "<H3>Internal referers</H3>\n"; $output .= "<TABLE BORDER=\"1\" CELLPADDING=\"3\" CELLSPACING=\"0\">\n"; $output .= " <TR><TH>URL</TH><TH>number</TH></TR>\n"; while ($referer = db_fetch_object($result)) { - if (!ereg("^http://", $referer->url)) { - $output .= "<TR><TD><A HREF=\"". check_output($referer->url) ."\">". check_output($referer->url) ."</A></TD><TD>". check_output($referer->count) ."</TD></TR>"; - } + $output .= "<TR><TD><A HREF=\"". check_output($referer->url) ."\">". check_output($referer->url) ."</A></TD><TD>". check_output($referer->count) ."</TD></TR>"; } $output .= "</TABLE>\n"; diff --git a/updates/2.00-to-x.xx.sql b/updates/2.00-to-x.xx.sql index a6927ba1a..e8512c373 100644 --- a/updates/2.00-to-x.xx.sql +++ b/updates/2.00-to-x.xx.sql @@ -284,6 +284,6 @@ ALTER TABLE users CHANGE userid userid VARCHAR(32) DEFAULT '' NOT NULL; # 24/06/01 CREATE TABLE referer ( - url varchar(32) DEFAULT '' NOT NULL, + url varchar(255) DEFAULT '' NOT NULL, timestamp int(11) NOT NULL -); +);
\ No newline at end of file |