$where_clause[] = "se_eventmembers.eventmember_status=1 && se_eventmembers.eventmember_approved=0";
}
if (empty($v) && $v !== "0") {
    $where_clause[] = "se_eventmembers.eventmember_status=1 && se_eventmembers.eventmember_approved=1";
}
if (!empty($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}%')";
}
if (!empty($where_clause)) {
    $where = implode(" && ", $where_clause);
}
// GET TOTAL MEMBERS
$total_members = $event->event_member_total($where, TRUE);
// MAKE MEMBER PAGES
$members_per_page = 10;
$page_vars = make_page($total_members, $members_per_page, $p);
// GET MEMBER ARRAY
$members = $event->event_member_list($page_vars[0], $members_per_page, $s, $where);
// ASSIGN VARIABLES AND SHOW USER EDIT EVENT MEMBERS PAGE
$smarty->assign_by_ref('event', $event);
$smarty->assign_by_ref('members', $members);
$smarty->assign('total_members', $total_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));
$smarty->assign('result', $result);
include "footer.php";
예제 #2
0
//  $members_where_clause[] = "(se_users.user_username LIKE '%{$search_members}%' OR se_users.user_email LIKE '%{$search_members}%' OR CONCAT(se_users.user_fname, ' ', se_users.user_lname) LIKE '%{$search_members}%')";
if (!empty($members_where_clause)) {
    $members_where = implode(" && ", $members_where_clause);
} else {
    $members_where = "(se_eventmembers.eventmember_status=1 && se_eventmembers.eventmember_approved=1)";
}
//echo $members_where;
$total_members = $event->event_member_total($members_where, TRUE);
$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 = $event->event_member_list($page_vars_members[0], $members_per_page, "se_users.user_username", $members_where);
//$members = $event->event_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_waiting = $event->event_member_total("(se_eventmembers.eventmember_status=1 && se_eventmembers.eventmember_approved=1 && se_eventmembers.eventmember_rsvp=0)");
$total_members_attending = $event->event_member_total("(se_eventmembers.eventmember_status=1 && se_eventmembers.eventmember_approved=1 && se_eventmembers.eventmember_rsvp=1)");
$total_members_maybeattending = $event->event_member_total("(se_eventmembers.eventmember_status=1 && se_eventmembers.eventmember_approved=1 && se_eventmembers.eventmember_rsvp=2)");
$total_members_notattending = $event->event_member_total("(se_eventmembers.eventmember_status=1 && se_eventmembers.eventmember_approved=1 && se_eventmembers.eventmember_rsvp=3)");
// GET OFFICERS
$where_officers = "se_eventmembers.eventmember_rank>1 AND se_eventmembers.eventmember_status='1' AND se_eventmembers.eventmember_approved='1'";
$total_officers = $event->event_member_total($where_officers, 0);
$officers = $event->event_member_list(0, $total_officers, "se_eventmembers.eventmember_rank DESC, se_users.user_username", $where_officers);
// GET CUSTOM EVENT STYLE IF ALLOWED
if ($event->eventowner_level_info['level_event_style'] && $allowed_to_view) {
    $eventstyle_info = $database->database_fetch_assoc($database->database_query("SELECT eventstyle_css FROM se_eventstyles WHERE eventstyle_event_id='{$event->event_info['event_id']}' LIMIT 1"));
    $global_css = $eventstyle_info['eventstyle_css'];
}