<cfinclude template="header.cfm">


<div id="content">
  <div id="content-header">
  </div>
  <div class="container-fluid" style="margin-left:300px;">


<cfif parameterexists(form.zip) and #form.zip# is not '' and #form.city# eq '' and #form.state# eq ''>
	<Cfquery name="Getss" datasource="#ds#">
		select city,state from Zip_code_table2017
	    where zip = #form.zip#
	</cfquery>
	<cfif #getss.recordcount# gt 0>
		<cfset form.state = '#getss.state#'>

	<cfset form.city = '#getss.city#'>

	</cfif>
</cfif>


	  <cfif parameterexists(getuser.id)>

<cfparam name="form.phonex" default="">
<cfparam name="form.onlineonly" default="">
<cfparam name="form.registrationrequired" default="">
<cfparam name="form.daysofweek" default="">
<cfparam name="form.cg" default="">
<cfparam name="form.nympregion" default="">
<cfparam name="form.shortdescription" default="">
<cfparam name="form.contactfirst" default="">
<cfparam name="form.contactlast" default="">
<cfparam name="form.contacttitle" default="">
<cfparam name="form.contactphone" default="">
<cfparam name="form.contactemail" default="">
<cfparam name="form.catid3" default="0">
<cfparam name="form.catid4" default="0">
<cfparam name="form.catid" default="0">
<cfparam name="form.catid2" default="0">

<cfparam name="form.alist" default="0">
<cfparam name="form.mainpage" default="0">
<cfparam name="form.address2" default="0">

<cfparam name="form.ml" default="">
<cfparam name="form.pk" default="">
<cfparam name="form.pkb" default="">
<cfparam name="form.pkq" default="">
<cfparam name="form.nympprintcat" default="0">

<cfparam name="form.pkf" default="">
<cfparam name="form.pkw" default="">

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

<Cfparam name="form.age1" default="">
<Cfparam name="form.age2" default="">
<Cfparam name="form.age3" default="">
<Cfparam name="form.age4" default="">
<Cfparam name="form.age5" default="">
<Cfparam name="form.age6" default="">
<Cfparam name="form.ages" default="">
<Cfparam name="form.newsletterpickup" default="">

<Cfparam name="form.price1" default="">
<Cfparam name="form.price2" default="">
<Cfparam name="form.price3" default="">
<Cfparam name="form.price4" default="">
<Cfparam name="form.price5" default="">
<Cfparam name="form.price6" default="">
<Cfparam name="form.starthours" default="">
<Cfparam name="form.startminutes" default="">
<Cfparam name="form.starttt" default="">
<Cfparam name="form.endhours" default="">
<Cfparam name="form.endminutes" default="">
<Cfparam name="form.endtt" default="">
<Cfparam name="form.hotticket" default="">
<Cfparam name="form.hotticketregion" default="">

<Cfparam name="form.editorlove" default="">

<cfquery name="Getcat" datasource="cityguide">
SELECT cat,catid
FROM CatActivityPlanner
</cfquery>

<div align="center"><font face=verdana size=+1><strong>Preview Entry</strong></font></div>
<p>
	<cftry>
	<cfquery name="finddupe" dataSource="#ds#">
		select id from ActivityPlanner 
		where name = '#form.name#' and activityname like '%#form.activityname#%'
		and datestart = '#dateformat(form.datestart,'yyyy-mm-dd')#'
		and dateend = '#dateformat(form.dateend,'yyyy-mm-dd')#'

	</cfquery>
	
	<Cfif finddupe.recordcount gt 0>
		<font color="red"><b>Warning - there’s a similar event already listed. If this is the same as already listed, please do not proceed. If this is definitely a different event, continue with approval process.</b></font>
		
	</Cfif>
	<cfcatch></cfcatch>
	</cftry>

<cfoutput> 
<font face=verdana size=-1>


