Changeset 1513 in ExiteCMS

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)

Location:

trunk/forum

Files:

• index.php (modified) (1 diff)
• viewthread.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"
 );

trunk/forum/viewthread.php

@@ -262 +262 @@
     $result = dbquery(
         "SELECT p.*, u.*, u2.user_name AS edit_name, u2.user_status AS edit_status FROM ".$db_prefix."posts p
-        INNER JOIN ".$db_prefix."users u ON p.post_author = u.user_id
+        LEFT JOIN ".$db_prefix."users u ON p.post_author = u.user_id
         LEFT JOIN ".$db_prefix."users u2 ON p.post_edituser = u2.user_id AND post_edituser > '0'
         WHERE p.thread_id='$thread_id' ORDER BY post_sticky DESC, post_datestamp ASC LIMIT $rowstart,".$settings['numofthreads']