function execute($requests) { $tail = $GLOBALS['KTAI_URL_TAIL']; $u = $GLOBALS['KTAI_C_MEMBER_ID']; // --- リクエスト変数 $target_c_diary_comment_id = $requests['target_c_diary_comment_id']; // ---------- $c_diary_comment = _do_c_diary_comment4c_diary_comment_id($target_c_diary_comment_id); $target_c_member_id = $c_diary_comment['c_member_id']; //--- 権限チェック //日記作成者 or コメント作成者 $c_diary = db_diary_get_c_diary4id($c_diary_comment['c_diary_id']); if ($c_diary['c_member_id'] != $u && $c_diary_comment['c_member_id'] != $u) { handle_kengen_error(); } //--- db_diary_delete_c_diary_comment($target_c_diary_comment_id, $u); //コメント記入履歴削除実行 db_diary_delete_c_diary_comment_log($target_c_member_id, $c_diary_comment['c_diary_id']); $p = array('target_c_diary_id' => $c_diary['c_diary_id']); openpne_redirect('ktai', 'page_fh_diary', $p); }
function execute($requests) { $u = $GLOBALS['AUTH']->uid(); $target_c_diary_comment_id = $_REQUEST['target_c_diary_comment_id']; foreach ($target_c_diary_comment_id as $val) { //--- 権限チェック //日記作成者 or コメント作成者 $target_c_diary_comment = _do_c_diary_comment4c_diary_comment_id($val); $target_c_diary_id = $target_c_diary_comment['c_diary_id']; $c_diary = db_diary_get_c_diary4id($target_c_diary_id); if ($c_diary['c_member_id'] != $u && $target_c_diary_comment['c_member_id'] != $u) { handle_kengen_error(); } //--- //コメント削除実行 db_diary_delete_c_diary_comment($val, $u); //コメント記入履歴削除実行 db_diary_delete_c_diary_comment_log($target_c_diary_comment['c_member_id'], $target_c_diary_id); } $p = array('target_c_diary_id' => $target_c_diary_id); openpne_redirect('pc', 'page_fh_diary', $p); }
/** * メンバーの日記とコメントを削除 * * @param int $c_member_id */ function db_diary_delete4c_member_id($c_member_id) { $sql = 'SELECT * FROM c_diary WHERE c_member_id = ?'; $single = array(intval($c_member_id)); $c_diary_list = db_get_all($sql, $single, 'main'); foreach ($c_diary_list as $c_diary) { db_image_data_delete($c_diary['image_filename_1']); db_image_data_delete($c_diary['image_filename_2']); db_image_data_delete($c_diary['image_filename_3']); // c_diary_comment $sql = 'SELECT * FROM c_diary_comment WHERE c_diary_id = ?'; $params = array(intval($c_diary['c_diary_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_diary_id = ?'; db_query($sql, $params); db_diary_delete_c_diary_comment_log($c_member_id, $c_diary['c_diary_id']); } $sql = 'DELETE FROM c_diary WHERE c_member_id = ?'; db_query($sql, $single); }