Example #1
0
function p_common_c_friend4c_member_id_from4c_member_id_to($c_member_id_from, $c_member_id_to)
{
    return db_friend_c_friend4c_member_id_from4c_member_id_to($c_member_id_from, $c_member_id_to);
}
Example #2
0
function db_friend_c_friend_list_disp4c_member_id($c_member_id, $page = 1, $size = 20)
{
    $sql = "SELECT c_member_id," . "image_filename," . "nickname," . "intro," . "c_member_id_from," . "c_member_id_to," . "is_display_friend_home" . " FROM c_member," . "c_friend" . " WHERE c_member.c_member_id = c_friend.c_member_id_to" . " AND c_friend.c_member_id_from = ?" . " ORDER BY c_friend.r_datetime DESC";
    $params = array(intval($c_member_id));
    $c_friend_list = db_get_all_page($sql, $page, $size, $params);
    foreach ($c_friend_list as $key => $value) {
        $c_friend = db_friend_c_friend4c_member_id_from4c_member_id_to($value['c_member_id_from'], $value['c_member_id_to']);
        $c_friend_list[$key]['intro'] = $c_friend['intro'];
        $c_friend_list[$key]['friend_count'] = db_friend_count_friends($value['c_member_id_to']);
    }
    $total_num = db_friend_count_friends($c_member_id);
    $prev = 0;
    $next = 0;
    if ($total_num) {
        $total_page_num = ceil($total_num / $size);
        if ($page < $total_page_num) {
            $next = $page + 1;
        }
        if ($page > 1) {
            $prev = $page - 1;
        }
    }
    return array($c_friend_list, $prev, $next, $total_num);
}