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);
}
