50 lines
2.6 KiB
PHP
50 lines
2.6 KiB
PHP
<?php
|
|
/* $Id: home.php 8 2009-01-11 06:02:53Z john $ */
|
|
$includeevent=true;
|
|
include "header-ajax.php";
|
|
$page = 'latestevents';
|
|
|
|
//EVENTS
|
|
$s_events="event_totalmembers DESC";
|
|
$v_events=3;
|
|
$p_events=1;
|
|
// SET WHERE CLAUSE
|
|
$where_events = "CASE
|
|
WHEN se_events.event_user_id='{$user->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";
|
|
?>
|