Changeset 11173 for OpenPNE/trunk/webapp/lib/db/etc.php

Timestamp:

Mar 26, 2009, 9:47:06 AM (12 years ago)

Author:

nagasawa

Message:

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

File:

• OpenPNE/trunk/webapp/lib/db/etc.php (modified) (1 diff)

OpenPNE/trunk/webapp/lib/db/etc.php

@@ -986 +986 @@
     db_diary_delete4c_member_id($c_member_id);
 
+    // 対象メンバーのコメントをすべて削除
+    $sql = 'SELECT * FROM c_diary_comment WHERE c_member_id = ?';
+    $c_diary_comment_list = db_get_all($sql, $params, 'main');
+    foreach ($c_diary_comment_list as $c_diary_comment) {
+        db_image_data_delete($c_diary_comment['image_filename_1']);
+        db_image_data_delete($c_diary_comment['image_filename_2']);
+        db_image_data_delete($c_diary_comment['image_filename_3']);
+    }
+    $sql = 'DELETE FROM c_diary_comment WHERE c_member_id = ?';
+    db_query($sql, $params); 
+
     // アルバム
     db_album_delete4c_member_id($c_member_id);