3580 lines
112 KiB
PHP
3580 lines
112 KiB
PHP
|
|
<?php
|
||
|
|
|
||
|
|
/* $Id: class_event.php 131 2009-03-22 00:54:31Z john $ */
|
||
|
|
|
||
|
|
|
||
|
|
//
|
||
|
|
// THIS CLASS CONTAINS EVENT-RELATED METHODS
|
||
|
|
//
|
||
|
|
// METHODS IN THIS CLASS:
|
||
|
|
//
|
||
|
|
// se_event()
|
||
|
|
//
|
||
|
|
// event_total()
|
||
|
|
// event_list()
|
||
|
|
// event_edit()
|
||
|
|
// event_edit_settings()
|
||
|
|
// event_delete()
|
||
|
|
// event_lastupdate()
|
||
|
|
// event_privacy_max()
|
||
|
|
//
|
||
|
|
// event_member_total()
|
||
|
|
// event_member_list()
|
||
|
|
//
|
||
|
|
// event_dir()
|
||
|
|
//
|
||
|
|
// event_photo()
|
||
|
|
// event_photo_upload()
|
||
|
|
// event_photo_delete()
|
||
|
|
//
|
||
|
|
// event_media_upload()
|
||
|
|
// event_media_space()
|
||
|
|
// event_media_total()
|
||
|
|
// event_media_list()
|
||
|
|
// event_media_update()
|
||
|
|
// event_media_delete()
|
||
|
|
//
|
||
|
|
// event_calendar_generate()
|
||
|
|
//
|
||
|
|
// event_member_invite()
|
||
|
|
// event_member_approve()
|
||
|
|
// event_member_reject()
|
||
|
|
// event_member_cancel()
|
||
|
|
// event_member_remove()
|
||
|
|
//
|
||
|
|
// event_join()
|
||
|
|
// event_leave()
|
||
|
|
// event_rsvp()
|
||
|
|
//
|
||
|
|
// event_rsvp_level()
|
||
|
|
// event_generate_javascript_structure()
|
||
|
|
//
|
||
|
|
|
||
|
|
|
||
|
|
defined('SE_PAGE') or exit();
|
||
|
|
|
||
|
|
use Aws\S3\S3Client;
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
class se_event
|
||
|
|
{
|
||
|
|
// INITIALIZE VARIABLES
|
||
|
|
var $is_error; // DETERMINES WHETHER THERE IS AN ERROR OR NOT
|
||
|
|
var $error_message; // CONTAINS RELEVANT ERROR MESSAGE
|
||
|
|
|
||
|
|
var $user_id; // CONTAINS THE USER ID OF THE USER WHOSE EVENTS WE ARE EDITING OR THE LOGGED-IN USER
|
||
|
|
var $is_member; // DETERMINES WHETHER USER IS IN THE EVENTMEMBER TABLE OR NOT
|
||
|
|
|
||
|
|
var $event_exists; // DETERMINES WHETHER THE EVENT HAS BEEN SET AND EXISTS OR NOT
|
||
|
|
|
||
|
|
var $event_info; // CONTAINS THE EVENT INFO OF THE EVENT WE ARE EDITING
|
||
|
|
var $eventvalue_info; // CONTAINS THE EVENT FIELD VALUE INFO
|
||
|
|
var $eventowner_level_info; // CONTAINS THE EVENT CREATOR'S LEVEL INFO
|
||
|
|
var $eventmember_info; // CONTAINS THE EVENT MEMBER INFO FOR THE LOGGED-IN USER
|
||
|
|
|
||
|
|
var $moderation_privacy; // CONTAINS THE PRIVACY LEVEL THAT IS ALLOWED TO MODERATE FOR THIS USER
|
||
|
|
|
||
|
|
|
||
|
|
var $event_rsvp_levels = array(
|
||
|
|
'-2' => 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 "<br>".$sql."<br>";}
|
||
|
|
// RUN QUERY
|
||
|
|
|
||
|
|
//if(SE_DEBUG1){echo "<br>".time()."event1<br>";}
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
//if(SE_DEBUG1){echo "<br>".time()."event2<br>";}
|
||
|
|
// 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 "<br>".time()."event3<br>";}
|
||
|
|
$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 "<br>".time()."event4<br>";}
|
||
|
|
$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 "<br>".$sql."<br>";}
|
||
|
|
// RUN QUERY
|
||
|
|
|
||
|
|
//if(SE_DEBUG1){echo "<br>".time()."event1<br>";}
|
||
|
|
$resource = $database->database_query(str_replace(",,", ",", $sql));
|
||
|
|
//if(SE_DEBUG1){echo "<br>".time()."event2<br>";}
|
||
|
|
// 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 "<br>".time()."event3<br>";}
|
||
|
|
$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 "<br>".time()."event4<br>";}
|
||
|
|
$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", "<br />", 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", "<br />", $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<time() )
|
||
|
|
{
|
||
|
|
// IF CREATING, ERROR
|
||
|
|
if( !$this->event_exists )
|
||
|
|
{
|
||
|
|
$this->is_error = 3000250;
|
||
|
|
return FALSE;
|
||
|
|
}
|
||
|
|
|
||
|
|
// IF EDITING, ERROR ONLY IF THERE IS NO CHANGE
|
||
|
|
elseif( $event_date_start!=$this->event_info['event_date_start'] || $event_date_end!=$this->event_info['event_date_end'] )
|
||
|
|
{
|
||
|
|
$this->is_error = 3000250;
|
||
|
|
return FALSE;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
// CREATE
|
||
|
|
if( !$event_id )
|
||
|
|
{
|
||
|
|
// ADD ROW TO EVENTS TABLE
|
||
|
|
$sql = "
|
||
|
|
INSERT INTO se_events (
|
||
|
|
event_user_id,
|
||
|
|
event_eventcat_id,
|
||
|
|
event_title,
|
||
|
|
event_desc,
|
||
|
|
event_date_start,
|
||
|
|
event_date_end,
|
||
|
|
event_host,
|
||
|
|
event_location,
|
||
|
|
event_datecreated,
|
||
|
|
onlineonly,
|
||
|
|
address,
|
||
|
|
city,
|
||
|
|
state,
|
||
|
|
province,
|
||
|
|
country,
|
||
|
|
postal, club_id
|
||
|
|
) VALUES (
|
||
|
|
'{$this->user_id}',
|
||
|
|
'{$event_eventcat_id}',
|
||
|
|
'{$event_title}',
|
||
|
|
'{$event_desc}',
|
||
|
|
'{$event_date_start}',
|
||
|
|
'{$event_date_end}',
|
||
|
|
'{$event_host}',
|
||
|
|
'{$event_location}',
|
||
|
|
'{$time}',
|
||
|
|
'".$database->database_real_escape_string($onlineonly)."',
|
||
|
|
'".$database->database_real_escape_string($address)."',
|
||
|
|
'".$database->database_real_escape_string($city)."',
|
||
|
|
'".$database->database_real_escape_string($state)."',
|
||
|
|
'".$database->database_real_escape_string($province)."',
|
||
|
|
'".$database->database_real_escape_string($country)."',
|
||
|
|
'".$database->database_real_escape_string($postal)."',
|
||
|
|
'".$database->database_real_escape_string($club_id)."'
|
||
|
|
)
|
||
|
|
";
|
||
|
|
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
$event_id = $database->database_insert_id();
|
||
|
|
|
||
|
|
// MAKE EVENT EXIST
|
||
|
|
if( $event_id )
|
||
|
|
{
|
||
|
|
$this->event_exists = TRUE;
|
||
|
|
$this->is_member = TRUE;
|
||
|
|
$this->user_rank = 3;
|
||
|
|
$this->event_info['event_id'] = $event_id;
|
||
|
|
$this->event_info['event_user_id'] = $this->user_id;
|
||
|
|
$this->eventowner_level_info =& $user->level_info;
|
||
|
|
}
|
||
|
|
|
||
|
|
// MAKE CREATOR A MEMBER
|
||
|
|
$sql = "INSERT INTO se_eventmembers (eventmember_user_id, eventmember_event_id, eventmember_status, eventmember_approved, eventmember_rank) VALUES ('{$this->user_id}', '{$event_id}', '1', '1', '3')";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
addspampoint(16, $this->user_id);
|
||
|
|
wrapup("create_event");
|
||
|
|
// ADD EVENT STYLES ROW
|
||
|
|
// $sql = "INSERT INTO se_eventstyles (eventstyle_event_id) VALUES ('{$event_id}')";
|
||
|
|
//$resource = $database->database_query($sql);
|
||
|
|
|
||
|
|
// ADD EVENT VALUES ROW
|
||
|
|
$sql = "INSERT INTO se_eventvalues (eventvalue_event_id) VALUES ('{$event_id}')";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
|
||
|
|
|
||
|
|
// ADD EVENT ALBUM
|
||
|
|
$sql = "
|
||
|
|
INSERT INTO se_eventalbums
|
||
|
|
(eventalbum_event_id, eventalbum_datecreated, eventalbum_dateupdated, eventalbum_title, eventalbum_desc, eventalbum_search, eventalbum_privacy, eventalbum_comments)
|
||
|
|
VALUES
|
||
|
|
('{$event_id}', '{$time}', '{$time}', '', '', '{$this->event_info['event_search']}', '{$this->event_info['event_privacy']}', '{$this->event_info['event_comments']}')
|
||
|
|
";
|
||
|
|
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
|
||
|
|
|
||
|
|
// INSERT ACTION
|
||
|
|
$event_title = $this->event_info['event_title'];
|
||
|
|
if(strlen($event_title) > 100) { $event_title = substr($event_title, 0, 97)."..."; }
|
||
|
|
$actions->actions_add(
|
||
|
|
$user,
|
||
|
|
"newevent",
|
||
|
|
Array(
|
||
|
|
$user->user_info['user_username'],
|
||
|
|
$user->user_displayname,
|
||
|
|
$this->event_info['event_id'],
|
||
|
|
$event_title
|
||
|
|
),
|
||
|
|
NULL,
|
||
|
|
NULL,
|
||
|
|
FALSE,
|
||
|
|
"event",
|
||
|
|
$event_id,
|
||
|
|
$this->event_info['event_privacy']
|
||
|
|
);
|
||
|
|
}
|
||
|
|
|
||
|
|
// EDIT
|
||
|
|
else
|
||
|
|
{
|
||
|
|
// IF NEW INVITE ONLY SETTING IS CHANGED TO 0, APPROVE ALL REQUESTS FOR INVITATION
|
||
|
|
if( !$event_inviteonly )
|
||
|
|
{
|
||
|
|
$sql = "UPDATE se_eventmembers SET eventmember_status='1' WHERE eventmember_event_id='{$this->event_info['event_id']}' AND eventmember_status='0'";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
}
|
||
|
|
|
||
|
|
// UPDATE EVENT
|
||
|
|
$sql = "
|
||
|
|
UPDATE
|
||
|
|
se_events
|
||
|
|
SET
|
||
|
|
event_title='{$event_title}',
|
||
|
|
event_eventcat_id='{$event_eventcat_id}',
|
||
|
|
event_desc='{$event_desc}',
|
||
|
|
event_date_start='{$event_date_start}',
|
||
|
|
event_date_end='{$event_date_end}',
|
||
|
|
event_host='{$event_host}',
|
||
|
|
event_location='{$event_location}',
|
||
|
|
event_dateupdated={$time},
|
||
|
|
onlineonly='".$database->database_real_escape_string($onlineonly)."',
|
||
|
|
address='".$database->database_real_escape_string($address)."',
|
||
|
|
city='".$database->database_real_escape_string($city)."',
|
||
|
|
state='".$database->database_real_escape_string($state)."',
|
||
|
|
province='".$database->database_real_escape_string($province)."',
|
||
|
|
country='".$database->database_real_escape_string($country)."',
|
||
|
|
postal='".$database->database_real_escape_string($postal)."'
|
||
|
|
|
||
|
|
WHERE
|
||
|
|
event_id='{$event_id}'
|
||
|
|
LIMIT
|
||
|
|
1
|
||
|
|
";
|
||
|
|
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
$actions->actions_add(
|
||
|
|
$user,
|
||
|
|
"editevent",
|
||
|
|
Array(
|
||
|
|
$user->user_info['user_username'],
|
||
|
|
$user->user_displayname,
|
||
|
|
$this->event_info['event_id'],
|
||
|
|
$event_title
|
||
|
|
),
|
||
|
|
NULL,
|
||
|
|
NULL,
|
||
|
|
FALSE,
|
||
|
|
"event",
|
||
|
|
$event_id,
|
||
|
|
$this->event_info['event_privacy']
|
||
|
|
);
|
||
|
|
}
|
||
|
|
|
||
|
|
// TODO: UPDATE EVENT VALUES $event_field_query
|
||
|
|
if( !empty($event_field_query) )
|
||
|
|
{
|
||
|
|
$sql = " UPDATE se_eventvalues SET {$event_field_query} WHERE eventvalue_event_id='{$event_id}' LIMIT 1";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
// ADD EVENT DIRECTORY
|
||
|
|
$event_directory = $this->event_dir($event_id);
|
||
|
|
$event_path_array = explode("/", $event_directory);
|
||
|
|
array_pop($event_path_array);
|
||
|
|
array_pop($event_path_array);
|
||
|
|
$subdir = implode("/", $event_path_array)."/";
|
||
|
|
|
||
|
|
/*if( !is_dir($subdir) )
|
||
|
|
{
|
||
|
|
mkdir($subdir, 0777);
|
||
|
|
chmod($subdir, 0777);
|
||
|
|
if( $handle=fopen($subdir."index.php", 'x+') )
|
||
|
|
fclose($handle);
|
||
|
|
}
|
||
|
|
|
||
|
|
if( !is_dir($event_directory) )
|
||
|
|
{
|
||
|
|
mkdir($event_directory, 0777);
|
||
|
|
chmod($event_directory, 0777);
|
||
|
|
if( $handle=fopen($event_directory."/index.php", 'x+') )
|
||
|
|
fclose($event_directory);
|
||
|
|
}*/
|
||
|
|
|
||
|
|
return $event_id;
|
||
|
|
}
|
||
|
|
|
||
|
|
// END event_edit() METHOD
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
function event_edit_admin(&$event_title, &$event_desc, &$event_eventcat_id, $event_date_start, $event_date_end, &$event_host, &$event_location, $approved, $paid, $event_field_query)
|
||
|
|
{
|
||
|
|
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", "<br />", 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", "<br />", $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<time() )
|
||
|
|
{
|
||
|
|
// IF CREATING, ERROR
|
||
|
|
if( !$this->event_exists )
|
||
|
|
{
|
||
|
|
$this->is_error = 3000250;
|
||
|
|
return FALSE;
|
||
|
|
}
|
||
|
|
|
||
|
|
// IF EDITING, ERROR ONLY IF THERE IS NO CHANGE
|
||
|
|
elseif( $event_date_start!=$this->event_info['event_date_start'] || $event_date_end!=$this->event_info['event_date_end'] )
|
||
|
|
{
|
||
|
|
$this->is_error = 3000250;
|
||
|
|
return FALSE;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
// CREATE
|
||
|
|
if( !$event_id )
|
||
|
|
{}
|
||
|
|
|
||
|
|
// EDIT
|
||
|
|
else
|
||
|
|
{
|
||
|
|
// IF NEW INVITE ONLY SETTING IS CHANGED TO 0, APPROVE ALL REQUESTS FOR INVITATION
|
||
|
|
if( !$event_inviteonly )
|
||
|
|
{
|
||
|
|
$sql = "UPDATE se_eventmembers SET eventmember_status='1' WHERE eventmember_event_id='{$this->event_info['event_id']}' AND eventmember_status='0'";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
}
|
||
|
|
|
||
|
|
// UPDATE EVENT
|
||
|
|
$sql = "
|
||
|
|
UPDATE
|
||
|
|
se_events
|
||
|
|
SET
|
||
|
|
event_title='{$event_title}',
|
||
|
|
event_eventcat_id='{$event_eventcat_id}',
|
||
|
|
event_desc='{$event_desc}',
|
||
|
|
event_date_start='{$event_date_start}',
|
||
|
|
event_date_end='{$event_date_end}',
|
||
|
|
event_host='{$event_host}',
|
||
|
|
event_location='{$event_location}',
|
||
|
|
event_dateupdated={$time}, approved={$approved}, paid={$paid}, note='".$database->database_real_escape_string($_POST["note"])."'
|
||
|
|
WHERE
|
||
|
|
event_id='{$event_id}'
|
||
|
|
LIMIT
|
||
|
|
1
|
||
|
|
";
|
||
|
|
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
// TODO: UPDATE EVENT VALUES $event_field_query
|
||
|
|
if( !empty($event_field_query) )
|
||
|
|
{
|
||
|
|
$sql = " UPDATE se_eventvalues SET {$event_field_query} WHERE eventvalue_event_id='{$event_id}' LIMIT 1";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
// ADD EVENT DIRECTORY
|
||
|
|
$event_directory = $this->event_dir($event_id);
|
||
|
|
$event_path_array = explode("/", $event_directory);
|
||
|
|
array_pop($event_path_array);
|
||
|
|
array_pop($event_path_array);
|
||
|
|
$subdir = implode("/", $event_path_array)."/";
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
return $event_id;
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//
|
||
|
|
// THIS METHOD EDITS AN EVENT'S SETTINGS
|
||
|
|
//
|
||
|
|
// INPUT:
|
||
|
|
// $event_search REPRESENTING WHETHER THE EVENT SHOULD BE SEARCHABLE
|
||
|
|
// $event_inviteonly REPRESENTING WHETHER UNINVITED USERS MUST REQUEST A MEMBERSHIP TO RSVP
|
||
|
|
// $event_privacy REPRESENTING WHO CAN VIEW THE EVENT
|
||
|
|
// $event_comments REPRESENTING WHO CAN POST COMMENTS ON THE EVENT
|
||
|
|
// $event_upload REPRESENTING WHO CAN POST UPLOAD PHOTOS TO THE EVENT
|
||
|
|
// $event_tag REPRESENTING WHO CAN POST TAG PHOTOS IN THE EVENT
|
||
|
|
// $event_invite REPRESENTING WHO CAN INVITE PPL
|
||
|
|
//
|
||
|
|
// OUTPUT:
|
||
|
|
// TRUE/FALSE
|
||
|
|
//
|
||
|
|
|
||
|
|
function event_edit_settings(&$event_search, &$event_inviteonly, &$event_privacy, &$event_comments, &$event_upload, &$event_tag, &$event_invite)
|
||
|
|
{
|
||
|
|
global $database;
|
||
|
|
|
||
|
|
// VALIDATE OWNER
|
||
|
|
if( $this->user_rank<2 )
|
||
|
|
{
|
||
|
|
$this->is_error = 3000248;
|
||
|
|
return FALSE;
|
||
|
|
}
|
||
|
|
|
||
|
|
// GET PRIVACY SETTINGS
|
||
|
|
$level_event_privacy = unserialize($this->eventowner_level_info['level_event_privacy']);
|
||
|
|
rsort($level_event_privacy);
|
||
|
|
$level_event_comments = unserialize($this->eventowner_level_info['level_event_comments']);
|
||
|
|
rsort($level_event_comments);
|
||
|
|
$level_event_upload = unserialize($this->eventowner_level_info['level_event_upload']);
|
||
|
|
rsort($level_event_upload);
|
||
|
|
$level_event_tag = unserialize($this->eventowner_level_info['level_event_tag']);
|
||
|
|
rsort($level_event_tag);
|
||
|
|
|
||
|
|
// MAKE SURE SUBMITTED PRIVACY OPTIONS ARE ALLOWED, IF NOT, SET TO MOST PUBLIC
|
||
|
|
if( !in_array($event_privacy, $level_event_privacy) )
|
||
|
|
$event_privacy = $level_event_privacy[0];
|
||
|
|
if( !in_array($event_comments, $level_event_comments))
|
||
|
|
$event_comments = $level_event_comments[0];
|
||
|
|
if( !in_array($event_upload, $level_event_upload))
|
||
|
|
$event_upload = $level_event_upload[0];
|
||
|
|
if( !in_array($event_tag, $level_event_tag))
|
||
|
|
$event_tag = $level_event_tag[0];
|
||
|
|
|
||
|
|
// CHECK THAT SEARCH IS NOT BLANK
|
||
|
|
if( !$this->eventowner_level_info['level_event_search'] )
|
||
|
|
$event_search = 1;
|
||
|
|
|
||
|
|
// CHECK THAT INVITE ONLY IS NOT BLANK
|
||
|
|
if( !$this->eventowner_level_info['level_event_inviteonly'] )
|
||
|
|
$event_inviteonly = 0;
|
||
|
|
|
||
|
|
$time = time();
|
||
|
|
|
||
|
|
// UPDATE EVENT
|
||
|
|
$sql = "
|
||
|
|
UPDATE
|
||
|
|
se_events
|
||
|
|
SET
|
||
|
|
event_search='{$event_search}',
|
||
|
|
event_invite='{$event_invite}',
|
||
|
|
event_inviteonly='{$event_inviteonly}',
|
||
|
|
event_privacy='{$event_privacy}',
|
||
|
|
event_comments='{$event_comments}',
|
||
|
|
event_upload='{$event_upload}',
|
||
|
|
event_tag='{$event_tag}',
|
||
|
|
event_dateupdated={$time}
|
||
|
|
WHERE
|
||
|
|
event_id='{$this->event_info['event_id']}'
|
||
|
|
LIMIT
|
||
|
|
1
|
||
|
|
";
|
||
|
|
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
$result1 = (bool) $database->database_affected_rows($resource);
|
||
|
|
|
||
|
|
// UPDATE EVENT ALBUMS
|
||
|
|
$sql = "UPDATE se_eventalbums SET eventalbum_privacy='{$event_privacy}', eventalbum_comments='{$event_comments}', eventalbum_search='{$event_search}', eventalbum_tag='{$event_tag}' WHERE eventalbum_event_id='{$this->event_info['event_id']}'";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
$result2 = (bool) $database->database_affected_rows($resource);
|
||
|
|
|
||
|
|
return ($result1 && $result2);
|
||
|
|
}
|
||
|
|
|
||
|
|
// END event_edit_settings() METHOD
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//
|
||
|
|
// THIS METHOD DELETES AN EVENT
|
||
|
|
//
|
||
|
|
// INPUT:
|
||
|
|
// $event_id (OPTIONAL) REPRESENTING THE ID OR AN ARRAY OF IDS OF EVENTS TO DELETE
|
||
|
|
//
|
||
|
|
// OUTPUT:
|
||
|
|
// void
|
||
|
|
//
|
||
|
|
|
||
|
|
function event_delete($event_id=NULL)
|
||
|
|
{
|
||
|
|
global $database, $user;
|
||
|
|
|
||
|
|
// IF EMPTY, TRY TO GET FROM OBJECT
|
||
|
|
if( !$event_id && !$this->event_exists )
|
||
|
|
return FALSE;
|
||
|
|
elseif( !$event_id )
|
||
|
|
$event_id = $this->event_info['event_id'];
|
||
|
|
|
||
|
|
// IF ARRAY
|
||
|
|
if( is_array($event_id) )
|
||
|
|
return array_map(array(&$this, 'event_delete'), $event_id);
|
||
|
|
|
||
|
|
// DELETE EVENT ROW
|
||
|
|
$sql = "DELETE FROM se_events WHERE se_events.event_id='{$event_id}'";
|
||
|
|
if( $this->user_id ) $sql .= " && event_user_id='{$this->user_id}'";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
|
||
|
|
// EVENT WAS NOT DELETED, POSSIBLE SECURITY VIOLATION
|
||
|
|
if( !$database->database_affected_rows($resource) )
|
||
|
|
return FALSE;
|
||
|
|
|
||
|
|
// DELETE EVENT ALBUM, MEDIA, MEDIA COMMENTS
|
||
|
|
$sql = "DELETE FROM se_eventalbums, se_eventmedia, se_eventmediacomments USING se_eventalbums LEFT JOIN se_eventmedia ON se_eventalbums.eventalbum_id=se_eventmedia.eventmedia_eventalbum_id LEFT JOIN se_eventmediacomments ON se_eventmedia.eventmedia_id=se_eventmediacomments.eventmediacomment_eventmedia_id WHERE se_eventalbums.eventalbum_event_id='{$event_id}'";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
|
||
|
|
// DELETE ALL MEMBERS
|
||
|
|
$sql = "DELETE FROM se_eventmembers WHERE se_eventmembers.eventmember_event_id='{$event_id}'";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
|
||
|
|
// DELETE EVENT STYLE
|
||
|
|
// $sql = "DELETE FROM se_eventstyles WHERE se_eventstyles.eventstyle_event_id='{$event_id}'";
|
||
|
|
//$resource = $database->database_query($sql);
|
||
|
|
|
||
|
|
// DELETE EVENT COMMENTS
|
||
|
|
$sql = "DELETE FROM se_eventcomments WHERE se_eventcomments.eventcomment_event_id='{$event_id}'";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
|
||
|
|
// DELETE EVENT VALUES
|
||
|
|
$sql = "DELETE FROM se_eventvalues WHERE se_eventvalues.eventvalue_event_id='{$event_id}'";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
|
||
|
|
// DELETE EVENT'S FILES
|
||
|
|
$event_directory = $this->event_dir($event_id);
|
||
|
|
|
||
|
|
if( !is_dir($event_directory) && is_dir(".".$event_directory) )
|
||
|
|
$event_directory = ".".$event_directory;
|
||
|
|
$client = new MyS3Wrapper([
|
||
|
|
'region' => 'us-north-1',
|
||
|
|
'version' => 'latest',
|
||
|
|
'endpoint' => ENDPOINT,
|
||
|
|
'credentials' => [
|
||
|
|
'key' => AWS_KEY,
|
||
|
|
'secret' => AWS_SECRET_KEY
|
||
|
|
],
|
||
|
|
|
||
|
|
// Set the S3 class to use objects.dreamhost.com/bucket
|
||
|
|
// instead of bucket.objects.dreamhost.com
|
||
|
|
'use_path_style_endpoint' => true
|
||
|
|
]);
|
||
|
|
if( is_dir($event_directory) && ($dh=@opendir($dir)) )
|
||
|
|
{
|
||
|
|
while( ($file = @readdir($dh))!==FALSE )
|
||
|
|
{
|
||
|
|
if( $file=="." || $file==".." ) continue;
|
||
|
|
@unlink($dir.$file);
|
||
|
|
@unlink($dir.str_replace(".", "_thumb.", $file));
|
||
|
|
|
||
|
|
try {
|
||
|
|
$client->deleteObject(array(
|
||
|
|
'Bucket'=>'bateworld',
|
||
|
|
'Key' => str_replace("./", "", $dir).$file,
|
||
|
|
|
||
|
|
));}catch (Exception $e) {}
|
||
|
|
try {
|
||
|
|
$client->deleteObject(array(
|
||
|
|
'Bucket'=>'bateworld',
|
||
|
|
'Key' => str_replace("./", "", $dir).str_replace(".", "_thumb.", $file),
|
||
|
|
|
||
|
|
));}catch (Exception $e) {}
|
||
|
|
|
||
|
|
}
|
||
|
|
@closedir($dh);
|
||
|
|
@rmdir($dir);
|
||
|
|
}
|
||
|
|
$database->database_query("INSERT INTO bateworldcom_wall.admin_log SET user_id='{$user->user_info["user_id"]}', time='".time()."', action='User has deleted an event'");
|
||
|
|
return TRUE;
|
||
|
|
}
|
||
|
|
|
||
|
|
// END event_delete() METHOD
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//
|
||
|
|
// THIS METHOD UPDATES THE EVENT'S LAST UPDATE DATE
|
||
|
|
//
|
||
|
|
// INPUT:
|
||
|
|
// void
|
||
|
|
//
|
||
|
|
// OUTPUT:
|
||
|
|
// void
|
||
|
|
//
|
||
|
|
|
||
|
|
function event_lastupdate()
|
||
|
|
{
|
||
|
|
global $database;
|
||
|
|
$sql = "UPDATE se_events SET event_dateupdated='".time()."' WHERE event_id='{$this->event_info['event_id']}'";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
}
|
||
|
|
|
||
|
|
// END event_lastupdate() METHOD
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//
|
||
|
|
// THIS METHOD RETURNS MAXIMUM PRIVACY LEVEL VIEWABLE BY A USER WITH REGARD TO THE CURRENT EVENT
|
||
|
|
//
|
||
|
|
// INPUT:
|
||
|
|
// $user REPRESENTING A USER OBJECT
|
||
|
|
//
|
||
|
|
// OUTPUT:
|
||
|
|
// RETURNS PRIVACY LEVEL OF GIVEN USER WITH RESPECT TO CURRENT EVENT
|
||
|
|
//
|
||
|
|
|
||
|
|
function event_privacy_max($user)
|
||
|
|
{
|
||
|
|
global $database;
|
||
|
|
|
||
|
|
if( !is_object($user) || !$user->user_exists )
|
||
|
|
return 64;
|
||
|
|
|
||
|
|
switch( TRUE )
|
||
|
|
{
|
||
|
|
// EVENT CREATOR
|
||
|
|
case( $this->event_info['event_user_id']==$user->user_info['user_id'] ):
|
||
|
|
return 1;
|
||
|
|
break;
|
||
|
|
|
||
|
|
// EVENT INVITEE
|
||
|
|
case($database->database_num_rows($database->database_query("SELECT eventmember_id FROM se_eventmembers WHERE eventmember_user_id='{$user->user_info['user_id']}' AND eventmember_event_id='{$this->event_info['event_id']}' AND eventmember_status<>'-1'")) != 0):
|
||
|
|
return 2;
|
||
|
|
break;
|
||
|
|
|
||
|
|
// EVENT CREATOR'S FRIEND
|
||
|
|
/*case($database->database_num_rows($database->database_query("SELECT friend_id FROM se_friends WHERE friend_user_id1='{$this->event_info['event_user_id']}' AND friend_user_id2='{$user->user_info['user_id']}'")) != 0):
|
||
|
|
return 4;
|
||
|
|
break;
|
||
|
|
|
||
|
|
// EVENT INVITEE'S FRIEND
|
||
|
|
case($database->database_num_rows($database->database_query("SELECT se_friends.friend_id FROM se_eventmembers LEFT JOIN se_friends ON se_eventmembers.eventmember_user_id=se_friends.friend_user_id1 AND se_eventmembers.eventmember_status<>'-1' WHERE se_eventmembers.eventmember_event_id='{$this->event_info['event_id']}' AND se_friends.friend_user_id2='{$user->user_info['user_id']}'")) != 0):
|
||
|
|
return 8;
|
||
|
|
break;
|
||
|
|
|
||
|
|
// FRIEND OF EVENT INVITEE'S FRIENDS
|
||
|
|
case($database->database_num_rows($database->database_query("SELECT t2.friend_user_id2 FROM se_eventmembers LEFT JOIN se_friends AS t1 ON se_eventmembers.eventmember_user_id=t1.friend_user_id1 AND se_eventmembers.eventmember_status<>'-1' LEFT JOIN se_friends AS t2 ON t1.friend_user_id2=t2.friend_user_id1 WHERE se_eventmembers.eventmember_event_id='{$this->event_info['event_id']}' AND t2.friend_user_id2='{$user->user_info['user_id']}'")) != 0):
|
||
|
|
return 16;
|
||
|
|
break;
|
||
|
|
*/
|
||
|
|
// REGISTERED USER
|
||
|
|
case( $user->user_exists ):
|
||
|
|
return 32;
|
||
|
|
break;
|
||
|
|
|
||
|
|
// EVERYONE (DEFAULT)
|
||
|
|
default:
|
||
|
|
return 64;
|
||
|
|
break;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
// END event_privacy_max() METHOD
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//
|
||
|
|
// THIS METHOD RETURNS THE TOTAL NUMBER OF INVITED USERS IN AN EVENT
|
||
|
|
//
|
||
|
|
// INPUT:
|
||
|
|
// $where (OPTIONAL) REPRESENTING ADDITIONAL THINGS TO INCLUDE IN THE WHERE CLAUSE
|
||
|
|
// $member_details (OPTIONAL) REPRESENTING WHETHER TO JOIN TO THE USER TABLE FOR SEARCH PURPOSES
|
||
|
|
//
|
||
|
|
// OUTPUT:
|
||
|
|
// AN INTEGER REPRESENTING THE NUMBER OF EVENT MEMBERS
|
||
|
|
//
|
||
|
|
|
||
|
|
function event_member_total($where=NULL, $member_details=FALSE)
|
||
|
|
{
|
||
|
|
global $database;
|
||
|
|
|
||
|
|
// BEGIN QUERY
|
||
|
|
$sql = "
|
||
|
|
SELECT
|
||
|
|
NULL
|
||
|
|
FROM
|
||
|
|
se_eventmembers
|
||
|
|
";
|
||
|
|
|
||
|
|
// JOIN TO USER TABLE IF NECESSARY
|
||
|
|
if( $member_details ) $sql .= "
|
||
|
|
LEFT JOIN
|
||
|
|
se_users
|
||
|
|
ON se_eventmembers.eventmember_user_id=se_users.user_id
|
||
|
|
";
|
||
|
|
|
||
|
|
// ADD WHERE IF NECESSARY
|
||
|
|
if( $this->event_exists || $where ) $sql .= "
|
||
|
|
WHERE
|
||
|
|
";
|
||
|
|
|
||
|
|
// IF EVENT ID IS SET
|
||
|
|
if( $this->event_exists ) $sql .= "
|
||
|
|
se_eventmembers.eventmember_event_id='{$this->event_info['event_id']}'
|
||
|
|
";
|
||
|
|
|
||
|
|
// ADD AND IF NECESSARY
|
||
|
|
if( $this->event_exists && $where ) $sql .= " AND";
|
||
|
|
|
||
|
|
// ADD REST OF WHERE CLAUSE
|
||
|
|
if( $where ) $sql .= "
|
||
|
|
$where
|
||
|
|
";
|
||
|
|
|
||
|
|
// RUN QUERY
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
return (int) $database->database_num_rows($resource);
|
||
|
|
}
|
||
|
|
|
||
|
|
// END event_member_total() METHOD
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//
|
||
|
|
// THIS METHOD RETURNS AN ARRAY OF EVENT INVITEES
|
||
|
|
//
|
||
|
|
// INPUT:
|
||
|
|
// $start REPRESENTING THE EVENT MEMBER TO START WITH
|
||
|
|
// $limit REPRESENTING THE NUMBER OF EVENT MEMBERS TO RETURN
|
||
|
|
// $sort_by (OPTIONAL) REPRESENTING THE ORDER BY CLAUSE
|
||
|
|
// $where (OPTIONAL) REPRESENTING ADDITIONAL THINGS TO INCLUDE IN THE WHERE CLAUSE
|
||
|
|
//
|
||
|
|
// OUTPUT:
|
||
|
|
// AN ARRAY OF EVENT MEMBERS
|
||
|
|
//
|
||
|
|
|
||
|
|
function event_member_list($start, $limit, $sort_by="eventmember_id DESC", $where=NULL)
|
||
|
|
{
|
||
|
|
global $database;
|
||
|
|
|
||
|
|
if( !$start ) $start = '0';
|
||
|
|
|
||
|
|
// BEGIN QUERY
|
||
|
|
$sql = "
|
||
|
|
SELECT
|
||
|
|
se_eventmembers.*,
|
||
|
|
se_users.user_id,
|
||
|
|
se_users.user_username,
|
||
|
|
se_users.user_photo,
|
||
|
|
se_users.user_fname,
|
||
|
|
se_users.user_lname,
|
||
|
|
se_users.user_dateupdated,
|
||
|
|
se_users.user_lastlogindate,
|
||
|
|
se_users.user_signupdate
|
||
|
|
";
|
||
|
|
|
||
|
|
// IF USER IS SET
|
||
|
|
if( $this->user_id ) $sql .= ",
|
||
|
|
(SELECT TRUE FROM se_friends WHERE friend_user_id1='{$this->user_id}' && friend_user_id2=se_users.user_id LIMIT 1) AS is_viewers_friend,
|
||
|
|
(SELECT TRUE FROM se_users AS ivbl WHERE ivbl.user_id=se_users.user_id && ivbl.user_blocklist LIKE '%{$this->user_id}%' LIMIT 1) AS is_viewer_blocklisted
|
||
|
|
";
|
||
|
|
|
||
|
|
$sql .= "
|
||
|
|
FROM
|
||
|
|
se_eventmembers
|
||
|
|
LEFT JOIN
|
||
|
|
se_users
|
||
|
|
ON se_users.user_id=se_eventmembers.eventmember_user_id
|
||
|
|
";
|
||
|
|
|
||
|
|
// ADD WHERE IF NECESSARY
|
||
|
|
$sql .= "
|
||
|
|
WHERE se_users.user_enabled=1
|
||
|
|
";
|
||
|
|
|
||
|
|
// IF EVENT ID IS SET
|
||
|
|
if( $this->event_exists ) $sql .= "
|
||
|
|
AND se_eventmembers.eventmember_event_id='{$this->event_info['event_id']}'
|
||
|
|
";
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
// ADD REST OF WHERE CLAUSE
|
||
|
|
if( $where ) $sql .= " AND
|
||
|
|
$where
|
||
|
|
";
|
||
|
|
|
||
|
|
// ADD ORDER, AND LIMIT CLAUSE
|
||
|
|
$sql .= "
|
||
|
|
ORDER BY
|
||
|
|
$sort_by
|
||
|
|
LIMIT
|
||
|
|
$start, $limit
|
||
|
|
";
|
||
|
|
|
||
|
|
// RUN QUERY
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
|
||
|
|
// GET EVENT MEMBERS INTO AN ARRAY
|
||
|
|
$eventmember_array = array();
|
||
|
|
while( $eventmember_info=$database->database_fetch_assoc($resource) )
|
||
|
|
{
|
||
|
|
// CREATE OBJECT FOR MEMBER
|
||
|
|
$member = new se_user();
|
||
|
|
$member->user_exists = TRUE;
|
||
|
|
$member->user_info['user_id'] = $eventmember_info['user_id'];
|
||
|
|
$member->user_info['user_username'] = $eventmember_info['user_username'];
|
||
|
|
$member->user_info['user_photo'] = $eventmember_info['user_photo'];
|
||
|
|
$member->user_info['user_fname'] = $eventmember_info['user_fname'];
|
||
|
|
$member->user_info['user_lname'] = $eventmember_info['user_lname'];
|
||
|
|
$member->user_info['user_dateupdated'] = $eventmember_info['user_dateupdated'];
|
||
|
|
$member->user_info['user_lastlogindate'] = $eventmember_info['user_lastlogindate'];
|
||
|
|
$member->user_info['user_signupdate'] = $eventmember_info['user_signupdate'];
|
||
|
|
$member->is_viewers_friend = $eventmember_info['is_viewers_friend'];
|
||
|
|
$member->is_viewers_blocklist = $eventmember_info['is_viewers_blocklist'];
|
||
|
|
$member->user_displayname();
|
||
|
|
|
||
|
|
if( $eventmember_info['eventmember_status'] && !$eventmember_info['eventmember_approved'] )
|
||
|
|
$eventmember_info['eventmember_rsvp_lvid'] = $this->event_rsvp_levels['-1'];
|
||
|
|
elseif( !$eventmember_info['eventmember_status'] && $eventmember_info['eventmember_approved'] )
|
||
|
|
$eventmember_info['eventmember_rsvp_lvid'] = $this->event_rsvp_levels['-2'];
|
||
|
|
else
|
||
|
|
$eventmember_info['eventmember_rsvp_lvid'] = $this->event_rsvp_levels[$eventmember_info['eventmember_rsvp']];
|
||
|
|
|
||
|
|
// SET EVENT ARRAY
|
||
|
|
$eventmember_array[] = array(
|
||
|
|
'eventmember_id' => $eventmember_info['eventmember_id'],
|
||
|
|
'eventmember_status' => $eventmember_info['eventmember_status'],
|
||
|
|
'eventmember_approved' => $eventmember_info['eventmember_approved'],
|
||
|
|
'eventmember_rsvp' => $eventmember_info['eventmember_rsvp'],
|
||
|
|
'eventmember_rsvp_lvid' => $eventmember_info['eventmember_rsvp_lvid'],
|
||
|
|
'eventmember_title' => $eventmember_info['eventmember_title'],
|
||
|
|
'eventmember_rank' => $eventmember_info['eventmember_rank'],
|
||
|
|
'member' => &$member
|
||
|
|
);
|
||
|
|
|
||
|
|
unset($member);
|
||
|
|
}
|
||
|
|
|
||
|
|
return $eventmember_array;
|
||
|
|
}
|
||
|
|
|
||
|
|
// END event_member_list() METHOD
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//
|
||
|
|
// THIS METHOD RETURNS THE PATH TO THE GIVEN EVENT'S DIRECTORY
|
||
|
|
//
|
||
|
|
// INPUT:
|
||
|
|
// $event_id (OPTIONAL) REPRESENTING A EVENT'S EVENT_ID
|
||
|
|
//
|
||
|
|
// OUTPUT:
|
||
|
|
// A STRING REPRESENTING THE RELATIVE PATH TO THE EVENT'S DIRECTORY
|
||
|
|
//
|
||
|
|
|
||
|
|
function event_dir($event_id=NULL)
|
||
|
|
{
|
||
|
|
if( !$event_id && $this->event_exists )
|
||
|
|
$event_id = $this->event_info["event_id"];
|
||
|
|
elseif( !$event_id )
|
||
|
|
return FALSE;
|
||
|
|
|
||
|
|
$subdir = $event_id + 999 - ( ( $event_id - 1 ) % 1000 );
|
||
|
|
$eventdir = "./uploads_event/{$subdir}/{$event_id}/";
|
||
|
|
return $eventdir;
|
||
|
|
}
|
||
|
|
|
||
|
|
// END event_dir() METHOD
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//
|
||
|
|
// THIS METHOD OUTPUTS THE PATH TO THE EVENT'S PHOTO OR THE GIVEN NOPHOTO IMAGE
|
||
|
|
//
|
||
|
|
// INPUT:
|
||
|
|
// $nophoto_image (OPTIONAL) REPRESENTING THE PATH TO AN IMAGE TO OUTPUT IF NO PHOTO EXISTS
|
||
|
|
//
|
||
|
|
// OUTPUT:
|
||
|
|
// A STRING CONTAINING THE PATH TO THE EVENT'S PHOTO
|
||
|
|
//
|
||
|
|
|
||
|
|
function event_photo($nophoto_image=NULL, $thumb=FALSE)
|
||
|
|
{
|
||
|
|
global $database;
|
||
|
|
if( empty($this->event_info['event_photo']) )
|
||
|
|
return $nophoto_image;
|
||
|
|
|
||
|
|
$ex=explode(".", $this->event_info['event_photo']);
|
||
|
|
|
||
|
|
if(is_numeric($ex[0])){
|
||
|
|
$query=$database->database_query("SELECT approved FROM se_eventmedia WHERE eventmedia_id={$ex[0]}");
|
||
|
|
$row=$database->database_fetch_assoc($query);
|
||
|
|
if($row["approved"]!=1){$this->event_info['event_photo']="";}
|
||
|
|
}
|
||
|
|
|
||
|
|
$event_dir = $this->event_dir($this->event_info['event_id']);
|
||
|
|
$event_photo = $event_dir.$this->event_info['event_photo'];
|
||
|
|
|
||
|
|
|
||
|
|
if( $thumb )
|
||
|
|
{
|
||
|
|
$event_thumb = substr($event_photo, 0, strrpos($event_photo, "."))."_thumb".substr($event_photo, strrpos($event_photo, "."));
|
||
|
|
|
||
|
|
return IMAGECDN1.str_replace("./", "",$event_thumb);
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
return IMAGECDN1.str_replace("./", "",$event_photo);
|
||
|
|
|
||
|
|
return $nophoto_image;
|
||
|
|
}
|
||
|
|
|
||
|
|
// END event_photo() METHOD
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//
|
||
|
|
// THIS METHOD UPLOADS AN EVENT PHOTO ACCORDING TO SPECIFICATIONS AND RETURNS EVENT PHOTO
|
||
|
|
//
|
||
|
|
// INPUT:
|
||
|
|
// $photo_name REPRESENTING THE NAME OF THE FILE INPUT
|
||
|
|
//
|
||
|
|
// OUTPUT:
|
||
|
|
// void
|
||
|
|
//
|
||
|
|
|
||
|
|
function event_photo_upload($photo_name)
|
||
|
|
{
|
||
|
|
global $database, $url;
|
||
|
|
|
||
|
|
// SET KEY VARIABLES
|
||
|
|
$file_maxsize = "4194304";
|
||
|
|
$file_exts = explode(",", str_replace(" ", "", strtolower($this->eventowner_level_info['level_event_photo_exts'])));
|
||
|
|
$file_types = explode(",", str_replace(" ", "", strtolower("image/jpeg, image/jpg, image/jpe, image/pjpeg, image/pjpg, image/x-jpeg, x-jpg, image/gif, image/x-gif, image/png, image/x-png")));
|
||
|
|
$file_maxwidth = $this->eventowner_level_info['level_event_photo_width'];
|
||
|
|
$file_maxheight = $this->eventowner_level_info['level_event_photo_height'];
|
||
|
|
$photo_newname = "0_".rand(1000, 9999).".jpg";
|
||
|
|
|
||
|
|
//$file_dest = $this->event_dir($this->event_info['event_id']).$photo_newname;
|
||
|
|
//$thumb_dest = substr($file_dest, 0, strrpos($file_dest, "."))."_thumb".substr($file_dest, strrpos($file_dest, "."));
|
||
|
|
|
||
|
|
$pathinfo = pathinfo($_FILES[$photo_name]['name']);
|
||
|
|
$filename = $pathinfo['filename'];
|
||
|
|
$filename = md5(uniqid());
|
||
|
|
$ext = $pathinfo['extension'];
|
||
|
|
$uniq=uniqid();
|
||
|
|
$photo_newname = $uniq.".".$ext;
|
||
|
|
$photo_newname1 = $uniq."_thumb.".$ext;
|
||
|
|
$file_dest = $this->event_dir($this->event_info['event_id']).$photo_newname;
|
||
|
|
$thumb_dest = $this->event_dir($this->event_info['event_id']).$photo_newname1;
|
||
|
|
// if(SE_DEBUG){mail("leprakhauns@gmail.com", "eee", $file_dest);}
|
||
|
|
$new_photo = new se_upload();
|
||
|
|
$new_photo->new_upload($photo_name, $file_maxsize, $file_exts, $file_types, $file_maxwidth, $file_maxheight);
|
||
|
|
|
||
|
|
// UPLOAD AND RESIZE PHOTO IF NO ERROR
|
||
|
|
if( !$new_photo->is_error )
|
||
|
|
{
|
||
|
|
// DELETE OLD AVATAR IF EXISTS
|
||
|
|
$this->event_photo_delete();
|
||
|
|
|
||
|
|
// UPLOAD THUMB
|
||
|
|
$new_photo->upload_thumb($thumb_dest);
|
||
|
|
|
||
|
|
// CHECK IF IMAGE RESIZING IS AVAILABLE, OTHERWISE MOVE UPLOADED IMAGE
|
||
|
|
if( $new_photo->is_image )
|
||
|
|
$new_photo->upload_photo($file_dest);
|
||
|
|
else
|
||
|
|
$new_photo->upload_file($file_dest);
|
||
|
|
|
||
|
|
// UPDATE EVENT INFO WITH IMAGE IF STILL NO ERROR
|
||
|
|
|
||
|
|
//if(!$database->database_ping())
|
||
|
|
{
|
||
|
|
global $database, $database_host, $database_username, $database_password, $database_name;
|
||
|
|
$database =NULL;
|
||
|
|
$database =& SEDatabase::getInstance();
|
||
|
|
|
||
|
|
|
||
|
|
}
|
||
|
|
if( !$new_photo->is_error )
|
||
|
|
{
|
||
|
|
$sql = "UPDATE se_events SET event_photo='{$photo_newname}' WHERE event_id='{$this->event_info['event_id']}'";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
$this->event_info['event_photo'] = $photo_newname;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
$this->is_error = $new_photo->is_error;
|
||
|
|
$this->error_message = $new_photo->error_message;
|
||
|
|
}
|
||
|
|
|
||
|
|
// END event_photo_upload() METHOD
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//
|
||
|
|
// THIS METHOD DELETES A EVENT PHOTO
|
||
|
|
//
|
||
|
|
// INPUT:
|
||
|
|
// void
|
||
|
|
//
|
||
|
|
// OUTPUT:
|
||
|
|
// void
|
||
|
|
//
|
||
|
|
|
||
|
|
function event_photo_delete()
|
||
|
|
{
|
||
|
|
global $database, $user;
|
||
|
|
|
||
|
|
if( $event_photo=$this->event_photo() )
|
||
|
|
{
|
||
|
|
$sql = "UPDATE se_events SET event_photo='' WHERE event_id='{$this->event_info['event_id']}'";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
$this->event_info['event_photo'] = NULL;
|
||
|
|
@unlink($event_photo);
|
||
|
|
@unlink(str_replace(".", "_thumb.", $event_photo));
|
||
|
|
$client = new MyS3Wrapper([
|
||
|
|
'region' => 'us-north-1',
|
||
|
|
'version' => 'latest',
|
||
|
|
'endpoint' => ENDPOINT,
|
||
|
|
'credentials' => [
|
||
|
|
'key' => AWS_KEY,
|
||
|
|
'secret' => AWS_SECRET_KEY
|
||
|
|
],
|
||
|
|
|
||
|
|
// Set the S3 class to use objects.dreamhost.com/bucket
|
||
|
|
// instead of bucket.objects.dreamhost.com
|
||
|
|
'use_path_style_endpoint' => true
|
||
|
|
]);
|
||
|
|
|
||
|
|
try {
|
||
|
|
$client->deleteObject(array(
|
||
|
|
'Bucket'=>'bateworld',
|
||
|
|
'Key' => str_replace("./", "", $event_photo),
|
||
|
|
|
||
|
|
));}catch (Exception $e) {}
|
||
|
|
|
||
|
|
try {
|
||
|
|
$client->deleteObject(array(
|
||
|
|
'Bucket'=>'bateworld',
|
||
|
|
'Key' => str_replace("./", "", str_replace(".", "_thumb.", $event_photo)),
|
||
|
|
|
||
|
|
));}catch (Exception $e) {}
|
||
|
|
$database->database_query("INSERT INTO bateworldcom_wall.admin_log SET user_id='{$user->user_info["user_id"]}', time='".time()."', action='User has deleted an event photo'");
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
// END event_photo_delete() METHOD
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//
|
||
|
|
// THIS METHOD UPLOADS MEDIA TO A EVENT ALBUM
|
||
|
|
//
|
||
|
|
// INPUT:
|
||
|
|
// $file_name REPRESENTING THE NAME OF THE FILE INPUT
|
||
|
|
// $eventalbum_id REPRESENTING THE ID OF THE EVENT ALBUM TO UPLOAD THE MEDIA TO
|
||
|
|
// $space_left REPRESENTING THE AMOUNT OF SPACE LEFT
|
||
|
|
//
|
||
|
|
// OUTPUT:
|
||
|
|
// void
|
||
|
|
//
|
||
|
|
|
||
|
|
function event_media_upload($file_name, $eventalbum_id, &$space_left)
|
||
|
|
{
|
||
|
|
global $class_event, $database, $url, $user;
|
||
|
|
|
||
|
|
// SET KEY VARIABLES
|
||
|
|
$file_maxsize = $this->eventowner_level_info['level_event_album_maxsize'];
|
||
|
|
$file_exts = explode(",", str_replace(" ", "", strtolower($this->eventowner_level_info['level_event_album_exts'])));
|
||
|
|
$file_types = explode(",", str_replace(" ", "", strtolower($this->eventowner_level_info['level_event_album_mimes'])));
|
||
|
|
$file_maxwidth = $this->eventowner_level_info['level_event_album_width'];
|
||
|
|
$file_maxheight = $this->eventowner_level_info['level_event_album_height'];
|
||
|
|
$time = time();
|
||
|
|
|
||
|
|
$new_media = new se_upload();
|
||
|
|
$new_media->new_upload($file_name, $file_maxsize, $file_exts, $file_types, $file_maxwidth, $file_maxheight);
|
||
|
|
|
||
|
|
// UPLOAD AND RESIZE PHOTO IF NO ERROR
|
||
|
|
if( !$new_media->is_error )
|
||
|
|
{
|
||
|
|
// INSERT ROW INTO MEDIA TABLE
|
||
|
|
$sql = "
|
||
|
|
INSERT INTO se_eventmedia
|
||
|
|
(eventmedia_eventalbum_id, eventmedia_date, eventmedia_user_id, ai, filename)
|
||
|
|
VALUES
|
||
|
|
('{$eventalbum_id}', '{$time}', '".$user->user_info["user_id"]."', '".$database->database_real_escape_string($_POST["ai"])."', '".$database->database_real_escape_string($_FILES[$file_name]['name'])."')
|
||
|
|
";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
$eventmedia_id = $database->database_insert_id();
|
||
|
|
wrapup("eventupload_photo");
|
||
|
|
|
||
|
|
|
||
|
|
// CHECK IF IMAGE RESIZING IS AVAILABLE, OTHERWISE MOVE UPLOADED IMAGE
|
||
|
|
$event_dir = $this->event_dir($this->event_info['event_id']);
|
||
|
|
|
||
|
|
|
||
|
|
$pathinfo = pathinfo($_FILES[$file_name]['name']);
|
||
|
|
|
||
|
|
$filename = $pathinfo['filename'];
|
||
|
|
$filename = md5(uniqid());
|
||
|
|
$ext = $pathinfo['extension'];
|
||
|
|
|
||
|
|
$photo_newname = $eventmedia_id.".".$ext;
|
||
|
|
$photo_newname1 = $eventmedia_id."_thumb.".$ext;
|
||
|
|
|
||
|
|
if(in_array($ext, Array('jpg', 'jpeg', 'png', 'bmp', 'gif'))){$new_media->is_image =1;}
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
if( $new_media->is_image )
|
||
|
|
{
|
||
|
|
$file_dest = "{$event_dir}{$eventmedia_id}.".$ext;
|
||
|
|
$thumb_dest = "{$event_dir}{$eventmedia_id}_thumb.".$ext;
|
||
|
|
|
||
|
|
// UPLOAD THUMB
|
||
|
|
|
||
|
|
|
||
|
|
// UPLOAD PHOTO
|
||
|
|
$new_media->upload_photo($file_dest);
|
||
|
|
$new_media->upload_thumb($thumb_dest, 200);
|
||
|
|
$file_ext = $ext;
|
||
|
|
//$file_filesize = filesize($file_dest);
|
||
|
|
}
|
||
|
|
|
||
|
|
else
|
||
|
|
{
|
||
|
|
$file_dest = "{$event_dir}{$eventmedia_id}.{$new_media->file_ext}";
|
||
|
|
$thumb_dest = "{$event_dir}{$eventmedia_id}_thumb.{$new_media->file_ext}";
|
||
|
|
|
||
|
|
//if( $new_media->file_ext=='gif' )
|
||
|
|
$new_media->upload_thumb($thumb_dest, 200);
|
||
|
|
|
||
|
|
$new_media->upload_file($file_dest);
|
||
|
|
$file_ext = $new_media->file_ext;
|
||
|
|
//$file_filesize = filesize($file_dest);
|
||
|
|
}
|
||
|
|
/*
|
||
|
|
// CHECK SPACE LEFT
|
||
|
|
if( $space_left!==FALSE && $file_filesize>$space_left )
|
||
|
|
{
|
||
|
|
$new_media->is_error = 1;
|
||
|
|
$new_media->error_message = $class_event[1].$_FILES[$file_name]['name']; // TODO LANG
|
||
|
|
}
|
||
|
|
elseif( $space_left!==FALSE )
|
||
|
|
{
|
||
|
|
$space_left = $space_left-$file_filesize;
|
||
|
|
}*/
|
||
|
|
|
||
|
|
//if(!$database->database_ping())
|
||
|
|
if (!is_object($database) && !$database instanceof mysqli)
|
||
|
|
{
|
||
|
|
global $database, $database_host, $database_username, $database_password, $database_name;
|
||
|
|
$database =NULL;
|
||
|
|
$database =& SEDatabase::getInstance();
|
||
|
|
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
// DELETE FROM DATABASE IF ERROR
|
||
|
|
if( $new_media->is_error )
|
||
|
|
{
|
||
|
|
$sql = "DELETE FROM se_eventmedia WHERE eventmedia_id='{$eventmedia_id}' AND eventmedia_eventalbum_id='{$eventalbum_id}'";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
@unlink($file_dest);
|
||
|
|
}
|
||
|
|
|
||
|
|
// UPDATE ROW IF NO ERROR
|
||
|
|
else
|
||
|
|
{
|
||
|
|
$sql = "UPDATE se_eventmedia SET eventmedia_ext='{$file_ext}', eventmedia_filesize='{$file_filesize}', cloud=1 WHERE eventmedia_id='{$eventmedia_id}' AND eventmedia_eventalbum_id='{$eventalbum_id}'";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
|
||
|
|
if( !is_numeric($file_filesize) ) $file_filesize = 0;
|
||
|
|
$sql = "UPDATE se_eventalbums SET eventalbum_totalfiles=eventalbum_totalfiles+1, eventalbum_totalspace=eventalbum_totalspace+'{$file_filesize}' WHERE eventalbum_id='{$eventalbum_id}' LIMIT 1";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
// IF ERROR
|
||
|
|
if( $new_media->is_error )
|
||
|
|
{
|
||
|
|
$new_media->error_message = $_FILES[$file_name]['name']." - ".SE_Language::get($new_media->is_error);
|
||
|
|
}
|
||
|
|
|
||
|
|
// RETURN FILE STATS
|
||
|
|
return array(
|
||
|
|
'is_error' => $new_media->is_error,
|
||
|
|
'error_message' => $new_media->error_message,
|
||
|
|
'file_name' => $_FILES[$file_name]['name'],
|
||
|
|
'eventmedia_id' => $eventmedia_id,
|
||
|
|
'eventmedia_ext' => $file_ext,
|
||
|
|
'eventmedia_filesize' => $file_filesize
|
||
|
|
);
|
||
|
|
}
|
||
|
|
|
||
|
|
// END event_media_upload() METHOD
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//
|
||
|
|
// THIS METHOD RETURNS THE SPACE USED
|
||
|
|
//
|
||
|
|
// INPUT:
|
||
|
|
// $eventalbum_id (OPTIONAL) REPRESENTING THE ID OF THE ALBUM TO CALCULATE
|
||
|
|
//
|
||
|
|
// OUTPUT:
|
||
|
|
// AN INTEGER REPRESENTING THE SPACE USED
|
||
|
|
//
|
||
|
|
|
||
|
|
function event_media_space($eventalbum_id=NULL)
|
||
|
|
{
|
||
|
|
global $database;
|
||
|
|
|
||
|
|
// BEGIN QUERY
|
||
|
|
$sql = "
|
||
|
|
SELECT
|
||
|
|
SUM(se_eventmedia.eventmedia_filesize) AS total_space
|
||
|
|
FROM
|
||
|
|
se_eventalbums
|
||
|
|
LEFT JOIN
|
||
|
|
se_eventmedia
|
||
|
|
ON se_eventalbums.eventalbum_id=se_eventmedia.eventmedia_eventalbum_id
|
||
|
|
";
|
||
|
|
|
||
|
|
// ADD WHERE IF NECESSARY
|
||
|
|
if( $this->event_exists || $eventalbum_id ) $sql .= "
|
||
|
|
WHERE
|
||
|
|
";
|
||
|
|
|
||
|
|
// IF EVENT EXISTS, SPECIFY EVENT ID
|
||
|
|
if( $this->event_exists ) $sql .= "
|
||
|
|
se_eventalbums.eventalbum_event_id='{$this->event_info['event_id']}'
|
||
|
|
";
|
||
|
|
|
||
|
|
// ADD AND IF NECESSARY
|
||
|
|
if( $this->event_exists && $eventalbum_id ) $sql .= " AND";
|
||
|
|
|
||
|
|
// SPECIFY ALBUM ID IF NECESSARY
|
||
|
|
if( $eventalbum_id ) $sql .= "
|
||
|
|
se_eventalbums.eventalbum_id='{$eventalbum_id}'
|
||
|
|
";
|
||
|
|
|
||
|
|
// GET AND RETURN TOTAL SPACE USED
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
$space_info = $database->database_fetch_assoc($resource);
|
||
|
|
return $space_info['total_space'];
|
||
|
|
}
|
||
|
|
|
||
|
|
// END event_media_space() METHOD
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//
|
||
|
|
// THIS METHOD RETURNS THE NUMBER OF EVENT MEDIA
|
||
|
|
//
|
||
|
|
// INPUT:
|
||
|
|
// $eventalbum_id (OPTIONAL) REPRESENTING THE ID OF THE EVENT ALBUM TO CALCULATE
|
||
|
|
//
|
||
|
|
// OUTPUT:
|
||
|
|
// AN INTEGER REPRESENTING THE NUMBER OF FILES
|
||
|
|
//
|
||
|
|
|
||
|
|
function event_media_total($eventalbum_id=NULL)
|
||
|
|
{
|
||
|
|
global $database;
|
||
|
|
|
||
|
|
$sql = "SELECT eventalbum_totalfiles AS total_files FROM se_eventalbums ";
|
||
|
|
|
||
|
|
// ADD WHERE IF NECESSARY
|
||
|
|
if( $this->event_exists || $eventalbum_id ) $sql .= "
|
||
|
|
WHERE
|
||
|
|
";
|
||
|
|
|
||
|
|
// IF EVENT EXISTS, SPECIFY EVENT ID
|
||
|
|
if( $this->event_exists ) $sql .= "
|
||
|
|
se_eventalbums.eventalbum_event_id='{$this->event_info['event_id']}'
|
||
|
|
";
|
||
|
|
|
||
|
|
// ADD AND IF NECESSARY
|
||
|
|
if( $this->event_exists && $eventalbum_id ) $sql .= " AND";
|
||
|
|
|
||
|
|
// SPECIFY ALBUM ID IF NECESSARY
|
||
|
|
if( $eventalbum_id ) $sql .= "
|
||
|
|
se_eventalbums.eventalbum_id='{$eventalbum_id}'
|
||
|
|
";
|
||
|
|
|
||
|
|
// GET AND RETURN TOTAL FILES
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
$file_info = $database->database_fetch_assoc($resource);
|
||
|
|
return $file_info['total_files'];
|
||
|
|
}
|
||
|
|
|
||
|
|
// END event_media_total() METHOD
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//
|
||
|
|
// THIS METHOD RETURNS AN ARRAY OF EVENT MEDIA
|
||
|
|
//
|
||
|
|
// INPUT:
|
||
|
|
// $start REPRESENTING THE EVENT MEDIA TO START WITH
|
||
|
|
// $limit REPRESENTING THE NUMBER OF EVENT MEDIA TO RETURN
|
||
|
|
// $sort_by (OPTIONAL) REPRESENTING THE ORDER BY CLAUSE
|
||
|
|
// $where (OPTIONAL) REPRESENTING ADDITIONAL THINGS TO INCLUDE IN THE WHERE CLAUSE
|
||
|
|
//
|
||
|
|
// OUTPUT:
|
||
|
|
// AN ARRAY OF EVENT MEDIA
|
||
|
|
//
|
||
|
|
|
||
|
|
function event_media_list($start, $limit, $sort_by="eventmedia_id DESC", $where=NULL)
|
||
|
|
{
|
||
|
|
global $database;
|
||
|
|
|
||
|
|
// ???
|
||
|
|
if( !$sort_by ) $sort_by = "eventmedia_id DESC";
|
||
|
|
|
||
|
|
// BEGIN QUERY
|
||
|
|
$sql = "
|
||
|
|
SELECT
|
||
|
|
se_eventmedia.*,
|
||
|
|
se_eventalbums.eventalbum_id,
|
||
|
|
se_eventalbums.eventalbum_event_id,
|
||
|
|
se_eventalbums.eventalbum_title
|
||
|
|
FROM
|
||
|
|
se_eventmedia
|
||
|
|
LEFT JOIN
|
||
|
|
se_eventalbums
|
||
|
|
ON se_eventalbums.eventalbum_id=se_eventmedia.eventmedia_eventalbum_id
|
||
|
|
";
|
||
|
|
|
||
|
|
// ADD WHERE IF NECESSARY
|
||
|
|
if( $this->event_exists || $where ) $sql .= "
|
||
|
|
WHERE approved=1
|
||
|
|
";
|
||
|
|
|
||
|
|
// IF EVENT EXISTS, SPECIFY EVENT ID
|
||
|
|
if( $this->event_exists ) $sql .= "
|
||
|
|
AND se_eventalbums.eventalbum_event_id='{$this->event_info['event_id']}'
|
||
|
|
";
|
||
|
|
|
||
|
|
// ADD AND IF NECESSARY
|
||
|
|
// if( $this->event_exists && $where ) $sql .= " AND";
|
||
|
|
|
||
|
|
// ADD ADDITIONAL WHERE CLAUSE
|
||
|
|
if( $where ) $sql .= " AND
|
||
|
|
$where
|
||
|
|
";
|
||
|
|
|
||
|
|
// ADD GROUP BY, ORDER, AND LIMIT CLAUSE
|
||
|
|
$sql .= "
|
||
|
|
GROUP BY
|
||
|
|
eventmedia_id
|
||
|
|
ORDER BY
|
||
|
|
$sort_by
|
||
|
|
LIMIT
|
||
|
|
$start, $limit
|
||
|
|
";
|
||
|
|
|
||
|
|
// RUN QUERY
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
|
||
|
|
// GET EVENT MEDIA INTO AN ARRAY
|
||
|
|
$eventmedia_array = array();
|
||
|
|
while( $eventmedia_info=$database->database_fetch_assoc($resource) )
|
||
|
|
{
|
||
|
|
$eventmedia_info['eventmedia_desc'] = str_replace("<br />", "\r\n", $eventmedia_info['eventmedia_desc']);
|
||
|
|
$eventmedia_info['eventmedia_comments_total'] = $eventmedia_info['eventmedia_totalcomments'];
|
||
|
|
if($eventmedia_info["cloud"]==1){
|
||
|
|
$eventmedia_info["cdn"]=IMAGECDN1;
|
||
|
|
}else{
|
||
|
|
$eventmedia_info["cdn"]=IMAGECDN;
|
||
|
|
}
|
||
|
|
// CREATE ARRAY OF MEDIA DATA
|
||
|
|
$eventmedia_array[] = $eventmedia_info;
|
||
|
|
}
|
||
|
|
|
||
|
|
return $eventmedia_array;
|
||
|
|
}
|
||
|
|
|
||
|
|
// END event_media_list() METHOD
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//
|
||
|
|
// THIS METHOD UPDATES EVENT MEDIA INFORMATION
|
||
|
|
//
|
||
|
|
// INPUT:
|
||
|
|
// $start REPRESENTING THE EVENT MEDIA TO START WITH
|
||
|
|
// $limit REPRESENTING THE NUMBER OF EVENT MEDIA TO RETURN
|
||
|
|
// $sort_by (OPTIONAL) REPRESENTING THE ORDER BY CLAUSE
|
||
|
|
// $where (OPTIONAL) REPRESENTING ADDITIONAL THINGS TO INCLUDE IN THE WHERE CLAUSE
|
||
|
|
//
|
||
|
|
// OUTPUT:
|
||
|
|
// AN ARRAY CONTAINING ALL THE EVENT MEDIA ID
|
||
|
|
//
|
||
|
|
|
||
|
|
function event_media_update($start, $limit, $sort_by="eventmedia_id DESC", $where=NULL)
|
||
|
|
{
|
||
|
|
global $database;
|
||
|
|
|
||
|
|
// BEGIN QUERY
|
||
|
|
$sql = "
|
||
|
|
SELECT
|
||
|
|
se_eventmedia.*,
|
||
|
|
se_eventalbums.eventalbum_id,
|
||
|
|
se_eventalbums.eventalbum_event_id,
|
||
|
|
se_eventalbums.eventalbum_title
|
||
|
|
FROM
|
||
|
|
se_eventmedia
|
||
|
|
";
|
||
|
|
|
||
|
|
$sql .= "
|
||
|
|
LEFT JOIN
|
||
|
|
se_eventalbums
|
||
|
|
ON se_eventalbums.eventalbum_id=se_eventmedia.eventmedia_eventalbum_id
|
||
|
|
";
|
||
|
|
|
||
|
|
// ADD WHERE IF NECESSARY
|
||
|
|
if( $this->event_exists || $where ) $sql .= "
|
||
|
|
WHERE
|
||
|
|
";
|
||
|
|
|
||
|
|
// IF EVENT EXISTS, SPECIFY EVENT ID
|
||
|
|
if( $this->event_exists ) $sql .= "
|
||
|
|
se_eventalbums.eventalbum_event_id='{$this->event_info['event_id']}'
|
||
|
|
";
|
||
|
|
|
||
|
|
// ADD AND IF NECESSARY
|
||
|
|
if( $this->event_exists && $where ) $sql .= " AND";
|
||
|
|
|
||
|
|
// ADD ADDITIONAL WHERE CLAUSE
|
||
|
|
if( $where ) $sql .= "
|
||
|
|
$where
|
||
|
|
";
|
||
|
|
|
||
|
|
// ADD GROUP BY, ORDER, AND LIMIT CLAUSE
|
||
|
|
$sql .= "
|
||
|
|
GROUP BY
|
||
|
|
eventmedia_id
|
||
|
|
ORDER BY
|
||
|
|
$sort_by
|
||
|
|
LIMIT
|
||
|
|
$start, $limit
|
||
|
|
";
|
||
|
|
|
||
|
|
// RUN QUERY
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
|
||
|
|
// GET EVENT MEDIA INTO AN ARRAY
|
||
|
|
$eventmedia_array = array();
|
||
|
|
while( $eventmedia_info=$database->database_fetch_assoc($eventmedia) )
|
||
|
|
{
|
||
|
|
$var1 = "eventmedia_title_{$eventmedia_info['eventmedia_id']}";
|
||
|
|
$var2 = "eventmedia_desc_{$eventmedia_info['eventmedia_id']}";
|
||
|
|
$eventmedia_title = censor($_POST[$var1]);
|
||
|
|
$eventmedia_desc = censor(str_replace("\r\n", "<br>", $_POST[$var2]));
|
||
|
|
if( $eventmedia_title!=$eventmedia_info["eventmedia_title"] || $eventmedia_desc!=$eventmedia_info["eventmedia_desc"] )
|
||
|
|
{
|
||
|
|
$sql = "UPDATE se_eventmedia SET eventmedia_title='{$eventmedia_title}', eventmedia_desc='{$eventmedia_desc}' WHERE eventmedia_id='{$eventmedia_info['eventmedia_id']}'";
|
||
|
|
$database->database_query($sql);
|
||
|
|
}
|
||
|
|
$eventmedia_array[] = $eventmedia_info['eventmedia_id'];
|
||
|
|
}
|
||
|
|
|
||
|
|
return $eventmedia_array;
|
||
|
|
}
|
||
|
|
|
||
|
|
// END event_media_update() METHOD
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//
|
||
|
|
// THIS METHOD DELETES SELECTED EVENT MEDIA
|
||
|
|
//
|
||
|
|
// INPUT:
|
||
|
|
// $start REPRESENTING THE EVENT MEDIA TO START WITH
|
||
|
|
// $limit REPRESENTING THE NUMBER OF EVENT MEDIA TO RETURN
|
||
|
|
// $sort_by (OPTIONAL) REPRESENTING THE ORDER BY CLAUSE
|
||
|
|
// $where (OPTIONAL) REPRESENTING ADDITIONAL THINGS TO INCLUDE IN THE WHERE CLAUSE
|
||
|
|
//
|
||
|
|
// OUTPUT:
|
||
|
|
// void
|
||
|
|
//
|
||
|
|
|
||
|
|
function event_media_delete($start, $limit, $sort_by = "eventmedia_id DESC", $where = "")
|
||
|
|
{
|
||
|
|
global $database, $url;
|
||
|
|
|
||
|
|
// BEGIN QUERY
|
||
|
|
$eventmedia_query = "
|
||
|
|
SELECT
|
||
|
|
se_eventmedia.*,
|
||
|
|
se_eventalbums.eventalbum_id,
|
||
|
|
se_eventalbums.eventalbum_event_id,
|
||
|
|
se_eventalbums.eventalbum_title
|
||
|
|
";
|
||
|
|
|
||
|
|
// CONTINUE QUERY
|
||
|
|
$eventmedia_query .= "
|
||
|
|
FROM
|
||
|
|
se_eventmedia
|
||
|
|
LEFT JOIN
|
||
|
|
se_eventalbums
|
||
|
|
ON se_eventalbums.eventalbum_id=se_eventmedia.eventmedia_eventalbum_id
|
||
|
|
";
|
||
|
|
|
||
|
|
// ADD WHERE IF NECESSARY
|
||
|
|
if($this->event_exists != 0 | $where != "") { $eventmedia_query .= " WHERE"; }
|
||
|
|
|
||
|
|
// IF EVENT EXISTS, SPECIFY EVENT ID
|
||
|
|
if($this->event_exists != 0) { $eventmedia_query .= " se_eventalbums.eventalbum_event_id='{$this->event_info['event_id']}'"; }
|
||
|
|
|
||
|
|
// ADD AND IF NECESSARY
|
||
|
|
if($this->event_exists != 0 & $where != "") { $eventmedia_query .= " AND"; }
|
||
|
|
|
||
|
|
// ADD ADDITIONAL WHERE CLAUSE
|
||
|
|
if($where != "") { $eventmedia_query .= " $where"; }
|
||
|
|
|
||
|
|
// ADD GROUP BY, ORDER, AND LIMIT CLAUSE
|
||
|
|
$eventmedia_query .= " GROUP BY eventmedia_id ORDER BY $sort_by LIMIT $start, $limit";
|
||
|
|
|
||
|
|
// RUN QUERY
|
||
|
|
$eventmedia = $database->database_query($eventmedia_query);
|
||
|
|
|
||
|
|
// LOOP OVER EVENT MEDIA
|
||
|
|
$eventmedia_delete = "";
|
||
|
|
while($eventmedia_info = $database->database_fetch_assoc($eventmedia))
|
||
|
|
{
|
||
|
|
$var = "delete_eventmedia_".$eventmedia_info['eventmedia_id'];
|
||
|
|
if($_POST[$var] == 1)
|
||
|
|
{
|
||
|
|
if($eventmedia_delete != "") { $eventmedia_delete .= " OR "; }
|
||
|
|
$eventmedia_delete .= "eventmedia_id='{$eventmedia_info['eventmedia_id']}'";
|
||
|
|
$eventmedia_path = $this->event_dir($this->event_info['event_id']).$eventmedia_info['eventmedia_id'].".".$eventmedia_info['eventmedia_ext'];
|
||
|
|
if(file_exists($eventmedia_path)) { unlink($eventmedia_path); }
|
||
|
|
$client = new MyS3Wrapper([
|
||
|
|
'region' => 'us-north-1',
|
||
|
|
'version' => 'latest',
|
||
|
|
'endpoint' => ENDPOINT,
|
||
|
|
'credentials' => [
|
||
|
|
'key' => AWS_KEY,
|
||
|
|
'secret' => AWS_SECRET_KEY
|
||
|
|
],
|
||
|
|
|
||
|
|
// Set the S3 class to use objects.dreamhost.com/bucket
|
||
|
|
// instead of bucket.objects.dreamhost.com
|
||
|
|
'use_path_style_endpoint' => true
|
||
|
|
]);
|
||
|
|
|
||
|
|
try {
|
||
|
|
$client->deleteObject(array(
|
||
|
|
'Bucket'=>'bateworld',
|
||
|
|
'Key' => str_replace("./", "", $eventmedia_path),
|
||
|
|
|
||
|
|
));}catch (Exception $e) {}
|
||
|
|
$thumb_path = $this->event_dir($this->event_info['event_id']).$eventmedia_info['eventmedia_id']."_thumb.".$eventmedia_info['eventmedia_ext'];
|
||
|
|
if(file_exists($thumb_path)) { unlink($thumb_path); }
|
||
|
|
try {
|
||
|
|
$client->deleteObject(array(
|
||
|
|
'Bucket'=>'bateworld',
|
||
|
|
'Key' => str_replace("./", "", $thumb_path),
|
||
|
|
|
||
|
|
));}catch (Exception $e) {}
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
if( !is_numeric($eventmedia_info['eventmedia_filesize']) ) $eventmedia_info['eventmedia_filesize'] = 0;
|
||
|
|
$sql = "UPDATE se_eventalbums SET eventalbum_totalfiles=eventalbum_totalfiles-1, eventalbum_totalspace=eventalbum_totalspace-'{$eventmedia_info['eventmedia_filesize']}' WHERE eventalbum_id='{$eventmedia_info['eventmedia_eventalbum_id']}' LIMIT 1";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
}
|
||
|
|
|
||
|
|
$sql = "DELETE FROM se_eventmedia, se_eventmediacomments USING se_eventmedia LEFT JOIN se_eventmediacomments ON se_eventmedia.eventmedia_id=se_eventmediacomments.eventmediacomment_eventmedia_id WHERE se_eventmedia.eventmedia_id='".$eventmedia_info['eventmedia_id']."'";
|
||
|
|
$database->database_query($sql);
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
// IF DELETE CLAUSE IS NOT EMPTY, DELETE EVENT MEDIA
|
||
|
|
if($eventmedia_delete != "") { $database->database_query("DELETE FROM se_eventmedia, se_eventmediacomments USING se_eventmedia LEFT JOIN se_eventmediacomments ON se_eventmedia.eventmedia_id=se_eventmediacomments.eventmediacomment_eventmedia_id WHERE ($eventmedia_delete)"); }
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
// END event_media_delete() METHOD
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//
|
||
|
|
// THIS METHOD
|
||
|
|
//
|
||
|
|
|
||
|
|
function event_calendar_generate($date, $view="month")
|
||
|
|
{
|
||
|
|
global $database, $datetime, $global_timezone, $user;
|
||
|
|
|
||
|
|
// Make sure date is numeric
|
||
|
|
if( !is_numeric($date) ) $date = time();
|
||
|
|
|
||
|
|
// Reset to beginning of period/Get next and last periods/Get number of periods
|
||
|
|
if( $view=="day" )
|
||
|
|
{
|
||
|
|
$date = mktime(0, 0, 0, date("m", $date), date("j", $date), date("Y", $date));
|
||
|
|
$date_next = mktime(0, 0, 0, date("m", $date), date("j", $date) + 1, date("Y", $date));
|
||
|
|
$date_last = mktime(0, 0, 0, date("m", $date), date("j", $date) - 1, date("Y", $date));
|
||
|
|
$date_selector = "G";
|
||
|
|
}
|
||
|
|
|
||
|
|
elseif( $view=="month" )
|
||
|
|
{
|
||
|
|
$date = mktime(0, 0, 0, date("m", $date), 1, date("Y", $date));
|
||
|
|
$date_next = mktime(0, 0, 0, date("m", $date) + 1, 1, date("Y", $date));
|
||
|
|
$date_last = mktime(0, 0, 0, date("m", $date) - 1, 1, date("Y", $date));
|
||
|
|
$date_selector = "j";
|
||
|
|
}
|
||
|
|
|
||
|
|
elseif( $view=="year" )
|
||
|
|
{
|
||
|
|
$date = mktime(0, 0, 0, 1, 1, date("Y", $date));
|
||
|
|
$date_next = mktime(0, 0, 0, 1, 1, date("Y", $date) + 1);
|
||
|
|
$date_last = mktime(0, 0, 0, 1, 1, date("Y", $date) - 1);
|
||
|
|
$date_selector = "m";
|
||
|
|
$date_selector2 = "j";
|
||
|
|
}
|
||
|
|
|
||
|
|
// SELECT EVENTS
|
||
|
|
$sql = "
|
||
|
|
SELECT
|
||
|
|
event_id,
|
||
|
|
event_title,
|
||
|
|
event_date_start
|
||
|
|
FROM
|
||
|
|
se_events
|
||
|
|
WHERE
|
||
|
|
event_user_id='{$this->user_id}' &&
|
||
|
|
event_date_start>='{$date_next}' &&
|
||
|
|
event_date_start<='{$date_last}'
|
||
|
|
";
|
||
|
|
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
|
||
|
|
$event_array = array();
|
||
|
|
while( $event_info=$database->database_fetch_assoc($resource) )
|
||
|
|
{
|
||
|
|
$event_info['event_period_value'] = date("{$date_selector}", $event_info['event_date_start']);
|
||
|
|
if( $date_selector2 )
|
||
|
|
$event_info['event_period_value2'] = date("{$date_selector2}", $event_info['event_date_start']);
|
||
|
|
|
||
|
|
$event_array[] = $event_info;
|
||
|
|
}
|
||
|
|
|
||
|
|
return array(
|
||
|
|
'date' => $date,
|
||
|
|
'date_next' => $date_next,
|
||
|
|
'date_last' => $date_last,
|
||
|
|
'events' => &$event_array
|
||
|
|
);
|
||
|
|
}
|
||
|
|
|
||
|
|
// END event_calendar_generate() METHOD
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//
|
||
|
|
// THIS METHOD IS USED TO INVITE USERS TO AN EVENT
|
||
|
|
//
|
||
|
|
|
||
|
|
function event_member_invite($user_ids)
|
||
|
|
{
|
||
|
|
global $user, $database, $url, $notify;
|
||
|
|
|
||
|
|
if( empty($user_ids) )
|
||
|
|
return FALSE;
|
||
|
|
|
||
|
|
if( !is_array($user_ids) )
|
||
|
|
$user_ids = array($user_ids);
|
||
|
|
|
||
|
|
/*if( count($user_ids)>10 )
|
||
|
|
array_splice($user_ids, 10);*/
|
||
|
|
|
||
|
|
// GET INVITED USER INFO AND CHECK IF ALREADY IS MEMBER OR BEEN INVITED
|
||
|
|
$sql = "
|
||
|
|
SELECT
|
||
|
|
se_users.user_id,
|
||
|
|
se_users.user_username,
|
||
|
|
se_users.user_fname,
|
||
|
|
se_users.user_lname,
|
||
|
|
se_users.user_email,
|
||
|
|
se_usersettings.usersetting_notify_eventinvite
|
||
|
|
FROM
|
||
|
|
se_users
|
||
|
|
LEFT JOIN
|
||
|
|
se_usersettings
|
||
|
|
ON se_users.user_id=se_usersettings.usersetting_user_id
|
||
|
|
LEFT JOIN
|
||
|
|
se_eventmembers
|
||
|
|
ON (se_users.user_id=se_eventmembers.eventmember_user_id && se_eventmembers.eventmember_event_id='{$this->event_info['event_id']}')
|
||
|
|
WHERE
|
||
|
|
se_users.user_id IN('".join("', '", $user_ids)."') &&
|
||
|
|
se_eventmembers.eventmember_id IS NULL
|
||
|
|
";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
|
||
|
|
// USER DOES NOT EXIST OR HAS ALREADY BEEN INVITED
|
||
|
|
if( !$database->database_num_rows($resource) )
|
||
|
|
return FALSE;
|
||
|
|
|
||
|
|
// INSERT INTO MEMBERS
|
||
|
|
$invites_sent = 0;
|
||
|
|
while( $user_info = $database->database_fetch_assoc($resource) )
|
||
|
|
{
|
||
|
|
// Create user object for displayname
|
||
|
|
$recipient_object = new se_user();
|
||
|
|
$recipient_object->user_info['user_id'] = $user_info['user_id'];
|
||
|
|
$recipient_object->user_info['user_username'] = $user_info['user_username'];
|
||
|
|
$recipient_object->user_info['user_fname'] = $user_info['user_fname'];
|
||
|
|
$recipient_object->user_info['user_lname'] = $user_info['user_lname'];
|
||
|
|
$recipient_object->user_displayname();
|
||
|
|
|
||
|
|
// INSERT INTO EVENT MEMBERS
|
||
|
|
$members=$database->database_query("SELECT eventmember_user_id FROM se_eventmembers WHERE eventmember_user_id='".$user_info["user_id"]."' AND eventmember_event_id='{$this->event_info['event_id']}' LIMIT 1");
|
||
|
|
$row=$database->database_fetch_array($members);
|
||
|
|
if($row["eventmember_user_id"]==""){
|
||
|
|
$sql = "INSERT INTO se_eventmembers (eventmember_user_id, eventmember_event_id, eventmember_status, eventmember_approved) VALUES ('{$user_info['user_id']}','{$this->event_info['event_id']}','0', '1')";
|
||
|
|
$database->database_query($sql);
|
||
|
|
|
||
|
|
// NOTIFICATION
|
||
|
|
$notifytype = $notify->notify_add(
|
||
|
|
$recipient_object->user_info['user_id'],
|
||
|
|
"eventinvite",
|
||
|
|
$this->event_info['event_id'],
|
||
|
|
Array(
|
||
|
|
$user->user_info['user_username'],
|
||
|
|
$this->event_info['event_id']
|
||
|
|
),
|
||
|
|
Array(
|
||
|
|
$this->event_info['event_title'],
|
||
|
|
), FALSE, $user->user_info["user_id"]
|
||
|
|
);
|
||
|
|
|
||
|
|
|
||
|
|
// EMAIL NOTIFICATION
|
||
|
|
if( $user_info['usersetting_notify_eventinvite'] )
|
||
|
|
{
|
||
|
|
$replace=array("[displayname]"=>$recipient_object->user_displayname,
|
||
|
|
"[username]"=>$user->user_info['user_username'],
|
||
|
|
"[eventname]"=>$this->event_info['event_title'],
|
||
|
|
"[link]"=>"<a href=\"{$url->url_base}event.php?event_id=".$this->event_info['event_id']."\">{$url->url_base}event.php?event_id=".$this->event_info['event_id']."</a>");
|
||
|
|
|
||
|
|
send_systememail('eventinvite', $user_info['user_email'], $replace);
|
||
|
|
|
||
|
|
//send_systememail( 'eventinvite', $user_info['user_email'], array( $recipient_object->user_displayname, $this->event_info['event_title'], "<a href=\"{$url->url_base}login.php\">{$url->url_base}login.php</a>" ) );
|
||
|
|
}
|
||
|
|
|
||
|
|
$invites_sent++;
|
||
|
|
unset($recipient_object);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
return $invites_sent;
|
||
|
|
}
|
||
|
|
|
||
|
|
// END event_member_invite() METHOD
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//
|
||
|
|
// THIS METHOD IS USED TO APPROVE AN INVITATION REQUEST
|
||
|
|
//
|
||
|
|
|
||
|
|
function event_member_approve($eventmember_user_id)
|
||
|
|
{
|
||
|
|
global $database, $actions, $user;
|
||
|
|
|
||
|
|
// VERIFY ABILITY
|
||
|
|
if( !$this->event_exists || $this->user_rank<2 )
|
||
|
|
{
|
||
|
|
$this->is_error = 3000248;
|
||
|
|
return FALSE;
|
||
|
|
}
|
||
|
|
|
||
|
|
// GET MEMBER INFO
|
||
|
|
$sql = "
|
||
|
|
SELECT
|
||
|
|
se_eventmembers.*,
|
||
|
|
se_users.user_id,
|
||
|
|
se_users.user_username,
|
||
|
|
se_users.user_fname,
|
||
|
|
se_users.user_lname
|
||
|
|
FROM
|
||
|
|
se_eventmembers
|
||
|
|
LEFT JOIN
|
||
|
|
se_users
|
||
|
|
ON se_users.user_id=se_eventmembers.eventmember_user_id
|
||
|
|
WHERE
|
||
|
|
eventmember_approved=0 &&
|
||
|
|
eventmember_user_id='{$eventmember_user_id}' &&
|
||
|
|
eventmember_event_id='{$this->event_info['event_id']}'
|
||
|
|
LIMIT
|
||
|
|
1
|
||
|
|
";
|
||
|
|
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
|
||
|
|
if( !$database->database_num_rows($resource) )
|
||
|
|
{
|
||
|
|
$this->is_error = 3000251;
|
||
|
|
return FALSE;
|
||
|
|
}
|
||
|
|
|
||
|
|
$eventmember_info = $database->database_fetch_assoc($resource);
|
||
|
|
|
||
|
|
// UPDATE MEMBER INFO
|
||
|
|
$sql = "UPDATE se_eventmembers SET eventmember_status=1, eventmember_approved=1 WHERE eventmember_user_id='{$eventmember_user_id}' && eventmember_event_id='{$this->event_info['event_id']}' LIMIT 1";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
$result = (bool) $database->database_affected_rows($resource);
|
||
|
|
|
||
|
|
// INCREMENT MEMBER COUNT
|
||
|
|
$sql = "UPDATE se_events SET event_totalmembers=event_totalmembers+1 WHERE event_id='{$this->event_info['event_id']}' LIMIT 1";
|
||
|
|
$database->database_query($sql);
|
||
|
|
|
||
|
|
// REMOVE NOTIFICATIONS
|
||
|
|
//$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='{$this->event_info['event_user_id']}' AND se_notifytypes.notifytype_name='eventmemberrequest' AND notify_object_id='{$this->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='{$this->event_info['event_user_id']}' AND se_notifytypes.notifytype_name='eventmemberrequest' AND notify_object_id='{$this->event_info['event_id']}'";
|
||
|
|
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
|
||
|
|
// INSERT ACTION
|
||
|
|
$approved_user = new se_user();
|
||
|
|
$approved_user->user_info['user_id'] = $eventmember_info['user_id'];
|
||
|
|
$approved_user->user_info['user_username'] = $eventmember_info['user_username'];
|
||
|
|
$approved_user->user_info['user_fname'] = $eventmember_info['user_fname'];
|
||
|
|
$approved_user->user_info['user_lname'] = $eventmember_info['user_lname'];
|
||
|
|
$approved_user->user_displayname();
|
||
|
|
|
||
|
|
$event_title = $this->event_info['event_title'];
|
||
|
|
if(strlen($event_title) > 100) { $event_title = substr($event_title, 0, 97)."..."; }
|
||
|
|
$actions->actions_add(
|
||
|
|
$approved_user,
|
||
|
|
"joinevent",
|
||
|
|
Array(
|
||
|
|
$approved_user->user_info['user_username'],
|
||
|
|
$approved_user->user_displayname,
|
||
|
|
$this->event_info['event_id'],
|
||
|
|
$event_title
|
||
|
|
),
|
||
|
|
NULL,
|
||
|
|
60,
|
||
|
|
FALSE,
|
||
|
|
"event",
|
||
|
|
$this->event_info['event_id'],
|
||
|
|
$this->event_info['event_privacy']
|
||
|
|
);
|
||
|
|
|
||
|
|
return $result;
|
||
|
|
}
|
||
|
|
|
||
|
|
// END event_member_approve() METHOD
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//
|
||
|
|
// THIS METHOD IS USED TO REJECT AN INVITATION REQUEST
|
||
|
|
//
|
||
|
|
|
||
|
|
function event_member_reject($eventmember_user_id)
|
||
|
|
{
|
||
|
|
global $database;
|
||
|
|
|
||
|
|
// VERIFY ABILITY
|
||
|
|
if( !$this->event_exists || $this->user_rank<2 )
|
||
|
|
{
|
||
|
|
$this->is_error = 3000248;
|
||
|
|
return FALSE;
|
||
|
|
}
|
||
|
|
|
||
|
|
// GET MEMBER INFO
|
||
|
|
$sql = "SELECT * FROM se_eventmembers WHERE eventmember_approved=0 && eventmember_user_id='{$eventmember_user_id}' && eventmember_event_id='{$this->event_info['event_id']}' LIMIT 1";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
|
||
|
|
if( !$database->database_num_rows($resource) )
|
||
|
|
{
|
||
|
|
$this->is_error = 3000251;
|
||
|
|
return FALSE;
|
||
|
|
}
|
||
|
|
|
||
|
|
// UPDATE MEMBER INFO
|
||
|
|
$sql = "DELETE FROM se_eventmembers WHERE eventmember_user_id='{$eventmember_user_id}' && eventmember_event_id='{$this->event_info['event_id']}' LIMIT 1";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
$result = (bool) $database->database_affected_rows($resource);
|
||
|
|
|
||
|
|
// REMOVE NOTIFICATIONS
|
||
|
|
//$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='{$this->event_info['event_user_id']}' AND se_notifytypes.notifytype_name='eventmemberrequest' AND notify_object_id='{$this->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='{$this->event_info['event_user_id']}' AND se_notifytypes.notifytype_name='eventmemberrequest' AND notify_object_id='{$this->event_info['event_id']}'";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
|
||
|
|
return $result;
|
||
|
|
}
|
||
|
|
|
||
|
|
// END event_member_reject() METHOD
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//
|
||
|
|
// THIS METHOD IS USED TO CANCEL AN INVITATION REQUEST (EVENT OWNER->USER)
|
||
|
|
//
|
||
|
|
|
||
|
|
function event_member_cancel($eventmember_user_id)
|
||
|
|
{
|
||
|
|
global $database;
|
||
|
|
|
||
|
|
if(SE_DEBUG1){send_admin("sean@bateworld.com", "RRR", $eventmember_user_id);}
|
||
|
|
// VERIFY ABILITY
|
||
|
|
if( !$this->event_exists || $this->user_rank<2 )
|
||
|
|
{
|
||
|
|
if(SE_DEBUG1){send_admin("sean@bateworld.com", "ttt", $eventmember_user_id);}
|
||
|
|
$this->is_error = 3000248;
|
||
|
|
return FALSE;
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
// GET MEMBER INFO
|
||
|
|
$sql = "SELECT * FROM se_eventmembers WHERE eventmember_approved=1 && eventmember_status=0 && eventmember_user_id='{$eventmember_user_id}' && eventmember_event_id='{$this->event_info['event_id']}' LIMIT 1";
|
||
|
|
if(SE_DEBUG1){send_admin("sean@bateworld.com", "eee", $sql);}
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
|
||
|
|
if( !$database->database_num_rows($resource) )
|
||
|
|
{
|
||
|
|
$this->is_error = 3000251;
|
||
|
|
return FALSE;
|
||
|
|
}
|
||
|
|
|
||
|
|
// UPDATE MEMBER INFO
|
||
|
|
$sql = "DELETE FROM se_eventmembers WHERE eventmember_user_id='{$eventmember_user_id}' && eventmember_event_id='{$this->event_info['event_id']}' LIMIT 1";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
$result = (bool) $database->database_affected_rows($resource);
|
||
|
|
|
||
|
|
|
||
|
|
// REMOVE NOTIFICATIONS
|
||
|
|
// $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='{$this->event_info['event_user_id']}' AND se_notifytypes.notifytype_name='eventinvite' AND notify_object_id='{$member_info['eventmember_user_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='{$this->event_info['event_user_id']}' AND se_notifytypes.notifytype_name='eventinvite' AND notify_object_id='{$member_info['eventmember_user_id']}'";
|
||
|
|
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
|
||
|
|
return $result;
|
||
|
|
}
|
||
|
|
|
||
|
|
// END event_member_cancel() METHOD
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//
|
||
|
|
// THIS METHOD IS USED TO REMOVE AN EVENT MEMBER (EVENT OWNER->USER)
|
||
|
|
//
|
||
|
|
|
||
|
|
function event_member_remove($eventmember_user_id)
|
||
|
|
{
|
||
|
|
global $database;
|
||
|
|
|
||
|
|
// VERIFY ABILITY
|
||
|
|
if( !$this->event_exists || $this->user_rank<2 )
|
||
|
|
{
|
||
|
|
$this->is_error = 3000248;
|
||
|
|
return FALSE;
|
||
|
|
}
|
||
|
|
|
||
|
|
// GET MEMBER INFO
|
||
|
|
$sql = "SELECT * FROM se_eventmembers WHERE eventmember_approved=1 && eventmember_status=1 && eventmember_user_id='{$eventmember_user_id}' && eventmember_event_id='{$this->event_info['event_id']}' LIMIT 1";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
|
||
|
|
if( !$database->database_num_rows($resource) )
|
||
|
|
{
|
||
|
|
$this->is_error = 3000251;
|
||
|
|
return FALSE;
|
||
|
|
}
|
||
|
|
|
||
|
|
// UPDATE MEMBER INFO
|
||
|
|
$sql = "DELETE FROM se_eventmembers WHERE eventmember_user_id='{$eventmember_user_id}' && eventmember_event_id='{$this->event_info['event_id']}' LIMIT 1";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
$result = (bool) $database->database_affected_rows($resource);
|
||
|
|
|
||
|
|
// DECREMENT MEMBER COUNT
|
||
|
|
$sql = "UPDATE se_events SET event_totalmembers=event_totalmembers-1 WHERE event_id='{$this->event_info['event_id']}' LIMIT 1";
|
||
|
|
$database->database_query($sql);
|
||
|
|
|
||
|
|
return $result;
|
||
|
|
}
|
||
|
|
|
||
|
|
// END event_member_remove() METHOD
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//
|
||
|
|
// THIS METHOD
|
||
|
|
//
|
||
|
|
|
||
|
|
function event_join()
|
||
|
|
{
|
||
|
|
global $user, $database, $url, $actions, $notify;
|
||
|
|
|
||
|
|
// JOIN
|
||
|
|
if( !$this->is_member && !$this->is_member_waiting )
|
||
|
|
{
|
||
|
|
$new_member_approved = ( $this->event_info['event_inviteonly'] ? '0' : '1' );
|
||
|
|
|
||
|
|
// INSERT
|
||
|
|
$members=$database->database_query("SELECT eventmember_user_id FROM se_eventmembers WHERE eventmember_user_id='".$user_info["user_id"]."' AND eventmember_event_id='{$this->event_info['event_id']}' LIMIT 1");
|
||
|
|
$row=$database->database_fetch_array($members);
|
||
|
|
if($row["eventmember_user_id"]==""){
|
||
|
|
$sql = "INSERT INTO se_eventmembers (eventmember_user_id, eventmember_event_id, eventmember_status, eventmember_approved, eventmember_rank) VALUES ('{$this->user_id}', '{$this->event_info['event_id']}', '1', '{$new_member_approved}', '1')";
|
||
|
|
$database->database_query($sql);
|
||
|
|
wrapup("event_join");
|
||
|
|
addspampoint(12, $this->user_id);
|
||
|
|
// UPDATE MEMBER INFO
|
||
|
|
$this->is_member = (bool) $new_member_approved;
|
||
|
|
$this->is_member_waiting = !$new_member_approved;
|
||
|
|
$this->eventmember_info['eventmember_approved'] = (int) $new_member_approved;
|
||
|
|
|
||
|
|
// NOTIFY EVENT OWNER IF REQUESTING APPROVAL
|
||
|
|
if( !$new_member_approved )
|
||
|
|
{
|
||
|
|
$sql = "SELECT se_users.user_id, se_users.user_username, se_users.user_email, se_users.user_fname, se_users.user_lname, se_usersettings.usersetting_notify_eventmemberrequest FROM se_users LEFT JOIN se_usersettings ON se_users.user_id=se_usersettings.usersetting_user_id WHERE se_users.user_id='{$this->event_info['event_user_id']}'";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
|
||
|
|
if( !$database->database_num_rows($resource) )
|
||
|
|
return FALSE;
|
||
|
|
|
||
|
|
$eventowner_info = $database->database_fetch_assoc($resource);
|
||
|
|
|
||
|
|
// Create user object for displayname
|
||
|
|
$recipient_object = new se_user();
|
||
|
|
$recipient_object->user_info['user_id'] = $eventowner_info['user_id'];
|
||
|
|
$recipient_object->user_info['user_username'] = $eventowner_info['user_username'];
|
||
|
|
$recipient_object->user_info['user_fname'] = $eventowner_info['user_fname'];
|
||
|
|
$recipient_object->user_info['user_lname'] = $eventowner_info['user_lname'];
|
||
|
|
$recipient_object->user_displayname();
|
||
|
|
|
||
|
|
// NOTIFICATION
|
||
|
|
$notifytype = $notify->notify_add(
|
||
|
|
$recipient_object->user_info['user_id'],
|
||
|
|
"eventmemberrequest",
|
||
|
|
$this->event_info['event_id'],
|
||
|
|
Array(
|
||
|
|
$user->user_info['user_username'],
|
||
|
|
$this->event_info['event_id']
|
||
|
|
),
|
||
|
|
Array(
|
||
|
|
$this->event_info['event_title'],
|
||
|
|
), FALSE, $user->user_info["user_id"]
|
||
|
|
);
|
||
|
|
|
||
|
|
if( $eventowner_info['usersetting_notify_eventmemberrequest'] )
|
||
|
|
{
|
||
|
|
|
||
|
|
$replace=array("[displayname]"=>$recipient_object->user_displayname,
|
||
|
|
"[requester]"=>$user-user_displayname,
|
||
|
|
"[eventname]"=>$this->event_info['event_title'],
|
||
|
|
"[link]"=>"<a href=\"{$url->url_base}login.php\">{$url->url_base}login.php</a>" );
|
||
|
|
|
||
|
|
send_systememail('eventmemberrequest',$eventowner_info['user_email'],$replace);
|
||
|
|
|
||
|
|
//send_systememail( 'eventmemberrequest', $eventowner_info['user_email'], array( $recipient_object->user_displayname, $user-user_displayname, $this->event_info['event_title'], "<a href=\"{$url->url_base}login.php\">{$url->url_base}login.php</a>" ) );
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
// OTHERWISE INCREMENT MEMBER COUNT
|
||
|
|
else
|
||
|
|
{
|
||
|
|
$sql = "UPDATE se_events SET event_totalmembers=event_totalmembers+1 WHERE event_id='{$this->event_info['event_id']}' LIMIT 1";
|
||
|
|
$database->database_query($sql);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
// ACCEPT INVITATION
|
||
|
|
elseif( $this->is_member_waiting && $this->eventmember_info['eventmember_approved'] )
|
||
|
|
{
|
||
|
|
$sql = "UPDATE se_eventmembers SET eventmember_status=1 WHERE eventmember_event_id='{$this->event_info['event_id']}' && eventmember_user_id='{$this->user_id}' LIMIT 1";
|
||
|
|
$database->database_query($sql);
|
||
|
|
|
||
|
|
// INCREMENT MEMBER COUNT
|
||
|
|
$sql = "UPDATE se_events SET event_totalmembers=event_totalmembers+1 WHERE event_id='{$this->event_info['event_id']}' LIMIT 1";
|
||
|
|
$database->database_query($sql);
|
||
|
|
|
||
|
|
// UPDATE MEMBER INFO
|
||
|
|
$this->is_member = TRUE;
|
||
|
|
$this->is_member_waiting = FALSE;
|
||
|
|
$this->eventmember_info['eventmember_status'] = 1;
|
||
|
|
}
|
||
|
|
|
||
|
|
// SECURITY
|
||
|
|
else
|
||
|
|
{
|
||
|
|
$this->is_error = 3000248;
|
||
|
|
return FALSE;
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
// DELETE NOTIFICATION
|
||
|
|
// $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='{$this->user_id}' AND se_notifytypes.notifytype_name='eventinvite' AND notify_object_id='{$this->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='{$this->user_id}' AND se_notifytypes.notifytype_name='eventinvite' AND notify_object_id='{$this->event_info['event_id']}'";
|
||
|
|
|
||
|
|
$database->database_query($sql);
|
||
|
|
|
||
|
|
|
||
|
|
// INSERT ACTION IF NOT REQUESTING APPROVAL
|
||
|
|
if( $new_member_approved || !empty($this->eventmember_info['eventmember_approved']) )
|
||
|
|
{
|
||
|
|
$event_title = $this->event_info['event_title'];
|
||
|
|
if(strlen($event_title) > 100) { $event_title = substr($event_title, 0, 97)."..."; }
|
||
|
|
$actions->actions_add(
|
||
|
|
$user,
|
||
|
|
"joinevent",
|
||
|
|
Array(
|
||
|
|
$user->user_info['user_username'],
|
||
|
|
$user->user_displayname,
|
||
|
|
$this->event_info['event_id'],
|
||
|
|
$event_title
|
||
|
|
),
|
||
|
|
NULL,
|
||
|
|
60,
|
||
|
|
FALSE,
|
||
|
|
"event",
|
||
|
|
$this->event_info['event_id'],
|
||
|
|
$this->event_info['event_privacy']
|
||
|
|
);
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
return TRUE;
|
||
|
|
}
|
||
|
|
|
||
|
|
// END event_join() METHOD
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//
|
||
|
|
// THIS METHOD
|
||
|
|
//
|
||
|
|
|
||
|
|
function event_leave()
|
||
|
|
{
|
||
|
|
global $user, $database, $actions;
|
||
|
|
|
||
|
|
// If the event is not invite only, or user is already a member
|
||
|
|
if( !$this->is_member && !$this->is_member_waiting )
|
||
|
|
{
|
||
|
|
$this->is_error = 3000251;
|
||
|
|
return FALSE;
|
||
|
|
}
|
||
|
|
|
||
|
|
// REMOVE MEMBER
|
||
|
|
$sql = "DELETE FROM se_eventmembers WHERE eventmember_event_id='{$this->event_info['event_id']}' && eventmember_user_id='{$this->user_id}' LIMIT 1";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
$result = (bool) $database->database_affected_rows($resource);
|
||
|
|
|
||
|
|
// IF USER IS OWNER, DELETE
|
||
|
|
if( $this->user_id==$this->event_info['event_user_id'] )
|
||
|
|
{
|
||
|
|
$this->event_delete();
|
||
|
|
}
|
||
|
|
|
||
|
|
// INSERT ACTION IF NOT CANCELING REQUEST
|
||
|
|
elseif( $this->is_member && $result )
|
||
|
|
{
|
||
|
|
$event_title = $this->event_info['event_title'];
|
||
|
|
if(strlen($event_title) > 100) { $event_title = substr($event_title, 0, 97)."..."; }
|
||
|
|
$actions->actions_add(
|
||
|
|
$user,
|
||
|
|
"leaveevent",
|
||
|
|
Array(
|
||
|
|
$user->user_info['user_username'],
|
||
|
|
$user->user_displayname,
|
||
|
|
$this->event_info['event_id'],
|
||
|
|
$event_title
|
||
|
|
),
|
||
|
|
NULL,
|
||
|
|
60,
|
||
|
|
FALSE,
|
||
|
|
"event",
|
||
|
|
$this->event_info['event_id'],
|
||
|
|
$this->event_info['event_privacy']
|
||
|
|
);
|
||
|
|
}
|
||
|
|
|
||
|
|
// DECREMENT USER COUNT
|
||
|
|
if( $this->user_id!=$this->event_info['event_user_id'] )
|
||
|
|
{
|
||
|
|
|
||
|
|
$sql = "UPDATE se_events SET event_totalmembers = CASE
|
||
|
|
WHEN event_totalmembers > 0 THEN event_totalmembers - 1
|
||
|
|
ELSE 0 END WHERE event_id='{$this->event_info['event_id']}' LIMIT 1";
|
||
|
|
$database->database_query($sql);
|
||
|
|
}
|
||
|
|
|
||
|
|
// DELETE NOTIFICATION
|
||
|
|
//$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='{$this->user_id}' AND se_notifytypes.notifytype_name='eventinvite' AND notify_object_id='{$this->event_info['event_id']}'";
|
||
|
|
|
||
|
|
$sql = "UPDATE se_notifys USING 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='{$this->user_id}' AND se_notifytypes.notifytype_name='eventinvite' AND notify_object_id='{$this->event_info['event_id']}'";
|
||
|
|
|
||
|
|
$database->database_query($sql);
|
||
|
|
|
||
|
|
return $result;
|
||
|
|
}
|
||
|
|
|
||
|
|
// END event_leave() METHOD
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//
|
||
|
|
// THIS METHOD
|
||
|
|
//
|
||
|
|
|
||
|
|
function event_rsvp($event_rsvp)
|
||
|
|
{
|
||
|
|
global $user, $database, $actions;
|
||
|
|
|
||
|
|
// Validate RSVP value
|
||
|
|
if( !is_numeric($event_rsvp) || $event_rsvp<-1 || $event_rsvp>4 )
|
||
|
|
{
|
||
|
|
$this->is_error = 3000248;
|
||
|
|
return FALSE;
|
||
|
|
}
|
||
|
|
|
||
|
|
// Ensure user is allowed to do this
|
||
|
|
if( !$this->is_member )
|
||
|
|
{
|
||
|
|
$this->is_error = 3000248;
|
||
|
|
return FALSE;
|
||
|
|
}
|
||
|
|
|
||
|
|
// Ignore if user didn't change their response
|
||
|
|
if( $this->eventmember_info['eventmember_rsvp']==$event_rsvp )
|
||
|
|
{
|
||
|
|
return TRUE;
|
||
|
|
}
|
||
|
|
|
||
|
|
// INSERT
|
||
|
|
$sql = "UPDATE se_eventmembers SET eventmember_rsvp='{$event_rsvp}' WHERE eventmember_user_id='{$this->user_id}' && eventmember_event_id='{$this->event_info['event_id']}' && eventmember_status=1 && eventmember_approved=1";
|
||
|
|
$resource = $database->database_query($sql);
|
||
|
|
wrapup("event_join");
|
||
|
|
addspampoint(12, $this->user_id);
|
||
|
|
if( !$database->database_affected_rows($resource) )
|
||
|
|
{
|
||
|
|
$this->is_error = 3000251;
|
||
|
|
return FALSE;
|
||
|
|
}
|
||
|
|
|
||
|
|
// UPDATE
|
||
|
|
/*
|
||
|
|
else
|
||
|
|
{
|
||
|
|
$sql = "INSERT INTO se_eventmembers (eventmember_user_id, eventmember_event_id, eventmember_status) VALUES ('{$this->user_id}', '{$this->event_info['event_id']}', '{$event_rsvp}')";
|
||
|
|
$database->database_query($sql);
|
||
|
|
}
|
||
|
|
*/
|
||
|
|
|
||
|
|
// INSERT ACTION IF ATTENDING
|
||
|
|
if( $event_rsvp==1 )
|
||
|
|
{
|
||
|
|
$event_title = $this->event_info['event_title'];
|
||
|
|
if(strlen($event_title) > 100) { $event_title = substr($event_title, 0, 97)."..."; }
|
||
|
|
$actions->actions_add(
|
||
|
|
$user,
|
||
|
|
"attendevent",
|
||
|
|
Array(
|
||
|
|
$user->user_info['user_username'],
|
||
|
|
$user->user_displayname,
|
||
|
|
$this->event_info['event_id'],
|
||
|
|
$event_title
|
||
|
|
),
|
||
|
|
NULL,
|
||
|
|
60,
|
||
|
|
FALSE,
|
||
|
|
"event",
|
||
|
|
$this->event_info['event_id'],
|
||
|
|
$this->event_info['event_privacy']
|
||
|
|
);
|
||
|
|
}
|
||
|
|
|
||
|
|
return TRUE;
|
||
|
|
}
|
||
|
|
|
||
|
|
// END event_rsvp() METHOD
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//
|
||
|
|
// THIS METHOD
|
||
|
|
//
|
||
|
|
|
||
|
|
function event_rsvp_level($event_rsvp)
|
||
|
|
{
|
||
|
|
return $this->event_rsvp_levels[$event_rsvp];
|
||
|
|
}
|
||
|
|
|
||
|
|
// END event_rsvp() METHOD
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//
|
||
|
|
// THIS METHOD
|
||
|
|
//
|
||
|
|
|
||
|
|
function event_generate_javascript_structure()
|
||
|
|
{
|
||
|
|
return json_encode(array(
|
||
|
|
'event_exists' => (bool) $this->event_exists,
|
||
|
|
'is_member' => (bool) $this->is_member,
|
||
|
|
'is_member_waiting' => (bool) $this->is_member_waiting,
|
||
|
|
'user_rank' => (int) $this->user_rank,
|
||
|
|
|
||
|
|
'event_id' => (int) $this->event_info['event_id'],
|
||
|
|
'event_user_id' => (int) $this->event_info['event_user_id'],
|
||
|
|
'event_inviteonly' => (bool) $this->event_info['event_inviteonly'],
|
||
|
|
'event_invite' => (int) $this->event_info['event_invite'],
|
||
|
|
|
||
|
|
'eventmember_approved' => (bool) $this->eventmember_info['eventmember_approved'],
|
||
|
|
'eventmember_status' => (bool) $this->eventmember_info['eventmember_status'],
|
||
|
|
'eventmember_rank' => (int) $this->eventmember_info['eventmember_rank'],
|
||
|
|
'eventmember_rsvp' => (int) $this->eventmember_info['eventmember_rsvp']
|
||
|
|
));
|
||
|
|
}
|
||
|
|
|
||
|
|
// END event_rsvp() METHOD
|
||
|
|
function album_media_rotate($media_id, $dir)
|
||
|
|
{
|
||
|
|
global $database, $url, $user;
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
// ENSURE MEDIA BELONGS TO USER
|
||
|
|
$media = $database->database_query("SELECT se_eventmedia.* FROM se_eventmedia WHERE eventmedia_id='$media_id' AND eventmedia_user_id='".$user->user_info["user_id"]."'");
|
||
|
|
if($database->database_num_rows($media) != 1) { return; }
|
||
|
|
$media_info = $database->database_fetch_assoc($media);
|
||
|
|
|
||
|
|
$media_path = event_dir($this->event_info["event_id"]).$media_info["eventmedia_id"].".".$media_info["eventmedia_ext"];
|
||
|
|
$thumb_path = event_dir($this->event_info["event_id"]).$media_info["eventmedia_id"]."_thumb.".$media_info["eventmedia_ext"];
|
||
|
|
|
||
|
|
// GET IMAGE INFORMATION
|
||
|
|
|
||
|
|
$media_dimensions = @getimagesize($media_path);
|
||
|
|
$media_width = $media_dimensions[0];
|
||
|
|
$media_height = $media_dimensions[1];
|
||
|
|
|
||
|
|
// ROTATE IMAGE
|
||
|
|
|
||
|
|
$old = imagecreatefromjpeg($media_path);
|
||
|
|
//mail("leprakhauns@gmail.com", "AAA", $media_path);
|
||
|
|
$rotate = imagerotate($old, $dir, 0);
|
||
|
|
imagejpeg($rotate, $media_path, 100);
|
||
|
|
ImageDestroy($old);
|
||
|
|
ImageDestroy($rotate);
|
||
|
|
// ROTATE THUMB
|
||
|
|
if(file_exists($thumb_path)){
|
||
|
|
$old = imagecreatefromjpeg($thumb_path);
|
||
|
|
$rotate = imagerotate($old, $dir, 0);
|
||
|
|
imagejpeg($rotate, $thumb_path, 100);
|
||
|
|
ImageDestroy($old);
|
||
|
|
ImageDestroy($rotate);
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
/*$cf_cache_v1 = new cloudflare_cache(
|
||
|
|
array(
|
||
|
|
"tkn" => "b4fafa93f2bcd7ce518553d2df2793edd06e8",
|
||
|
|
"email" => "lepslair@gmail.com",
|
||
|
|
"z" => "bateworld.com"
|
||
|
|
)
|
||
|
|
);*/
|
||
|
|
highwindsdelete(IMAGECDN.substr($media_path,2));
|
||
|
|
highwindsdelete(IMAGECDN.substr($thumb_path,2));
|
||
|
|
|
||
|
|
# Update cache all in domain
|
||
|
|
//$res = $cf_cache_v1->purge_file("https://bateworld.com/".substr($media_path,2));
|
||
|
|
//$res = $cf_cache_v1->purge_file("https://bateworld.com/".substr($thumb_path,2));
|
||
|
|
//$res = $cf_cache_v1->purge_file(true);
|
||
|
|
//$res = $cf_cache_v1->purge_all();
|
||
|
|
//mail("leprakhauns@gmail.com", "rotate", "/".substr($thumb_path,2));
|
||
|
|
|
||
|
|
# Update cache file(s) (url)
|
||
|
|
//mail("leprakhauns@gmail.com", "rrr", $media_path);
|
||
|
|
return $media_info["eventmedia_ext"];
|
||
|
|
}
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
?>
|