Changeset 1549 in ExiteCMS for trunk/forum/viewforum.php

Timestamp:

07/27/08 14:22:31 (4 years ago)

Author:

root

Message:

fixed disappearing threads when a user_id in one of the posts was 0 (= automatic post).

File:

• trunk/forum/viewforum.php (modified) (1 diff)

trunk/forum/viewforum.php

@@ -151 +151 @@
             tu2.user_name AS user_lastuser, tu1.user_cc_code AS user_cc_code FROM ".$db_prefix."threads t
         INNER JOIN ".$db_prefix."posts p USING ( thread_id )
-        INNER JOIN ".$db_prefix."users tu1 ON t.thread_author = tu1.user_id
-        INNER JOIN ".$db_prefix."users tu2 ON t.thread_lastuser = tu2.user_id
+        LEFT JOIN ".$db_prefix."users tu1 ON t.thread_author = tu1.user_id
+        LEFT JOIN ".$db_prefix."users tu2 ON t.thread_lastuser = tu2.user_id
         WHERE t.forum_id = '".$forum_id."'
         GROUP BY thread_id