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); }