Changeset 445 for temp/test-xoops.ec-cube.net

Timestamp:

2006/12/04 23:50:03 (20 years ago)

Author:

uehara

Message:

 

File:

• temp/test-xoops.ec-cube.net/html/modules/newbb/blocks/newbb_new.php (modified) (1 diff)

temp/test-xoops.ec-cube.net/html/modules/newbb/blocks/newbb_new.php

@@ -49 +49 @@
         break;
     }
-    $query='SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.topic_time, t.topic_views, t.topic_replies, t.forum_id, f.forum_name FROM '.$db->prefix('bb_topics').' t, '.$db->prefix('bb_forums').' f WHERE f.forum_id=t.forum_id AND f.forum_type <> 1 ORDER BY '.$order.' DESC';
+    $query='SELECT c.cat_id, c.cat_title, t.topic_id, t.topic_title, t.topic_last_post_id, t.topic_time, t.topic_views, t.topic_replies, t.forum_id, f.forum_name FROM '.$db->prefix('bb_topics').' t, '.$db->prefix('bb_forums').' f,'.$db->prefix('bb_categories').' c  WHERE f.forum_id=t.forum_id AND f.cat_id=c.cat_id AND f.forum_type <> 1 ORDER BY '.$order.' DESC';
     if (!$result = $db->query($query,$options[0],0)) {
         return false;