<cfcontent type="text/html;charset=iso-8859-1">
<cfprocessingDirective pageencoding="iso-8859-1">
<cfset setEncoding("Form", "ISO-8859-15")>
<cfinclude template="header.cfm">


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


<cfif parameterexists(url.removepic)>

	<cfquery name="upds" dataSource="#ds#">
		update ActivityPlanner
		set photo = '', thumbnail = ''
		where id = #url.id#
</cfquery>
</cfif>


<cfparam name="url.general" default="off">


<cfif DirectoryExists('/home/home2/cgny/public_html/uploads2/#url.id#')>

<cfelse>

   <cfdirectory action = "create" directory = "/home/home2/cgny/public_html/uploads2/#url.id#" mode="777" >
</cfif>


<cfsetting
    requestTimeOut = "5000"
    >



<cfif parameterexists(getuser.id) and parameterexists(url.id) and isnumeric(url.id)>



<cfquery name="Getcat" datasource="cg22">
SELECT *
FROM ActivityPlanner
where id = '#url.id#'
</cfquery>

<table width=100%><tr><td><cfoutput>
<div align="center"><font face=verdana size=+1><strong>Edit #getcat.name#</strong></font>
<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>
<cfoutput>
<!---
<a href="uploadcalendarphoto.cfm?itemid=#url.id#">Manage Photos</a> | ---><a href="delplanner.cfm?id=#url.id#" onclick="return confirm('Really delete?');">Delete Entry</a>

</cfoutput>

<cfif parameterexists(url.hideme)>
<h1 style="color:red;">Entry Now Hidden from Print Export</h1>
</cfif>

<p></cfoutput>
<cfFORM action="editcalendar2.cfm?requesttimeout=50000" method="post" name="MyForm" enctype="multipart/form-data">
  <br><cfoutput query="getcat">
	  <cfif #addedby# is not ''>
		    <strong>Posted by: </strong> #addedby# on #dateformat(addedon,'m/d/yyyy')#

	  </cfif>
  <Cfif #updatedby# is not ''>
  <strong>Updated by: </strong> #updatedby# on #dateformat(updatedon,'m/d/yyyy')# @ #timeformat(updatedon,'h:mm:tt')#
  <p></Cfif>

	  <cfquery name="getviews" dataSource="#ds#">
		  select count(id)  as counter  from newmastertrackeventscg
		  where  idnumber = #getcat.id#
	 </cfquery>

	 	  <cfquery name="getcliecks" dataSource="#ds#">
		  select sum(views)  as counter  from CalendarLinkStats
		  where  showid = #getcat.id#
	 </cfquery>
	 
	 	 	  <cfquery name="getcliecks2" dataSource="#ds#">
		  select sum(views)  as counter  from CalendarLinkStatsBuy
		  where  showid = #getcat.id#
	 </cfquery>

<a href="https://2019.cityguideny.com/event/#getcat.seo_friendly#" target=+new>#getviews.counter# Views</a>

 | #getcliecks.counter# Clicks  | #getcliecks2.counter# Buy | <a href="editcalendarreport.cfm?id=#url.id#">Report</a>
<p>

  <input  type="hidden" name="id" value="#getcat.id#">
<table class="table color-table inverse-table table-hover table-striped">


	  <input name="cg" type="hidden" value="on">


  <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Venue Name:</font></b>
  </td><td>
	  <input NAME="name" SIZE="65" value="#getcat.Name#">
  </td></tr>
    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Event Name:</font></b>
  </td><td>
   <cfset TValue = Evaluate("getcat.activityname")>
