304 lines
14 KiB
PHP
304 lines
14 KiB
PHP
<?php
|
|
|
|
/* $Id: event.php 257 2009-11-20 20:30:53Z jung $ */
|
|
|
|
$page = "event";
|
|
|
|
include "header.php";
|
|
|
|
$task = ( !empty($_POST['task']) ? $_POST['task'] : ( !empty($_GET['task']) ? $_GET['task'] : NULL ) );
|
|
$event_id = ( !empty($_POST['event_id']) ? $_POST['event_id'] : ( !empty($_GET['event_id']) ? $_GET['event_id'] : NULL ) );
|
|
$v = ( !empty($_POST['v']) ? $_POST['v'] : ( !empty($_GET['v']) ? $_GET['v'] : NULL ) );
|
|
$p = ( !empty($_POST['p']) ? $_POST['p'] : ( !empty($_GET['p']) ? $_GET['p'] : 1 ) );
|
|
|
|
$v_members = ( isset($_POST['v_members']) ? $_POST['v_members'] : ( isset($_GET['v_members']) ? $_GET['v_members'] : NULL ) );
|
|
$search_members = ( !empty($_POST['search_members']) ? $_POST['search_members'] : ( !empty($_GET['search_members']) ? $_GET['search_members'] : NULL ) );
|
|
if(isset($_POST['media_id'])) { $media_id = $_POST['media_id']; } elseif(isset($_GET['media_id'])) { $media_id = $_GET['media_id']; } else { $media_id = ""; }
|
|
|
|
if($task=="make_photo")
|
|
{
|
|
|
|
|
|
$media_query = $database->database_query("SELECT se_eventmedia.*, se_eventalbums.*, se_events.event_id FROM se_eventmedia LEFT JOIN se_eventalbums ON se_eventmedia.eventmedia_eventalbum_id=se_eventalbums.eventalbum_id LEFT JOIN se_events ON se_eventalbums.eventalbum_event_id=se_events.event_id WHERE se_eventmedia.eventmedia_id='".$database->database_real_escape_string($media_id)."' AND se_eventalbums.eventalbum_event_id='".$database->database_real_escape_string($event_id)."' AND se_events.event_user_id='".$user->user_info["user_id"]."' LIMIT 1");
|
|
if($database->database_num_rows($media_query)>0)
|
|
{
|
|
$row=$database->database_fetch_array($media_query);
|
|
$database->database_query("UPDATE se_events SET event_photo='".$row["eventmedia_id"].".".$row["eventmedia_ext"]."' WHERE event_id='".$database->database_real_escape_string($event_id)."' AND se_events.event_user_id='".$user->user_info["user_id"]."' LIMIT 1");
|
|
}
|
|
|
|
}
|
|
|
|
// DISPLAY ERROR PAGE IF USER IS NOT LOGGED IN AND ADMIN SETTING REQUIRES REGISTRATION
|
|
if( (!$user->user_exists && !$setting['setting_permission_event']) || ($user->user_exists && (1 & ~$user->level_info['level_event_allow'])) )
|
|
{
|
|
$page = "error";
|
|
$smarty->assign('error_header', 639);
|
|
$smarty->assign('error_message', 656);
|
|
$smarty->assign('error_submit', 641);
|
|
include "footer.php";
|
|
}
|
|
|
|
|
|
// DISPLAY ERROR PAGE IF NO OWNER
|
|
$event = new se_event($user->user_info['user_id'], $event_id);
|
|
|
|
if( !$event->event_exists )
|
|
{
|
|
$page = "error";
|
|
$smarty->assign('filenotfound', 1);
|
|
$smarty->assign('item', 'event');
|
|
include "footer.php";
|
|
}
|
|
|
|
|
|
// GET PRIVACY LEVEL
|
|
$privacy_max = $event->event_privacy_max($user);
|
|
$allowed_to_view = (bool) ( $privacy_max & $event->event_info['event_privacy'] );
|
|
$allowed_to_comment = (bool) ( $privacy_max & $event->event_info['event_comments'] );
|
|
$allowed_to_upload = (bool) ( $privacy_max & $event->event_info['event_upload'] );
|
|
$allowed_to_invite = (bool) ( $event->event_info['event_user_id']==$user->user_info['user_id'] );
|
|
|
|
// UPDATE EVENT VIEWS IF EVENT VISIBLE
|
|
if( $allowed_to_view )
|
|
{
|
|
$event->event_info['event_views']++;
|
|
$sql = "UPDATE se_events SET event_views=event_views+1 WHERE event_id='{$event->event_info['event_id']}' LIMIT 1";
|
|
$database->database_query($sql);
|
|
}
|
|
|
|
|
|
// DELETE COMMENT NOTIFICATIONS /*IF VIEWING COMMENT PAGE*/
|
|
if( $user->user_info['user_id']==$event->event_info['event_user_id'])
|
|
{
|
|
//$sql = "DELETE FROM se_notifys USING se_notifys LEFT JOIN se_notifytypes ON se_notifys.notify_notifytype_id=se_notifytypes.notifytype_id WHERE se_notifys.notify_user_id='{$event->event_info['event_user_id']}' AND se_notifytypes.notifytype_name='eventcomment' AND notify_object_id='{$event->event_info[event_id]}'";
|
|
|
|
|
|
$sql = "UPDATE se_notifys LEFT JOIN se_notifytypes ON se_notifys.notify_notifytype_id=se_notifytypes.notifytype_id SET isread=1 WHERE se_notifys.notify_user_id='{$event->event_info['event_user_id']}' AND se_notifytypes.notifytype_name='eventcomment' AND notify_object_id='{$event->event_info[event_id]}'";
|
|
$database->database_query($sql);
|
|
}
|
|
|
|
|
|
// GET EVENT MEDIA
|
|
$eventalbum_info = $database->database_fetch_assoc($database->database_query("SELECT eventalbum_id FROM se_eventalbums WHERE eventalbum_event_id='{$event->event_info['event_id']}' LIMIT 1"));
|
|
|
|
|
|
// GET EVENT FIELDS
|
|
$eventcat_info = $database->database_fetch_assoc($database->database_query("SELECT t1.eventcat_id AS subcat_id, t1.eventcat_title AS subcat_title, t1.eventcat_dependency AS subcat_dependency, t2.eventcat_id AS cat_id, t2.eventcat_title AS cat_title FROM se_eventcats AS t1 LEFT JOIN se_eventcats AS t2 ON t1.eventcat_dependency=t2.eventcat_id WHERE t1.eventcat_id='{$event->event_info['event_eventcat_id']}'"));
|
|
if($eventcat_info['subcat_dependency'] == 0) { $cat_where = "eventcat_id='{$event->event_info['event_eventcat_id']}'"; } else { $cat_where = "eventcat_id='{$eventcat_info['subcat_dependency']}'"; }
|
|
$field = new se_field("event", $event->eventvalue_info);
|
|
$field->cat_list(0, 1, 0, $cat_where, "eventcat_id='0'", "");
|
|
|
|
|
|
// MAKE MEMBER PAGES AND GET TOTAL MEMBERS AND GET MEMBER ARRAY
|
|
$members_where_clause = array();
|
|
|
|
if( $v_members>0 )
|
|
$members_where_clause[] = "se_eventmembers.eventmember_approved=1 && se_eventmembers.eventmember_rsvp='{$v_members}'";
|
|
|
|
if( $v_members==="0" )
|
|
$members_where_clause[] = "se_eventmembers.eventmember_rsvp='{$v_members}'";
|
|
|
|
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_approved=1)";
|
|
|
|
$total_members = $event->event_member_total("(se_eventmembers.eventmember_approved=1)", TRUE);
|
|
|
|
$members_per_page = 10;
|
|
if($v == "members") { $p_members = $p; } else { $p_members = 1; }
|
|
|
|
|
|
//$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_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)");
|
|
|
|
if($v_members=="0"){$total_members=$total_members_waiting;}
|
|
elseif($v_members=="1"){$total_members=$total_members_attending;}
|
|
elseif($v_members=="2"){$total_members=$total_members_maybeattending;}
|
|
elseif($v_members=="3"){$total_members=$total_members_notattending;}
|
|
|
|
|
|
$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);
|
|
|
|
$maxpages=ceil($total_members/$members_per_page);
|
|
// 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'];
|
|
}
|
|
|
|
|
|
// SET GLOBAL PAGE TITLE
|
|
$global_page_title[0] = 3000272;
|
|
$global_page_title[1] = $event->event_info['event_title'];
|
|
$global_page_description[0] = 3000273;
|
|
$global_page_description[1] = $event->event_info['event_desc'];
|
|
|
|
|
|
|
|
|
|
// ########### CALENDAR ###########
|
|
/*
|
|
$event_day_start = $event->event_info['event_date_start'];
|
|
$event_day_end = $event->event_info['event_date_end'];
|
|
|
|
$event_day_start = $datetime->timezone($event_day_start, $global_timezone);
|
|
$event_day_end = $datetime->timezone($event_day_end, $global_timezone);
|
|
|
|
$event_day_start = mktime(0, 0, 0, date("m", $event_day_start), date("j", $event_day_start), date("Y", $event_day_start));
|
|
if( $event->event_info['event_date_end'] )
|
|
$event_day_end = mktime(0, 0, 0, date("m", $event_day_end), date("j", $event_day_end), date("Y", $event_day_end) );
|
|
else
|
|
$event_day_end = $event_day_start;
|
|
|
|
// CALENDAR YEAR LOOP
|
|
$calendar_data = array(
|
|
'today_year' => mktime(0, 0, 0, 1, 1, date("Y", time())),
|
|
'today_month' => mktime(0, 0, 0, date("m", time()), 1, date("Y", time())),
|
|
'today_day' => date('j', time()),
|
|
'years' => array()
|
|
);
|
|
|
|
//for( $day_time_value=$event_day_start; $day_time_value<=$event_day_end+86400; $day_time_value+=86400 )
|
|
for( $day_time_value_raw=$event_day_start; $day_time_value_raw<=$event_day_end; $day_time_value_raw+=86400 )
|
|
{
|
|
$day_time_value = $day_time_value_raw;
|
|
$year_time_value = mktime(0, 0, 0, 1, 1, date("Y", $day_time_value));
|
|
$month_time_value = mktime(0, 0, 0, date("m", $day_time_value), 1, date("Y", $day_time_value));
|
|
|
|
if( !isset($calendar_data['years'][$year_time_value]) )
|
|
{
|
|
$calendar_data['years'][$year_time_value] = array(
|
|
'name' => htmlentities($datetime->cdate("Y", $year_time_value), NULL, 'utf-8'),
|
|
'months' => array()
|
|
);
|
|
}
|
|
|
|
$loop_year_data =& $calendar_data['years'][$year_time_value];
|
|
|
|
if( !isset($loop_year_data['months'][$month_time_value]) )
|
|
{
|
|
$loop_year_data['months'][$month_time_value] = array();
|
|
}
|
|
|
|
$loop_month_data =& $loop_year_data['months'][$month_time_value];
|
|
|
|
if( !isset($loop_month_data['name']) )
|
|
{
|
|
$loop_month_data['days'] = array();
|
|
$loop_month_data['name'] = htmlentities($datetime->cdate("F", $month_time_value), NULL, 'utf-8');
|
|
|
|
$loop_month_data['days_in_month'] = date('t', $month_time_value);
|
|
$loop_month_data['first_day_of_month'] = date("w", $month_time_value);
|
|
if( $loop_month_data['first_day_of_month']==0 ) $loop_month_data['first_day_of_month'] = 7;
|
|
$loop_month_data['last_day_of_month'] = ($loop_month_data['first_day_of_month'] - 1) + $loop_month_data['days_in_month'];
|
|
|
|
$loop_month_data['total_cells'] = (floor($loop_month_data['last_day_of_month'] / 7) + 1) * 7;
|
|
}
|
|
|
|
$loop_month_data['days'][] = date('j', $day_time_value);
|
|
|
|
unset($loop_year_data, $loop_month_data);
|
|
}
|
|
|
|
|
|
// ASSIGN
|
|
$smarty->assign_by_ref('calendar_data', $calendar_data);
|
|
*/
|
|
// ########### CALENDAR ###########
|
|
|
|
|
|
$event->event_info['event_desc'] = html_entity_decode($event->event_info['event_desc'], ENT_QUOTES);
|
|
|
|
|
|
if(isset($_POST['favorites'])) { $fave = $_POST['favorites']; } elseif(isset($_GET['favorites'])) { $fave = $_GET['favorites']; } else { $fave = 0; }
|
|
|
|
|
|
|
|
if($fave==="delete"){
|
|
|
|
$database->database_query("DELETE FROM favorites WHERE user='".$user->user_info["user_id"]."' AND type='event' AND owner='".$event_id."' AND objectid='".$event_id."'");
|
|
|
|
}
|
|
|
|
|
|
if($fave==="addto"){
|
|
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND type='event' AND owner='".$event_id."' AND objectid='".$event_id."'");
|
|
|
|
if($database->database_num_rows($query)==0){
|
|
$database->database_query("INSERT INTO favorites SET user='".$user->user_info["user_id"]."', type='event', owner='".$event_id."', objectid='".$event_id."'");
|
|
}
|
|
}
|
|
|
|
for($x=$page_vars_members[1]; $x<=$page_vars_members[2]; $x++)
|
|
{
|
|
|
|
if(($page_vars_members[1]+10)==$x)
|
|
{break;}
|
|
$for[$y]=$x;
|
|
$y++;
|
|
}
|
|
|
|
$smarty->assign('for', $for);
|
|
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND type='event' AND owner='".$event_id."' AND objectid='".$event_id."'");
|
|
if($database->database_num_rows($query)>0){$smarty->assign('favorites1', 1);}
|
|
|
|
$smarty->assign('favorites', 1);
|
|
|
|
// ASSIGN VARIABLES AND DISPLAY EVENT PAGE
|
|
$smarty->assign_by_ref('event', $event);
|
|
$smarty->assign_by_ref('eventcat_info', $eventcat_info);
|
|
$smarty->assign_by_ref('eventalbum_info', $eventalbum_info);
|
|
$smarty->assign_by_ref('cats', $field->cats);
|
|
$smarty->assign_by_ref('members', $members);
|
|
$smarty->assign_by_ref('officers', $officers);
|
|
|
|
$smarty->assign('v', $v);
|
|
$smarty->assign('search', $search);
|
|
|
|
$smarty->assign('allowed_to_view', $allowed_to_view);
|
|
$smarty->assign('allowed_to_comment', $allowed_to_comment);
|
|
$smarty->assign('allowed_to_upload', $allowed_to_upload);
|
|
$smarty->assign('allowed_to_invite', $allowed_to_invite);
|
|
|
|
$smarty->assign('total_members', $total_members);
|
|
$smarty->assign('maxpage_members', $maxpages);//$page_vars_members[2]);
|
|
$smarty->assign('p_start_members', $page_vars_members[0]+1);
|
|
$smarty->assign('p_end_members', $page_vars_members[0]+count($members));
|
|
$smarty->assign('p_members', $page_vars_members[1]);
|
|
$smarty->assign('v_members', $v_members);
|
|
$smarty->assign('search_members', $search_members);
|
|
|
|
$smarty->assign('total_members_waiting', $total_members_waiting);
|
|
$smarty->assign('total_members_attending', $total_members_attending);
|
|
$smarty->assign('total_members_maybeattending', $total_members_maybeattending);
|
|
$smarty->assign('total_members_notattending', $total_members_notattending);
|
|
|
|
$smarty->assign_by_ref('actions', $actions->actions_display(0, $setting['setting_actions_actionsonprofile'], "se_actions.action_object_owner='event' AND se_actions.action_object_owner_id='{$event->event_info['event_id']}'"));
|
|
|
|
include "footer.php";
|
|
?>
|