<cfinclude template="header.cfm">


<cfif parameterexists(form.skipbutton)>

<cfquery name="updater" datasource="cg22">
update ActivityPlannerHold
set statusnum = 1
where id = #form.id#
</cfquery>

<cflocation url="approvecalendar.cfm" addtoken="no">
</cfif>


<cfif parameterexists(form.delbutton)>

<cfquery name="updater" datasource="cg22">
delete from ActivityPlannerHold
where id = #form.id#
</cfquery>

<cflocation url="approvecalendar.cfm" addtoken="no">
</cfif>

 <cfif IsDate(FORM.datestart) and isdate(form.dateend)>





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

<cfparam name="form.pkn" default="">
<cfparam name="form.pks" default="">

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

<cfparam name="form.nympprintcat" default="0">
<cfparam name="form.buytickets" default="0">

<cfparam name="form.ages" default="">

<cfparam name="form.pkr" default="">
<cfparam name="form.age6" default="">
<cfparam name="form.editorlove" default="">
<cfparam name="form.catid" default="0">


<Cfif #form.catid# eq ''>
	<cfset form.catid = 0>
</Cfif>
<cfparam name="form.nympregion" default="">
<cfset datestart=#DateFormat(form.datestart,"yyyy-mm-dd")#>
<cfset dateend=#DateFormat(form.dateend,"yyyy-mm-dd")#>
<cfif parameterexists(form.addbutton)>


<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	('#form.name#',#form.catid#,'#datestart#','#dateend#','#form.address#','#form.city#','#form.state#','#form.description#','#form.zip#','#form.phone#','#form.website#','#form.address2#','#form.contactfirst#','#form.contactlast#','#form.contactitle#','#form.contactphone#','#form.contactemail#','#form.hours#',#currentdatetime#,'#form.activityname#','#form.ages#','#form.price#',#form.catid2#,'#form.cg#','#form.ml#','#form.pk#','#form.pkb#','#form.pkq#','#form.pkw#',#form.ActivityPlannerVenueID#,'#form.shortdescription#','#form.pkr#','#form.nympregion#','#form.pkn#','#form.pkf#','#form.pks#',#form.catid3#,#form.catid4#,'#form.age6#','#getuser.member#',#currentdatetime#,'#form.newsletterpickup#',#form.nympprintcat#,'#form.photo#','#form.thumbnail#',#form.usepicprint#,'#form.hotticket#','#form.editorlove#','#getuser.member#',#currentdatetime#,'#form.buytickets#')
</cfquery>


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


<a href="https://www.cityguideny.com/admin/approvecalendarlist.cfm">Back to Approve Calendar</a>
<cfquery name="Getcat" datasource="#ds#">
select id,nympregion
from ActivityPlanner
order by id desc
limit 0,1
</cfquery>



<Cfif #getcat.nympregion# is not ''>
<CFMAIL
TO="#form.contactemail#"

SUBJECT="Your event has been approved for the NYMetroParents Calendar"

        FROM="NYMP <#session.email#>"
SERVER="127.0.0.1"
type="html">

Congratulations! Your event has been approved in our calendar section. To see your event listing, go to: <a href="http://nymetroparents.com/2011neweventinfo.cfm?id=#getcat.id#">http://nymetroparents.com/2011neweventinfo.cfm?id=#getcat.id#</a>
<p>
You're definitely in our online calendar, and if you made the deadline, your event may also be included in one of our print calendars. Didn't know we had print calendars? We're not mad...but you might want to <a href="http://nymetroparents.com/nviewpage.cfm?colid=7475">get acquainted with our publications</a>.</p>
<p>Now start spreading the word about your great event! We recommend posting the link above to your <a href="http://www.facebook.com">Facebook</a> and <a href="http://www.twitter.com">Twitter</a> pages. Not a fan of social media? Go ahead and send out an email to your clients and friends (you probably need to catch up anyway, right?).</p>
<p>By the way, if your event is really terrific, we might just select it for our weekly activities newsletter, where we highlight the best family events happening each weekend in the NYC area. Keep tabs on it by <a href="http://nymetroparents.com/2011nregisternew.cfm">signing up</a> (it's free!).</p>
Want to submit more events? Head back to <a href="http://www.nymetroparents.com/submitevent">http://www.nymetroparents.com/submitevent</a>.
<p>
Questions? <a href="http://nymetroparents.com/ncontact.cfm">Contact us</a>.
<p>
Thanks!<br />
The NYMetroParents Editorial Team
<p>

---------------------------------------------<br>
<a href="http://nymetroparents.com/">nymetroparents.com</a>
</cfmail>
</Cfif>

<br /><FORM action="dupecalendar.cfm" method="post">
<cfoutput><input type="hidden" name="id" value="#getcat.id#"></cfoutput>
<font face=verdana size=-1>Enter Number of Times to Duplicate Entry <input NAME="dupenum" SIZE="5">
<input type="submit" Value="Dupe">
</FORM>
<p>
<a href="activityplanneredit.cfm?mag=5">Back to Calendar Admin</a>...

</cfif>




<cfelse>
<Table width=800><Tr><Td></Td></Tr></Table>
<p>
<font face=verdana size=+1><center>
<strong>Invalid Date Format,<br /> <a href="javascript: history.go(-1)">Click Here to Go Back and Edit</a></strong>
</center>

</cfif>