Changeset 8244 for OpenPNE/branches/stable-2.10.x/webapp/lib/db/commu.php

Timestamp:

Sep 8, 2008, 9:25:54 PM (12 years ago)

Author:

shingo

Message:

#2856:コミュニティを退会したメンバーがイベントの参加メンバーに残らないように修正

File:

• OpenPNE/branches/stable-2.10.x/webapp/lib/db/commu.php (modified) (1 diff)

OpenPNE/branches/stable-2.10.x/webapp/lib/db/commu.php

@@ -2769 +2769 @@
            ' WHERE c_commu_id = ? AND c_member_id_to = ?';
     db_query($sql, $params);
+    
+    //参加イベント情報削除
+    $sql = "SELECT ct.c_commu_topic_id"
+         . " FROM c_commu_topic ct"
+         . " LEFT JOIN c_event_member cem ON ct.c_commu_topic_id = cem.c_commu_topic_id"
+         . " WHERE ct.c_commu_id = ?"
+         . " AND cem.c_member_id = ?";
+    $params = array(intval($c_commu_id), intval($c_member_id));
+    $c_event_list = db_get_all($sql, $params);
+    foreach ($c_event_list as $c_event) {
+        db_commu_delete_c_event_member($c_event['c_commu_topic_id'], $c_member_id);
+    }
 
     //コミュニティから退会