Changeset 963

Timestamp:

Nov 30, 2006, 5:41:17 PM (16 years ago)

Author:

ebihara

Message:

カテゴリ日記リスト表示時に、メンバーIDと関連しないカテゴリIDを指定すると表示がおかしくなっていたバグの修正。

File:

• OpenPNE/branches/ebihara/dev_2_6/webapp/lib/db/diary.php (modified) (1 diff)

OpenPNE/branches/ebihara/dev_2_6/webapp/lib/db/diary.php

@@ -75 +75 @@
     $pf_cond = db_diary_public_flag_condition($c_member_id, $u);
     $sql = 'SELECT * FROM c_diary' .
-        ' WHERE c_diary_id IN ('.$ids.')' . $pf_cond . ' ORDER BY r_datetime DESC';
-    $list = db_get_all($sql);
+        ' WHERE c_diary_id IN ('.$ids.') AND c_member_id = ? ' . $pf_cond . ' ORDER BY r_datetime DESC';
+    $list = db_get_all($sql, array($c_member_id));
 
     foreach ($list as $key => $c_diary) {