user_exists && !$setting['setting_permission_event']) || ($user->user_exists && (1 & ~$user->level_info['level_event_allow'])) ) { $page = "error"; $smarty->assign('error_header', 639); $smarty->assign('error_message', 656); $smarty->assign('error_submit', 641); include "footer.php"; } if($city!="") { $citysearch=" AND bateworldcom_zips.zipcodes1.place_name='".$database->database_real_escape_string($city)."'"; } if($zip!=""){ if($country=="40"&&$province>0){ $query=$database->database_query("SELECT latitude, longitude FROM bateworldcom_zips.zipcodes1, bateworldcom_zips.countries, bateworldcom_zips.provinces WHERE bateworldcom_zips.zipcodes1.postal_code='".$database->database_real_escape_string($zip)."' ".$citysearch." AND bateworldcom_zips.countries.id='".$database->database_real_escape_string($country)."' AND bateworldcom_zips.provinces.id='".$database->database_real_escape_string($province)."' AND bateworldcom_zips.provinces.abbr=admin_code1 AND bateworldcom_zips.countries.alpha_2=bateworldcom_zips.zipcodes1.country_code LIMIT 1"); } elseif($country=="236"&&$state>0){ $query=$database->database_query("SELECT latitude, longitude FROM bateworldcom_zips.zipcodes1, bateworldcom_zips.countries, bateworldcom_zips.tbl_state WHERE bateworldcom_zips.zipcodes1.postal_code='".$database->database_real_escape_string($zip)."' ".$citysearch." AND bateworldcom_zips.countries.id='".$database->database_real_escape_string($country)."' AND bateworldcom_zips.tbl_state.state_id='".$database->database_real_escape_string($state)."' AND bateworldcom_zips.tbl_state.state_abbr=admin_code1 AND bateworldcom_zips.countries.alpha_2=bateworldcom_zips.zipcodes1.country_code AND bateworldcom_zips.zipcodes1.country_code='US' LIMIT 1"); } elseif($country!="-1"&&$country!=""){ $query=$database->database_query("SELECT latitude, longitude FROM bateworldcom_zips.zipcodes1, bateworldcom_zips.countries WHERE bateworldcom_zips.zipcodes1.postal_code='".$database->database_real_escape_string($zip)."' ".$citysearch." AND bateworldcom_zips.countries.id='".$database->database_real_escape_string($country)."' AND bateworldcom_zips.countries.alpha_2=bateworldcom_zips.zipcodes1.country_code LIMIT 1"); } else{ $query=$database->database_query("SELECT latitude, longitude FROM bateworldcom_zips.zipcodes1 WHERE postal_code='".$database->database_real_escape_string($zip)."' ".$citysearch." LIMIT 1"); } $row=$database->database_fetch_array($query); if($row["latitude"]!=""){ $coslat=cos(deg2rad($row["latitude"])); $sinlat=sin( deg2rad($row["latitude"]) ); $radlon=deg2rad($row["longitude"]); /* "(SELECT country_code, place_name, admin_name1, admin_code1, postal_code, 0 AS distance FROM bateworldcom_zips.zipcodes1 WHERE postal_code='11237') UNION (SELECT country_code, place_name, admin_name1, admin_code1, postal_code, ( 3959 * acos( 0.75812750739757 * cos( radianslat ) * cos( radianslon - -1.2901124764892 ) + 0.65210634295884 * sin( radianslat ) ) ) AS distance FROM bateworldcom_zips.zipcodes1 HAVING distance <= 5) ORDER BY distance ASC LIMIT 0 , 10000" */ $sql1=" (SELECT country_code, place_name, admin_name1, admin_code1, postal_code, 0 AS distance FROM bateworldcom_zips.zipcodes1 WHERE postal_code='".$database->database_real_escape_string($zip)."') UNION (SELECT country_code, place_name, admin_name1, admin_code1, postal_code, ( 3959 * acos( ".$coslat." * cos( radianslat ) * cos( radianslon - ".$radlon." ) + ".$sinlat." * sin( radianslat ) ) ) AS distance FROM bateworldcom_zips.zipcodes1 WHERE (latitude<=".($row["latitude"]+1)." AND latitude>=".($row["latitude"]-1).") AND (longitude<=".($row["longitude"]+1)." AND longitude>=".($row["longitude"]-1).") HAVING distance <= ".$database->database_real_escape_string($distance).") ORDER BY distance ASC LIMIT 0 , 10000"; $url_string1 .="field_27=".urlencode($zip)."&"; $query1=$database->database_query($sql1); $o=1; while($row1=$database->database_fetch_array($query1)) { if($o==1){ $zips="se_events.postal='".$row1["postal_code"]."'"; } else{ $zips.=" OR se_events.postal='".$row1["postal_code"]."'"; } $o++; } } else{$total_users=0;} } // SET WHERE CLAUSE $where = "CASE WHEN se_events.event_user_id='{$user->user_info['user_id']}' THEN TRUE WHEN ((se_events.event_privacy & 32) AND '{$user->user_exists}'<>0) THEN TRUE WHEN ((se_events.event_privacy & 64) AND '{$user->user_exists}'=0) THEN TRUE WHEN ((se_events.event_privacy & 2) AND (SELECT TRUE FROM se_eventmembers WHERE eventmember_user_id='{$user->user_info['user_id']}' AND eventmember_event_id=se_events.event_id AND eventmember_status=1 LIMIT 1)) THEN TRUE WHEN ((se_events.event_privacy & 4) AND '{$user->user_exists}'<>0 AND (SELECT TRUE FROM se_friends WHERE friend_user_id1=se_events.event_user_id AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status=1 LIMIT 1)) THEN TRUE WHEN ((se_events.event_privacy & 8) AND '{$user->user_exists}'<>0 AND (SELECT TRUE FROM se_eventmembers LEFT JOIN se_friends ON se_eventmembers.eventmember_user_id=se_friends.friend_user_id1 WHERE se_eventmembers.eventmember_event_id=se_events.event_id AND se_friends.friend_user_id2='{$user->user_info['user_id']}' AND se_eventmembers.eventmember_status=1 AND se_friends.friend_status=1 LIMIT 1)) THEN TRUE WHEN ((se_events.event_privacy & 16) AND '{$user->user_exists}'<>0 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_event_id=se_events.event_id AND se_eventmembers.eventmember_status=1 AND friends_secondary.friend_user_id2='{$user->user_info['user_id']}' AND friends_primary.friend_status=1 AND friends_secondary.friend_status=1 LIMIT 1)) THEN TRUE ELSE FALSE END"; if($zips!=""){$where=$where." AND (".$zips.") ";} // ONLY MY FRIENDS' EVENTS if( $v=="2" && $user->user_exists ) { // SET WHERE CLAUSE $where .= " AND (SELECT TRUE FROM se_friends LEFT JOIN se_eventmembers ON se_friends.friend_user_id2=se_eventmembers.eventmember_user_id WHERE friend_user_id1='{$user->user_info[user_id]}' AND friend_status=1 AND eventmember_event_id=se_events.event_id AND eventmember_status=1 LIMIT 1)"; } elseif( $v=="3" ) { $where .= " && se_events.event_date_start>'".time()."' "; // Force sort? $s = "event_date_start ASC"; } elseif( $v=="4" ) { $where .= " && se_events.event_date_start<='".time()."' "; // Force sort? $s = "event_date_start ASC"; } // SPECIFIC EVENT CATEGORY if( is_numeric($eventcat_id) ) { $eventcat_query = $database->database_query("SELECT eventcat_id, eventcat_title, eventcat_dependency FROM se_eventcats WHERE eventcat_id='{$eventcat_id}' LIMIT 1"); if( $database->database_num_rows($eventcat_query) ) { $eventcat = $database->database_fetch_assoc($eventcat_query); if( !$eventcat['eventcat_dependency'] ) { $cat_ids[] = $eventcat['eventcat_id']; $depcats = $database->database_query("SELECT eventcat_id FROM se_eventcats WHERE eventcat_id='{$eventcat['eventcat_id']}' OR eventcat_dependency='{$eventcat['eventcat_id']}'"); while($depcat_info = $database->database_fetch_assoc($depcats)) { $cat_ids[] = $depcat_info['eventcat_id']; } $where .= " AND se_events.event_eventcat_id IN('".implode("', '", $cat_ids)."')"; } else { $where .= " AND se_events.event_eventcat_id={$eventcat[eventcat_id]}"; $eventsubcat = $eventcat; $eventcat = $database->database_fetch_assoc($database->database_query("SELECT eventcat_id, eventcat_title FROM se_eventcats WHERE eventcat_id='{$eventcat['eventcat_dependency']}' LIMIT 1")); } } } // CREATE EVENT OBJECT $event = new se_event(); // GET TOTAL EVENTS $total_events = $event->event_total($where); // MAKE ENTRY PAGES $events_per_page = 10; $page_vars = make_page($total_events, $events_per_page, $p); // GET EVENT ARRAY $event_array = $event->event_list($page_vars[0], $events_per_page, $s, $where, TRUE); // GET CATS $field = new se_field("event"); $field->cat_list(0, 0, 0, "", "", "eventfield_id=0"); $cat_array = $field->cats; // SET GLOBAL PAGE TITLE $global_page_title[0] = 3000274; $global_page_description[0] = 3000275; for($x=$page_vars[1]; $x<=$page_vars[2]; $x++) { if(($page_vars[1]+10)==$x) {break;} $for[$y]=$x; $y++; } $smarty->assign('for', $for); // ASSIGN SMARTY VARIABLES AND DISPLAY EVENTS PAGE $smarty->assign('eventcat_id', $eventcat_id); $smarty->assign('zip', $zip); $smarty->assign('distance', $distance); $smarty->assign('eventcat', $eventcat); $smarty->assign('eventsubcat', $eventsubcat); $smarty->assign('cats', $cat_array); $smarty->assign('events', $event_array); $smarty->assign('total_events', $total_events); $smarty->assign('p', $page_vars[1]); $smarty->assign('maxpage', $page_vars[2]); $smarty->assign('p_start', $page_vars[0]+1); $smarty->assign('p_end', $page_vars[0]+count($event_array)); $smarty->assign('s', $s); $smarty->assign('v', $v); include "footer.php"; ?>