diff options
| author | Dries Buytaert <dries@buytaert.net> | 2009-04-01 20:00:47 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2009-04-01 20:00:47 +0000 |
| commit | 27d7455edb329f590aa55b3932500b74f9926855 (patch) | |
| tree | 4d9802bfdace4161bbfac1d9629b5c288c7e1d3b /modules/statistics | |
| parent | c403b16006428696815d3fc8fc9640c976d80e13 (diff) | |
| download | brdo-27d7455edb329f590aa55b3932500b74f9926855.tar.gz brdo-27d7455edb329f590aa55b3932500b74f9926855.tar.bz2 | |
- Patch #333054 by c960657: page cache should be case sensitive.
Diffstat (limited to 'modules/statistics')
| -rw-r--r-- | modules/statistics/statistics.admin.inc | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/modules/statistics/statistics.admin.inc b/modules/statistics/statistics.admin.inc index d527ae4c8..d596b1c95 100644 --- a/modules/statistics/statistics.admin.inc +++ b/modules/statistics/statistics.admin.inc @@ -107,8 +107,8 @@ function statistics_top_visitors() { * Menu callback; presents the "referrer" page. */ function statistics_top_referrers() { - $query = "SELECT url, COUNT(url) AS hits, MAX(timestamp) AS last FROM {accesslog} WHERE url NOT LIKE :host AND url <> '' GROUP BY url"; - $query_cnt = "SELECT COUNT(DISTINCT(url)) FROM {accesslog} WHERE url <> '' AND url NOT LIKE :host"; + $query = "SELECT url, COUNT(url) AS hits, MAX(timestamp) AS last FROM {accesslog} WHERE LOWER(url) NOT LIKE :host AND url <> '' GROUP BY url"; + $query_cnt = "SELECT COUNT(DISTINCT(url)) FROM {accesslog} WHERE url <> '' AND LOWER(url) NOT LIKE :host"; drupal_set_title(t('Top referrers in the past %interval', array('%interval' => format_interval(variable_get('statistics_flush_accesslog_timer', 259200)))), PASS_THROUGH); $header = array( |