Changeset 6977

Timestamp:

May 5, 2008, 10:54:58 PM (14 years ago)

Author:

ebihara

Message:

#2082:次・前のメッセージを取得する際、削除フラグを考慮するようにした

File:

• OpenPNE/trunk/webapp/lib/db/message.php (modified) (2 diffs)

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

@@ -691 +691 @@
         return null;
     } else if ($box == 'outbox'){   //送信箱
-        $where = " WHERE c_member_id_from = ?";
+        $where = " WHERE c_member_id_from = ? AND is_deleted_from = 0";
     } else {                        //受信箱
-        $where = " WHERE c_member_id_to = ?";
+        $where = " WHERE c_member_id_to = ? AND is_deleted_to = 0";
     }
 
     $sql =  "SELECT c_message_id FROM c_message" .
             $where.
-            " AND is_deleted_to = 0" .
             " AND is_send = 1" .
             " AND c_message_id > ?" .
@@ -716 +715 @@
         return null;
     } else if ($box == 'outbox'){   //送信箱
-        $where = " WHERE c_member_id_from = ?";
+        $where = " WHERE c_member_id_from = ? AND is_deleted_from = 0";
     } else {                        //受信箱
-        $where = " WHERE c_member_id_to = ?";
+        $where = " WHERE c_member_id_to = ? AND is_deleted_to = 0";
     }
 
     $sql =  "SELECT c_message_id FROM c_message" .
             $where.
-            " AND is_deleted_to = 0" .
             " AND is_send = 1" .
             " AND c_message_id < ?" .