3000081,
'-1' => 3000080,
'0' => 3000081,
'1' => 3000082,
'2' => 3000083,
'3' => 3000084,
'4' => 3000085
);
//
// THIS METHOD SETS INITIAL VARS
//
// INPUT:
// $user_id (OPTIONAL) REPRESENTING THE USER ID OF THE USER WHOSE EVENTS WE ARE CONCERNED WITH
// $event_id (OPTIONAL) REPRESENTING THE EVENT ID OF THE EVENT WE ARE CONCERNED WITH
//
// OUTPUT:
// void
//
function __construct($user_id=NULL, $event_id=NULL)
{
global $database, $user, $owner;
$this->user_id = $user_id;
$this->event_exists = FALSE;
$this->is_member = FALSE;
$this->is_member_waiting = FALSE;
$this->user_rank = 0;
$this->moderation_privacy = 3;
// RSVP LEVELS
foreach( $this->event_rsvp_levels as $rsvp_level )
SE_Language::_preload($rsvp_level);
// EVENT INFO
if( $event_id )
{
if($_SERVER["PHP_SELF"]=="/bwadmin/eventedit.php"){
$sql = "SELECT *, se_events.province AS province1, se_events.state AS state1 FROM se_events WHERE event_id='{$event_id}' LIMIT 1";
}else{
$sql = "SELECT *, se_events.province AS province1, se_events.state AS state1 FROM se_events WHERE event_id='{$event_id}' AND approved='1' LIMIT 1";
}
$resource = $database->database_query($sql);
if( $database->database_num_rows($resource) )
{
$this->event_exists = TRUE;
$this->event_info = $database->database_fetch_assoc($resource);
$query = $database->database_query("SELECT * FROM bateworldcom_zips.provinces WHERE id='".$this->event_info['province']."'");
$row=$database->database_fetch_assoc($query);
$query1 = $database->database_query("SELECT user_username FROM se_users WHERE user_id='".$this->event_info['event_user_id']."'");
$row1=$database->database_fetch_array($query1);
$this->event_info['owner_username'] = $row1['user_username'];
$this->event_info['province'] = $row['abbr'];
$this->event_info['provinces']=$row;
$query = $database->database_query("SELECT * FROM bateworldcom_zips.tbl_state WHERE state_id='".$this->event_info['state']."'");
$row=$database->database_fetch_assoc($query);
$this->event_info['state'] = $row['state_abbr'];
$this->event_info['states']=$row;
// GET FIELD VALUE INFO
$sql = "SELECT * FROM se_eventvalues WHERE eventvalue_event_id='{$event_id}' LIMIT 1";
$resource = $database->database_query($sql);
if( $database->database_num_rows($resource) )
$this->eventvalue_info = $database->database_fetch_assoc($resource);
// GET LEVEL INFO
if( $this->event_info['event_user_id']==$user->user_info['user_id'])
{
$this->eventowner_level_info =& $user->level_info;
}
elseif( $this->event_info['event_user_id']==$owner->user_info['user_id'])
{
$this->eventowner_level_info =& $owner->level_info;
}
else
{
$sql = "SELECT se_levels.* FROM se_users LEFT JOIN se_levels ON se_users.user_level_id=se_levels.level_id WHERE se_users.user_id='{$this->event_info['event_user_id']}'";
$resource = $database->database_query($sql);
$this->eventowner_level_info = $database->database_fetch_assoc($resource);
}
// GET MEMBER INFO OF CURRENT USER
if( $this->user_id )
{
$sql = "SELECT * FROM se_eventmembers WHERE eventmember_user_id='{$this->user_id}' AND eventmember_event_id='{$event_id}' LIMIT 1";
$resource = $database->database_query($sql);
if( $database->database_num_rows($resource) )
{
$this->eventmember_info = $database->database_fetch_assoc($resource);
$this->is_member = ( $this->eventmember_info['eventmember_status'] && $this->eventmember_info['eventmember_approved'] );
$this->is_member_waiting = ( $this->eventmember_info['eventmember_status'] xor $this->eventmember_info['eventmember_approved'] );
$this->user_rank =& $this->eventmember_info['eventmember_rank'];
}
}
}
}
}
// END se_event() METHOD
//
// THIS METHOD RETURNS THE TOTAL NUMBER OF EVENTS
//
// INPUT:
// $where (OPTIONAL) REPRESENTING ADDITIONAL THINGS TO INCLUDE IN THE WHERE CLAUSE
// $event_details (OPTIONAL) REPRESENTING A BOOLEAN THAT DETERMINES WHETHER TO RETRIEVE EVENT CREATOR
//
// OUTPUT:
// AN INTEGER REPRESENTING THE NUMBER OF EVENTS
//
function event_total_upcoming($where=NULL, $event_details=FALSE)
{
global $database;
// BEGIN QUERY
$sql = "
SELECT
NULL
";
// IF USER ID NOT EMPTY, GET USER AS MEMBER
if( $this->user_id ) $sql .= ",
se_eventmembers.eventmember_status
";
// CONTINUE QUERY
$sql .= "
FROM
se_events
";
// IF USER ID NOT EMPTY, SELECT FROM EVENTMEMBER TABLE
if( $this->user_id ) $sql .= "
LEFT JOIN
se_eventmembers
ON se_eventmembers.eventmember_event_id=se_events.event_id
";
// CONTINUE QUERY IF NECESSARY
if( $event_details ) $sql .= "
LEFT JOIN
se_users
ON se_users.user_id=se_events.event_user_id
";
// ADD WHERE IF NECESSARY
$sql .= "
WHERE se_events.approved='1' AND event_date_end>".time()." ";
// IF USER ID NOT EMPTY, MAKE SURE USER IS A MEMBER
if( $this->user_id ) $sql .= " AND
se_eventmembers.eventmember_user_id='{$this->user_id}' &&
se_eventmembers.eventmember_approved=1
";
// INSERT AND IF NECESSARY
// ADD WHERE CLAUSE, IF NECESSARY
if( $where ) $sql .= "
AND $where
";
// ADD GROUP BY
$sql .= "
GROUP BY
event_id
";
// RUN QUERY
$resource = $database->database_query($sql);
return (int) $database->database_num_rows($resource);
}
function event_total($where=NULL, $event_details=FALSE, $club_id=false)
{
global $database;
// BEGIN QUERY
$sql = "
SELECT
NULL
";
// IF USER ID NOT EMPTY, GET USER AS MEMBER
if( $this->user_id ) $sql .= ",
se_eventmembers.eventmember_status
";
// CONTINUE QUERY
$sql .= "
FROM
se_events
";
// IF USER ID NOT EMPTY, SELECT FROM EVENTMEMBER TABLE
if( $this->user_id ) $sql .= "
LEFT JOIN
se_eventmembers
ON se_eventmembers.eventmember_event_id=se_events.event_id
";
// CONTINUE QUERY IF NECESSARY
if( $event_details ) $sql .= "
LEFT JOIN
se_users
ON se_users.user_id=se_events.event_user_id
";
// ADD WHERE IF NECESSARY
$sql .= "
WHERE approved='1' AND event_user_id NOT IN (".$database->database_real_escape_string(str_replace(",,", ",",$user->user_info["user_blocklist"]))."0)
";
if( $club_id!="" ){ $sql .= "
AND se_events.club_id='".$database->database_real_escape_string($club_id)."'
";
}
// IF USER ID NOT EMPTY, MAKE SURE USER IS A MEMBER
if( $this->user_id ) $sql .= " AND
se_eventmembers.eventmember_user_id='{$this->user_id}' &&
se_eventmembers.eventmember_approved=1
";
// INSERT AND IF NECESSARY
// ADD WHERE CLAUSE, IF NECESSARY
if( $where ) $sql .= "
AND $where
";
// ADD GROUP BY
$sql .= "
GROUP BY
event_id
";
// RUN QUERY
$resource = $database->database_query($sql);
return (int) $database->database_num_rows($resource);
}
function event_total_admin($where=NULL, $event_details=FALSE)
{
global $database;
// BEGIN QUERY
$sql = "
SELECT
NULL
";
// IF USER ID NOT EMPTY, GET USER AS MEMBER
if( $this->user_id ) $sql .= ",
se_eventmembers.eventmember_status
";
// CONTINUE QUERY
$sql .= "
FROM
se_events
";
// IF USER ID NOT EMPTY, SELECT FROM EVENTMEMBER TABLE
if( $this->user_id ) $sql .= "
LEFT JOIN
se_eventmembers
ON se_eventmembers.eventmember_event_id=se_events.event_id
";
// CONTINUE QUERY IF NECESSARY
if( $event_details ) $sql .= "
LEFT JOIN
se_users
ON se_users.user_id=se_events.event_user_id
";
// ADD WHERE IF NECESSARY
$sql .= "
WHERE 1=1
";
// IF USER ID NOT EMPTY, MAKE SURE USER IS A MEMBER
if( $this->user_id ) $sql .= " AND
se_eventmembers.eventmember_user_id='{$this->user_id}' &&
se_eventmembers.eventmember_approved=1
";
// INSERT AND IF NECESSARY
// ADD WHERE CLAUSE, IF NECESSARY
if( $where ) $sql .= "
AND $where
";
// ADD GROUP BY
$sql .= "
GROUP BY
event_id
";
// RUN QUERY
$resource = $database->database_query($sql);
return (int) $database->database_num_rows($resource);
}
// END event_total() METHOD
//
// THIS METHOD RETURNS AN ARRAY OF EVENTS
//
// INPUT:
// $start REPRESENTING THE EVENT TO START WITH
// $limit REPRESENTING THE NUMBER OF EVENTS TO RETURN
// $sort_by (OPTIONAL) REPRESENTING THE ORDER BY CLAUSE
// $where (OPTIONAL) REPRESENTING ADDITIONAL THINGS TO INCLUDE IN THE WHERE CLAUSE
// $event_details (OPTIONAL) REPRESENTING A BOOLEAN THAT DETERMINES WHETHER TO RETRIEVE EVENT CREATOR
//
// OUTPUT:
// AN ARRAY OF EVENTS
//
function event_list_upcoming($start, $limit, $sort_by="event_id DESC", $where=NULL, $event_details=FALSE)
{
global $database, $user;
if( !$start ) $start = '0';
// BEGIN QUERY
$sql = "
SELECT
se_events.*, se_events.province AS province1, se_events.state AS state1
";
// SELECT RELEVANT EVENT DETAILS IF NECESSARY
if( $event_details ) $sql .= ",
se_users.user_id,
se_users.user_username,
se_users.user_photo,
se_users.user_fname,
se_users.user_lname
";
// IF USER ID NOT EMPTY, GET USER AS MEMBER
if( $this->user_id ) $sql .= ",
se_eventmembers.eventmember_status,
se_eventmembers.eventmember_approved,
se_eventmembers.eventmember_rsvp,
se_eventmembers.eventmember_rank
";
// CONTINUE QUERY
$sql .= "
FROM
se_events
";
// IF USER ID NOT EMPTY, SELECT FROM EVENTMEMBER TABLE
if( $this->user_id ) $sql .= "
LEFT JOIN
se_eventmembers
ON se_eventmembers.eventmember_event_id=se_events.event_id
";
// CONTINUE QUERY IF NECESSARY
if( $event_details ) $sql .= "
LEFT JOIN
se_users
ON se_users.user_id=se_events.event_user_id
";
// ADD WHERE IF NECESSARY
$sql .= "
WHERE se_events.approved='1' AND event_date_end>".time()." ";
// IF USER ID NOT EMPTY, MAKE SURE USER IS A MEMBER
if( $this->user_id ) $sql .= "
AND se_eventmembers.eventmember_user_id='{$this->user_id}'
/*
&&
se_eventmembers.eventmember_approved=1
*/
";
// INSERT AND IF NECESSARY
// ADD WHERE CLAUSE, IF NECESSARY
if( $where ) $sql .= "
AND $where
";
// ADD GROUP BY, ORDER, AND LIMIT CLAUSE
$sql .= "
ORDER BY
$sort_by
LIMIT
$start, $limit
";
// RUN QUERY
$resource = $database->database_query($sql);
// GET EVENTS INTO AN ARRAY
$event_array = array();
while( $event_info=$database->database_fetch_assoc($resource) )
{
$event_item = array();
// CREATE OBJECT FOR EVENT
$event = new se_event($event_info['user_id']);
$event->event_exists = TRUE;
$event->is_member = ( $event_info['eventmember_status'] && $event_info['eventmember_approved'] );
$event->is_member_waiting = ( $event_info['eventmember_status'] xor $event_info['eventmember_approved'] );
$event->user_rank = ( isset($event_info['eventmember_rank']) ? $event_info['eventmember_rank'] : 0 );
$event->event_info =& $event_info;
$event->event_info['event_desc'] = htmlspecialchars_decode($event->event_info['event_desc'], ENT_QUOTES);
// CREATE OBJECT FOR EVENT CREATOR IF EVENT DETAILS
if( $event_details )
{
$creator = new se_user();
$creator->user_exists = TRUE;
$creator->user_info['user_id'] = $event_info['user_id'];
$creator->user_info['user_username'] = $event_info['user_username'];
$creator->user_info['user_photo'] = $event_info['user_photo'];
$creator->user_info['user_fname'] = $event_info['user_fname'];
$creator->user_info['user_lname'] = $event_info['user_lname'];
$creator->user_displayname();
$event_item['event_creator'] = &$creator;
}
// SET EVENT ARRAY
$event_item['event'] = &$event;
$event_item['event_status'] = $event_info['eventmember_status'];
$event_item['event_approved'] = $event_info['eventmember_approved'];
$event_item['event_rsvp'] = $event_info['eventmember_rsvp'];
$event_item['event_rank'] = $event_info['eventmember_rank'];
// PRELOAD
if( $event_info['eventmember_status'] && !$event_info['eventmember_approved'] )
$event_item['event_rsvp_lvid'] = $this->event_rsvp_levels['-1'];
elseif( !$event_info['eventmember_status'] && $event_info['eventmember_approved'] )
$event_item['event_rsvp_lvid'] = $this->event_rsvp_levels['-2'];
else
$event_item['event_rsvp_lvid'] = $this->event_rsvp_levels[$event_info['eventmember_rsvp']];
$event_array[] = $event_item;
unset($event_info, $event, $creator, $event_item);
}
// RETURN ARRAY
return $event_array;
}
function club_list($start, $limit, $sort_by="event_id DESC", $where=NULL, $event_details=FALSE, $club_id="")
{
global $database, $user;
if( !$start ) $start = '0';
// BEGIN QUERY
$sql = "
SELECT
se_events.*, se_events.province AS province1, se_events.state AS state1
";
// SELECT RELEVANT EVENT DETAILS IF NECESSARY
if( $event_details ) $sql .= ",
se_users.user_id,
se_users.user_username,
se_users.user_photo,
se_users.user_fname,
se_users.user_lname
";
// IF USER ID NOT EMPTY, GET USER AS MEMBER
if( $this->user_id ) $sql .= ",
se_eventmembers.eventmember_status,
se_eventmembers.eventmember_approved,
se_eventmembers.eventmember_rsvp,
se_eventmembers.eventmember_rank
";
// CONTINUE QUERY
$sql .= "
FROM
se_events
";
// IF USER ID NOT EMPTY, SELECT FROM EVENTMEMBER TABLE
if( $this->user_id ) $sql .= "
LEFT JOIN
se_eventmembers
ON se_eventmembers.eventmember_event_id=se_events.event_id
";
// CONTINUE QUERY IF NECESSARY
if( $event_details ) $sql .= "
LEFT JOIN
se_users
ON se_users.user_id=se_events.event_user_id
";
// ADD WHERE IF NECESSARY
$sql .= "
WHERE approved='1'
";
if( $club_id!="" ){ $sql .= "
AND se_events.club_id='".$database->database_real_escape_string($club_id)."'
";
}
// IF USER ID NOT EMPTY, MAKE SURE USER IS A MEMBER
if( $this->user_id ) $sql .= "
AND se_eventmembers.eventmember_user_id='{$this->user_id}'
/*
&&
se_eventmembers.eventmember_approved=1
*/
";
// INSERT AND IF NECESSARY
// ADD WHERE CLAUSE, IF NECESSARY
if( $where ) $sql .= "
AND $where
";
// ADD GROUP BY, ORDER, AND LIMIT CLAUSE
$sql .= "
ORDER BY
$sort_by
LIMIT
$start, $limit
";
//if(SE_DEBUG1){echo "
".$sql."
";}
// RUN QUERY
//if(SE_DEBUG1){echo "
".time()."event1
";}
$resource = $database->database_query($sql);
//if(SE_DEBUG1){echo "
".time()."event2
";}
// GET EVENTS INTO AN ARRAY
$event_array = array();
while( $event_info=$database->database_fetch_assoc($resource) )
{
$event_item = array();
// CREATE OBJECT FOR EVENT
$event = new se_event($event_info['user_id']);
$event->event_exists = TRUE;
$event->is_member = ( $event_info['eventmember_status'] && $event_info['eventmember_approved'] );
$event->is_member_waiting = ( $event_info['eventmember_status'] xor $event_info['eventmember_approved'] );
$event->user_rank = ( isset($event_info['eventmember_rank']) ? $event_info['eventmember_rank'] : 0 );
$event->event_info =& $event_info;
$event->event_info['event_desc'] = htmlspecialchars_decode($event->event_info['event_desc'], ENT_QUOTES);
// CREATE OBJECT FOR EVENT CREATOR IF EVENT DETAILS
if( $event_details )
{
$creator = new se_user();
$creator->user_exists = TRUE;
$creator->user_info['user_id'] = $event_info['user_id'];
$creator->user_info['user_username'] = $event_info['user_username'];
$creator->user_info['user_photo'] = $event_info['user_photo'];
$creator->user_info['user_fname'] = $event_info['user_fname'];
$creator->user_info['user_lname'] = $event_info['user_lname'];
$creator->user_displayname();
$event_item['event_creator'] = &$creator;
}
// SET EVENT ARRAY
$event_item['event'] = &$event;
$event_item['event_status'] = $event_info['eventmember_status'];
$event_item['event_approved'] = $event_info['eventmember_approved'];
$event_item['event_rsvp'] = $event_info['eventmember_rsvp'];
$event_item['event_rank'] = $event_info['eventmember_rank'];
$event_item['address'] = $event_info['address'];
$event_item['country'] = $event_info['country'];
$event_item['address'] = $event_info['address'];
$event_item['city'] = $event_info['city'];
//if(SE_DEBUG1){echo "
".time()."event3
";}
$query = $database->database_query("SELECT * FROM bateworldcom_zips.provinces WHERE id='".$event_info['province']."'");
$row=$database->database_fetch_assoc($query);
$event->event_info['province'] = $row['abbr'];
$query = $database->database_query("SELECT * FROM bateworldcom_zips.tbl_state WHERE state_id='".$event_info['state']."'");
//if(SE_DEBUG1){echo "
".time()."event4
";}
$row=$database->database_fetch_assoc($query);
$event->event_info['state'] = $row['state_abbr'];
$event_item['postal'] = $event_info['postal'];
//if(SE_DEBUG1){echo $event_item['state']; exit;}
// PRELOAD
if( $event_info['eventmember_status'] && !$event_info['eventmember_approved'] )
$event_item['event_rsvp_lvid'] = $this->event_rsvp_levels['-1'];
elseif( !$event_info['eventmember_status'] && $event_info['eventmember_approved'] )
$event_item['event_rsvp_lvid'] = $this->event_rsvp_levels['-2'];
else
$event_item['event_rsvp_lvid'] = $this->event_rsvp_levels[$event_info['eventmember_rsvp']];
$event_array[] = $event_item;
unset($event_info, $event, $creator, $event_item);
}
// RETURN ARRAY
return $event_array;
}
function event_list($start, $limit, $sort_by="event_id DESC", $where=NULL, $event_details=FALSE, $club_id="0")
{
global $database, $user;
if( !$start ) $start = '0';
// BEGIN QUERY
$sql = "
SELECT
se_events.*, se_events.province AS province1, se_events.state AS state1
";
// SELECT RELEVANT EVENT DETAILS IF NECESSARY
if( $event_details ) $sql .= ",
se_users.user_id,
se_users.user_username,
se_users.user_photo,
se_users.user_fname,
se_users.user_lname
";
// IF USER ID NOT EMPTY, GET USER AS MEMBER
if( $this->user_id ) $sql .= ",
se_eventmembers.eventmember_status,
se_eventmembers.eventmember_approved,
se_eventmembers.eventmember_rsvp,
se_eventmembers.eventmember_rank
";
// CONTINUE QUERY
$sql .= "
FROM
se_events
";
// IF USER ID NOT EMPTY, SELECT FROM EVENTMEMBER TABLE
if( $this->user_id ) $sql .= "
LEFT JOIN
se_eventmembers
ON se_eventmembers.eventmember_event_id=se_events.event_id
";
// CONTINUE QUERY IF NECESSARY
if( $event_details ) $sql .= "
LEFT JOIN
se_users
ON se_users.user_id=se_events.event_user_id
";
$ex=explode(",",$user->user_info["user_blocklist"]);
if(is_array($ex))
{
foreach($ex as $e)
{
if($e!=""){$t=$t."0,".$e.",";}
}
}
// ADD WHERE IF NECESSARY
$sql .= "
WHERE approved='1' AND event_user_id NOT IN (".$database->database_real_escape_string($t)."0)
";
if( $club_id!="0" ){ $sql .= "
AND se_events.club_id='".$database->database_real_escape_string($club_id)."'
";
}
// IF USER ID NOT EMPTY, MAKE SURE USER IS A MEMBER
if( $this->user_id ) $sql .= "
AND se_eventmembers.eventmember_user_id='{$this->user_id}'
/*
&&
se_eventmembers.eventmember_approved=1
*/
";
// INSERT AND IF NECESSARY
// ADD WHERE CLAUSE, IF NECESSARY
if( $where ) $sql .= "
AND $where
";
// ADD GROUP BY, ORDER, AND LIMIT CLAUSE
$sql .= "
ORDER BY
$sort_by
LIMIT
$start, $limit
";
//if(SE_DEBUG1){echo "
".$sql."
";}
// RUN QUERY
//if(SE_DEBUG1){echo "
".time()."event1
";}
$resource = $database->database_query(str_replace(",,", ",", $sql));
//if(SE_DEBUG1){echo "
".time()."event2
";}
// GET EVENTS INTO AN ARRAY
$event_array = array();
while( $event_info=$database->database_fetch_assoc($resource) )
{
$event_item = array();
// CREATE OBJECT FOR EVENT
$event = new se_event($event_info['user_id']);
$event->event_exists = TRUE;
$event->is_member = ( $event_info['eventmember_status'] && $event_info['eventmember_approved'] );
$event->is_member_waiting = ( $event_info['eventmember_status'] xor $event_info['eventmember_approved'] );
$event->user_rank = ( isset($event_info['eventmember_rank']) ? $event_info['eventmember_rank'] : 0 );
$event->event_info =& $event_info;
$event->event_info['event_desc'] = htmlspecialchars_decode($event->event_info['event_desc'], ENT_QUOTES);
// CREATE OBJECT FOR EVENT CREATOR IF EVENT DETAILS
if( $event_details )
{
$creator = new se_user();
$creator->user_exists = TRUE;
$creator->user_info['user_id'] = $event_info['user_id'];
$creator->user_info['user_username'] = $event_info['user_username'];
$creator->user_info['user_photo'] = $event_info['user_photo'];
$creator->user_info['user_fname'] = $event_info['user_fname'];
$creator->user_info['user_lname'] = $event_info['user_lname'];
$creator->user_displayname();
$event_item['event_creator'] = &$creator;
}
// SET EVENT ARRAY
$event_item['event'] = &$event;
$event_item['event_status'] = $event_info['eventmember_status'];
$event_item['event_approved'] = $event_info['eventmember_approved'];
$event_item['event_rsvp'] = $event_info['eventmember_rsvp'];
$event_item['event_rank'] = $event_info['eventmember_rank'];
$event_item['address'] = $event_info['address'];
$event_item['country'] = $event_info['country'];
$event_item['address'] = $event_info['address'];
$event_item['city'] = $event_info['city'];
//if(SE_DEBUG1){echo "
".time()."event3
";}
$query = $database->database_query("SELECT * FROM bateworldcom_zips.provinces WHERE id='".$event_info['province']."'");
$row=$database->database_fetch_assoc($query);
$event->event_info['province'] = $row['abbr'];
$query = $database->database_query("SELECT * FROM bateworldcom_zips.tbl_state WHERE state_id='".$event_info['state']."'");
//if(SE_DEBUG1){echo "
".time()."event4
";}
$row=$database->database_fetch_assoc($query);
$event->event_info['state'] = $row['state_abbr'];
$event_item['postal'] = $event_info['postal'];
//if(SE_DEBUG1){echo $event_item['state']; exit;}
// PRELOAD
if( $event_info['eventmember_status'] && !$event_info['eventmember_approved'] )
$event_item['event_rsvp_lvid'] = $this->event_rsvp_levels['-1'];
elseif( !$event_info['eventmember_status'] && $event_info['eventmember_approved'] )
$event_item['event_rsvp_lvid'] = $this->event_rsvp_levels['-2'];
else
$event_item['event_rsvp_lvid'] = $this->event_rsvp_levels[$event_info['eventmember_rsvp']];
$event_array[] = $event_item;
unset($event_info, $event, $creator, $event_item);
}
// RETURN ARRAY
return $event_array;
}
function event_list_admin($start, $limit, $sort_by="event_id DESC", $where=NULL, $event_details=FALSE)
{
global $database, $user;
if( !$start ) $start = '0';
// BEGIN QUERY
$sql = "
SELECT
se_events.*, se_events.province AS province1, se_events.state AS state1
";
// SELECT RELEVANT EVENT DETAILS IF NECESSARY
if( $event_details ) $sql .= ",
se_users.user_id,
se_users.user_username,
se_users.user_photo,
se_users.user_fname,
se_users.user_lname
";
// IF USER ID NOT EMPTY, GET USER AS MEMBER
if( $this->user_id ) $sql .= ",
se_eventmembers.eventmember_status,
se_eventmembers.eventmember_approved,
se_eventmembers.eventmember_rsvp,
se_eventmembers.eventmember_rank
";
// CONTINUE QUERY
$sql .= "
FROM
se_events
";
// IF USER ID NOT EMPTY, SELECT FROM EVENTMEMBER TABLE
if( $this->user_id ) $sql .= "
LEFT JOIN
se_eventmembers
ON se_eventmembers.eventmember_event_id=se_events.event_id
";
// CONTINUE QUERY IF NECESSARY
if( $event_details ) $sql .= "
LEFT JOIN
se_users
ON se_users.user_id=se_events.event_user_id
";
// ADD WHERE IF NECESSARY
$sql .= "
WHERE 1=1
";
// IF USER ID NOT EMPTY, MAKE SURE USER IS A MEMBER
if( $this->user_id ) $sql .= "
AND se_eventmembers.eventmember_user_id='{$this->user_id}'
/*
&&
se_eventmembers.eventmember_approved=1
*/
";
// INSERT AND IF NECESSARY
// ADD WHERE CLAUSE, IF NECESSARY
if( $where ) $sql .= "
AND $where
";
// ADD GROUP BY, ORDER, AND LIMIT CLAUSE
$sql .= "
ORDER BY
$sort_by
LIMIT
$start, $limit
";
// RUN QUERY
$resource = $database->database_query($sql);
// GET EVENTS INTO AN ARRAY
$event_array = array();
while( $event_info=$database->database_fetch_assoc($resource) )
{
$event_item = array();
// CREATE OBJECT FOR EVENT
$event = new se_event($event_info['user_id']);
$event->event_exists = TRUE;
$event->is_member = ( $event_info['eventmember_status'] && $event_info['eventmember_approved'] );
$event->is_member_waiting = ( $event_info['eventmember_status'] xor $event_info['eventmember_approved'] );
$event->user_rank = ( isset($event_info['eventmember_rank']) ? $event_info['eventmember_rank'] : 0 );
$event->event_info =& $event_info;
$event->event_info['event_desc'] = htmlspecialchars_decode($event->event_info['event_desc'], ENT_QUOTES);
// CREATE OBJECT FOR EVENT CREATOR IF EVENT DETAILS
if( $event_details )
{
$creator = new se_user();
$creator->user_exists = TRUE;
$creator->user_info['user_id'] = $event_info['user_id'];
$creator->user_info['user_username'] = $event_info['user_username'];
$creator->user_info['user_photo'] = $event_info['user_photo'];
$creator->user_info['user_fname'] = $event_info['user_fname'];
$creator->user_info['user_lname'] = $event_info['user_lname'];
$creator->user_displayname();
$event_item['event_creator'] = &$creator;
}
// SET EVENT ARRAY
$event_item['event'] = &$event;
$event_item['event_status'] = $event_info['eventmember_status'];
$event_item['event_approved'] = $event_info['eventmember_approved'];
$event_item['event_rsvp'] = $event_info['eventmember_rsvp'];
$event_item['event_rank'] = $event_info['eventmember_rank'];
// PRELOAD
if( $event_info['eventmember_status'] && !$event_info['eventmember_approved'] )
$event_item['event_rsvp_lvid'] = $this->event_rsvp_levels['-1'];
elseif( !$event_info['eventmember_status'] && $event_info['eventmember_approved'] )
$event_item['event_rsvp_lvid'] = $this->event_rsvp_levels['-2'];
else
$event_item['event_rsvp_lvid'] = $this->event_rsvp_levels[$event_info['eventmember_rsvp']];
$event_array[] = $event_item;
unset($event_info, $event, $creator, $event_item);
}
// RETURN ARRAY
return $event_array;
}
// END event_list() METHOD
//
// THIS METHOD CREATES/EDITS AN EVENT
//
// INPUT:
// $event_title REPRESENTING THE EVENT TITLE
// $event_desc REPRESENTING THE EVENT DESCRIPTION
// $event_eventcat_id REPRESENTING THE EVENT CATEGORY ID
// $event_date_start REPRESENTING THE EVENT'S START TIMESTAMP
// $event_date_end REPRESENTING THE EVENT'S END TIMESTAMP
// $event_host REPRESENTING THE EVENT'S HOST
// $event_location REPRESENTING THE EVENT'S LOCATION
// $event_field_query REPRESENTING THE QUERY TO UPDATE THE EVENT'S FIELDS
//
// OUTPUT:
// THE EVENT'S ID OR FALSE
//
function event_edit(&$event_title, &$event_desc, &$event_eventcat_id, $event_date_start, $event_date_end, &$event_host, &$event_location, $event_field_query,$onlineonly="",$address="",$city="",$state="",$province="",$country="",$postal="", $club_id="")
{
global $database, $user, $actions;
// VALIDATE OWNER
if( $this->event_exists && $this->user_rank<2 )
{
$this->is_error = 3000248;
return FALSE;
}
// INIT VARS
$event_id = ( !empty($this->event_info['event_id']) ? $this->event_info['event_id'] : NULL );
$event_title = censor($event_title);
$event_desc = censor(str_replace("\r\n", "
", html_entity_decode($event_desc, ENT_QUOTES)));
$event_desc = security(cleanHTML($event_desc, $user->level_info['level_event_html']));
$event_host = censor($event_host);
$event_location = censor(str_replace("\r\n", "
", $event_location));
$time = time();
// CHECK TO MAKE SURE TITLE HAS BEEN ENTERED
if( !trim($event_title) )
{
$this->is_error = 3000246;
return FALSE;
}
// CHECK TO MAKE SURE CATEGORY HAS BEEN SELECTED
if( !$event_eventcat_id )
{
$this->is_error = 3000247;
return FALSE;
}
// CHECK TO MAKE SURE END DATE IS AFTER START DATE (IF END DATE IS SET)
if( $event_date_end && $event_date_end<$event_date_start )
{
$this->is_error = 3000249;
return FALSE;
}
// CHECK TO MAKE SURE THAT START DATE IS IN THE FUTURE IF BACKDATING NOT ALLOWED
if( !$user->level_info['level_event_backdate'] && $event_date_start