diff options
| author | Dries Buytaert <dries@buytaert.net> | 2003-01-05 00:05:53 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2003-01-05 00:05:53 +0000 |
| commit | 36556762f97238fb055cb88f44570e6cfcd2e4a6 (patch) | |
| tree | df04626c2e4b661c6e5b499be79d55b42de08766 /modules | |
| parent | 520416d97752fb111dc0ca7132c0c949fba86944 (diff) | |
| download | brdo-36556762f97238fb055cb88f44570e6cfcd2e4a6.tar.gz brdo-36556762f97238fb055cb88f44570e6cfcd2e4a6.tar.bz2 | |
- Made a database query ASNI compliant. Patch by Ax.
Diffstat (limited to 'modules')
| -rw-r--r-- | modules/statistics.module | 2 | ||||
| -rw-r--r-- | modules/statistics/statistics.module | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/modules/statistics.module b/modules/statistics.module index af6387480..d465b23c3 100644 --- a/modules/statistics.module +++ b/modules/statistics.module @@ -353,7 +353,7 @@ function statistics_admin_accesslog_table($type, $id) { } else { /* retrieve recent access logs for all users */ - $result = db_query("SELECT nid, url, hostname, uid, MAX(timestamp) AS timestamp FROM accesslog WHERE uid <> '0' GROUP BY uid ORDER BY timestamp DESC LIMIT %s", $limit1); + $result = db_query("SELECT nid, url, hostname, uid, MAX(timestamp) AS timestamp FROM accesslog WHERE uid <> '0' GROUP BY uid, nid, url, hostname ORDER BY timestamp DESC LIMIT %s", $limit1); } } else if ($type == 2) { diff --git a/modules/statistics/statistics.module b/modules/statistics/statistics.module index af6387480..d465b23c3 100644 --- a/modules/statistics/statistics.module +++ b/modules/statistics/statistics.module @@ -353,7 +353,7 @@ function statistics_admin_accesslog_table($type, $id) { } else { /* retrieve recent access logs for all users */ - $result = db_query("SELECT nid, url, hostname, uid, MAX(timestamp) AS timestamp FROM accesslog WHERE uid <> '0' GROUP BY uid ORDER BY timestamp DESC LIMIT %s", $limit1); + $result = db_query("SELECT nid, url, hostname, uid, MAX(timestamp) AS timestamp FROM accesslog WHERE uid <> '0' GROUP BY uid, nid, url, hostname ORDER BY timestamp DESC LIMIT %s", $limit1); } } else if ($type == 2) { |