Changeset 1509 in ExiteCMS for branches/PLi-Fusion/forum/index.php

Timestamp:

07/02/08 18:27:06 (4 years ago)

Author:

hverton

Message:

Merged trunk revisions 1408:1508 into the PLi-Fusion branch

File:

• branches/PLi-Fusion/forum/index.php (modified) (3 diffs)

branches/PLi-Fusion/forum/index.php

@@ -45 +45 @@
 $result = dbquery(
     "SELECT f.*, COUNT(t.thread_id) AS thread_count, MAX(t.thread_lastpost) AS last_post, f2.forum_name AS forum_cat_name, f2.forum_id as cat_id, u.user_id, u.user_name FROM ".$db_prefix."forums f
-    LEFT JOIN ".$db_prefix."threads t USING(forum_id)
-    LEFT JOIN ".$db_prefix."forums f2 ON f.forum_cat = f2.forum_id
-    LEFT JOIN ".$db_prefix."users u ON f.forum_lastuser = u.user_id
+    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
     WHERE ".groupaccess('f.forum_access')." AND f.forum_cat != '0' GROUP BY forum_id ORDER BY f2.forum_order ASC, f.forum_order ASC"
 );
@@ -84 +84 @@
                 SELECT count(*) as unread 
                     FROM ".$db_prefix."posts p 
-                        LEFT JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id 
+                        INNER JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id 
                     WHERE tr.user_id = '".$userdata['user_id']."' 
                         AND tr.forum_id = '".$data['forum_id']."' 
@@ -95 +95 @@
                 SELECT count(*) as unread 
                     FROM ".$db_prefix."posts p 
-                        LEFT JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id 
+                        INNER JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id 
                     WHERE tr.user_id = '".$userdata['user_id']."' 
                         AND tr.forum_id = '".$data['forum_id']."'