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

Changeset 11173


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

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

Location:
OpenPNE/trunk/webapp/lib/db
Files:
2 edited

Legend:

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

    r11164 r11173  
    13381338    $sql = 'DELETE FROM c_diary WHERE c_member_id = ?';
    13391339    db_query($sql, $single);
    1340 
    1341     // 対象メンバーのコメントをすべて削除
    1342     $sql = 'SELECT * FROM c_diary_comment WHERE c_member_id = ?';
    1343     $c_diary_comment_list = db_get_all($sql, $single, 'main');
    1344     foreach ($c_diary_comment_list as $c_diary_comment) {
    1345         db_image_data_delete($c_diary_comment['image_filename_1']);
    1346         db_image_data_delete($c_diary_comment['image_filename_2']);
    1347         db_image_data_delete($c_diary_comment['image_filename_3']);
    1348     }
    1349     $sql = 'DELETE FROM c_diary_comment WHERE c_member_id = ?';
    1350     db_query($sql, $single);
    13511340}
    13521341
  • 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.