require("fn/fn_tellafriend.php"); require("fn/fn_event_review.php"); require("fn/fn_writelocphotos.php"); require("../_inc/fn/datediff.php"); require("../_inc/fn/fmtdate.php"); require("../_inc/fn/dayofweek.php"); require("../_inc/fn/getuserpic.php"); require("../_inc/fn/getmap.php"); require("../zinc/head.php"); $gbVID=0; if(isset($_GET['id']) && $_GET['id']!="")$gbVID=$_GET['id']; $db = mysql_connect($dbserver,$dbuser,$dbpw); mysql_select_db($dbname,$db); main(); mysql_close($db); require("../zinc/foot.php"); //============================================================================== function main(){ global $gbVID; print('
'); showVenue($gbVID); print(' | ![]() | ');
print(' '); 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']).' |
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='![]() ');
$thisevt.=$thumb.''.cutstr($rs['venue_name'],30).' ');
print($thisevt);
}
mysql_free_result($result);
print(''; $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.=(' |