function execute($requests) { $u = $GLOBALS['AUTH']->uid(); $target_c_commu_topic_id = $requests['target_c_commu_topic_id']; //--- 権限チェック //コミュニティ管理者 or トピック作成者 $c_commu_topic = db_commu_c_commu_topic4c_commu_topic_id($target_c_commu_topic_id); $c_commu_id = $c_commu_topic['c_commu_id']; $status = db_common_commu_status($u, $c_commu_id); if (!$status['is_commu_admin'] && $c_commu_topic['c_member_id'] != $u) { handle_kengen_error(); } $c_commu = db_commu_c_commu4c_commu_id2($c_commu_id); if ($c_commu['is_topic'] == 'admin_only' && !db_commu_is_c_commu_admin($c_commu_id, $u)) { handle_kengen_error(); } if ($c_commu['is_topic'] == 'member' && !db_commu_is_c_commu_member($c_commu_id, $u)) { handle_kengen_error(); } //--- db_commu_delete_c_commu_topic($target_c_commu_topic_id); $p = array('target_c_commu_id' => $c_commu_topic['c_commu_id']); if ($c_commu_topic['event_flag']) { openpne_redirect('pc', 'page_c_event_list', $p); } else { openpne_redirect('pc', 'page_c_topic_list', $p); } }
function execute($requests) { $topic = db_commu_c_topic4c_commu_topic_id($requests['target_c_commu_topic_id']); if (!$topic) { admin_client_redirect('topic_list', '指定されたトピック・イベントは存在しません'); } db_commu_delete_c_commu_topic($requests['target_c_commu_topic_id']); admin_client_redirect('topic_list', WORD_COMMUNITY . 'トピックを削除しました'); }
function execute($requests) { $id_ary = split(":", $requests['target_c_commu_topic_ids']); foreach ($id_ary as $id) { $topic = db_commu_c_topic4c_commu_topic_id($id); if (!$topic) { admin_client_redirect('topic_list', '指定されたトピック・イベントは存在しません'); } } foreach ($id_ary as $id) { db_commu_delete_c_commu_topic($id); } admin_client_redirect('topic_list', WORD_COMMUNITY . 'トピックを削除しました'); }
function execute($requests) { $u = $GLOBALS['KTAI_C_MEMBER_ID']; $tail = $GLOBALS['KTAI_URL_TAIL']; $target_c_commu_topic_id = $requests['target_c_commu_topic_id']; //--- 権限チェック //コミュニティ管理者 or トピック作成者 $c_commu_topic = db_commu_c_commu_topic4c_commu_topic_id($target_c_commu_topic_id); $c_commu_id = $c_commu_topic['c_commu_id']; $status = db_common_commu_status($u, $c_commu_id); if (!$status['is_commu_admin'] && $c_commu_topic['c_member_id'] != $u) { handle_kengen_error(); } //--- db_commu_delete_c_commu_topic($target_c_commu_topic_id); $p = array('target_c_commu_id' => $c_commu_topic['c_commu_id']); openpne_redirect('ktai', 'page_c_home', $p); }
/** * 指定メンバーの書き込み一括削除 * 以下の書き込みが削除対象 * ・日記、日記コメント * ・トピック・イベント、トピック・イベントのコメント * ・送信メッセージ * ・アルバム * * @param int $c_member_id */ function db_common_delete_c_member_write_all($c_member_id) { $params = array(intval($c_member_id)); ///コミュニティ関連 // トピック・イベント削除 $sql = 'SELECT c_commu_topic_id FROM c_commu_topic WHERE c_member_id = ?'; $c_topic_list = db_get_all($sql, $params, 'main'); foreach ($c_topic_list as $c_topic) { // 削除 db_commu_delete_c_commu_topic($c_topic['c_commu_topic_id']); } // トピック・イベントのコメント削除 $sql = 'SELECT c_commu_topic_comment_id FROM c_commu_topic_comment WHERE c_member_id = ?'; $c_topic_comment_list = db_get_all($sql, $params, 'main'); foreach ($c_topic_comment_list as $c_topic_comment) { //削除 db_commu_delete_c_commu_topic_comment($c_topic_comment['c_commu_topic_comment_id']); } ///日記関連 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); // コメントが無ければ履歴削除 $sql = 'DELETE FROM c_diary_comment_log' . ' WHERE c_member_id = ?'; db_query($sql, $params); // アルバム db_album_delete4c_member_id($c_member_id); //送信メッセージ関連 $sql = 'SELECT * FROM c_message WHERE c_member_id_from = ?'; $c_message_list = db_get_all($sql, $params, 'main'); foreach ($c_message_list as $c_message) { db_image_data_delete($c_message['image_filename_1']); db_image_data_delete($c_message['image_filename_2']); db_image_data_delete($c_message['image_filename_3']); } $sql = 'DELETE FROM c_message WHERE c_member_id_from = ?'; db_query($sql, $params); }