| 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/nympadmin/ |
Upload File : |
<Cfif #dateformat(currentdatetime,'dddd')# eq 'Saturday' or #dateformat(currentdatetime,'dddd')# eq 'Sunday'>
- NONE!<cfabort></Cfif>
<CFSET CurrentDateTime = #CreateODBCDateTime(Now())#>
<cfparam name="form.arrivedate" default="#dateformat(currentdatetime,'yyyy-mm-dd')#">
<cfset form.arrivedate = #dateformat(currentdatetime,'yyyy-mm-dd')#>
<cfset newdeparturedate = #dateadd('d',7,CurrentDateTime)#>
<cfparam name="form.departuredate" default="#dateformat(newdeparturedate,'yyyy-mm-dd')#">
<cfset form.departuredate = #dateformat(currentdatetime,'yyyy-mm-dd')#>
<Cfquery name="getm" dataSource="#ds#">
select id,astart,aend,description,event,address,city,state,nympregion,zip,dateend
from ActivityPlannerHold
where 1=1
and statusnum=0
and id > 100000
and (catid = 0 and catid2 = 0)
and dateend = '2006-01-01'
order by dateend
</cfquery>
<Cfoutput query="Getm">
<Cfset startme = #dateformat(astart,'yyyy-mm-dd')#>
<Cfset endme = #dateformat(aend,'yyyy-mm-dd')#>
<Cfif endme eq ''>
<cfset endme = '#startme#'>
</Cfif>
<Cftry>
<cfquery name="upme" dataSource="#ds#">
update ActivityPlannerHold
set DateStart = '#startme#', DateEnd = '#endme#'
where id = #id#
</cfquery>
<Cfcatch>
</Cfcatch>
</Cftry>
</Cfoutput>
<Cfset url.region = 'Manhattan'>
<Cfset url.email = '[email protected]'>
<cfquery name="getevents" datasource="#ds#">
select id,astart,aend,description,event,address,city,state,nympregion,zip,dateend
from ActivityPlannerHold
where 1=1
and statusnum=0
and nympregion = '#url.region#'
and (catid = 0 and catid2 = 0)
and ( aend like '%2021%')
order by dateend
limit 0,2000
</cfquery>
<cfsavecontent variable="message"><cfset total = 0>
<Cfset redtotal = 0>
<cfoutput query="getevents">
<Cfif #dateformat(astart,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
and
#dateformat(aend,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
>
<Cfif #description# does not contain 'http'>
<cfset total = total + 1>
<cfif #datediff('d',currentdatetime,dateend)# lt 60>
<cfset redtotal = redtotal + 1></cfif>
</cfif>
</Cfif>
</cfoutput>
<b>Total:</b> <cfoutput>#total# <b>Total 60 Days or Less:</b> <font color="Red">#redtotal#</font></cfoutput>
<table class="table color-table inverse-table table-hover table-striped">
<tr>
<td valign="top">
<p>
<font face=verdana size=-1>
<cfset total = 0>
<cfoutput query="getevents">
<Cfif #dateformat(astart,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
and
#dateformat(aend,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
>
<Cfif #description# does not contain 'http'>
<cfif #len(nympregion)# lt 3>
<Cfquery name="checkregion" dataSource="#ds#">
select county from Zip_code_table2017
where zip = '#zip#'
</cfquery>
<cfquery name="upds" dataSource="#ds#">
update ActivityPlannerHold
set nympregion = '#checkregion.county#'
where id = #id#
</cfquery>
</cfif>
<Cfset total = total + 1><div <cfif #datediff('d',currentdatetime,dateend)# lt 60>style="background-color:##ffdfe3;padding:4px;"</cfif>>
<strong>#event#</strong> - #dateformat(astart,'mm/dd/yy')# - #dateformat (aend,'mm/dd/yy')#
<cfif #address# is not ''><br>#address# </cfif> #city#, #state#
<p>
#description#<br />
<cfif parameterexists(getuser.accesslevel) and getuser.accesslevel eq 100>
<a href="https://admin.nymetroparents.com/approvecalendar.cfm?eventid=#id#&blank=on">approve entry</a>
<a href="https://admin.nymetroparents.com/delplannerhold.cfm?id=#id#&blank=on">delete entry</a></div>
</cfif>
<hr>
</Cfif>
</Cfif>
</cfoutput>
</td></tr></table>
</cfsavecontent>
<Cfif #total# gt 0>
<CFMAIL TO="#url.email#,[email protected]"
FROM="[email protected]"
SUBJECT="You have #total# calendar events to approve for NYMP #url.region#"
SERVER="us-smtp-outbound-1.mimecast.com"
type="html">
#url.email#
Below are the events that have been submitted by site visitors and need to be approved for posting. Our goal is to always have this ## be 0, so we're serving the maximum amount of content to our readers.
<p>
#message#
</CFMAIL>
</Cfif>
<Cfset url.region = 'Nassau'>
<Cfset url.email = '[email protected]'>
<cfquery name="getevents" datasource="#ds#">
select id,astart,aend,description,event,address,city,state,nympregion,zip,dateend
from ActivityPlannerHold
where 1=1
and statusnum=0
and nympregion = '#url.region#'
and (catid = 0 and catid2 = 0)
and ( aend like '%2021%')
order by dateend
limit 0,2000
</cfquery>
<cfsavecontent variable="message"><cfset total = 0>
<Cfset redtotal = 0>
<cfoutput query="getevents">
<Cfif #dateformat(astart,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
and
#dateformat(aend,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
>
<Cfif #description# does not contain 'http'>
<cfset total = total + 1>
<cfif #datediff('d',currentdatetime,dateend)# lt 60>
<cfset redtotal = redtotal + 1></cfif>
</cfif>
</Cfif>
</cfoutput>
<b>Total:</b> <cfoutput>#total# <b>Total 60 Days or Less:</b> <font color="Red">#redtotal#</font></cfoutput>
<table class="table color-table inverse-table table-hover table-striped">
<tr>
<td valign="top">
<p>
<font face=verdana size=-1>
<cfset total = 0>
<cfoutput query="getevents">
<Cfif #dateformat(astart,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
and
#dateformat(aend,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
>
<Cfif #description# does not contain 'http'>
<cfif #len(nympregion)# lt 3>
<Cfquery name="checkregion" dataSource="#ds#">
select county from Zip_code_table2017
where zip = '#zip#'
</cfquery>
<cfquery name="upds" dataSource="#ds#">
update ActivityPlannerHold
set nympregion = '#checkregion.county#'
where id = #id#
</cfquery>
</cfif>
<Cfset total = total + 1><div <cfif #datediff('d',currentdatetime,dateend)# lt 60>style="background-color:##ffdfe3;padding:4px;"</cfif>>
<strong>#event#</strong> - #dateformat(astart,'mm/dd/yy')# - #dateformat (aend,'mm/dd/yy')#
<cfif #address# is not ''><br>#address# </cfif> #city#, #state#
<p>
#description#<br />
<cfif parameterexists(getuser.accesslevel) and getuser.accesslevel eq 100>
<a href="https://admin.nymetroparents.com/approvecalendar.cfm?eventid=#id#&blank=on">approve entry</a>
<a href="https://admin.nymetroparents.com/delplannerhold.cfm?id=#id#&blank=on">delete entry</a></div>
</cfif>
<hr>
</Cfif>
</Cfif>
</cfoutput>
</td></tr></table>
</cfsavecontent>
<Cfif #total# gt 0>
<CFMAIL TO="#url.email#,[email protected]"
FROM="[email protected]"
SUBJECT="You have #total# calendar events to approve for NYMP #url.region#"
SERVER="us-smtp-outbound-1.mimecast.com"
type="html">
#url.email#
Below are the events that have been submitted by site visitors and need to be approved for posting. Our goal is to always have this ## be 0, so we're serving the maximum amount of content to our readers.
<p>
#message#
</CFMAIL>
</Cfif>
<Cfset url.region = 'Queens'>
<Cfset url.email = '[email protected]'>
<cfquery name="getevents" datasource="#ds#">
select id,astart,aend,description,event,address,city,state,nympregion,zip,dateend
from ActivityPlannerHold
where 1=1
and statusnum=0
and nympregion = '#url.region#'
and (catid = 0 and catid2 = 0)
and ( aend like '%2021%')
order by dateend
limit 0,2000
</cfquery>
<cfsavecontent variable="message"><cfset total = 0>
<Cfset redtotal = 0>
<cfoutput query="getevents">
<Cfif #dateformat(astart,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
and
#dateformat(aend,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
>
<Cfif #description# does not contain 'http'>
<cfset total = total + 1>
<cfif #datediff('d',currentdatetime,dateend)# lt 60>
<cfset redtotal = redtotal + 1></cfif>
</cfif>
</Cfif>
</cfoutput>
<b>Total:</b> <cfoutput>#total# <b>Total 60 Days or Less:</b> <font color="Red">#redtotal#</font></cfoutput>
<table class="table color-table inverse-table table-hover table-striped">
<tr>
<td valign="top">
<p>
<font face=verdana size=-1>
<cfset total = 0>
<cfoutput query="getevents">
<Cfif #dateformat(astart,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
and
#dateformat(aend,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
>
<Cfif #description# does not contain 'http'>
<cfif #len(nympregion)# lt 3>
<Cfquery name="checkregion" dataSource="#ds#">
select county from Zip_code_table2017
where zip = '#zip#'
</cfquery>
<cfquery name="upds" dataSource="#ds#">
update ActivityPlannerHold
set nympregion = '#checkregion.county#'
where id = #id#
</cfquery>
</cfif>
<Cfset total = total + 1><div <cfif #datediff('d',currentdatetime,dateend)# lt 60>style="background-color:##ffdfe3;padding:4px;"</cfif>>
<strong>#event#</strong> - #dateformat(astart,'mm/dd/yy')# - #dateformat (aend,'mm/dd/yy')#
<cfif #address# is not ''><br>#address# </cfif> #city#, #state#
<p>
#description#<br />
<cfif parameterexists(getuser.accesslevel) and getuser.accesslevel eq 100>
<a href="https://admin.nymetroparents.com/approvecalendar.cfm?eventid=#id#&blank=on">approve entry</a>
<a href="https://admin.nymetroparents.com/delplannerhold.cfm?id=#id#&blank=on">delete entry</a></div>
</cfif>
<hr>
</Cfif>
</Cfif>
</cfoutput>
</td></tr></table>
</cfsavecontent>
<Cfif #total# gt 0>
<CFMAIL TO="#url.email#,[email protected]"
FROM="[email protected]"
SUBJECT="You have #total# calendar events to approve for NYMP #url.region#"
SERVER="us-smtp-outbound-1.mimecast.com"
type="html">
#url.email#
Below are the events that have been submitted by site visitors and need to be approved for posting. Our goal is to always have this ## be 0, so we're serving the maximum amount of content to our readers.
<p>
#message#
</CFMAIL>
</Cfif>
<Cfset url.region = 'Westchester'>
<Cfset url.email = '[email protected]'>
<cfquery name="getevents" datasource="#ds#">
select id,astart,aend,description,event,address,city,state,nympregion,zip,dateend
from ActivityPlannerHold
where 1=1
and statusnum=0
and nympregion = '#url.region#'
and (catid = 0 and catid2 = 0)
and ( aend like '%2021%')
order by dateend
limit 0,2000
</cfquery>
<cfsavecontent variable="message"><cfset total = 0>
<Cfset redtotal = 0>
<cfoutput query="getevents">
<Cfif #dateformat(astart,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
and
#dateformat(aend,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
>
<Cfif #description# does not contain 'http'>
<cfset total = total + 1>
<cfif #datediff('d',currentdatetime,dateend)# lt 60>
<cfset redtotal = redtotal + 1></cfif>
</cfif>
</Cfif>
</cfoutput>
<b>Total:</b> <cfoutput>#total# <b>Total 60 Days or Less:</b> <font color="Red">#redtotal#</font></cfoutput>
<table class="table color-table inverse-table table-hover table-striped">
<tr>
<td valign="top">
<p>
<font face=verdana size=-1>
<cfset total = 0>
<cfoutput query="getevents">
<Cfif #dateformat(astart,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
and
#dateformat(aend,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
>
<Cfif #description# does not contain 'http'>
<cfif #len(nympregion)# lt 3>
<Cfquery name="checkregion" dataSource="#ds#">
select county from Zip_code_table2017
where zip = '#zip#'
</cfquery>
<cfquery name="upds" dataSource="#ds#">
update ActivityPlannerHold
set nympregion = '#checkregion.county#'
where id = #id#
</cfquery>
</cfif>
<Cfset total = total + 1><div <cfif #datediff('d',currentdatetime,dateend)# lt 60>style="background-color:##ffdfe3;padding:4px;"</cfif>>
<strong>#event#</strong> - #dateformat(astart,'mm/dd/yy')# - #dateformat (aend,'mm/dd/yy')#
<cfif #address# is not ''><br>#address# </cfif> #city#, #state#
<p>
#description#<br />
<cfif parameterexists(getuser.accesslevel) and getuser.accesslevel eq 100>
<a href="https://admin.nymetroparents.com/approvecalendar.cfm?eventid=#id#&blank=on">approve entry</a>
<a href="https://admin.nymetroparents.com/delplannerhold.cfm?id=#id#&blank=on">delete entry</a></div>
</cfif>
<hr>
</Cfif>
</Cfif>
</cfoutput>
</td></tr></table>
</cfsavecontent>
<Cfif #total# gt 0>
<CFMAIL TO="#url.email#,[email protected]"
FROM="[email protected]"
SUBJECT="You have #total# calendar events to approve for NYMP #url.region#"
SERVER="us-smtp-outbound-1.mimecast.com"
type="html">
#url.email#
Below are the events that have been submitted by site visitors and need to be approved for posting. Our goal is to always have this ## be 0, so we're serving the maximum amount of content to our readers.
<p>
#message#
</CFMAIL>
</Cfif>
<Cfset url.region = 'Suffolk'>
<Cfset url.email = '[email protected]'>
<cfquery name="getevents" datasource="#ds#">
select id,astart,aend,description,event,address,city,state,nympregion,zip,dateend
from ActivityPlannerHold
where 1=1
and statusnum=0
and nympregion = '#url.region#'
and ( aend like '%2021%')
and (catid = 0 and catid2 = 0)
order by dateend
limit 0,2000
</cfquery>
<cfsavecontent variable="message"><cfset total = 0>
<Cfset redtotal = 0>
<cfoutput query="getevents">
<Cfif #dateformat(astart,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
and
#dateformat(aend,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
>
<Cfif #description# does not contain 'http'>
<cfset total = total + 1>
<cfif #datediff('d',currentdatetime,dateend)# lt 60>
<cfset redtotal = redtotal + 1></cfif>
</cfif>
</Cfif>
</cfoutput>
<b>Total:</b> <cfoutput>#total# <b>Total 60 Days or Less:</b> <font color="Red">#redtotal#</font></cfoutput>
<table class="table color-table inverse-table table-hover table-striped">
<tr>
<td valign="top">
<p>
<font face=verdana size=-1>
<cfset total = 0>
<cfoutput query="getevents">
<Cfif #dateformat(astart,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
and
#dateformat(aend,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
>
<Cfif #description# does not contain 'http'>
<cfif #len(nympregion)# lt 3>
<Cfquery name="checkregion" dataSource="#ds#">
select county from Zip_code_table2017
where zip = '#zip#'
</cfquery>
<cfquery name="upds" dataSource="#ds#">
update ActivityPlannerHold
set nympregion = '#checkregion.county#'
where id = #id#
</cfquery>
</cfif>
<Cfset total = total + 1><div <cfif #datediff('d',currentdatetime,dateend)# lt 60>style="background-color:##ffdfe3;padding:4px;"</cfif>>
<strong>#event#</strong> - #dateformat(astart,'mm/dd/yy')# - #dateformat (aend,'mm/dd/yy')#
<cfif #address# is not ''><br>#address# </cfif> #city#, #state#
<p>
#description#<br />
<cfif parameterexists(getuser.accesslevel) and getuser.accesslevel eq 100>
<a href="https://admin.nymetroparents.com/approvecalendar.cfm?eventid=#id#&blank=on">approve entry</a>
<a href="https://admin.nymetroparents.com/delplannerhold.cfm?id=#id#&blank=on">delete entry</a></div>
</cfif>
<hr>
</Cfif>
</Cfif>
</cfoutput>
</td></tr></table>
</cfsavecontent>
<Cfif #total# gt 0>
<CFMAIL TO="#url.email#,[email protected]"
FROM="[email protected]"
SUBJECT="You have #total# calendar events to approve for NYMP #url.region#"
SERVER="us-smtp-outbound-1.mimecast.com"
type="html">
#url.email#
Below are the events that have been submitted by site visitors and need to be approved for posting. Our goal is to always have this ## be 0, so we're serving the maximum amount of content to our readers.
<p>
#message#
</CFMAIL>
</Cfif>
<Cfset url.region = 'Brooklyn'>
<Cfset url.email = '[email protected]'>
<cfquery name="getevents" datasource="#ds#">
select id,astart,aend,description,event,address,city,state,nympregion,zip,dateend
from ActivityPlannerHold
where 1=1
and statusnum=0
and nympregion = '#url.region#'
and (catid = 0 and catid2 = 0)
and ( aend like '%2021%')
order by dateend
limit 0,2000
</cfquery>
<cfsavecontent variable="message"><cfset total = 0>
<Cfset redtotal = 0>
<cfoutput query="getevents">
<Cfif #dateformat(astart,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
and
#dateformat(aend,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
>
<Cfif #description# does not contain 'http'>
<cfset total = total + 1>
<cfif #datediff('d',currentdatetime,dateend)# lt 60>
<cfset redtotal = redtotal + 1></cfif>
</cfif>
</Cfif>
</cfoutput>
<b>Total:</b> <cfoutput>#total# <b>Total 60 Days or Less:</b> <font color="Red">#redtotal#</font></cfoutput>
<table class="table color-table inverse-table table-hover table-striped">
<tr>
<td valign="top">
<p>
<font face=verdana size=-1>
<cfset total = 0>
<cfoutput query="getevents">
<Cfif #dateformat(astart,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
and
#dateformat(aend,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
>
<Cfif #description# does not contain 'http'>
<cfif #len(nympregion)# lt 3>
<Cfquery name="checkregion" dataSource="#ds#">
select county from Zip_code_table2017
where zip = '#zip#'
</cfquery>
<cfquery name="upds" dataSource="#ds#">
update ActivityPlannerHold
set nympregion = '#checkregion.county#'
where id = #id#
</cfquery>
</cfif>
<Cfset total = total + 1><div <cfif #datediff('d',currentdatetime,dateend)# lt 60>style="background-color:##ffdfe3;padding:4px;"</cfif>>
<strong>#event#</strong> - #dateformat(astart,'mm/dd/yy')# - #dateformat (aend,'mm/dd/yy')#
<cfif #address# is not ''><br>#address# </cfif> #city#, #state#
<p>
#description#<br />
<cfif parameterexists(getuser.accesslevel) and getuser.accesslevel eq 100>
<a href="https://admin.nymetroparents.com/approvecalendar.cfm?eventid=#id#&blank=on">approve entry</a>
<a href="https://admin.nymetroparents.com/delplannerhold.cfm?id=#id#&blank=on">delete entry</a></div>
</cfif>
<hr>
</Cfif>
</Cfif>
</cfoutput>
</td></tr></table>
</cfsavecontent>
<Cfif #total# gt 0>
<CFMAIL TO="#url.email#,[email protected]"
FROM="[email protected]"
SUBJECT="You have #total# calendar events to approve for NYMP #url.region#"
SERVER="us-smtp-outbound-1.mimecast.com"
type="html">
#url.email#
Below are the events that have been submitted by site visitors and need to be approved for posting. Our goal is to always have this ## be 0, so we're serving the maximum amount of content to our readers.
<p>
#message#
</CFMAIL>
</Cfif>
<Cfset url.region = 'Rockland'>
<Cfset url.email = '[email protected]'>
<cfquery name="getevents" datasource="#ds#">
select id,astart,aend,description,event,address,city,state,nympregion,zip,dateend
from ActivityPlannerHold
where 1=1
and statusnum=0
and nympregion = '#url.region#'
and ( aend like '%2021%')
and (catid = 0 and catid2 = 0)
order by dateend
limit 0,2000
</cfquery>
<cfsavecontent variable="message"><cfset total = 0>
<Cfset redtotal = 0>
<cfoutput query="getevents">
<Cfif #dateformat(astart,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
and
#dateformat(aend,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
>
<Cfif #description# does not contain 'http'>
<cfset total = total + 1>
<cfif #datediff('d',currentdatetime,dateend)# lt 60>
<cfset redtotal = redtotal + 1></cfif>
</cfif>
</Cfif>
</cfoutput>
<b>Total:</b> <cfoutput>#total# <b>Total 60 Days or Less:</b> <font color="Red">#redtotal#</font></cfoutput>
<table class="table color-table inverse-table table-hover table-striped">
<tr>
<td valign="top">
<p>
<font face=verdana size=-1>
<cfset total = 0>
<cfoutput query="getevents">
<Cfif #dateformat(astart,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
and
#dateformat(aend,'mm/dd/yy')# gt #dateformat(currentdatetime,'mm/dd/yy')#
>
<Cfif #description# does not contain 'http'>
<cfif #len(nympregion)# lt 3>
<Cfquery name="checkregion" dataSource="#ds#">
select county from Zip_code_table2017
where zip = '#zip#'
</cfquery>
<cfquery name="upds" dataSource="#ds#">
update ActivityPlannerHold
set nympregion = '#checkregion.county#'
where id = #id#
</cfquery>
</cfif>
<Cfset total = total + 1><div <cfif #datediff('d',currentdatetime,dateend)# lt 60>style="background-color:##ffdfe3;padding:4px;"</cfif>>
<strong>#event#</strong> - #dateformat(astart,'mm/dd/yy')# - #dateformat (aend,'mm/dd/yy')#
<cfif #address# is not ''><br>#address# </cfif> #city#, #state#
<p>
#description#<br />
<cfif parameterexists(getuser.accesslevel) and getuser.accesslevel eq 100>
<a href="https://admin.nymetroparents.com/approvecalendar.cfm?eventid=#id#&blank=on">approve entry</a>
<a href="https://admin.nymetroparents.com/delplannerhold.cfm?id=#id#&blank=on">delete entry</a></div>
</cfif>
<hr>
</Cfif>
</Cfif>
</cfoutput>
</td></tr></table>
</cfsavecontent>
<Cfif #total# gt 0>
<CFMAIL TO="#url.email#,[email protected]"
FROM="[email protected]"
SUBJECT="You have #total# calendar events to approve for NYMP #url.region#"
SERVER="us-smtp-outbound-1.mimecast.com"
type="html">
#url.email#
Below are the events that have been submitted by site visitors and need to be approved for posting. Our goal is to always have this ## be 0, so we're serving the maximum amount of content to our readers.
<p>
#message#
</CFMAIL>
</Cfif>