From 680979845ad9c1648a1b262c0fff242ef219c18f Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Sun, 19 Apr 2009 18:51:37 +0000
Subject: - Patch #160226 by Berdir, Dave Reid, karschsp: fixed SQL query in
 statistics_node_tracker function.

---
 modules/statistics/statistics.pages.inc | 7 +++++--
 1 file changed, 5 insertions(+), 2 deletions(-)

(limited to 'modules')

diff --git a/modules/statistics/statistics.pages.inc b/modules/statistics/statistics.pages.inc
index 777080dd3..f416054fe 100644
--- a/modules/statistics/statistics.pages.inc
+++ b/modules/statistics/statistics.pages.inc
@@ -21,7 +21,9 @@ function statistics_node_tracker() {
     $query
       ->fields('a', array('aid', 'timestamp', 'url', 'uid'))
       ->fields('u', array('name'))
-      ->condition('path', 'node/' . $node->nid . '%', 'LIKE')
+      ->condition(db_or()
+        ->condition('a.path', 'node/' . $node->nid)
+        ->condition('a.path', 'node/' . $node->nid . '/%', 'LIKE'))
       ->limit(30)
       ->setHeader($header);
 
@@ -32,7 +34,8 @@ function statistics_node_tracker() {
         array('data' => format_date($log->timestamp, 'small'), 'class' => 'nowrap'),
         _statistics_link($log->url),
         theme('username', $log),
-        l(t('details'), "admin/reports/access/$log->aid"));
+        l(t('details'), "admin/reports/access/$log->aid"),
+      );
     }
 
     if (empty($rows)) {
-- 
cgit v1.2.3