Changeset 862 in ExiteCMS for modules/common/forum_threads_list_panel/php-files/modules/forum_threads_list_panel/forum_threads_list_panel.php

Timestamp:

10/02/07 22:27:18 (5 years ago)

Author:

hverton

Message:

Added an image upload function to the Wiki module
Optimized the speed of the download panels
Fixed a crash due to "attachment to big" in M2F

File:

• modules/common/forum_threads_list_panel/php-files/modules/forum_threads_list_panel/forum_threads_list_panel.php (modified) (2 diffs)

modules/common/forum_threads_list_panel/php-files/modules/forum_threads_list_panel/forum_threads_list_panel.php

@@ -20 +20 @@
 // get the list of latest threads
 $result = dbquery(
-    "SELECT tf.*, tt.*, tu.user_id,user_name, MAX(tp.post_id) as last_id, COUNT(tp.post_id) as count_posts FROM ".$db_prefix."forums tf
+    "SELECT tf.*, tt.*, tu.user_id,user_name FROM ".$db_prefix."forums tf
     INNER JOIN ".$db_prefix."threads tt USING(forum_id)
     INNER JOIN ".$db_prefix."posts tp USING(thread_id)
@@ -38 +38 @@
     while ($data = dbarray($result)) {
         $data['poll'] = fpm_panels_poll_exists($data['forum_id'], $data['thread_id']);
-        $data['count_posts']--;
+        $data2 = dbarray(dbquery("SELECT MAX(post_id) AS last_id FROM ".$db_prefix."posts WHERE thread_id = '".$data['thread_id']."'"));
+        $data['last_id'] = $data2['last_id'];
+        $data['count_posts'] = dbcount("(*)", "posts", "thread_id = '".$data['thread_id']."'") - 1;
         $threadlist[] = $data;
     }