<cfinclude template="header.cfm">


<div id="content">
  <div id="content-header">
  </div>
  <div class="container-fluid"><cfparam name="form.strollerparking" default="">
<cfparam name="form.takestroller" default="">
<cfparam name="form.strollercheck" default="">
<cfparam name="form.bringfood" default="">
<cfparam name="form.buyfood" default="">
<cfparam name="form.allowedfood" default="">
<cfparam name="form.changingwomen" default="">
<cfparam name="form.changingmen" default="">
<cfparam name="form.changingfamily" default="">

<cfparam name="form.changingunisex" default="">
<cfparam name="form.phoneextension" default="">
<cfparam name="form.Twitter" default="">
<cfparam name="form.Facebook" default="">
<cfparam name="form.Instagram" default="">
<cfparam name="form.Pinterest" default="">
<cfparam name="form.handicap" default="">

<cfset robpic = #createUUID()#>

<cfif parameterexists(form.crop) and #form.crop# is not ''>

	<cftry>
<cfimage source="#form.crop#" action="write" destination="/home/home2/cgny/public_html/calendarphotos/#robpic#.jpg" isBase64="yes" overwrite="true">
<cfset #file.serverfile# = '#robpic#.jpg'>

<cfcatch>
<cffile action="upload"
	        nameconflict="makeunique"
filefield="crop"
accept="image/jpeg,image/pjpeg,image/png"
 destination="/home/home2/cgny/public_html/calendarphotos/#robpic#.jpg"
 mode="644">
</cfcatch>
</cftry>

</cfif>


<CFQUERY datasource="#ds#">
	UPDATE ActivityPlannerVenues SET
website = '#form.website#',
venuename  = '#form.venuename#',
address = '#form.address#',
city = '#form.city#',
lastupdated = #currentdatetime#,
hours = '#form.hours#',
Nearestsubway= '#form.Nearestsubway#',
parking = '#form.parking#',


playarea = '#form.playarea#',
partyroom = '#form.partyroom#',
otherprice = '#form.otherprice#',
adultprice= '#form.adultprice#',
childrenprice= '#form.childrenprice#',
seniorsprice = '#form.seniorsprice#',
phoneextension = '#form.phoneextension#',
state = '#form.state#',
zip = '#form.zip#',
phone = '#form.phone#',
Twitter = '#form.twitter#',
Facebook = '#form.Facebook#',
region = '#form.region#',
Instagram = '#form.Instagram#',
Pinterest = '#form.Pinterest#',
handicap = '#form.handicap#',
<Cfif parameterexists(form.crop) and #form.crop# is not ''>
	image = '#robpic#.jpg',

</Cfif>
description = '#form.description#',
strollerparking = '#form.strollerparking#',
takestroller = '#form.takestroller#',
strollercheck = '#form.strollercheck#',
bringfood = '#form.bringfood#',
buyfood = '#form.buyfood#',
allowedfood = '#form.allowedfood#',
changingunisex = '#form.changingunisex#',
changingwomen = '#form.changingwomen#',
changingmen = '#form.changingmen#',
changingfamily = '#form.changingfamily#',
<cfif parameterexists(form.alistmanhattan) and #form.alistmanhattan# eq 'On'>
alistmanhattan = 1,
<Cfelse>
alistmanhattan = 0,
</Cfif>

<cfif parameterexists(form.alistbrooklyn) and #form.alistbrooklyn# eq 'On'>
alistbrooklyn = 1,
<Cfelse>
alistbrooklyn = 0,
</Cfif>
<cfif parameterexists(form.alistqueens) and #form.alistqueens# eq 'On'>
alistqueens = 1,
<Cfelse>
alistqueens = 0,
</Cfif>
<cfif parameterexists(form.alistwestchester) and #form.alistwestchester# eq 'On'>
alistwestchester = 1,
<Cfelse>
alistwestchester = 0,
</Cfif>
<cfif parameterexists(form.alistrockland) and #form.alistrockland# eq 'On'>
alistrockland = 1,
<Cfelse>
alistrockland = 0,
</Cfif>
<cfif parameterexists(form.alistbronx) and #form.alistbronx# eq 'On'>
alistbronx = 1,
<Cfelse>
alistbronx = 0,
</Cfif>
<cfif parameterexists(form.aliststatenisland) and #form.aliststatenisland# eq 'On'>
aliststatenisland = 1,
<Cfelse>
aliststatenisland = 0,
</Cfif>
<cfif parameterexists(form.alistessex) and #form.alistessex# eq 'On'>
alistessex = 1,
<Cfelse>
alistessex = 0,
</Cfif>
<cfif parameterexists(form.alistfairfield) and #form.alistfairfield# eq 'On'>
alistfairfield = 1,
<Cfelse>
alistfairfield = 0,
</Cfif>
<cfif parameterexists(form.alistbergen) and #form.alistbergen# eq 'On'>
alistbergen = 1,
<Cfelse>
alistbergen = 0,
</Cfif>
<cfif parameterexists(form.alistnassau) and #form.alistnassau# eq 'On'>
alistnassau = 1,
<Cfelse>
alistnassau = 0,
</Cfif>
<cfif parameterexists(form.alistsuffolk) and #form.alistsuffolk# eq 'On'>
alistsuffolk = 1
<Cfelse>
alistsuffolk = 0
</Cfif>

	WHERE id = #form.id#
	</CFQUERY>


	<CFLOOP FROM = "1" TO = "#NumRecords#" INDEX = "ThisRow">

	<CFQUERY datasource="#ds#">
	UPDATE ActivityPlannerVenuesContacts
		SET
		name = '#Evaluate("contactname" & ThisRow)#',
		title = '#Evaluate("contacttitle" & ThisRow)#',
		email = '#Evaluate("contactemail" & ThisRow)#',
		phone = '#Evaluate("contactphone" & ThisRow)#',
		comment = '#Evaluate("contactcomment" & ThisRow)#'

		WHERE ID = #Evaluate("ID" & ThisRow)#
	</CFQUERY>
</CFLOOP>


<cfif parameterexists(form.buttadminman)>
<cflocation addToken="no" url="/editvenue.cfm?id=#form.id#">
<Cfelse>
<cflocation url="addvenue.cfm" addtoken="no">
</cfif>