diff options
| author | Dries Buytaert <dries@buytaert.net> | 2003-09-09 18:18:43 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2003-09-09 18:18:43 +0000 |
| commit | 8e657f64efb3c3e12365d1c33e6ab89e40d9bfd5 (patch) | |
| tree | af96a46601a88e0be7089151a7bdb95afd54c310 /modules/statistics.module | |
| parent | accebe358c1cb4b07e6dba7f9f7776fe3b09d242 (diff) | |
| download | brdo-8e657f64efb3c3e12365d1c33e6ab89e40d9bfd5.tar.gz brdo-8e657f64efb3c3e12365d1c33e6ab89e40d9bfd5.tar.bz2 | |
- Gerhard's uid 0 patches. These patches bring various performance
improvements. Requires a database update.
Diffstat (limited to 'modules/statistics.module')
| -rw-r--r-- | modules/statistics.module | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/modules/statistics.module b/modules/statistics.module index 76e24a3f3..48e0dc8bb 100644 --- a/modules/statistics.module +++ b/modules/statistics.module @@ -728,7 +728,7 @@ function statistics_display_online_block() { /* Display linked title based on field name */ function statistics_title_list($dbfield, $dbrows) { /* valid dbfields: totalcount, daycount, timestamp */ - return db_query_range("SELECT s.nid, n.title, u.uid, u.name FROM {statistics} s INNER JOIN {node} n ON s.nid = n.nid LEFT JOIN {users} u ON n.uid = u.uid WHERE %s <> '0' AND n.status = 1 ORDER BY %s DESC", "s.". $dbfield, "s.". $dbfield, 0, $dbrows); + return db_query_range("SELECT s.nid, n.title, u.uid, u.name FROM {statistics} s INNER JOIN {node} n ON s.nid = n.nid INNER JOIN {users} u ON n.uid = u.uid WHERE %s <> '0' AND n.status = 1 ORDER BY %s DESC", "s.". $dbfield, "s.". $dbfield, 0, $dbrows); } |