require("../../_inc/fn/dateadd.php");
function getmkdt($curdt){ return mktime(0,0,0,substr($curdt,4,2),substr($curdt,6,2),substr($curdt,0,4)); }
function cutstr($s,$ln){ $s=str_replace("'","'",$s); if( strlen($s)>$ln ) return substr($s,0,$ln-2).".."; return $s; }
function getAge($a){if($a<16)return "all ages";return $a."+";}
function fmtTime($t){$h=substr($t,0,2);$m=substr($t,3,2);$a="A";if($h>=12){$a="P"; $h-=12;}else $h+=0;if($h==0)$h=12;return $h.':'.$m.$a;}
//================================================================================
function getCityLat($c){
switch($c){
case "NY": return "40.743004, -73.99329";
case "LA": return "34.042084,-118.316417";
case "SF": return "37.76872,-122.423601";
case "PA": return "39.954925,-75.164022";
case "AT": return "33.751505,-84.383783";
case "CH": return "41.897441,-87.642074";
case "BO": return "42.346828,-71.08911";
case "HU": return "29.758908,-95.356379";
case "OT": return "39.953543,-95.324708";
case "VC": return "49.280309,-123.127484";
case "TO": return "43.651019,-79.384661";
case "ME": return "45.498364,-73.572621";
}
return "";
}
//================================================================================
function getCityZoom($c){
switch($c){
case "NY": return "13";
case "LA": return "12";
case "SF": return "13";
case "PA": return "13";
case "AT": return "12";
case "CH": return "13";
case "BO": return "13";
case "HU": return "13";
case "OT": return "4";
case "VC": return "13";
case "TO": return "13";
case "ME": return "13";
}
return "";
}
//================================================================================
require("../../zinc/db.php");
$db = mysql_connect($dbserver,$dbuser,$dbpw);
mysql_select_db($dbname,$db);
$gbDT=date("Ymd");
//$gbDT="20110416";
if(isset($_GET['cdt']) && $_GET['cdt']!=""){
$gbDT=$_GET['cdt'];
$day=$_GET['d'];
$gbDT=str_replace('-','',dateadd('d',$day-1,substr($gbDT,0,4).'-'.substr($gbDT,4,2).'-'.substr($gbDT,6,2)));
}
$gbCity=$_COOKIE['city'];
if(!isset($gbCity))$gbCity="NY";
$age=$_GET['a'];
$crowd=$_GET['c'];
$gbMKDT=getmkdt($gbDT);
$ordby=" order by event_dt,e.is_repeat desc,is_promoted desc,venue_name,venue_addr2,e.create_dt";
$filter.=" and venue_state='".$gbCity."'";
$filter.=" and event_dt='".date("Y-m-d",$gbMKDT)."'";
if($age==1)$filter.=" and age_range>=18 and age_range<21";
elseif($age==2)$filter.=" and age_range>=21";
if($crowd==1)$filter.=" and (target_id=3 or (target_id>=10 and target_id<=24))";
elseif($crowd==2)$filter.=" and (target_id<>3 and (target_id<10 or target_id>24))";
$result=mysql_query("select e.*,t.event_type_name,r.target_name".
" from cz_events e,cz_event_type t,ref_event_target r".
" where e.event_target_id=r.target_id and e.event_type_id=t.event_type_id".
" and e.is_repeat=0 and e.event_status<2".$filter.$ordby,$db);
$cnt=0;
$lastvenue=0;
while( ($rs=mysql_fetch_array($result)) ){
if($lastvenue!=$rs['venue_id']){
$lastvenue=$rs['venue_id'];
$thumb="";
if($rs['flyer_file1']!='')$thumb='';
//else $thumb='
';
$thisevt="";
$thisevt.=''.cutstr($rs['event_name'],50).'
';
$thisevt.=''.cutstr($rs['venue_name'],50).'
'.$rs['venue_addr1'].', '.$rs['venue_state'].'
';
$thisevt.='by '.cutstr($rs['grp_name'],25).'
';
$thisevt.='';
$thisevt.=getAge($rs['age_range']).' | '.fmtTime($rs['event_time_start']).'-'.fmtTime($rs['event_time_end']).'
';
if($rs['event_target_id']!=0)$thisevt.=$rs['target_name'].', ';
$thisevt.=$rs['event_type_name'].'
';
$cnt++;
//if($cnt>2)
$marks.='markAddress("'.$rs['venue_addr1'].', '.$rs['venue_state'].'","'.$rs['venue_name'].'","'.str_replace('"','\"',$thisevt).'");'."\n";
}
}
mysql_free_result($result);
mysql_close($db);
?>