Changeset 7750

Timestamp:

Jul 18, 2008, 3:19:17 PM (13 years ago)

Author:

ebihara

Message:

#2689:r7729の変更により、ダッシュボードの「最新コミュニティ書き込み」のソート順や表示される日時が、コメントの書き込み時刻ではなくトピックの作成日時によっておこなうようになってしまっていたのを修正

Location:

OpenPNE/branches/stable-2.12.x/webapp/modules/admin

Files:

• lib/db_admin.php (modified) (2 diffs)
• templates/inc_dashboard.tpl (modified) (1 diff)

OpenPNE/branches/stable-2.12.x/webapp/modules/admin/lib/db_admin.php

@@ -2469 +2469 @@
     } 
 
-    $select = 'SELECT c.name AS commu_name, c.image_filename AS commu_image,'
-            . ' ct.*, ct.r_datetime AS max_datetime';
+    $select = 'SELECT c.name AS commu_name, c.image_filename AS commu_image, ct.*';
     $from   = ' FROM c_commu AS c, c_commu_topic AS ct, c_commu_topic_comment AS ctc';
     $params = array();
@@ -2476 +2475 @@
             . ' AND c.c_commu_id = ct.c_commu_id';
     $group  = ' GROUP BY ct.c_commu_topic_id';
-    $order  = ' ORDER BY max_datetime DESC';
+    $order  = ' ORDER BY ct.u_datetime DESC';
 
     $sql = $select . $from . $where . $group . $order;

OpenPNE/branches/stable-2.12.x/webapp/modules/admin/templates/inc_dashboard.tpl

@@ -75 +75 @@
 <dl>
 ({foreach from=$new_topic_list item=item})
-    <dt>({$item.max_datetime|date_format:"%m/%d %H:%M"})</dt>
+    <dt>({$item.u_datetime|date_format:"%m/%d %H:%M"})</dt>
     <dd><a href="({t_url _absolute=1 m=pc a=page_c_topic_detail})&amp;target_c_commu_topic_id=({$item.c_commu_topic_id})" target="_blank">({$item.name}) (({$item.count_comments|number_format}))</a> <span class="origin">(<a href="({t_url _absolute=1 m=pc a=page_c_home})&amp;target_c_commu_id=({$item.c_commu_id})" target="_blank">({$item.commu_name})</a>)</span></dd>
 ({/foreach})