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