/**
* トピック・イベント写真変更
*/
function add_topic_image($c_commu_topic_id)
{
if (!($c_topic = db_commu_c_topic4c_commu_topic_id($c_commu_topic_id))) {
return false;
}
$c_commu_id = $c_topic['c_commu_id'];
if (!db_commu_is_c_topic_admin($c_commu_topic_id, $this->c_member_id) && !db_commu_is_c_commu_admin($c_commu_id, $this->c_member_id)) {
return false;
}
// 登録する写真番号(1-3)を決める
$target_number = 0;
if ($c_topic['image_filename1'] || $c_topic['image_filename2'] || $c_topic['image_filename3']) {
if (!$c_topic['image_filename1']) {
$target_number = 1;
} elseif (!$c_topic['image_filename2']) {
$target_number = 2;
} elseif (!$c_topic['image_filename3']) {
$target_number = 3;
} else {
$this->error_mail('トピック・イベント写真の登録は最大3枚までです。');
m_debug_log('mail_sns::add_topic_image() image is full');
return false;
}
} else {
$target_number = 1;
}
// 写真登録
if ($images = $this->decoder->get_images()) {
$image = $images[0];
$image_ext = $image['ext'];
$image_data = $image['data'];
$filename = 't_' . $c_commu_topic_id . '_' . $target_number . '_' . time() . '.' . $image_ext;
// 画像アップロード可能サイズチェック
$filesize = $image['filesize'];
$result = util_image_check_add_image_upload($filesize, $this->c_member_id, 'commu');
if ($result) {
$msg = util_image_get_upload_err_msg($result);
$this->error_mail($msg);
m_debug_log('mail_sns::add_topic_image() size over');
return false;
}
$c_topic['image_filename' . $target_number] = $filename;
db_image_insert_c_image($filename, $image_data, $filesize, $this->c_member_id);
db_commu_update_c_commu_topic_comment_images($c_topic['c_commu_topic_comment_id'], $c_topic['image_filename1'], $c_topic['image_filename2'], $c_topic['image_filename3']);
return true;
} else {
$this->error_mail('写真が添付されていないか、ファイルサイズが大きすぎるため、登録できませんでした。');
m_debug_log('mail_sns::add_topic_image() no images');
return false;
}
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$c_commu_topic_id = $requests['target_c_commu_topic_id'];
$body = $requests['body'];
$tmpfile1 = $requests['image_filename1_tmpfile'];
$tmpfile2 = $requests['image_filename2_tmpfile'];
$tmpfile3 = $requests['image_filename3_tmpfile'];
// ----------
// 添付ファイル
if (OPENPNE_USE_FILEUPLOAD) {
$filename4_tmpfile = $requests['filename4_tmpfile'];
$filename4_original_filename = $requests['filename4_original_filename'];
if ($filename4_tmpfile) {
// 拡張子制限
if (!util_check_file_extention($filename4_original_filename)) {
$_REQUEST['target_c_commu_topic_id'] = $c_commu_topic_id;
$_REQUEST['err_msg'] = sprintf('アップロードできるファイルの種類は(%s)です', util_get_file_allowed_extensions('string'));
openpne_forward('pc', 'page', "c_topic_detail");
exit;
}
}
}
//--- 権限チェック
//コミュニティ参加者
$c_topic = db_commu_c_topic4c_commu_topic_id($c_commu_topic_id);
$c_commu_id = $c_topic['c_commu_id'];
$c_commu = db_commu_c_commu4c_commu_id($c_commu_id);
switch ($c_commu['is_comment']) {
case 'public':
//誰でもコメント可能
break;
case 'member':
$status = db_common_commu_status($u, $c_commu_id);
if (!$status['is_commu_member']) {
handle_kengen_error();
}
break;
}
if (!db_commu_is_writable_c_commu_topic_comment4c_commu_topic_id($c_commu_topic_id)) {
$err_msg[] = 'コメントが1000番に達したので、このトピックにはコメントできません';
$_REQUEST['err_msg'] = $err_msg;
openpne_forward('pc', 'page', "c_topic_detail");
exit;
}
//---
//---画像アップロードサイズチェック
$filesize = 0;
if ($tmpfile1) {
$filesize += util_image_get_c_tmp_filesize4filename("tc_{$insert_id}_1", $tmpfile1);
}
if ($tmpfile2) {
$filesize += util_image_get_c_tmp_filesize4filename("tc_{$insert_id}_2", $tmpfile2);
}
if ($tmpfile3) {
$filesize += util_image_get_c_tmp_filesize4filename("tc_{$insert_id}_3", $tmpfile3);
}
if ($filesize) {
$result = util_image_check_add_image_upload($filesize, $u, 'commu');
if ($result) {
if ($result == 2) {
$result = 3;
}
$_REQUEST['err_msg'] = util_image_get_upload_err_msg($result);
openpne_forward('pc', 'page', "c_topic_detail");
exit;
}
}
$number = db_commu_c_commu_topic_comment_number4c_commu_topic_id($c_commu_topic_id);
$insert_c_commu_topic_comment = array("c_commu_id" => $c_commu_id, "c_member_id" => $u, "body" => $body, "number" => $number, "c_commu_topic_id" => $c_commu_topic_id);
$insert_id = db_commu_insert_c_commu_topic_comment_3($insert_c_commu_topic_comment);
if ($tmpfile1) {
$filename1 = image_insert_c_image4tmp("tc_{$insert_id}_1", $tmpfile1, $u);
}
if ($tmpfile2) {
$filename2 = image_insert_c_image4tmp("tc_{$insert_id}_2", $tmpfile2, $u);
}
if ($tmpfile3) {
$filename3 = image_insert_c_image4tmp("tc_{$insert_id}_3", $tmpfile3, $u);
}
if (OPENPNE_USE_FILEUPLOAD) {
// 添付ファイルをDBに入れる
if ($filename4_tmpfile) {
$filename4 = file_insert_c_file4tmp("tc_{$insert_id}_4", $filename4_tmpfile, $filename4_original_filename);
}
}
t_image_clear_tmp(session_id());
t_file_clear_tmp(session_id());
db_commu_update_c_commu_topic_comment_images($insert_id, $filename1, $filename2, $filename3);
db_commu_update_c_commu_topic_comment_file($insert_id, $filename4);
//お知らせメール送信(携帯へ)
send_bbs_info_mail($insert_id, $u);
//お知らせメール送信(PCへ)
send_bbs_info_mail_pc($insert_id, $u);
if (OPENPNE_USE_POINT_RANK) {
//トピック・イベントにコメントした人にポイント付与
$point = db_action_get_point4c_action_id(11);
db_point_add_point($u, $point);
}
$p = array('target_c_commu_topic_id' => $c_commu_topic_id);
openpne_redirect('pc', 'page_c_topic_detail', $p);
}
