<cfinclude template="header.cfm">


<div id="content">
  <div id="content-header">
  </div>
  <div class="container-fluid"><cfif parameterexists(Session.email) and (Session.email IS NOT -1) and (#getuser.accesslevel# eq 100)>
<cfquery name="getcolumn" datasource="#ds#">
select *
from ActivityPlannerVenuesupwork
where id = #url.id#
</cfquery>
<table width=600><tr><td>
<div align="center"><font face=verdana size=+1><strong>Edit Venue</strong></font>
<br>
<a href="#recentevents">Show Recent Events</a> | <a href="deletevenue.cfm?id=<Cfoutput>#url.id#</Cfoutput>" onclick="return confirm('Are you sure?');">Delete Venue


</a>
<cfoutput>
<FORM action="editvenue2upwork.cfm" method=post enctype="multipart/form-data" >
</cfoutput>
  <br>
<cfoutput query="Getcolumn" maxrows = 1>


	 <input NAME="ID" SIZE="70" value="#getcolumn.id#" type="hidden">

   <table cellspacing=5 cellpadding=5 border="1">

  <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Venue Name:</font></b>
  </td><td colspan="8">
	  <input NAME="venuename" SIZE="50" value="#getcolumn.venuename#">
  </td></tr>


    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Website:</font></b>
  </td><td colspan="8">
	  <input NAME="website" SIZE="50" value="#getcolumn.website#">
  </td></tr>

	    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Address:</font></b>
  </td><td colspan="8">
	  <input NAME="Address" SIZE="50" value="#getcolumn.Address#">
  </td></tr>
    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">City:</font></b>
  </td><td colspan="8">
	  <input NAME="City" SIZE="30" value="#getcolumn.City#">
  </td></tr>
    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">State:</font></b>
  </td><td colspan="8">
	  <input NAME="State" SIZE="5" value="#getcolumn.State#">
  </td></tr>    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Zip:</font></b>
  </td><td colspan="8">
	  <input NAME="Zip" SIZE="10" value="#getcolumn.Zip#">
  </td></tr>
    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Phone:</font></b>
  </td><td colspan="8">
	  <input NAME="Phone" SIZE="30" value="#getcolumn.Phone#"> x<input NAME="phoneextension" SIZE="4" value="#getcolumn.phoneextension#">
  </td></tr>

    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Hours:</font></b>
  </td><td colspan="8">
	  <input NAME="Hours" SIZE="30" value="#getcolumn.Hours#">
  </td></tr>

 <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Facebook:</font></b>
  </td><td colspan="8">
	  <input NAME="Facebook" SIZE="25" value="#getcolumn.Facebook#">
  </td></tr>

<tr><td>
	  <b><font SIZE="-1" FACE="verdana">Twitter:</font></b>
  </td><td colspan="8">
	  <input NAME="Twitter" SIZE="25" value="#getcolumn.Twitter#">
  </td></tr>

 <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Instagram:</font></b>
  </td><td colspan="8">
	  <input NAME="Instagram" SIZE="25" value="#getcolumn.Instagram#">
  </td></tr>

 <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Pinterest:</font></b>
  </td><td colspan="8">
	  <input NAME="Pinterest" SIZE="25" value="#getcolumn.Pinterest#">
  </td></tr>


  <tr><td>
	  <b><font SIZE="-1" FACE="verdana">A-List:</font></b>
  </td><td colspan="8">
	  <font SIZE="-1" FACE="verdana">
	  <input type="checkbox" name="alistmanhattan" <cfif #getcolumn.alistmanhattan# eq 1>checked</cfif>> Manhattan

	  <input type="checkbox" name="alistbrooklyn" <cfif #getcolumn.alistbrooklyn# eq 1>checked</cfif>> Brooklyn

	  <input type="checkbox" name="alistqueens" <cfif #getcolumn.alistqueens# eq 1>checked</cfif>> Queens
<Br>

	  <input type="checkbox" name="alistwestchester" <cfif #getcolumn.alistwestchester# eq 1>checked</cfif>> Westchester

	  <input type="checkbox" name="alistbronx" <cfif #getcolumn.alistbronx# eq 1>checked</cfif>> Bronx
	  <input type="checkbox" name="alistrockland" <cfif #getcolumn.alistrockland# eq 1>checked</cfif>> Rockland
	  <input type="checkbox" name="aliststatenisland" <cfif #getcolumn.aliststatenisland# eq 1>checked</cfif>> Staten Island
	  <input type="checkbox" name="alistessex" <cfif #getcolumn.alistessex# eq 1>checked</cfif>> Essex

	  <input type="checkbox" name="alistfairfield" <cfif #getcolumn.alistfairfield# eq 1>checked</cfif>> Fairfield
	  <input type="checkbox" name="alistbergen" <cfif #getcolumn.alistbergen# eq 1>checked</cfif>> Bergen<br>
	  <input type="checkbox" name="alistnassau" <cfif #getcolumn.alistnassau# eq 1>checked</cfif>> Nassau
	  <input type="checkbox" name="alistsuffolk" <cfif #getcolumn.alistsuffolk# eq 1>checked</cfif>> Suffolk

  </td></tr>

    <script src="//cdn.ckeditor.com/4.5.7/basic/ckeditor.js"></script>

     <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Venue<br>Description:</font></b>
  </td><td colspan="8">
	  <textarea name="description" style="width:100%;height:100px;" wrap="VIRTUAL" placeholder="Venue Description">#getcolumn.description#</textarea>
  </td></tr>


               <script>
            CKEDITOR.replace( 'description' );
        </script>

<tr><td colspan="3">
	  <b><font SIZE="-1" FACE="verdana">Admission: Follow this format: $12; $10 seniors; $8 children ages 2-12; free for children younger than 2</font></b>
<br>
<Table>
<Tr><Td><font SIZE="-1" FACE="verdana"><B>Standard:</B></Td><TD><input type="number" step="any" min="0" class="form-control" value="#adultprice#" name="adultprice" ></TD></Tr>
<Tr><Td><font SIZE="-1" FACE="verdana"><B>Members:</B></Td><TD><input type="number" step="any" min="0" class="form-control" value="#childrenprice#" name="childrenprice" ></TD></Tr>
<Tr><Td><font SIZE="-1" FACE="verdana"><B>Group:</B></Td><TD><input type="number" step="any" min="0" class="form-control" value="#seniorsprice#" name="seniorsprice" ></TD></Tr>
<Tr><Td><font SIZE="-1" FACE="verdana"><B>Other:</B></Td><TD><input type="text"  class="form-control" value="#otherprice#" name="otherprice" ></TD></Tr>

</Table>





</td></tr>


<Tr><td colspan="3">
		  <p>

	  <b><font SIZE="-1" FACE="verdana">Parking?</font></b>
<br>
<select name="parking">
<option value="#getcolumn.parking#">#getcolumn.parking#</option>
<option value="Free">Free</option>
<option value="Paid">Paid</option>
<option value="Street Parking">Street Parking</option>

	  </select>

</p></Td></Tr>

 <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Nearest subway stop:</font></b>
  </td><td colspan="8"> <font SIZE="-2" FACE="verdana">
Follow this format: Subway stop; lines (exp. 23 Street Station; N, Q, R, W)
	  <input NAME="Nearestsubway" SIZE="25" value="#getcolumn.Nearestsubway#">
  </td></tr>


<Tr><td colspan="3">
		  <p>

	  <b><font SIZE="-1" FACE="verdana">Wheelchair accessible?</font></b>
<br>
<select name="handicap">
<option value="#getcolumn.handicap#">#getcolumn.handicap#</option>
<option value="Yes">Yes</option>
<option value="No">No</option>
<option value="Partially">Partially</option>

	  </select>

</p></Td></Tr>


<Tr><td colspan="3">
		  <p>

	  <b><font SIZE="-1" FACE="verdana">Play area?</font></b>
<br>
<select name="playarea">
<option value="#getcolumn.playarea#">#getcolumn.playarea#</option>
<option value="No">No</option>
<option value="Indoor">Indoor</option>
<option value="Outdoor">Outdoor</option>
<option value="Indoor and Outdoor">Indoor and Outdoor</option>


	  </select>

</p></Td></Tr>


 <tr><td colspan="3">
	  <b><font SIZE="-1" FACE="verdana">Party room?</font></b>
<br>	  <select name="partyroom">
<option value="#getcolumn.partyroom#">#getcolumn.partyroom#</option>
<option value="Yes">Yes</option>
<option value="No">No</option>

	  </select>
  </td>


</tr>

    <tr><td colspan="3">
	  <b><font SIZE="-1" FACE="verdana">Is there stroller parking?</font></b>
<br>	  <select name="strollerparking">
<option value="#getcolumn.strollerparking#">#getcolumn.strollerparking#</option>
<option value="Yes">Yes</option>
<option value="No">No</option>

	  </select>
  </td>


</tr><tr>
<td colspan="3">
	  <b><font SIZE="-1" FACE="verdana">Is there a stroller check?</font></b>
<Br>
	  <select name="strollercheck">
<option value="#getcolumn.strollercheck#">#getcolumn.strollercheck#</option>
<option value="Yes">Yes</option>
<option value="No">No</option>

	  </select>
  </td>
</tr><tr>


<td colspan="3">
	  <b><font SIZE="-1" FACE="verdana">Can you take a stroller throughout the experience, or must they be left in a designated spot?</font></b>
<br>
	  <select name="takestroller" style="width:100px;">
<option value="#getcolumn.takestroller#">#getcolumn.takestroller#</option>
<option value="Can Take With You">Can Take With You</option>
<option value="Can't Take With You">Can't Take With You</option>
<option value="Can Take, But Some Parts Are Off Limits to Strollers">Can Take, But Some Parts Are Off Limits to Strollers</option>

	  </select>
  </td>

  </tr>



 <tr><td colspan="3">

	  <b><font SIZE="-1" FACE="verdana">Can Patrons Bring Food?</font></b>
<br>	  <select name="bringfood">
<option value="#getcolumn.bringfood#">#getcolumn.bringfood#</option>
<option value="Yes">Yes</option>
<option value="No">No</option>

	  </select>
  </td>
</tr><tr>

  <td colspan="3">

	  <b><font SIZE="-1" FACE="verdana">Is there a place to buy food?</font></b>
<Br>
	  <select name="buyfood">
<option value="#getcolumn.buyfood#">#getcolumn.buyfood#</option>
<option value="Yes">Yes</option>
<option value="No">No</option>

	  </select>
  </td>

</tr><tr>

  <td colspan="3">

	  <b><font SIZE="-1" FACE="verdana">Is it a "no food allowed" venue?</font></b>
<br>
	  <select name="allowedfood">
<option value="#getcolumn.allowedfood#">#getcolumn.allowedfood#</option>
<option value="Food is allowed throughout">Food is allowed throughout</option>
<option value="food not allowed at all">food not allowed at all</option>
<option value="food allowed in designated spots">food allowed in designated spots</option>

	  </select>
  </td>

  </tr>



 <tr><td colspan="3">

	  <b><font SIZE="-1" FACE="verdana">Changing tables in the women's room(s)?</font></b>
<br>	  <select name="changingwomen">
<option value="#getcolumn.changingwomen#">#getcolumn.changingwomen#</option>
<option value="Yes">Yes</option>
<option value="No">No</option>

	  </select>

  </td>
</tr><tr>

  <td colspan="3">

	  <b><font SIZE="-1" FACE="verdana">Changing tables in the men's room(s)?</font></b>
<Br>
	  <select name="changingmen">
<option value="#getcolumn.changingmen#">#getcolumn.changingmen#</option>
<option value="Yes">Yes</option>
<option value="No">No</option>

	  </select>
  </td>
</tr><tr>


<td colspan="3">

	  <b><font SIZE="-1" FACE="verdana">Is there a family bathroom?</font></b>
<br>
<select name="changingfamily">
<option value="#getcolumn.changingfamily#">#getcolumn.changingfamily#</option>
<option value="Yes">Yes</option>
<option value="No">No</option>

	  </select>



	    </td>

  </tr>



	<tr><td valign=top><font face=verdana size=-1><strong>Image:</strong> </font></td><td valign="top">
		<input type=file name="crop">
<script src="https://newimages.bwwstatic.com/2017/resizephoto0403b.js" ></script>


			<Cfif #image# is not ''>
			</td><td>
	<a href="https://www.cityguideny.com/calendarphotos/#image#" target="_new"><img src="https://www.cityguideny.com/calendarphotos/#image#" style="float:right;max-width: 200px;"></a>
	</Cfif>


</td></tr>




  </cfoutput></table>
<center><b><input type="submit" Value="Update"></b></center>
</center><br>
</form>
</td></tr></table>
<hr>
<a name="recentevents"></a>
<cfoutput><font face=verdana size=+1><strong>Recent Events @ #getcolumn.venuename#</font></strong></cfoutput>


<p>
<Cfquery name="Getevents" Datasource="#ds#">
	select * from ActivityPlanner
	where name = '#getcolumn.venuename#'
	and nympregion <> ''
	order by dateend DESC
	limit 0,10
</cfquery>

<TAble width=100%>
<cfoutput query="getevents">
<Tr style="margin-bottom: 10px;"><td><CenteR><b><Br>
<font face=verdana size=-2>
<cfif parameterexists(getuser.accesslevel) and getuser.accesslevel eq 100><br /><a href="editcalendar.cfm?id=#id#" target="new">edit entry</a></cfif>

<cfif #updatedby# is not ''><p><strong>EDITED</strong></p></cfif>
</td><td><Br>
<font face=verdana size=-1>
<em><cfif #datediff('d',dateend,datestart)# eq 0>#dateformat(datestart,'mm/dd/yy')#<cfelse> #dateformat(datestart,'mm/dd/yy')#  through #dateformat (dateend,'mm/dd/yy')#</cfif> </em><br /><b><Cfif #activityname# is not '' and #activityname# is not '#name#'>#activityname#:</Cfif> #name#</b> <br />
#description# <br />
<CFIF #hours# is not ''>#hours#<br /></CFIF>
<cfif #address# is not ''>#address#<br /></cfif>
<cfif #address2# is not ''>#address2# <br />  </cfif>
<cfif #city# is not ''>#city# #state#  </cfif>
<cfif #zip# is not ''>#zip# <br />  </cfif>
<cfif #phone# is not ''>#phone#  <br /> </cfif>
<cfif #website# is not ''>#website#</a> <br></cfif>
<Cfif (#pk# eq 'on' or pkb eq 'on'
or pkq eq 'on' or pkw eq 'on' or pkr eq 'on') or parameterexists(url.mag) and #url.mag# eq 5>

<a href="http://www.nymetroparents.com/2015neweventinfo.cfm?id=#id#" target="_new">http://www.nymetroparents.com/2015neweventinfo.cfm?id=#id#</a></cfif>
<br>
</td></tr>
</cfoutput>
</table>

<p>
</td></tr></TABLE></td>

</td></tr></table>
</td></tr></table></body></html>

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

<cfinclude template="footer.cfm">