<cfset TValue = rereplace(TValue, '"','''', "ALL")>

	  <input NAME="activityname" SIZE="65" value="#tvalue#">
  </td></tr>

</cfoutput>

<cfif #currentdatetime# gt '2022-04-27'>
<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Article Intent Embed:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><Small>
    <Cfoutput><textarea style="width:100%;height:100px;"><iframe src="https://www.cityguideny.com/intendembed-calendar.cfm?id=#url.id#&table=Calendar" width="100%" height="280" style="height:280px;" frameborder="0"></iframe></Cfoutput>
</textarea>


<cfquery name="getint" dataSource="#ds#">
    select rating, count(rating) as countrating from ActivityPlannerRatings where calendarid = #url.id#  group by rating
</cfquery>
<cfoutput query="getint">


    
   <Cfif #rating# eq 1>I intend to go<cfelseif #rating# eq 2>Not Sure<cfelse>Not for Me</Cfif> - #countrating#<br>
</cfoutput>

</Small></td>
</tr>
</cfif>
<Cfoutput query='getcat'>

    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Address:</font></b>
  </td><td>
	  <input NAME="address" SIZE="65" value="#getcat.address#">
  </td></tr>

   <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Cross Streets:</font></b>
  </td><td>
	  <input NAME="address2" SIZE="65" value="#getcat.address2#">
  </td></tr>

    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Zip:</font></b>
  </td><td>
	  <cfinput NAME="zip" SIZE="5" value="#getcat.zip#" required="no" message="Zip code required">

  </td></tr>




    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">City:</font></b>
  </td><td>
	  <input NAME="City" SIZE="65" <Cfif #getcat.city# eq '' and parameterexists(zipcheck.recordcount) and #zipcheck.recordcount# gt 0>value="#zipcheck.city#"<cfelse>value="#getcat.city#"</Cfif>>
  </td></tr>

    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">State:</font></b>
  </td><td>
	  <select name="state">
		 <Cfif #getcat.city# eq '' and parameterexists(zipcheck.recordcount) and #zipcheck.recordcount# gt 0>

				<option value="#stateme#">#stateme#</option>

		 </Cfif>
	<option value="#getcat.state#">#getcat.state#</option>
	<option value="NY">NY</option>
	<option value="NJ">NJ</option>
	<option value="CT">CT</option>
	  </select>

  </td></tr>

 <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Website:</font></b>
  </td><td>
	  <input NAME="website" SIZE="65" value="#getcat.website#">
  </td></tr>



 <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Buy Tickets:</font></b>
  </td><td>
	  <input NAME="buytickets" SIZE="65" value="#getcat.buytickets#">
  </td></tr>


    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Phone:</font></b>
  </td><td>
  	  <cfinput NAME="Phone" SIZE="12" value="#getcat.Phone#"   message = "Enter telephone number,formatted xxx-xxx-xxxx (e.g. 617-761-2000)"
   validate = "telephone" required = "No">


  	  x<cfinput NAME="Phonex" SIZE="4" value="#getcat.Phonex#"  >

  </td></tr>



 <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Price:</font></b>
  </td><td>

<Table>

<tr><Td></td><td>Free <input NAME="age6" SIZE="10" type="checkbox" <Cfif #getcat.age6# eq 'On'>checked</cfif>>
<p>
	OR	<p>  <input NAME="Price" SIZE="65" value="#getcat.Price#">

<p>
			  <Small>Follow this format: $12; $10 seniors; $8 children ages 2-12; free for children younger than 2


</td><td> </td></tr>
<!---
<tr><Td>Children</td><td><input NAME="age1" SIZE="10" value="#getcat.age1#"></td><td> $<input NAME="price1" SIZE="10" value="#getcat.price1#"></td></tr>
<tr><Td>Students</td><td><input NAME="age2" SIZE="10" value="#getcat.age2#"></td><td> $<input NAME="price2" SIZE="10" value="#getcat.price2#"></td></tr>
<tr><Td>Adults</td><td><input NAME="age3" SIZE="10" value="#getcat.age3#"></td><td> $<input NAME="price3" SIZE="10" value="#getcat.price3#"></td></tr>
<tr><Td>Seniors</td><td><input NAME="age4" SIZE="10" value="#getcat.age4#"></td><td> $<input NAME="price4" SIZE="10" value="#getcat.price4#"></td></tr>
<tr><Td>All Ages</td><td><input NAME="age5" SIZE="10" value="#getcat.age5#"></td><td> $<input NAME="price5" SIZE="10" value="#getcat.price5#"></td></tr>
--->
  </table></td></tr>


  <tr>
  <td>
  <b><font SIZE="-1" FACE="verdana" >Start Date:</font></b>
  </td><td>

    <cf_calendar form="MyForm" name="datestart" calendardir="." value="#getcat.datestart#" FORMAT="DD-MMM-YY">
  </td></tr>


  <tr>
  <td>
  <b><font SIZE="-1" FACE="verdana" >End Date:</font></b>
  </td><td>

  <cf_calendar form="MyForm" name="dateend" calendardir="." value="#getcat.dateend#" FORMAT="DD-MMM-YY">
  </td></tr>
<!---

    <tr>
  <td>
  <b><font SIZE="-1" FACE="verdana" >Special Date Instructions:</font></b>
  </td><td>
  <input NAME="specialdate" SIZE="50" value="#getcat.specialdate#">
  </td></tr>

  <tr><Td valign="top">  <b><font SIZE="-1" FACE="verdana" >
  Dates to Skip:<br />
  Format: yyyy-mm-dd
  </Td><td valign="top">
  <input name="skipdate1"  <Cfif #getcat.skipdate1# is not '1900-01-01'>value="#getcat.skipdate1#"</cfif>><br />

    <input name="skipdate2"  <Cfif #getcat.skipdate2# is not '1900-01-01'>value="#getcat.skipdate2#"</cfif>><br />

	    <input name="skipdate3"  <Cfif #getcat.skipdate3# is not '1900-01-01'>value="#getcat.skipdate3#"</cfif>><br />

		    <input name="skipdate4"  <Cfif #getcat.skipdate4# is not '1900-01-01'>value="#getcat.skipdate4#"</cfif>><br />

    <input name="skipdate5"  <Cfif #getcat.skipdate5# is not '1900-01-01'>value="#getcat.skipdate5#"</cfif>><br />


    <input name="skipdate6"  <Cfif #getcat.skipdate6# is not '1900-01-01'>value="#getcat.skipdate6#"</cfif>><br />


	    <input name="skipdate7"  <Cfif #getcat.skipdate7# is not '1900-01-01'>value="#getcat.skipdate7#"</cfif>><br />


    <input name="skipdate8"  <Cfif #getcat.skipdate8# is not '1900-01-01'>value="#getcat.skipdate8#"</cfif>><br />

    <input name="skipdate9"  <Cfif #getcat.skipdate9# is not '1900-01-01'>value="#getcat.skipdate9#"</cfif>><br />

    <input name="skipdate10"  <Cfif #getcat.skipdate10# is not '1900-01-01'>value="#getcat.skipdate10#"</cfif>><br />
  </Td></tr>


   <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Hours:</font></b>
  </td><td>
  Start Time: <select name="starthours"><option value="#getcat.starthours#">#getcat.starthours#<cfloop from="1" to="12" index="i"><option value="#i#">#i#</cfloop></select>
  <select name="startminutes"><option value="#getcat.startminutes#">#getcat.startminutes#<cfloop from="0" to="59" index="i"><option value="#i#">#i#</cfloop></select>
  <select name="starttt"><option value="#getcat.starttt#">#getcat.starttt#<option value="am">am<option value="pm">pm</select>
  </td></tr>
   --->

   <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Time:</font></b>
  </td><td>
	  <input NAME="hours" SIZE="65" value="#getcat.Hours#">
  </td></tr>



   <tr><td>
	  <b><font SIZE="-1" FACE="verdana">NYMP Sponsored event:</font></b>
  </td><td>
<select name="mainpage">
<cfif #getcat.mainpage# eq 2>
<option value="2">Main Page + Newsletter
<cfelseif #getcat.mainpage# eq 3>
<option value="3">Main Page - Sponsor
<cfelseif #getcat.mainpage# eq 4>
<option value="4">Main Page - Non Sponsor
<cfelse>
<option value="0">No

</cfif><option value="4">Main Page - Non Sponsor
<option value="3">Main Page - Sponsor
<option value="0">No


</select>

  </td></tr>



	 <!---   <tr>
      <td colspan=2 align="left" valign="top">
<font SIZE="-1" FACE="verdana" ><b>Thumbnail:</b></font><br>
	  <input NAME="thumbnail" SIZE="65" value="#getcat.thumbnail#">
<iframe src="articleimage.cfm?id=<Cfoutput>#url.id#</cfoutput>" style="width:600px;" scrolling=yes height=100></iframe>

      </td>
    </tr>
--->
</cfoutput>




<cfquery name="Getcats" datasource="cg22">
SELECT cat,catid,mastercat
FROM CatActivityPlanner
where mag = 1
                    and hide <> 1
                    and catid > 150
                    </cfquery>




<cfquery name="Getcata" datasource="cg22">
SELECT cat,catid,mastercat
FROM CatActivityPlanner
where catid = #getcat.catid#
</cfquery>

<cfquery name="Getcatb" datasource="cg22">
SELECT cat,catid,mastercat
FROM CatActivityPlanner
where catid = #getcat.catid2#
</cfquery>
<cfquery name="Getcatc" datasource="cg22">
SELECT cat,catid
FROM CatActivityPlanner
where catid = #getcat.catid3#
</cfquery>

<cfquery name="Getcatd" datasource="cg22">
SELECT cat,catid
FROM CatActivityPlanner
where catid = #getcat.catid4#
</cfquery>

   <tr>
	  <td>
	  <b><font SIZE="-1" FACE="verdana" >CG Category 1:</font></b>
	  </td>
	  <td>

	    <select NAME="catid" size="1">     <cfif #getcata.recordcount# eq 0>		     <option value="0">None</option></cfif>
		<cfoutput><option value="#getcata.catid#"><!---#getcata.mastercat# --->#getcata.Cat#</option></cfoutput>

	  <cfoutput query="getcats">
        <option value="#catid#"><!---#mastercat# - --->#Cat#</option>
					</cfoutput>


		</select>

	  </td>
  </tr>


   <tr>
	  <td>
	  <b><font SIZE="-1" FACE="verdana" >CG Category 2:</font></b>
	  </td>
	  <td>

	    <select NAME="catid2" size="1">
		<cfoutput>
        <cfif #getcatb.recordcount# eq 0>		     <option value="0">None</option></cfif>
        <option value="#getcatb.catid#">#getcatb.mastercat# - #getcatb.Cat#</option></cfoutput>
		     <option value="0">None</option>
	  <cfoutput query="getcats">
        <option value="#catid#">#mastercat# - #Cat#</option>
					</cfoutput>

		</select>

	  </td>
  </tr>

   <tr>
	  <td>
	  <b><font SIZE="-1" FACE="verdana" >CG Priority:</font></b>
	  </td>
	  <td>

	    <select NAME="cgpriority" size="1">

<Cfif #getcat.cgpriority# eq 1>
			     <option value="1">Regular</option>


</Cfif>

<Cfif #getcat.cgpriority# eq 2>

			     <option value="2">Priority</option>

</Cfif>

<Cfif #getcat.cgpriority# eq 0>

			     <option value="0">Back of the Line</option>

</Cfif>


		     <option value="2">Priority</option>

		     <option value="1">Regular</option>
		     <option value="0">Back of the Line</option>


		</select>

	  </td>
  </tr>

<cfoutput>

   <cfcookie name = "folderme"
    value = "#Now()#"
    expires = "NOW">

<cfcookie name = "folderme" value = "/uploads2/#url.id#/">
<Cfparam name="url.beta" default="on">


   <cfcookie name = "folderme"
    value = "#Now()#"
    expires = "NOW">

<cfcookie name = "folderme" value = "/uploads2/#url.id#/">
<Cfparam name="url.beta" default="on">


	<script src="ckeditor46z27e/ckeditor.js?asd2" charset="utf-8"></script>

<script type="text/javascript" src="ckfinder3511a/ckfinder.js?as441" charset="utf-8"></script>


	    <tr>
      <td colspan=2 align="left" valign="top">
<font SIZE="-1" FACE="verdana" ><b>Full Description for Online Calendar:</b></font><br>


        <textarea name="enhanceddescription" cols="65" rows="10"  wrap="VIRTUAL">#htmleditformat(getcat.enhanceddescription)#</textarea>
<script type="text/javascript">

CKEDITOR.on( 'dialogDefinition', function( ev ) {
                                // Take the dialog name and its definition from the event data.
                                var dialogName = ev.data.name;
                                var dialogDefinition = ev.data.definition;
                                // Check if the definition is from the dialog we're interested on (the "Link" dialog).
                                if ( dialogName == 'link' ){
                                        var targetTab = dialogDefinition.getContents( 'target' );
                                        var targetDropdown = targetTab.get( 'linkTargetType' );
                                        targetDropdown.default = '_blank';
                                }
                        }       );



CKFinder.setupCKEditor( editor, 'ckfinder34/' ) ;


var editor = CKEDITOR.replace( 'enhanceddescription',{
   height: '500px',
   extraAllowedContent : 'object(*);param(*);embed(*);p(*);script(*);form(*);input(*);div(*);blockquote(*)'
});


editor.on( 'instanceReady', function() {
console.log( editor.filter.allowedContent );
} );
</script>





      </td>
    </tr>



	    <tr>
      <td colspan=2 align="left" valign="top">
<font SIZE="-1" FACE="verdana" ><b>Text Description for Online Calendar:</b></font><br>

	        <textarea name="description" cols="65" rows="5"  wrap="VIRTUAL">#htmleditformat(getcat.description)#</textarea>






      </td>
    </tr>



	    <tr>
      <td colspan=2 align="left" valign="top">
<font SIZE="-1" FACE="verdana" ><b>Short Description for Print Calendar:</b></font><br>


        <textarea name="shortdescription" cols="60" rows="10"  wrap="VIRTUAL">#getcat.shortdescription#</textarea>
 <script>
	CKEDITOR.removeButtons = 'Bold,About';

            CKEDITOR.replace( 'shortdescription' );

        </script>
      </td>
    </tr>


    </cfoutput>


 </table>


	 </font></td>
	 
	   <tr><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">
<cfif #getcat.usepicprint# eq 0>
<option value="0">No</option>

<Cfelseif #getcat.usepicprint# eq 2>
<option value="2">Online Only</option>

<Cfelseif #getcat.usepicprint# eq 1>
<option value="1">Print & Online</option>

<Cfelseif #getcat.usepicprint# eq 3>
<option value="3">Print Only</option>

</cfif>
<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>

<cfoutput>




	 <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Contact First Name [Private]:</font></b>
  </td><td>
	  <input NAME="contactfirst" SIZE="10" value="#getcat.contactfirst#">
  </td></tr>

	    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Contact Last Name:</font></b>
  </td><td>
	  <input NAME="contactlast" SIZE="15" value="#getcat.contactlast#">
  </td></tr>

      <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Contact Title:</font></b>
  </td><td>
	  <input NAME="contactitle" SIZE="15" value="#getcat.contactitle#">
  </td></tr>

      <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Contact Phone Number:</font></b>
  </td><td>
	  <input NAME="contactphone" SIZE="15" value="#getcat.contactphone#">
  </td></tr>

      <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Contact E-Mail:</font></b>
  </td><td>
	  <input NAME="contactemail" SIZE="15" value="#getcat.contactemail#">
  </td></tr>
	</cfoutput> </table><br>
<center>
<input name="entry" type="submit" Value="Update and Return to Entry">

<input name="admin" type="submit" Value="Update and Return to Admin">
<input name="buttlisting" type="submit" Value="Update and Go to Online Listing ">
</center>
</cfform>

</td></tr></table>
</cfif>


   </div>
<!--Footer-part-->
<br><br><br><br>

<cfinclude template="footer.cfm">