diff options
| author | Dries Buytaert <dries@buytaert.net> | 2004-11-03 22:46:53 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2004-11-03 22:46:53 +0000 |
| commit | 4fa64b57c2269e462e33c582223c81f9105fca06 (patch) | |
| tree | 9f47dfd2a86ca4991c3dbdea9c180cf08e817bc7 /modules/forum.module | |
| parent | b63d529a15b76a19d88066bc09d514a54ddc57a7 (diff) | |
| download | brdo-4fa64b57c2269e462e33c582223c81f9105fca06.tar.gz brdo-4fa64b57c2269e462e33c582223c81f9105fca06.tar.bz2 | |
- Patch #12502 by Axel: fixed typo in SQL query: h.hid -> h.nid
Diffstat (limited to 'modules/forum.module')
| -rw-r--r-- | modules/forum.module | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/modules/forum.module b/modules/forum.module index 74baed433..b96d5da4b 100644 --- a/modules/forum.module +++ b/modules/forum.module @@ -459,7 +459,7 @@ function forum_get_topics($tid, $sortby, $forum_per_page) { function _forum_new($tid) { global $user; - $nid = db_result(db_query_range("SELECT n.nid FROM {node} n LEFT JOIN {history} h ON n.nid = h.hid AND h.uid = %d INNER JOIN {term_node} r ON n.nid = r.nid AND r.tid = %d " . node_access_join_sql() . " WHERE n.status = 1 AND n.type = 'forum' AND h.nid IS NULL AND n.created > %d AND " . node_access_where_sql() . " ORDER BY created", $user->uid, $tid, NODE_NEW_LIMIT, 0, 1)); + $nid = db_result(db_query_range("SELECT n.nid FROM {node} n LEFT JOIN {history} h ON n.nid = h.nid AND h.uid = %d INNER JOIN {term_node} r ON n.nid = r.nid AND r.tid = %d " . node_access_join_sql() . " WHERE n.status = 1 AND n.type = 'forum' AND h.nid IS NULL AND n.created > %d AND " . node_access_where_sql() . " ORDER BY created", $user->uid, $tid, NODE_NEW_LIMIT, 0, 1)); return $nid ? $nid : 0; } |