ここの情報は古いです。ご理解頂いた上でお取り扱いください。

Changeset 6872


Ignore:
Timestamp:
Apr 30, 2008, 10:28:57 PM (11 years ago)
Author:
ebihara
Message:

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

File:
1 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/branches/stable-2.12.x/webapp/lib/db/message.php

    r6799 r6872  
    691691        return null;
    692692    } else if ($box == 'outbox'){   //送信箱
    693         $where = " WHERE c_member_id_from = ?";
     693        $where = " WHERE c_member_id_from = ? AND is_deleted_from = 0";
    694694    } else {                        //受信箱
    695         $where = " WHERE c_member_id_to = ?";
     695        $where = " WHERE c_member_id_to = ? AND is_deleted_to = 0";
    696696    }
    697697
    698698    $sql =  "SELECT c_message_id FROM c_message" .
    699699            $where.
    700             " AND is_deleted_to = 0" .
    701700            " AND is_send = 1" .
    702701            " AND c_message_id > ?" .
     
    716715        return null;
    717716    } else if ($box == 'outbox'){   //送信箱
    718         $where = " WHERE c_member_id_from = ?";
     717        $where = " WHERE c_member_id_from = ? AND is_deleted_from = 0";
    719718    } else {                        //受信箱
    720         $where = " WHERE c_member_id_to = ?";
     719        $where = " WHERE c_member_id_to = ? AND is_deleted_to = 0";
    721720    }
    722721
    723722    $sql =  "SELECT c_message_id FROM c_message" .
    724723            $where.
    725             " AND is_deleted_to = 0" .
    726724            " AND is_send = 1" .
    727725            " AND c_message_id < ?" .
Note: See TracChangeset for help on using the changeset viewer.