function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
$target_c_commu_topic_comment_id = $requests['target_c_commu_topic_comment_id'];
//--- 権限チェック
//コミュニティ管理者 or コミュニティ参加者
$c_commu_topic_comment = db_commu_c_commu_topic_comment4c_commu_topic_comment_id_2($target_c_commu_topic_comment_id);
$c_commu_topic = db_commu_c_commu_topic4c_commu_topic_id($c_commu_topic_comment['c_commu_topic_id']);
$c_commu_id = $c_commu_topic['c_commu_id'];
$status = db_common_commu_status($u, $c_commu_id);
if ($c_commu_topic_comment['number'] == "0") {
handle_kengen_error();
}
if (!$status['is_commu_admin'] && $c_commu_topic_comment['c_member_id'] != $u) {
handle_kengen_error();
}
//---
db_commu_delete_c_commu_topic_comment($target_c_commu_topic_comment_id);
if ($c_commu_topic['event_flag']) {
$action = 'page_c_event_detail';
} else {
$action = 'page_c_topic_detail';
}
$p = array('target_c_commu_topic_id' => $c_commu_topic_comment['c_commu_topic_id']);
openpne_redirect('pc', $action, $p);
}
function execute($requests)
{
$v = array();
$pager = array();
$v['SNS_NAME'] = SNS_NAME;
$c_image_list = db_image_c_image_list($requests['page'], $requests['page_size'], $pager);
//ファイル名からリンク先を生成
foreach ($c_image_list as $key => $c_image) {
$temp = explode("_", $c_image['filename']);
//
switch ($temp[0]) {
case 'm':
//メンバー画像
$c_image_list[$key]['param'] = '&a=page_f_home&target_c_member_id=' . $temp[1];
break;
case 'c':
//コミュニティ画像
$c_image_list[$key]['param'] = '&a=page_c_home&target_c_commu_id=' . $temp[1];
break;
case 'd':
//日記画像
$c_image_list[$key]['param'] = '&a=page_fh_diary&target_c_diary_id=' . $temp[1];
break;
case 'dc':
//日記コメント画像
$id = _do_c_diary_comment4c_diary_comment_id($temp[1]);
$c_image_list[$key]['param'] = '&a=page_fh_diary&target_c_diary_id=' . $id['c_diary_id'];
break;
case 't':
//トピック、イベント画像
$c_image_list[$key]['param'] = '&a=page_c_topic_detail&target_c_commu_topic_id=' . $temp[1];
break;
case 'tc':
//トピック、イベントコメント画像
$id = db_commu_c_commu_topic_comment4c_commu_topic_comment_id_2($temp[1]);
$c_image_list[$key]['param'] = '&a=page_c_topic_detail&target_c_commu_topic_id=' . $id['c_commu_topic_id'];
break;
}
}
$v['c_image_list'] = $c_image_list;
$v['pager'] = $pager;
$this->set($v);
return 'success';
}
function execute($requests)
{
$tail = $GLOBALS['KTAI_URL_TAIL'];
$u = $GLOBALS['KTAI_C_MEMBER_ID'];
// --- リクエスト変数
$target_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_2($target_c_commu_topic_comment_id);
//--- 権限チェック
//コミュニティ管理者 or コメント作成者
$c_commu_topic = db_commu_c_commu_topic4c_commu_topic_id($c_commu_topic_comment['c_commu_topic_id']);
$c_commu_id = $c_commu_topic['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();
}
//---
db_commu_delete_c_commu_topic_comment($target_c_commu_topic_comment_id);
$p = array('target_c_commu_topic_id' => $c_commu_topic_comment['c_commu_topic_id']);
openpne_redirect('ktai', 'page_c_bbs', $p);
}
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';
}
function do_c_bbs_c_commu_topic_comment4c_commu_topic_comment_id($c_commu_topic_comment_id)
{
return db_commu_c_commu_topic_comment4c_commu_topic_comment_id_2($c_commu_topic_comment_id);
}
/**
* 画像リスト取得
*/
function kanshi_get_image_list($updated_from, $updated_to, $offset, $limit)
{
$sql = " SELECT\n c_image_id as data_id,\n filename as title,\n r_datetime\n ";
$sql .= " FROM c_image";
$sql .= " WHERE 1";
$params = array();
if (!empty($updated_from)) {
$sql .= " AND r_datetime > ?";
$params[] = $updated_from;
}
if (!empty($updated_to)) {
$sql .= " AND r_datetime < ?";
$params[] = $updated_to;
}
$sql .= " ORDER BY r_datetime";
if (!empty($offset) || !empty($limit)) {
if (empty($offset)) {
$offset = 0;
}
if (empty($limit)) {
$limit = count(db_get_col($sql, $params)) - $offset;
}
$c_image_list = db_get_all_limit($sql, $offset, $limit, $params);
} else {
$c_image_list = db_get_all($sql, $params);
}
if (count($c_image_list) > 0) {
foreach ($c_image_list as $num => $c_image) {
$c_image_list[$num]['image_url'] = OPENPNE_URL . 'img.php?filename=' . $c_image['title'];
$temp = explode("_", $c_image['title']);
switch ($temp[0]) {
case 'm':
//メンバー画像
$c_image_list[$num]['creator'] = $temp[1];
$c_image_list[$num]['c_member'] = db_member_c_member4c_member_id($temp[1], true, true, 'private');
$c_image_list[$num]['refer_data_url'] = OPENPNE_URL . '&a=page_f_home&target_c_member_id=' . $temp[1];
break;
case 'c':
//コミュニティ画像
$id = db_commu_c_commu4c_commu_id($temp[1]);
$c_image_list[$num]['creator'] = $id['c_member_id_admin'];
$c_image_list[$num]['c_member'] = db_member_c_member4c_member_id($id['c_member_id_admin'], true, true, 'private');
$c_image_list[$num]['refer_watch_type_id'] = 3;
$c_image_list[$num]['refer_data_id'] = $temp[1];
$c_image_list[$num]['refer_data_url'] = OPENPNE_URL . '&a=page_c_home&target_c_commu_id=' . $temp[1];
break;
case 'd':
//日記画像
$id = db_diary_get_c_diary4id($temp[1]);
$c_image_list[$num]['creator'] = $id['c_member_id'];
$c_image_list[$num]['c_member'] = db_member_c_member4c_member_id($id['c_member_id'], true, true, 'private');
$c_image_list[$num]['refer_watch_type_id'] = 1;
$c_image_list[$num]['refer_data_id'] = $temp[1];
$c_image_list[$num]['refer_data_url'] = OPENPNE_URL . '&a=page_fh_diary&target_c_diary_id=' . $temp[1];
break;
case 'dc':
//日記コメント画像
$id = _do_c_diary_comment4c_diary_comment_id($temp[1]);
$c_image_list[$num]['creator'] = $id['c_member_id'];
$c_image_list[$num]['c_member'] = db_member_c_member4c_member_id($id['c_member_id'], true, true, 'private');
$c_image_list[$num]['refer_watch_type_id'] = 4;
$c_image_list[$num]['refer_data_id'] = $temp[1];
$c_image_list[$num]['refer_data_url'] = OPENPNE_URL . '&a=page_fh_diary&target_c_diary_id=' . $id['c_diary_id'];
break;
case 't':
//トピック、イベント画像
$id = db_commu_c_topic4c_commu_topic_id($temp[1]);
$c_image_list[$num]['creator'] = $id['c_member_id'];
$c_image_list[$num]['c_member'] = db_member_c_member4c_member_id($id['c_member_id'], true, true, 'private');
$c_image_list[$num]['refer_watch_type_id'] = 2;
$c_image_list[$num]['refer_data_id'] = $temp[1];
$c_image_list[$num]['refer_data_url'] = OPENPNE_URL . '&a=page_c_topic_detail&target_c_commu_topic_id=' . $temp[1];
break;
case 'tc':
//トピック、イベントコメント画像
$id = db_commu_c_commu_topic_comment4c_commu_topic_comment_id_2($temp[1]);
$c_image_list[$num]['creator'] = $id['c_member_id'];
$c_image_list[$num]['c_member'] = db_member_c_member4c_member_id($id['c_member_id'], true, true, 'private');
$c_image_list[$num]['refer_watch_type_id'] = 5;
$c_image_list[$num]['refer_data_id'] = $temp[1];
$c_image_list[$num]['param'] = '&a=page_c_topic_detail&target_c_commu_topic_id=' . $id['c_commu_topic_id'];
break;
}
}
}
return $c_image_list;
}
