function execute($requests)
 {
     $v = array();
     $target_c_commu_topic_comment_ids = $requests['target_c_commu_topic_comment_ids'];
     // トピックのコメントが選択されていない場合はエラー
     if (!$target_c_commu_topic_comment_ids) {
         admin_client_redirect('topic_comment_list', "トピックのコメントが選択されていません");
     }
     $id_ary = split(":", $target_c_commu_topic_comment_ids);
     $v = array();
     $topic_comment_list = array();
     foreach ($id_ary as $id) {
         $topic_comment = db_commu_c_commu_topic_comment4c_commu_topic_comment_id($id);
         if (!$topic_comment) {
             admin_client_redirect('topic_comment_list', '指定されたトピック・イベントのコメントは存在しません');
         }
         if ($topic_comment['number'] == 0) {
             admin_client_redirect('topic_comment_list', '指定されたコメントはトピック本文のためトピック削除にて削除してください');
         }
         $member = db_member_c_member4c_member_id($topic_comment['c_member_id']);
         $topic_comment['nickname'] = $member['nickname'];
         $topic_comment['count_comments'] = _db_count_c_commu_topic_comments4c_commu_topic_id($topic_comment['c_commu_topic_id']);
         $topic_comment['original_filename'] = db_file_original_filename4filename($topic_comment['filename']);
         array_push($topic_comment_list, $topic_comment);
     }
     $this->set('topic_comment_list', $topic_comment_list);
     $this->set('target_c_commu_topic_comment_ids', $target_c_commu_topic_comment_ids);
     $v['SNS_NAME'] = SNS_NAME;
     $v['OPENPNE_VERSION'] = OPENPNE_VERSION;
     $this->set($v);
     return 'success';
 }
 function execute($requests)
 {
     $v = array();
     $target_c_commu_topic_ids = $requests['target_c_commu_topic_ids'];
     // トピックが選択されていない場合はエラー
     if (!$target_c_commu_topic_ids) {
         admin_client_redirect('topic_list', "トピックが選択されていません");
     }
     $id_ary = split(":", $target_c_commu_topic_ids);
     $v = array();
     $topic_list = array();
     foreach ($id_ary as $id) {
         $topic = db_commu_c_topic4c_commu_topic_id_2($id);
         if (!$topic) {
             admin_client_redirect('topic_list', '指定されたトピック・イベントは存在しません');
         }
         $member = db_member_c_member4c_member_id($topic['c_member_id']);
         $topic['count_comments'] = _db_count_c_commu_topic_comments4c_commu_topic_id($topic['c_commu_topic_id']);
         $commu = db_commu_c_commu4c_commu_id($topic['c_commu_id']);
         $topic['commu_name'] = $commu['name'];
         $topic['c_member'] = $member;
         $topic['original_filename'] = db_file_original_filename4filename($topic['filename']);
         array_push($topic_list, $topic);
     }
     $this->set('topic_list', $topic_list);
     $this->set('pref', p_regist_prof_c_profile_pref_list4null());
     $this->set('target_c_commu_topic_ids', $target_c_commu_topic_ids);
     $v['SNS_NAME'] = SNS_NAME;
     $v['OPENPNE_VERSION'] = OPENPNE_VERSION;
     $this->set($v);
     return 'success';
 }
예제 #3
0
 function execute($requests)
 {
     $u = $GLOBALS['KTAI_C_MEMBER_ID'];
     $tail = $GLOBALS['KTAI_URL_TAIL'];
     // --- リクエスト変数
     $target_c_message_id = $requests['target_c_message_id'];
     $from_h_home = $requests['from_h_home'];
     // ----------
     // メッセージデータ取得
     $c_message = db_message_c_message4c_message_id($target_c_message_id);
     //--- 権限チェック
     if (!util_is_readable_message($u, $target_c_message_id)) {
         handle_kengen_error();
     }
     //---
     // 既読にする
     db_message_update_c_message_is_read4c_message_id($target_c_message_id, $u);
     // メッセージデータ
     //コミュニティおすすめメッセージのURLを置換
     list($c_message['body'], $com_url, $friend_url) = k_p_h_message_ktai_url4url($c_message['body'], $tail);
     //オリジナルファイル名取得
     $c_message['original_filename'] = db_file_original_filename4filename($c_message['filename']);
     $this->set("c_message", $c_message);
     $this->set("com_url", $com_url);
     $this->set("friend_url", $friend_url);
     //送信箱
     if ($c_message['c_member_id_from'] == $u) {
         $box = 'outbox';
     }
     $this->set("next_c_message_id", db_message_get_c_message_next_id4c_message_id($u, $target_c_message_id, $box));
     $this->set("prev_c_message_id", db_message_get_c_message_prev_id4c_message_id($u, $target_c_message_id, $box));
     return 'success';
 }
