Changeset 1291

Timestamp:

2007/01/22 13:47:53 (17 years ago)

Author:

kakinaka

Message:

 

File:

• temp/test-xoops.ec-cube.net/html/roadmap/index.php (modified) (1 diff)

temp/test-xoops.ec-cube.net/html/roadmap/index.php

@@ -16 +16 @@
 $xoopsTpl->assign('forum_name', 'Âбþ¾õ¶·°ìÍ÷');
 
-$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';
+$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 WHERE tpc.topic_response != 1 ORDER BY topic_response, topic_id DESC';
 if ( !$result = $xoopsDB->query($sql) ) {
     redirect_header('index.php',2,_MD_ERROROCCURED);