Changeset 1513 in ExiteCMS for trunk/forum/index.php

Timestamp:

07/02/08 20:42:25 (4 years ago)

Author:

hverton

Message:

Changed two INNER queries back to LEFT JOINS, because a user does not always exist (p.e. in case of automatic post)

File:

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

trunk/forum/index.php

@@ -47 +47 @@
     INNER JOIN ".$db_prefix."threads t USING(forum_id)
     INNER JOIN ".$db_prefix."forums f2 ON f.forum_cat = f2.forum_id
-    INNER JOIN ".$db_prefix."users u ON f.forum_lastuser = u.user_id
+    LEFT JOIN ".$db_prefix."users u ON f.forum_lastuser = u.user_id
     WHERE ".groupaccess('f.forum_access')." AND f.forum_cat != '0' GROUP BY forum_id ORDER BY f2.forum_order ASC, f.forum_order ASC"
 );