예제 #4
0
 function execute($requests)
 {
     $u = $GLOBALS['AUTH']->uid();
     // --- リクエスト変数
     $target_c_message_id = $requests['target_c_message_id'];
     $from_h_home = $requests['from_h_home'];
     $form_val['subject'] = $requests['subject'];
     $form_val['body'] = $requests['body'];
     $box = $requests['box'];
     $jyusin_c_message_id = $requests['jyusin_c_message_id'];
     // ----------
     $form_val['target_c_message_id'] = $target_c_message_id;
     $this->set('inc_navi', fetch_inc_navi("h"));
     // 既読にする
     db_message_update_c_message_is_read4c_message_id($target_c_message_id, $u);
     //---- 受信・送信、閲覧権限のチェック ----//
     // メッセージデータ取得
     $c_message = db_message_c_message4c_message_id2($target_c_message_id, $u);
     $c_message['original_filename'] = db_file_original_filename4filename($c_message['filename']);
     if ($c_message['c_member_id_from'] == $u && $box === 'inbox') {
         $box = 'outbox';
     }
     if ($c_message['c_member_id_to'] == $u && $box === 'outbox') {
         $box = 'inbox';
     }
     if (!$form_val['subject']) {
         $form_val['subject'] = "Re:" . $c_message['subject'];
     }
     //--- 権限チェック
     if (!util_is_readable_message($u, $target_c_message_id)) {
         handle_kengen_error();
     }
     //---
     // is_syoudakuがあれば承認待ちリストへリダイレクト
     if ($c_message['is_syoudaku'] && $from_h_home == 1) {
         openpne_redirect('pc', 'page_h_confirm_list');
     }
     //---- ページ本体表示用 変数 ----//
     // メッセージデータ
     $this->set("c_message", $c_message);
     $this->set("form_val", $form_val);
     $this->set("jyusin_c_message_id", $jyusin_c_message_id);
     $this->set("next_c_message_id", db_message_get_c_message_next_id4c_message_id($u, $target_c_message_id, $box));
     $this->set("prev_c_message_id", db_message_get_c_message_prev_id4c_message_id($u, $target_c_message_id, $box));
     //ボックス判定
     $this->set("box", $box);
     //---- ページ表示 ----//
     return 'success';
 }
예제 #5
0
 function execute($requests)
 {
     $u = $GLOBALS['AUTH']->uid();
     // --- リクエスト変数
     $c_commu_topic_id = $requests['target_c_commu_topic_id'];
     $title = $requests['title'];
     $body = $requests['body'];
     $err_msg = $requests['err_msg'];
     // ----------
     $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();
     }
     $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();
     }
     //---
     if ($c_topic['event_flag']) {
         $p = array('target_c_commu_topic_id' => $c_topic['c_commu_topic_id']);
         openpne_redirect('pc', 'page_c_event_edit', $p);
     }
     $this->set('inc_navi', fetch_inc_navi('c', $c_commu_id));
     if ($err_msg) {
         $c_topic['name'] = $title;
         $c_topic['body'] = $body;
     }
     if (!empty($c_topic['filename'])) {
         $original_filename = db_file_original_filename4filename($c_topic['filename']);
         $c_topic['original_filename'] = $original_filename;
     }
     $this->set('err_msg', $err_msg);
     $this->set('c_topic', $c_topic);
     // 許可されている拡張子のリスト
     $this->set('allowed_extensions', util_get_file_allowed_extensions('string'));
     return 'success';
 }
 function execute($requests)
 {
     $v = array();
     $target_c_commu_topic_comment_id = $requests['target_c_commu_topic_comment_id'];
     $v = array();
     $topic_comment = db_commu_c_commu_topic_comment4c_commu_topic_comment_id($target_c_commu_topic_comment_id);
     if (!$topic_comment) {
         admin_client_redirect('topic_comment_list', '指定されたトピック・イベントのコメントは存在しません');
     }
     if ($topic_comment['number'] == 0) {
         admin_client_redirect('topic_comment_list', '指定されたコメントはトピック本文のためトピック削除にて削除してください');
     }
     $member = db_member_c_member4c_member_id($topic_comment['c_member_id']);
     $topic_comment['nickname'] = $member['nickname'];
     $topic_comment['count_comments'] = _db_count_c_commu_topic_comments4c_commu_topic_id($topic_comment['c_commu_topic_id']);
     $topic_comment['original_filename'] = db_file_original_filename4filename($topic_comment['filename']);
     $this->set('topic_comment', $topic_comment);
     $v['SNS_NAME'] = SNS_NAME;
     $v['OPENPNE_VERSION'] = OPENPNE_VERSION;
     $this->set($v);
     return 'success';
 }
