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');
}
if ($target_c_member_id == $u) {
handle_kengen_error();
}
//アクティブメンバーか
if (!db_member_is_active_c_member_id($target_c_member_id)) {
handle_kengen_error();
}
//お気に入り登録済みメンバーか
if (db_bookmark_is_bookmark($u, $target_c_member_id)) {
$p = array('c_member_id_to' => $target_c_member_id);
openpne_redirect('pc', 'page_f_bookmark_add_err_already', $p);
}
$this->set('inc_navi', fetch_inc_navi('f', $target_c_member_id));
$c_member = db_member_c_member_with_profile($target_c_member_id);
$c_member['last_login'] = p_f_home_last_login4access_date($c_member['access_date']);
$this->set('c_member', $c_member);
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();
if (!OPENPNE_USE_RANKING) {
openpne_forward('pc', 'page', 'h_err_ranking');
exit;
}
// --- リクエスト変数
$kind = $requests['kind'];
// ----------
$this->set('inc_navi', fetch_inc_navi('h'));
$this->set('kind', $kind);
$limit = 10;
switch ($kind) {
case "friend":
$list = pne_cache_call(3600, 'db_ranking_c_friend_ranking', $limit);
foreach ($list as $key => $value) {
$list[$key]['c_member'] = db_member_c_member_with_profile($value['c_member_id']);
}
break;
case "com_member":
$list = pne_cache_call(3600, 'db_ranking_c_commu_member_ranking', $limit);
foreach ($list as $key => $value) {
$list[$key]['c_commu'] = db_commu_c_commu4c_commu_id($value['c_commu_id']);
}
break;
case "com_comment":
$list = pne_cache_call(3600, 'db_ranking_c_commu_topic_comment_ranking', $limit);
foreach ($list as $key => $value) {
$list[$key]['c_commu'] = db_commu_c_commu4c_commu_id($value['c_commu_id']);
}
break;
case "ashiato":
default:
$list = pne_cache_call(3600, 'db_ranking_c_ashiato_ranking', $limit);
foreach ($list as $key => $value) {
$list[$key]['c_member'] = db_member_c_member_with_profile($value['c_member_id']);
if (!$list[$key]['c_member']) {
unset($list[$key]);
}
}
break;
}
$rank_list = array();
if ($list) {
$rank = 1;
$current_count = null;
foreach ($list as $item) {
if ($item['count'] != $current_count) {
$rank = $rank + count($rank_list[$rank]);
$current_count = $item['count'];
}
$rank_list[$rank][] = $item;
}
}
$this->set("rank_list", $rank_list);
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['KTAI_C_MEMBER_ID'];
// --- リクエスト変数
$target_c_member_id = $requests['target_c_member_id'];
// ----------
if ($target_c_member_id == $u) {
openpne_redirect('ktai', 'page_h_home');
}
if (!db_member_is_active_c_member_id($target_c_member_id)) {
ktai_display_error('該当するメンバーが見つかりません。');
}
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_f_home'));
//ターゲットのc_member
$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');
$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_diary_list", db_diary_get_c_diary_list4c_member_id($target_c_member_id, 5, $u));
//フレンドランダム５人
$this->set("c_friend_list", db_friend_c_friend_list_random4c_member_id($target_c_member_id, 5));
//参加コミュニティ最新書き込み５件
$this->set("c_commu_list", db_commu_c_commu_list_lastupdate4c_member_id($target_c_member_id, 5));
//共通コミュニティ
$this->set('common_commu_count', count(db_common_commu_common_commu_id4c_member_id($target_c_member_id, $u)));
//ターゲットと自分との関係
$this->set("relation", db_friend_relationship4two_members($u, $target_c_member_id));
$is_friend = db_friend_is_friend($u, $target_c_member_id);
if ($is_friend) {
$this->set('is_friend', $is_friend);
} else {
$this->set('friend_path', db_friend_friend_path4c_member_ids($u, $target_c_member_id));
}
$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_ktai_entry_point', fetch_inc_entry_point($this->getView(), 'ktai_f_home'));
//あしあとをつける
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['KTAI_C_MEMBER_ID'];
if (!OPENPNE_USE_RANKING) {
ktai_display_error(SNS_NAME . 'では、ランキングの閲覧はおこなえません');
}
// --- リクエスト変数
$kind = $requests['kind'];
// ----------
$this->set('kind', $kind);
$limit = 10;
switch ($kind) {
case "friend":
$list = pne_cache_call(3600, 'db_ranking_c_friend_ranking', $limit);
foreach ($list as $key => $value) {
$list[$key]['c_member'] = db_member_c_member_with_profile($value['c_member_id']);
}
break;
case "com_member":
$list = pne_cache_call(3600, 'db_ranking_c_commu_member_ranking', $limit);
foreach ($list as $key => $value) {
$list[$key]['c_commu'] = db_commu_c_commu4c_commu_id($value['c_commu_id']);
}
break;
case "com_comment":
$list = pne_cache_call(3600, 'db_ranking_c_commu_topic_comment_ranking', $limit);
foreach ($list as $key => $value) {
$list[$key]['c_commu'] = db_commu_c_commu4c_commu_id($value['c_commu_id']);
}
break;
case "ashiato":
default:
$list = pne_cache_call(3600, 'db_ranking_c_ashiato_ranking', $limit);
foreach ($list as $key => $value) {
$list[$key]['c_member'] = db_member_c_member_with_profile($value['c_member_id']);
if (!$list[$key]['c_member']) {
unset($list[$key]);
}
}
break;
}
$rank_list = array();
if ($list) {
$rank = 1;
$current_count = null;
foreach ($list as $item) {
if ($item['count'] != $current_count) {
$rank = $rank + count($rank_list[$rank]);
$current_count = $item['count'];
}
$rank_list[$rank][] = $item;
}
}
$this->set("rank_list", $rank_list);
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['KTAI_C_MEMBER_ID'];
$prof = db_member_c_member_with_profile($u);
$this->set('c_member', $prof);
// --- リクエスト変数
$img_num = $requests['img_num'];
// ----------
$this->set("img_num", $img_num);
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['KTAI_C_MEMBER_ID'];
$this->set("c_member", db_member_c_member4c_member_id($u));
$prof = db_member_c_member_with_profile($u, 'private');
$this->set('c_member', $prof);
$public_flags = array('public' => '全員に公開', 'friend' => WORD_MY_FRIEND_HALF . 'まで公開', 'private' => '公開しない');
$this->set('public_flags', $public_flags);
$this->set('profile_list', db_member_c_profile_list());
$this->set('month', p_regist_prof_c_profile_month_list4null());
$this->set('day', p_regist_prof_c_profile_day_list4null());
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['KTAI_C_MEMBER_ID'];
$prof = db_member_c_member_with_profile($u);
$this->set('c_member', $prof);
if (MAIL_ADDRESS_HASHED) {
$mail_address = "p{$u}-" . t_get_user_hash($u) . "@" . MAIL_SERVER_DOMAIN;
} else {
$mail_address = "p{$u}" . "@" . MAIL_SERVER_DOMAIN;
}
$mail_address = MAIL_ADDRESS_PREFIX . $mail_address;
$this->set('mail_address', $mail_address);
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['KTAI_C_MEMBER_ID'];
// --- リクエスト変数
$target_c_commu_id = $requests['target_c_commu_id'];
$target_c_member_id = $requests['target_c_member_id'];
$body = $requests['body'];
// ----------
//--- 権限チェック
// コミュニティ管理者
// コミュニティ副管理者ではない
// 自分自身へのメッセージ送信ではない
// すでに管理者交代依頼メッセージ送信済みではない
// すでに副管理者要請メッセージを送信済みでない
if (!db_commu_is_c_commu_admin($target_c_commu_id, $u)) {
handle_kengen_error();
}
if (db_commu_is_c_commu_sub_admin($target_c_commu_id, $u)) {
handle_kengen_error();
}
if ($u == $target_c_member_id) {
handle_kengen_error();
}
$target_c_commu_admin_confirm_list = db_commu_anatani_c_commu_admin_confirm_list4c_member_id($target_c_member_id);
if (!empty($target_c_commu_admin_confirm_list)) {
foreach ($target_c_commu_admin_confirm_list as $value) {
if ($value['c_commu_id'] == $target_c_commu_id) {
handle_kengen_error();
}
}
}
$target_c_commu_sub_admin_confirm_list = db_commu_anatani_c_commu_sub_admin_confirm_list4c_member_id($target_c_member_id);
if (!empty($target_c_commu_sub_admin_confirm_list)) {
foreach ($target_c_commu_sub_admin_confirm_list as $value) {
if ($value['c_commu_id'] == $target_c_commu_id) {
handle_kengen_error();
}
}
}
//---
$this->set('inc_navi', fetch_inc_navi("c", $target_c_commu_id));
$member = db_member_c_member_with_profile($target_c_member_id);
$member['last_login'] = p_f_home_last_login4access_date($member['access_date']);
$this->set("member", $member);
$this->set("c_commu", db_commu_c_commu4c_commu_id($target_c_commu_id));
$this->set('body', $body);
return 'success';
}
function _getRanking($kind)
{
$limit = 10;
switch ($kind) {
case "friend":
$list = pne_cache_call(3600, 'db_ranking_c_friend_ranking', $limit);
foreach ($list as $key => $value) {
$list[$key]['c_member'] = db_member_c_member_with_profile($value['c_member_id']);
}
break;
case "com_member":
$list = pne_cache_call(3600, 'db_ranking_c_commu_member_ranking', $limit);
foreach ($list as $key => $value) {
$list[$key]['c_commu'] = db_commu_c_commu4c_commu_id($value['c_commu_id']);
}
break;
case "com_comment":
$list = pne_cache_call(3600, 'db_ranking_c_commu_topic_comment_ranking', $limit);
foreach ($list as $key => $value) {
$list[$key]['c_commu'] = db_commu_c_commu4c_commu_id($value['c_commu_id']);
}
break;
case "ashiato":
default:
$list = pne_cache_call(3600, 'db_ranking_c_ashiato_ranking', $limit);
foreach ($list as $key => $value) {
$list[$key]['c_member'] = db_member_c_member_with_profile($value['c_member_id']);
if (!$list[$key]['c_member']) {
unset($list[$key]);
}
}
break;
}
$rank_list = array();
if ($list) {
$rank = 1;
$current_count = null;
foreach ($list as $item) {
if ($item['count'] != $current_count) {
$rank = $rank + count($rank_list[$rank]);
$current_count = $item['count'];
}
$rank_list[$rank][] = $item;
}
}
return $rank_list;
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$prof = $_REQUEST['prof'];
// ----------
$this->set('inc_navi', fetch_inc_navi('h'));
if (!$prof) {
$prof = db_member_c_member_with_profile($u, 'private');
$OPTION = $this->get('C_MEMBER_CONFIG');
$prof['is_search_result'] = $OPTION['IS_SEARCH_RESULT'];
}
$this->set('c_member', $prof);
$this->set('month', p_regist_prof_c_profile_month_list4null());
$this->set('day', p_regist_prof_c_profile_day_list4null());
$public_flags = array('public' => '全員に公開', 'friend' => WORD_MY_FRIEND . 'まで公開', 'private' => '公開しない');
$this->set('public_flags', $public_flags);
$this->set('profile_list', db_member_c_profile_list());
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['KTAI_C_MEMBER_ID'];
// --- リクエスト変数
$target_c_member_id = $u;
// ----------
$this->set('is_h_prof', 1);
//管理画面HTML
$this->set('c_siteadmin', p_common_c_siteadmin4target_pagename('k_f_home'));
$target_c_member = db_member_c_member_with_profile($target_c_member_id, 'private');
$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_diary_list', db_diary_get_c_diary_list4c_member_id($target_c_member_id, 5, null, 'friend'));
//フレンドランダム５人
$this->set("c_friend_list", db_friend_c_friend_list_random4c_member_id($target_c_member_id, 5));
//参加コミュニティ最新書き込み５件
$this->set("c_commu_list", db_commu_c_commu_list_lastupdate4c_member_id($target_c_member_id, 5));
//共通コミュニティ
$this->set('common_commu_count', count(db_common_commu_common_commu_id4c_member_id($target_c_member_id, $u)));
$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_ktai_entry_point', fetch_inc_entry_point($this->getView(), 'ktai_f_home'));
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['KTAI_C_MEMBER_ID'];
// --- リクエスト変数
$target_c_member_id = $requests['target_c_member_id'];
// ----------
$is_h = 0;
if ($target_c_member_id == $u || empty($target_c_member_id)) {
$target_c_member_id = $u;
$is_h = 1;
}
if (!$is_h) {
if (!db_member_is_active_c_member_id($target_c_member_id)) {
ktai_display_error('該当するメンバーが見つかりません。');
}
if (db_member_is_access_block($u, $target_c_member_id)) {
openpne_redirect('ktai', 'page_h_access_block');
}
//あしあとをつける
db_ashiato_insert_c_ashiato($target_c_member_id, $u);
}
$is_friend = db_friend_is_friend($u, $target_c_member_id);
if ($is_h || $is_friend) {
$target_c_member = db_member_c_member_with_profile($target_c_member_id, 'friend');
} else {
$target_c_member = db_member_c_member_with_profile($target_c_member_id, 'public');
}
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('is_h', $is_h);
$this->set('target_c_member', $target_c_member);
$this->set('profile_list', db_member_c_profile_list());
$this->set('relation', db_friend_relationship4two_members($u, $target_c_member_id));
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$target_c_commu_id = $requests['target_c_commu_id'];
$target_c_member_id = $requests['target_c_member_id'];
// ----------
//--- 権限チェック
//コミュニティ管理者
//コミュニティ副管理者ではない
if (!db_commu_is_c_commu_admin($target_c_commu_id, $u)) {
handle_kengen_error();
}
if (db_commu_is_c_commu_sub_admin($target_c_commu_id, $u)) {
handle_kengen_error();
}
//---
$this->set('inc_navi', fetch_inc_navi("c", $target_c_commu_id));
$member = db_member_c_member_with_profile($target_c_member_id);
$member['last_login'] = p_f_home_last_login4access_date($member['access_date']);
$this->set("member", $member);
$this->set("c_commu", db_commu_c_commu4c_commu_id($target_c_commu_id));
return 'success';
}
function db_common_c_member_with_profile($c_member_id, $public_flag = 'public')
{
return db_member_c_member_with_profile($c_member_id, $public_flag);
}
function db_member_search($cond, $cond_like, $page_size, $page, $c_member_id, $profiles)
{
$page = intval($page);
$page_size = intval($page_size);
$wheres = array();
$params = array();
foreach ($cond as $key => $value) {
if ($value) {
if ($key === 'image') {
$wheres[] = "image_filename <> '' AND image_filename <> '0'";
} else {
$wheres[] = db_escapeIdentifier($key) . ' = ?';
$params[] = $value;
if ($key === 'birth_year') {
$wheres[] = "public_flag_birth_year = 'public'";
} elseif ($key === 'birth_month' || $key === 'birth_day') {
$wheres[] = "public_flag_birth_month_day = 'public'";
}
}
}
}
foreach ($cond_like as $key => $value) {
if ($value) {
$wheres[] = db_escapeIdentifier($key) . ' LIKE ?';
$params[] = '%' . $value . '%';
}
}
if ($wheres) {
$where = ' WHERE ' . implode(' AND ', $wheres);
} else {
$where = '';
}
$from = " FROM c_member" . $hint;
$order = " ORDER BY c_member_id DESC";
$sql = "SELECT c_member_id" . $from . $where . $order;
$result_ids = db_get_col($sql, $params);
// 検索設定を公開にしていないメンバーを除外
$sql = "SELECT c_member_id FROM c_member_config WHERE name = 'IS_SEARCH_RESULT' AND value = '0'";
$ids = db_get_col($sql);
$result_ids = array_diff($result_ids, $ids);
foreach ($profiles as $key => $value) {
$sql = "SELECT c_member_id FROM c_member_profile";
$sql .= " WHERE c_profile_id = ? AND public_flag = 'public'";
$params = array(intval($value['c_profile_id']));
if ($value['form_type'] == "text" || $value['form_type'] == "textlong" || $value['form_type'] == 'textarea') {
$sql .= " AND value LIKE ?";
$params[] = '%' . $value['value'] . '%';
} elseif (is_array($value['c_profile_option_id'])) {
$values = implode(',', array_map('intval', $value['c_profile_option_id']));
$sql .= " AND c_profile_option_id IN (" . $values . ")";
} else {
$sql .= " AND c_profile_option_id = ?";
$params[] = intval($value['c_profile_option_id']);
}
$ids = db_get_col($sql, $params);
$result_ids = array_intersect($result_ids, $ids);
}
$result_ids = array_values($result_ids);
$start = ($page - 1) * $page_size;
$list = array();
for ($i = $start; $i < $start + $page_size && $result_ids[$i]; $i++) {
$c_member = db_member_c_member_with_profile($result_ids[$i], 'public');
$c_member['last_login'] = p_f_home_last_login4access_date($c_member['access_date']);
$list[] = $c_member;
}
$total_num = count($result_ids);
if ($total_num != 0) {
$total_page_num = ceil($total_num / $page_size);
if ($page >= $total_page_num) {
$next = false;
} else {
$next = $page + 1;
}
if ($page <= 1) {
$prev = false;
} else {
$prev = $page - 1;
}
}
return array($list, $prev, $next, $total_num);
}
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 db_admin_album_list4c_album_id($c_album_id, $page_size, $page)
{
$page = intval($page);
$page_size = intval($page_size);
$where = " WHERE c_album_id = ? ";
$params[] = intval($c_album_id);
$select = "SELECT c_album.*";
$from = " FROM c_album";
$order = " ORDER BY r_datetime DESC";
$sql = $select . $from . $where . $order;
$list = db_get_all_limit($sql, ($page - 1) * $page_size, $page_size, $params);
foreach ($list as $key => $value) {
$list[$key]['c_member'] = db_member_c_member_with_profile($value['c_member_id']);
$list[$key]['count_images'] = db_admin_album_count_c_album_image4c_album_id($value['c_album_id']);
}
$sql = "SELECT COUNT(*) " . $from . $where;
$total_num = db_get_one($sql, $params);
$total_page_num = ceil($total_num / $page_size);
$next = $page < $total_page_num;
$prev = $page > 1;
return array($list, $prev, $next, $total_num, $total_page_num);
}
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 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';
}
/**
* 新着日記検索
* 検索ポイントはタイトル、本文
* 空白（全角半角問わない）でand検索可
*/
function p_h_diary_list_all_search_c_diary4c_diary($keyword, $page_size, $page, $c_member_id = '')
{
$params = array();
$select = 'SELECT *';
$from = ' FROM c_diary';
//自分の日記だけを対象にする事もできる
if ($c_member_id) {
$where = ' WHERE c_member_id = ?';
$params[] = intval($c_member_id);
} else {
$where = " WHERE public_flag = 'public'";
}
//and検索を実装
//subject,body を検索
if ($keyword) {
//全角空白を半角に統一
$keyword = str_replace(' ', ' ', $keyword);
$keyword_list = explode(' ', $keyword);
foreach ($keyword_list as $word) {
$word = check_search_word($word);
$where .= ' AND (subject LIKE ? OR body LIKE ?)';
$params[] = '%' . $word . '%';
$params[] = '%' . $word . '%';
}
}
$order = " ORDER BY r_datetime DESC";
$sql = $select . $from . $where . $order;
$list = db_get_all_page($sql, $page, $page_size, $params);
foreach ($list as $key => $value) {
$list[$key]['c_member'] = db_member_c_member_with_profile($value['c_member_id']);
$list[$key]['num_comment'] = db_diary_count_c_diary_comment4c_diary_id($value['c_diary_id']);
}
$sql = 'SELECT COUNT(*)' . $from . $where;
$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;
}
}
return array($list, $prev, $next, $total_num);
}
