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/fmttime.php");
require("../_inc/fn/dayofweek.php");
require("../_inc/fn/getuserpic.php");
require("../_inc/fn/getmap.php");
require("../zinc/head.php");
$gbUpcoming=1;
$gbEID=0;
$gbLOC=0;
$gbEDT="";
$gbAddr1="";
$gbAddr2="";
if(isset($_GET['id']) && $_GET['id']!="")$gbEID=$_GET['id'];
$db = mysql_connect($dbserver,$dbuser,$dbpw);
mysql_select_db($dbname,$db);
main();
mysql_close($db);
require("../zinc/foot.php");
//==============================================================================
function main(){
global $gbEID,$gbLOC,$gbEDT,$gbUpcoming,$gbAddr1,$gbAddr2;
print('
');
dp_event();
print(' |  | ');
//if($gbUpcoming!=0)tellafriend($gbEID);
print('
');
//dp_sameevent($gbEID,$gbLOC,$gbEDT);
eventSimilarBox($gbEID,$gbLOC,$gbEDT);
eventSameDay($gbEID,$gbEDT);
if($gbUpcoming!=0)displayReviewFormB4($gbEID);
else displayReviewForm($gbEID);
print(' |
');
}
//==============================================================================
function eventActions(){
global $db,$gbMemID,$gbEID,$gbUpcoming;
$watched=0;
if($gbMemID!=0){
$result=mysql_query("select count(*) as c from cz_mem_event where mem_id=".$gbMemID." and event_id=".$gbEID,$db);
if( ($rs=mysql_fetch_array($result)) )$watched=$rs['c'];
mysql_free_result($result);
}
print('');
print('
| ');
print('');
if($watched!=0)print('  ');
else print('  ');
print(' ');
if(!$gbUpcoming&&$gbMemID!=0)print(' ');
print(' | ');
//Addthis.com Share Code
print('');
print('');
print(' |
');
}
//==============================================================================
function dp_event(){
global $db,$gbEID,$gbLOC,$gbEDT,$gbUpcoming,$gbAddr1,$gbAddr2;
if($gbEID==0){print('
ERROR: NO ID
go to events');return;}
//check if event have been backed-up to cz_events_bk
$isbk="_bk";
$result=mysql_query("select event_id from cz_events where event_id=".$gbEID,$db);
if( ($rs=mysql_fetch_array($result)) )$isbk="";
mysql_free_result($result);
$result=mysql_query("select e.*,t.event_type_name,r.target_name,m.gender,m.profile_pic".
" from cz_events".$isbk." e,cz_event_type t,ref_event_target r,cz_members m".
" where e.event_status<2 and e.mem_id=m.mem_id".
" and e.event_target_id=r.target_id and e.event_type_id=t.event_type_id and e.event_id=".$gbEID,$db);
if( ($rs=mysql_fetch_array($result)) ){
$gbUpcoming=0;
$gbLOC=$rs['venue_id'];
$gbEDT=$rs['event_dt'];
$gbVenue=$rs['venue_name'];
$gbAddr1=$rs['venue_addr1'];
$gbAddr2=$rs['venue_addr2'];
if($gbEDT>=date("Y-m-d"))$gbUpcoming=1;
$cmem_id=$rs['mem_id'];
print('');
print(''.cutstr($rs['event_name'],60).' |
');
print('>> back to events |
');
print('Date/Time: | ');
if($rs['is_repeat']==0){
if(datediff("d",$rs['event_sdt'],$rs['event_edt'])>1){
print(''.fmtdate('l - F j, Y',$rs['event_sdt']).' '.fmttime($rs['event_time_start']).' ');
print('to ');
print(''.fmtdate('l - F j, Y',$rs['event_edt']).' '.fmttime($rs['event_time_end']).'');
}
else{
print(''.fmtdate('l - F j, Y',$rs['event_dt']).'');
print(' ['.fmttime($rs['event_time_start']).' to '.fmttime($rs['event_time_end']).']');
}
}
else{print(' '.getEventFreq($rs['repeat_freq']).' '.getDayOfWeek($rs['repeat_dow']));
if( $rs['repeat_freq']!=0) print(' of the Month');
print(' ['.fmttime($rs['event_time_start']).' to '.fmttime($rs['event_time_end']).']');
}
print(' |
');
print('Event: | '.$rs['event_name'].'
|
');
print('Venue: |
'.$rs['venue_name'].' '.getmap($rs['venue_addr1'],$rs['venue_addr2'],$rs['venue_state']).'
'.$rs['venue_addr1'].'
'.$rs['venue_addr2'].'
|
');
print('Presented by: | '.$rs['grp_name'].'');
if($rs['grp_email']<>"")print(' [email]');
print(' ');
if($rs['grp_website1']<>"")print('>'.cleanURL($rs['grp_website1']).' ');
if($rs['grp_website2']<>"")print('>'.cleanURL($rs['grp_website2']).' ');
if($rs['grp_website3']<>"")print('>'.cleanURL($rs['grp_website3']).' ');
print(' |
');
if($rs['mem_id']!="1"){ $poster=getUserPic($rs); }
print('Age Restriction: | '.getAge($rs['age_range']).' | ');
print('Posted by: | '.$poster.' on '.fmtdate('m.d.y',$rs['create_dt']).' |
');
print('Type of Event: | '.$rs['event_type_name'].' |
');
if($rs['event_target_id']!=0)print('Target Crowd: | '.$rs['target_name'].' |
');
if($rs['event_music']!='')print('Music: | '.trim($rs['event_music_name']).' |
');
print('
');
eventActions();
print('
');
//FLYERS DETAILS ------------------------------------------------------
$fly="";
if($rs['flyer_url1']!='' || $rs['flyer_url2']!='' || $rs['flyer_file1']!='' || $rs['flyer_file2']!=''){
$imgx=-1;
if($rs['flyer_url1']!='')$fly.=('
');
elseif($rs['flyer_file1']!=''){
$imgx=imgSizeCmp($rootdir.'img_flyers/'.$rs['flyer_file1'],600);
$fly.=('
');
}
if($rs['flyer_url2']!='')$fly.=('

');
elseif($rs['flyer_file2']!=''){
$img2x=imgSizeCmp($rootdir.'img_flyers/'.$rs['flyer_file2'],600);
if($imgx>300 || abs($imgx-$img2x)>20){$fly.=('
');}
elseif($imgx>0) print(" ");
$fly.=('
');
}
}
if($fly!="")print('
'.$fly.'
');
//EVENT DETAILS ------------------------------------------------------
$des=strtolower($rs['event_des']);
if(strpos($des,"
'.$des.'
');
}
else{
//$des=$rs['event_des'];
print('');
}
//----------------------------------------------------------------------
print('');
print('');
showMap($gbAddr1,$gbAddr2,$gbVenue,610,400);
print('');
//writeLocPhotos($gbLOC);
writeMemPhotos($cmem_id);
}
else print('
ERROR: EVENT NOT FOUND
go to events');
mysql_free_result($result);
}
//=======================================================
function eventSimilarBox($eid,$lid,$edt){
global $db;
$thisevt="";
$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_status<2 and e.event_target_id=r.target_id and e.event_type_id=t.event_type_id".
" and e.event_dt='".$edt."' and e.venue_id=".$lid." and event_id<>".$eid." order by create_dt",$db);
if( ($rs=mysql_fetch_array($result)) ){
$thisevt.=('
');
$thisevt.=('');
do{
$thisevt.=boxEvent($rs);
}while( ($rs=mysql_fetch_array($result)) );
$thisevt.=(' |
');
print($thisevt);
}
mysql_free_result($result);
}
//=======================================================
function eventSameDay($eid,$edt){
global $db;
$thisevt="";
$lastvenue=0;
$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_status<2 and e.event_target_id=r.target_id and e.event_type_id=t.event_type_id".
" and e.event_dt='".$edt."' and event_id<>".$eid." order by is_promoted desc,create_dt LIMIT 0,10",$db);
if( ($rs=mysql_fetch_array($result)) ){
$thisevt.=('
');
$thisevt.=('');
do{
if($lastvenue!=$rs['venue_id']){
$lastvenue=$rs['venue_id'];
$thisevt.=boxEvent($rs);
}
}while( ($rs=mysql_fetch_array($result)) );
$thisevt.=(' |
');
print($thisevt);
}
mysql_free_result($result);
}
//=======================================================
function boxEvent($rs){
$isprom="";
if($rs['is_promoted']!=0)$isprom="P";
if ($rs['flyer_file1']!='')$thumb='
';
elseif($rs['flyer_url1' ]!='')$thumb='
';
elseif($rs['flyer_url2' ]!='')$thumb='
';
else $thumb='
';
$thisevt="";
$thisevt=('');
$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.=('
');
return $thisevt;
}
//=======================================================
function cleanURL($url){
$url=strtolower($url);
if(substr($url,0,11)=="http://www.")$url=substr($url,11);
elseif(substr($url,0,7)=="http://")$url=substr($url,7);
elseif(substr($url,0,12)=="https://www.")$url=substr($url,12);
elseif(substr($url,0,8)=="https://")$url=substr($url,8);
if( ($p=strpos($url,"/"))>0 )$url=substr($url,0,$p);
return $url;
}
//=======================================================
function getAge($a){
if($a<16)return "No Restrictions";
return $a." and over";
}
//=========================================================
function fixDesc($d){
$ln=strlen($d);
$i=0;
$r="";
while($i<$ln){
$s=substr($d,$i,1);
$t=ord($s);
if(($t>=12 && $t<=15))$r.="
";
else $r.=$s;
$i++;
}
return $r;
}
//=========================================================
function imgSizeCmp($fname,$maxwidth){
if(file_exists($fname)){
$size=getimagesize($fname);
if($size[0]>$maxwidth)return $maxwidth;
return $size[0];
}
return 0;}
?>