/** * コミュニティ情報取得関連のfunction cacheを削除する */ function cache_drop_c_commu($c_commu_id) { $c_commu_id = (int) $c_commu_id; pne_cache_drop('db_commu_c_commu4c_commu_id_k', $c_commu_id); pne_cache_drop('db_commu_c_commu_member_list_random4c_commu_id', $c_commu_id, 5); pne_cache_drop('db_commu_c_commu_member_list4c_commu_id', $c_commu_id, 9); pne_cache_drop('db_commu_c_commu4c_commu_id2', $c_commu_id); $c_commu_id = (string) $c_commu_id; pne_cache_drop('db_commu_c_commu4c_commu_id_k', $c_commu_id); pne_cache_drop('db_commu_c_commu_member_list_random4c_commu_id', $c_commu_id, 5); pne_cache_drop('db_commu_c_commu_member_list4c_commu_id', $c_commu_id, 9); pne_cache_drop('db_commu_c_commu4c_commu_id2', $c_commu_id); $c_commu_topic_list = db_commu_new_topic_comment4c_commu_id($c_commu_id, 7); $c_commu_event_list = db_commu_new_topic_comment4c_commu_id($c_commu_id, 7, 1); $c_commu_bbs_list = array_merge($c_commu_topic_list, $c_commu_event_list); foreach ($c_commu_bbs_list as $c_commu_topic_id) { $c_commu_topic_id = (int) $c_commu_topic_id; cache_drop_c_commu_topic($c_commu_topic_id); $c_commu_topic_id = (string) $c_commu_topic_id; cache_drop_c_commu_topic($c_commu_topic_id); } $c_commu_member_total_num = db_commu_count_c_commu_member_list4c_commu_id($c_commu_id); $c_commu_member_list = db_commu_c_member_list4c_commu_id($c_commu_id, 1, $c_commu_member_total_num); foreach ($c_commu_member_list[0] as $c_member) { cache_drop_c_commu_list4c_member_id($c_member['c_member_id']); } }
/** * コミュニティからメンバーを削除 */ function db_commu_delete_c_commu_member($c_commu_id, $c_member_id) { //function cache削除 cache_drop_c_commu($c_commu_id); cache_drop_c_commu_list4c_member_id($c_member_id); //おすすめレビューを削除 $sql = 'DELETE FROM c_commu_review' . ' WHERE c_commu_id = ? AND c_member_id = ?'; $params = array(intval($c_commu_id), intval($c_member_id)); db_query($sql, $params); //副管理者なら副管理者のポストを空に $sql = 'UPDATE c_commu' . ' SET c_member_id_sub_admin = 0' . ' WHERE c_commu_id = ? AND c_member_id_sub_admin = ?'; db_query($sql, $params); //管理者承認依頼 $sql = 'DELETE FROM c_commu_admin_confirm' . ' WHERE c_commu_id = ? AND c_member_id_to = ?'; db_query($sql, $params); //副管理者承認依頼 $sql = 'DELETE FROM c_commu_sub_admin_confirm' . ' 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 = ?'; $c_commu_topic_id_list = db_get_col($sql, $params, 'main'); foreach ($c_commu_topic_id_list as $c_commu_topic_id) { db_commu_delete_c_event_member($c_commu_topic_id, $c_member_id); } //コミュニティから退会 $sql = 'DELETE FROM c_commu_member' . ' WHERE c_commu_id = ? AND c_member_id = ?'; db_query($sql, $params); }