| Server IP : 104.21.21.239 / Your IP : 216.73.216.11 Web Server : Apache/2.4.68 (Amazon Linux) OpenSSL/3.5.5 System : Linux ip-172-31-69-123.ec2.internal 6.1.176-223.369.amzn2023.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Jul 24 13:34:27 UTC 2026 x86_64 User : ec2-user ( 1000) PHP Version : 8.4.23 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /home/home2/cgny/public_html/newadmin/ |
Upload File : |
<cfinclude template="header.cfm">
<div id="content">
<div id="content-header">
</div>
<div class="container-fluid" style="margin-left:200px;"><cfif parameterexists(getuser.id) and parameterexists(url.eventid)>
<cfquery name="getseo" datasource="#ds#">
select id, name,datestart,dateend
from ActivityPlanner
where (seo_friendly is null or seo_friendly = '')
and id <> 9939 and id <> 171250 and id <> 174319 and id <> 116527 and name <> ''
</cfquery>
<cfoutput query="getseo">
<cfset seodate = '#dateformat(datestart,"yyyy-mm-dd")#-#dateformat(datestart,"yyyy-mm-dd")#'>
<cfset moveurl = reReplace(name, "([^[:alnum:]|[:blank:]]) ", "", "all")>
<cfset moveurl = #reReplaceNoCase(moveurl, "[^a-z0-9]", "-", "all")#>
<Cfset moveurl = rereplace(moveurl," ","-","ALL")>
<cfset moveurl = rereplace(moveurl,"'","-","ALL")>
<cfset xxx = len(moveurl)>
<cfset xxx2 = xxx -1>
<Cfif #left(moveurl,1)# eq '-'>
<cfset moveurl = '#right(moveurl,xxx2)#'>
</cfif>
<cfset xxx = len(moveurl)>
<cfset xxx2 = xxx -1>
<Cfif #left(moveurl,1)# eq '-'>
<cfset moveurl = '#right(moveurl,xxx2)#'>
</cfif>
<cfset moveurl = '#moveurl#-#seodate#'>
<Cfquery name="checkmove" datasource="#ds#">
select id from ActivityPlanner where seo_friendly = '#moveurl#'
</cfquery>
<Cfif #checkmove.recordcount# gt 0>
<cfset moveurl = '#moveurl#-#dateformat(currentdatetime,'mmdd')#'>
</cfif>
<Cfquery name="upds" datasource="#ds#">
update ActivityPlanner
set seo_friendly = '#moveurl#'
where id = #id#
</cfquery>
</cfoutput>
<Cfif parameterexists(url.blank)>
<cfquery name="Getcat" datasource="#ds#">
SELECT
ActivityPlannerHold.id,
ActivityPlannerHold.META_SRC_URI,
ActivityPlannerHold.AGES,
ActivityPlannerHold.AREA,
ActivityPlannerHold.AUDIENCE,
ActivityPlannerHold.CATEGORY,
ActivityPlannerHold.COST,
ActivityPlannerHold.DATE,
ActivityPlannerHold.address,
ActivityPlannerHold.city as acity,
ActivityPlannerHold.state as astate,
ActivityPlannerHold.zip,ActivityPlannerHold.firstname,
ActivityPlannerHold.lastname,
ActivityPlannerHold.contactfirst,
ActivityPlannerHold.contactlast,
ActivityPlannerHold.catid,
ActivityPlannerHold.contactitle,
ActivityPlannerHold.contactphone,
ActivityPlannerHold.contactemail,
ActivityPlannerHold.zip as azip,
ActivityPlannerHold.DESCRIPTION,
ActivityPlannerHold.EVENT,
ActivityPlannerHold.ENDDATE,
ActivityPlannerHold.ENDTIME,
ActivityPlannerHold.EVENT_URL,
ActivityPlannerHold.INFO,
ActivityPlannerHold.PHONE as venuephone,
ActivityPlannerHold.TIME,
ActivityPlannerHold.website,
ActivityPlannerHold.URL,
ActivityPlannerHold.VENUE,
ActivityPlannerHold.VENUE_URL,
ActivityPlannerHold.VENUENAME,
ActivityPlannerHold.ActivityPlannerVenueID,
ActivityPlannerHold.statusnum,
ActivityPlannerHold.astart,
ActivityPlannerHold.aend,
ActivityPlannerHold.photo,
ActivityPlannerHold.buytickets,
ActivityPlannerHold.thumbnail
FROM ActivityPlannerHold
where 1 =1
<cfif parameterexists(url.eventid)> and ActivityPlannerHold.id = #url.eventid# </cfif>
order by ActivityPlannerHold.venue
limit 0,1
</cfquery>
<cfelse>
<cfquery name="Getcat" datasource="#ds#">
SELECT
ActivityPlannerHold.id,
ActivityPlannerHold.META_SRC_URI,
ActivityPlannerHold.AGES,
ActivityPlannerHold.AREA,
ActivityPlannerHold.AUDIENCE,
ActivityPlannerHold.CATEGORY,
ActivityPlannerHold.COST,
ActivityPlannerHold.DATE,
ActivityPlannerHold.city as acity,
ActivityPlannerHold.state as astate,
ActivityPlannerHold.zip as azip,
ActivityPlannerHold.DESCRIPTION,
ActivityPlannerHold.EVENT,
ActivityPlannerHold.firstname,
ActivityPlannerHold.lastname,
ActivityPlannerHold.contactitle,
ActivityPlannerHold.contactphone,
ActivityPlannerHold.contactemail,
ActivityPlannerHold.website,
ActivityPlannerHold.ENDDATE,
ActivityPlannerHold.ENDTIME,
ActivityPlannerHold.EVENT_URL,
ActivityPlannerHold.INFO,
ActivityPlannerHold.PHONE,
ActivityPlannerHold.buytickets,
ActivityPlannerHold.contactfirst,
ActivityPlannerHold.contactlast,
ActivityPlannerHold.catid,
ActivityPlannerHold.TIME,
ActivityPlannerHold.URL,
ActivityPlannerHold.VENUE,
ActivityPlannerHold.VENUE_URL,
ActivityPlannerHold.VENUENAME,
ActivityPlannerHold.ActivityPlannerVenueID,
ActivityPlannerHold.statusnum,
ActivityPlannerVenues.id as venueid,
ActivityPlannerVenues.website,
ActivityPlannerVenues.address,
ActivityPlannerHold.astart,
ActivityPlannerHold.aend,
ActivityPlannerVenues.city,
ActivityPlannerVenues.state,
ActivityPlannerVenues.zip,
ActivityPlannerVenues.phone as venuephone,
,
ActivityPlannerHold.photo,
ActivityPlannerHold.thumbnail
FROM ActivityPlannerHold inner join ActivityPlannerVenues on ActivityPlannerHold.ActivityPlannerVenueID = ActivityPlannerVenues.id
where ActivityPlannerHold.statusnum = 0
<cfif parameterexists(url.venueid)>and ActivityPlannerHold.ActivityPlannerVenueID = #url.venueid# </cfif>
<cfif parameterexists(url.eventid)>and ActivityPlannerHold.id = #url.eventid# </cfif>
order by ActivityPlannerHold.venue
limit 0,1
</cfquery>
</Cfif>
<table width=100%><tr><td style="padding:4px;">
<strong><Font face=verdana size=+1>Calendar Import</Font></strong>
<script language="javascript">
function pickbooka() {
if (document.bookforma.books.value != '0' )
{
document.location = document.bookforma.books.value;
} else {
alert('Please select a Show')
}
}
</script>
<script language="javascript">
function pickbookab() {
if (document.bookformab.books.value != '0' )
{
document.location = document.bookformab.books.value;
} else {
alert('Please select a Show')
}
}
</script>
<Cfquery name="Getpullcat" datasource="#ds#" cachedwithin="#CreateTimeSpan(0, 6, 0, 0)#">
select distinct venuename,ActivityPlannerVenueID as id
from ActivityPlannerHold
order by venuename,ActivityPlannerVenueID
</Cfquery>
<br />
<form name="bookforma" style="margin-bottom:0; display: inline;padding:0; border:0; margin:0">
Jump to Venue:
<SELECT size=1 onchange="javascript:pickbooka();" name="books" class="books" style="width:300px;">
<cfoutput><cfif parameterexists(url.venuename)><option value="approvecalendar.cfm?venueid=#url.venueid#&venuename=#url.venuename#">#url.venuename#</option></cfif></cfoutput>
<option value=''>Select Venue
<cfoutput query="getpullcat">
<option value="approvecalendar.cfm?venueid=#getpullcat.id#&venuename=#getpullcat.venuename#">#getpullcat.venuename#</option>
</cfoutput>
</select>
</form>
a<Cfoutput>#getcat.recordcount#</Cfoutput>a
<br>
<FORM action="approvecalendar2.cfm" method="post">
<br><cfoutput query="getcat"><input type="hidden" name="id" value="#getcat.id#">
<input type="hidden" name="ActivityPlannerVenueID" value="#getcat.ActivityPlannerVenueID#">
<table cellspacing=5 cellpadding=5 border=1>
<table cellspacing=5 cellpadding=5 border=1>
<tr><td align="left"> <b><font SIZE="-1" FACE="verdana">
Select as many as needed to include in the PRINT calendar:</font></b><br /><font face=verdana size=-2>
<input name="cg" type="checkbox" checked="">CityGuide<br />
</td></tr>
<tr><td style="padding:4px;">
<b><font SIZE="-1" FACE="verdana">Venue Name:</font></b>
</td><td style="padding:4px;">
<input NAME="name" SIZE="35" value="#getcat.VENUENAME#">
</td></tr>
<tr><td style="padding:4px;">
<b><font SIZE="-1" FACE="verdana">Activity Name:</font></b>
</td><td style="padding:4px;">
<cfset TValue = Evaluate("getcat.event")>
<cfset TValue = rereplace(TValue, '"','''', "ALL")>
<input NAME="activityname" SIZE="35" value="#tvalue#">
</td></tr>
<tr><td style="padding:4px;">
<b><font SIZE="-1" FACE="verdana">Mark for Newsletter?:</font></b>
</td><td style="padding:4px;">
<select name="newsletterpickup">
<option value="No">No</option>
<option value="Yes">Yes</option>
</select>
</td></tr>
<tr><td style="padding:4px;">
<b><font SIZE="-1" FACE="verdana">Mark for Editor's Hot Tickets?:</font></b>
</td><td style="padding:4px;">
<select name="hotticket">
<option value="No">No</option>
<option value="Yes">Yes</option>
</select>
</td></tr>
<tr><td style="padding:4px;">
<b><font SIZE="-1" FACE="verdana">Address:</font></b>
</td><td style="padding:4px;">
<input NAME="address" SIZE="35" value="#getcat.address#">
</td></tr>
<tr><td style="padding:4px;">
<b><font SIZE="-1" FACE="verdana">Cross Streets:</font></b>
</td><td style="padding:4px;">
<input NAME="address2" SIZE="35">
</td></tr>
<tr><td style="padding:4px;">
<b><font SIZE="-1" FACE="verdana">City:</font></b>
</td><td style="padding:4px;">
<Cfif #getcat.acity# is not ''>
<input NAME="City" SIZE="35" value="#getcat.acity#">
<Cfelse>
<cfif parameterexists(getcat.city)>
<input NAME="City" SIZE="35" value="#getcat.city#">
<cfelse>
<input NAME="City" SIZE="35" >
</cfif>
</Cfif>
</td></tr>
<tr><td style="padding:4px;">
<b><font SIZE="-1" FACE="verdana">State:</font></b>
</td><td style="padding:4px;">
<Cfif #getcat.astate# is not ''>
<input NAME="state" SIZE="3" value="#getcat.astate#">
<Cfelse>
<input NAME="state" SIZE="3" value="#getcat.astate#">
</Cfif>
</td></tr>
<tr><td style="padding:4px;">
<b><font SIZE="-1" FACE="verdana">Zip:</font></b>
</td><td style="padding:4px;">
<Cfif #getcat.azip# is not ''>
<input NAME="zip" SIZE="5" value="#getcat.azip#">
<Cfelse>
<input NAME="zip" SIZE="5" value="#getcat.zip#">
</Cfif>
</td></tr>
<tr><td style="padding:4px;">
<b><font SIZE="-1" FACE="verdana">Phone:</font></b>
</td><td style="padding:4px;">
<input NAME="Phone" SIZE="35" value="#getcat.venuePhone#">
</td></tr>
<tr><td style="padding:4px;">
<b><font SIZE="-1" FACE="verdana">Price:</font></b>
</td><td style="padding:4px;">
Free <input NAME="age6" SIZE="35" type="checkbox">
<p>
or
<p>
<input NAME="Price" SIZE="35" value="#getcat.cost#"><br>
Follow this format: $12; $10 seniors; $8 children ages 2-12; free for children younger than 2
</td></tr>
<tr><td style="padding:4px;">
<b><font SIZE="-1" FACE="verdana">Ages (Select all that apply):</font></b>
</td><td style="padding:4px;">
<font SIZE="-2" FACE="verdana">
<font SIZE="-2" FACE="verdana">
<input name="ages" type="checkbox" value="TOD" <cfif #getcat.ages# contains 'TOD'>checked</cfif>>Pre-school & younger<br />
<input name="ages" type="checkbox" value="YE" <cfif #getcat.ages# contains 'YE'>checked</cfif>>Young elementary
<input name="ages" type="checkbox" value="TW" <cfif #getcat.ages# contains 'TW'>checked</cfif>>Tween<br />
<input name="ages" type="checkbox" value="TE" <cfif #getcat.ages# contains 'TE'>checked</cfif>>Teen
<input name="ages" type="checkbox" value="AD" <cfif #getcat.ages# contains 'AD'>checked</cfif>>Adult
<p>
OR
<p>
<input name="ages" type="checkbox" value="All" <cfif #getcat.ages# contains 'ALL'>checked</cfif>>All Ages
</td></tr>
<tr>
<td style="padding:4px;">
<b><font SIZE="-1" FACE="verdana" >Date:</font></b>
</td><td style="padding:4px;">
<Font face=verdana size=-1 color="red"><strong>#date#</strong>
</td></tr>
<tr>
<td style="padding:4px;">
<b><font SIZE="-1" FACE="verdana" >Start Date (mm/dd/yyyy):</font></b>
</td><td style="padding:4px;">
<input NAME="datestart" SIZE="50" value="#getcat.astart#">
</td></tr>
<tr>
<td style="padding:4px;">
<b><font SIZE="-1" FACE="verdana" >End Date (mm/dd/yyyy):</font></b>
</td><td style="padding:4px;">
<input NAME="dateend" SIZE="50" value="#aend#">
</td></tr>
<tr><td style="padding:4px;">
<b><font SIZE="-1" FACE="verdana">Hours:</font></b>
</td><td style="padding:4px;">
<input NAME="hours" SIZE="35" value="#time#">
</td></tr>
<tr><td style="padding:4px;">
<b><font SIZE="-1" FACE="verdana">Website:</font></b>
</td><td style="padding:4px;">
<input NAME="Website" SIZE="35" value="#getcat.website#">
</td></tr>
<tr><td style="padding:4px;">
<b><font SIZE="-1" FACE="verdana">Purchase Tickets Link:</font></b>
</td><td style="padding:4px;">
<input NAME="buytickets" SIZE="35" value="#getcat.buytickets#">
</td></tr>
<tr><td style="padding:4px;">
<b><font SIZE="-1" FACE="verdana">Main Page:</font></b>
</td><td style="padding:4px;">
<select name="mainpage">
<option value="0">No
<option value="1">Yes
</select>
</td></tr>
</cfoutput>
<cfquery name="Getcats" datasource="#ds#">
select catid, cat,mastercat
from CatActivityPlanner
where mag = 1
and hide <> 1
and catid > 150
order by mastercat,cat
</cfquery>
<cfquery name="Getcat2" datasource="#ds#">
SELECT cat,catid
FROM CatActivityPlanner
where mag = 5
order by cat
</cfquery>
<cfquery name="Getcata" datasource="#ds#">
SELECT cat,catid,mastercat
FROM CatActivityPlanner
where catid = #getcat.catid#
</cfquery>
<tr>
<td style="padding:4px;">
<b><font SIZE="-1" FACE="verdana" >CG Category 1:</font></b>
</td>
<td style="padding:4px;">
<select NAME="catid" size="1">
<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 style="padding:4px;">
<b><font SIZE="-1" FACE="verdana" >CG Category 2:</font></b>
</td>
<td style="padding:4px;">
<select NAME="catid2" size="1">
<option value="0">None</option>
<cfoutput query="getcats">
<option value="#catid#">#mastercat# - #cat#</option>
</cfoutput>
</select>
</td>
</tr>
<tr>
<td style="padding:4px;">
<b><font SIZE="-1" FACE="verdana" >NYMP Category 1 (ONLINE ONLY):</font></b>
</td>
<td style="padding:4px;">
<select NAME="catid3" size="1">
<option value="106">Miscellaneous</option>
<option value="0">None</option>
<cfoutput query="getcat2">
<option value="#catid#">#Cat#</option>
</cfoutput>
</select>
</td>
</tr>
<tr>
<td style="padding:4px;">
<b><font SIZE="-1" FACE="verdana" >NYMP Category 2 (ONLINE ONLY):</font></b>
</td>
<td style="padding:4px;">
<select NAME="catid4" size="1">
<option value="0">None</option>
<cfoutput query="getcat2">
<option value="#catid#">#Cat#</option>
</cfoutput>
</select>
</td></tr>
<cfquery name="Getcatnympprint" datasource="#ds#">
SELECT cat,catid
FROM CatActivityPlanner
where mag = 55
order by cat
</cfquery>
<tr>
<td style="padding:4px;">
<b><font SIZE="-1" FACE="verdana" >NYMP Print Category:</font></b>
</td>
<td style="padding:4px;">
<select NAME="nympprintcat" size="1">
<option value="0">None</option>
<cfoutput query="Getcatnympprint">
<option value="#catid#">#Cat#</option>
</cfoutput>
</select>
</td></tr>
<cfoutput>
<tr>
<td colspan=2 align="left" valign="top">
<font SIZE="-1" FACE="verdana" ><b>Full Description for the Online Calendar:</b></font><br>
<textarea name="description" cols="45" rows="10" wrap="VIRTUAL">#getcat.description#</textarea>
</td>
</tr>
<tr>
<td colspan=2 align="left" valign="top">
<font SIZE="-1" FACE="verdana" ><b>Short Description for the Print Calendar:</b></font><br>
<Table style="width:450px"><tr><td>
<script src="//cdn.ckeditor.com/4.5.3/basic/ckeditor.js"></script>
<textarea name="shortdescription" cols="45" rows="10" wrap="VIRTUAL" style="width:450px;"></textarea>
<script>
CKEDITOR.removeButtons = 'Bold,About';
CKEDITOR.replace( 'shortdescription' );
</script></td></tr></Table>
</td>
</tr>
<tr>
<td colspan=2 align="left" valign="top">
<font SIZE="-1" FACE="verdana" ><b>Why We Love It (for Editor's Hot Tickets only):</b></font><br>
<textarea name="editorlove" cols="45" rows="10" wrap="VIRTUAL"></textarea>
</td>
</tr>
</cfoutput>
<tr><td valign=top><font face=verdana size=-1><strong> Event Images:</strong><Br>
<table>
<cfif #getcat.thumbnail# is not ''>
<Cfoutput><!---<a href="editcalendar.cfm?id=#url.id#&removepic=on">remove pic</a><br>--->
<Tr><td style="padding:4px;"><Center>
<input type="Radio" name="usepic" value="#getcat.id#"><br>
<input type="hidden" name="photo" value="#getcat.photo#">
<input type="hidden" name="thumbnail" value="#getcat.thumbnail#">
<a href="Https://www.cityguideny.com/eventpic/#getcat.photo#" target="_new"><img src="Https://www.cityguideny.com/eventpic/#getcat.thumbnail#" width="200"></a>
<br>
<cfset cfImage = imageNew('/home/home2/domains/parentsknow.com/public_html/newsite2018/2020/eventpic/#getcat.photo#')>
<cfset imageData = imageInfo(cfImage)>
#imagedata.width# x #imagedata.height#
</Center></Td></Tr>
</Cfoutput>
</cfif>
<cfquery name="getrelated" dataSource="#ds#">
select thumbnail,photo,id,imageheight,imagewidth from ActivityPlanner
where name = '#getcat.venuename#' and photo <> '' and photo <> '#getcat.photo#'
order by id DESC
</cfquery>
<Cfoutput query="getrelated">
<cfif FileExists('/home/home2/domains/parentsknow.com/public_html/newsite2018/2020/eventpic/#getrelated.photo#')>
<Tr><td style="padding:4px;"><Center>
<input type="Radio" name="usepic" value="#id#"><br>
<a href="Http://www.cityguideny.com/eventpic/#getrelated.photo#" target="_new"><img src="Http://www.cityguideny.com/eventpic/#getrelated.thumbnail#" width="200"></a><br>
#imagewidth# x #imageheight#
</Center></Td></Tr>
</cfif>
</Cfoutput>
</table>
</font></td><td style="padding:4px;"><input type=file name=photo></td></tr>
<tr><td style="padding:4px;">
<b><font SIZE="-1" FACE="verdana">Use Picture:</font></b>
</td><td style="padding:4px;">
<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>
<cfoutput>
<tr><td style="padding:4px;">
<b><font SIZE="-1" FACE="verdana">Contact First Name:</font></b>
</td><td style="padding:4px;">
<Cfif #getcat.contactfirst# is not ''>
<input NAME="contactfirst" SIZE="10" value="#getcat.contactfirst#">
<Cfelse>
<input NAME="contactfirst" SIZE="10" value="#getcat.firstname#">
</Cfif>
</td></tr>
<tr><td style="padding:4px;">
<b><font SIZE="-1" FACE="verdana">Contact Last Name:</font></b>
</td><td style="padding:4px;">
<Cfif #getcat.contactlast# is not ''>
<input NAME="contactlast" SIZE="15" value="#getcat.contactlast#">
<Cfelse>
<input NAME="contactlast" SIZE="15" value="#getcat.lastname#">
</Cfif>
</td></tr>
<tr><td style="padding:4px;">
<b><font SIZE="-1" FACE="verdana">Contact Title:</font></b>
</td><td style="padding:4px;">
<input NAME="contactitle" SIZE="15" value="#getcat.contactitle#">
</td></tr>
<tr><td style="padding:4px;">
<b><font SIZE="-1" FACE="verdana">Contact Phone Number:</font></b>
</td><td style="padding:4px;">
<input NAME="contactphone" SIZE="15" value="#getcat.contactphone#">
</td></tr>
<tr><td style="padding:4px;">
<b><font SIZE="-1" FACE="verdana">Contact E-Mail:</font></b>
</td><td style="padding:4px;">
<input NAME="contactemail" SIZE="35" value="#getcat.contactemail#">
</td></tr>
</cfoutput>
</table><br>
<a name="jump"></a>
<center><input type="submit" name="addbutton" Value="Add Event">
<input type="submit" name="skipbutton" Value="Skip Event">
<Cfoutput>
<a href="delplannerhold.cfm?id=#url.eventid#" onclick="return confirm('Really delete?');">Delete Event</a>
</Cfoutput>
</form>
</td></tr></table>
</cfif>
<Br /><p>
<style type="text/css">.regular8{font-family : verdana; font-size : 8pt; color : 000000; text-decoration : none;}</style></form><Table width="90%"><tr><td style="padding:4px;"><p><font face="verdana" size="-2"><p><center>
<a target="_parent" href="/contact.cfm">Contact</a> us. All Materials Copyright <cfoutput>#Year(Now())#</cfoutput> <a href="http://www.davlermedia.com">Davler Media Group, LLC</a><br> View <a href="/privacy.cfm">Privacy Policy</a> | <a href="/tos.cfm">Terms of Service</a>
<p>
</td></tr></TABLE></td><td bgcolor="white" width="4"> </td><td valign=top width=25% bgcolor=white>
<Table><tr><td style="padding:4px;"></td></tr></TABLE>
<table><tr><td style="padding:4px;"></td></tr></table>
<table width=200 bgcolor=white><tr><td style="padding:4px;">
<Font face=verdana size=-2>
<Cfif parameterexists(getcat.activityplannervenueid) and isnumeric(getcat.activityplannervenueid)>
<cfparam name="form.arrivedate" default="#dateformat(currentdatetime,'yyyy-mm-dd')#">
<cfif #form.arrivedate# eq ''>
<cfset form.arrivedate = #dateformat(currentdatetime,'yyyy-mm-dd')#>
</cfif>
<cfset newdeparturedate = #dateadd('d',7,CurrentDateTime)#>
<cfparam name="form.departuredate" default="#dateformat(newdeparturedate,'yyyy-mm-dd')#">
<cfif #form.departuredate# eq ''>
<cfset form.departuredate = #dateformat(currentdatetime,'yyyy-mm-dd')#>
</cfif>
<cfquery name="getstuff" datasource="#ds#">
select *
from ActivityPlanner
where activityplannervenueid = #getcat.activityplannervenueid#
<cfif parameterexists (form.ArriveDate)>
and
(
(datestart between '#dateformat(form.arrivedate,'yyyy-mm-dd')#' and '#dateformat(form.departuredate,'yyyy-mm-dd')#')
or
(dateend between '#dateformat(form.arrivedate,'yyyy-mm-dd')#' and '#dateformat(form.departuredate,'yyyy-mm-dd')#')
or
datestart = '#dateformat(form.arrivedate,'yyyy-mm-dd')#'
or
dateend = '#dateformat(form.arrivedate,'yyyy-mm-dd')#'
<cfif #form.arrivedate# eq #form.departuredate#>
or
(datestart <= '#dateformat(form.arrivedate,'yyyy-mm-dd')#' and dateend >= '#dateformat(form.arrivedate,'yyyy-mm-dd')#')
</cfif>
)
</cfif>
order by id
limit 0, 30
</cfquery>
<strong>Approved:</strong><Br />
<Cfoutput query="Getstuff">
<a href="/admin/editcalendar.cfm?id=#id#">#activityname#</a><Br />
#dateformat(datestart,'m/dd/yyyy')#<cfif #dateend# is not #datestart#> - #dateformat(dateend,'m/dd/yyyy')#</cfif>
<Table><Tr><td style="padding:4px;"></Td></Tr></Table>
</Cfoutput>
<p>
</cfif><Cfif parameterexists(getcat.activityplannervenueid) and isnumeric(getcat.activityplannervenueid)>
<cfquery name="getstuff" datasource="#ds#">
select *
from ActivityPlannerHold
where activityplannervenueid = #getcat.activityplannervenueid#
order by id
limit 0, 30
</cfquery>
<strong>Not Approved:</strong><Br />
<Cfoutput query="Getstuff">
<Cfif #statusnum# eq 0>
<a href="approvecalendar.cfm?eventid=#id#">#event#</a><Br />
#date#
<Table><Tr><td style="padding:4px;"></Td></Tr></Table>
</Cfif>
</Cfoutput>
<p>
<strong>Skipped:</strong><Br />
<Cfoutput query="Getstuff">
<Cfif #statusnum# eq 1>
<a href="approvecalendar.cfm?eventid=#id#">#event#</a><Br />
#date#
<Table><Tr><td style="padding:4px;"></Td></Tr></Table>
</Cfif>
</Cfoutput>
<Cfelse>
Processed!
</Cfif>
<table><tr><td style="padding:4px;"></td></tr></table>
</td></tr></table>
</td></tr></table></body></html>