diff options
author | Dries Buytaert <dries@buytaert.net> | 2010-02-28 20:10:34 +0000 |
---|---|---|
committer | Dries Buytaert <dries@buytaert.net> | 2010-02-28 20:10:34 +0000 |
commit | 897817eb0c431a4ea6585dea470c8bc43e08b824 (patch) | |
tree | a5e99e8b58cb9956a8a24924cfd66afa15f836c2 /modules/statistics | |
parent | 994fafcebf25c17776026194ca01b04a170d6d50 (diff) | |
download | brdo-897817eb0c431a4ea6585dea470c8bc43e08b824.tar.gz brdo-897817eb0c431a4ea6585dea470c8bc43e08b824.tar.bz2 |
- Patch #279851 by catch, David Strauss, Damien Tournoud, asimmonds, c960657, JohnAlbin, drawk, pwolanin, robertDouglass, coltrane: replace LOWER() with db_select() and LIKE() where possible.
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 303eafa44..b9e986b85 100644 --- a/modules/statistics/statistics.admin.inc +++ b/modules/statistics/statistics.admin.inc @@ -160,7 +160,7 @@ function statistics_top_referrers() { $query->addExpression('MAX(timestamp)', 'last'); $query ->fields('a', array('url')) - ->where('LOWER(url) NOT LIKE :host', array(':host' => '%' . $_SERVER['HTTP_HOST'] . '%')) + ->condition('url', '%' . $_SERVER['HTTP_HOST'] . '%', 'NOT LIKE') ->condition('url', '', '<>') ->groupBy('url') ->limit(30) @@ -169,7 +169,7 @@ function statistics_top_referrers() { $count_query = db_select('accesslog', 'a', array('target' => 'slave')); $count_query->addExpression('COUNT(DISTINCT url)'); $count_query - ->where('LOWER(url) NOT LIKE :host', array(':host' => '%' . $_SERVER['HTTP_HOST'] . '%')) + ->condition('url', '%' . $_SERVER['HTTP_HOST'] . '%', 'NOT LIKE') ->condition('url', '', '<>'); $query->setCountQuery($count_query); |