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

Changeset 4367


Ignore:
Timestamp:
Oct 12, 2007, 10:16:01 PM (13 years ago)
Author:
ebihara
Message:

#1399:退会時のSELECTはマスタDBを読むように修正

File:
1 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/branches/stable-2.10.x/webapp/lib/db/etc.php

    r4346 r4367  
    454454    // c_commu (画像)
    455455    $sql = 'SELECT * FROM c_commu WHERE c_member_id_admin = ?';
    456     $c_commu_list = db_get_all($sql, $single);
     456    $c_commu_list = db_get_all($sql, $single, 'main');
    457457
    458458    foreach ($c_commu_list as $c_commu) {
     
    469469                    ' ORDER BY r_datetime';
    470470                $params = array(intval($c_commu['c_commu_id']));
    471                 $new_admin_id = db_get_one($sql, $params);
     471                $new_admin_id = db_get_one($sql, $params, 'main');
    472472            } else {
    473473                $new_admin_id = $c_commu['c_member_id_sub_admin'];
     
    501501    // c_diary (画像)
    502502    $sql = 'SELECT * FROM c_diary WHERE c_member_id = ?';
    503     $c_diary_list = db_get_all($sql, $single);
     503    $c_diary_list = db_get_all($sql, $single, 'main');
    504504    foreach ($c_diary_list as $c_diary) {
    505505        image_data_delete($c_diary['image_filename_1']);
     
    510510        $sql = 'SELECT * FROM c_diary_comment WHERE c_diary_id = ?';
    511511        $params = array(intval($c_diary['c_diary_id']));
    512         $c_diary_comment_list = db_get_all($sql, $params);
     512        $c_diary_comment_list = db_get_all($sql, $params, 'main');
    513513        foreach ($c_diary_comment_list as $c_diary_comment) {
    514514            image_data_delete($c_diary_comment['image_filename_1']);
     
    527527    // c_member_pre
    528528    $sql = 'SELECT * FROM c_member_pre WHERE c_member_id_invite = ?';
    529     $c_member_pre_list = db_get_all($sql, $single);
     529    $c_member_pre_list = db_get_all($sql, $single, 'main');
    530530    foreach ($c_member_pre_list as $c_member_pre) {
    531531        // c_member_pre_profile
     
    548548    $sql = 'SELECT image_filename_1, image_filename_2, image_filename_3' .
    549549        ' FROM c_member WHERE c_member_id = ?';
    550     $c_member = db_get_row($sql, $single);
     550    $c_member = db_get_row($sql, $single, 'main');
    551551    image_data_delete($c_member['image_filename_1']);
    552552    image_data_delete($c_member['image_filename_2']);
Note: See TracChangeset for help on using the changeset viewer.