<b>PRINT Region(s):</b>
<Cfif parameterexists(form.cg) and #form.cg# eq 'On'>CityGuide, </Cfif>
<Cfif parameterexists(form.pk) and #form.pk# eq 'On'>NYMP - Manhattan, </Cfif>
<Cfif parameterexists(form.pkb) and #form.pkb# eq 'On'>NYMP - Brooklyn, </Cfif>
<Cfif parameterexists(form.pkq) and #form.pkq# eq 'On'>NYMP - Queens, </Cfif>
<Cfif parameterexists(form.pkw) and #form.pkw# eq 'On'>NYMP - Westchester, </Cfif>
<Cfif parameterexists(form.pkr) and #form.pkr# eq 'On'>NYMP - Rockland, </Cfif>
<Cfif parameterexists(form.pkf) and #form.pkf# eq 'On'>NYMP - Fairfield, </Cfif>
<Cfif parameterexists(form.pkn) and #form.pkn# eq 'On'>NYMP - Nassau, </Cfif>
<Cfif parameterexists(form.pks) and #form.pks# eq 'On'>NYMP - Suffolk</Cfif>


<br>
<b>ONLINE Region(s):</b> #form.nympregion#

<p>
<cfset myText=form.descriptiona>
<!--- replace double quotes --->
<cfset myText=replace(myText, chr(8220), chr(34), "all")>
<cfset myText=replace(myText, chr(8221), chr(34), "all")>
<cfset myText=replace(myText, "’", "'", "all")>
<!--- replace single quotes --->
<cfset myText=replacenocase(myText, chr(8216), chr(39), "all")>
<cfset form.descriptiona=replace(myText, chr(8217), chr(39), "all")>



<cfset myText=form.name>
<!--- replace double quotes --->
<cfset myText=replace(myText, chr(8220), chr(34), "all")>
<cfset myText=replace(myText, chr(8221), chr(34), "all")>
<cfset myText=replace(myText, "’", "'", "all")>
<!--- replace single quotes --->
<cfset myText=replacenocase(myText, chr(8216), chr(39), "all")>
<cfset myText=replacenocase(myText, '"', "'", "all")>
<cfset form.name=replace(myText, chr(8217), chr(39), "all")>

<cfset myText=form.activityname>
<!--- replace double quotes --->
<cfset myText=replace(myText, chr(8220), chr(34), "all")>
<cfset myText=replace(myText, chr(8221), chr(34), "all")>
<cfset myText=replace(myText, "’", "'", "all")>
<!--- replace single quotes --->
<cfset myText=replacenocase(myText, chr(8216), chr(39), "all")>
<cfset myText=replacenocase(myText, '"', "'", "all")>
<cfset form.activityname=replace(myText, chr(8217), chr(39), "all")>


<font face=verdana size=-1>
<cfif #datediff('d',dateend,datestart)# eq 0>#dateformat(form.datestart,'mm/dd/yy')#<cfelse> #dateformat(form.datestart,'mm/dd/yy')#  through #dateformat (form.dateend,'mm/dd/yy')# </cfif>
<br />Hours: #form.starthours#:<cfif #form.startminutes# eq '0'>00<cfelse>#form.startminutes#</cfif>#form.starttt#
#form.hours#
<p>



<font face=verdana size=-1>
<strong>#form.name#<br />
#form.activityname#</a></strong>
<cfif #form.address# is not ''><br>#form.address#   </cfif>
<cfif #form.address2# is not ''><br>#form.address2#   </cfif>
<cfif #form.city# is not ''><br>#form.city#,</cfif> <cfif #form.state# is not ''>#form.state#</cfif> <cfif #form.zip# is not ''>#form.zip#</cfif>

<br />
 <cfif #form.txtphone# is not ''>Phone: #form.txtphone#   </cfif> <br />
