PHP db_commu_c_commu4c_commu_id函数代码示例

 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);
     //--- 権限チェック
     if (!db_commu_is_c_commu_view4c_commu_idAc_member_id($c_commu_id, $u)) {
         handle_kengen_error();
     }
     $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('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);
     return 'success';
 }

 function execute($requests)
 {
     $u = $GLOBALS['AUTH']->uid();
     // --- リクエスト変数
     $target_c_commu_id = $requests['target_c_commu_id'];
     $page = $requests['page'];
     // ----------
     $this->set('inc_navi', fetch_inc_navi("c", $target_c_commu_id));
     //メンバー情報
     $this->set("member", db_member_c_member4c_member_id($u));
     //コミュニティID
     $this->set("c_commu_id", $target_c_commu_id);
     $this->set("c_commu", db_commu_c_commu4c_commu_id($target_c_commu_id));
     $this->set("c_commu_num", db_commu_count_c_commu_member_list4c_commu_id($target_c_commu_id));
     $page_size = 50;
     //コミュニティメンバーリスト
     list($c_member_list, $is_prev, $is_next, $total_num, $start_num, $end_num) = db_commu_c_members4c_commu_id($target_c_commu_id, $page_size, $page);
     $this->set("c_member_list", $c_member_list);
     $this->set("is_prev", $is_prev);
     $this->set("is_next", $is_next);
     $this->set("page", $page);
     $this->set("total_num", $total_num);
     $this->set('start_num', $start_num);
     $this->set('end_num', $end_num);
     for ($i = 1; $i <= ceil($total_num / $page_size); $i++) {
         $page_num[] = $i;
     }
     $this->set("page_num", $page_num);
     return 'success';
 }

 function execute($requests)
 {
     $u = $GLOBALS['AUTH']->uid();
     // --- リクエスト変数
     $c_commu_id = $requests['target_c_commu_id'];
     $page = $requests['page'];
     // ----------
     $page_size = 30;
     $c_member_id = $u;
     //--- 権限チェック
     //コミュニティメンバー
     if (!db_commu_is_c_commu_member($c_commu_id, $u)) {
         handle_kengen_error();
     }
     //---
     $this->set('c_member', db_member_c_member4c_member_id($c_member_id));
     list($c_review_list, $is_prev, $is_next, $total_num, $start_num, $end_num) = db_review_list_product_c_review_list4c_member_id($c_member_id, $page, $page_size);
     $this->set('c_review_list', $c_review_list);
     $this->set("is_prev", $is_prev);
     $this->set("is_next", $is_next);
     $this->set("page", $page);
     $this->set("total_num", $total_num);
     $this->set('start_num', $start_num);
     $this->set('end_num', $end_num);
     $c_commu = db_commu_c_commu4c_commu_id($c_commu_id);
     $this->set('c_commu', $c_commu);
     $this->set('inc_navi', fetch_inc_navi('c', $c_commu_id));
     return 'success';
 }

 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);
     //--- 権限チェック
     if ($c_commu['c_member_id_admin'] != $u && $c_commu['c_member_id_sub_admin'] != $u) {
         handle_kengen_error();
     }
     //---
     //カテゴリのリスト
     $c_commu_category_list = db_commu_c_commu_category4is_create_commu($c_commu['c_commu_category_id']);
     // 現在設定されているカテゴリが作成不可ならば、別途取得
     if (!db_commu_c_commu_category_is_create_commu($c_commu['c_commu_category_id'])) {
         array_push($c_commu_category_list, db_commu_get_c_commu_category4id($c_commu['c_commu_category_id']));
         asort($c_commu_category_list);
     }
     $this->set('c_commu_category_list', $c_commu_category_list);
     $this->set('is_topic', db_commu_is_topic4c_commu_id($target_c_commu_id));
     $this->set('c_commu', $c_commu);
     if ($c_commu['c_member_id_sub_admin'] == $u) {
         $this->set('is_sub_admin', 1);
     }
     return 'success';
 }

 function execute($requests)
 {
     $tail = $GLOBALS['KTAI_URL_TAIL'];
     $u = $GLOBALS['KTAI_C_MEMBER_ID'];
     // --- リクエスト変数
     $target_c_commu_id = $requests['target_c_commu_id'];
     $body = $requests['body'];
     $target_c_member_id = $requests['target_c_member_id'];
     // ----------
     //--- 権限チェック
     //フレンド
     $status = db_friend_status($u, $target_c_member_id);
     if (!$status['is_friend']) {
         handle_kengen_error();
     }
     //---
     list($msg_subject, $msg_body) = create_message_commu_invite($u, $body, $target_c_commu_id);
     db_message_send_message_syoukai_commu($u, $target_c_member_id, $msg_subject, $msg_body);
     $commu = db_commu_c_commu4c_commu_id($target_c_commu_id);
     $c_member_id_admin = $commu['c_member_id_admin'];
     $public_flag = $commu['public_flag'];
     if ($c_member_id_admin == $u && $public_flag != 'public') {
         db_commu_insert_c_commu_admin_invite($target_c_commu_id, $target_c_member_id);
     }
     $p = array('target_c_commu_id' => $target_c_commu_id);
     openpne_redirect('ktai', 'page_c_home', $p);
 }

 function execute($requests)
 {
     $u = $GLOBALS['AUTH']->uid();
     // --- リクエスト変数
     $c_commu_topic_id = $requests['target_c_commu_topic_id'];
     $c_member_ids = $requests['c_member_id'];
     $body = $requests['body'];
     // ----------
     if (!$c_member_ids) {
         $p = array('target_c_commu_topic_id' => $c_commu_topic_id);
         openpne_redirect('pc', 'page_c_event_mail', $p);
     }
     $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_event_admin($c_commu_topic_id, $u) && !db_commu_is_c_commu_admin($c_commu_id, $u)) {
         handle_kengen_error();
     }
     if (in_array($u, $c_member_ids)) {
         handle_kengen_error();
     }
     //---
     $this->set('c_commu', db_commu_c_commu4c_commu_id($c_commu_id));
     $this->set('inc_navi', fetch_inc_navi('c', $c_commu_id));
     $this->set('c_mail_member', db_commu_c_event_mail_confirm_list4c_member_ids($c_member_ids));
     $this->set('body', $body);
     $this->set('c_member_ids', implode(',', $c_member_ids));
     $this->set("c_commu_id", $c_commu_id);
     $this->set("c_commu_topic_id", $c_commu_topic_id);
     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';
 }

 function execute($requests)
 {
     $u = $GLOBALS['AUTH']->uid();
     // --- リクエスト変数
     $target_c_commu_id = $requests['target_c_commu_id'];
     $page = $requests['page'];
     // ----------
     //--- 権限チェック
     //コミュニティ管理者
     if (!db_commu_is_c_commu_admin($target_c_commu_id, $u)) {
         handle_kengen_error();
     }
     //---
     $this->set('inc_navi', fetch_inc_navi('c', $target_c_commu_id));
     //メンバー情報
     $this->set("member", db_member_c_member4c_member_id($u));
     //コミュニティID
     $this->set("c_commu_id", $target_c_commu_id);
     //コミュニティ情報
     $this->set("c_commu", db_commu_c_commu4c_commu_id($target_c_commu_id));
     $page_size = 20;
     //コミュニティメンバーリスト
     $list = db_commu_c_member_list4c_commu_id($target_c_commu_id, $page_size, $page);
     $this->set("c_member_list", $list[0]);
     $this->set("is_prev", $list[1]);
     $this->set("is_next", $list[2]);
     $this->set("page", $page);
     return 'success';
 }

 function execute($requests)
 {
     $u = $GLOBALS['AUTH']->uid();
     // --- リクエスト変数
     $c_commu_id = $requests['target_c_commu_id'];
     $c_review_id = $requests['c_review_id'];
     // ----------
     //--- 権限チェック
     //コミュニティメンバー
     if (!db_commu_is_c_commu_member($c_commu_id, $u)) {
         handle_kengen_error();
     }
     //---
     if (!$c_review_id) {
         $_REQUEST['target_c_commu_id'] = $c_commu_id;
         openpne_forward('pc', 'page', "c_member_review_add");
         exit;
     }
     $c_member_review = db_review_c_member_review_add_confirm_c_member_review4c_review_id($c_review_id, $u);
     if (!$c_member_review) {
         handle_kengen_error();
     }
     $this->set('c_member_review', $c_member_review);
     $this->set('c_commu', db_commu_c_commu4c_commu_id($c_commu_id));
     $this->set('c_review_id', $c_review_id);
     $this->set('inc_navi', fetch_inc_navi('c', $c_commu_id));
     return 'success';
 }

 function execute($requests)
 {
     $u = $GLOBALS['AUTH']->uid();
     // --- リクエスト変数
     $target_c_commu_id = $requests['target_c_commu_id'];
     $body = $requests['body'];
     // ----------
     //--- 権限チェック
     //コミュニティメンバーでない or 参加承認中でない
     $status = db_common_commu_status($u, $target_c_commu_id);
     if ($status['is_commu_member'] || $status['is_commu_member_confirm']) {
         handle_kengen_error();
     }
     //---
     $c_member_id_from = $u;
     db_commu_insert_c_commu_member_confirm($target_c_commu_id, $c_member_id_from, $body);
     //メッセージ
     $c_commu = db_commu_c_commu4c_commu_id($target_c_commu_id);
     list($subject, $body_disp) = create_message_commu_join_request($c_member_id_from, $body, $target_c_commu_id);
     db_message_send_message_syoudaku($c_member_id_from, $c_commu['c_member_id_admin'], $subject, $body_disp);
     if ($c_commu['c_member_id_sub_admin']) {
         db_message_send_message_syoudaku($c_member_id_from, $c_commu['c_member_id_sub_admin'], $subject, $body_disp);
     }
     $p = array('target_c_commu_id' => $target_c_commu_id);
     openpne_redirect('pc', 'page_c_home', $p);
 }

 function execute($requests)
 {
     $u = $GLOBALS['KTAI_C_MEMBER_ID'];
     // --- リクエスト変数
     $c_commu_id = $requests['target_c_commu_id'];
     $title = $requests['title'];
     $body = $requests['body'];
     $event_flag = $requests['event_flag'];
     $err_msg = $requests['err_msg'];
     // ----------
     //--- 権限チェック
     $c_commu = db_commu_c_commu4c_commu_id2($c_commu_id);
     switch ($c_commu['is_topic']) {
         case 'public':
             //誰でも作成可能
             break;
         case 'member':
             //コミュニティメンバー
             if (!db_commu_is_c_commu_member($c_commu_id, $u)) {
                 handle_kengen_error();
             }
             break;
         case 'admin_only':
             //トピック作成権限チェック
             if (!db_commu_is_c_commu_admin($c_commu_id, $u)) {
                 handle_kengen_error();
             }
             break;
     }
     // ---
     $this->set('c_commu', db_commu_c_commu4c_commu_id($c_commu_id));
     return 'success';
 }

 function execute($requests)
 {
     $v = array();
     $target_c_commu_ids = $requests['target_c_commu_ids'];
     $target_c_commu_id = $requests['target_c_commu_id'];
     if (!empty($target_c_commu_id)) {
         $target_c_commu_ids[] = $target_c_commu_id;
     }
     if (empty($target_c_commu_ids)) {
         admin_client_redirect('list_c_commu', WORD_COMMUNITY . 'が選択されていません');
     }
     $i = 0;
     foreach ($target_c_commu_ids as $target_c_commu_id) {
         $c_commu_list[$i] = db_commu_c_commu4c_commu_id($target_c_commu_id);
         if (!$c_commu_list[$i]) {
             admin_client_redirect('list_c_commu', '指定された' . WORD_COMMUNITY . 'は存在しません');
         }
         $c_commu_list[$i]['c_member'] = db_member_c_member4c_member_id($c_commu_list[$i]['c_member_id_admin']);
         $i++;
     }
     $this->set('c_commu_list', $c_commu_list);
     $v['SNS_NAME'] = SNS_NAME;
     $v['OPENPNE_VERSION'] = OPENPNE_VERSION;
     $this->set($v);
     return 'success';
 }

 function execute($requests)
 {
     $u = $GLOBALS['AUTH']->uid();
     if (!OPENPNE_USE_RANKING) {
         openpne_forward('pc', 'page', 'h_err_ranking');
         exit;
     }
     // --- リクエスト変数
     $kind = $requests['kind'];
     // ----------
     $this->set('inc_navi', fetch_inc_navi('h'));
     $this->set('kind', $kind);
     $limit = 10;
     switch ($kind) {
         case "friend":
             $list = pne_cache_call(3600, 'db_ranking_c_friend_ranking', $limit);
             foreach ($list as $key => $value) {
                 $list[$key]['c_member'] = db_member_c_member_with_profile($value['c_member_id']);
             }
             break;
         case "com_member":
             $list = pne_cache_call(3600, 'db_ranking_c_commu_member_ranking', $limit);
             foreach ($list as $key => $value) {
                 $list[$key]['c_commu'] = db_commu_c_commu4c_commu_id($value['c_commu_id']);
             }
             break;
         case "com_comment":
             $list = pne_cache_call(3600, 'db_ranking_c_commu_topic_comment_ranking', $limit);
             foreach ($list as $key => $value) {
                 $list[$key]['c_commu'] = db_commu_c_commu4c_commu_id($value['c_commu_id']);
             }
             break;
         case "ashiato":
         default:
             $list = pne_cache_call(3600, 'db_ranking_c_ashiato_ranking', $limit);
             foreach ($list as $key => $value) {
                 $list[$key]['c_member'] = db_member_c_member_with_profile($value['c_member_id']);
                 if (!$list[$key]['c_member']) {
                     unset($list[$key]);
                 }
             }
             break;
     }
     $rank_list = array();
     if ($list) {
         $rank = 1;
         $current_count = null;
         foreach ($list as $item) {
             if ($item['count'] != $current_count) {
                 $rank = $rank + count($rank_list[$rank]);
                 $current_count = $item['count'];
             }
             $rank_list[$rank][] = $item;
         }
     }
     $this->set("rank_list", $rank_list);
     return 'success';
 }

 function execute($requests)
 {
     $u = $GLOBALS['KTAI_C_MEMBER_ID'];
     if (!OPENPNE_USE_RANKING) {
         ktai_display_error(SNS_NAME . 'では、ランキングの閲覧はおこなえません');
     }
     // --- リクエスト変数
     $kind = $requests['kind'];
     // ----------
     $this->set('kind', $kind);
     $limit = 10;
     switch ($kind) {
         case "friend":
             $list = pne_cache_call(3600, 'db_ranking_c_friend_ranking', $limit);
             foreach ($list as $key => $value) {
                 $list[$key]['c_member'] = db_member_c_member_with_profile($value['c_member_id']);
             }
             break;
         case "com_member":
             $list = pne_cache_call(3600, 'db_ranking_c_commu_member_ranking', $limit);
             foreach ($list as $key => $value) {
                 $list[$key]['c_commu'] = db_commu_c_commu4c_commu_id($value['c_commu_id']);
             }
             break;
         case "com_comment":
             $list = pne_cache_call(3600, 'db_ranking_c_commu_topic_comment_ranking', $limit);
             foreach ($list as $key => $value) {
                 $list[$key]['c_commu'] = db_commu_c_commu4c_commu_id($value['c_commu_id']);
             }
             break;
         case "ashiato":
         default:
             $list = pne_cache_call(3600, 'db_ranking_c_ashiato_ranking', $limit);
             foreach ($list as $key => $value) {
                 $list[$key]['c_member'] = db_member_c_member_with_profile($value['c_member_id']);
                 if (!$list[$key]['c_member']) {
                     unset($list[$key]);
                 }
             }
             break;
     }
     $rank_list = array();
     if ($list) {
         $rank = 1;
         $current_count = null;
         foreach ($list as $item) {
             if ($item['count'] != $current_count) {
                 $rank = $rank + count($rank_list[$rank]);
                 $current_count = $item['count'];
             }
             $rank_list[$rank][] = $item;
         }
     }
     $this->set("rank_list", $rank_list);
     return 'success';
 }

 function execute($requests)
 {
     $c_commu_list = array();
     $list = db_commu_regist_join_list();
     foreach ($list as $c_commu_id) {
         $c_commu_list[] = db_commu_c_commu4c_commu_id($c_commu_id);
     }
     $this->set('c_commu_list', $c_commu_list);
     return 'success';
 }