diff options
| -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 |