Changeset 9218

Timestamp:

Nov 18, 2008, 2:57:44 PM (14 years ago)

Author:

akamine

Message:

#1474 親記事に画像が付いている場合カメラの画像を表示するよう修正

File:

• OpenPNE/trunk/webapp/lib/db/commu.php (modified) (4 diffs)

OpenPNE/trunk/webapp/lib/db/commu.php

@@ -524 +524 @@
     foreach ($list as $key => $value) {
         $list[$key]['count_comments'] = db_commu_get_max_c_commu_topic_comment_number4c_topic_id($value['c_commu_topic_id']);
-        $last_comment = db_commu_get_last_c_topic_comment($value['c_commu_topic_id']);
-        $list[$key]['image_filename1'] = $last_comment['image_filename1'];
-        $list[$key]['image_filename2'] = $last_comment['image_filename2'];
-        $list[$key]['image_filename3'] = $last_comment['image_filename3'];
+        $start_comment = db_commu_get_start_c_topic_comment($value['c_commu_topic_id']);
+        $list[$key]['image_filename1'] = $start_comment['image_filename1'];
+        $list[$key]['image_filename2'] = $start_comment['image_filename2'];
+        $list[$key]['image_filename3'] = $start_comment['image_filename3'];
     }
     return $list;
@@ -1174 +1174 @@
         $c_commu_topic_list[$key]['nickname'] = $c_member['nickname'];
 
-        $temp = db_commu_get_last_c_topic_comment($value['c_commu_topic_id']);
+        $temp = db_commu_get_start_c_topic_comment($value['c_commu_topic_id']);
 
         $sql = 'SELECT name AS c_commu_name FROM c_commu WHERE c_commu_id = ?';
@@ -1214 +1214 @@
         $c_commu_topic_list[$key]['nickname'] = $c_member['nickname'];
 
-        $temp = db_commu_get_last_c_topic_comment($value['c_commu_topic_id']);
+        $temp = db_commu_get_start_c_topic_comment($value['c_commu_topic_id']);
 
         $sql = 'SELECT name AS c_commu_name FROM c_commu WHERE c_commu_id = ?';
@@ -3389 +3389 @@
 
 /*
- * 最終書き込みコメントの情報取得
- */
-function db_commu_get_last_c_topic_comment($c_commu_topic_id)
-{
-    $sql = 'SELECT * FROM c_commu_topic_comment WHERE c_commu_topic_id = ? ORDER BY r_datetime DESC';
+ * 最初の書き込みコメントの情報取得(親トピック)
+ */
+function db_commu_get_start_c_topic_comment($c_commu_topic_id)
+{
+    $sql = 'SELECT * FROM c_commu_topic_comment WHERE c_commu_topic_id = ? ORDER BY r_datetime ASC';
     $params = array(intval($c_commu_topic_id));
     return db_get_row($sql,$params);