Changeset 7012

Timestamp:

May 7, 2008, 5:27:14 PM (14 years ago)

Author:

ebihara

Message:

#2149:MySQL4.0環境でポータルにコミュニティ最新書き込みが表示されなかったのを修正

Location:

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

Files:

• lib/db_portal.php (modified) (1 diff)
• templates/inc_portal_Contents_Layout.tpl (modified) (2 diffs)

OpenPNE/branches/stable-2.12.x/webapp/modules/portal/lib/db_portal.php

@@ -274 +274 @@
     $is_recurred = false;
 
-    $select = "SELECT ct.*, c.name as commu_name, ctc.r_datetime as comment_datetime, c.image_filename as image_filename";
+    $select = "SELECT ct.*, c.name as commu_name, c.image_filename as image_filename";
     $from = " FROM c_commu_topic as ct"
-          . " LEFT JOIN c_commu as c ON c.c_commu_id = ct.c_commu_id"
-          . " LEFT JOIN c_commu_topic_comment as ctc ON (ctc.c_commu_topic_id = ct.c_commu_topic_id AND ctc.number = (select max(number) FROM c_commu_topic_comment where c_commu_topic_id = ct.c_commu_topic_id))";
+          . " LEFT JOIN c_commu as c ON c.c_commu_id = ct.c_commu_id";
     $where = " WHERE c.public_flag = 'public'";
-    $order = " ORDER BY comment_datetime DESC";
+    $order = " ORDER BY ct.u_datetime DESC";
 
     $sql = $select . $from . $where . $order;

OpenPNE/branches/stable-2.12.x/webapp/modules/portal/templates/inc_portal_Contents_Layout.tpl

@@ -11 +11 @@
                             <span><img src="({t_img_url filename=$item.image_filename w=76 h=76 noimg=no_logo_small})" alt="({$item.commu_name})" /></span>
                             <dl>
-                                <dt>({$item.comment_datetime|date_format:"%m/%d"})</dt>
+                                <dt>({$item.u_datetime|date_format:"%m/%d"})</dt>
                                 <dd>({$item.name})&nbsp;(({$item.count_comments|number_format}))&nbsp;(({$item.commu_name}))</dd>
                             </dl>
@@ -32 +32 @@
                     <dl>
                         ({foreach from=$data.contents item=item})
-                        <dt>({$item.comment_datetime|date_format:"%m/%d"})</dt>
+                        <dt>({$item.u_datetime|date_format:"%m/%d"})</dt>
                         <dd>({$item.name})&nbsp;(({$item.count_comments|number_format}))&nbsp;(({$item.commu_name}))</dd>
                         ({/foreach})