예제 #7
0
 function execute($requests)
 {
     $v = array();
     $target_c_commu_topic_id = $requests['target_c_commu_topic_id'];
     $v = array();
     $topic = db_commu_c_topic4c_commu_topic_id_2($target_c_commu_topic_id);
     if (!$topic) {
         admin_client_redirect('topic_list', '指定されたトピック・イベントは存在しません');
     }
     $member = db_member_c_member4c_member_id($topic['c_member_id']);
     $topic['count_comments'] = _db_count_c_commu_topic_comments4c_commu_topic_id($topic['c_commu_topic_id']);
     $commu = db_commu_c_commu4c_commu_id($topic['c_commu_id']);
     $topic['commu_name'] = $commu['name'];
     $topic['c_member'] = $member;
     $topic['original_filename'] = db_file_original_filename4filename($topic['filename']);
     $this->set('topic', $topic);
     $this->set('pref', p_regist_prof_c_profile_pref_list4null());
     $v['SNS_NAME'] = SNS_NAME;
     $v['OPENPNE_VERSION'] = OPENPNE_VERSION;
     $this->set($v);
     return 'success';
 }
 function execute($requests)
 {
     $u = $GLOBALS['AUTH']->uid();
     // --- リクエスト変数
     $c_commu_topic_comment_id = $requests['target_c_commu_topic_comment_id'];
     // ----------
     $c_commu_topic_comment = db_commu_c_commu_topic_comment4c_commu_topic_comment_id_3($c_commu_topic_comment_id);
     $c_commu_id = $c_commu_topic_comment['c_commu_id'];
     $c_commu_topic_id = $c_commu_topic_comment['c_commu_topic_id'];
     $c_commu = db_commu_c_commu4c_commu_id($c_commu_id);
     //--- 権限チェック
     $status = db_common_commu_status($u, $c_commu_id);
     if (!$status['is_commu_admin'] && $c_commu_topic_comment['c_member_id'] != $u) {
         handle_kengen_error();
     }
     //---
     $c_commu_topic_comment['original_filename'] = db_file_original_filename4filename($c_commu_topic_comment['filename']);
     $this->set('inc_navi', fetch_inc_navi("c", $c_commu_id));
     $this->set('c_commu_id', $c_commu_id);
     $this->set('c_commu_topic_id', $c_commu_topic_id);
     $this->set('c_commu_topic_comment', $c_commu_topic_comment);
     $this->set("c_member", db_member_c_member4c_member_id($c_commu_topic_comment['c_member_id']));
     return 'success';
 }
 function execute($requests)
 {
     $u = $GLOBALS['KTAI_C_MEMBER_ID'];
     // --- リクエスト変数
     $target_c_commu_topic_id = $requests['target_c_commu_topic_id'];
     $c_commu_topic_comment_id = $requests['c_commu_topic_comment_id'];
     // ----------
     $c_topic = db_commu_c_topic4c_commu_topic_id($target_c_commu_topic_id);
     $c_commu_id = $c_topic['c_commu_id'];
     $c_commu_topic_comment = db_commu_c_commu_topic_comment4c_commu_topic_comment_id_2($c_commu_topic_comment_id);
     $c_commu_topic_comment['original_filename'] = db_file_original_filename4filename($c_commu_topic_comment['filename']);
     //--- 権限チェック
     $status = db_common_commu_status($u, $c_commu_id);
     if (!$status['is_commu_admin'] && $c_commu_topic_comment['c_member_id'] != $u) {
         handle_kengen_error();
     }
     //---
     //トピック名
     $this->set("c_commu_topic_name", $c_topic['name']);
     $this->set('c_commu_topic_comment', $c_commu_topic_comment);
     $this->set("c_commu_topic_id", $target_c_commu_topic_id);
     $this->set("c_commu_topic_comment_id", $c_commu_topic_comment_id);
     return 'success';
 }
