Changeset 1273

Timestamp:

2007/01/22 11:46:07 (17 years ago)

Author:

kakinaka

Message:

 

File:

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

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

@@ -204 +204 @@
 $xoopsTpl->assign('forum_name', 'Âбþ¾õ¶·°ìÍ÷');
 
-$sql = 'SELECT topic_id, topic_title, topic_response, from_unixtime(topic_last_posttime) 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, from_unixtime(topic_last_posttime) as topic_last_posttime, 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);