function execute($requests) { $v = array(); $target_c_diary_ids = $requests['target_c_diary_ids']; // 日記が選択されていない場合はエラー if (!$target_c_diary_ids) { admin_client_redirect('diary_list', WORD_DIARY . "が選択されていません"); } $ids_ary = split(":", $target_c_diary_ids); $v = array(); $diary_list = array(); foreach ($ids_ary as $id) { $diary = db_diary_get_c_diary4id($id); if (!$diary) { admin_client_redirect('diary_list', '指定された' . WORD_DIARY . "は存在しません"); } $diary['count_comments'] = db_diary_count_c_diary_comment4c_diary_id($id); $member = db_member_c_member4c_member_id($diary['c_member_id']); $diary['c_member'] = $member; array_push($diary_list, $diary); } $this->set('diary_list', $diary_list); $this->set('target_c_diary_ids', $target_c_diary_ids); $v['SNS_NAME'] = SNS_NAME; $v['OPENPNE_VERSION'] = OPENPNE_VERSION; $this->set($v); return 'success'; }
function execute($requests) { $v = array(); $target_c_diary_id = $requests['target_c_diary_id']; $v = array(); $diary = db_diary_get_c_diary4id($target_c_diary_id); if (!$diary) { admin_client_redirect('diary_list', '指定された' . WORD_DIARY . 'は存在しません'); } $diary['count_comments'] = db_diary_count_c_diary_comment4c_diary_id($target_c_diary_id); $member = db_member_c_member4c_member_id($diary['c_member_id']); $diary['c_member'] = $member; $this->set('diary', $diary); $v['SNS_NAME'] = SNS_NAME; $v['OPENPNE_VERSION'] = OPENPNE_VERSION; $this->set($v); return 'success'; }
function execute($requests) { $u = $GLOBALS['AUTH']->uid(); // --- リクエスト変数 $target_c_diary_id = $requests['target_c_diary_id']; $tmpfile_1 = $requests['tmpfile_1']; $tmpfile_2 = $requests['tmpfile_2']; $tmpfile_3 = $requests['tmpfile_3']; $body = $requests['body']; // ---------- if (is_null($body) || $body === '') { $p = array('target_c_diary_id' => $target_c_diary_id, 'msg' => "コメントを入力してださい"); openpne_redirect('pc', 'page_fh_diary', $p); } //--- 権限チェック $c_diary = db_diary_get_c_diary4id($target_c_diary_id); $target_c_member_id = $c_diary['c_member_id']; $target_c_member = db_member_c_member4c_member_id($target_c_member_id); if ($u != $target_c_member_id) { // check public_flag if (!pne_check_diary_public_flag($target_c_diary_id, $u)) { openpne_redirect('pc', 'page_h_err_diary_access'); } //アクセスブロック設定 if (db_member_is_access_block($u, $target_c_member_id)) { openpne_redirect('pc', 'page_h_access_block'); } } //日記コメント停止設定 if (OPENPNE_USE_DIARY_COMMENT && !$c_diary['is_comment_input']) { openpne_forward('pc', 'page', 'fh_diary'); exit; } if (!db_diary_is_writable_comment4c_diary_id($target_c_diary_id)) { $_REQUEST['msg'] = 'コメントが1000番に達したので、この' . WORD_DIARY . 'にはコメントできません'; openpne_forward('pc', 'page', 'fh_diary'); exit; } //--- //---画像アップロードサイズチェック $filesize = 0; if ($tmpfile_1) { $filesize += util_image_get_c_tmp_filesize4filename("dc_{$c_diary_comment_id}_1", $tmpfile_1); } if ($tmpfile_2) { $filesize += util_image_get_c_tmp_filesize4filename("dc_{$c_diary_comment_id}_2", $tmpfile_2); } if ($tmpfile_3) { $filesize += util_image_get_c_tmp_filesize4filename("dc_{$c_diary_comment_id}_3", $tmpfile_3); } if ($filesize) { $result = util_image_check_add_image_upload($filesize, $u, 'diary'); if ($result) { if ($result == 2) { $result = 3; } $_REQUEST['msg'] = util_image_get_upload_err_msg($result); openpne_forward('pc', 'page', 'fh_diary'); exit; } } //日記コメント書き込み $c_diary_comment_id = db_diary_insert_c_diary_comment($u, $target_c_diary_id, $body); $sessid = session_id(); $filename_1 = image_insert_c_image4tmp("dc_{$c_diary_comment_id}_1", $tmpfile_1, $u); $filename_2 = image_insert_c_image4tmp("dc_{$c_diary_comment_id}_2", $tmpfile_2, $u); $filename_3 = image_insert_c_image4tmp("dc_{$c_diary_comment_id}_3", $tmpfile_3, $u); t_image_clear_tmp($sessid); db_diary_insert_c_diary_comment_images($c_diary_comment_id, $filename_1, $filename_2, $filename_3); //日記コメント記入履歴更新 if ($u != $target_c_member_id) { db_diary_insert_c_diary_comment_log($u, $target_c_diary_id); } db_diary_update_c_diary_comment_log($target_c_diary_id); //日記コメントが書き込まれたので日記自体を未読扱いにする db_diary_update_c_diary_is_checked($target_c_diary_id, 0); // お知らせメール送信(携帯へ) if ($u != $target_c_member_id) { send_diary_comment_info_mail($c_diary_comment_id, $u); } if (OPENPNE_USE_POINT_RANK) { // コメント者と被コメント者が違う場合にポイント加算 if ($u != $target_c_member_id) { //書いた人にポイント付与 $point = db_action_get_point4c_action_id(3); db_point_add_point($u, $point); //書かれた人にポイント付与 $point = db_action_get_point4c_action_id(2); db_point_add_point($target_c_member_id, $point); } } $p = array('target_c_diary_id' => $target_c_diary_id, 'comment_count' => db_diary_count_c_diary_comment4c_diary_id($target_c_diary_id)); openpne_redirect('pc', 'page_fh_diary', $p); }
/** * SNS全体の最新日記リスト取得 * 日記公開範囲を考慮 * * @param int $limit * @return array_of_array (c_diary.*, nickname) */ function p_h_home_c_diary_all_list($limit) { $sql = 'SELECT * FROM c_diary WHERE public_flag = \'public\'' . ' ORDER BY c_diary.r_datetime DESC'; $c_diary_list_all = db_get_all_limit($sql, 0, $limit); foreach ($c_diary_list_all as $key => $value) { $c_member = db_member_c_member4c_member_id_LIGHT($value['c_member_id']); $c_diary_list_all[$key]['nickname'] = $c_member['nickname']; $c_diary_list_all[$key]['count_comments'] = db_diary_count_c_diary_comment4c_diary_id($value['c_diary_id']); } return $c_diary_list_all; }
/** * お気に入りメンバーの日記リスト(ページャ付き) */ function db_bookmark_diary_list_with_pager($c_member_id, $page_size, $page) { $bookmarks = db_bookmark_c_member_id_list($c_member_id, true); if (!$bookmarks) { return array(array(), false, false, 0); } $ids = implode(',', array_map('intval', $bookmarks)); $sql = 'SELECT c_diary.* FROM c_diary, c_member WHERE c_diary.c_member_id IN (' . $ids . ') AND c_diary.public_flag = \'public\' AND c_diary.c_member_id=c_member.c_member_id ORDER BY r_datetime DESC'; $diary_list = db_get_all_page($sql, intval($page), intval($page_size)); foreach ($diary_list as $key => $value) { $diary_list[$key]['c_member'] = db_member_c_member4c_member_id_LIGHT($value['c_member_id']); $diary_list[$key]['count_comments'] = db_diary_count_c_diary_comment4c_diary_id($value['c_diary_id']); } $sql = 'SELECT count(*) FROM c_diary WHERE c_member_id IN (' . $ids . ')'; $total_num = db_get_one($sql); if ($total_num != 0) { $total_page_num = ceil($total_num / $page_size); if ($page >= $total_page_num) { $next = false; } else { $next = true; } if ($page <= 1) { $prev = false; } else { $prev = true; } } return array($diary_list, $prev, $next, $total_num); }
function monitor_diary_comment_list4c_diary_id($c_diary_id, $page_size, $page) { $page = intval($page); $page_size = intval($page_size); $where = " WHERE c_diary_comment.c_diary_id = ? "; $params[] = intval($c_diary_id); $select = "SELECT c_diary_comment.*, c_diary.subject"; $from = " FROM c_diary_comment" . " LEFT JOIN c_diary ON c_diary.c_diary_id = c_diary_comment.c_diary_id "; $order = " ORDER BY r_datetime desc"; $sql = $select . $from . $where . $order; $list = db_get_all_limit($sql, ($page - 1) * $page_size, $page_size, $params); foreach ($list as $key => $value) { $list[$key]['c_member'] = db_member_c_member_with_profile($value['c_member_id']); $list[$key]['count_comments'] = db_diary_count_c_diary_comment4c_diary_id($value['c_diary_id']); } $sql = "SELECT COUNT(*) " . $from . $where; $total_num = db_get_one($sql, $params); $total_page_num = ceil($total_num / $page_size); $next = $page < $total_page_num; $prev = $page > 1; return array($list, $prev, $next, $total_num, $total_page_num); }