예제 #10
0
 function execute($requests)
 {
     $u = $GLOBALS['AUTH']->uid();
     // --- リクエスト変数
     $c_commu_topic_id = $requests['target_c_commu_topic_id'];
     $err_msg = $requests['err_msg'];
     // ----------
     $c_topic = db_commu_c_topic4c_commu_topic_id_2($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();
     }
     $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();
     }
     //---
     if (!$c_topic['event_flag']) {
         $p = array('target_c_commu_topic_id' => $c_topic['c_commu_topic_id']);
         openpne_redirect('pc', 'page_c_topic_edit', $p);
     }
     if (!empty($c_topic['filename'])) {
         $c_topic['original_filename'] = db_file_original_filename4filename($c_topic['filename']);
     }
     $this->set('inc_navi', fetch_inc_navi("c", $c_commu_id));
     $this->set("year", db_commu_year4null());
     $this->set('month', p_regist_prof_c_profile_month_list4null());
     $this->set('day', p_regist_prof_c_profile_day_list4null());
     $this->set('pref', p_regist_prof_c_profile_pref_list4null());
     $this->set('err_msg', $err_msg);
     //編集確認画面でエラーがでたときここに戻ってくる。そのときのためにrequestから取得
     //保留
     if ($err_msg) {
         $c_topic_temp = p_c_event_add_confirm_event4request();
         $c_topic['name'] = $c_topic_temp['title'];
         $c_topic['body'] = $c_topic_temp['detail'];
         $c_topic['open_date_comment'] = $c_topic_temp['open_date_comment'];
         $c_topic['open_pref_id'] = $c_topic_temp['open_pref_id'];
         $c_topic['open_pref_comment'] = $c_topic_temp['open_pref_comment'];
         $c_topic['open_date_year'] = $c_topic_temp['open_date_year'];
         $c_topic['open_date_month'] = $c_topic_temp['open_date_month'];
         $c_topic['open_date_day'] = $c_topic_temp['open_date_day'];
         $c_topic['invite_period_year'] = $c_topic_temp['invite_period_year'];
         $c_topic['invite_period_month'] = $c_topic_temp['invite_period_month'];
         $c_topic['invite_period_day'] = $c_topic_temp['invite_period_day'];
     } else {
         $open_date_arr = explode("-", $c_topic['open_date']);
         $invite_period_arr = explode("-", $c_topic['invite_period']);
         $c_topic['open_date_year'] = $open_date_arr[0];
         $c_topic['open_date_month'] = $open_date_arr[1];
         $c_topic['open_date_day'] = $open_date_arr[2];
         $c_topic['invite_period_year'] = $invite_period_arr[0];
         $c_topic['invite_period_month'] = $invite_period_arr[1];
         $c_topic['invite_period_day'] = $invite_period_arr[2];
     }
     $this->set('event', $c_topic);
     // 許可されている拡張子のリスト
     $this->set('allowed_extensions', util_get_file_allowed_extensions('string'));
     return 'success';
 }
