| ');
showEvents();
print(' | ');
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('');
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('\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('
'.$body[$i]."
\n");
}
?>
=12){$a="P"; $h-=12;}
else $h+=0;
if($h==0)$h=12;
return $h.':'.$m.$a;
}
?>