ここの情報は古いです。ご理解頂いた上でお取り扱いください。

Changeset 3693


Ignore:
Timestamp:
Aug 11, 2007, 2:03:58 AM (12 years ago)
Author:
ogawa
Message:

トピック検索機能の修正(並び順、表示日時、文言)
r3691 をマージ

Location:
OpenPNE/trunk/webapp
Files:
5 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/trunk/webapp/lib/db/commu.php

    r3591 r3693  
    27932793{
    27942794    $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';
    27962796    $from = ' FROM c_commu AS c, c_commu_topic AS ct, c_commu_topic_comment AS ctc';
    27972797
     
    28272827    }
    28282828    $group = ' GROUP BY ct.c_commu_topic_id';
    2829     $order = ' ORDER BY ctc.r_datetime DESC';
     2829    $order = ' ORDER BY max_datetime DESC';
    28302830
    28312831    $sql = $select . $from . $where . $group . $order;
     
    28382838        $sql = 'SELECT MAX(number) FROM c_commu_topic_comment WHERE c_commu_topic_id = ?';
    28392839        $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);
    28422840    }
    28432841
  • OpenPNE/trunk/webapp/modules/ktai/templates/c_com_topic_find.tpl

    r3481 r3693  
    1010
    1111({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"})
    1313<a href="({t_url m=ktai a=page_c_bbs})&amp;target_c_commu_topic_id=({$topic.c_commu_topic_id})&amp;({$tail})">({$topic.name})</a>(({$topic.max_number}))<br>
    1414({/foreach})
  • OpenPNE/trunk/webapp/modules/ktai/templates/h_com_topic_find_all.tpl

    r3481 r3693  
    1010
    1111({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>
    1313<a href="({t_url m=ktai a=page_c_bbs})&amp;target_c_commu_topic_id=({$topic.c_commu_topic_id})&amp;({$tail})">({$topic.name})</a>(({$topic.max_number}))<br>
    1414({/foreach})
  • OpenPNE/trunk/webapp/modules/pc/templates/c_com_topic_find.tpl

    r3480 r3693  
    290290<div class="padding_s">
    291291
    292 最終更新
     292投稿
    293293
    294294</div>
     
    299299<div class="padding_s">
    300300
    301 ({$c_topic_search.last_datetime|date_format:"%m月%d日 %H:%M"})
     301({$c_topic_search.max_datetime|date_format:"%m月%d日 %H:%M"})
    302302
    303303</div>
  • OpenPNE/trunk/webapp/modules/pc/templates/h_com_topic_find_all.tpl

    r3482 r3693  
    297297<div class="padding_s">
    298298
    299 最終更新
     299投稿
    300300
    301301</div>
     
    306306<div class="padding_s">
    307307
    308 ({$c_topic_search.last_datetime|date_format:"%m月%d日 %H:%M"})
     308({$c_topic_search.max_datetime|date_format:"%m月%d日 %H:%M"})
    309309
    310310</div>
Note: See TracChangeset for help on using the changeset viewer.