예제 #11
0
 function execute($requests)
 {
     $u = $GLOBALS['AUTH']->uid();
     // --- リクエスト変数
     $c_commu_topic_id = $requests['target_c_commu_topic_id'];
     $page = $requests['page'];
     $err_msg = $requests['err_msg'];
     $body = $requests['body'];
     // ----------
     $c_topic = db_commu_c_topic4c_commu_topic_id_2($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();
     }
     //---
     $c_commu = db_commu_c_commu4c_commu_id($c_commu_id);
     if (!$c_commu) {
         openpne_redirect('pc', 'page_h_err_c_home');
     }
     if (!$c_topic['event_flag']) {
         $p = array('target_c_commu_topic_id' => $c_topic['c_commu_topic_id']);
         openpne_redirect('pc', 'page_c_topic_detail', $p);
     }
     $this->set('inc_navi', fetch_inc_navi('c', $c_commu_id));
     //詳細部分
     $this->set('c_commu', $c_commu);
     $c_topic = db_commu_c_topic4c_commu_topic_id_2($c_commu_topic_id);
     $c_topic['original_filename'] = db_file_original_filename4filename($c_topic['filename']);
     $this->set('c_topic', $c_topic);
     //書き込み一覧部分
     if ($requests['page_size'] == 100) {
         $page_size = 100;
     } else {
         $page_size = 20;
     }
     if ($requests['order'] === 'asc') {
         $desc = false;
     } else {
         $desc = true;
     }
     list($c_topic_write, $pager) = db_commu_c_topic_write4c_commu_topic_id($c_commu_topic_id, $page, $page_size, $desc);
     foreach ($c_topic_write as $key => $value) {
         if ($value['filename']) {
             $c_topic_write[$key]['original_filename'] = db_file_original_filename4filename($value['filename']);
         }
     }
     $this->set('c_topic_write', $c_topic_write);
     $this->set('pager', $pager);
     $this->set('is_c_commu_admin', db_commu_is_c_commu_admin($c_commu_id, $u));
     $this->set('is_c_commu_member', db_commu_is_c_commu_member($c_commu_id, $u));
     $this->set('is_c_event_member', db_commu_is_c_event_member($c_commu_topic_id, $u));
     $this->set('is_c_event_admin', db_commu_is_c_event_admin($c_commu_topic_id, $u));
     $this->set('is_event_join_date', db_commu_is_event_join_date($c_commu_topic_id));
     $this->set('is_event_join_capacity', db_commu_is_event_join_capacity($c_commu_topic_id));
     $this->set('is_writable_comment', db_commu_is_writable_c_commu_topic_comment4c_commu_topic_id($c_commu_topic_id));
     $this->set('err_msg', $err_msg);
     $this->set('body', $body);
     $this->set('c_member_id', $u);
     // 許可されている拡張子のリスト
     $this->set('allowed_extensions', util_get_file_allowed_extensions('string'));
     return 'success';
 }
