$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); ?> Google Maps