Changeset 1281

Timestamp:

2007/01/22 12:12:47 (17 years ago)

Author:

kakinaka

Message:

 

File:

• temp/test-xoops.ec-cube.net/html/modules/newbb/response.php (modified) (2 diffs)

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

@@ -176 +176 @@
 $xoopsTpl->assign('forum_name', 'Âбþ¾õ¶·°ìÍ÷');
 
-$sql = 'SELECT topic_id, topic_title, topic_response, topic_last_post_id, from_unixtime(topic_time) as topic_time, uname FROM xoops_bb_topics as tpc left join xoops_users as usr on tpc.topic_response_uid = usr.uid ORDER BY topic_response, topic_id DESC';
+$sql = 'SELECT topic_id, topic_title, topic_response, topic_last_post_id, forum_id,  from_unixtime(topic_time) as topic_time, uname FROM xoops_bb_topics as tpc left join xoops_users as usr on tpc.topic_response_uid = usr.uid ORDER BY topic_response, topic_id DESC';
 if ( !$result = $xoopsDB->query($sql) ) {
     redirect_header('index.php',2,_MD_ERROROCCURED);
@@ -185 +185 @@
 $topic_lastread = newbb_get_topics_viewed();
 while ( $myrow = $xoopsDB->fetchArray($result) ) {
-    $fix = getFixName($myrow['topic_id']);
+    $fix = getFixName($myrow['forum_id']);
     
     $xoopsTpl->append('topics', array(