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

Changeset 6871


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

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

File:
1 edited

Legend:

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

    r4682 r6871  
    690690        return null;
    691691    } else if ($box == 'outbox'){   //送信箱
    692         $where = " WHERE c_member_id_from = ?";
     692        $where = " WHERE c_member_id_from = ? AND is_deleted_from = 0";
    693693    } else {                        //受信箱
    694         $where = " WHERE c_member_id_to = ?";
     694        $where = " WHERE c_member_id_to = ? AND is_deleted_to = 0";
    695695    }
    696696
    697697    $sql =  "SELECT c_message_id FROM c_message" .
    698698            $where.
    699             " AND is_deleted_to = 0" .
    700699            " AND is_send = 1" .
    701700            " AND c_message_id > ?" .
     
    715714        return null;
    716715    } else if ($box == 'outbox'){   //送信箱
    717         $where = " WHERE c_member_id_from = ?";
     716        $where = " WHERE c_member_id_from = ? AND is_deleted_from = 0";
    718717    } else {                        //受信箱
    719         $where = " WHERE c_member_id_to = ?";
     718        $where = " WHERE c_member_id_to = ? AND is_deleted_to = 0";
    720719    }
    721720
    722721    $sql =  "SELECT c_message_id FROM c_message" .
    723722            $where.
    724             " AND is_deleted_to = 0" .
    725723            " AND is_send = 1" .
    726724            " AND c_message_id < ?" .
Note: See TracChangeset for help on using the changeset viewer.