'); showVenue($gbVID); print(''); print('

'); print(''); } //============================================================================== function showVenue($gid){ global $db; $evtcnt=0; print(''); print(''); $result=mysql_query("select * from cz_location where loc_id=".$gid,$db); if( ($rs=mysql_fetch_array($result)) ){ if( ($gdes=$rs['lic_des'])=="")$gdes="..."; $evtcnt=$rs['event_cnt']; print(''); print(''); if($gdes!="...")print(''); if($rs['loc_website']!="")print(''); } else print('

ERROR: VENUE ['.$gid.'] NOT FOUND

go to groups
'); mysql_free_result($result); print('
Venue
Name'.$rs['loc_name'].'
Location'.$rs['addr_1'].'
'.$rs['addr_city'].', '.$rs['addr_state'].'
'.$rs['addr_info'].'
Description'.$gdes.'
Website'.cleanURL($rs['loc_website']).'
'); if($evtcnt>0)showEvents($gid); } //======================================================= function showEvents($gid){ global $db; $ST=0; print(''); print('
Events
'); $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 and e.venue_id=".$gid." order by event_dt desc LIMIT ".$ST.",10",$db); while( ($rs=mysql_fetch_array($result)) ){ if ($rs['flyer_file1']!='')$thumb=''; elseif($rs['flyer_url1' ]!='')$thumb=''; elseif($rs['flyer_url2' ]!='')$thumb=''; else $thumb=''; $evtdt=$rs['event_dt']; $dtnow=mktime(0,0,0,substr($evtdt,5,2),substr($evtdt,8,2),substr($evtdt,0,4)); $thisevt =('
'); $thisevt.=$thumb.''.cutstr($rs['venue_name'],30).'
'; $thisevt.=''.cutstr($rs['event_name'],30).'
'; $thisevt.=date("l - M j, Y",$dtnow).'

'; $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'].'

'; $thisevt.=('
'); print($thisevt); } mysql_free_result($result); print('


'); } //======================================================= function cleanURL($url){ $url=strtolower($url); if(substr($url,0,11)=="http://www.")$url=substr($url,11); if(substr($url,0,7)=="http://")$url=substr($url,7); if( ($p=strpos($url,"/"))>0 )$url=substr($url,0,$p); return $url; } //======================================================= 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; } ?>