function db_review_c_friend_review_list_more4c_member_id($c_member_id, $page, $page_size)
{
$friends = db_friend_c_member_id_list($c_member_id, true);
if (!$friends) {
return array();
}
$ids = implode(',', array_map('intval', $friends));
$sql = 'SELECT * FROM c_review INNER JOIN c_review_comment USING (c_review_id)' . ' WHERE c_review_comment.c_member_id IN (' . $ids . ')' . ' ORDER BY c_review_comment.r_datetime DESC';
$list = db_get_all_page($sql, $page, $page_size, $params);
foreach ($list as $key => $value) {
$list[$key] += db_member_c_member4c_member_id_LIGHT($value['c_member_id']);
}
$sql = 'SELECT COUNT(*) FROM c_review_comment 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;
}
}
$start_num = ($page - 1) * $page_size + 1;
$end_num = ($page - 1) * $page_size + $page_size > $total_num ? $total_num : ($page - 1) * $page_size + $page_size;
return array($list, $prev, $next, $total_num, $start_num, $end_num);
}
function execute($requests)
{
$u = $GLOBALS['KTAI_C_MEMBER_ID'];
// --- リクエスト変数
$target_c_member_id = $requests['target_c_member_id'];
$page = $requests['page'];
// ----------
if (!$target_c_member_id) {
$target_c_member_id = $u;
}
if (db_member_is_access_block($u, $target_c_member_id)) {
openpne_redirect('ktai', 'page_h_access_block');
}
//ターゲット情報
$this->set("target_c_member", db_member_c_member4c_member_id_LIGHT($target_c_member_id));
// 1ページ当たりに表示するフレンドの数
$page_size = 10;
//ターゲットの詳細な友達リスト
$list = db_friend_friend_list4c_member_id($target_c_member_id, $page_size, $page);
$total_num = db_friend_count_friends($target_c_member_id);
$this->set("target_friend_list", $list[0]);
$this->set("page", $page);
$this->set("is_prev", $list[1]);
$this->set("is_next", $list[2]);
$this->set('total_num', $total_num);
$pager = array();
$pager['start'] = $page_size * ($page - 1) + 1;
$pager['end'] = $pager['start'] + count($list[0]) - 1;
$this->set('pager', $pager);
$this->set("INC_NAVI_type", k_p_fh_common_get_type($target_c_member_id, $u));
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['KTAI_C_MEMBER_ID'];
// --- リクエスト変数
$target_c_member_id = $requests['target_c_member_id'];
$page = $requests['page'];
// ----------
if (db_member_is_access_block($u, $target_c_member_id)) {
openpne_redirect('ktai', 'page_h_access_block');
}
// メンバー情報
$this->set("target_c_member", db_member_c_member4c_member_id_LIGHT($target_c_member_id));
// 参加コミュニティリスト
$page_size = 10;
list($list, $pager) = db_common_commu_common_commu_list4c_member_id($target_c_member_id, $u, $page, $page_size);
$this->set("common_commu_list", $list);
$this->set("page", $page);
$this->set("is_prev", $pager[prev_page]);
$this->set("is_next", $pager[next_page]);
$this->set('start_num', $pager['start_num']);
$this->set('end_num', $pager['end_num']);
// 共通コミュニティ数
$this->set("common_commu_count", $pager[total_num]);
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['KTAI_C_MEMBER_ID'];
// --- リクエスト変数
$target_c_member_id = $requests['target_c_member_id'];
$page = $requests['page'];
// ----------
if (!$target_c_member_id) {
$target_c_member_id = $u;
}
if (db_member_is_access_block($u, $target_c_member_id)) {
openpne_redirect('ktai', 'page_h_access_block');
}
// メンバー情報
$this->set("target_c_member", db_member_c_member4c_member_id_LIGHT($target_c_member_id));
// 参加コミュニティリスト
$page_size = 10;
$list = db_commu_c_commu_list4c_member_id_4($target_c_member_id, $page_size, $page);
$this->set("c_commu_list", $list[0]);
$this->set("page", $page);
$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($list[0]) - 1;
$this->set('pager', $pager);
// 参加コミュニティ数
$this->set("count_commus", $list[3]);
//f or h
$this->set("INC_NAVI_type", k_p_fh_common_get_type($target_c_member_id, $u));
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$target_c_album_id = $requests['target_c_album_id'];
// ----------
if (!p_common_is_active_c_album_id($target_c_album_id)) {
util_send_header_internal_server_error();
}
//--- 権限チェック
$c_album = db_album_get_c_album4c_album_id($target_c_album_id);
$target_c_member_id = $c_album['c_member_id'];
$c_album['c_member'] = db_member_c_member4c_member_id_LIGHT($target_c_member_id);
$c_album['album_cover_image'] = util_get_img_url($c_album['album_cover_image'], 180, 180);
$c_album['word_my_friend'] = WORD_MY_FRIEND;
if ($u != $target_c_member_id) {
// メンバーが存在しない
if (!$c_album['c_member']) {
util_send_header_internal_server_error();
}
// check public_flag
if (!pne_check_album_public_flag($target_c_album_id, $u)) {
util_send_header_internal_server_error();
}
// アクセスブロック設定
if (db_member_is_access_block($u, $target_c_member_id)) {
util_send_header_internal_server_error();
}
}
//---
util_output_xml4array($c_album, 'c_album');
}
function db_rss_list_friend_c_rss_cache_list($c_member_id, $limit)
{
static $is_recurred = false;
//再帰処理中かどうかの判定フラグ
if (!$is_recurred) {
//function cacheのために再帰処理を行う
$is_recurred = true;
$funcargs = func_get_args();
$result = pne_cache_recursive_call(OPENPNE_FUNCTION_CACHE_LIFETIME_FAST, __FUNCTION__, $funcargs);
$is_recurred = false;
return $result;
}
$friends = db_friend_c_member_id_list($c_member_id, true);
if (!$friends) {
return array();
}
$ids = implode(',', array_map('intval', $friends));
$hint = db_mysql_hint('USE INDEX (c_member_id_r_datetime)');
$sql = 'SELECT * FROM c_rss_cache' . $hint . ' WHERE c_member_id IN (' . $ids . ')' . ' ORDER BY r_datetime DESC';
$list = db_get_all_limit($sql, 0, $limit);
foreach ($list as $key => $value) {
$list[$key]['c_member'] = db_member_c_member4c_member_id_LIGHT($value['c_member_id']);
}
return $list;
}
/**
* 認証API
*/
function xmlrpc_000_auth($message)
{
$param = $message->getParam(0);
if (!XML_RPC_Value::isValue($param)) {
return false;
}
$params = XML_RPC_decode($param);
if (empty($params['sid'])) {
return false;
}
if (empty($params['mid'])) {
return false;
}
if (empty($params['dt'])) {
return false;
}
$c_member_id = $params['mid'];
$datetime = $params['dt'];
if (!db_member_c_member4c_member_id_LIGHT($c_member_id)) {
return xmlrpc_get_fault_response(56);
}
if (!($member_token = db_api_get_member_token($c_member_id))) {
return xmlrpc_get_fault_response(52);
}
$session_id = api_get_sid($c_member_id, $member_token, $datetime);
if ($params['sid'] != $session_id) {
return xmlrpc_get_fault_response(52);
}
return xmlrpc_get_response($c_member_id);
}
function execute($requests)
{
$v = array();
$v['SNS_NAME'] = SNS_NAME;
$v['c_member'] = db_member_c_member4c_member_id_LIGHT($requests['target_c_member_id']);
$this->set($v);
return 'success';
}
function _getNewMemberList()
{
$sql = 'SELECT * FROM c_member WHERE c_member_id <> 1 ORDER BY c_member_id DESC';
$list = db_get_all_limit($sql, 0, 5);
foreach ($list as $key => $value) {
$list[$key]['c_member_invite'] = db_member_c_member4c_member_id_LIGHT($value['c_member_id_invite']);
}
return $list;
}
function _getUnreadMessageList()
{
$sql = 'SELECT * FROM c_message WHERE c_member_id_to = ? AND is_read = 0 AND is_send = 1 ORDER BY c_message_id DESC';
$list = db_get_all_limit($sql, 0, 5, array(1));
foreach ($list as $key => $value) {
$list[$key]['c_member'] = db_member_c_member4c_member_id_LIGHT($value['c_member_id_from']);
}
return $list;
}
function execute($requests)
{
if (!db_member_c_member4c_member_id_LIGHT($requests['target_c_member_id'])) {
admin_client_redirect('list_c_member', '指定されたメンバーは存在しません');
}
$v = array();
$v['c_profile_list'] = db_member_c_profile_list4null();
$v['c_member'] = db_member_c_member4c_member_id($requests['target_c_member_id'], true, true, 'private');
$this->set($v);
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$target_c_member_id = $requests['target_c_member_id'];
$target_c_commu_id = $requests['target_c_commu_id'];
$body = $requests['body'];
// ----------
//--- 権限チェック
// 自分がコミュニティ管理者
// 自分がコミュニティ副管理者ではない
// targetがコミュニティメンバー
// 自分へのメッセージ送信ではない
// すでに管理者交代依頼メッセージ送信済みではない
// すでに副管理者要請メッセージを送信済みでない
$status = db_common_commu_status($u, $target_c_commu_id);
if (!$status['is_commu_admin']) {
handle_kengen_error();
}
if ($status['is_commu_sub_admin']) {
handle_kengen_error();
}
$status = db_common_commu_status($target_c_member_id, $target_c_commu_id);
if (!$status['is_commu_member']) {
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));
$this->set("target_c_member_id", $target_c_member_id);
$this->set('target_c_member', db_member_c_member4c_member_id_LIGHT($target_c_member_id));
$this->set("target_c_commu_id", $target_c_commu_id);
$this->set("body", $body);
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$target_c_member_id = $requests['target_c_member_id'];
// ----------
if (db_member_is_access_block($u, $target_c_member_id)) {
openpne_redirect('pc', 'page_h_access_block');
}
$this->set('inc_navi', fetch_inc_navi('f', $target_c_member_id));
$this->set('target_c_member', db_member_c_member4c_member_id_LIGHT($target_c_member_id));
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$c_member_id_to = $requests['c_member_id_to'];
// ----------
if (db_member_is_access_block($u, $c_member_id_to)) {
openpne_redirect('pc', 'page_h_access_block');
}
$this->set('inc_navi', fetch_inc_navi("f", $c_member_id_to));
$this->set('bookmark_member', db_member_c_member4c_member_id_LIGHT($c_member_id_to));
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['KTAI_C_MEMBER_ID'];
// --- リクエスト変数
$target_c_member_id = $requests['target_c_member_id'];
// ----------
if (db_member_is_access_block($u, $target_c_member_id)) {
openpne_redirect('ktai', 'page_h_access_block');
}
//ターゲット情報
$this->set("target_c_member", db_member_c_member4c_member_id_LIGHT($target_c_member_id));
return 'success';
}
function execute($requests)
{
if (!OPENPNE_USE_POINT_RANK || !OPENPNE_IS_POINT_ADMIN && $requests['target_c_member_id'] == 1) {
admin_client_redirect('top', '指定されたページにはアクセスできません');
}
$lite = db_member_c_member4c_member_id_LIGHT($requests['target_c_member_id']);
$prof = db_member_c_member_profile_list4c_member_id($requests['target_c_member_id'], "private");
$point = intval($prof['PNE_POINT']['value']);
$item = array("c_member_id" => $requests['target_c_member_id'], "nickname" => $lite['nickname'], "point" => $point);
$v = array();
$v['point'] = $point;
$v['item'] = $item;
$this->set($v);
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$id = $requests['id'];
$is_check = $requests['is_check'];
$writer_name = $requests['writer_name'];
$sort_order = $requests['sort_order'];
$writer_id = $requests['writer_id'];
$memo = $requests['memo'];
$is_done = $requests['is_done'];
$due_year = $requests['due_year'];
$due_month = $requests['due_month'];
$due_day = $requests['due_day'];
$priority = $requests['priority'];
$biz_group_id = $requests['biz_group_id'];
$public_flag = $requests['public_flag'];
// ----------
if (!biz_isPermissionTodo($u, $id)) {
handle_kengen_error();
}
if (empty($memo)) {
$_REQUEST['msg'] = 'Todoの内容を入力してください';
openpne_forward('biz', 'page', 'fh_home_edit_biz_todo');
exit;
}
if (!$biz_group_id && $public_flag == 'group') {
$_REQUEST['msg'] = '「グループまで公開」Todoの場合はグループを指定してください';
openpne_forward('biz', 'page', 'fh_home_edit_biz_todo');
exit;
}
if ($is_check && $public_flag == 'private') {
$_REQUEST['msg'] = '公開範囲が「公開しない」のTodoは共有できません';
openpne_forward('biz', 'page', 'fh_home_edit_biz_todo');
exit;
}
$member_info = db_member_c_member4c_member_id_LIGHT($writer_id);
$todo_info = biz_getTodo($id);
$due_datetime = $due_year . '-' . $due_month . '-' . $due_day . ' 00:00:00';
if (!$todo_info['c_member_id'] && !$is_check) {
$todo_info['c_member_id'] = $writer_id;
}
biz_editTodo($todo_info['c_member_id'], $memo, $writer_id, $sort_order, $is_check, $id, $is_done, $due_datetime, $priority, $biz_group_id, $public_flag);
openpne_redirect('pc', 'page_h_home');
}
/**
* @copyright 2005-2008 OpenPNE Project
* @license http://www.php.net/license/3_01.txt PHP License 3.01
*/
function xmlrpc_001_get_c_member($message)
{
$param = $message->getParam(0);
if (!XML_RPC_Value::isValue($param)) {
return false;
}
$params = XML_RPC_decode($param);
if (empty($params['target_c_member_id'])) {
return false;
}
if (empty($params['my_c_member_id'])) {
return false;
}
$t_id = intval($params['target_c_member_id']);
$m_id = intval($params['my_c_member_id']);
// my_c_member_id が不正
if (!db_member_c_member4c_member_id_LIGHT($m_id)) {
return xmlrpc_get_fault_response(56);
}
if ($t_id == $m_id) {
// 自分
$public_flag = 'private';
} elseif (db_friend_is_friend($t_id, $m_id)) {
$public_flag = 'friend';
} else {
$public_flag = 'public';
}
// target_c_member_id が不正
if (!($c_member = db_member_c_member4c_member_id($t_id, false, true, $public_flag))) {
return xmlrpc_get_fault_response(56);
}
// アクセスブロック判定
if (db_member_is_access_block($m_id, $t_id)) {
$result = array('c_member_id' => $t_id, 'nickname' => $c_member['nickname'], 'image_url' => xmlrpc_get_image_url());
} else {
$result = array('c_member_id' => $t_id, 'nickname' => $c_member['nickname'], 'image_url' => xmlrpc_get_image_url($c_member['image_filename']), 'image_url_1' => xmlrpc_get_image_url($c_member['image_filename_1'], false), 'image_url_2' => xmlrpc_get_image_url($c_member['image_filename_2'], false), 'image_url_3' => xmlrpc_get_image_url($c_member['image_filename_3'], false), 'birth_year' => intval($c_member['birth_year']), 'birth_month' => intval($c_member['birth_month']), 'birth_day' => intval($c_member['birth_day']), 'access_date' => xmlrpc_get_date($c_member['access_date']), 'r_date' => xmlrpc_get_date($c_member['r_date']), 'profile' => array());
foreach ($c_member['profile'] as $key => $profile) {
$result['profile'][$key] = $profile['value'];
}
}
return xmlrpc_get_response($result);
}
/**
* あしあとリスト取得
* 同一人物・同一日付のアクセスは最新の日時だけ
*
* @param int $c_member_id_to 訪問された人
* @param int $limit
* @return array あしあとリスト
*/
function db_ashiato_c_ashiato_list4c_member_id($c_member_id_to, $count)
{
$sql = 'SELECT DISTINCT r_date FROM c_ashiato WHERE c_member_id_to = ? ORDER BY r_date DESC';
$params = array(intval($c_member_id_to));
$days = db_get_col_limit($sql, 0, $count, $params);
$sql = 'SELECT DISTINCT c_member_id_from, MAX(r_datetime) AS r_datetime' . ' FROM c_ashiato WHERE r_date = ? AND c_member_id_to = ?' . ' GROUP BY c_member_id_from ORDER BY r_datetime DESC';
$result = array();
foreach ($days as $day) {
$params = array(strval($day), intval($c_member_id_to));
$day_result = db_get_all_limit($sql, 0, $count, $params);
$result = array_merge($result, $day_result);
$count -= count($day_result);
if ($count <= 0) {
break;
}
}
foreach ($result as $key => $value) {
$c_member = db_member_c_member4c_member_id_LIGHT($value['c_member_id_from']);
$result[$key]['nickname'] = $c_member['nickname'];
}
return $result;
}
function execute($requests)
{
$u = $GLOBALS['KTAI_C_MEMBER_ID'];
// --- リクエスト変数
$target_c_member_id = $requests['target_c_member_id'];
$subject = $requests['subject'];
$body = $requests['body'];
// ----------
if (db_member_is_access_block($u, $target_c_member_id)) {
openpne_redirect('ktai', 'page_h_access_block');
}
if ($target_c_member_id == $u) {
// 自分にメッセージは送れない
handle_kengen_error();
}
//ターゲットの情報
$this->set("target_c_member", db_member_c_member4c_member_id_LIGHT($target_c_member_id));
$form_val = array();
$form_val['subject'] = $subject;
$form_val['body'] = $body;
$this->set("form_val", $form_val);
return 'success';
}
/**
* @copyright 2005-2008 OpenPNE Project
* @license http://www.php.net/license/3_01.txt PHP License 3.01
*/
function xmlrpc_101_add_point($message)
{
$param = $message->getParam(0);
if (!XML_RPC_Value::isValue($param)) {
return false;
}
$params = XML_RPC_decode($param);
if (empty($params['c_member_id'])) {
return false;
}
if (!isset($params['point'])) {
return false;
}
$c_member_id = intval($params['c_member_id']);
$point = intval($params['point']);
if (!db_member_c_member4c_member_id_LIGHT($c_member_id)) {
return xmlrpc_get_fault_response(56);
}
$c_point_log_id = db_point_insert_log($c_member_id, $point, $params['memo']);
db_point_insert_tags($c_point_log_id, $params['tags']);
$point = db_point_add_point($c_member_id, $point);
return xmlrpc_get_response($point);
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$target_id = $requests['target_c_commu_id'];
// ----------
$group = biz_getGroupData($target_id);
if (!$group) {
$p = array();
openpne_redirect('pc', 'page_h_err_c_home', $p);
exit;
}
$this->set("group", $group);
$member_list = biz_getGroupMember($target_id, 9);
$member_list_full = biz_getGroupMember($target_id);
foreach ($member_list as $key => $value) {
$member_list[$key] = db_member_c_member4c_member_id_LIGHT($value['c_member_id']);
}
foreach ($member_list_full as $key => $value) {
$member_list_full[$key] = db_member_c_member4c_member_id($value['c_member_id']);
$member_list_full[$key]['last_login'] = p_f_home_last_login4access_date($member_list_full[$key]['access_date']);
}
$this->set('inc_navi', fetch_inc_navi('h'));
$this->set("member_list", $member_list);
$this->set("member_count", count($member_list_full));
$this->set("admin_data", db_member_c_member4c_member_id_LIGHT($group['admin_id']));
$this->set('calendar_head', biz_getScheduleWeek($u, $target_id, $requests['w'], 'g', ture, false, false));
foreach ($member_list_full as $key => $value) {
$calendar_value .= biz_getScheduleWeek($u, $value['c_member_id'], $requests['w'], 'g', false, true, false, $value);
}
$this->set('calendar_value', $calendar_value);
$this->set('calendar_foot', biz_getScheduleWeek($u, $target_id, $requests['w'], 'g', false, false, true));
if ($u == $group['admin_id']) {
$this->set("is_admin", true);
}
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['KTAI_C_MEMBER_ID'];
//ランダム５０人のフレンド
$this->set('c_friend_list', db_friend_ktai_c_friend_list_random4c_member_id($u));
// --- リクエスト変数
$form_val['target_c_message_id'] = $requests['target_c_message_id'];
$target_c_member_id = $requests['target_c_member_id'];
$subject = $requests['subject'];
$body = $requests['body'];
// ----------
//メッセージIDから情報を取り出す
if (isset($form_val['target_c_message_id'])) {
$c_message = db_message_c_message4c_message_id($form_val['target_c_message_id']);
// 権限チェック
if ($c_message['c_member_id_from'] != $u || $c_message['is_send']) {
handle_kengen_error();
}
// 内容の不備によるリダイレクト時は値を上書き
if ($requests['msg'] && !$c_message) {
$c_message['subject'] = $subject;
$c_message['body'] = $body;
$c_message['c_member_id_to'] = $target_c_member_id;
}
if (isset($c_message['c_member_id_to'])) {
$this->set('target_c_member', db_member_c_member4c_member_id_LIGHT($c_message['c_member_id_to']));
}
$form_val = array('target_c_message_id' => $c_message['c_message_id'], 'hensinmoto_c_message_id' => $c_message['hensinmoto_c_message_id'], 'subject' => $c_message['subject'], 'body' => $c_message['body']);
} else {
$form_val['target_c_member'] = db_member_c_member4c_member_id_LIGHT($target_c_member_id);
$form_val['target_c_member_id'] = $target_c_member_id;
$form_val['subject'] = $subject;
$form_val['body'] = $body;
}
$this->set('form_val', $form_val);
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['KTAI_C_MEMBER_ID'];
// --- リクエスト変数
$page = $requests['page'];
// ----------
//ターゲット情報
$this->set("target_c_member", db_member_c_member4c_member_id_LIGHT($u));
// 1ページ当たりに表示する数
$page_size = 5;
//ターゲットの詳細なリスト
$list = db_commu_ktai_anataga_c_commu_member_confirm_list4c_member_id($u, $page_size, $page);
$total_num = db_commu_count_c_anataga_c_commu_member_confirm($u);
$this->set("anataga_c_commu_member_confirm_list", $list[0]);
$this->set("page", $page);
$this->set("is_prev", $list[1]);
$this->set("is_next", $list[2]);
$this->set('total_num', $total_num);
$pager = array();
$pager['start'] = $page_size * ($page - 1) + 1;
$pager['end'] = $pager['start'] + count($list[0]) - 1;
$this->set('pager', $pager);
return 'success';
}
/**
* 受信メッセージの送信者リストを取得
*/
function db_message_c_message_receiver_list4c_member_id($c_member_id)
{
$where = "c_member_id_from = ?" . " AND is_deleted_from = 0" . " AND is_send = 1";
if ($GLOBALS['_OPENPNE_DSN_LIST']['main']['dsn']['phptype'] == 'pgsql') {
$sql = "SELECT c_member_id_to" . " FROM" . "(" . "SELECT distinct on(c_member_id_to) *" . " FROM" . " c_message" . " WHERE " . $where . ") as sub_member_tbl";
} else {
$sql = "SELECT distinct c_member_id_to FROM c_message";
$sql .= " WHERE {$where}";
}
$sql .= " ORDER BY r_datetime DESC";
$params = array(intval($c_member_id));
$c_message_list = db_get_all($sql, $params);
foreach ($c_message_list as $key => $value) {
$c_member = db_member_c_member4c_member_id_LIGHT($value['c_member_id_to']);
$c_message_list[$key]['nickname'] = $c_member['nickname'];
}
return $c_message_list;
}
function db_common_c_member4c_member_id_LIGHT($c_member_id)
{
return db_member_c_member4c_member_id_LIGHT($c_member_id);
}
function execute($requests)
{
$u = $GLOBALS['KTAI_C_MEMBER_ID'];
// --- リクエスト変数
$target_c_diary_id = $requests['target_c_diary_id'];
$target_response_comment_id = $requests['target_response_comment_id'];
$page = $requests['page'];
// ----------
$c_diary = db_diary_get_c_diary4id($target_c_diary_id);
$target_c_member = k_p_fh_diary_c_member4c_diary_id($target_c_diary_id);
$target_c_member_id = $target_c_member['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('ktai', 'page_h_err_diary_access');
}
//アクセスブロック設定
if (db_member_is_access_block($u, $target_c_member_id)) {
openpne_redirect('ktai', 'page_h_access_block');
}
}
//管理画面HTML
$this->set('c_siteadmin', p_common_c_siteadmin4target_pagename('k_fh_diary'));
//日記の作者情報
$this->set('target_diary_writer', $target_c_member);
//日記
$this->set('target_c_diary', $c_diary);
$this->set('c_diary_id_prev', db_diary_c_diary_id_prev4c_diary_id($target_c_member_id, $target_c_diary_id, $u));
$this->set('c_diary_id_next', db_diary_c_diary_id_next4c_diary_id($target_c_member_id, $target_c_diary_id, $u));
//自分で日記を見たとき
if ($c_diary['c_member_id'] == $u) {
//日記を閲覧済みにする
db_diary_update_c_diary_is_checked($target_c_diary_id, 1);
$this->set('type', 'h');
}
//コメント
$page_size = 5;
if ($requests['order'] === 'asc') {
$desc = false;
} else {
$desc = true;
}
list($c_diary_comment_list, $is_prev, $is_next, $total_num, $total_page_num) = k_p_fh_diary_c_diary_comment_list4c_diary_id($target_c_diary_id, $page_size, $page, $desc);
if ($desc) {
$c_diary_comment_list = array_reverse($c_diary_comment_list);
}
if ($target_response_comment_id) {
$target_comment = _do_c_diary_comment4c_diary_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");
}
$this->set('c_diary_comment', $c_diary_comment_list);
$this->set('total_num', $total_num);
$this->set('total_page_num', $total_page_num);
$this->set('page_size', $page_size);
$this->set('page', $page);
$this->set('is_writable_comment', db_diary_is_writable_comment4c_diary_id($target_c_diary_id));
// コメント許可設定取得
$this->set('is_comment_input', $c_diary['is_comment_input']);
$start_comment = reset($c_diary_comment_list);
$end_comment = end($c_diary_comment_list);
$pager = array();
$pager['start'] = (int) $start_comment['number'];
$pager['end'] = (int) $end_comment['number'];
if ($is_prev) {
if ($desc) {
$pager['page_next'] = $page - 1;
} else {
$pager['page_prev'] = $page - 1;
}
}
if ($is_next) {
if ($desc) {
$pager['page_prev'] = $page + 1;
} else {
$pager['page_next'] = $page + 1;
}
}
$this->set('pager', $pager);
// f or h
$this->set('INC_NAVI_type', k_p_fh_common_get_type($target_c_member['c_member_id'], $u));
if (MAIL_ADDRESS_HASHED) {
$mail_address = "bc{$target_c_diary_id}-" . t_get_user_hash($u) . '@' . MAIL_SERVER_DOMAIN;
} else {
$mail_address = "bc{$target_c_diary_id}" . '@' . MAIL_SERVER_DOMAIN;
}
$mail_address = MAIL_ADDRESS_PREFIX . $mail_address;
$this->set('mail_address', $mail_address);
//あしあとをつける
db_ashiato_insert_c_ashiato($target_c_member_id, $u);
return 'success';
}
function send_diary_comment_info_mail($c_diary_comment_id, $c_member_id)
{
$comment = _do_c_diary_comment4c_diary_comment_id($c_diary_comment_id);
$target_c_member_id = $comment['c_member_id_author'];
// コメントした人=日記オーナーの場合は通知しない
if ($target_c_member_id == $c_member_id) {
return false;
}
// 日記オーナーの通知設定が無ければ通知しない
$target_c_member_config = util_get_c_member_config($target_c_member_id);
if (!$target_c_member_config['SEND_DIARY_COMMENT_MAIL_KTAI']) {
return false;
}
$c_member = db_member_c_member4c_member_id_LIGHT($c_member_id);
$target_c_member = db_member_c_member_secure4c_member_id($target_c_member_id);
$c_diary_id = $comment['c_diary_id'];
$c_diary = db_diary_get_c_diary4id($c_diary_id);
$p = array('target_c_diary_id' => $c_diary_id);
$url = openpne_gen_url('ktai', 'page_fh_diary', $p);
$params = array('subject' => $c_diary['subject'], 'nickname' => $c_member['nickname'], 'body' => $comment['body'], 'url' => $url, 'image_filename1' => $comment['image_filename_1'], 'image_filename2' => $comment['image_filename_2'], 'image_filename3' => $comment['image_filename_3'], 'id' => $c_diary_comment_id);
$ktai_address = $target_c_member['ktai_address'];
if (MAIL_ADDRESS_HASHED) {
$from = "bc{$c_diary_id}-" . t_get_user_hash($target_c_member_id) . '@' . MAIL_SERVER_DOMAIN;
} else {
$from = "bc{$c_diary_id}" . '@' . MAIL_SERVER_DOMAIN;
}
$from = MAIL_ADDRESS_PREFIX . $from;
return fetch_send_mail($ktai_address, 'm_ktai_diary_comment_info', $params, true, $from);
}
/**
* スケジュール通知メールを送信する
*/
function biz_do_common_send_schedule_mail()
{
$y = date("Y");
$m = date("m");
$d = date("d");
$c_schedule_list = biz_getDateSchedule($y, $m, $d);
$send_list = array();
foreach ($c_schedule_list as $schedule_id) {
$value = biz_getScheduleInfo($schedule_id);
$biz_schedule_member = biz_getJoinIdSchedule($value['biz_schedule_id']);
foreach ($biz_schedule_member as $c_member_id) {
$send_list[$c_member_id][] = $value;
}
}
foreach ($send_list as $c_member_id => $c_schedule_list) {
$c_member_secure = db_member_c_member_secure4c_member_id($c_member_id);
if (!empty($c_member_secure['pc_address'])) {
// PCメールアドレスがある場合は、PCのみ送信
$pc_address = $c_member_secure['pc_address'];
$params = array('c_member' => db_member_c_member4c_member_id_LIGHT($c_member_id), 'c_schedule_list' => $c_schedule_list);
fetch_send_mail($pc_address, 'm_pc_schedule_mail', $params);
} else {
// PCメールアドレスがない場合は、携帯のみ送信
$ktai_address = $c_member_secure['ktai_address'];
$p = array('kad' => t_encrypt(db_member_username4c_member_id($c_member_id, true)));
$login_url = openpne_gen_url('ktai', 'page_o_login', $p);
$params = array('c_member' => db_member_c_member4c_member_id_LIGHT($c_member_id), 'login_url' => $login_url, 'c_schedule_list' => $c_schedule_list);
fetch_send_mail($ktai_address, 'm_ktai_schedule_mail', $params);
}
}
}
function make_channel($input, $download_date)
{
$dscript['sns_title'] = SNS_NAME;
$data_names = array('日記', '日記とコメント', 'トピック', 'トピックとコメント', 'イベント', 'イベントとコメント');
//ダウンロード対象
$dscript['dl_target'] = $data_names[$input['data_type']];
//ニックネーム取得
$nickname = "";
if ($input['member']['select'] > 0) {
$member = db_member_c_member4c_member_id_LIGHT($input['member']['c_member_id']);
$dscript['dl_user'] = $member['nickname'];
}
//カテゴリ名称取得
$category = "";
if ($input['data_type'] > 1) {
if ($input['commu']['is_commu'] == 1) {
$dscript['dl_category'] = db_commu_c_commu_category_name4c_commu_category_id($input['commu']['category_id']);
}
}
//期間の編集
$period = "";
if ($input['period']['is_period']) {
$start_date = date('Y/m/d', strtotime($input['period']['start_datetime']));
$end_date = date('Y/m/d', strtotime($input['period']['dsp_datetime']));
$dscript['dl_date'] = sprintf("%s～%sまで", $start_date, $end_date);
}
$channel = array("title" => SNS_NAME, "link" => OPENPNE_URL, "description" => $dscript, "items" => array("rdf:Seq" => array("rdf:li" => array("_attributes" => array("rdf:resource" => OPENPNE_URL))), "pubDate" => $download_date));
return $channel;
}
