Changeset 1218


Ignore:
Timestamp:
2007/01/21 18:19:36 (17 years ago)
Author:
kakinaka
Message:
 
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  
    2929                <td><!--{$arrResponse[$item.topic_response]}--><!--{if $item.uname != ""}--><br/>[<!--{$item.uname}-->]<!--{/if}--></td> 
    3030                <td><!--{$item.topic_title}--></td> 
    31                 <td><!--{$item.topic_time}--></td> 
     31                <td><!--{$item.topic_time|sfDispDBDate}--></td> 
    3232            </tr> 
    3333            <!--{/foreach}--> 
  • temp/test-xoops.ec-cube.net/html/test/kakinaka/list.php

    r1216 r1218  
    1414$objQuery = new SC_Query(); 
    1515 
    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'; 
    1717 
    1818$arrList = $objQuery->getAll($sql); 
Note: See TracChangeset for help on using the changeset viewer.