<cfif #form.website# is not ''><br /><a href="#website#" target="new">#form.website#</a></cfif>
<p>
Short: #form.shortdescription# <br />
Full: #form.descriptiona# <br />
Price: #form.age1# - #form.price1#
#form.age2# - #form.price2#<br />
#form.age3# - #form.price3#<br />
#form.age4# - #form.price4#<br />
#form.age5# - #form.price5#<br />
#form.age6# - #form.price6#<br />
#form.price#<br />
Ages: #form.ages#
<hr>
<strong>Contact:</strong> #form.contactfirst# #form.contactlast#<br />
#form.contacttitle#<br />
#form.contactphone#<br />
#form.contactemail#
#form.onlineonly#


</cfoutput>

<FORM name="bookforma" action="addcalendar2.cfm?requesttimeout=5000" method="post" enctype="multipart/form-data">



<cfoutput>
<cfif parameterexists(form.tablename) and parameterexists(form.itemid)>

  <input NAME="tablename" SIZE="65" type="hidden" value="#form.tablename#">
  <input NAME="itemid" SIZE="65" type="hidden" value="#form.itemid#">
</cfif>
<input name="phonex" type="hidden" value="#form.phonex#">

<input name="cg" type="hidden" value="#form.cg#">
<input name="ml" type="hidden" value="#form.ml#">
<input name="pk" type="hidden" value="#form.pk#">
<input name="pkb" type="hidden" value="#form.pkb#">
<input name="pkq" type="hidden" value="#form.pkq#">
<input name="pkf" type="hidden" value="#form.pkf#">
<input name="pkw" type="hidden" value="#form.pkw#">
<input name="pkn" type="hidden" value="#form.pkn#">
<input name="pks" type="hidden" value="#form.pks#">
<input name="newsletterpickup" type="hidden" value="#form.newsletterpickup#">
<input name="hotticket" type="hidden" value="#form.hotticket#">
<input name="editorlove" type="hidden" value="#form.editorlove#">


<input name="pkr" type="hidden" value="#form.pkr#">
<input name="nympregion" type="hidden" value="#form.nympregion#">
<input name="nympprintcat" type="hidden" value="#form.nympprintcat#">

		  	  <input NAME="price" SIZE="65" value="#form.price#" type="hidden">
			  	  <input NAME="ages" SIZE="65" value="#form.ages#" type="hidden">
	  <input NAME="address" SIZE="65" value="#form.address#" type="hidden">
	  	  <input NAME="address2" SIZE="65" value="#form.address2#" type="hidden">
	  <input NAME="City" SIZE="65" value="#form.City#" type="hidden">
	  <input NAME="state" SIZE="3" value="#form.state#" type="hidden">
	  <input NAME="zip" SIZE="5" value="#form.zip#" type="hidden">
	  <input NAME="phone" SIZE="10" value="#form.txtphone#" type="hidden">

	  	  <input NAME="catid2" SIZE="10" value="#form.catid2#" type="hidden">	  <input NAME="catid3" SIZE="10" value="#form.catid3#" type="hidden">	  <input NAME="catid4" SIZE="10" value="#form.catid4#" type="hidden">
	  <input NAME="website" SIZE="10" value="#form.website#" type="hidden">
	  	  <input NAME="alist" SIZE="10" value="#form.alist#" type="hidden">
  <input NAME="datestart" SIZE="50" value="#form.datestart#" type="hidden">
  <input NAME="dateend" SIZE="50" value="#form.dateend#" type="hidden">
    <input NAME="catid" SIZE="50" value="#form.catid#" type="hidden">
<input name="descriptiona" value="#form.descriptiona#" type="hidden">
<input name="shortdescription" value="#form.shortdescription#" type="hidden">
	  <input NAME="name" value="#form.name#" type="hidden">
  	  <input NAME="activityname" value="#form.activityname#" type="hidden">
  	  <input NAME="isweekend" value="#form.isweekend#" type="hidden">


	  <input NAME="contactfirst" SIZE="10" value="#form.contactfirst#" type="hidden">
	  <input NAME="contactlast" SIZE="10" value="#form.contactlast#" type="hidden">
  <input NAME="contacttitle" SIZE="50" value="#form.contacttitle#" type="hidden">
  <input NAME="contactphone" SIZE="50" value="#form.contactphone#" type="hidden">
    <input NAME="contactemail" SIZE="50" value="#form.contactemail#" type="hidden">
    <input NAME="mainpage" SIZE="50" value="#form.mainpage#" type="hidden">
