'); showEvents(); print(''); print('
'); ?>
 CROWD FILTER:

All Asian Mix

 AGE FILTER:

All 18+ 21+

'); makeCalendar($gbDT,2,"events.php?",1); print('
'); print('


'); writeEventAlbum(); print(''); } //============================================================================== function showEvents(){ global $db,$gbCity,$gbDT,$gbMKDT,$gbTODAY; $wk1=getWeekFirst($gbMKDT); $wk2=getWeekLast($gbMKDT); $body=array("","","","","","","",""); $cntevt=array('',0,0,0,0,0,0,0); //------------------------------------------------------------------------- $dow=0; if($_GET['w']=="1"){ $dow=date("N",$gbMKDT); } //------------------------------------------------------------------------- $sel="";if($dow==0)$sel="Sel"; print('

ALL
WEEK
'); for($i=1;$i<=7;$i++){ $dt=dateadd("d",$i-1,$wk1); $body[$i]="
".date("l - M j, Y",$dt)." (No Events)
"; $sel=""; if($i==$dow)$sel="Sel"; print('

'.str_replace("-",'
',date("D-j",$dt))."
\n"); } //------------------------------------------------------------------------- $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",$wk1)."' and event_dt<='".date("Y-m-d",$wk2)."'"; $arr_asian=""; $arr_mix=""; $arr_18=""; $arr_21=""; //------------------------------------------------------------------------- $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); $cur=0; $lastvenue=0; while( ($rs=mysql_fetch_array($result)) ){ $thishead=""; $evtdt=$rs['event_dt']; $dtnow=mktime(0,0,0,substr($evtdt,5,2),substr($evtdt,8,2),substr($evtdt,0,4)); if($dtnow!=$dtcur){ $thishead="
".date("l - M j, Y",$dtnow)."
"; $dtcur=$dtnow; $cur=date("w",$dtnow); if($cur==0)$cur=7; $body[$cur]=""; $lastvenue=0; } if($lastvenue!=$rs['venue_id']){ $lastvenue=$rs['venue_id']; $isprom=""; if($rs['is_promoted']!=0)$isprom="P"; $thisevt=""; $thisdiv0=('
'); $thisdiv =('
'); if ($rs['flyer_file1']!='')$thumb=''; elseif($rs['flyer_url1' ]!='')$thumb=''; elseif($rs['flyer_url2' ]!='')$thumb=''; else $thumb=''; $thisevt.=$thumb.''.cutstr($rs['venue_name'],30).'
'; $thisevt.=''.cutstr($rs['event_name'],30).'
'; $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'].'

'; $thisevt.=('
'); $target=$rs['event_target_id']; if($target==3 || ($target>=10 and $target<=24 ) )$arr_asian.=",".$rs['event_id']; else $arr_mix.=",".$rs['event_id']; if($rs['age_range']>=21)$arr_21.=",".$rs['event_id']; elseif($rs['age_range']>=18)$arr_18.=",".$rs['event_id']; if($dtnow>=$gbTODAY)$body[0].=$thishead.$thisdiv0.$thisevt; if($cur!=0){$body[$cur].=$thishead.$thisdiv.$thisevt; $cntevt[$cur]++;} } } mysql_free_result($result); if($cntevt[7]==0 && $gbTODAY==$wk2){ $body[0]=""; if($cntevt[5]!=0)$body[0].=$body[5]; if($cntevt[6]!=0)$body[0].=$body[6]; }//*/ for($i=1;$i<=7;$i++)$cntevt[0].=",".$cntevt[$i]; //------------------------------------------------------------------------- if($body[0]=="")$body[0]=$body[5].$body[6]; for($i=0;$i<=7;$i++){ print('\n"); } ?>
=12){$a="P"; $h-=12;} else $h+=0; if($h==0)$h=12; return $h.':'.$m.$a; } ?>