// SET WHERE CLAUSE FOR MEMBER LIST
$where[] = "(se_groupmembers.groupmember_status='1')";
if ($search != "") {
    $where[] = "(se_users.user_username LIKE '%{$search}%' OR CONCAT(se_users.user_fname, ' ', se_users.user_lname) LIKE '%{$search}%' OR se_users.user_email LIKE '%{$search}%')";
}
// GET TOTAL MEMBERS
$total_members = $group->group_member_total(implode(" AND ", $where), 1);
// MAKE MEMBER PAGES AND GET MEMBER ARRAY
$members_per_page = 10;
if ($v == "members") {
    $p_members = $p;
} else {
    $p_members = 1;
}
$page_vars_members = make_page($total_members, $members_per_page, $p_members);
$members = $group->group_member_list($page_vars_members[0], $members_per_page, "is_viewers_friend DESC, se_users.user_username", implode(" AND ", $where));
// GET MASTER TOTAL OF MEMBERS
$total_members_all = $group->group_member_total("(se_groupmembers.groupmember_status='1')");
// GET OFFICERS
$where_officers = "se_groupmembers.groupmember_rank<>'0' AND se_groupmembers.groupmember_status='1' AND se_groupmembers.groupmember_approved='1'";
$total_officers = $group->group_member_total($where_officers, 0);
$officers = $group->group_member_list(0, $total_officers, "se_groupmembers.groupmember_rank DESC, se_users.user_username", $where_officers);
// CHECK TO SEE IF USER IS SUBSCRIBED TO GROUP AND UPDATE VIEW TIME
if ($database->database_num_rows($database->database_query("SELECT NULL FROM se_groupsubscribes WHERE groupsubscribe_group_id='{$group->group_info['group_id']}' AND groupsubscribe_user_id='{$user->user_info['user_id']}' LIMIT 1")) == 1) {
    $is_subscribed = 1;
    $database->database_query("UPDATE se_groupsubscribes SET groupsubscribe_time='" . time() . "' WHERE groupsubscribe_group_id='{$group->group_info['group_id']}' AND groupsubscribe_user_id='{$user->user_info['user_id']}'");
} else {
    $is_subscribed = 0;
}
// GET TOTAL DISCUSSION TOPICS
$total_topics = $group->group_topic_total();
        break;
    case "3":
        $where_clause[] = "se_groupmembers.groupmember_approved='0'";
        break;
    default:
        $where_clause[] = "se_groupmembers.groupmember_status='1' AND se_groupmembers.groupmember_approved='1'";
        break;
}
if ($search != "") {
    $where_clause[] = "(se_users.user_username LIKE '%{$search}%' OR se_users.user_email LIKE '%{$search}%' OR CONCAT(se_users.user_fname, ' ', se_users.user_lname) LIKE '%{$search}%')";
}
$where = implode(" AND ", $where_clause);
// GET TOTAL MEMBERS
$total_members = $group->group_member_total($where, 1);
// MAKE MEMBER PAGES
$members_per_page = 10;
$page_vars = make_page($total_members, $members_per_page, $p);
// GET MEMBER ARRAY
$members = $group->group_member_list($page_vars[0], $members_per_page, $sort, $where);
// ASSIGN VARIABLES AND SHOW USER EDIT GROUP MEMBERS PAGE
$smarty->assign('group', $group);
$smarty->assign('total_members', $total_members);
$smarty->assign('members', $members);
$smarty->assign('search', $search);
$smarty->assign('s', $s);
$smarty->assign('v', $v);
$smarty->assign('p', $page_vars[1]);
$smarty->assign('maxpage', $page_vars[2]);
$smarty->assign('p_start', $page_vars[0] + 1);
$smarty->assign('p_end', $page_vars[0] + count($members));
include "footer.php";