<cfinclude template="header.cfm">


<div id="content">
  <div id="content-header">
  </div>
  <div class="container-fluid" style="margin-left:300px;"><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>
<Cfif parameterexists(url.id)>
<cfquery name="getcolumn" datasource="#ds#">
select *
from ActivityPlannerVenuesupwork
where id = #url.id#
</cfquery></Cfif>
<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 class="table color-table inverse-table table-hover table-striped">

  <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Venue Name:</font></b>   </td><td colspan="8">
	  <input NAME="venuename" SIZE="50" value="#getcolumn.venuename#" required>
  </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">Region:</font></b>
  </td><td colspan="8">
<SELECT  name="region" >
<option value='#getcolumn.region#'>#getcolumn.region#
<option value="Westchester">Westchester County / Bronx</option>
<option value="Rockland">Rockland County</option>
<option value="Bergen">Bergen County</option>
<option value="Brooklyn">Brooklyn</option>
<option value="Staten Island">Staten Island</option>
<option value="Queens">Queens</option>
<option value="Fairfield">Fairfield</option>

<option value="Manhattan">Manhattan</option>
<option value="Nassau">Nassau County</option>
<option value="Suffolk">Suffolk County</option>
 </select>  </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>


<cfquery name="Geter" dataSource="#ds#">
	select distinct ActivityPlannerVenuesContactsuw.name,ActivityPlannerVenuesContactsuw.* from ActivityPlannerVenuesContactsuw
	where venueid = #url.id#
	group by name
	order by name desc
	limit 0,3
</cfquery>

<Cfif #geter.recordcount# eq 0>
<cfquery name=addphoto datasource="cityguide">
INSERT INTO ActivityPlannerVenuesContactsuw (venueid)
VALUES	(#url.id#)
</cfquery>
<cfquery name="Geter" dataSource="#ds#">
	select distinct ActivityPlannerVenuesContactsuw.name,ActivityPlannerVenuesContactsuw.* from ActivityPlannerVenuesContactsuw
	where venueid = #url.id#
	group by name
	order by name desc
		limit 0,3

</cfquery>
</Cfif>

<cfquery name="checker" dataSource="#ds#">
	select * from ActivityPlannerVenuesContactsuw
	where venueid = #url.id#
    and name = ''
</cfquery>
<Cfif #checker.recordcount# eq 0>
<cfquery name=addphoto datasource="cityguide">
INSERT INTO ActivityPlannerVenuesContactsuw (venueid)
VALUES	(#url.id#)
</cfquery>
<cfquery name="Geter" dataSource="#ds#">
	select distinct ActivityPlannerVenuesContactsuw.name,ActivityPlannerVenuesContactsuw.* from ActivityPlannerVenuesContactsuw
	where venueid = #url.id#
	group by name
	order by name desc
		limit 0,3

</cfquery>
</Cfif>


	<tr><td valign=top><font face=verdana size=-1><strong>Contact Info for the Venue [Private]:</strong> </font></td><td valign="top" colspan="2">
	<INPUT TYPE = "hidden" NAME = "NumRecords" VALUE = "#Geter.RecordCount#">

<table>
<cfloop from="1" to="#geter.recordcount#" index="i">

	<cfif #geter.name[i]# eq ''><cfset blank='on'></cfif>
<INPUT TYPE = "hidden" NAME = "ID#i#" VALUE = "#geter.id[i]#">
<Tr><Td><b><font SIZE="-1" FACE="verdana">Name:</font></b></Td><Td><input NAME="contactname#i#" SIZE="30" value="#geter.name[i]#"></Td></Tr>
<Tr><Td><b><font SIZE="-1" FACE="verdana">Title:</font></b></Td><Td><input NAME="contacttitle#i#" SIZE="30" value="#geter.title[i]#"></Td></Tr>
<Tr><Td><b><font SIZE="-1" FACE="verdana">Email:</font></b></Td><Td><input NAME="contactemail#i#" SIZE="30" value="#geter.email[i]#"></Td></Tr>
<Tr><Td><b><font SIZE="-1" FACE="verdana">Phone:</font></b></Td><Td><input NAME="contactphone#i#" SIZE="30" value="#geter.phone[i]#"></Td></Tr>
<Tr><Td><b><font SIZE="-1" FACE="verdana">Comment:</font></b></Td><Td><textarea NAME="contactcomment#i#" rows="5" cols="30">#geter.comment[i]#</textarea></Td></Tr>
</cfloop>
</table>

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


    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Standard Hours:</font></b>
  </td><td colspan="8">
	  <input NAME="Hours" SIZE="30" value="#getcolumn.Hours#" >
	  <br><small>Follow this format: <br>Monday-Friday, 10am-8pm; Saturday-Sunday, 12-5pm</small>
  </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">Standard Admission: <br></b><small>Follow this format: $12; $10 seniors; $8 children ages 2-12; free for children younger than 2</small></b>
<br>
<Table>
<Tr><Td><font SIZE="-1" FACE="verdana"><B>Standard:</B></Td><TD><input class="form-control" value="#adultprice#" name="adultprice" ></TD></Tr>
<Tr><Td><font SIZE="-1" FACE="verdana"><B>Members:</B></Td><TD><input value="#childrenprice#" name="childrenprice" ></TD></Tr>
<Tr><Td><font SIZE="-1" FACE="verdana"><B>Group:</B></Td><TD><input  value="#seniorsprice#" name="seniorsprice" ></TD></Tr>
<Tr><Td><font SIZE="-1" FACE="verdana"><B>Other:</B></Td><TD><input type="text" 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 public transportation stop:</font></b>
  </td><td colspan="8"> <font SIZE="-2" FACE="verdana">
Follow this format: Stop name; 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 stroller with you to seat or throughout experience?</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">Where is food allowed?</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">Changing tables in the unisex bathroom(s)?</font></b>
<Br>
	  <select name="changingunisex">
<option value="#getcolumn.changingunisex#">#getcolumn.changingunisex#</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>



  </cfoutput></table>
<center><b><input type="submit" Value="Update & Back to Admin">
<input type="submit" Value="Update & Stay on Entry" name="buttadminman">


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