<cfquery name="geter" datasource="cg22">
select * from ActivityPlannerHold
where id = #url.eventid#
</cfquery>


 <cfif IsDate(geter.datestart) and isdate(geter.dateend)>





<cfparam name="geter.cg" default="">
<cfparam name="geter.ml" default="">
<cfparam name="geter.pk" default="">
<cfparam name="geter.pkb" default="">
<cfparam name="geter.pkq" default="">
<cfparam name="geter.pkw" default="">


<cfparam name="geter.photo" default="">
<cfparam name="geter.thumbnail" default="">


<cfparam name="geter.ages" default="">
<cfparam name="geter.buytickets" default="">

<cfparam name="geter.pkr" default="">
<cfparam name="geter.catid" default="0">


<Cfif #geter.catid# eq ''>
	<cfset geter.catid = 0>
</Cfif>
<cfparam name="geter.nympregion" default="">
<cfset datestart=#DateFormat(geter.astart,"yyyy-mm-dd")#>
<cfset dateend=#DateFormat(geter.aend,"yyyy-mm-dd")#>

<Cfquery name=checker datasource="#ds#">
SELECT id 
FROM ActivityPlanner 
WHERE (name = '#geter.venue#' OR name = TRIM('#geter.venue#')) 
AND datestart = #geter.datestart#
AND dateend = #geter.dateend#
AND (activityname = '#geter.event#' OR activityname = TRIM('#geter.event#'))
</Cfquery>

<Cfif checker.recordcount eq 0>
<cfquery name=addphoto datasource="#ds#">
INSERT INTO ActivityPlanner(name,catid,datestart,dateend,address,city,state,description,zip,phone,website,address2,contactfirst,contactlast,contactitle,contactphone,contactemail,hours,dtentered,activityname,ages,price,catid2,cg,ml,pk,pkb,pkq,pkw,ActivityPlannerVenueID,shortdescription,pkr,nympregion,pkn,pkf,pks,catid3,catid4,age6,updatedby,updatedon,newsletterpickup,nympprintcat,photo,thumbnail,usepicprint,hotticket,editorlove,approvedby,approvedon,buytickets)

VALUES	('#geter.venue#',#geter.catid#,'#datestart#','#dateend#','#geter.address#','#geter.city#','#geter.state#','#geter.description#','#geter.zip#','#geter.phone#','#geter.website#','#geter.address2#','#geter.contactfirst#','#geter.contactlast#','#geter.contactitle#','#geter.contactphone#','#geter.contactemail#','#geter.hours#',#currentdatetime#,'#geter.event#','#geter.ages#','#geter.price#',#geter.catid2#,'#geter.cg#','#geter.ml#','#geter.pk#','#geter.pkb#','#geter.pkq#','#geter.pkw#',#geter.ActivityPlannerVenueID#,'#geter.shortdescription#','#geter.pkr#','#geter.nympregion#','','','',#geter.catid3#,#geter.catid4#,'','Rob',#currentdatetime#,'',0,'','',0,'','','Rob',#currentdatetime#,'#geter.buytickets#')
</cfquery>

</Cfif>
<cfquery name="updater" datasource="cg22">
update ActivityPlannerHold
set statusnum = 2
where id = #geter.id#
</cfquery>

</cfif>