function execute($requests) { if (!OPENPNE_USE_POINT_RANK) { admin_client_redirect('top', '指定されたページにはアクセスできません'); } $c_rank_id = $requests['c_rank_id']; $c_rank = db_admin_get_c_rank_one($c_rank_id); $image_filename = $c_rank['image_filename']; if (db_point_is_rank4point($requests['point']) && $c_rank['point'] != $requests['point']) { $tail = 'c_rank_id=' . $c_rank_id; admin_client_redirect('update_c_rank', '同一の到達ポイントのランクが既に存在します', $tail); } $upfile_obj = $_FILES['image_upfile']; if (!empty($upfile_obj) && $upfile_obj['error'] !== UPLOAD_ERR_NO_FILE) { if (!($image = t_check_image($upfile_obj))) { $tail = 'c_rank_id=' . $c_rank_id; admin_client_redirect('update_c_rank', '画像は' . IMAGE_MAX_FILESIZE . 'KB以内のGIF・JPEG・PNGにしてください', $tail); } //以前のイメージを削除 db_image_data_delete($image_filename); //新しいイメージを作成 $ext = t_check_image_format($_FILES['image_upfile']); $image_filename = "r_{$c_rank_id}_" . time() . ".{$ext}"; admin_insert_c_image($_FILES['image_upfile'], $image_filename); } db_admin_update_c_rank($c_rank_id, $requests['name'], $image_filename, $requests['point']); admin_client_redirect('list_c_rank', 'ランクを編集しました'); }
function execute($requests) { $u = $GLOBALS['AUTH']->uid(); // --- リクエスト変数 $c_commu_topic_id = $requests['target_c_commu_topic_id']; $pic_delete = $requests['pic_delete']; // ---------- $c_topic = db_commu_c_topic4c_commu_topic_id_2($c_commu_topic_id); //--- 権限チェック //イベントの管理者 or コミュニティ管理者 if (!db_commu_is_c_event_admin($c_commu_topic_id, $u) && !db_commu_is_c_commu_admin($c_topic['c_commu_id'], $u)) { handle_kengen_error(); } $c_commu = db_commu_c_commu4c_commu_id2($c_topic['c_commu_id']); if ($c_commu['is_topic'] == 'admin_only' && !db_commu_is_c_commu_admin($c_topic['c_commu_id'], $u)) { handle_kengen_error(); } if ($c_commu['is_topic'] == 'member' && !db_commu_is_c_commu_member($c_topic['c_commu_id'], $u)) { handle_kengen_error(); } //--- db_image_data_delete($c_topic['image_filename' . $pic_delete], $u); db_commu_delete_c_commu_topic_comment_image($c_commu_topic_id, $pic_delete); $p = array('target_c_commu_topic_id' => $c_commu_topic_id); openpne_redirect('pc', 'page_c_event_edit', $p); }
function execute($requests) { if (strpos($requests['filename'], 'skin_') === 0 || strpos($requests['filename'], 'no_') === 0) { admin_client_redirect('edit_c_image', 'この画像は削除できません'); } db_image_data_delete($requests['filename']); db_admin_delete_c_image_link4image_filename($requests['filename']); admin_client_redirect('edit_c_image', '画像を削除しました'); }
function execute($requests) { if (!OPENPNE_USE_POINT_RANK) { admin_client_redirect('top', '指定されたページにはアクセスできません'); } //以前のイメージを削除 $c_rank = db_admin_get_c_rank_one($requests['c_rank_id']); db_image_data_delete($c_rank['image_filename']); db_admin_delete_c_rank($requests['c_rank_id']); admin_client_redirect('list_c_rank', 'ランクを削除しました'); }
function execute($requests) { $filename = $requests['filename']; $target_area = $requests['target_area']; $tail = '&target_area=' . urlencode($target_area); if (!db_portal_imaage4filename($filename)) { portal_client_redirect('edit_portal_image', '画像を削除できませんでした', $tail); } db_image_data_delete($filename); db_portal_delete_portal_image($filename); portal_client_redirect('edit_portal_image', '画像を削除しました', $tail); }
function execute($requests) { $file = $_FILES['upfile']; if (empty($file) || $file['error'] === UPLOAD_ERR_NO_FILE) { admin_client_redirect('edit_c_image', '画像ファイルを指定してください'); } if (!t_check_image($file)) { admin_client_redirect('edit_c_image', '画像は' . IMAGE_MAX_FILESIZE . 'KB以内のGIF・JPEG・PNGにしてください'); } db_image_data_delete($requests['filename']); if (!admin_insert_c_image($_FILES['upfile'], $requests['filename'])) { admin_client_redirect('edit_c_image', '画像が登録できませんでした'); } admin_client_redirect('edit_c_image', '画像を登録しました', 'filename=' . $requests['filename']); }
function execute($requests) { $u = $GLOBALS['AUTH']->uid(); // --- リクエスト変数 $img_num = $requests['img_num']; // ---------- //--- 権限チェック //必要なし //--- $c_member = db_member_c_member4c_member_id($u); db_image_data_delete($c_member['image_filename_' . $img_num], $u); db_member_delete_c_member_image_new($u, $img_num); if ($c_member['image_filename'] == $c_member['image_filename_' . $img_num]) { db_member_change_c_member_main_image($u, 1); } openpne_redirect('pc', 'page_h_config_image'); }
function execute($requests) { $u = $GLOBALS['AUTH']->uid(); // --- リクエスト変数 $target_c_commu_id = $requests['target_c_commu_id']; // ---------- //--- 権限チェック //コミュニティ管理者 $status = db_common_commu_status($u, $target_c_commu_id); if (!$status['is_commu_admin']) { handle_kengen_error(); } //--- $c_commu = db_commu_c_commu4c_commu_id($target_c_commu_id); db_image_data_delete($c_commu['image_filename'], $u); db_commu_delete_c_commu_image_filename($target_c_commu_id); $p = array('target_c_commu_id' => $target_c_commu_id); openpne_redirect('pc', 'page_c_edit', $p); }
function execute($requests) { $u = $GLOBALS['AUTH']->uid(); // --- リクエスト変数 $c_diary_id = $requests['target_c_diary_id']; $del_img = $requests['del_img']; // ---------- //--- 権限チェック //日記作成者 $c_diary = db_diary_get_c_diary4id($c_diary_id); //日記を書いた人でないと消せない if ($c_diary['c_member_id'] != $u) { openpne_redirect('pc', 'page_h_home'); } //--- db_image_data_delete($c_diary['image_filename_' . $del_img], $u); db_diary_delete_c_diary_image($c_diary_id, $del_img); $p = array('target_c_diary_id' => $c_diary_id); openpne_redirect('pc', 'page_h_diary_edit', $p); }
function execute($requests) { $file = $_FILES['upfile']; $target_area = $requests['target_area']; $tail = 'target_area=' . $target_area; if (empty($file) || $file['error'] === UPLOAD_ERR_NO_FILE) { portal_client_redirect('edit_portal_image', '画像ファイルを指定してください', $tail); } $file_info = t_check_image($file); if (!$file_info) { portal_client_redirect('edit_portal_image', '画像は' . IMAGE_MAX_FILESIZE . 'KB以内のGIF・JPEG・PNGにしてください', $tail); } $filename = sprintf('module_portal_%d.%s', time(), $file_info['format']); db_image_data_delete($filename); db_portal_delete_portal_image($filename); if (!admin_insert_c_image($_FILES['upfile'], $filename)) { portal_client_redirect('edit_portal_image', '画像が登録できませんでした', $tail); } db_portal_insert_portal_image($filename); portal_client_redirect('edit_portal_image', '画像を登録しました', $tail); }
function execute($requests) { $u = $GLOBALS['KTAI_C_MEMBER_ID']; // --- リクエスト変数 $target_c_commu_id = $requests['target_c_commu_id']; // ---------- $c_commu = db_commu_c_commu4c_commu_id($target_c_commu_id); //--- 権限チェック $status = db_common_commu_status($u, $target_c_commu_id); if (!$status['is_commu_admin'] && !$status['is_commu_sub_admin']) { handle_kengen_error(); } //--- if (empty($c_commu['image_filename'])) { handle_kengen_error(); } db_image_data_delete($c_commu['image_filename'], $u); db_commu_delete_c_commu_image_filename($target_c_commu_id); $p = array('target_c_commu_id' => $target_c_commu_id); openpne_redirect('ktai', 'page_c_edit_image', $p); }
function execute($requests) { $tail = $GLOBALS['KTAI_URL_TAIL']; $u = $GLOBALS['KTAI_C_MEMBER_ID']; $img_num = $requests['img_num']; $c_member = db_member_c_member4c_member_id($u); if (!$img_num) { if ($c_member['image_filename'] == $c_member['image_filename_1']) { $img_num = 1; } elseif ($c_member['image_filename'] == $c_member['image_filename_2']) { $img_num = 2; } elseif ($c_member['image_filename'] == $c_member['image_filename_3']) { $img_num = 3; } } db_image_data_delete($c_member['image_filename_' . $img_num], $u); db_member_delete_c_member_image_new($u, $img_num); if ($c_member['image_filename'] == $c_member['image_filename_' . $img_num]) { db_member_change_c_member_main_image($u, 1); } openpne_redirect('ktai', 'page_h_config_image'); }
function execute($requests) { $u = $GLOBALS['KTAI_C_MEMBER_ID']; $tail = $GLOBALS['KTAI_URL_TAIL']; // --- リクエスト変数 $c_commu_topic_id = $requests['target_c_commu_topic_id']; $img_num = $requests['img_num']; // ---------- $c_topic = db_commu_c_topic4c_commu_topic_id($c_commu_topic_id); $c_commu_id = $c_topic['c_commu_id']; //--- 権限チェック if (!db_commu_is_c_commu_view4c_commu_idAc_member_id($c_commu_id, $u)) { handle_kengen_error(); } if (!db_commu_is_c_topic_admin($c_commu_topic_id, $u) && !db_commu_is_c_commu_admin($c_commu_id, $u)) { handle_kengen_error(); } //--- $target_image_filename = ''; switch ($img_num) { case '1': $target_image_filename = $c_topic['image_filename1']; break; case '2': $target_image_filename = $c_topic['image_filename2']; break; case '3': $target_image_filename = $c_topic['image_filename3']; break; } if (empty($target_image_filename)) { handle_kengen_error(); } db_image_data_delete($target_image_filename, $u); db_commu_delete_c_commu_topic_comment_image($c_commu_topic_id, $img_num); $p = array('target_c_commu_topic_id' => $c_commu_topic_id); openpne_redirect('ktai', 'page_c_topic_edit_image', $p); }
function execute($requests) { $u = $GLOBALS['KTAI_C_MEMBER_ID']; // --- リクエスト変数 $target_c_diary_id = $requests['target_c_diary_id']; $img_num = $requests['img_num']; // ---------- $c_member = db_member_c_member4c_member_id($u); if ($target_c_diary_id) { $c_diary = db_diary_get_c_diary4id($target_c_diary_id); if ($c_diary['c_member_id'] != $u) { handle_kengen_error(); } } else { handle_kengen_error(); } $target_image_filename = ''; switch ($img_num) { case '1': $target_image_filename = $c_diary['image_filename_1']; break; case '2': $target_image_filename = $c_diary['image_filename_2']; break; case '3': $target_image_filename = $c_diary['image_filename_3']; break; } if (empty($target_image_filename)) { handle_kengen_error(); } db_image_data_delete($target_image_filename, $u); db_diary_delete_c_diary_image($target_c_diary_id, $img_num); $p = array('target_c_diary_id' => $target_c_diary_id); openpne_redirect('ktai', 'page_h_diary_edit_image', $p); }
function execute($requests) { if (!$_FILES['upfile']['size']) { admin_client_redirect('edit_skin_image', 'ファイルが指定されていません'); } $prefix = sprintf('skin_%s', $requests['skinname']); if ($fn = image_insert_c_image($_FILES['upfile'], $prefix)) { if ($old_fn = db_get_c_skin_filename4skinname($requests['skinname'])) { db_image_data_delete($old_fn); } // 携帯版ロゴ画像がアップロードされた場合は、ロゴの非表示設定を解除する if ($requests['skinname'] == 'skin_ktai_header') { if (is_null(db_admin_c_admin_config4name('OPENPNE_USE_KTAI_LOGO'))) { db_admin_insert_c_admin_config('OPENPNE_USE_KTAI_LOGO', true); } else { db_admin_update_c_admin_config('OPENPNE_USE_KTAI_LOGO', true); } } db_replace_c_skin_filename($requests['skinname'], $fn); pne_cache_drop('fetch_inc_navi', 'h'); admin_client_redirect('edit_skin_image', 'スキン画像を変更しました'); } admin_client_redirect('edit_skin_image', 'スキン画像を変更できませんでした'); }
function execute($requests) { $u = $GLOBALS['AUTH']->uid(); // --- リクエスト変数 $c_commu_topic_id = $requests['target_c_commu_topic_id']; $body = $requests['body']; $title = $requests['title']; // ---------- $upfile_obj1 = $_FILES['image_filename1']; $upfile_obj2 = $_FILES['image_filename2']; $upfile_obj3 = $_FILES['image_filename3']; $upfile_obj4 = $_FILES['filename4']; //--- 権限チェック //トピック作成者 or コミュニティ管理者 $c_topic = db_commu_c_topic4c_commu_topic_id($c_commu_topic_id); $c_commu_id = $c_topic['c_commu_id']; if (!db_commu_is_c_topic_admin($c_commu_topic_id, $u) && !db_commu_is_c_commu_admin($c_commu_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(); } //--- //エラーチェック $err_msg = array(); $filesize = 0; $del_file = array(); if (is_null($title) || $title === '') { $err_msg[] = "タイトルを入力してください"; } if (is_null($body) || $body === '') { $err_msg[] = "本文を入力してください"; } if (!empty($upfile_obj1) && $upfile_obj1['error'] !== UPLOAD_ERR_NO_FILE) { if (!($image = t_check_image($upfile_obj1))) { $err_msg[] = '画像1は' . IMAGE_MAX_FILESIZE . 'KB以内のGIF・JPEG・PNGにしてください'; } $filesize += $image['size']; if ($c_topic['image_filename1']) { $del_file[] = $c_topic['image_filename1']; } } if (!empty($upfile_obj2) && $upfile_obj2['error'] !== UPLOAD_ERR_NO_FILE) { if (!($image = t_check_image($upfile_obj2))) { $err_msg[] = '画像2は' . IMAGE_MAX_FILESIZE . 'KB以内のGIF・JPEG・PNGにしてください'; } $filesize += $image['size']; if ($c_topic['image_filename2']) { $del_file[] = $c_topic['image_filename2']; } } if (!empty($upfile_obj3) && $upfile_obj3['error'] !== UPLOAD_ERR_NO_FILE) { if (!($image = t_check_image($upfile_obj3))) { $err_msg[] = '画像3は' . IMAGE_MAX_FILESIZE . 'KB以内のGIF・JPEG・PNGにしてください'; } $filesize += $image['size']; if ($c_topic['image_filename3']) { $del_file[] = $c_topic['image_filename3']; } } // 画像アップロード可能サイズチェック if (!$err_msg && $filesize) { $result = util_image_check_change_image_upload($filesize, $del_file, $u, 'commu'); if ($result) { if ($result == 2) { $result = 3; } $err_msg[] = util_image_get_upload_err_msg($result); } } if (OPENPNE_USE_FILEUPLOAD) { if (!empty($upfile_obj4) && $upfile_obj4['error'] !== UPLOAD_ERR_NO_FILE) { // ファイルサイズ制限 if ($upfile_obj4['size'] === 0 || $upfile_obj4['size'] > FILE_MAX_FILESIZE * 1024) { $err_msg[] = 'ファイルは' . FILE_MAX_FILESIZE . 'KB以内のファイルにしてください(ただし空のファイルはアップロードできません)'; } // 拡張子制限 if (!util_check_file_extention($upfile_obj4['name'])) { $err_msg[] = sprintf('アップロードできるファイルの種類は(%s)です', util_get_file_allowed_extensions('string')); } } } if ($err_msg) { $_REQUEST['err_msg'] = $err_msg; $_REQUEST['target_c_commu_topic_id'] = $c_commu_topic_id; $_REQUEST['title'] = $title; $_REQUEST['body'] = $body; openpne_forward('pc', 'page', "c_topic_edit"); exit; } // 画像アップデート $filename1 = image_insert_c_image_direct($upfile_obj1, "t_{$c_commu_topic_id}_1", $u); $filename2 = image_insert_c_image_direct($upfile_obj2, "t_{$c_commu_topic_id}_2", $u); $filename3 = image_insert_c_image_direct($upfile_obj3, "t_{$c_commu_topic_id}_3", $u); //ファイルアップロード $sessid = session_id(); t_image_clear_tmp($sessid); if (OPENPNE_USE_FILEUPLOAD) { $tmpfile4 = t_file_save2tmp($upfile_obj4, $sessid, "t_4"); } if ($tmpfile4) { $filename4 = file_insert_c_file4tmp("t_{$c_commu_topic_id}_4", $tmpfile4, $upfile_obj4['name']); } t_file_clear_tmp(session_id()); $update_c_commu_topic = array('name' => $title, 'event_flag' => 0); db_commu_update_c_commu_topic($c_commu_topic_id, $update_c_commu_topic); $update_c_commu_topic_comment = array('body' => $body); $c_topic = db_commu_c_topic4c_commu_topic_id($c_commu_topic_id); if ($filename1) { $update_c_commu_topic_comment["image_filename1"] = $filename1; db_image_data_delete($c_topic['image_filename1'], $u); } if ($filename2) { $update_c_commu_topic_comment["image_filename2"] = $filename2; db_image_data_delete($c_topic['image_filename2'], $u); } if ($filename3) { $update_c_commu_topic_comment["image_filename3"] = $filename3; db_image_data_delete($c_topic['image_filename3'], $u); } if ($filename4) { $update_c_commu_topic_comment['filename4'] = $filename4; db_file_delete_c_file($c_topic['filename']); } db_commu_update_c_commu_topic_comment($c_commu_topic_id, $update_c_commu_topic_comment); $p = array('target_c_commu_topic_id' => $c_commu_topic_id); openpne_redirect('pc', 'page_c_topic_detail', $p); }
function execute($requests) { $u = $GLOBALS['AUTH']->uid(); // --- リクエスト変数 $target_c_diary_id = $requests['target_c_diary_id']; $subject = $requests['subject']; $body = $requests['body']; $public_flag = util_cast_public_flag_diary($requests['public_flag']); $tmpfile_1 = $requests['tmpfile_1']; $tmpfile_2 = $requests['tmpfile_2']; $tmpfile_3 = $requests['tmpfile_3']; $category = array_unique(preg_split('/\\s+/', $requests['category'])); $is_comment_input = $requests['is_comment_input']; // ---------- //--- 権限チェック //日記作成者 $c_diary = db_diary_get_c_diary4id($target_c_diary_id); if ($c_diary['c_member_id'] != $u) { handle_kengen_error(); } //--- $sessid = session_id(); if (count($category) > 5) { $_REQUEST['msg'] = 'カテゴリは5つまでしか指定できません'; openpne_forward('pc', 'page', 'h_diary_edit'); exit; } foreach ($category as $value) { if (mb_strwidth($value) > 20) { $_REQUEST['msg'] = 'カテゴリはひとつにつき全角10文字(半角20文字)以内で入力してください'; openpne_forward('pc', 'page', 'h_diary_edit'); exit; } } // 画像アップロード可能サイズチェック $filesize = 0; $del_file = array(); if ($tmpfile_1) { $filesize += util_image_get_c_tmp_filesize4filename("d_{$target_c_diary_id}_1", $tmpfile_1); if ($c_diary['image_filename_1']) { $del_file[] = $c_diary['image_filename_1']; } } if ($tmpfile_2) { $filesize += util_image_get_c_tmp_filesize4filename("d_{$target_c_diary_id}_2", $tmpfile_2); if ($c_diary['image_filename_2']) { $del_file[] = $c_diary['image_filename_2']; } } if ($tmpfile_3) { $filesize += util_image_get_c_tmp_filesize4filename("d_{$target_c_diary_id}_3", $tmpfile_3); if ($c_diary['image_filename_3']) { $del_file[] = $c_diary['image_filename_3']; } } if ($filesize) { $result = util_image_check_change_image_upload($filesize, $del_file, $u, 'diary'); if ($result) { if ($result == 2) { $result = 3; } $_REQUEST['msg'] = util_image_get_upload_err_msg($result); openpne_forward('pc', 'page', 'h_diary_edit'); exit; } } //カテゴリ登録しなおし db_diary_category_delete_c_diary_category_diary($target_c_diary_id); $c_diary_category_list = db_diary_category_list4c_member_id($c_diary['c_member_id']); foreach ($category as $value) { if (empty($value)) { break; } // 同一のカテゴリ名が登録済みかどうかを確認 $c_category_id = 0; foreach ($c_diary_category_list as $c_diary_category) { if ($c_diary_category['category_name'] == $value) { $c_category_id = $c_diary_category['c_diary_category_id']; break; } } // 未登録の場合は新規に登録する if (!$c_category_id) { $c_category_id = db_diary_category_insert_category($c_diary['c_member_id'], $value); } db_diary_category_insert_c_diary_category_diary($target_c_diary_id, $c_category_id); } $filename_1 = $filename_2 = $filename_3 = ''; if ($tmpfile_1) { db_image_data_delete($c_diary['image_filename_1'], $u); $filename_1 = image_insert_c_image4tmp("d_{$target_c_diary_id}_1", $tmpfile_1, $u); } if ($tmpfile_2) { db_image_data_delete($c_diary['image_filename_2'], $u); $filename_2 = image_insert_c_image4tmp("d_{$target_c_diary_id}_2", $tmpfile_2, $u); } if ($tmpfile_3) { db_image_data_delete($c_diary['image_filename_3'], $u); $filename_3 = image_insert_c_image4tmp("d_{$target_c_diary_id}_3", $tmpfile_3, $u); } if (!OPENPNE_USE_DIARY_COMMENT) { $is_comment_input = $c_diary['is_comment_input']; } t_image_clear_tmp($sessid); db_diary_update_c_diary($target_c_diary_id, $subject, $body, $public_flag, $is_comment_input, $filename_1, $filename_2, $filename_3); $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); }
function biz_deleteGroup($group_id, $c_member_id) { // 画像削除 $sql = 'SELECT image_filename FROM biz_group ' . 'WHERE biz_group_id = ? '; $params = array(intval($group_id)); $image_filename = db_get_one($sql, $params, 'main'); db_image_data_delete($image_filename, $c_member_id); $sql = 'DELETE FROM biz_group_member WHERE biz_group_id = ?'; $params = array(intval($group_id)); $result = db_query($sql, $params); $sql = 'DELETE FROM biz_group WHERE biz_group_id = ?'; $params = array(intval($group_id)); $result = db_query($sql, $params); $sql = 'UPDATE biz_schedule SET public_flag = "private", biz_group_id = NULL WHERE biz_group_id = ?'; db_query($sql, array(intval($group_id))); $sql = 'DELETE FROM biz_todo WHERE biz_group_id = ?'; db_query($sql, array(intval($group_id))); }
/** * 指定メンバーの書き込み一括削除 * 以下の書き込みが削除対象 * ・日記、日記コメント * ・トピック・イベント、トピック・イベントのコメント * ・送信メッセージ * ・アルバム * * @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); }
function execute($requests) { $u = $GLOBALS['AUTH']->uid(); // --- リクエスト変数 $target_c_commu_id = $requests['target_c_commu_id']; $name = $requests['name']; $c_commu_category_id = $requests['c_commu_category_id']; $info = $requests['info']; $is_admit = $requests['is_admit']; $is_open = $requests['is_open']; $is_topic = $requests['is_topic']; $is_comment = $requests['is_comment']; $is_send_join_mail = $requests['is_send_join_mail']; // ---------- $upfile_obj = $_FILES['image_filename']; //--- 権限チェック //コミュニティ管理者 $status = db_common_commu_status($u, $target_c_commu_id); if (!$status['is_commu_admin']) { handle_kengen_error(); } //--- $err_msg = array(); $filesize = 0; $del_file = array(); if (!$name) { $err_msg[] = WORD_COMMUNITY . "名を入力してください"; } if (!$info) { $err_msg[] = WORD_COMMUNITY . "の説明を入力してください"; } if (db_commu_is_changed_c_commu_name($target_c_commu_id, $name) && db_commu_is_commu4c_commu_name($name)) { $err_msg[] = 'その' . WORD_COMMUNITY . 'はすでに存在します'; } $c_commu = db_commu_c_commu4c_commu_id($target_c_commu_id); if ($c_commu_category_id != $c_commu['c_commu_category_id'] && !db_commu_c_commu_category_is_create_commu($c_commu_category_id)) { $_REQUEST['c_commu_category_id'] = $c_commu['c_commu_category_id']; $err_msg[] = '指定されたカテゴリは選択できません'; } if ($is_open == 'member') { if ($is_topic == 'public') { $err_msg[] = '公開範囲とトピック作成権限が指定できない組み合わせです'; } if ($is_comment == 'public') { $err_msg[] = '公開範囲とコメント作成権限が指定できない組み合わせです'; } } if (!empty($upfile_obj) && $upfile_obj['error'] !== UPLOAD_ERR_NO_FILE) { if (!($image = t_check_image($upfile_obj))) { $err_msg[] = '画像は' . IMAGE_MAX_FILESIZE . 'KB以内のGIF・JPEG・PNGにしてください'; } $filesize = $image['size']; if ($c_commu['image_filename']) { $del_file[] = $c_commu['image_filename']; } } //---画像アップロードサイズチェック if (!$err_msg && $filesize) { $result = util_image_check_change_image_upload($filesize, $del_file, $u, 'other'); if ($result) { $err_msg[] = util_image_get_upload_err_msg($result); } } if ($err_msg) { $_REQUEST['err_msg'] = $err_msg; $_REQUEST['target_c_commu_id'] = $target_c_commu_id; $_REQUEST['name'] = $name; $_REQUEST['info'] = $info; openpne_forward('pc', 'page', "c_edit"); exit; } $c_commu = db_commu_c_commu4c_commu_id($target_c_commu_id); //画像アップデート $image_filename = image_insert_c_image_direct($upfile_obj, 'c_' . $target_c_commu_id, $u); if ($image_filename) { //画像削除 db_image_data_delete($c_commu['image_filename'], $u); } // 承認待ちメンバー登録処理 if ($is_admit == 'public' && $is_admit != $c_commu['is_admit']) { $member_confirm_list = db_commu_c_commu_member_confirm4c_commu_id($target_c_commu_id); foreach ($member_confirm_list as $confirm_id => $c_member_id) { db_commu_join_c_commu($target_c_commu_id, $c_member_id); do_inc_join_c_commu_send_mail($target_c_commu_id, $c_member_id); db_commu_delete_c_commu_member_confirm($confirm_id); } } db_commu_update_c_commu($target_c_commu_id, $name, $is_topic, $is_comment, $c_commu_category_id, $info, $is_admit, $is_open, $image_filename, $is_send_join_mail); $p = array('target_c_commu_id' => $target_c_commu_id); openpne_redirect('pc', 'page_c_home', $p); }
/** * トピックコメント削除 */ function db_commu_delete_c_commu_topic_comment($c_commu_topic_comment_id) { $sql = 'SELECT image_filename1, image_filename2, image_filename3, filename, c_member_id' . ' FROM c_commu_topic_comment' . ' WHERE c_commu_topic_comment_id = ?'; $params = array(intval($c_commu_topic_comment_id)); $topic_comment = db_get_row($sql, $params); db_image_data_delete($topic_comment['image_filename1'], $topic_comment['c_member_id']); db_image_data_delete($topic_comment['image_filename2'], $topic_comment['c_member_id']); db_image_data_delete($topic_comment['image_filename3'], $topic_comment['c_member_id']); db_file_delete_c_file($topic_comment['filename']); $sql = 'DELETE FROM c_commu_topic_comment WHERE c_commu_topic_comment_id = ?'; return db_query($sql, $params); }
function db_admin_delete_c_image4c_banner_id($c_banner_id) { $sql = 'SELECT image_filename FROM c_banner WHERE c_banner_id = ?'; $params = array(intval($c_banner_id)); $image_filename = db_get_one($sql, $params); db_image_data_delete($image_filename); }
function image_data_delete($image_filename) { return db_image_data_delete($image_filename); }
function execute($requests) { $u = $GLOBALS['AUTH']->uid(); // --- リクエスト変数 $c_commu_topic_id = $requests['target_c_commu_topic_id']; // ---------- $upfile_obj1 = $_FILES['image_filename1']; $upfile_obj2 = $_FILES['image_filename2']; $upfile_obj3 = $_FILES['image_filename3']; $upfile_obj4 = $_FILES['filename4']; list($event, $errors) = p_c_event_add_confirm_event4request(true); if ($event['invite_period_year'] . $event['invite_period_month'] . $event['invite_period_day'] != '') { $invite_period = $event['invite_period_year'] . "-" . $event['invite_period_month'] . "-" . $event['invite_period_day']; } else { $invite_period = ""; } $c_commu_id = $event['c_commu_id']; //--- 権限チェック //イベント管理者 or コミュニティ管理者 if (!db_commu_is_c_event_admin($c_commu_topic_id, $u) && !db_commu_is_c_commu_admin($c_commu_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(); } //--- //エラーチェック $err_msg = $errors; $filesize = 0; $del_file = array(); if (!$event['open_date_month'] || !$event['open_date_day'] || !$event['open_date_year']) { $err_msg[] = "開催日時を入力してください"; } elseif (!t_checkdate($event['open_date_month'], $event['open_date_day'], $event['open_date_year'])) { $err_msg[] = "開催日時は存在しません"; } elseif (mktime(0, 0, 0, $event['open_date_month'], $event['open_date_day'], $event['open_date_year']) < mktime(0, 0, 0)) { $err_msg[] = "開催日時は過去に指定できません"; } if ($event['invite_period_month'] . $event['invite_period_day'] . $event['invite_period_year'] != "") { if (!$event['invite_period_month'] || !$event['invite_period_day'] || !$event['invite_period_year']) { $err_msg[] = "募集期限は存在しません"; } elseif (!t_checkdate($event['invite_period_month'], $event['invite_period_day'], $event['invite_period_year'])) { $err_msg[] = "募集期限は存在しません"; } elseif (mktime(0, 0, 0, $event['invite_period_month'], $event['invite_period_day'], $event['invite_period_year']) < mktime(0, 0, 0)) { $err_msg[] = "募集期限は過去に指定できません"; } elseif (mktime(0, 0, 0, $event['open_date_month'], $event['open_date_day'], $event['open_date_year']) < mktime(0, 0, 0, $event['invite_period_month'], $event['invite_period_day'], $event['invite_period_year'])) { $err_msg[] = "募集期限は開催日時より未来に指定できません"; } } $c_topic = db_commu_c_topic4c_commu_topic_id_2($c_commu_topic_id); if (!empty($upfile_obj1) && $upfile_obj1['error'] !== UPLOAD_ERR_NO_FILE) { if (!($image = t_check_image($upfile_obj1))) { $err_msg[] = '画像1は' . IMAGE_MAX_FILESIZE . 'KB以内のGIF・JPEG・PNGにしてください'; } $filesize += $image['size']; if ($c_topic['image_filename1']) { $del_file[] = $c_topic['image_filename1']; } } if (!empty($upfile_obj2) && $upfile_obj2['error'] !== UPLOAD_ERR_NO_FILE) { if (!($image = t_check_image($upfile_obj2))) { $err_msg[] = '画像2は' . IMAGE_MAX_FILESIZE . 'KB以内のGIF・JPEG・PNGにしてください'; } $filesize += $image['size']; if ($c_topic['image_filename2']) { $del_file[] = $c_topic['image_filename2']; } } if (!empty($upfile_obj3) && $upfile_obj3['error'] !== UPLOAD_ERR_NO_FILE) { if (!($image = t_check_image($upfile_obj3))) { $err_msg[] = '画像3は' . IMAGE_MAX_FILESIZE . 'KB以内のGIF・JPEG・PNGにしてください'; } $filesize += $image['size']; if ($c_topic['image_filename3']) { $del_file[] = $c_topic['image_filename3']; } } // 画像アップロード可能サイズチェック if (!$err_msg && $filesize) { $result = util_image_check_change_image_upload($filesize, $del_file, $u, 'commu'); if ($result) { if ($result == 2) { $result = 3; } $err_msg[] = util_image_get_upload_err_msg($result); } } if (OPENPNE_USE_FILEUPLOAD) { if (!empty($upfile_obj4) && $upfile_obj4['error'] !== UPLOAD_ERR_NO_FILE) { // ファイルサイズ制限 if ($upfile_obj4['size'] === 0 || $upfile_obj4['size'] > FILE_MAX_FILESIZE * 1024) { $err_msg[] = 'ファイルは' . FILE_MAX_FILESIZE . 'KB以内のファイルにしてください(ただし空のファイルはアップロードできません)'; } // 拡張子制限 if (!util_check_file_extention($upfile_obj4['name'])) { $err_msg[] = sprintf('アップロードできるファイルの種類は(%s)です', util_get_file_allowed_extensions('string')); } } } if ($err_msg) { $_REQUEST = $event; $_REQUEST['err_msg'] = $err_msg; $_REQUEST['target_c_commu_topic_id'] = $c_commu_topic_id; openpne_forward('pc', 'page', "c_event_edit"); exit; } // 画像アップデート $filename1 = image_insert_c_image_direct($upfile_obj1, "t_{$c_commu_topic_id}_1", $u); $filename2 = image_insert_c_image_direct($upfile_obj2, "t_{$c_commu_topic_id}_2", $u); $filename3 = image_insert_c_image_direct($upfile_obj3, "t_{$c_commu_topic_id}_3", $u); //ファイルアップロード $sessid = session_id(); t_image_clear_tmp($sessid); if (OPENPNE_USE_FILEUPLOAD) { $tmpfile4 = t_file_save2tmp($upfile_obj4, $sessid, "t_4"); } if ($tmpfile4) { $filename4 = file_insert_c_file4tmp("t_{$c_commu_topic_id}_4", $tmpfile4, $upfile_obj4['name']); } t_file_clear_tmp(session_id()); $update_c_commu_topic = array('name' => $event['title'], 'open_date' => $event['open_date_year'] . "-" . $event['open_date_month'] . "-" . $event['open_date_day'], 'open_date_comment' => $event['open_date_comment'], 'open_pref_id' => $event['open_pref_id'], 'open_pref_comment' => $event['open_pref_comment'], 'invite_period' => $invite_period, 'event_flag' => 1, 'capacity' => $event['capacity']); db_commu_update_c_commu_topic($c_commu_topic_id, $update_c_commu_topic); $update_c_commu_topic_comment = array('body' => $event['detail']); // 画像アップロード可能サイズチェックで使用するため移動 // $c_topic = db_commu_c_topic4c_commu_topic_id_2($c_commu_topic_id); if ($filename1) { $update_c_commu_topic_comment["image_filename1"] = $filename1; db_image_data_delete($c_topic['image_filename1'], $u); } if ($filename2) { $update_c_commu_topic_comment["image_filename2"] = $filename2; db_image_data_delete($c_topic['image_filename2'], $u); } if ($filename3) { $update_c_commu_topic_comment["image_filename3"] = $filename3; db_image_data_delete($c_topic['image_filename3'], $u); } if ($filename4) { $update_c_commu_topic_comment['filename4'] = $filename4; db_file_delete_c_file($c_topic['filename']); } db_commu_update_c_commu_topic_comment($c_commu_topic_id, $update_c_commu_topic_comment); $p = array('target_c_commu_topic_id' => $c_commu_topic_id); openpne_redirect('pc', 'page_c_event_detail', $p); }