diff options
| author | Neil Drumm <drumm@3064.no-reply.drupal.org> | 2006-08-26 00:19:02 +0000 |
|---|---|---|
| committer | Neil Drumm <drumm@3064.no-reply.drupal.org> | 2006-08-26 00:19:02 +0000 |
| commit | 07ad89db032ac09b6b9a434ae7e4ff0316eb0244 (patch) | |
| tree | df0aa45b90a18201bae521a23a1d9d71fc663a6f /modules | |
| parent | 19ba382adb65dc3c12a966c3ea662364885d443a (diff) | |
| download | brdo-07ad89db032ac09b6b9a434ae7e4ff0316eb0244.tar.gz brdo-07ad89db032ac09b6b9a434ae7e4ff0316eb0244.tar.bz2 | |
#70660 by pwolanin. Forum last post time was considering non-forum items.
Diffstat (limited to 'modules')
| -rw-r--r-- | modules/forum/forum.module | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/modules/forum/forum.module b/modules/forum/forum.module index 51c5a2895..ad2cc2c9d 100644 --- a/modules/forum/forum.module +++ b/modules/forum/forum.module @@ -749,7 +749,7 @@ function forum_get_forums($tid = 0) { // This query does not use full ANSI syntax since MySQL 3.x does not support // table1 INNER JOIN table2 INNER JOIN table3 ON table2_criteria ON table3_criteria // used to join node_comment_statistics to users. - $sql = "SELECT ncs.last_comment_timestamp, IF (ncs.last_comment_uid != 0, u2.name, ncs.last_comment_name) AS last_comment_name, ncs.last_comment_uid FROM {node} n INNER JOIN {users} u1 ON n.uid = u1.uid INNER JOIN {term_node} tn ON n.nid = tn.nid INNER JOIN {node_comment_statistics} ncs ON n.nid = ncs.nid INNER JOIN {users} u2 ON ncs.last_comment_uid=u2.uid WHERE n.status = 1 AND tn.tid = %d ORDER BY ncs.last_comment_timestamp DESC"; + $sql = "SELECT ncs.last_comment_timestamp, IF (ncs.last_comment_uid != 0, u2.name, ncs.last_comment_name) AS last_comment_name, ncs.last_comment_uid FROM {node} n INNER JOIN {users} u1 ON n.uid = u1.uid INNER JOIN {term_node} tn ON n.nid = tn.nid INNER JOIN {node_comment_statistics} ncs ON n.nid = ncs.nid INNER JOIN {users} u2 ON ncs.last_comment_uid=u2.uid WHERE n.status = 1 AND n.type='forum' AND tn.tid = %d ORDER BY ncs.last_comment_timestamp DESC"; $sql = db_rewrite_sql($sql); $topic = db_fetch_object(db_query_range($sql, $forum->tid, 0, 1)); |