$where_clause[] = "se_eventmembers.eventmember_status=0 && se_eventmembers.eventmember_approved=1"; } if ($v == -2) { $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);
} if ($v_members == -1) { $members_where_clause[] = "se_eventmembers.eventmember_status=0 && se_eventmembers.eventmember_approved=1"; } if ($v_members == -2) { $members_where_clause[] = "se_eventmembers.eventmember_status=1 && se_eventmembers.eventmember_approved=0"; } //if( !empty($search_members) ) // $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