function execute($requests) { if (!OPENPNE_USE_ALBUM) { handle_kengen_error(); } $u = $GLOBALS['AUTH']->uid(); // --- リクエスト変数 $target_c_album_id = $requests['target_c_album_id']; $subject = $requests['subject']; $description = $requests['description']; $public_flag = $requests['public_flag']; $tmpfile_1 = $requests['tmpfile_1']; // ---------- //--- 権限チェック $c_album = db_album_get_c_album4c_album_id($target_c_album_id); if ($c_album['c_member_id'] != $u) { handle_kengen_error(); } //--- //---画像アップロードサイズチェック if ($tmpfile_1) { $del_file = array(); $filesize = util_image_get_c_tmp_filesize4filename("a_{$target_c_album_id}_1", $tmpfile_1); if ($c_album['album_cover_image']) { $del_file[] = $c_album['album_cover_image']; } $result = util_image_check_change_image_upload($filesize, $del_file, $u, 'other'); if ($result) { $sessid = session_id(); t_image_clear_tmp($sessid); $_REQUEST['msg'] = util_image_get_upload_err_msg($result); openpne_forward('pc', 'page', 'h_album_cover_edit'); exit; } } $filename_1 = ''; $c_album_cover = $c_album['album_cover_image']; if ($tmpfile_1) { db_album_image_data_delete($c_album_cover, $u); $filename_1 = image_insert_c_image4tmp("a_{$target_c_album_id}_1", $tmpfile_1, $u, 'other'); } $sessid = session_id(); t_image_clear_tmp($sessid); //アルバムデータの変更 db_album_update_c_album_cover($target_c_album_id, $subject, $description, $filename_1, $public_flag); $p = array('target_c_album_id' => $target_c_album_id); openpne_redirect('pc', 'page_fh_album', $p); }
function execute($requests) { $tail = $GLOBALS['KTAI_URL_TAIL']; $u = $GLOBALS['KTAI_C_MEMBER_ID']; // --- リクエスト変数 $target_c_album_id = $requests['target_c_album_id']; // ---------- //--- 権限チェック $c_album = db_album_get_c_album4c_album_id($target_c_album_id); if ($c_album['c_member_id'] != $u) { handle_kengen_error(); } //--- $c_album_cover = $c_album['album_cover_image']; db_album_image_data_delete($c_album_cover, $u); db_album_update_c_album_album_cover_image($target_c_album_id, ''); $p = array('target_c_member_id' => $u, 'target_c_album_id' => $target_c_album_id); openpne_redirect('ktai', 'page_h_album_edit', $p); }
function execute($requests) { $tail = $GLOBALS['KTAI_URL_TAIL']; $u = $GLOBALS['KTAI_C_MEMBER_ID']; // --- リクエスト変数 $target_c_album_image_id = $requests['target_c_album_image_id']; // ---------- $target_c_album_image = db_album_image_get_c_album_image4id($target_c_album_image_id); //targetのアルバム写真が存在しない if (!$target_c_album_image) { openpne_redirect('ktai', 'page_h_err_fh_album'); } $target_c_album_id = $target_c_album_image['c_album_id']; $c_album = db_album_get_c_album4c_album_id($target_c_album_id); //targetのアルバムが存在しない if (!$c_album) { openpne_redirect('ktai', 'page_h_err_fh_album'); } if ($c_album['c_member_id'] != $u) { handle_kengen_error(); } //--- $image_filename = $target_c_album_image['image_filename']; $path_parts = pathinfo($image_filename); $ext = $path_parts['extension']; $new_filename = 'a_' . $target_c_album_id . '_1_' . time() . '.' . $ext; $c_image_id = db_image_data_copy($image_filename, $new_filename, $u, $target_c_album_image['filesize']); if (!$c_image_id) { openpne_redirect('ktai', 'page_h_err_fh_album'); } $c_album_cover = $c_album['album_cover_image']; db_album_image_data_delete($c_album_cover, $u); db_album_update_c_album_album_cover_image($target_c_album_id, $new_filename); $p = array('target_c_member_id' => $u, 'target_c_album_id' => $target_c_album_id); openpne_redirect('ktai', 'page_fh_album', $p); }
/** * アルバム表紙変更 */ function add_album_cover_image($c_album_id) { if (!($c_album = db_album_get_c_album4c_album_id($c_album_id))) { return false; } if ($c_album['c_member_id'] != $this->c_member_id) { return false; } // 写真登録 if ($images = $this->decoder->get_images()) { $image = $images[0]; $image_ext = $image['ext']; $image_data = $image['data']; $filename = 'a_' . $c_album_id . '_1_' . time() . '.' . $image_ext; // 画像アップロード可能サイズチェック $filesize = $image['filesize']; $result = util_image_check_add_image_upload($filesize, $this->c_member_id, 'other'); if ($result) { $msg = util_image_get_upload_err_msg($result); $this->error_mail($msg); m_debug_log('mail_sns::add_album_cover_image() size over'); return false; } db_image_insert_c_image($filename, $image_data, $filesize, $this->c_member_id); //アルバムデータの変更 $c_album_cover = $c_album['album_cover_image']; db_album_image_data_delete($c_album_cover, $c_album['c_member_id']); db_album_update_c_album_album_cover_image($c_album_id, $filename); } else { $this->error_mail('写真が添付されていないか、ファイルサイズが大きすぎるため、アルバム表紙を変更できませんでした。'); m_debug_log('mail_sns::add_album_cover_image() no images'); return false; } return true; }
function execute($requests) { if (!OPENPNE_USE_ALBUM) { handle_kengen_error(); } $u = $GLOBALS['AUTH']->uid(); // --- リクエスト変数 $target_c_album_image_id = $requests['target_c_album_image_id']; $image_description = $requests['image_description']; $tmpfile = $requests['tmpfile_1']; // ---------- $filename = ''; $filesize = 0; $c_album_image = db_album_image_get_c_album_image4id($target_c_album_image_id); $target_c_album_id = $c_album_image['c_album_id']; $img_tmp_dir_path = OPENPNE_VAR_DIR . '/tmp/'; $c_album = db_album_get_c_album4c_album_id($target_c_album_id); if ($c_album['c_member_id'] != $u) { handle_kengen_error(); } // 画像アップロード可能サイズチェック if ($tmpfile) { $del_file = array(); $filesize = util_image_get_c_tmp_filesize4filename("a_{$target_c_album_id}_1", $tmpfile); if ($c_album_image['image_filename']) { $del_file[] = $c_album_image['image_filename']; } $result = util_image_check_change_image_upload($filesize, $del_file, $u, 'album'); if ($result) { $sessid = session_id(); t_image_clear_tmp($sessid); $msg = util_image_get_upload_err_msg($result); $p = array('msg' => $msg, 'target_c_album_id' => $target_c_album_id, 'target_c_album_image_id' => $target_c_album_image_id); openpne_redirect('pc', 'page_h_album_image_edit', $p); } } // アルバム写真登録処理 if ($tmpfile) { if (!(list($filename, $filesize) = image_insert_c_image_album4tmp("a_{$target_c_album_id}_1", $tmpfile, $u))) { $this->handleError(array('写真が登録できませんでした')); } $sessid = session_id(); t_image_clear_tmp($sessid); if (!db_album_is_insertable4c_member_id($u, $filesize - $c_album_image['filesize'])) { db_album_image_data_delete($filename, $u); $msg = 'これ以上写真を投稿することができません。'; if (!db_album_is_insertable4c_member_id($u)) { $msg .= '登録済みの写真を削除してからやり直してください。'; } else { $msg .= 'ファイルサイズを変更してやり直してください。'; } $p = array('msg' => $msg, 'target_c_album_id' => $target_c_album_id, 'target_c_album_image_id' => $target_c_album_image_id); openpne_redirect('pc', 'page_h_album_image_edit', $p); } db_album_image_data_delete($c_album_image['image_filename'], $u); } db_album_update_c_album_image($target_c_album_image_id, $filename, $image_description, $filesize); // c_albumの更新時間UPDATE db_album_update_c_album_u_datetime($target_c_album_id); $p = array('target_c_album_id' => $target_c_album_id); openpne_redirect('pc', 'page_fh_album', $p); }
/** * c_album_image_idをキーとしてc_album_imageテーブルからデータを削除 */ function db_album_delete_c_album_image($c_album_image_id, $c_member_id) { $sql = 'SELECT image_filename FROM c_album_image WHERE c_album_image_id = ?'; $filename = db_get_one($sql, array($c_album_image_id), 'main'); db_album_image_data_delete($filename, $c_member_id); $sql = 'DELETE FROM c_album_image WHERE c_album_image_id = ?'; $params = array(intval($c_album_image_id)); return db_query($sql, $params); }