user_info['user_id']}' THEN TRUE WHEN ((se_events.event_privacy & 32) AND '{$user->user_exists}'<>0) THEN TRUE WHEN ((se_events.event_privacy & 64) AND '{$user->user_exists}'=0) THEN TRUE WHEN ((se_events.event_privacy & 2) AND (SELECT TRUE FROM se_eventmembers WHERE eventmember_user_id='{$user->user_info['user_id']}' AND eventmember_event_id=se_events.event_id AND eventmember_status=1 LIMIT 1)) THEN TRUE WHEN ((se_events.event_privacy & 4) AND '{$user->user_exists}'<>0 AND (SELECT TRUE FROM se_friends WHERE friend_user_id1=se_events.event_user_id AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status=1 LIMIT 1)) THEN TRUE WHEN ((se_events.event_privacy & 8) AND '{$user->user_exists}'<>0 AND (SELECT TRUE FROM se_eventmembers LEFT JOIN se_friends ON se_eventmembers.eventmember_user_id=se_friends.friend_user_id1 WHERE se_eventmembers.eventmember_event_id=se_events.event_id AND se_friends.friend_user_id2='{$user->user_info['user_id']}' AND se_eventmembers.eventmember_status=1 AND se_friends.friend_status=1 LIMIT 1)) THEN TRUE WHEN ((se_events.event_privacy & 16) AND '{$user->user_exists}'<>0 AND (SELECT TRUE FROM se_eventmembers LEFT JOIN se_friends AS friends_primary ON se_eventmembers.eventmember_user_id=friends_primary.friend_user_id1 LEFT JOIN se_friends AS friends_secondary ON friends_primary.friend_user_id2=friends_secondary.friend_user_id1 WHERE se_eventmembers.eventmember_event_id=se_events.event_id AND se_eventmembers.eventmember_status=1 AND friends_secondary.friend_user_id2='{$user->user_info['user_id']}' AND friends_primary.friend_status=1 AND friends_secondary.friend_status=1 LIMIT 1)) THEN TRUE ELSE FALSE END"; // SET WHERE CLAUSE $where_events .= " && se_events.event_date_start>'".time()."' "; // Force sort? $s_events = "event_date_start ASC"; // CREATE EVENT OBJECT $event = new se_event(); // GET TOTAL EVENTS $total_events = $event->event_total($where_events); // MAKE ENTRY PAGES $events_per_page = 24; $events_page_vars = make_page($total_events, $events_per_page, $p_events); // GET EVENT ARRAY $event_array = $event->event_list($events_page_vars[0], $events_per_page, $s_events, $where_events, TRUE); // ASSIGN SMARTY VARIABLES AND DISPLAY EVENTS PAGE $smarty->assign('events', $event_array); $smarty->assign('total_events', $total_events); include "footer-ajax.php"; ?>