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 ?>