Files
Testing/browse_events.php
sean 0e8a8b3028
Some checks are pending
deploy-testing / deploy (push) Waiting to run
Initial testing snapshot
2026-11-17 16:15:01 -05:00

233 lines
11 KiB
PHP

<?php
/* $Id: browse_events.php 22 2009-01-16 05:50:49Z john $ */
$page = "browse_events";
include "header.php";
if(isset($_POST['p'])) { $p = $_POST['p']; } elseif(isset($_GET['p'])) { $p = $_GET['p']; } else { $p = 1; }
if(isset($_POST['s'])) { $s = $_POST['s']; } elseif(isset($_GET['s'])) { $s = $_GET['s']; } else { $s = "event_datecreated DESC"; }
if(isset($_POST['v'])) { $v = $_POST['v']; } elseif(isset($_GET['v'])) { $v = $_GET['v']; } else { $v = 0; }
if(isset($_POST['eventcat_id'])) { $eventcat_id = $_POST['eventcat_id']; } elseif(isset($_GET['eventcat_id'])) { $eventcat_id = $_GET['eventcat_id']; } else { $eventcat_id = 0; }
if(isset($_POST['zip'])) { $zip = $_POST['zip']; } elseif(isset($_GET['zip'])) { $zip = $_GET['zip']; } else { $zip = ""; }
if(isset($_POST['city'])) { $city = $_POST['city']; } elseif(isset($_GET['city'])) { $city = $_GET['city']; } else { $city = ""; }
if(isset($_POST['state'])) { $state = $_POST['state']; } elseif(isset($_GET['state'])) { $state = $_GET['state']; } else { $state = ""; }
if(isset($_POST['province'])) { $province = $_POST['province']; } elseif(isset($_GET['province'])) { $province = $_GET['province']; } else { $province = ""; }
if(isset($_POST['country'])) { $country = $_POST['country']; } elseif(isset($_GET['country'])) { $country = $_GET['country']; } else { $country = ""; }
if(isset($_POST['distance'])) { $distance = $_POST['distance']; } elseif(isset($_GET['distance'])) { $distance = $_GET['distance']; } else { $distance = "50"; }
// ENSURE SORT/VIEW ARE VALID
if($s != "event_datecreated DESC" && $s != "event_totalmembers DESC" && $s != "event_date_start DESC" && $s != "event_date_end DESC" && $s != "event_date_start ASC" && $s != "event_date_end ASC") { $s = "event_date_start ASC"; }
if($v != "1" && $v != "2" && $v != "3" && $v != "4" ) { $v = 3; }
// DISPLAY ERROR PAGE IF USER IS NOT LOGGED IN AND ADMIN SETTING REQUIRES REGISTRATION
if( (!$user->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";
?>