Changeset 1216

Timestamp:

2007/01/21 18:16:15 (17 years ago)

Author:

kakinaka

Message:

 

Location:

temp/test-xoops.ec-cube.net

Files:

• data/Smarty/templates/list.tpl (modified) (2 diffs)
• html/modules/newbb/topic_list.php (deleted)
• html/test/kakinaka/list.php (modified) (1 diff)

temp/test-xoops.ec-cube.net/data/Smarty/templates/list.tpl

@@ -22 +22 @@
             <tr align="center" bgcolor="#aaaaff">
                 <td><strong>Âбþ¾õ¶·</strong></td>
+                <td><strong>¹¹¿·¼Ô</strong></td>
                 <td><strong>¥¹¥ì¥Ã¥É</strong></td>
                 <td><strong>ÅÐÏ¿Æü»þ</strong></td>
@@ -28 +29 @@
             <tr bgcolor="#ffffff">
                 <td><!--{$arrResponse[$item.topic_response]}--></td>
+                <td><!--{$item.uname}--></td>
                 <td><!--{$item.topic_title}--></td>
                 <td><!--{$item.topic_time}--></td>

temp/test-xoops.ec-cube.net/html/test/kakinaka/list.php

@@ -14 +14 @@
 $objQuery = new SC_Query();
 
-
-$sql = 'SELECT topic_id, topic_title, topic_response, topic_time FROM xoops_bb_topics ORDER BY topic_response, topic_id';
+$sql = 'SELECT topic_id, topic_title, topic_response, 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';
 
 $arrList = $objQuery->getAll($sql);