예제 #12
0
function monitor_topic_list($keyword, $page_size, $page)
{
    $page = intval($page);
    $page_size = intval($page_size);
    $wheres = array();
    if ($keyword) {
        $keyword = str_replace(' ', ' ', $keyword);
        $keyword_list = explode(' ', $keyword);
        for ($i = 0; $i < count($keyword_list); $i++) {
            $keyword = check_search_word($keyword_list[$i]);
            $wheres[] = '(ctc.body like ? OR ct.name like ? OR c.name like ?)';
            $params[] = '%' . $keyword . '%';
            $params[] = '%' . $keyword . '%';
            $params[] = '%' . $keyword . '%';
        }
    }
    if ($wheres) {
        $where = ' WHERE ' . implode(' AND ', $wheres);
    } else {
        $where = '';
    }
    if ($GLOBALS['_OPENPNE_DSN_LIST']['main']['dsn']['phptype'] == 'pgsql') {
        $select = "SELECT ct.*," . " ct.name AS topic_name, c.name AS commu_name," . " ctc.body, ctc.filename, ctc.image_filename1, ctc.image_filename2, ctc.image_filename3," . " CASE WHEN ct.invite_period = '0001-01-01 BC' THEN '0000-00-00' ELSE to_char(ct.invite_period,'YYYY-MM-DD') END AS invite_period";
    } else {
        $select = "SELECT ct.*," . " ct.name AS topic_name, c.name AS commu_name," . " ctc.body, ctc.filename, ctc.image_filename1, ctc.image_filename2, ctc.image_filename3";
    }
    $from = " FROM c_commu_topic AS ct" . " LEFT JOIN c_commu AS c ON c.c_commu_id = ct.c_commu_id" . " LEFT JOIN c_commu_topic_comment AS ctc ON (ctc.c_commu_topic_id = ct.c_commu_topic_id AND ctc.number = 0)";
    $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]['count_comments'] = _db_count_c_commu_topic_comments4c_commu_topic_id($value['c_commu_topic_id']);
        $c_member = db_member_c_member4c_member_id_LIGHT($value['c_member_id']);
        $list[$key]['nickname'] = $c_member['nickname'];
        if (!empty($value['filename'])) {
            $list[$key]['original_filename'] = db_file_original_filename4filename($value['filename']);
        }
        if ($value['event_flag']) {
            $list[$key]['member_num'] = db_commu_count_c_event_member_list4c_commu_topic_id($value['c_commu_topic_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);
}
예제 #13
0
 function execute($requests)
 {
     $u = $GLOBALS['KTAI_C_MEMBER_ID'];
     // --- リクエスト変数
     $c_commu_topic_id = $requests['target_c_commu_topic_id'];
     $target_response_comment_id = $requests['target_response_comment_id'];
     $page = $requests['page'];
     // ----------
     $page_size = 5;
     // トピックのコメントリスト
     if ($requests['order'] === 'asc') {
         $desc = false;
     } else {
         $desc = true;
     }
     list($list, $pager) = db_commu_c_topic_write4c_commu_topic_id($c_commu_topic_id, $page, $page_size, $desc);
     foreach ($list as $key => $value) {
         if ($value['filename']) {
             $list[$key]['original_filename'] = db_file_original_filename4filename($value['filename']);
         }
     }
     $this->set('c_commu_topic_comment_list', $list);
     $this->set('pager', $pager);
     //トピック名
     $this->set('c_commu_topic_name', db_commu_c_commu_topic_name4c_commu_topic_id($c_commu_topic_id));
     //トピックID
     $this->set('c_commu_topic_id', $c_commu_topic_id);
     //トピック
     $c_commu_topic = db_commu_c_topic4c_commu_topic_id_2($c_commu_topic_id);
     $c_commu_topic['original_filename'] = db_file_original_filename4filename($c_commu_topic['filename']);
     $this->set('c_commu_topic', $c_commu_topic);
     //コミュニティ
     $c_commu = db_commu_c_commu4c_commu_topic_id($c_commu_topic_id);
     $c_commu_id = $c_commu['c_commu_id'];
     $c_commu = db_commu_c_commu4c_commu_id($c_commu_id);
     $this->set('c_commu', $c_commu);
     //--- 権限チェック
     //コミュニティの存在の有無
     if (!$c_commu) {
         handle_kengen_error();
     }
     //コミュニティ掲示板閲覧権限
     if (!db_commu_is_c_commu_view4c_commu_idAc_member_id($c_commu_id, $u)) {
         handle_kengen_error();
     }
     if ($target_response_comment_id) {
         $target_comment = db_commu_c_commu_topic_comment4c_commu_topic_comment_id($target_response_comment_id);
         $response_set = db_member_c_member4c_member_id_LIGHT($target_comment['c_member_id']);
         $this->set('response_comment_format', '>>' . $target_comment['number'] . ' ' . $response_set['nickname'] . "さん\n");
     }
     //掲示板の閲覧権限 tplでやっている
     $this->set('is_c_commu_view', db_commu_is_c_commu_view4c_commu_idAc_member_id($c_commu['c_commu_id'], $u));
     $this->set('is_c_commu_member', db_commu_is_c_commu_member($c_commu['c_commu_id'], $u));
     $this->set('is_c_event_member', db_commu_is_c_event_member($c_commu_topic_id, $u));
     $this->set('is_c_event_admin', db_commu_is_c_event_admin($c_commu_topic_id, $u));
     $this->set('is_event_join_date', db_commu_is_event_join_date($c_commu_topic_id));
     $this->set('is_event_join_capacity', db_commu_is_event_join_capacity($c_commu_topic_id));
     $this->set('is_writable_comment', db_commu_is_writable_c_commu_topic_comment4c_commu_topic_id($c_commu_topic_id));
     //メンバーがコミュニティ管理者かどうか
     $this->set('is_admin', db_commu_is_admin4c_member_id_c_commu_topic_id($u, $c_commu_topic_id));
     //コミュニティ管理者
     $this->set('c_member_admin', db_commu_c_member_admin4c_commu_topic_id($c_commu_topic_id));
     if (MAIL_ADDRESS_HASHED) {
         $mail_address = "t{$c_commu_topic_id}-" . t_get_user_hash($u) . '@' . MAIL_SERVER_DOMAIN;
     } else {
         $mail_address = "t{$c_commu_topic_id}" . '@' . MAIL_SERVER_DOMAIN;
     }
     $mail_address = MAIL_ADDRESS_PREFIX . $mail_address;
     $this->set('mail_address', $mail_address);
     return 'success';
 }