require("fn/menu.php");
require("../zinc/head.php");
require("../_inc/fn/fmtdate.php");
require("../_inc/fn/writepages.php");
require("../_inc/sel/selstate.php");
require("../_inc/sel/selloctype.php");
require("../_inc/sel/seleventtype2.php");
require("../_inc/sel/seleventmusic.php");
require("../_inc/fn/fn_dayofweek.php");
require("../_inc/fn/fn_cleantag.php");
require("../_inc/fn/fn_image.php");
require("../_inc/fn/dateadd.php");
require("../_inc/fn/datediff.php");
$db = mysql_connect($dbserver,$dbuser,$dbpw);
mysql_select_db($dbname,$db);
dp_main();
mysql_close($db);
require("../zinc/foot.php");
//==============================================================================
function dp_main(){
GLOBAL $gbMemID;
print('
');
dp_menu(6);
print(' ');
displayAddEvent("0","1");
/*
if(($eid=trim($_REQUEST['eid']))!=""){
if(isset($_POST['addevent']) && $_POST['addevent']=="yes")insertEvent();
else displayAddEvent("0","1");
}
else{
if($gbMemID==""){dpLogin();}
elseif(isset($_REQUEST['av']) && $_REQUEST['av']=="8")addVenue();
elseif(isset($_POST['addevent']) && $_POST['addevent']=="yes")insertEvent();
elseif(isset($_REQUEST['vid']))displayAddEvent("0","1");
elseif(isset($_REQUEST['av']) && $_REQUEST['av']=="7")dpVenue();
else dp_policy();
}
//*/
print('
');
}
//=========================================================
function box_red_top($n){}
function box_red_bot(){}
function dpLogin(){
box_red_top("Please Login","585","");
print('Please login to add a event. if you do not have a account, you can register for a free account here . ');
box_red_bot();
}
//=========================================================
function dp_policy(){
GLOBAL $db,$gbMemID;
$result=mysql_query("select mem_id from cz_members where mem_status=1 and mem_id=".$gbMemID,$db);
if(! ($rs=mysql_fetch_array($result)) ){
print("");
exit;
}
$cdt="";
if(isset($_GET['cdt']))$cdt=$_GET['cdt'];
box_red_top("Event Posting Policy","585","");
print('');
box_red_bot();
print('');
}
//=========================================================
function dpVenue(){
GLOBAL $db,$gbMemID,$gbState;
if($gbState=='ZZ' || $gbState=='')$gbState="NY";
$result=mysql_query("select count(m.loc_id) as cnt from cz_location l,cz_mem_loc m where l.loc_id=m.loc_id and m.mem_id=".$gbMemID,$db);
if( ($rs=mysql_fetch_array($result)) ){ $vcnt=$rs['cnt'];}
mysql_free_result($result);
box_red_top("Step (1/2): Select or Create Venue","600","");
if($vcnt>0){
$rcnt=floor(($vcnt+2)/3);
$result=mysql_query("select l.* from cz_location l,cz_mem_loc m where l.loc_id=m.loc_id and m.mem_id=".$gbMemID." order by addr_city,loc_name",$db);
//$result=mysql_query("select l.* from cz_location l,cz_mem_loc m where l.loc_id=m.loc_id and m.mem_id=".$gbMemID." and loc_status=1 and addr_state='".$gbState."' order by addr_city,loc_name",$db);
print('');
$ct=0;
$city="";
while( ($rs=mysql_fetch_array($result)) ){
if($city!=$rs['addr_city']){
if($ct!=0)print(' ');
$city=$rs['addr_city'];
print(''.$city.' ');
}
elseif($ct==0)print(''.$city.' (con"t) ');
print(' '.cutstr($rs['loc_name'],25).' ');
print(' '.$rs['addr_1'].' ');
if(++$ct>$rcnt){ $ct=0; print(' '); }
}
mysql_free_result($result);
print('
');
}
else print(" no venues for this area found in our database ");
box_red_bot();
print(" OR ");
box_red_top("Step (1/2): Create New Venue","585","");
print('');
box_red_bot();
print('');
?>
}
//=========================================================
function addVenue(){
global $db,$gbMemID;
$loc_name=trim($_POST['loc_name']);
$loc_addr1=trim($_POST['loc_addr1']);
$loc_addr2=trim($_POST['loc_addr2']);
$loc_city=trim($_POST['loc_city']);
if( $loc_name=="" || $loc_addr1=="" || $loc_city==""){
box_red_top("Step (1/2): Create New Venue","585","");
print('Please enter the Venue Name, Address, and City ');
box_red_bot();
}
else{
$loc_state=trim($_POST['loc_state']);
$loc_zip=trim($_POST['loc_zip']);
$loc_info=trim($_POST['loc_info']);
$loc_website=(cleanurl($_POST['loc_website']));
mysql_query("insert into cz_location(loc_name,addr_1,addr_2,addr_city,addr_state,addr_zip,addr_info,loc_website,create_dt,create_ip) values".
"('".cleantag($loc_name)."'".
",'".cleantag($loc_addr1)."'".
",'".cleantag($loc_addr2)."'".
",'".cleantag($loc_city)."'".
",'".$loc_state."'".
",'".$loc_zip."'".
",'".cleantag($loc_info)."'".
",'".$loc_website."'".
",now(),'".$_SERVER['REMOTE_ADDR']."')",$db);
$result=mysql_query("select max(loc_id) as xid from cz_location",$db);
if( ($rs=mysql_fetch_array($result)) ){ $loc_id=$rs['xid']; }
mysql_free_result($result);
mysql_query("insert into cz_mem_loc(mem_id,loc_id) values(".$gbMemID.",".$loc_id.")",$db);
box_red_top("Step (1/2): Create New Venue","585","");
?>
box_red_bot();
}
}
//=========================================================
//== INSERT Venue =========================================
//=========================================================
function insertVenue(){
GLOBAL $db,$gbMemID;
mysql_query("insert into cz_location(loc_name,addr_1,addr_city,addr_state,addr_zip,addr_info,loc_website,create_dt,create_ip) values".
"('".cleantag($_POST['loc_name'])."'".
",'".cleantag($_POST['loc_addr1'])."'".
",'".cleantag($_POST['loc_city'])."'".
",'".cleantag($_POST['loc_state'])."'".
",'".cleantag($_POST['loc_zip'])."'".
",'".cleantag($_POST['loc_info'])."'".
",'".cleanurl($_POST['loc_website'])."'".
",now(),'".$_SERVER['REMOTE_ADDR']."')",$db);
$result=mysql_query("select max(loc_id) as xid from cz_location",$db);
if( ($rs=mysql_fetch_array($result)) ){ $loc_id=$rs['xid']; }
mysql_free_result($result);
mysql_query("insert into cz_mem_loc(mem_id,loc_id) values(".$gbMemID.",".$loc_id.")",$db);
return $loc_id;
}
//=========================================================
//== INSERT EVENT =========================================
//=========================================================
function insertEvent(){
GLOBAL $db,$gbMemID,$username,$rootdir;
/// INSERT EVENT /////////////////////////////////////////
$muzstr="";
$cnt=count($_POST['event_music']);
for($i=0;$i<$cnt;$i++){ $muzstr.=$_POST['event_music'][$i]; }
if( ($loc_id=$_POST['loc_id'])==0)$loc_id=insertVenue();
$start_dt=$_POST['start_dt'].' '.$_POST['stime'];
$end_dt=DateAdd("d",1,$_POST['start_dt']).' '.$_POST['etime'];
$event_dt=$_POST['start_dt'];
$sql="insert into cz_events(mem_id,username,grp_name,grp_email,grp_website1,grp_website2,grp_website3,venue_id,venue_name,venue_addr1,venue_addr2,venue_state,venue_info,venue_website,event_name,event_sdt,event_edt,event_dt,event_time_start,event_time_end,event_des,event_music,event_music_name,event_status,event_type_id,event_target_id,age_range,create_dt,create_ip,last_dt,last_ip) values(".
$gbMemID.",'".$username.
"','".cleantag($_POST['grp_name'])."','".strtolower(cleantag($_POST['grp_email']))."','".strtolower(cleanurl($_POST['grp_website1']))."','".strtolower(cleanurl($_POST['grp_website2']))."','".strtolower(cleanurl($_POST['grp_website3'])).
"',".$loc_id.",'".cleantag($_POST['loc_name'])."','".cleantag($_POST['loc_addr1'])."','".cleantag($_POST['loc_city']).", ".$_POST['loc_state']." ".$_POST['loc_zip']."','".$_POST['loc_state']."','".cleantag($_POST['loc_info'])."','".strtolower(cleanurl($_POST['loc_website'])).
"','".cleantag($_POST['event_name'])."'".
",'".$start_dt."'".
",'".$end_dt."'".
",'".$event_dt."'".
",'".($_POST['stime'])."','".($_POST['etime'])."','".cleanXtag($_POST['event_des'])."'".
",'".$muzstr."','".getEventMusic($muzstr)."',0,".$_POST['event_type'].",".$_POST['target_id'].",".$_POST['age_range'].
",now(),'".$_SERVER['REMOTE_ADDR']."',now(),'none')";
mysql_query($sql,$db);
/// GET EVENT ID /////////////////////////////////////////
$result=mysql_query("select (max(event_id)) as xid from cz_events",$db);
if( ($rs=mysql_fetch_array($result)) ){ $event_id=$rs['xid']; }
mysql_free_result($result);
mysql_query("insert into cz_mem_event(mem_id,event_id) values(".$gbMemID.",".$event_id.")",$db);
/// UPLOAD FLYERS /////////////////////////////////////////
$err='';
$flyerfile1='';
$flyerfile2='';
$flyerurl1=cleanurl($_POST['flyerurl1']);
if( $flyerurl1=="" || $flyerurl1 == "http://"){
$flyerurl1="";
$flyerfile1=upload_image("flyer1",str_pad($event_id, 7, "0", STR_PAD_LEFT).'_1',"img_flyers/",&$err);
if($flyerfile1=="none.gif")$flyerfile1="";
}
$flyerurl2=cleanurl($_POST['flyerurl2']);
if( $flyerurl2=="" || $flyerurl2 == "http://"){
$flyerurl2="";
$flyerfile2=upload_image("flyer2",str_pad($event_id, 7, "0", STR_PAD_LEFT).'_2',"img_flyers/",&$err);
if($flyerfile2=="none.gif")$flyerfile2="";
}
$sql="update cz_events set flyer_file1='".$flyerfile1."',flyer_file2='".$flyerfile2."',flyer_url1='".$flyerurl1."',flyer_url2='".$flyerurl2."' where event_id=".$event_id;
mysql_query($sql,$db);
/// FINISH /////////////////////////////////////////
$msg="Thank You, Your event has been added.";
if($err!="")$msg="Thank You, Your event has been added.BUT THERE ARE ERRORS ".$err;
box_red_top("Step Finalize: Create New Event","585","");
?>
box_red_bot();
}
//=========================================================
//== DISPLAY FROM =========================================
//=========================================================
function displayAddEvent($is_repeat,$evt_type){
GLOBAL $db,$gbMemID,$gbCity;
$vid=$_REQUEST['vid'];
// GET GROUP SELECT ///////////////////////////////////
if($_POST["grp_name"]==""){
if(($eid=trim($_REQUEST['eid']))!=""){
$result=mysql_query("select * from cz_events where event_id=".$eid,$db);
if( ($rs=mysql_fetch_array($result)) ){
$vid=$rs['venue_id'];
$area_id=$rs['venue_area_id'];
$grp_name=$rs["grp_name"];
$grp_email=$rs["grp_email"];
$grp_website1=$rs["grp_website1"];
$grp_website2=$rs["grp_website2"];
$grp_website3=$rs["grp_website3"];
$event_name=$rs['event_name'];
$event_des=$rs['event_des'];
$event_type=$rs['event_type_id'];
$age=$rs['age_range'];
$target_id=$rs['event_target_id'];
$event_music=$rs['event_music'];
$flyer1=$rs['flyer_file1'];
$flyer2=$rs['flyer_file2'];
$flyerurl1=$rs['flyer_url1'];
$flyerurl2=$rs['flyer_url2'];
if($flyer1!="")$flyerurl1='http://clubzen.com/img_flyers/'.$flyer1;
if($flyer2!="")$flyerurl2='http://clubzen.com/img_flyers/'.$flyer2;
$start_dt=$rs['event_dt'];
$df=datediff('d',$rs['event_dt'],date("Y-m-d"));
if($df>0){
$dx=$df%7;
$df=floor($df/7);
if($dx>0)$df++;
}
else $df=1;
$start_dt=dateadd('d',$df*7,$rs['event_dt']);
$starttime=substr($rs['event_time_start'],0,5);
$endtime=substr($rs['event_time_end'],0,5);
}
mysql_free_result($result);
}else{
if($age=="")$age="21";
$start_dt=date('Y-m-d');
$result=mysql_query("select * from cz_events where mem_id=".$gbMemID." order by create_dt desc LIMIT 0,1",$db);
if( ($rs=mysql_fetch_array($result)) ){
$vid=$rs['venue_id'];
$area_id=$rs['venue_area_id'];
$grp_name=$rs["grp_name"];
$grp_email=$rs["grp_email"];
$grp_website1=$rs["grp_website1"];
$grp_website2=$rs["grp_website2"];
$grp_website3=$rs["grp_website3"];
$age=$rs['age_range'];
$target_id=$rs['event_target_id'];
$event_music=$rs['event_music'];
}
mysql_free_result($result);
$result=mysql_query("select * from cz_location where loc_id=".$vid,$db);
if( ($rs=mysql_fetch_array($result)) ){
$loc_name=str_replace('"','',$rs['loc_name']);
$loc_addr1=$rs['addr_1'];
$loc_addr2=$rs['addr_2'];
$loc_city=$rs['addr_city'];
$loc_state=$rs['addr_state'];
$loc_zip=$rs['addr_zip'];
$loc_info=str_replace('"','',$rs['addr_info']);
$loc_website=$rs['loc_website'];
}
mysql_free_result($result);
}
}
else{
$grp_name=$_POST["grp_name"];
$grp_website1=$_POST["grp_website1"];
$grp_website2=$_POST["grp_website2"];
$grp_website3=$_POST["grp_website3"];
$grp_email=$_POST["grp_email"];
$age=$_POST['age_range'];
$target_id=$_POST['target_id'];
$event_music=$_POST['event_music'];
$loc_name=str_replace('\"','"',str_replace("\'","'",$_POST['loc_name']));
$loc_addr1=$_POST['loc_addr1'];
$loc_city=$_POST['loc_city'];
$loc_zip=$_POST['loc_zip'];
$loc_state=$_POST['loc_state'];
$loc_website=$_POST['loc_website'];
$loc_type=$_POST['loc_type'];
$loc_info=$_POST['loc_info'];
if($loc_state=="")$loc_state="NY";
$event_name=$_POST['event_name'];
$event_des=$_POST['event_des'];
$flyerurl1=$_POST['flyerurl1'];
$flyerurl2=$_POST['flyerurl2'];
$start_dt=$_POST['start_dt'];
$starttime=$_POST['stime'];
$endtime=$_POST['etime'];
}
// SET DATA /////////////////////////////////////////////
$is_repeat=$_REQUEST['t'];
if( $starttime=="")$starttime="22:00";
if( $endtime=="")$endtime="04:00";
///// SET LOCATION DATA /////////////////////////////////////////////
if( ($loc_id=$_POST['loc_id'])=="")$loc_id=$vid;
$selLoc='-- New Location --';
$result=mysql_query("select l.* from cz_location l,cz_mem_loc m where (l.loc_id=m.loc_id and m.mem_id=".$gbMemID.") order by addr_state,addr_city,loc_name",$db);
while( ($rs=mysql_fetch_array($result)) ){
if($loc_id==$rs['loc_id']){
$selLoc.=' '.$rs['addr_state'].' '.$rs['addr_city'].' -- '.$rs['loc_name'];
if($loc_id!=$_POST['vid']){
$loc_type=$rs['loc_type_id'];
$loc_name=$rs['loc_name'];
$loc_addr1=$rs['addr_1'];
$loc_city=$rs['addr_city'];
$loc_state=$rs['addr_state'];
$loc_zip=$rs['addr_zip'];
$loc_info=$rs['addr_info'];
$loc_website=$rs['loc_website'];
}
}
else $selLoc.=' '.$rs['addr_state'].' '.$rs['addr_city'].' -- '.$rs['loc_name'];
}
mysql_free_result($result);
$selLoc.=' ';
///// SET LOCATION DATA /////////////////////////////////////////////
$grp_name=str_replace("\\","",$grp_name);
$grp_name=str_replace("\"",""",$grp_name);
$event_name=str_replace("\\","",$event_name);
$event_name=str_replace("\"",""",$event_name);
$flyerpreview1="/img/preview.gif";
$flyerpreview2="/img/preview.gif";
if($flyerurl1=="")$flyerurl1="http://";else $flyerpreview1=$flyerurl1;
if($flyerurl2=="")$flyerurl2="http://";else $flyerpreview2=$flyerurl2;
box_red_top("Step (2/2): Create New Event","585","");
?>
}
//=========================================================
function padon($s,$ln){
$s=substr($s,0,$ln);
$i=strlen($s);
while($i++<$ln)$s.=" ";
return $s;
}
//==============================================================================
function monthname($m,$x){ return date($x, mktime(0,0,0,$m,"1","2002") ); }
//=========================================================
function selDate($n,$m,$d,$y){
print(selmonth($n,$m));
if($n=="s") print('');
else print('');
for($i=1;$i<=31;$i++){
if($i<10)print("".$i);
else print(" ".$i);
}
print(' ');
$yr=date("Y")+2;
if($n=="s") print('');
else print('');
for($i=$yr;$i>=2000;$i--)print("".$i);
print(' ');
}
//=========================================================
function selMonth($n,$v){
if($n=="s") $rval=('');
else $rval=('');
for($i=1;$i<=12;$i++){
if($i<10)$rval.="".monthname($i,"M");
else $rval.=" ".monthname($i,"M");
}
return $rval." ";
}
//=========================================================
function selTime($n,$v){
$rval='';
$h2=0;
$h=12;
$m="00";
$a="AM";
$i=0;
while(++$i<=48){
$t=$h.':'.$m.' '.$a;
if($h<10){ $t='0'.$h.':'.$m.' '.$a; }
else { $t=$h.':'.$m.' '.$a; }
if($h2<10){ $z='0'.$h2.':'.$m; }
else { $z=$h2.':'.$m; }
$rval.=''.$t;
if($m=="30"){ $m="00"; ++$h2; if(++$h>12){$h=1;} if($h2>=12)$a="PM"; }
else{ $m="30"; }
}
return $rval.' ';
}
//=========================================================
function selAge($n,$v,$o){
return '
No Age Restriction
16 and over
18 and over
21 and over
Other
if other: ';
}
//=========================================================
function selTarget($n,$v){
global $db;
$result=mysql_query("select * from ref_event_target where target_id<>0 order by target_sort",$db);
while( ($rs=mysql_fetch_array($result)) ){
$rval.=''.$rs['target_name'].' ';
}
mysql_free_result($result);
return 'Select target crowd '.$rval.' ';
}
//=======================================================
function chkYesNo($name,$v){
if($v==0)return(' No Yes');
else return(' No Yes');
}
//=========================================================
function clean($s){
return str_replace("'","'",trim($s));
}
function cleantag($s){
return str_replace("'","'",strip_tags(trim($s)));
}
function cleanurl($s){
$s=strtolower(trim($s));
if($s=="")return "";
if($s=="http://")return "";
if(substr($s,0,7)!="http://") return "http://".strip_tags(trim($s));
else return strip_tags(trim($s));
}
//==============================================================
function upload_image($fieldname,$pixname,$imgdir,&$err){
global $rootdir,$gbMemID;
$maxwidth=600;
$err="";
if($_FILES[$fieldname]['name']!=''){
if(!isImageType($_FILES[$fieldname]['type'])){
$err.="Profile image not uploaded Images must be in .jpg format";
}
elseif (!is_uploaded_file($_FILES[$fieldname]['tmp_name'])){
$err.="".$_FILES[$fieldname]['name']." couldn't be copied !!";
}
else{
$pic_ext=getImageType($_FILES[$fieldname]['type']);
$pic_flyer0=$pixname.'.'.$pic_ext;
$pic_flyer1=$pixname.'.jpg';
move_uploaded_file($_FILES[$fieldname]['tmp_name'],$rootdir.$imgdir.$pic_flyer0) or $err.="Profile image not uploaded Error moving file.";
if($pic_ext=='gif'){
covertimagetype($rootdir.$imgdir.$pic_flyer0, $rootdir.$imgdir.$pic_flyer1);
@unlink($rootdir.$imgdir.$pic_flyer0);
delGif2Jpg($rootdir.$imgdir.$pic_flyer1);
}
$size=getimagesize($rootdir.$imgdir.$pic_flyer1);
if($size[0]>$maxwidth || $size[1]>$maxwidth ){
resampleimage($maxwidth,$maxwidth, $rootdir.$imgdir.$pic_flyer1, $rootdir.$imgdir.$pic_flyer1);
}
else{
$fsize=filesize($rootdir.$imgdir.$pic_flyer1);
resampleimage($size[0],$size[1], $rootdir.$imgdir.$pic_flyer1, $rootdir.$imgdir."x".$pic_flyer1);
if($fsize>filesize($rootdir.$imgdir."x".$pic_flyer1)){
resampleimage($size[0],$size[1], $rootdir.$imgdir.$pic_flyer1, $rootdir.$imgdir.$pic_flyer1);
}
@unlink($rootdir.$imgdir."x".$pic_flyer1);
}
@chmod($rootdir.$imgdir.$pic_flyer1,0666);
if(substr($pixname,7,2)!='_2'){
resizeimage(90,60, $rootdir.$imgdir.$pic_flyer1, $rootdir.$imgdir."thumbs/".$pic_flyer1);
delGif2Jpg($rootdir.$imgdir."thumbs/".$pic_flyer1);
@chmod($rootdir.$imgdir."thumbs/".$pic_flyer1,0666);
}
if (file_exists($rootdir.$imgdir.$pic_flyer1)) return $pic_flyer1;
}
}
/*
elseif($_POST['rimg_'.$fieldname]=="yes"){
if (file_exists($rootdir.$imgdir.$pixname.'.jpg')) { @unlink($rootdir.$imgdir.$pixname.'.jpg'); @unlink($rootdir.$imgdir."t_".$pixname.'.jpg');}
elseif (file_exists($rootdir.$imgdir.$pixname.'.gif')){ @unlink($rootdir.$imgdir.$pixname.'.gif'); @unlink($rootdir.$imgdir."t_".$pixname.'.gif');}
elseif (file_exists($rootdir.$imgdir.$pixname.'.png')){ @unlink($rootdir.$imgdir.$pixname.'.png'); @unlink($rootdir.$imgdir."t_".$pixname.'.png');}
return "none.gif";
}//*/
return "";
}
//=========================================================
?>