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)
{
//<PCKTAI
if (OPENPNE_AUTH_MODE == 'slavepne' || !((OPENPNE_REGIST_FROM & OPENPNE_REGIST_FROM_KTAI) >> 1)) {
openpne_redirect('ktai', 'page_o_login', array('msg' => 42));
}
//>
// --- リクエスト変数
$ses = $requests['ses'];
$aff_id = $requests['aff_id'];
// ----------
// セッションが有効かどうか
if (!($pre = db_member_c_member_ktai_pre4session($ses))) {
// 無効の場合、login へリダイレクト
openpne_redirect('ktai', 'page_o_login', array('msg' => 42));
}
// メールアドレスが登録できるかどうか
if (!util_is_regist_mail_address($pre['ktai_address'])) {
openpne_redirect('ktai', 'page_o_login', array('msg' => 42));
}
if ($aff_id) {
$this->set('aff_id', $aff_id);
}
// 招待者の情報
$c_member_invite = db_member_c_member_with_profile($pre['c_member_id_invite'], 'friend');
$this->set('last_login', p_f_home_last_login4access_date($c_member_invite['access_date']));
$this->set('friend_count', db_friend_count_friends($c_member_invite['c_member_id']));
$this->set('target_c_member', $c_member_invite);
$this->set('ses', $ses);
$this->set('SNS_NAME', SNS_NAME);
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$target_c_member_id = $requests['target_c_member_id'];
$page = $requests['page'];
$order = $requests['order'];
// ----------
if (!$target_c_member_id) {
$target_c_member_id = $u;
}
if (db_member_is_access_block($u, $target_c_member_id)) {
openpne_redirect('pc', 'page_h_access_block');
}
// navi 振り分け用
if ($target_c_member_id == $u) {
$type = "h";
} else {
$type = "f";
}
$this->set('inc_navi', fetch_inc_navi($type, $target_c_member_id));
$this->set("type", $type);
//----------PC CONTENT#LEFT
//メンバー情報
$this->set("member", db_member_c_member4c_member_id($u));
//ターゲット情報
$this->set("target_member", db_member_c_member4c_member_id($target_c_member_id));
//ターゲットの友達数
$friend_num = db_friend_count_friends($target_c_member_id);
$this->set("target_friend_num", $friend_num);
//----------PC CONTENT#CENTER
// 1ページ当たりに表示するフレンドの数
$page_size = 50;
//ターゲットの詳細な友達リスト
$list = db_friend_friend_list4c_member_id2($target_c_member_id, $page_size, $page, $order);
$this->set("order", $order);
$this->set("target_friend_list_disp", $list[0]);
$this->set("page", $page);
$this->set("is_prev", $list[1]);
$this->set("is_next", $list[2]);
$this->set("start_num", ($page - 1) * $page_size + 1);
if ($page * $page_size < $friend_num) {
$end_num = $page * $page_size;
} else {
$end_num = $friend_num;
}
$this->set("end_num", $end_num);
for ($i = 1; $i <= $list[3]; $i++) {
$page_num[] = $i;
}
$this->set("page_num", $page_num);
//あしあとをつける
if ($target_c_member_id != $u) {
db_ashiato_insert_c_ashiato($target_c_member_id, $u);
}
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
$target_c_member_id = $u;
$this->set('is_h_prof', 1);
$this->set('inc_navi', fetch_inc_navi('h'));
$target_c_member = db_member_c_member_with_profile($u, 'private');
$this->set('is_friend', 0);
$this->set('c_diary_list', db_diary_get_c_diary_list4c_member_id($target_c_member_id, 5, null, 'friend'));
if (OPENPNE_USE_ALBUM) {
// アルバム
$this->set('c_album_list', db_album_get_c_album_subject_list4c_member_id($target_c_member_id, 5, null, 'friend'));
}
// --- f_home, h_prof 共通処理
$this->set('target_c_member_id', $target_c_member_id);
$target_c_member['last_login'] = p_f_home_last_login4access_date($target_c_member['access_date']);
if ($target_c_member['birth_year']) {
$target_c_member['age'] = getAge($target_c_member['birth_year'], $target_c_member['birth_month'], $target_c_member['birth_day']);
}
$this->set('target_c_member', $target_c_member);
$this->set('c_rss_cache_list', db_rss_c_rss_cache_list4c_member_id($target_c_member_id, 5));
$this->set('c_friend_comment_list', db_friend_c_friend_comment4c_member_id($target_c_member_id));
$this->set('c_friend_list', db_friend_c_friend_list4c_member_id($target_c_member_id, 9));
$this->set('c_friend_count', db_friend_count_friends($target_c_member_id));
$this->set('user_count', db_commu_count_c_commu4c_member_id($target_c_member_id));
$this->set('c_commu_list', db_commu_c_commu_list4c_member_id_2($target_c_member_id, 9));
$this->set('c_review_list', db_review_c_review_list4member($target_c_member_id, 5));
$this->set('profile_list', db_member_c_profile_list());
// 誕生日まであと何日？
$this->set('days_birthday', db_member_count_days_birthday4c_member_id($target_c_member_id));
if (OPENPNE_USE_POINT_RANK) {
// ポイント
$point = db_point_get_point($target_c_member_id);
$this->set("point", $point);
// ランク
$this->set("rank", db_point_get_rank4point($point));
}
// ---bizここから
$this->set('is_h_prof', 1);
//カレンダー表示用
$biz_dir = OPENPNE_MODULES_BIZ_DIR . '/biz/';
//bizモジュールディレクトリの定義
include_once $biz_dir . 'lib/smarty_functions.php';
//bizモジュールよりライブラリを拝借
include_once $biz_dir . 'lib/mysql_functions.php';
//bizモジュールよりライブラリを拝借
$this->set('calendar', biz_getScheduleWeek($u, $u, $requests['w'], 'p', true, true, true, $target_c_member));
$todolist = biz_getTodoList($u, $u, "h", $target_c_member['nickname']);
$this->set("todolist", $todolist);
$group_list = biz_getHomeGroupList($u);
$this->set('group_list', $group_list);
// ---bizここまで
// inc_entry_point
$this->set('inc_entry_point', fetch_inc_entry_point($this->getView(), 'f_home'));
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
$target_c_member_id = $u;
$this->set('is_h_prof', 1);
$this->set('inc_navi', fetch_inc_navi('h'));
$target_c_member = db_member_c_member_with_profile($u, 'private');
$this->set('is_friend', 0);
$this->set('c_diary_list', db_diary_get_c_diary_list4c_member_id($target_c_member_id, 5, null, 'friend'));
if (OPENPNE_USE_ALBUM) {
// アルバム
$this->set('c_album_list', db_album_get_c_album_subject_list4c_member_id($target_c_member_id, 5, null, 'friend'));
}
// --- f_home, h_prof 共通処理
$this->set('target_c_member_id', $target_c_member_id);
$target_c_member['last_login'] = p_f_home_last_login4access_date($target_c_member['access_date']);
if ($target_c_member['birth_year']) {
$target_c_member['age'] = getAge($target_c_member['birth_year'], $target_c_member['birth_month'], $target_c_member['birth_day']);
}
$this->set('target_c_member', $target_c_member);
$this->set('c_rss_cache_list', db_rss_c_rss_cache_list4c_member_id($target_c_member_id, 5));
$this->set('c_friend_comment_list', db_friend_c_friend_comment4c_member_id($target_c_member_id));
$this->set('c_friend_list', db_friend_c_friend_list4c_member_id($target_c_member_id, 9));
$this->set('c_friend_count', db_friend_count_friends($target_c_member_id));
$this->set('user_count', db_commu_count_c_commu4c_member_id($target_c_member_id));
$this->set('c_commu_list', db_commu_c_commu_list4c_member_id_2($target_c_member_id, 9));
$this->set('c_review_list', db_review_c_review_list4member($target_c_member_id, 5));
$this->set('profile_list', db_member_c_profile_list());
// 誕生日まであと何日？
$this->set('days_birthday', db_member_count_days_birthday4c_member_id($target_c_member_id));
if (OPENPNE_USE_POINT_RANK) {
// ポイント
$point = db_point_get_point($target_c_member_id);
$this->set("point", $point);
// ランク
$this->set("rank", db_point_get_rank4point($point));
}
// inc_entry_point
$this->set('inc_entry_point', fetch_inc_entry_point($this->getView(), 'f_home'));
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
$inc_navi = fetch_inc_navi('h');
$this->set('inc_navi', $inc_navi);
$OPTION = $this->get('C_MEMBER_CONFIG');
/// infomation ///
// 運営者からのおしらせ
$this->set('site_info', p_common_c_siteadmin4target_pagename('h_home'));
//未読メッセージの数をお知らせ
$this->set('num_message_not_is_read', db_message_count_c_message_not_is_read4c_member_to_id($u));
//日記コメントの未読の数をお知らせ
$this->set('num_diary_not_is_read', p_h_diary_count_c_diary_not_is_read4c_member_id($u));
//日記コメントの未読の中で、読ませるものを送る
$this->set('first_diary_read', p_h_diary_c_diary_first_diary_read4c_member_id($u));
//あなたにフレンド承認を求めているメンバーリスト
$f_confirm_list = db_friend_anatani_c_friend_confirm_list4c_member_id($u);
$this->set('f_confirm_list', $f_confirm_list);
$this->set('num_f_confirm_list', count($f_confirm_list));
//あなたにコミュニティ参加承認を求めているメンバーリスト
$h_confirm_list = db_commu_anatani_c_commu_member_confirm_list4c_member_id($u);
$this->set('h_confirm_list', $h_confirm_list);
$this->set('num_h_confirm_list', count($h_confirm_list));
// あなたにコミュニティ管理者交代を希望しているメンバー
$anatani_c_commu_admin_confirm_list = db_commu_anatani_c_commu_admin_confirm_list4c_member_id($u);
$this->set('anatani_c_commu_admin_confirm_list', $anatani_c_commu_admin_confirm_list);
$this->set('num_anatani_c_commu_admin_confirm_list', count($anatani_c_commu_admin_confirm_list));
// あなたにコミュニティ副管理者を希望しているメンバー
$anatani_c_commu_sub_admin_confirm_list = db_commu_anatani_c_commu_sub_admin_confirm_list4c_member_id($u);
$this->set('anatani_c_commu_sub_admin_confirm_list', $anatani_c_commu_sub_admin_confirm_list);
$this->set('num_anatani_c_commu_sub_admin_confirm_list', count($anatani_c_commu_sub_admin_confirm_list));
// 誕生日かどうか
$this->set('birthday_flag', db_member_birthday_flag4c_member_id($u));
/// 左側 ///
// メンバー情報
$c_member = db_member_c_member_with_profile($u, 'private');
$this->set('c_member', $c_member);
// フレンドリスト
$c_friend_list = db_friend_c_friend_list4c_member_id($u, 9);
$this->set('c_friend_list', $c_friend_list);
$this->set('c_friend_count', db_friend_count_friends($u));
// 参加コミュニティ
$c_commu_user_list = db_commu_c_commu_list4c_member_id_2($u, 9);
$this->set('c_commu_user_list', $c_commu_user_list);
$this->set('fh_com_count_user', db_commu_count_c_commu4c_member_id($u));
// 写真使用量
$image_limit_list = db_image_get_image_limit_list($u);
$this->set('image_limit_list', $image_limit_list);
/// 最新情報 ///
// 最新日記
if (DISPLAY_NEWDIARYTOPIC_HOME && $OPTION['IS_DISPLAY_NEWDIARY_HOME']) {
$this->set('c_diary_list_all', p_h_home_c_diary_all_list(5));
}
// フレンド最新日記
$c_diary_friend_list = p_h_home_c_diary_friend_list4c_member_id($u, 5, true);
$this->set('c_diary_friend_list', $c_diary_friend_list);
// フレンド最新blog
$this->set('c_rss_cache_list', db_rss_list_friend_c_rss_cache_list($u, 5));
// 日記コメント記入履歴
$c_diary_my_comment_list = p_h_home_c_diary_my_comment_list4c_member_id($u, 5);
$this->set('c_diary_my_comment_list', $c_diary_my_comment_list);
// コミュニティ全ての新着書き込み
if (DISPLAY_NEWDIARYTOPIC_HOME && $OPTION['IS_DISPLAY_NEWTOPIC_HOME']) {
$this->set('c_topic_list_all', p_h_home_c_topic_all_list(5));
}
// 参加コミュニティの新着書き込み
$this->set('c_commu_topic_comment_list', db_commu_c_commu_topic_comment_list4c_member_id($u, 5, true));
// レビュー
$this->set('c_friend_review_list', db_review_c_friend_review_list4c_member_id($u, 5));
if (OPENPNE_USE_ALBUM) {
// アルバム
$this->set('c_friend_album_list', p_h_home_c_album_friend_list4c_member_id($u, 5));
}
/// 自分の情報 ///
// 日記
$c_diary_list = db_diary_get_c_diary_list4c_member_id($u, 5);
$this->set('c_diary_list', $c_diary_list);
// 外部blog
$this->set('c_blog_list', db_rss_h_blog_list_friend4c_member_id($u, 5, 1));
// レビュー
$this->set('c_review_list', db_review_c_review_list4member($u, 5));
if (OPENPNE_USE_ALBUM) {
// アルバム
$this->set('c_album_list', db_album_get_c_album_subject_list4c_member_id($u, 5));
}
/// その他 ///
if (OPENPNE_USE_POINT_RANK) {
// ポイント
$point = db_point_get_point($u);
$this->set("point", $point);
// ランク
$this->set("rank", db_point_get_rank4point($point));
}
// 紹介文
$c_friend_intro_list = db_friend_c_friend_intro_list4c_member_id($u, 5);
$this->set('c_friend_intro_list', $c_friend_intro_list);
// 今日の日付、曜日
$this->set('r_datetime', date('m/d'));
$date = array('日', '月', '火', '水', '木', '金', '土');
$this->set('r_datetime_date', $date[date('w')]);
/// 週間カレンダー
if (DISPLAY_SCHEDULE_HOME && $OPTION['IS_DISPLAY_SCHEDULE_HOME']) {
//開始曜日の設定
if ($c_member['schedule_start_day'] == 2) {
$start_day = date("w");
} else {
$start_day = $c_member['schedule_start_day'];
}
$this->set('calendar', $this->get_calendar($u, $requests['w'], $start_day));
}
// お気に入りフィード
if (USE_BOOKMARK_FEED) {
// お気に入りの最新日記
if ($OPTION['IS_DISPLAY_BOOKMARK_DIARY_HOME']) {
$this->set('bookmark_diary_list', db_bookmark_diary_list($u, 5));
}
//お気に入りの最新ブログ
if ($OPTION['IS_DISPLAY_BOOKMARK_BLOG_HOME']) {
$this->set('bookmark_blog_list', db_bookmark_blog_list($u, 5));
}
//お気に入りのメンバー
$bookmark_member_list = db_bookmark_member_list($u, 9);
$this->set('bookmark_member_list', $bookmark_member_list);
$this->set('bookmark_count', db_bookmark_count($u));
}
// API用セッションID
$this->set('api_session_id', get_api_sessionid($u));
// アクセス日時を記録
db_member_do_access($u);
// inc_entry_point
$this->set('inc_entry_point', fetch_inc_entry_point($this->getView(), 'h_home'));
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['KTAI_C_MEMBER_ID'];
$OPTION = $this->get('C_MEMBER_CONFIG');
$c_member_secure = db_member_c_member_secure4c_member_id($u);
//管理画面HTML
$this->set('c_siteadmin', p_common_c_siteadmin4target_pagename('k_h_home'));
$c_member = db_member_c_member_with_profile($u, 'private');
//メンバー情報
$this->set('c_member', $c_member);
//新着メッセージ数
$this->set('c_message_unread_count', db_message_c_message_received_unread_all_count4c_member_id($u));
//フレンドの最新日記
$this->set('c_diary_friend_list', p_h_home_c_diary_friend_list4c_member_id($u, 5, true));
//参加コミュニティリスト
$this->set('c_commu_list', db_commu_c_commu_list_lastupdate4c_member_id($u, 5));
//参加コミュニティの数
$this->set('fh_com_count_user', db_commu_count_c_commu4c_member_id($u));
//フレンドリスト
$this->set('c_friend_list', db_friend_c_friend_list_random4c_member_id($u, 5));
//フレンドの数
$this->set('c_friend_count', db_friend_count_friends($u));
//参加コミュニティの新着書き込み
$this->set('c_commu_topic_list', db_commu_c_commu_topic_comment_list4c_member_id($u, 5, true));
$this->set('SNS_NAME', SNS_NAME);
if (DISPLAY_NEWDIARYTOPIC_HOME) {
if ($OPTION['IS_DISPLAY_NEWDIARY_HOME_KTAI']) {
$this->set('c_diary_list_all', p_h_home_c_diary_all_list(5));
}
if ($OPTION['IS_DISPLAY_NEWTOPIC_HOME_KTAI']) {
$this->set('c_topic_list_all', p_h_home_c_topic_all_list(5));
}
}
//アクセス日時を記録
db_member_do_access($u);
//未読メッセージの数をお知らせ
$this->set("num_message_not_is_read", db_message_count_c_message_not_is_read4c_member_to_id($u));
//日記コメントの未読の数をお知らせ
$this->set("num_diary_not_is_read", p_h_diary_count_c_diary_not_is_read4c_member_id($u));
//日記コメントの未読の中で、読ませるものを送る
$this->set("first_diary_read", p_h_diary_c_diary_first_diary_read4c_member_id($u));
//コミュニティ承認を求めているメンバーリスト
$h_confirm_list = db_commu_anatani_c_commu_member_confirm_list4c_member_id($u);
$this->set("h_confirm_list", $h_confirm_list);
//そのメンバーの人数
$this->set("num_h_confirm_list", count($h_confirm_list));
//あなたにフレンド認証を求めているメンバーリスト
$f_confirm_list = db_friend_anatani_c_friend_confirm_list4c_member_id($u);
$this->set("f_confirm_list", $f_confirm_list);
//そのメンバーの人数
$this->set("num_f_confirm_list", count($f_confirm_list));
// あなたにコミュニティ管理者交代を希望しているメンバー
$anatani_c_commu_admin_confirm_list = db_commu_anatani_c_commu_admin_confirm_list4c_member_id($u);
$this->set("anatani_c_commu_admin_confirm_list", $anatani_c_commu_admin_confirm_list);
//そのメンバーの人数
$this->set("num_anatani_c_commu_admin_confirm_list", count($anatani_c_commu_admin_confirm_list));
// あなたにコミュニティ副管理者を希望しているメンバー
$anatani_c_commu_sub_admin_confirm_list = db_commu_anatani_c_commu_sub_admin_confirm_list4c_member_id($u);
$this->set("anatani_c_commu_sub_admin_confirm_list", $anatani_c_commu_sub_admin_confirm_list);
//そのメンバーの人数
$this->set("num_anatani_c_commu_sub_admin_confirm_list", count($anatani_c_commu_sub_admin_confirm_list));
//日記コメント記入履歴
$this->set("c_diary_my_comment_list", p_h_home_c_diary_my_comment_list4c_member_id($u, 5));
// 誕生日かどうか
$this->set('birthday_flag', db_member_birthday_flag4c_member_id($u));
if (MAIL_ADDRESS_HASHED) {
$mail_address = "b{$u}-" . t_get_user_hash($u) . "@" . MAIL_SERVER_DOMAIN;
} else {
$mail_address = "blog" . "@" . MAIL_SERVER_DOMAIN;
}
$mail_address = MAIL_ADDRESS_PREFIX . $mail_address;
$this->set('blog_address', $mail_address);
if (OPENPNE_USE_POINT_RANK) {
// ポイント
$point = db_point_get_point($u);
$this->set("point", $point);
// ランク
$this->set("rank", db_point_get_rank4point($point));
// メール送信設定
$this->set('is_unused_rank_up', util_is_unused_mail('m_ktai_rank_up'));
}
// メール送信設定
$this->set('is_unused_ashiato', util_is_unused_mail('m_ktai_ashiato'));
$this->set('is_unused_diary_comment', util_is_unused_mail('m_ktai_diary_comment_info'));
// inc_entry_point
$this->set('inc_ktai_entry_point', fetch_inc_entry_point($this->getView(), 'ktai_h_home'));
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$target_c_member_id = $requests['target_c_member_id'];
// ----------
// - IDが指定されていない場合
// - IDが自分の場合
// は h_home へリダイレクト
if (!$target_c_member_id || $target_c_member_id == $u) {
openpne_redirect('pc', 'page_h_home');
}
if (!db_member_is_active_c_member_id($target_c_member_id)) {
openpne_redirect('pc', 'page_h_err_f_home');
}
if (db_member_is_access_block($u, $target_c_member_id)) {
openpne_redirect('pc', 'page_h_access_block');
}
//あしあとをつける
db_ashiato_insert_c_ashiato($target_c_member_id, $u);
$this->set('is_h_prof', 0);
$inc_navi = fetch_inc_navi('f', $target_c_member_id);
$this->set('inc_navi', $inc_navi);
$target_c_member = db_member_c_member_with_profile($target_c_member_id, 'private');
$is_friend = db_friend_is_friend($u, $target_c_member_id);
if ($is_friend) {
// 自分が書いた紹介文
$this->set('my_friend_intro', db_friend_c_friend_intro($u, $target_c_member_id));
} else {
// 友達の友達
$this->set('friend_path', db_friend_friend_path4c_member_ids($u, $target_c_member_id));
}
$this->set('is_friend', $is_friend);
$c_member = db_member_c_member4c_member_id($u);
$this->set('c_member', $c_member);
$c_diary_list = db_diary_get_c_diary_list4c_member_id($target_c_member_id, 5, $u);
$this->set('c_diary_list', $c_diary_list);
if (OPENPNE_USE_ALBUM) {
// アルバム
$this->set('c_album_list', db_album_get_c_album_subject_list4c_member_id($target_c_member_id, 5, $u));
}
// --- f_home, h_prof 共通処理
$this->set('target_c_member_id', $target_c_member_id);
$target_c_member['last_login'] = p_f_home_last_login4access_date($target_c_member['access_date']);
if ($target_c_member['birth_year']) {
$target_c_member['age'] = getAge($target_c_member['birth_year'], $target_c_member['birth_month'], $target_c_member['birth_day']);
}
$this->set('target_c_member', $target_c_member);
$this->set('c_rss_cache_list', db_rss_c_rss_cache_list4c_member_id($target_c_member_id, 5));
$c_friend_comment_list = db_friend_c_friend_comment4c_member_id($target_c_member_id);
$this->set('c_friend_comment_list', $c_friend_comment_list);
$c_friend_list = db_friend_c_friend_list4c_member_id($target_c_member_id, 9);
$this->set('c_friend_list', $c_friend_list);
$this->set('c_friend_count', db_friend_count_friends($target_c_member_id));
$this->set('user_count', db_commu_count_c_commu4c_member_id($target_c_member_id));
$this->set('common_commu_count', count(db_common_commu_common_commu_id4c_member_id($target_c_member_id, $u)));
$c_commu_list = db_commu_c_commu_list4c_member_id_2($target_c_member_id, 9);
$this->set('c_commu_list', $c_commu_list);
$this->set('c_review_list', db_review_c_review_list4member($target_c_member_id, 5));
$profile_list = db_member_c_profile_list();
$this->set('profile_list', $profile_list);
// 誕生日まであと何日？
$this->set('days_birthday', db_member_count_days_birthday4c_member_id($target_c_member_id));
if (OPENPNE_USE_POINT_RANK) {
// ポイント
$point = db_point_get_point($target_c_member_id);
$this->set("point", $point);
// ランク
$this->set("rank", db_point_get_rank4point($point));
}
// inc_entry_point
$this->set('inc_entry_point', fetch_inc_entry_point($this->getView(), 'f_home'));
// ---
return 'success';
}
function db_friend_friend_list4c_member_id($c_member_id, $page_size, $page)
{
$sql = "SELECT " . "c_friend_id," . "c_member_id_from," . "c_member_id_to," . "r_datetime," . "is_display_friend_home" . " FROM " . "c_friend" . " WHERE c_member_id_from = ?" . " ORDER BY r_datetime DESC";
$params = array(intval($c_member_id));
$c_friend_list = db_get_all_page($sql, $page, $page_size, $params);
foreach ($c_friend_list as $key => $value) {
$c_member = db_member_c_member4c_member_id($value['c_member_id_to']);
$c_friend_list[$key]['image_filename'] = $c_member['image_filename'];
$c_friend_list[$key]['c_member_id'] = $c_member['c_member_id'];
$c_friend_list[$key]['nickname'] = $c_member['nickname'];
$c_friend_list[$key]['access_date'] = $c_member['access_date'];
$c_friend_list[$key]['friend_count'] = db_friend_count_friends($c_member['c_member_id']);
}
$total_num = db_friend_count_friends($c_member_id);
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;
}
}
return array($c_friend_list, $prev, $next, $total_num);
}
/**
* お気に入りメンバーリスト
*/
function db_bookmark_member_list($c_member_id, $limit = 0)
{
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_LONG, __FUNCTION__, $funcargs);
$is_recurred = false;
return $result;
}
$sql = 'SELECT c_member_id_to AS c_member_id FROM c_bookmark' . ' WHERE c_member_id_from = ?' . db_order_by_rand();
$params = array(intval($c_member_id));
if ($limit) {
$result = db_get_all_limit($sql, 0, intval($limit), $params);
} else {
$result = db_get_all($sql, $params);
}
foreach ($result as $key => $value) {
$result[$key] = db_member_c_member4c_member_id_LIGHT($value['c_member_id']);
$result[$key]['friend_count'] = db_friend_count_friends($value['c_member_id']);
}
return $result;
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$target_c_member_id = $requests['target_c_member_id'];
// ----------
// - IDが指定されていない場合
// - IDが自分の場合
// は h_home へリダイレクト
if (!$target_c_member_id || $target_c_member_id == $u) {
openpne_redirect('pc', 'page_h_home');
}
if (!db_member_is_active_c_member_id($target_c_member_id)) {
openpne_redirect('pc', 'page_h_err_f_home');
}
if (db_member_is_access_block($u, $target_c_member_id)) {
openpne_redirect('pc', 'page_h_access_block');
}
//あしあとをつける
db_ashiato_insert_c_ashiato($target_c_member_id, $u);
$this->set('is_h_prof', 0);
$this->set('inc_navi', fetch_inc_navi('f', $target_c_member_id));
$is_friend = db_friend_is_friend($u, $target_c_member_id);
$target_c_member = db_member_c_member_with_profile($target_c_member_id, 'private');
if ($is_friend) {
// 自分が書いた紹介文
$this->set('my_friend_intro', db_friend_c_friend_intro($u, $target_c_member_id));
} else {
// 友達の友達
$this->set('friend_path', db_friend_friend_path4c_member_ids($u, $target_c_member_id));
}
$this->set('is_friend', $is_friend);
$this->set('c_member', db_member_c_member4c_member_id($u));
$this->set('c_diary_list', db_diary_get_c_diary_list4c_member_id($target_c_member_id, 5, $u));
if (OPENPNE_USE_ALBUM) {
// アルバム
$this->set('c_album_list', db_album_get_c_album_subject_list4c_member_id($target_c_member_id, 5, $u));
}
// --- f_home, h_prof 共通処理
$this->set('target_c_member_id', $target_c_member_id);
$target_c_member['last_login'] = p_f_home_last_login4access_date($target_c_member['access_date']);
if ($target_c_member['birth_year']) {
$target_c_member['age'] = getAge($target_c_member['birth_year'], $target_c_member['birth_month'], $target_c_member['birth_day']);
}
$this->set('target_c_member', $target_c_member);
$target_c_member_all = db_member_c_member_with_profile($target_c_member_id, 'private');
$this->set('target_c_member_all', $target_c_member_all);
$this->set('c_rss_cache_list', db_rss_c_rss_cache_list4c_member_id($target_c_member_id, 5));
$this->set('c_friend_comment_list', db_friend_c_friend_comment4c_member_id($target_c_member_id));
$this->set('c_friend_list', db_friend_c_friend_list4c_member_id($target_c_member_id, 9));
$this->set('c_friend_count', db_friend_count_friends($target_c_member_id));
$this->set('user_count', db_commu_count_c_commu4c_member_id($target_c_member_id));
$this->set('common_commu_count', count(db_common_commu_common_commu_id4c_member_id($target_c_member_id, $u)));
$this->set('c_commu_list', db_commu_c_commu_list4c_member_id_2($target_c_member_id, 9));
$this->set('c_review_list', db_review_c_review_list4member($target_c_member_id, 5));
$this->set('profile_list', db_member_c_profile_list());
// 誕生日まであと何日？
$this->set('days_birthday', db_member_count_days_birthday4c_member_id($target_c_member_id));
if (OPENPNE_USE_POINT_RANK) {
// ポイント
$point = db_point_get_point($target_c_member_id);
$this->set("point", $point);
// ランク
$this->set("rank", db_point_get_rank4point($point));
}
// --- bizここから
// バナーをBIZ用右部拡張領域下に表示させる為の仕掛け
$this->set('is_f_home', 1);
$biz_dir = OPENPNE_MODULES_BIZ_DIR . '/biz/';
//bizモジュールディレクトリの定義
include_once $biz_dir . 'lib/smarty_functions.php';
//bizモジュールよりライブラリを拝借
include_once $biz_dir . 'lib/mysql_functions.php';
//bizモジュールよりライブラリを拝借
$c_member = db_member_c_member4c_member_id($u);
$todolist = biz_getTodoList($u, $target_c_member_id, "f", $c_member['nickname']);
$this->set("todolist", $todolist);
$this->set('calendar', biz_getScheduleWeek($u, $target_c_member_id, $requests['w'], 'f', true, true, true, $target_c_member));
$group_list = biz_getHomeGroupList($target_c_member_id);
$this->set('group_list', $group_list);
// --- bizここまで
// inc_entry_point
$this->set('inc_entry_point', fetch_inc_entry_point($this->getView(), 'f_home'));
// ---
return 'success';
}
function db_admin_commu_c_members4c_commu_id($c_commu_id, $page_size, $page)
{
$sql = 'SELECT c_member_id, r_datetime FROM c_commu_member WHERE c_commu_id = ? ORDER BY r_datetime';
$params = array(intval($c_commu_id));
$id_list = db_get_all_page($sql, $page, $page_size, $params);
$list = array();
foreach ($id_list as $key => $value) {
$c_member = db_member_c_member4c_member_id_LIGHT($value['c_member_id']);
$c_member['friend_count'] = db_friend_count_friends($value['c_member_id']);
$c_member['r_datetime'] = $value['r_datetime'];
$list[] = $c_member;
}
$sql = 'SELECT COUNT(*) FROM c_commu_member WHERE c_commu_id = ?';
$total_num = db_get_one($sql, $params);
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);
}
/**
* コミュニティメンバーのリストをID新しいもの順に取得する。
* 取得する範囲を指定できる。
*/
function db_commu_c_members_disp4c_commu_id($c_commu_id, $page_size, $page)
{
$sql = 'SELECT c_member.c_member_id, nickname ' . ' FROM c_member, c_commu_member' . ' WHERE c_member.c_member_id = c_commu_member.c_member_id' . ' AND c_commu_member.c_commu_id = ?' . ' ORDER BY c_member.c_member_id DESC';
$params = array(intval($c_commu_id));
$list = db_get_all_page($sql, $page, $page_size, $params);
foreach ($list as $key => $value) {
$list[$key]['friend_count'] = db_friend_count_friends($value['c_member_id']);
}
$total_num = db_commu_count_c_commu_member_list4c_commu_id($c_commu_id);
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;
}
}
return array($list, $prev, $next);
}
