Changeset 2215

Timestamp:

Mar 21, 2007, 3:11:09 PM (15 years ago)

Author:

ebihara

Message:

#547 コミュニティリストのソート順が正しくなかったのを修正

File:

• OpenPNE/branches/ebihara/prj_dev28_misc01/webapp/lib/db/commu.php (modified) (6 diffs)

OpenPNE/branches/ebihara/prj_dev28_misc01/webapp/lib/db/commu.php

@@ -802 +802 @@
 
     $hint = db_mysql_hint('USE INDEX (r_datetime_c_commu_id)');
-    $sql = 'SELECT c_commu_id, c_commu_topic_id, name AS c_commu_topic_name, r_datetime, c_member_id'.
-        ' FROM c_commu_topic'. $hint . ' WHERE c_commu_id IN (' . $ids . ') ORDER BY r_datetime DESC';
+    $sql = 'SELECT cct.c_commu_topic_id, cct.c_commu_id, MAX(cctc.r_datetime) as r_datetime, cct.c_member_id'.
+        ' FROM c_commu_topic as cct, c_commu_topic_comment as cctc'. $hint . ' WHERE cct.c_commu_id IN (' . $ids . ') AND cctc.c_commu_topic_id = cct.c_commu_topic_id'.
+        ' GROUP BY cctc.c_commu_topic_id'.
+        ' ORDER BY r_datetime DESC';
     $c_commu_topic_list = db_get_all_limit($sql, 0, $limit);
 
@@ -819 +821 @@
         $c_commu_name = db_get_one($sql, $value['c_commu_id']);
 
+        $sql = 'SELECT name FROM c_commu_topic WHERE c_commu_topic_id = ?';
+        $c_commu_topic_name = db_get_one($sql, $value['c_commu_topic_id']);
+
         //最新の書き込み番号
         $number = db_commu_get_max_number4topic($value['c_commu_topic_id']);
@@ -827 +832 @@
         $c_commu_topic_list[$key]['image_filename3'] = $temp['image_filename3'];
         $c_commu_topic_list[$key]['c_commu_name'] = $c_commu_name;
+        $c_commu_topic_list[$key]['c_commu_topic_name'] = $c_commu_topic_name;
     }
 
@@ -839 +845 @@
 
     $hint = db_mysql_hint('USE INDEX (r_datetime_c_commu_id)');
-    $sql = 'SELECT c_commu_id, c_commu_topic_id, name AS c_commu_topic_name, r_datetime, c_member_id'.
-        ' FROM c_commu_topic'. $hint . ' WHERE c_commu_id IN (' . $ids . ') ORDER BY r_datetime DESC';
+    $sql = 'SELECT cct.c_commu_topic_id, cct.c_commu_id, MAX(cctc.r_datetime) as r_datetime, cct.c_member_id'.
+        ' FROM c_commu_topic as cct, c_commu_topic_comment as cctc'. $hint . ' WHERE cct.c_commu_id IN (' . $ids . ') AND cctc.c_commu_topic_id = cct.c_commu_topic_id'.
+        ' GROUP BY cctc.c_commu_topic_id'.
+        ' ORDER BY r_datetime DESC';
     $c_commu_topic_list = db_get_all_limit($sql, ($page-1)*$limit, $limit);
 
@@ -856 +864 @@
         $c_commu_name = db_get_one($sql, $value['c_commu_id']);
 
+        $sql = 'SELECT name FROM c_commu_topic WHERE c_commu_topic_id = ?';
+        $c_commu_topic_name = db_get_one($sql, $value['c_commu_topic_id']);
+
         //最新の書き込み番号
         $number = db_commu_get_max_number4topic($value['c_commu_topic_id']);
@@ -864 +875 @@
         $c_commu_topic_list[$key]['image_filename3'] = $temp['image_filename3'];
         $c_commu_topic_list[$key]['c_commu_name'] = $c_commu_name;
+        $c_commu_topic_list[$key]['c_commu_topic_name'] = $c_commu_topic_name;
     }