<input name="form.updateall" type="hidden" value="#form.updateall#">

	    <input NAME="hours" SIZE="50" value="#form.hours#" type="hidden">
	    <input NAME="age1" SIZE="50" value="#form.age1#" type="hidden">
        	    <input NAME="age2" SIZE="50" value="#form.age2#" type="hidden">
                	    <input NAME="age3" SIZE="50" value="#form.age3#" type="hidden">
                        	    <input NAME="age4" SIZE="50" value="#form.age4#" type="hidden">
                                	    <input NAME="age5" SIZE="50" value="#form.age5#" type="hidden">
                                        	    <input NAME="age6" SIZE="50" value="#form.age6#" type="hidden">

<input name="onlineonly" type="hidden" value="#form.onlineonly#">
<input name="registrationrequired" type="hidden" value="#form.registrationrequired#">
<input name="daysofweek" type="hidden" value="#form.daysofweek#">
	    <input NAME="price1" SIZE="50" value="#form.price1#" type="hidden">
        	    <input NAME="price2" SIZE="50" value="#form.price2#" type="hidden">
                	    <input NAME="price3" SIZE="50" value="#form.price3#" type="hidden">
                        	    <input NAME="price4" SIZE="50" value="#form.price4#" type="hidden">
                                	    <input NAME="price5" SIZE="50" value="#form.price5#" type="hidden">
                                        	    <input NAME="price6" SIZE="50" value="#form.price6#" type="hidden">





<input name="hotticketregion" type="hidden" value="#form.hotticketregion#">

<input name="starthours" type="hidden" value="#form.starthours#">
<input name="startminutes"  type="hidden" value="#form.startminutes#">
<input name="starttt"  type="hidden" value="#form.starttt#">
<input name="endhours"  type="hidden" value="#form.endhours#">
<input name="endminutes"  type="hidden" value="#form.endminutes#" >
<input name="endtt"  type="hidden" value="#form.endtt#" >
 </cfoutput>

<table>
<tr><td valign=top><font face=verdana size=-1><strong> Event Images:</strong><Br>
<cfquery name="getrelated" dataSource="#ds#">
	select thumbnail,photo,id from ActivityPlanner
where name = '#form.name#' and photo <> ''
order by id DESC
limit 0,5
</cfquery>

<Cfoutput query="getrelated">
<cftry>

<input type="Radio" name="usepic" value="#id#"><br>
<a href="Http://www.nymetroparents.com/eventpic/#getrelated.photo#" target="_new"><img src="Http://www.nymetroparents.com/eventpic/#getrelated.thumbnail#" width="150"></a>
<br>

<cfif fileexists('/home/home2/domains/parentsknow.com/public_html/eventpic/#getrelated.photo#')>
<cfset cfImage = imageNew('/home/home2/domains/parentsknow.com/public_html/eventpic/#getrelated.photo#')>
<cfset imageData = imageInfo(cfImage)>
#imagedata.width# x #imagedata.height#
</cfif>
<cfcatch></cfcatch>
</cftry>

</Cfoutput>


	 </font></td><td>

<input type=file name="crop">
<script src="https://newimages.bwwstatic.com/2017/resizephoto0403b.js" ></script>



	 </td></tr>

   <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Use Picture:</font></b>
  </td><td>
<select name="usepicprint">
<option value="2">Online Only</option>
<option value="0">No</option>
<option value="1">Print & Online</option>
<option value="3">Print Only</option>
</select>

  </td></tr>

</table>

<INPUT TYPE="button" VALUE="Edit Listing" onClick="history.go(-1);return true;"> <input type="submit" Value="Add Listing">
</form>

</td></tr>
 </table><br><Br>
<center></center>


</cfif>

   </div>   </div>

<!--Footer-part-->
<br><br><br><br>

<cfinclude template="footer.cfm">