Changeset 1218
- Timestamp:
- 2007/01/21 18:19:36 (17 years ago)
- Location:
- temp/test-xoops.ec-cube.net
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
temp/test-xoops.ec-cube.net/data/Smarty/templates/list.tpl
r1217 r1218 29 29 <td><!--{$arrResponse[$item.topic_response]}--><!--{if $item.uname != ""}--><br/>[<!--{$item.uname}-->]<!--{/if}--></td> 30 30 <td><!--{$item.topic_title}--></td> 31 <td><!--{$item.topic_time }--></td>31 <td><!--{$item.topic_time|sfDispDBDate}--></td> 32 32 </tr> 33 33 <!--{/foreach}--> -
temp/test-xoops.ec-cube.net/html/test/kakinaka/list.php
r1216 r1218 14 14 $objQuery = new SC_Query(); 15 15 16 $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';16 $sql = 'SELECT topic_id, topic_title, topic_response, 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'; 17 17 18 18 $arrList = $objQuery->getAll($sql);
Note: See TracChangeset
for help on using the changeset viewer.