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

Ignore:
Timestamp:
Mar 26, 2009, 9:47:06 AM (12 years ago)
Author:
nagasawa
Message:

#3723:r11164の修正分をdb_common_delete_c_member_write_allに移行

File:
1 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/trunk/webapp/lib/db/etc.php

    r11114 r11173  
    986986    db_diary_delete4c_member_id($c_member_id);
    987987
     988    // 対象メンバーのコメントをすべて削除
     989    $sql = 'SELECT * FROM c_diary_comment WHERE c_member_id = ?';
     990    $c_diary_comment_list = db_get_all($sql, $params, 'main');
     991    foreach ($c_diary_comment_list as $c_diary_comment) {
     992        db_image_data_delete($c_diary_comment['image_filename_1']);
     993        db_image_data_delete($c_diary_comment['image_filename_2']);
     994        db_image_data_delete($c_diary_comment['image_filename_3']);
     995    }
     996    $sql = 'DELETE FROM c_diary_comment WHERE c_member_id = ?';
     997    db_query($sql, $params);
     998
    988999    // アルバム
    9891000    db_album_delete4c_member_id($c_member_id);
Note: See TracChangeset for help on using the changeset viewer.