Changeset 1853 in ExiteCMS for trunk/forum/viewposts.php

Timestamp:

10/16/08 11:37:18 (4 years ago)

Author:

hverton

Message:

fixed session issue in the albums module
blog previous now breaks after a complete paragraph
fixed PHP notice in feeds.php when using PHP5
fixed MySQL error in viewforum.php/viewposts.php when using MySQL v5.x
fixed PHP warning in calls.httpdownload.php when using PHP5
added locale direction (ltr/rtl) to hoteditor
fixed issue with ocassional empty [URL] tags in hoteditor
fixed wrong returncode from sendemail() in sendmail_include.php
fixed issues in session management when behind loadbalanced proxies or ISP links (changing public IP address)
fixed typo in the album gallery edit template
fixed mismatched quotes in pm post causing hoteditor message retrieval to fail
fixed versioning issue in the menu, user info and welcome panel module installers
fixed PHP notice in setuser.php

File:

• trunk/forum/viewposts.php (modified) (2 diffs)

trunk/forum/viewposts.php

@@ -38 +38 @@
     "SELECT tp.*, tf.* FROM ".$db_prefix."posts tp
     INNER JOIN ".$db_prefix."threads th USING(thread_id)
-    INNER JOIN ".$db_prefix."forums tf USING(forum_id)
+    INNER JOIN ".$db_prefix."forums tf ON tp.forum_id = tf.forum_id
     WHERE ".($thread_limit==0?"":" th.thread_lastpost > ".$thread_limit." AND ").groupaccess('forum_access').($forum_id ? " AND tp.forum_id = '$forum_id'" : "")
 );
@@ -52 +52 @@
     "SELECT tp.*, tf.* FROM ".$db_prefix."posts tp
     INNER JOIN ".$db_prefix."threads th USING(thread_id)
-    INNER JOIN ".$db_prefix."forums tf USING(forum_id)
+    INNER JOIN ".$db_prefix."forums tf ON tp.forum_id = tf.forum_id
     WHERE ".($thread_limit==0?"":" th.thread_lastpost > ".$thread_limit." AND ").groupaccess('forum_access').($forum_id ? " AND tp.forum_id = '$forum_id'" : "")."
     ORDER BY post_datestamp DESC