Changeset 3693
- Timestamp:
- Aug 11, 2007, 2:03:58 AM (15 years ago)
- Location:
- OpenPNE/trunk/webapp
- Files:
-
- 5 edited
Legend:
- Unmodified
- Added
- Removed
-
OpenPNE/trunk/webapp/lib/db/commu.php
r3591 r3693 2793 2793 { 2794 2794 $select = 'SELECT c.name AS commu_name, c.image_filename AS commu_image' 2795 . ', ct.*, ctc.r_datetime';2795 . ', ct.*, MAX(ctc.r_datetime) AS max_datetime'; 2796 2796 $from = ' FROM c_commu AS c, c_commu_topic AS ct, c_commu_topic_comment AS ctc'; 2797 2797 … … 2827 2827 } 2828 2828 $group = ' GROUP BY ct.c_commu_topic_id'; 2829 $order = ' ORDER BY ctc.r_datetime DESC';2829 $order = ' ORDER BY max_datetime DESC'; 2830 2830 2831 2831 $sql = $select . $from . $where . $group . $order; … … 2838 2838 $sql = 'SELECT MAX(number) FROM c_commu_topic_comment WHERE c_commu_topic_id = ?'; 2839 2839 $list[$key]['max_number'] = db_get_one($sql, $p); 2840 $sql = 'SELECT MAX(r_datetime) FROM c_commu_topic_comment WHERE c_commu_topic_id = ?';2841 $list[$key]['last_datetime'] = db_get_one($sql, $p);2842 2840 } 2843 2841 -
OpenPNE/trunk/webapp/modules/ktai/templates/c_com_topic_find.tpl
r3481 r3693 10 10 11 11 ({foreach from=$c_commu_topic_search_list item=topic}) 12 ({$topic. last_datetime|date_format:"%m/%d"})12 ({$topic.max_datetime|date_format:"%m/%d"}) 13 13 <a href="({t_url m=ktai a=page_c_bbs})&target_c_commu_topic_id=({$topic.c_commu_topic_id})&({$tail})">({$topic.name})</a>(({$topic.max_number}))<br> 14 14 ({/foreach}) -
OpenPNE/trunk/webapp/modules/ktai/templates/h_com_topic_find_all.tpl
r3481 r3693 10 10 11 11 ({foreach from=$c_commu_topic_search_list item=topic}) 12 ({$topic. last_datetime|date_format:"%m/%d"}) (({$topic.commu_name}))<br>12 ({$topic.max_datetime|date_format:"%m/%d"}) (({$topic.commu_name}))<br> 13 13 <a href="({t_url m=ktai a=page_c_bbs})&target_c_commu_topic_id=({$topic.c_commu_topic_id})&({$tail})">({$topic.name})</a>(({$topic.max_number}))<br> 14 14 ({/foreach}) -
OpenPNE/trunk/webapp/modules/pc/templates/c_com_topic_find.tpl
r3480 r3693 290 290 <div class="padding_s"> 291 291 292 最終更新日292 投稿日 293 293 294 294 </div> … … 299 299 <div class="padding_s"> 300 300 301 ({$c_topic_search. last_datetime|date_format:"%m月%d日 %H:%M"})301 ({$c_topic_search.max_datetime|date_format:"%m月%d日 %H:%M"}) 302 302 303 303 </div> -
OpenPNE/trunk/webapp/modules/pc/templates/h_com_topic_find_all.tpl
r3482 r3693 297 297 <div class="padding_s"> 298 298 299 最終更新日299 投稿日 300 300 301 301 </div> … … 306 306 <div class="padding_s"> 307 307 308 ({$c_topic_search. last_datetime|date_format:"%m月%d日 %H:%M"})308 ({$c_topic_search.max_datetime|date_format:"%m月%d日 %H:%M"}) 309 309 310 310 </div>
Note: See TracChangeset
for help on using the changeset viewer.