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';
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$target_c_commu_id = $requests['target_c_commu_id'];
// ----------
$this->set('inc_navi', fetch_inc_navi("c", $target_c_commu_id));
$this->set('c_commu', db_commu_c_commu4c_commu_id($target_c_commu_id));
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$target_c_commu_id = $requests['target_c_commu_id'];
$name = $requests['name'];
$c_commu_category_id = $requests['c_commu_category_id'];
$info = $requests['info'];
$is_admit = $requests['is_admit'];
$is_open = $requests['is_open'];
$is_topic = $requests['is_topic'];
$is_comment = $requests['is_comment'];
$err_msg = $requests['err_msg'];
// ----------
//--- 権限チェック
//コミュニティ管理者
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));
//コミュニティデータ取得
$c_commu = db_commu_c_commu4c_commu_id($target_c_commu_id);
$c_commu_category_id_now = $c_commu['c_commu_category_id'];
if ($name) {
$c_commu['name'] = $name;
}
if ($c_commu_category_id) {
$c_commu['c_commu_category_id'] = $c_commu_category_id;
}
if ($info) {
$c_commu['info'] = $info;
}
if ($public_flag) {
$c_commu['public_flag'] = $public_flag;
}
$this->set('target_c_commu_id', $target_c_commu_id);
if ($err_msg) {
$c_commu['name'] = $name;
$c_commu['info'] = $info;
}
$this->set('c_commu', $c_commu);
// カテゴリリスト
$c_commu_category_list = db_commu_c_commu_category4is_create_commu();
// 現在設定されているカテゴリが作成不可ならば、別途取得
if (!db_commu_c_commu_category_is_create_commu($c_commu_category_id_now)) {
array_push($c_commu_category_list, db_commu_get_c_commu_category4id($c_commu_category_id_now));
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('err_msg', $err_msg);
$this->set('is_unused_join_commu', util_is_unused_mail('m_pc_join_commu'));
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'];
$name = $requests['name'];
$c_commu_category_id = $requests['c_commu_category_id'];
$info = $requests['info'];
$is_admit = $requests['is_admit'];
$is_open = $requests['is_open'];
$is_topic = $requests['is_topic'];
$is_comment = $requests['is_comment'];
if (db_commu_is_changed_c_commu_name($target_c_commu_id, $name) && db_commu_is_commu4c_commu_name($name)) {
$p = array('target_c_commu_id' => $target_c_commu_id, 'msg' => 49);
openpne_redirect('ktai', 'page_c_edit', $p);
}
$c_commu = db_commu_c_commu4c_commu_id($target_c_commu_id);
if ($c_commu_category_id != $c_commu['c_commu_category_id'] && !db_commu_c_commu_category_is_create_commu($c_commu_category_id)) {
$p = array('target_c_commu_id' => $target_c_commu_id, 'msg' => 50);
openpne_redirect('ktai', 'page_c_edit', $p);
}
if ($is_open == 'member') {
if ($is_topic == 'public') {
$p = array('target_c_commu_id' => $target_c_commu_id, 'msg' => 53);
openpne_redirect('ktai', 'page_c_edit', $p);
}
if ($is_comment == 'public') {
$p = array('target_c_commu_id' => $target_c_commu_id, 'msg' => 54);
openpne_redirect('ktai', 'page_c_edit', $p);
}
}
// ----------
//--- 権限チェック
//コミュニティ管理者
$status = db_common_commu_status($u, $target_c_commu_id);
if (!$status['is_commu_admin']) {
handle_kengen_error();
}
//---
// 承認待ちメンバー登録処理
$c_commu = db_commu_c_commu4c_commu_id($target_c_commu_id);
if ($is_admit == 'public' && $is_admit != $c_commu['is_admit']) {
$c_commu_member_confirm_list = db_commu_c_commu_member_confirm4c_commu_id($target_c_commu_id);
foreach ($c_commu_member_confirm_list as $c_commu_member_confirm) {
db_commu_join_c_commu($target_c_commu_id, $c_commu_member_confirm['c_member_id']);
do_inc_join_c_commu_send_mail($target_c_commu_id, $c_commu_member_confirm['c_member_id']);
db_commu_delete_c_commu_member_confirm($c_commu_member_confirm['c_commu_member_confirm_id']);
}
}
db_commu_update_c_commu($target_c_commu_id, $name, $is_topic, $is_comment, $c_commu_category_id, $info, $is_admit, $is_open);
$p = array('target_c_commu_id' => $target_c_commu_id);
openpne_redirect('ktai', 'page_c_home', $p);
}
function execute($requests)
{
$u = $GLOBALS['KTAI_C_MEMBER_ID'];
// --- リクエスト変数
$target_c_commu_id = $requests['target_c_commu_id'];
// ----------
//ランダムフレンドリスト
$this->set("c_friend_list", db_commu_c_friend_list_random4c_member_id4c_commu_id($u, $target_c_commu_id, 50));
//コミュニティID
$this->set("target_c_commu_id", $target_c_commu_id);
$this->set("c_commu", db_commu_c_commu4c_commu_id($target_c_commu_id));
return 'success';
}
function execute($requests)
{
$id_ary = split(":", $requests['target_c_commu_ids']);
foreach ($id_ary as $id) {
$commu = db_commu_c_commu4c_commu_id($id);
if (!$commu) {
admin_client_redirect('list_c_commu', '指定された' . WORD_COMMUNITY . 'は存在しません');
}
}
foreach ($id_ary as $id) {
db_common_delete_c_commu($id);
}
admin_client_redirect('list_c_commu', WORD_COMMUNITY . 'を削除しました');
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$target_c_commu_id = $requests['target_c_commu_id'];
// ----------
$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);
//community情報
$this->set("c_commu", db_commu_c_commu4c_commu_id($target_c_commu_id));
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['KTAI_C_MEMBER_ID'];
// --- リクエスト変数
$target_c_commu_id = $requests['target_c_commu_id'];
$target_c_member_id = $requests['target_c_member_id'];
$body = $requests['body'];
// ----------
//--- 権限チェック
// コミュニティ管理者
// コミュニティ副管理者ではない
// 自分自身へのメッセージ送信ではない
// すでに管理者交代依頼メッセージ送信済みではない
// すでに副管理者要請メッセージを送信済みでない
if (!db_commu_is_c_commu_admin($target_c_commu_id, $u)) {
handle_kengen_error();
}
if (db_commu_is_c_commu_sub_admin($target_c_commu_id, $u)) {
handle_kengen_error();
}
if ($u == $target_c_member_id) {
handle_kengen_error();
}
$target_c_commu_admin_confirm_list = db_commu_anatani_c_commu_admin_confirm_list4c_member_id($target_c_member_id);
if (!empty($target_c_commu_admin_confirm_list)) {
foreach ($target_c_commu_admin_confirm_list as $value) {
if ($value['c_commu_id'] == $target_c_commu_id) {
handle_kengen_error();
}
}
}
$target_c_commu_sub_admin_confirm_list = db_commu_anatani_c_commu_sub_admin_confirm_list4c_member_id($target_c_member_id);
if (!empty($target_c_commu_sub_admin_confirm_list)) {
foreach ($target_c_commu_sub_admin_confirm_list as $value) {
if ($value['c_commu_id'] == $target_c_commu_id) {
handle_kengen_error();
}
}
}
//---
$this->set('inc_navi', fetch_inc_navi("c", $target_c_commu_id));
$member = db_member_c_member_with_profile($target_c_member_id);
$member['last_login'] = p_f_home_last_login4access_date($member['access_date']);
$this->set("member", $member);
$this->set("c_commu", db_commu_c_commu4c_commu_id($target_c_commu_id));
$this->set('body', $body);
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['KTAI_C_MEMBER_ID'];
// --- リクエスト変数
$target_c_commu_id = $requests['target_c_commu_id'];
$page = $requests['page'];
// ----------
$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) {
ktai_display_error('閲覧権限がありません');
}
//---
$page_size = 5;
//ページ
$this->set("page", $page);
//メンバーリスト
$list = db_commu_c_member_list4c_commu_id($target_c_commu_id, $page_size, $page);
$total_num = $list[3];
$c_member_list = $list[0];
// 管理者交代メッセージ送信先メンバーリスト
foreach ($c_member_list as $key => $c_member) {
if ($c_member['c_member_id'] != $c_commu['c_member_id_admin'] && $c_member['c_commu_admin_confirm_id'] <= 0 && $c_member['c_commu_sub_admin_confirm_id'] <= 0) {
$c_member_list[$key]['is_display_admin'] = true;
} else {
$c_member_list[$key]['is_display_admin'] = false;
}
}
// 副管理者要請メッセージ送信先メンバーリスト
foreach ($c_member_list as $key => $c_member) {
if ($c_member['c_member_id'] != $c_commu['c_member_id_admin'] && $c_member['c_member_id'] != $c_commu['c_member_id_sub_admin'] && $c_member['c_commu_admin_confirm_id'] <= 0 && $c_member['c_commu_sub_admin_confirm_id'] <= 0) {
$c_member_list[$key]['is_display_sub_admin'] = true;
} else {
$c_member_list[$key]['is_display_sub_admin'] = false;
}
}
$this->set("c_member_list", $c_member_list);
$this->set("is_prev", $list[1]);
$this->set("is_next", $list[2]);
$pager = array();
$pager['start'] = $page_size * ($page - 1) + 1;
$pager['end'] = $pager['start'] + count($c_member_list) - 1;
$this->set('pager', $pager);
//コミュニティのメンバー数
$this->set("count_member", db_commu_count_c_commu_member_list4c_commu_id($target_c_commu_id));
$this->set("c_commu", $c_commu);
return 'success';
}
function _getRanking($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;
}
}
return $rank_list;
}
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) {
openpne_redirect('ktai', 'page_h_home');
}
//--- 権限チェック
//未処理
//掲示板の閲覧権限チェック tplでやっている
$this->set("is_c_commu_view", db_commu_is_c_commu_view4c_commu_idAc_member_id($target_c_commu_id, $u));
$this->set("is_c_commu_member", db_commu_is_c_commu_member($target_c_commu_id, $u));
$this->set('is_c_commu_admin', db_commu_is_c_commu_admin($target_c_commu_id, $u));
//---
//管理画面HTML
$this->set('c_siteadmin', p_common_c_siteadmin4target_pagename('k_c_home'));
//コミュニティ情報
$this->set("c_commu", db_commu_c_commu4c_commu_id_k($target_c_commu_id));
// 副管理者情報
if ($c_commu['c_member_id_sub_admin']) {
$c_member_sub_admin = db_member_c_member4c_member_id($c_commu['c_member_id_sub_admin']);
$this->set('sub_admin', $c_member_sub_admin);
}
//コミュニティメンバーリスト
$this->set("c_commu_member_list", db_commu_c_commu_member_list_random4c_commu_id($target_c_commu_id, 5));
//参加コミュニティの新着トピック書き込み
$this->set("new_topic_comment", db_commu_new_topic_comment4c_commu_id($target_c_commu_id, 5));
//参加コミュニティの新着イベント書き込み
$this->set("new_topic_comment_event", db_commu_new_topic_comment4c_commu_id($target_c_commu_id, 5, 1));
//自分($u)とこのコミュとの関係
$this->set("relation_c_member_and_c_commu", db_commu_relationship_between_member_commu($target_c_commu_id, $u));
//コミュニティメール(ktai)受信設定
$this->set("is_receive_mail", db_commu_is_receive_mail_ktai($target_c_commu_id, $u));
//コミュニティメール(pc)受信設定
$this->set("is_receive_mail_pc", db_commu_is_receive_mail_pc($target_c_commu_id, $u));
//管理者からのメッセージ受信設定
$this->set("is_receive_message", db_commu_is_receive_message($target_c_commu_id, $u));
$this->set('is_unused_pc_bbs', util_is_unused_mail('m_pc_bbs_info'));
$this->set('is_unused_ktai_bbs', util_is_unused_mail('m_ktai_bbs_info'));
// inc_entry_point
$this->set('inc_ktai_entry_point', fetch_inc_entry_point($this->getView(), 'ktai_c_home'));
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) {
openpne_redirect('ktai', 'page_h_home');
}
//コミュニティ情報
$this->set("c_commu", db_commu_c_commu4c_commu_id_k($target_c_commu_id));
// 副管理者情報
$c_member_sub_admin = db_member_c_member4c_member_id($c_commu['c_member_id_sub_admin']);
$this->set('sub_admin', $c_member_sub_admin);
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);
//--- 権限チェック
$status = db_common_commu_status($u, $target_c_commu_id);
if (!$status['is_commu_admin'] && !$status['is_commu_sub_admin']) {
handle_kengen_error();
}
//---
if (empty($c_commu['image_filename'])) {
handle_kengen_error();
}
$this->set('c_commu', $c_commu);
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$target_c_commu_id = $requests['target_c_commu_id'];
// ----------
//--- 権限チェック
//コミュニティ管理者
$status = db_common_commu_status($u, $target_c_commu_id);
if (!$status['is_commu_admin']) {
handle_kengen_error();
}
//---
$c_commu = db_commu_c_commu4c_commu_id($target_c_commu_id);
db_image_data_delete($c_commu['image_filename'], $u);
db_commu_delete_c_commu_image_filename($target_c_commu_id);
$p = array('target_c_commu_id' => $target_c_commu_id);
openpne_redirect('pc', 'page_c_edit', $p);
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$target_c_commu_id = $requests['target_c_commu_id'];
// ----------
$is_admin = db_commu_is_c_commu_admin($target_c_commu_id, $u);
$is_member = db_commu_is_c_commu_member($target_c_commu_id, $u);
if ($is_admin) {
$p = array('target_c_commu_id' => $target_c_commu_id);
openpne_redirect('pc', 'page_c_taikai_err_admin', $p);
}
if (!$is_member) {
$p = array('target_c_commu_id' => $target_c_commu_id);
openpne_redirect('pc', 'page_c_taikai_err_no_member', $p);
}
$this->set('inc_navi', fetch_inc_navi("c", $target_c_commu_id));
$this->set('c_commu', db_commu_c_commu4c_commu_id($target_c_commu_id));
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$keyword = $requests['keyword'];
$page = $requests['page'];
$type = $requests['type'];
$c_commu_id = $requests['c_commu_id'];
$target_commu = $requests['target_commu'];
// ----------
if ($target_commu == 'all') {
openpne_forward('ktai', 'page', 'h_com_topic_find_all');
exit;
}
//--- 権限チェック
//掲示板閲覧権限
if (!db_commu_is_c_commu_view4c_commu_idAc_member_id($c_commu_id, $u)) {
handle_kengen_error();
}
//バグ回避のため全角空白を半角空白に統一
$keyword = str_replace(" ", " ", $keyword);
do_common_insert_search_log($u, $keyword);
$page_size = 20;
$this->set('page', $page);
//検索結果
list($result, $is_prev, $is_next, $total_num, $start_num, $end_num) = db_commu_search_c_commu_topic($keyword, $page_size, $page, $type, $c_commu_id);
$this->set('c_commu_topic_search_list', $result);
$this->set('is_prev', $is_prev);
$this->set('is_next', $is_next);
$this->set('total_num', $total_num);
$this->set('start_num', $start_num);
$this->set('end_num', $end_num);
$this->set('keyword', $keyword);
$search_val_list = array('type' => $type);
$this->set('search_val_list', $search_val_list);
$this->set('c_commu_id', $c_commu_id);
if ($c_commu_id) {
$this->set('c_commu', db_commu_c_commu4c_commu_id($c_commu_id));
}
return 'success';
}
