Files
Testing/include/functions_event.php

1162 lines
45 KiB
PHP
Raw Permalink Normal View History

2026-11-17 16:15:01 -05:00
<?php
/* $Id: functions_event.php 42 2009-01-29 04:55:14Z john $ */
//
// THIS FILE CONTAINS EVENT-RELATED FUNCTIONS
//
// FUNCTIONS IN THIS CLASS:
//
// notification_event()
// action_privacy_event()
// mediatag_event()
// search_event()
// deleteuser_event()
// event_privacy_levels()
// site_statistics_event()
//
defined('SE_PAGE') or exit();
//
// THIS FUNCTION IS RUN ON THE USER HOME PAGE TO GENERATE NOTIFICATIONS
//
// INPUT:
// void
//
// OUTPUT:
// void
//
function notification_event(&$notifications)
{
global $database, $user, $url, $functions_event;
// SET VARIABLES AND INITIALIZE EVENT OBJECT
$event = new se_event($user->user_info['user_id']);
$where = "(se_eventmembers.eventmember_status='0')";
// GET TOTAL EVENT INVITES
$total_events = $event->event_total($where);
// IF EVENT INVITES, CONTINUE
if( $total_events>0 )
{
// GET PLUGIN ICON
$plugin_info = $database->database_fetch_assoc($database->database_query("SELECT plugin_icon FROM se_plugins WHERE plugin_type='event'"));
// SET NOTIFICATION ARRAY
$notifications[] = array(
'notify_url' => $url->url_base."user_event.php?show_notification=1",
'notify_icon' => $plugin_info[plugin_icon],
'notify_text' => $total_events.$functions_event[11]
);
}
}
// END notification_event() FUNCTION
//
// THIS FUNCTION ADDS A CLAUSE IN ACTION QUERY TO ACCOUNT FOR EVENT PRIVACY
//
// INPUT:
//
// OUTPUT:
//
function action_privacy_event($args)
{
global $user;
$args['actions_query'] .= "
WHEN se_actions.action_object_owner='event' THEN
CASE
WHEN ((se_actions.action_object_privacy & 32) AND '{$user->user_exists}'<>0)
THEN TRUE
WHEN ((se_actions.action_object_privacy & 64) AND '{$user->user_exists}'=0)
THEN TRUE
"/*WHEN ((se_actions.action_object_privacy & 2) AND (SELECT TRUE FROM se_eventmembers WHERE eventmember_event_id=se_actions.action_object_owner_id AND eventmember_user_id='{$user->user_info['user_id']}' AND eventmember_status='1' LIMIT 1))
THEN TRUE*/."
WHEN ((se_actions.action_object_privacy & 4) AND (SELECT TRUE FROM se_friends JOIN se_events ON se_friends.friend_user_id1=se_events.event_user_id WHERE se_events.event_id=se_actions.action_object_owner_id AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1))
THEN TRUE
"/*WHEN ((se_actions.action_object_privacy & 8) AND (SELECT TRUE FROM se_friends JOIN se_eventmembers ON se_friends.friend_user_id1=se_eventmembers.eventmember_user_id WHERE se_eventmembers.eventmember_event_id=se_actions.action_object_owner_id AND eventmember_status='1' AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1))
THEN TRUE
WHEN ((se_actions.action_object_privacy & 16) AND (SELECT TRUE FROM se_eventmembers LEFT JOIN se_friends AS friends_primary ON se_eventmembers.eventmember_user_id=friends_primary.friend_user_id1 LEFT JOIN se_friends AS friends_secondary ON friends_primary.friend_user_id2=friends_secondary.friend_user_id1 WHERE eventmember_status='1' AND eventmember_event_id=se_actions.action_object_owner_id AND friends_primary.friend_status='1' AND friends_secondary.friend_status='1' AND friends_secondary.friend_user_id2='{$user->user_info['user_id']}' LIMIT 1))
THEN TRUE*/."
ELSE FALSE
END
";
}
function action_privacy_event_new($args)
{
global $user;
$user->user_info["blocked_events"].="0";
$args['actions_query'] .= "
WHEN bateworldcom_wall.wall.objectowner='event' THEN
CASE
WHEN bateworldcom_wall.wall.objectowner_id IN (".$user->user_info["blocked_events"].")
THEN FALSE
WHEN ((bateworldcom_wall.wall.object_privacy & 32) AND '{$user->user_exists}'<>0)
THEN TRUE
WHEN ((bateworldcom_wall.wall.object_privacy & 64) AND '{$user->user_exists}'=0)
THEN TRUE
"/*WHEN ((se_actions.action_object_privacy & 2) AND (SELECT TRUE FROM se_eventmembers WHERE eventmember_event_id=se_actions.action_object_owner_id AND eventmember_user_id='{$user->user_info['user_id']}' AND eventmember_status='1' LIMIT 1))
THEN TRUE*/."
WHEN ((bateworldcom_wall.wall.object_privacy & 4) AND (SELECT TRUE FROM se_friends JOIN se_events ON se_friends.friend_user_id1=se_events.event_user_id WHERE se_events.event_id=bateworldcom_wall.wall.objectowner_id AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1))
THEN TRUE
"/*WHEN ((se_actions.action_object_privacy & 8) AND (SELECT TRUE FROM se_friends JOIN se_eventmembers ON se_friends.friend_user_id1=se_eventmembers.eventmember_user_id WHERE se_eventmembers.eventmember_event_id=se_actions.action_object_owner_id AND eventmember_status='1' AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1))
THEN TRUE
WHEN ((se_actions.action_object_privacy & 16) AND (SELECT TRUE FROM se_eventmembers LEFT JOIN se_friends AS friends_primary ON se_eventmembers.eventmember_user_id=friends_primary.friend_user_id1 LEFT JOIN se_friends AS friends_secondary ON friends_primary.friend_user_id2=friends_secondary.friend_user_id1 WHERE eventmember_status='1' AND eventmember_event_id=se_actions.action_object_owner_id AND friends_primary.friend_status='1' AND friends_secondary.friend_status='1' AND friends_secondary.friend_user_id2='{$user->user_info['user_id']}' LIMIT 1))
THEN TRUE*/."
ELSE FALSE
END
";
}
// END action_privacy_event() FUNCTION
function action_privacy_event_new1($args)
{
global $user;
$args['actions_query'] .= "
WHEN bateworldcom_wall.wall.objectowner='event' THEN
CASE
WHEN ((bateworldcom_wall.wall.object_privacy & 32) AND '{$user->user_exists}'<>0)
THEN TRUE
WHEN ((bateworldcom_wall.wall.object_privacy & 64) AND '{$user->user_exists}'=0)
THEN TRUE
"/*WHEN ((se_actions.action_object_privacy & 2) AND (SELECT TRUE FROM se_eventmembers WHERE eventmember_event_id=se_actions.action_object_owner_id AND eventmember_user_id='{$user->user_info['user_id']}' AND eventmember_status='1' LIMIT 1))
THEN TRUE*/."
WHEN ((bateworldcom_wall.wall.object_privacy & 4) AND (SELECT TRUE FROM se_friends JOIN se_events ON se_friends.friend_user_id1=se_events.event_user_id WHERE se_events.event_id=bateworldcom_wall.wall.objectowner_id AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1))
THEN TRUE
"/*WHEN ((se_actions.action_object_privacy & 8) AND (SELECT TRUE FROM se_friends JOIN se_eventmembers ON se_friends.friend_user_id1=se_eventmembers.eventmember_user_id WHERE se_eventmembers.eventmember_event_id=se_actions.action_object_owner_id AND eventmember_status='1' AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1))
THEN TRUE
WHEN ((se_actions.action_object_privacy & 16) AND (SELECT TRUE FROM se_eventmembers LEFT JOIN se_friends AS friends_primary ON se_eventmembers.eventmember_user_id=friends_primary.friend_user_id1 LEFT JOIN se_friends AS friends_secondary ON friends_primary.friend_user_id2=friends_secondary.friend_user_id1 WHERE eventmember_status='1' AND eventmember_event_id=se_actions.action_object_owner_id AND friends_primary.friend_status='1' AND friends_secondary.friend_status='1' AND friends_secondary.friend_user_id2='{$user->user_info['user_id']}' LIMIT 1))
THEN TRUE*/."
ELSE FALSE
END
";
}
//
// THIS FUNCTION IS RUN WHEN RETRIEVING PHOTOS OF A USER
//
// INPUT:
//
// OUTPUT:
//
function mediatag_event()
{
global $photo_query, $tag_query, $owner, $user;
if($photo_query != "") { $photo_query .= " UNION ALL "; }
$photo_query .= "
(
SELECT
'eventmedia' AS type,
'eventmedia_id' AS type_id,
'event' AS type_prefix,
se_eventmediatags.eventmediatag_eventmedia_id AS media_id,
se_eventmediatags.eventmediatag_date AS mediatag_date,
'event.php?event_id=[media_parent_id]&v=photos' AS media_parent_url,
se_events.event_id AS media_parent_id,
se_events.event_title AS media_parent_title,
se_events.event_user_id AS owner_user_id,
0 AS user_id,
'' AS user_username,
'' AS user_fname,
'' AS user_lname,
CONCAT('./uploads_event/', se_events.event_id+999-((se_events.event_id-1)%1000), '/', se_events.event_id, '/') AS media_dir,
se_eventmedia.eventmedia_date AS media_date,
se_eventmedia.eventmedia_title AS media_title,
se_eventmedia.eventmedia_desc AS media_desc,
se_eventmedia.eventmedia_ext AS media_ext,
se_eventmedia.eventmedia_filesize AS media_filesize,
(CASE
WHEN ((se_eventalbums.eventalbum_tag & 32) AND '{$user->user_exists}'<>0)
THEN TRUE
WHEN ((se_eventalbums.eventalbum_tag & 64) AND '{$user->user_exists}'=0)
THEN TRUE
WHEN ((se_eventalbums.eventalbum_tag & 1) AND '{$user->user_exists}'<>0 AND event_user_id='{$user->user_info['user_id']}')
THEN TRUE
WHEN ((se_eventalbums.eventalbum_tag & 2) AND (SELECT TRUE FROM se_eventmembers WHERE se_eventmembers.eventmember_event_id=se_eventalbums.eventalbum_event_id AND se_eventmembers.eventmember_user_id='{$user->user_info['user_id']}' AND se_eventmembers.eventmember_status='1' LIMIT 1))
THEN TRUE
WHEN ((se_eventalbums.eventalbum_tag & 4) AND (SELECT TRUE FROM se_friends JOIN se_events AS t1 ON se_friends.friend_user_id1=t1.event_user_id WHERE t1.event_id=se_eventalbums.eventalbum_event_id && friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1))
THEN TRUE
WHEN ((se_eventalbums.eventalbum_tag & 8) AND (SELECT TRUE FROM se_friends JOIN se_eventmembers ON se_friends.friend_user_id1=se_eventmembers.eventmember_user_id WHERE se_eventmembers.eventmember_status='1' && se_eventmembers.eventmember_event_id=se_eventalbums.eventalbum_event_id AND se_friends.friend_user_id2='{$user->user_info["user_id"]}' AND se_friends.friend_status='1' LIMIT 1))
THEN TRUE
WHEN ((se_eventalbums.eventalbum_tag & 16) AND (SELECT TRUE FROM se_eventmembers LEFT JOIN se_friends AS friends_primary ON se_eventmembers.eventmember_user_id=friends_primary.friend_user_id1 LEFT JOIN se_friends AS friends_secondary ON friends_primary.friend_user_id2=friends_secondary.friend_user_id1 WHERE se_eventmembers.eventmember_status='1' AND se_eventmembers.eventmember_event_id=se_eventalbums.eventalbum_event_id AND friends_primary.friend_status='1' AND friends_secondary.friend_status='1' AND friends_secondary.friend_user_id2='{$user->user_info["user_id"]}' LIMIT 1))
THEN TRUE
ELSE FALSE
END)
AS allowed_to_tag,
(CASE
WHEN ((se_events.event_comments & 32) AND '{$user->user_exists}'<>0)
THEN TRUE
WHEN ((se_events.event_comments & 64) AND '{$user->user_exists}'=0)
THEN TRUE
WHEN ((se_events.event_comments & 1) AND '{$user->user_exists}'<>0 AND event_user_id='{$user->user_info['user_id']}')
THEN TRUE
WHEN ((se_events.event_comments & 2) AND (SELECT TRUE FROM se_eventmembers WHERE se_eventmembers.eventmember_event_id=se_events.event_id AND se_eventmembers.eventmember_user_id='{$user->user_info['user_id']}' AND se_eventmembers.eventmember_status='1' LIMIT 1))
THEN TRUE
WHEN ((se_events.event_comments & 4) AND (SELECT TRUE FROM se_friends JOIN se_events AS t1 ON se_friends.friend_user_id1=t1.event_user_id WHERE friend_user_id2='{$user->user_info['user_id']}' && t1.event_id=se_events.event_id AND se_friends.friend_status='1' LIMIT 1))
THEN TRUE
WHEN ((se_events.event_comments & 8) AND (SELECT TRUE FROM se_friends JOIN se_eventmembers ON se_friends.friend_user_id1=se_eventmembers.eventmember_user_id WHERE se_eventmembers.eventmember_status='1' && se_eventmembers.eventmember_event_id=se_events.event_id AND se_friends.friend_user_id2='{$user->user_info['user_id']}' AND se_friends.friend_status='1' LIMIT 1))
THEN TRUE
WHEN ((se_events.event_comments & 16) AND (SELECT TRUE FROM se_eventmembers LEFT JOIN se_friends AS friends_primary ON se_eventmembers.eventmember_user_id=friends_primary.friend_user_id1 LEFT JOIN se_friends AS friends_secondary ON friends_primary.friend_user_id2=friends_secondary.friend_user_id1 WHERE eventmember_status='1' AND eventmember_event_id=se_events.event_id AND friends_primary.friend_status='1' AND friends_secondary.friend_status='1' AND friends_secondary.friend_user_id2='{$user->user_info['user_id']}' LIMIT 1))
THEN TRUE
ELSE FALSE
END)
AS allowed_to_comment
FROM
se_eventmediatags
LEFT JOIN
se_eventmedia
ON se_eventmediatags.eventmediatag_eventmedia_id=se_eventmedia.eventmedia_id
LEFT JOIN
se_eventalbums
ON se_eventmedia.eventmedia_eventalbum_id=se_eventalbums.eventalbum_id
LEFT JOIN
se_events
ON se_eventalbums.eventalbum_event_id=se_events.event_id
WHERE
se_eventmediatags.eventmediatag_user_id='{$owner->user_info['user_id']}'
)
";
$tag_query['eventmedia'] = "SELECT eventmediatag_id AS mediatag_id, eventmediatag_eventmedia_id AS mediatag_media_id, eventmediatag_user_id AS mediatag_user_id, eventmediatag_x AS mediatag_x, eventmediatag_y AS mediatag_y, eventmediatag_height AS mediatag_height, eventmediatag_width AS mediatag_width, eventmediatag_text AS mediatag_text, eventmediatag_date AS mediatag_date, se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname FROM se_eventmediatags LEFT JOIN se_users ON se_eventmediatags.eventmediatag_user_id=se_users.user_id WHERE eventmediatag_eventmedia_id='[media_id]' ORDER BY eventmediatag_id ASC";
}
// END mediatag_event() FUNCTION
//
// THIS FUNCTION IS RUN DURING THE SEARCH PROCESS TO SEARCH THROUGH EVENTS AND EVENT MEDIA
//
// INPUT:
// void
//
// OUTPUT:
// void
//
function tag_events(){
global $database, $url, $results_per_page, $p, $search_text, $t, $search_objects, $results, $total_results, $type, $id;
/*global $database, $url, $results_per_page, $p, $search_text, $t, $search_objects, $results, $total_results, $type;
// GET EVENT FIELDS
$fields = $database->database_query("SELECT eventfield_id AS field_id, eventfield_type AS field_type, eventfield_options AS field_options FROM se_eventfields WHERE eventfield_type<>'5' AND (eventfield_dependency<>'0' OR (eventfield_dependency='0' AND eventfield_display<>'0'))");
$event_query = "se_events.event_title LIKE '%{$search_text}%' OR se_events.event_desc LIKE '%{$search_text}%'";
// LOOP OVER FIELDS
while( $field_info=$database->database_fetch_assoc($fields) )
{
// TEXT FIELD OR TEXTAREA
if($field_info['field_type'] == 1 || $field_info['field_type'] == 2) {
if($event_query != "") { $event_query .= " OR "; }
$event_query .= "se_eventvalues.eventvalue_{$field_info['field_id']} LIKE '%{$search_text}%'";
}
// RADIO OR SELECT BOX
elseif($field_info['field_type'] == 3 || $field_info['field_type'] == 4)
{
$options = unserialize($field_info['field_options']);
$langids = Array();
$cases = Array();
for($i=0,$max=count($options);$i<$max;$i++) {
$cases[] = "WHEN languagevar_id='{$options[$i]['label']}' THEN {$options[$i][value]}";
$langids[] = $options[$i]['label'];
}
if(count($cases) != 0) {
if($event_query != "") { $event_query .= " OR "; }
$event_query .= "se_eventvalues.eventvalue_{$field_info['field_id']} IN (SELECT CASE ".implode(" ", $cases)." END AS value FROM se_languagevars WHERE languagevar_id IN (".implode(", ", $langids).") AND languagevar_value LIKE '%{$search_text}%')";
}
}
// CHECKBOX
elseif($field_info['field_type'] == 6)
{
$options = unserialize($field_info['field_options']);
$langids = Array();
$cases = Array();
for($i=0,$max=count($options);$i<$max;$i++) {
$cases[] = "WHEN languagevar_id='{$options[$i]['label']}' THEN ".(pow(2, $i));
$langids[] = $options[$i]['label'];
}
if(count($cases) != 0) {
if($event_query != "") { $event_query .= " OR "; }
$event_query .= "se_eventvalues.eventvalue_{$field_info['field_id']} & (SELECT sum(CASE ".implode(" ", $cases)." END) AS value FROM se_languagevars WHERE languagevar_id IN (".implode(", ", $langids).") AND languagevar_value LIKE '%{$search_text}%')";
}
}
}*/
$type=2;
// CONSTRUCT QUERY
if($type==1){
$event_query = "
(
SELECT
'1' AS sub_type,
se_events.event_id AS event_id, event_date_start,
se_events.event_title AS event_title,
se_events.event_datecreated,
se_events.event_photo AS event_photo,
'' AS title,
se_events.event_desc AS description,
'' AS id,
'' AS extra
FROM
se_eventvalues
LEFT JOIN
se_events
ON
se_eventvalues.eventvalue_event_id=se_events.event_id
WHERE
se_events.event_search='1' AND event_date_end>=".time()."
AND
($event_query)
)
ORDER BY event_id DESC
";
}
elseif($type==2){
$event_query = "
(
SELECT
'2' AS sub_type,
se_events.event_id AS event_id, event_date_start,
se_events.event_datecreated,
se_events.event_title AS event_title,
se_events.event_photo AS event_photo,
se_eventmedia.eventmedia_title AS title,
se_eventmedia.eventmedia_desc AS description,
se_eventmedia.eventmedia_id AS id,
se_eventmedia.eventmedia_ext AS extra
FROM
se_eventmedia,
se_eventalbums,
se_events,
bateworldcom_zips.mediainteresttagged
WHERE
se_eventmedia.approved=1 AND
se_eventmedia.eventmedia_eventalbum_id=se_eventalbums.eventalbum_id AND
se_eventalbums.eventalbum_event_id=se_events.event_id AND
se_events.event_search='1'
AND bateworldcom_zips.mediainteresttagged.user_id=eventmedia_id AND bateworldcom_zips.mediainteresttagged.interest_id='".$database->database_real_escape_string($id)."' AND event_date_end>=".time()."
)ORDER BY event_id DESC
";}
else{$event_query = "
(
SELECT
'1' AS sub_type,
se_events.event_id AS event_id, event_date_start,
se_events.event_title AS event_title,
se_events.event_datecreated,
se_events.event_photo AS event_photo,
'' AS title,
se_events.event_desc AS description,
'' AS id,
'' AS extra
FROM
se_eventvalues
LEFT JOIN
se_events
ON
se_eventvalues.eventvalue_event_id=se_events.event_id
WHERE
se_events.event_search='1' AND event_date_end>=".time()."
AND
($event_query)
)
UNION ALL
(
SELECT
'2' AS sub_type,
se_events.event_id AS event_id, event_date_start,
se_events.event_datecreated,
se_events.event_title AS event_title,
se_events.event_photo AS event_photo,
se_eventmedia.eventmedia_title AS title,
se_eventmedia.eventmedia_desc AS description,
se_eventmedia.eventmedia_id AS id,
se_eventmedia.eventmedia_ext AS extra
FROM
se_eventmedia,
se_eventalbums,
se_events
WHERE
se_eventmedia.approved=1 AND
se_eventmedia.eventmedia_eventalbum_id=se_eventalbums.eventalbum_id AND
se_eventalbums.eventalbum_event_id=se_events.event_id AND
se_events.event_search='1'
AND
(
se_eventmedia.eventmedia_title LIKE '%".$database->database_real_escape_string($search_text)."%' OR
se_eventmedia.eventmedia_desc LIKE '%".$database->database_real_escape_string($search_text)."%'
) AND event_date_end>=".time()."
)ORDER BY event_id DESC
";
}
//if($_SERVER['REMOTE_ADDR']=="98.192.194.204"){echo $event_query;}
// GET TOTAL EVENT RESULTS
$total_events = $database->database_num_rows($database->database_query($event_query." LIMIT 201"));
// IF NOT TOTAL ONLY
//if( $t=="event" || $t="")
{
// MAKE EVENT PAGES
$start = ($p - 1) * $results_per_page;
$limit = $results_per_page + 1;
// SEARCH EVENTS
$resource = $database->database_query($event_query." LIMIT $start, $limit");
while( $event_info=$database->database_fetch_assoc($resource) )
{
// SET UP EVENT
$event = new se_event();
$event->event_info['event_id'] = $event_info['event_id'];
$event->event_info['event_photo'] = $event_info['event_photo'];
$thumb_path = $event->event_photo('./images/nophoto.png', TRUE);
// IF DESCRIPTION IS LONG
if( strlen($event_info['description']) > 150 ) $event_info['description'] = substr($event_info['description'], 0, 147)."...";
if( strlen($event_info['event_desc']) > 150 ) $event_info['event_desc'] = substr($event_info['event_desc'], 0, 147)."...";
// RESULT IS A EVENT
if( $event_info["sub_type"]==1 )
{
$result_url = $url->url_create('event', NULL, $event_info['event_id']);
$result_name = 3000282;
$result_name_1 = $event_info['event_title'];
$result_desc = 3000284;
$result_desc_1 = strip_tags(html_entity_decode($event_info['description']));
}
// RESULT IS A PHOTO
elseif( $event_info["sub_type"]==2 )
{
$result_url = $url->url_create('event_media', NULL, $event_info['event_id'], $event_info['id']);
$result_name = 3000283;
$result_name_1 = $event_info['title'];
$result_desc = 3000285;
$result_desc_1 = "event.php?event_id=".$event_info["event_id"];
$result_desc_2 = $event_info['event_title'];
$result_desc_3 = $event_info['description'];
// SET THUMBNAIL, IF AVAILABLE
switch( $event_info['extra'] )
{
case "jpeg": case "jpg": case "gif": case "png": case "bmp": case "JPEG": case "JPG": case "GIF": case "PNG": case "BMP":
$thumb_path = IMAGECDN1.str_replace("./", "", $event->event_dir($event->event_info['event_id']).$event_info['event_photo']);
break;
case "mp3": case "mp4": case "wav":
$thumb_path = "./images/icons/audio_big.gif";
break;
case "mpeg": case "mpg": case "mpa": case "avi": case "swf": case "mov": case "ram": case "rm":
$thumb_path = "./images/icons/video_big.gif";
break;
default:
$thumb_path = "./images/icons/file_big.gif";
}
//if(!file_exists($thumb_path)) { $thumb_path = "./images/icons/file_big.gif"; }
}
$results[] = array(
'result_type'=>'event',
'result_url' => $result_url,
'result_icon' => $thumb_path,
'result_name' => $result_name,
'result_name_1' => $result_name_1,
'result_desc' => $result_desc,
'time' => $event_info['event_date_start'],
'result_desc_1' => $result_desc_1,
'result_desc_2' => $result_desc_2,
'result_desc_3' => $result_desc_3
);
}
// SET TOTAL RESULTS
$total_results = $total_events;
}
// SET ARRAY VALUES
SE_Language::_preload_multi(3000281, 3000282, 3000283, 3000284, 3000285);
//if($total_events > 200) $total_events = "200+";
$search_objects[] = array(
'search_type' => 'event',
'search_lang' => 3000281,
'search_total' => $total_events
);
}
function search_event_new(){
global $database, $url, $results_per_page, $p, $search_text, $t, $search_objects, $results, $total_results, $type;
// GET EVENT FIELDS
$fields = $database->database_query("SELECT eventfield_id AS field_id, eventfield_type AS field_type, eventfield_options AS field_options FROM se_eventfields WHERE eventfield_type<>'5' AND (eventfield_dependency<>'0' OR (eventfield_dependency='0' AND eventfield_display<>'0'))");
$event_query = "se_events.event_title LIKE '%".$database->database_real_escape_string($search_text)."%' OR se_events.event_desc LIKE '%".$database->database_real_escape_string($search_text)."%'";
// LOOP OVER FIELDS
while( $field_info=$database->database_fetch_assoc($fields) )
{
// TEXT FIELD OR TEXTAREA
if($field_info['field_type'] == 1 || $field_info['field_type'] == 2) {
if($event_query != "") { $event_query .= " OR "; }
$event_query .= "se_eventvalues.eventvalue_{$field_info['field_id']} LIKE '%".$database->database_real_escape_string($search_text)."%'";
}
// RADIO OR SELECT BOX
elseif($field_info['field_type'] == 3 || $field_info['field_type'] == 4)
{
$options = unserialize($field_info['field_options']);
$langids = Array();
$cases = Array();
for($i=0,$max=count($options);$i<$max;$i++) {
$cases[] = "WHEN languagevar_id='{$options[$i]['label']}' THEN {$options[$i][value]}";
$langids[] = $options[$i]['label'];
}
if(count($cases) != 0) {
if($event_query != "") { $event_query .= " OR "; }
$event_query .= "se_eventvalues.eventvalue_{$field_info['field_id']} IN (SELECT CASE ".implode(" ", $cases)." END AS value FROM se_languagevars WHERE languagevar_id IN (".implode(", ", $langids).") AND languagevar_value LIKE '%".$database->database_real_escape_string($search_text)."%')";
}
}
// CHECKBOX
elseif($field_info['field_type'] == 6)
{
$options = unserialize($field_info['field_options']);
$langids = Array();
$cases = Array();
for($i=0,$max=count($options);$i<$max;$i++) {
$cases[] = "WHEN languagevar_id='{$options[$i]['label']}' THEN ".(pow(2, $i));
$langids[] = $options[$i]['label'];
}
if(count($cases) != 0) {
if($event_query != "") { $event_query .= " OR "; }
$event_query .= "se_eventvalues.eventvalue_{$field_info['field_id']} & (SELECT sum(CASE ".implode(" ", $cases)." END) AS value FROM se_languagevars WHERE languagevar_id IN (".implode(", ", $langids).") AND languagevar_value LIKE '%".$database->database_real_escape_string($search_text)."%')";
}
}
}
// CONSTRUCT QUERY
if($type==1){
$event_query = "
(
SELECT
'1' AS sub_type,
se_events.event_id AS event_id, event_date_start,
se_events.event_title AS event_title,
se_events.event_datecreated,
se_events.event_photo AS event_photo,
'' AS title,
se_events.event_desc AS description,
'' AS id,
'' AS extra
FROM
se_eventvalues
LEFT JOIN
se_events
ON
se_eventvalues.eventvalue_event_id=se_events.event_id
WHERE
se_events.event_search='1' AND event_date_end>=".time()."
AND
($event_query)
)
ORDER BY event_id DESC
";
}
elseif($type==2){
$event_query = "
(
SELECT
'2' AS sub_type,
se_events.event_id AS event_id, event_date_start,
se_events.event_datecreated,
se_events.event_title AS event_title,
se_events.event_photo AS event_photo,
se_eventmedia.eventmedia_title AS title,
se_eventmedia.eventmedia_desc AS description,
se_eventmedia.eventmedia_id AS id,
se_eventmedia.eventmedia_ext AS extra
FROM
se_eventmedia,
se_eventalbums,
se_events
WHERE
se_eventmedia.approved=1 AND
se_eventmedia.eventmedia_eventalbum_id=se_eventalbums.eventalbum_id AND
se_eventalbums.eventalbum_event_id=se_events.event_id AND
se_events.event_search='1'
AND
(
se_eventmedia.eventmedia_title LIKE '%".$database->database_real_escape_string($search_text)."%' OR
se_eventmedia.eventmedia_desc LIKE '%".$database->database_real_escape_string($search_text)."%'
) AND event_date_end>=".time()."
)ORDER BY event_id DESC
";}
else{$event_query = "
(
SELECT
'1' AS sub_type,
se_events.event_id AS event_id, event_date_start,
se_events.event_title AS event_title,
se_events.event_datecreated,
se_events.event_photo AS event_photo,
'' AS title,
se_events.event_desc AS description,
'' AS id,
'' AS extra
FROM
se_eventvalues
LEFT JOIN
se_events
ON
se_eventvalues.eventvalue_event_id=se_events.event_id
WHERE
se_events.event_search='1' AND event_date_end>=".time()."
AND
($event_query)
)
UNION ALL
(
SELECT
'2' AS sub_type,
se_events.event_id AS event_id, event_date_start,
se_events.event_datecreated,
se_events.event_title AS event_title,
se_events.event_photo AS event_photo,
se_eventmedia.eventmedia_title AS title,
se_eventmedia.eventmedia_desc AS description,
se_eventmedia.eventmedia_id AS id,
se_eventmedia.eventmedia_ext AS extra
FROM
se_eventmedia,
se_eventalbums,
se_events
WHERE
se_eventmedia.approved=1 AND
se_eventmedia.eventmedia_eventalbum_id=se_eventalbums.eventalbum_id AND
se_eventalbums.eventalbum_event_id=se_events.event_id AND
se_events.event_search='1'
AND
(
se_eventmedia.eventmedia_title LIKE '%".$database->database_real_escape_string($search_text)."%' OR
se_eventmedia.eventmedia_desc LIKE '%".$database->database_real_escape_string($search_text)."%'
) AND event_date_end>=".time()."
)ORDER BY event_id DESC
";
}
//if($_SERVER['REMOTE_ADDR']=="98.192.194.204"){echo $event_query;}
// GET TOTAL EVENT RESULTS
$total_events = $database->database_num_rows($database->database_query($event_query." LIMIT 201"));
// IF NOT TOTAL ONLY
//if( $t=="event" || $t="")
{
// MAKE EVENT PAGES
$start = ($p - 1) * $results_per_page;
$limit = $results_per_page + 1;
// SEARCH EVENTS
$resource = $database->database_query($event_query." LIMIT $start, $limit");
while( $event_info=$database->database_fetch_assoc($resource) )
{
// SET UP EVENT
$event = new se_event();
$event->event_info['event_id'] = $event_info['event_id'];
$event->event_info['event_photo'] = $event_info['event_photo'];
$thumb_path = $event->event_photo('./images/nophoto.png', TRUE);
// IF DESCRIPTION IS LONG
if( strlen($event_info['description']) > 150 ) $event_info['description'] = substr($event_info['description'], 0, 147)."...";
if( strlen($event_info['event_desc']) > 150 ) $event_info['event_desc'] = substr($event_info['event_desc'], 0, 147)."...";
// RESULT IS A EVENT
if( $event_info["sub_type"]==1 )
{
$result_url = $url->url_create('event', NULL, $event_info['event_id']);
$result_name = 3000282;
$result_name_1 = $event_info['event_title'];
$result_desc = 3000284;
$result_desc_1 = strip_tags(html_entity_decode($event_info['description']));
}
// RESULT IS A PHOTO
elseif( $event_info["sub_type"]==2 )
{
$result_url = $url->url_create('event_media', NULL, $event_info['event_id'], $event_info['id']);
$result_name = 3000283;
$result_name_1 = $event_info['title'];
$result_desc = 3000285;
$result_desc_1 = "event.php?event_id=".$event_info["event_id"];
$result_desc_2 = $event_info['event_title'];
$result_desc_3 = $event_info['description'];
// SET THUMBNAIL, IF AVAILABLE
switch( $event_info['extra'] )
{
case "jpeg": case "jpg": case "gif": case "png": case "bmp": case "JPEG": case "JPG": case "GIF": case "PNG": case "BMP":
$thumb_path = IMAGECDN1.str_replace("./", "", $event->event_dir($event->event_info['event_id']).$event_info['event_photo']);
break;
case "mp3": case "mp4": case "wav":
$thumb_path = "./images/icons/audio_big.gif";
break;
case "mpeg": case "mpg": case "mpa": case "avi": case "swf": case "mov": case "ram": case "rm":
$thumb_path = "./images/icons/video_big.gif";
break;
default:
$thumb_path = "./images/icons/file_big.gif";
}
//if(!file_exists($thumb_path)) { $thumb_path = "./images/icons/file_big.gif"; }
}
$results[] = array(
'result_type'=>'event',
'result_url' => $result_url,
'result_icon' => $thumb_path,
'result_name' => $result_name,
'result_name_1' => $result_name_1,
'result_desc' => $result_desc,
'time' => $event_info['event_date_start'],
'result_desc_1' => $result_desc_1,
'result_desc_2' => $result_desc_2,
'result_desc_3' => $result_desc_3
);
}
// SET TOTAL RESULTS
$total_results = $total_events;
}
// SET ARRAY VALUES
SE_Language::_preload_multi(3000281, 3000282, 3000283, 3000284, 3000285);
//if($total_events > 200) $total_events = "200+";
$search_objects[] = array(
'search_type' => 'event',
'search_lang' => 3000281,
'search_total' => $total_events
);
}
function search_event()
{
global $database, $url, $results_per_page, $p, $search_text, $t, $search_objects, $results, $total_results;
// GET EVENT FIELDS
$fields = $database->database_query("SELECT eventfield_id AS field_id, eventfield_type AS field_type, eventfield_options AS field_options FROM se_eventfields WHERE eventfield_type<>'5' AND (eventfield_dependency<>'0' OR (eventfield_dependency='0' AND eventfield_display<>'0'))");
$event_query = "se_events.event_title LIKE '%".$database->database_real_escape_string($search_text)."%' OR se_events.event_desc LIKE '%".$database->database_real_escape_string($search_text)."%'";
// LOOP OVER FIELDS
while( $field_info=$database->database_fetch_assoc($fields) )
{
// TEXT FIELD OR TEXTAREA
if($field_info['field_type'] == 1 || $field_info['field_type'] == 2) {
if($event_query != "") { $event_query .= " OR "; }
$event_query .= "se_eventvalues.eventvalue_{$field_info['field_id']} LIKE '%".$database->database_real_escape_string($search_text)."%'";
}
// RADIO OR SELECT BOX
elseif($field_info['field_type'] == 3 || $field_info['field_type'] == 4)
{
$options = unserialize($field_info['field_options']);
$langids = Array();
$cases = Array();
for($i=0,$max=count($options);$i<$max;$i++) {
$cases[] = "WHEN languagevar_id='{$options[$i]['label']}' THEN {$options[$i][value]}";
$langids[] = $options[$i]['label'];
}
if(count($cases) != 0) {
if($event_query != "") { $event_query .= " OR "; }
$event_query .= "se_eventvalues.eventvalue_{$field_info['field_id']} IN (SELECT CASE ".implode(" ", $cases)." END AS value FROM se_languagevars WHERE languagevar_id IN (".implode(", ", $langids).") AND languagevar_value LIKE '%".$database->database_real_escape_string($search_text)."%')";
}
}
// CHECKBOX
elseif($field_info['field_type'] == 6)
{
$options = unserialize($field_info['field_options']);
$langids = Array();
$cases = Array();
for($i=0,$max=count($options);$i<$max;$i++) {
$cases[] = "WHEN languagevar_id='{$options[$i]['label']}' THEN ".(pow(2, $i));
$langids[] = $options[$i]['label'];
}
if(count($cases) != 0) {
if($event_query != "") { $event_query .= " OR "; }
$event_query .= "se_eventvalues.eventvalue_{$field_info['field_id']} & (SELECT sum(CASE ".implode(" ", $cases)." END) AS value FROM se_languagevars WHERE languagevar_id IN (".implode(", ", $langids).") AND languagevar_value LIKE '%".$database->database_real_escape_string($search_text)."%')";
}
}
}
// CONSTRUCT QUERY
$event_query = "
(
SELECT
'1' AS sub_type,
se_events.event_id AS event_id, event_date_start,
se_events.event_title AS event_title,
se_events.event_datecreated,
se_events.event_photo AS event_photo,
'' AS title,
se_events.event_desc AS description,
'' AS id,
'' AS extra
FROM
se_eventvalues
LEFT JOIN
se_events
ON
se_eventvalues.eventvalue_event_id=se_events.event_id
WHERE
se_events.event_search='1' AND event_date_end>=".time()."
AND
($event_query)
)
UNION ALL
(
SELECT
'2' AS sub_type,
se_events.event_id AS event_id, event_date_start,
se_events.event_datecreated,
se_events.event_title AS event_title,
se_events.event_photo AS event_photo,
se_eventmedia.eventmedia_title AS title,
se_eventmedia.eventmedia_desc AS description,
se_eventmedia.eventmedia_id AS id,
se_eventmedia.eventmedia_ext AS extra
FROM
se_eventmedia,
se_eventalbums,
se_events
WHERE
se_eventmedia.approved=1 AND
se_eventmedia.eventmedia_eventalbum_id=se_eventalbums.eventalbum_id AND
se_eventalbums.eventalbum_event_id=se_events.event_id AND
se_events.event_search='1'
AND
(
se_eventmedia.eventmedia_title LIKE '%".$database->database_real_escape_string($search_text)."%' OR
se_eventmedia.eventmedia_desc LIKE '%".$database->database_real_escape_string($search_text)."%'
) AND event_date_end>=".time()."
)ORDER BY event_id DESC
";
//if($_SERVER['REMOTE_ADDR']=="98.192.194.204"){echo $event_query;}
// GET TOTAL EVENT RESULTS
$total_events = $database->database_num_rows($database->database_query($event_query." LIMIT 201"));
// IF NOT TOTAL ONLY
if( $t=="event" )
{
// MAKE EVENT PAGES
$start = ($p - 1) * $results_per_page;
$limit = $results_per_page + 1;
// SEARCH EVENTS
$resource = $database->database_query($event_query." LIMIT $start, $limit");
while( $event_info=$database->database_fetch_assoc($resource) )
{
// SET UP EVENT
$event = new se_event();
$event->event_info['event_id'] = $event_info['event_id'];
$event->event_info['event_photo'] = $event_info['event_photo'];
$thumb_path = $event->event_photo('./images/nophoto.png', TRUE);
// IF DESCRIPTION IS LONG
if( strlen($event_info['description']) > 150 ) $event_info['description'] = substr($event_info['description'], 0, 147)."...";
if( strlen($event_info['event_desc']) > 150 ) $event_info['event_desc'] = substr($event_info['event_desc'], 0, 147)."...";
// RESULT IS A EVENT
if( $event_info["sub_type"]==1 )
{
$result_url = $url->url_create('event', NULL, $event_info['event_id']);
$result_name = 3000282;
$result_name_1 = $event_info['event_title'];
$result_desc = 3000284;
$result_desc_1 = $event_info['description'];
}
// RESULT IS A PHOTO
elseif( $event_info["sub_type"]==2 )
{
$result_url = $url->url_create('event_media', NULL, $event_info['event_id'], $event_info['id']);
$result_name = 3000283;
$result_name_1 = $event_info['title'];
$result_desc = 3000285;
$result_desc_1 = "event.php?event_id=".$event_info["event_id"];
$result_desc_2 = $event_info['event_title'];
$result_desc_3 = $event_info['description'];
// SET THUMBNAIL, IF AVAILABLE
switch( $event_info['extra'] )
{
case "jpeg": case "jpg": case "gif": case "png": case "bmp": case "JPEG": case "JPG": case "GIF": case "PNG": case "BMP":
$thumb_path = IMAGECDN1.str_replace("./", "", $event->event_dir($event->event_info['event_id']).$event_info['event_photo']);
break;
case "mp3": case "mp4": case "wav":
$thumb_path = "./images/icons/audio_big.gif";
break;
case "mpeg": case "mpg": case "mpa": case "avi": case "swf": case "mov": case "ram": case "rm":
$thumb_path = "./images/icons/video_big.gif";
break;
default:
$thumb_path = "./images/icons/file_big.gif";
}
//if(!file_exists($thumb_path)) { $thumb_path = "./images/icons/file_big.gif"; }
}
$results[] = array(
'result_type'=>'event',
'result_url' => $result_url,
'result_icon' => $thumb_path,
'result_name' => $result_name,
'result_name_1' => $result_name_1,
'result_desc' => $result_desc,
'time' => $event_info['event_date_start'],
'result_desc_1' => $result_desc_1,
'result_desc_2' => $result_desc_2,
'result_desc_3' => $result_desc_3
);
}
// SET TOTAL RESULTS
$total_results = $total_events;
}
// SET ARRAY VALUES
SE_Language::_preload_multi(3000281, 3000282, 3000283, 3000284, 3000285);
if($total_events > 200) $total_events = "200+";
$search_objects[] = array(
'search_type' => 'event',
'search_lang' => 3000281,
'search_total' => $total_events
);
}
// END search_event() FUNCTION
//
// THIS FUNCTION IS RUN WHEN A USER IS DELETED
//
// INPUT:
// $user_id REPRESENTING THE USER ID OF THE USER BEING DELETED
//
// OUTPUT:
// void
//
function deleteuser_event($user_id)
{
global $database;
// INITATE EVENT OBJECT
$event = new se_event($user_id);
// LOOP OVER EVENTS AND DELETE THEM
$events = $database->database_query("SELECT event_id FROM se_events WHERE event_user_id='{$user_id}'");
while($event_info = $database->database_fetch_assoc($events)) {
$event->event_delete($event_info['event_id']);
}
// DELETE USER FROM EVENT GUESTLISTS
$database->database_query("DELETE FROM se_eventmembers WHERE eventmember_user_id='{$user_id}'");
// DELETE USER'S COMMENTS
$database->database_query("DELETE FROM se_eventcomments WHERE eventcomment_authoruser_id='{$user_id}'");
$database->database_query("DELETE FROM se_eventmediacomments WHERE eventmediacomment_authoruser_id='{$user_id}'");
}
// END deleteuser_event() FUNCTION
//
// THIS FUNCTION RETURNS TEXT CORRESPONDING TO THE GIVEN EVENT PRIVACY LEVEL
//
// INPUT:
// $privacy_level REPRESENTING THE LEVEL OF EVENT PRIVACY
//
// OUTPUT:
// A STRING EXPLAINING THE GIVEN PRIVACY SETTING
//
function event_privacy_levels($privacy_level)
{
switch($privacy_level)
{
case 127: $privacy = 323; break;
case 63: $privacy = 324; break;
case 31: $privacy = 3000014; break;
case 15: $privacy = 3000015; break;
case 7: $privacy = 3000016; break;
case 3: $privacy = 3000017; break;
case 1: $privacy = 3000018; break;
case 0: $privacy = 329; break;
default: $privacy = NULL; break;
}
if( $privacy && class_exists('SE_Language') )
SE_Language::_preload($privacy);
return $privacy;
}
// END event_privacy_levels() FUNCTION
//
// GENERATES AN ERROR STRING FOR DATABASE QUERIES
//
// DEPRECATED AND REMOVED: 3.04
//
function event_error($err_file, $err_line, $err_msg, $err_query, $is_fatal=TRUE)
{
return;
}
// END event_error() FUNCTION
// THIS FUNCTION IS RUN WHEN GENERATING SITE STATISTICS
// INPUT:
// OUTPUT:
function site_statistics_event(&$args)
{
global $database;
$statistics =& $args['statistics'];
// NOTE: CACHING WILL BE HANDLED BY THE FUNCTION THAT CALLS THIS
$total = $database->database_fetch_assoc($database->database_query("SELECT COUNT(event_id) AS total FROM se_events"));
$statistics['events'] = array(
'title' => 3000291,
'stat' => (int) ( isset($total['total']) ? $total['total'] : 0 )
);
/*
$total = $database->database_fetch_assoc($database->database_query("SELECT COUNT(eventcomment_id) AS total FROM se_eventcomments"));
$statistics['eventcomments'] = array(
'title' => 3000292,
'stat' => (int) ( isset($total['total']) ? $total['total'] : 0 )
);
$total = $database->database_fetch_assoc($database->database_query("SELECT COUNT(eventmedia_id) AS total FROM se_eventmedia"));
$statistics['eventmedia'] = array(
'title' => 3000293,
'stat' => (int) ( isset($total['total']) ? $total['total'] : 0 )
);
$total = $database->database_fetch_assoc($database->database_query("SELECT COUNT(eventmember_id) AS total FROM se_eventmembers WHERE eventmember_approved=1 && eventmember_status=1"));
$statistics['eventmembers'] = array(
'title' => 3000294,
'stat' => (int) ( isset($total['total']) ? $total['total'] : 0 )
);
*/
}
// END site_statistics_event() FUNCTION
?>