| 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/2019/ |
Upload File : |
<cfinclude template="header.cfm">
<CFSET CurrentDateTime=#CreateODBCDateTime(Now())#>
<cfif parameterexists(form.date1)>
<cfset form.arrivedate='#dateformat(form.date1,' yyyy-mm-dd')#'>
</cfif>
<cfif parameterexists(form.date2)>
<cfset form.departuredate='#dateformat(form.date2,' yyyy-mm-dd')#'>
</cfif>
<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',30,CurrentDateTime)#>
<cfparam name="form.departuredate" default="#dateformat(newdeparturedate,'yyyy-mm-dd')#">
<cfif #form.departuredate# eq ''>
<cfset form.departuredate=#dateformat(currentdatetime,'yyyy-mm-dd')#>
</cfif>
<cfif parameterexists(url.catid)>
<cfparam name="form.catpick" default="#url.catid#">
</cfif>
<cfif parameterexists(url.catpick)>
<cfparam name="form.catpick" default="#url.catpick#">
</cfif>
<cfquery name="Getcat" datasource="#dsro#" cachedwithin="#createtimespan(0,1,3,0)#">
SELECT cat,catid,mastercat, icon, shorthomepage
FROM CatActivityPlanner
where mag = 1
and hide <> 1
and catid > 150
<!---and mastercat = '' --->
and cat <> ''
and shorthomepage <> ''
and icon <> ''
order by orderme
</cfquery>
<cfquery name="getcountm" datasource="#dsro#" cachedwithin="#createtimespan(0,3,3,0)#">
select count(id) as counter
from ActivityPlanner
where 1=1
and
(
(datestart between '#dateformat(currentdatetime,'yyyy-mm-dd')#' and
'2099-12-31')
or
(dateend between '#dateformat(currentdatetime,'yyyy-mm-dd')#' and
'2099-12-31')
or
datestart = '#dateformat(currentdatetime,'yyyy-mm-dd')#'
or
dateend = '#dateformat(currentdatetime,'yyyy-mm-dd')#'
or
dateend > '#dateformat(currentdatetime,'yyyy-mm-dd')#'
)
and status=0
and numdays >= 0
and (catid > 0 or catid2 > 0)
and (catid3 = 0 and catid4 = 0)
</cfquery>
<div id="home">
<section id="hero">
<div class="intro_title">
<div class="container promo-header" style="">
<a href="/events/"><div class="tagline" style="display:none"></div></a>
<div class="promo-section-wrapper" style="display:none">
<div class="promo-section">
<div class="row row-header">
<div class="col-md-12">
<h1 class="text-center main-title"> <span class="accent"><strong>
<cfoutput>#getcountm.counter#</cfoutput>
Events
</strong></span></h1>
</div>
</div>
<div class="general_icons">
<ul class="flex wrap center">
<Cfoutput query="getcat">
<cfquery name="getcount" datasource="#dsro#"
cachedwithin="#createtimespan(0,1,3,0)#">
select count(id) as counter
from ActivityPlanner
where 1=1
<cfif parameterexists (form.ArriveDate) and
isdate(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')#'
or
dateend >
'#dateformat(form.departuredate,'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>
<cfif parameterexists (url.ArriveDate) and
isdate(url.arrivedate) and
parameterexists(url.departuredate) and
isdate(url.departuredate)>
and
(
(datestart between
'#dateformat(url.arrivedate,'yyyy-mm-dd')#' and
'#dateformat(url.departuredate,'yyyy-mm-dd')#')
or
(dateend between
'#dateformat(url.arrivedate,'yyyy-mm-dd')#'
and '#dateformat(url.departuredate,'yyyy-mm-dd')#')
or
datestart = '#dateformat(form.arrivedate,'yyyy-mm-dd')#'
or
dateend = '#dateformat(form.arrivedate,'yyyy-mm-dd')#'
)
</cfif>
<Cfif parameterexists(form.mobilesearchfield) and
#form.mobilesearchfield# is not ''>
and
(name like '%#form.mobilesearchfield#%'
or activityname like '%#form.mobilesearchfield#%'
)
</Cfif>
<Cfif parameterexists(form.free) and form.free eq 'on'>
and age6 = 'on'
</Cfif>
<Cfif parameterexists(form.feature) and form.feature
eq 'on'>
and cgpriority = 2
</Cfif>
and status=0
and numdays >= 0
and (catid > 0 or catid2 > 0)
and (catid3 = 0 and catid4 = 0)
and (catid = #getcat.catid# or catid2 = #getcat.catid#)
</cfquery>
<li><a href="/events/?catid=#catid#"><i
class="#icon#"></i>#shorthomepage# <small><span
id="comedy">(#getcount.counter#)</span></small>
</a></li>
</Cfoutput>
<li><a href="/events/?catid=#catid#"><i
class="icon_set_1_icon-53"></i>All <small><span
id="all">(
<Cfoutput>#getcountm.counter#</Cfoutput>
)</span></small>
</a></li>
</ul>
</div>
<div class="col-md-12">
<hr>
<div class="row pt-10">
<div class="col-md-1 mobile-hide"> <i class="icon-reply"></i></div>
<div class="col-md-11 col-sm-12"><a class="button btn_1 block" href="/events/">Explore More</a> </div>
</div>
</div>
</div>
</div>
</div>
<div class="text-center p-10"><a class="down-arrow" href="#savings-section"><span class="icon-angle-double-down"></span></a>
</div>
</div>
</section>
<main>
<div class="container margin_30">
<div class="row pt-10">
<div class="col-12 text-center" style="text-transform:none">Join
<a class="button btn_1" href="https://www.facebook.com/groups/everythingtodonyc/" target="_blank"><i class="icon-facebook"></i> Everything to Do NYC Group</a>
Sign Up
<a class="button btn_1" href="/register.cfm"><i class="icon-email"></i> Weekly Event Newsletter</a>
</div>
</div>
</div>
<!---
<div id="savings-section" class="white_bg" style="">
<div class="container margin_60">
<div class="main_title">
<h2>New York City <span>Savings & Discounts</span></h2>
</div>
<div class="wow zoomIn fadeIn" data-wow-delay="0.3s">
<div class="row">
<div class="col-lg-12 mb-35">
<div class="ribbon ribbon_special"><span>Discounts</span>
</div>
<section class="featured-block">
<div class="row">
<div class="col-12 border-bottom mb-10">
<h3><strong>Coupons & Discounts </strong></h3>
<p>Save money during your NYC vacation with coupons and
discounts.</p>
</div>
<div class="col-12 featured-section">
<div class="row">
<cfquery name="getdiscounts" datasource="cg22">
select
id,itemname,expire,description,trackingpixel,photo,storylink
from ListingsCoupons where mag = 1 and expire >
#currentdatetime#
and storylink <> ''
order by rand()
limit 0,4
</cfquery>
<cfoutput query="getdiscounts">
<!--REPEATER For each discount-->
<div class="col-lg-6">
<div class="row">
<div class="col-md-4 image-container mobile-hide"> <a href="#rereplace(storylink,'http://www','https://www','all')#"> <img
class="thumbnail-image" src="#rereplace(photo,'http:','https:')#"
alt="Image"></a></div>
<div class="col-md-8">
<h5>#getdiscounts.itemname# </h5>
<div class="row">
<div class="col-sm-12 description-section" style="min-height:90px">
<p>#description# </p>
<a href="#rereplace(storylink,'http://www','https://www','all')#"
class="button btn_1 white">Get
it Now</a>
</div>
</div>
</div>
<div class="col-12"><hr></div></div>
</div>
</cfoutput>
</div>
</div>
<div class="col-12">
<p class="text-center"><a href="/discounts/" class="btn_1">View
All
<span id="dealCount"></span></a>
</p>
</div>
</div>
</section>
</div>
</div>
</div>
</div>
</div>
--->
<div class="container">
<div class="banner mb-0">
<div class="extra-small-ad"><div id='div-gpt-ad-1548258286998-CG-Homepage320'>
<script>
googletag.cmd.push(function () {
googletag.display('div-gpt-ad-1548258286998-CG-Homepage320');
});
</script>
</div></div>
<div class="small-ad"><div id='div-gpt-ad-1548258286998-CG-Homepage320'>
<script>
googletag.cmd.push(function () {
googletag.display('div-gpt-ad-1548258286998-CG-Homepage320');
});
</script>
</div></div>
<div class="medium-ad"><div id='div-gpt-ad-1548258286998-CG-Homepage728'>
<script>
googletag.cmd.push(function () {
googletag.display('div-gpt-ad-1548258286998-CG-Homepage728');
});
</script>
</div></div>
<div class="large-ad"><div id='div-gpt-ad-1548258286998-CG-Homepage970'>
<script>
googletag.cmd.push(function () {
googletag.display('div-gpt-ad-1548258286998-CG-Homepage970');
});
</script>
</div>
</div>
</div>
</div>
<div class="white_bg">
<div class="container margin_60">
<div class="main_title">
<h2>New York City <span>Activities</span></h2>
<p class="mb-30 mobile-hide">Since 1982, City Guide has been the Big Apple's
authority on
tourism, trip planning, and everything to do in New York City.</p>
</div>
<div class="wow zoomIn fadeIn activity-grid" data-wow-delay="0.3s">
<div class="row">
<div class="col-6 col-sm-6 col-md-4 mb-60">
<a href="/sightseeing/">
<div class="box_style_2" style="background-image: url('https://www.cityguideny.com/heads/unnamed.jpg');">
<h4 class="category-title">Sightseeing/Tours</h4>
</div>
</a>
</div>
<div class="col-6 col-sm-6 col-md-4 mb-60">
<a href="/cultural-arts/">
<div class="box_style_2" style="background-image: url('https://www.cityguideny.com/heads/dan flavin guggenheim night (1).jpg');">
<h4 class="category-title">Museums/Culture</h4>
</div>
</a>
</div>
<div class="col-6 col-sm-6 col-md-4 mb-60">
<a href="/theater/">
<div class="box_style_2" style="background-image: url('https://www.cityguideny.com/heads/Jessica.Vosk.as.Elphaba.2.Photo.by.Joan.Marcus._v1_current (1).jpg');">
<h4 class="category-title">Theatre</h4>
</div>
</a>
</div>
<div class="col-6 col-sm-6 col-md-4 mb-60">
<a href="/restaurants/">
<div class="box_style_2" style="background-image: url('https://www.cityguideny.com/heads/Del Friscos Double Eagle Steak House_Bone-In Ribeye.jpg');">
<h4 class="category-title">Restaurants</h4>
</div>
</a>
</div>
<div class="col-6 col-sm-6 col-md-4 mb-60">
<a href="/nightlife/">
<div class="box_style_2" style="background-image: url('https://www.cityguideny.com/heads/comedy hp 350x2002.jpg');">
<h4 class="category-title">Nightlife/Entertainment</h4>
</div>
</a>
</div>
<div class="col-6 col-sm-6 col-md-4 mb-60">
<a href="https://2019.cityguideny.com/articles/neighborhoods">
<div class="box_style_2" style="background-image: url('https://www.cityguideny.com/heads/chinatown.jpg');">
<h4 class="category-title">Neighborhoods</h4>
</div>
</a>
</div>
<div class="col-6 col-sm-6 col-md-4 mb-60">
<a href="https://2019.cityguideny.com/articles/city-secrets">
<div class="box_style_2" style="background-image: url('https://www.cityguideny.com/heads/seb-159444-unsplash (1).jpg');">
<h4 class="category-title">City Secrets</h4>
</div>
</a>
</div>
<div class="col-6 col-sm-6 col-md-4 mb-60">
<a href="/shopping/">
<div class="box_style_2" style="background-image: url('https://www.cityguideny.com/heads/2198328968_fd514cc0db_o (1).jpg');">
<h4 class="category-title">Shopping</h4>
</div>
</a>
</div>
<div class="col-6 col-sm-6 col-md-4 mb-60">
<a href="/services/">
<div class="box_style_2" style="background-image: url('https://www.cityguideny.com/heads/image1 (1).jpg');">
<h4 class="category-title">Services</h4>
</div>
</a>
</div>
</div>
</div>
</div>
</div>
<div class="bg_light">
<div class="container margin_60">
<div class="main_title">
<h2>What's <span>Happening</span> in New York City</h2>
<p class="mobile-hide">The latest happenings</p>
</div>
<div class="wow zoomIn fadeIn" data-wow-delay="0.3s">
<div class="row">
<cfquery name="getcolumns" datasource="#dsro#"
cachedwithin="#createtimespan(0,0,30,0)#">
SELECT distinct columntable.id as colid, columntable.Title,
columntable.Blurb, columntable.DatePosted,
columntable.MainSwap,imageheadline,imagecaption,
columntable.seo_friendly,imageurlbig
FROM columntable inner join columntableimages on columntable.id =
columntableimages.colid
where columntable.status = 1 and
mag = 1
and imageurlbig <> ''
and mainpage = 1
and stopdate > #currentdatetime#
order by columntable.dateposted desc
limit 0,1
</cfquery>
<cfquery name="getcolumns2" datasource="#dsro#"
cachedwithin="#createtimespan(0,0,30,0)#">
SELECT distinct columntable.id as colid, columntable.Title,
columntable.Blurb, columntable.DatePosted,
columntable.MainSwap,imageheadline,imagecaption,
columntable.seo_friendly,imageurl
FROM columntable inner join columntableimages on columntable.id =
columntableimages.colid
where columntable.status = 1 and
mag = 1
and stopdate > #currentdatetime#
and imageurl <> ''
and mainpage = 1
order by columntable.dateposted desc
limit 0,4
</cfquery>
<div class="col-xl-5">
<cfoutput query="Getcolumns">
<!--The main article -->
<div class="main-featured-article-image"><a
href="/article/#seo_friendly#"><img
class="responsive" src="#rereplace(imageurlbig,'http:','https:')#" alt="" /></a>
</div>
<h4 class="category-title"><a
href="/article/#seo_friendly#">#imageheadline#</a>
</h4>
<p class="description">#imagecaption#</p>
<!--END The main article -->
</div>
</cfoutput>
<div class="col-xl-7">
<div class="row">
<cfoutput query="Getcolumns2">
<div class="col-lg-6">
<div class="featured-article-image"><a
href="/article/#seo_friendly#"><img
class="responsive" src="#rereplace(imageurl,'http:','https:')#"
alt="" /></a>
</div>
<h4 class="category-title"><a
href="/article/#seo_friendly#">#imageheadline#</a>
</h4>
<p class="description">#imagecaption#</p>
</div>
</cfoutput>
</div>
</div>
</div>
</div>
</div>
<div class="white_bg">
<div class="container margin_60">
<div class="main_title">
<h2>Your New York <span>City Guide</span> Resource</h2>
<p>
Your one stop source for the best deals, events and things to do in New York
City
</p>
</div>
<div class="wow zoomIn fadeIn" data-wow-delay="0.3s">
<div class="row">
<div class="col-md-6 text-center">
<cfquery name="getc" datasource="#ds#">
select copy from columntable where id = 157740
</cfquery>
<cfoutput>#getc.copy#</cfoutput><!---
<p><a href="https://www.cityguideny.com/article/best-new-york-observatories-one-world-top-of-the-rock-empire-state-building" target="_blank"><img class="img-fluid print-magazine" alt="observation decks city guide cover" height="600" src="https://www.cityguideny.com/uploads2/151483/files/wk2-ObservationDecks-1.jpg" width="392" /></a></p>--->
</div>
<div class="col-md-6">
<h3><span>Be in the know</span> with City Guide</h3>
<p>
Connect with us and be the first to know about special deals and new events.
</p>
<ul class="list_order">
<li><span>1</span><a href="/register.cfm"> <strong>Sign Up </strong></a> for our
newsletter and get
the
latest news
and deals</li>
<li><span>2</span><a href="https://www.facebook.com/groups/everythingtodonyc/" target="_new"> <strong>Join </strong></a> our group
on
Facebook for the
latest events
and happenings </li>
<li><span>3</span><a href="https://www.facebook.com/CityGuideNY/" target="_new"> <strong>Follow Us </strong></a> us on
Facebook for the
best
insider
information</li>
</ul>
</div>
</div>
</div>
</div>
</div>
<section class="bg-white sub-footer">
<div class="container">
<div class="footer-wrapper" style="max-width:800px;margin:0 auto; margin-bottom: 30px;">
<h3 class="inset-box-title strong">Looking for...?</h3>
<div class="inset-box-wrapper row align-center text-center" style="box-shadow:none">
<div class="col-sm-4"><a class="block button btn_1" href="/discounts/">Discounts</a></div>
<div class="col-sm-4"><a class="block button btn_1" href="/activities/">Activities</a></div>
<div class="col-sm-4"><a class="block button btn_1" href="/events/">Calendar</a></div>
</div>
</div>
<div class="footer-wrapper" style="max-width:800px;margin:0 auto">
<h3 class="inset-box-title strong">Be in the Know</h3>
<div class="inset-box-wrapper row align-center text-center" style="box-shadow:none">
<div class="col-sm-6">
<a class="button btn_1" href="https://www.facebook.com/groups/everythingtodonyc/" target="_blank"><i class="icon-facebook"></i> Everything to Do NYC Group</a>
</div>
<div class="col-sm-6">
<a class="button btn_1" href="/register.cfm"><i class="icon-email"></i> Weekly Event
Newsletter</a>
</div>
</div>
</div>
</div>
</div>
</main> </div>
</div>
<footer class="revealed">
<div class="container">
<div class="row">
<div class="col-md-3">
<h3>City Guide</h3>
<a href="/contact.cfm" id="email_footer">Contact Us</a>
<ul>
<li> <a href="https://www.facebook.com/groups/everythingtodonyc/">Join Our Facebook Group Everything to Do NYC</a></li></ul>
</div>
<div class="col-md-3">
<h3>Discover</h3>
<ul>
<li><a href="/events/">Events</a></li>
<li><a href="/article/what-to-do-in-nyc">Things to Do</a></li>
<li><a href="/articles/neighborhoods">New York Neighborhoods</a></li>
<li><a href="https://www.thoughtgallery.org/">Thought Gallery</a></li>
</ul>
</div>
<!---
<div class="col-md-3">
<h3>More Resources</h3>
<ul>
<li><a href="https://www.nymetroparents.com/">NYMetroParents</a></li>
<li><a href="https://www.mitzvahmarket.com/">Mitzvah Market</a></li>
<li><a href="https://www.metrosource.com/">Metrosource</a></li>
</ul>
</div>--->
<div class="col-md-3">
<h3>About</h3>
<ul>
<li><a href="/advertise.cfm">Advertise</a></li>
<li><a href="/addcalendar.cfm">Submit an Event</a></li>
<li><a href="https://www.davlermedia.com/index.php/career/" target="_new">Careers</a></li>
<li><a href="https://www.davlermedia.com" target="_new">Company News</a></li>
</ul>
</div>
</div>
<div class="row">
<div class="col-md-12">
<div id="social_footer">
<ul>
<li><a href="https://www.facebook.com/CityGuideNY/" target="_blank"><i class="icon-facebook"></i></a></li>
<li><a href="https://www.twitter.com/CityGuideNY/"><i class="icon-twitter"></i></a></li>
<li><a href="https://www.instagram.com/CityGuideNY/"><i class="icon-instagram"></i></a></li>
<li><a href="https://www.pinterest.com/CityGuideNY/"><i class="icon-pinterest"></i></a></li>
</ul>
<p>All Materials Copyright © <cfoutput>#dateformat(currentdatetime,'yyyy')#</cfoutput> Davler Media Group, LLC</p>
<p><a href="/privacy.cfm">Privacy Policy</a> | <a href="/tos.cfm">Terms and Conditions</a></p>
</div>
</div>
</div>
</div>
</footer>
<div id="toTop"></div>
<div class="search-overlay-menu">
<span class="search-overlay-close"><i class="icon_set_1_icon-77"></i></span>
<form role="search" id="searchform" method="get" action="/sitesearch.cfm">
<input type="hidden" name="cx" value="008158698637091872551:5mr94wjwyvq" />
<input type="hidden" name="cof" value="FORID:11" />
<input type="hidden" name="ie" value="UTF-8" />
<input value="" name="q" type="search" placeholder="Search..." />
<button type="submit"><i class="icon_set_1_icon-78"></i>
</button>
</form>
</div>
<script src="/js/jquery-2.2.4.min.js"></script>
<script src="/js/common_scripts_min.js"></script>
<script src="/js/functions.js"></script>
<script src="/js/cat_nav_mobile.js"></script>
<script>
$('.tablet-plus-hide #cat_nav').mobileMenu();
</script>
<script src="js/cat_nav_mobile.js"></script>
<script>
$('#cat_nav').mobileMenu();
</script>
<!-- This site is converting visitors into subscribers and customers with OptinMonster - https://optinmonster.com --> <script>(function(d,u,ac){var s=d.createElement('script');s.type='text/javascript';s.src='https://a.omappapi.com/app/js/api.min.js';s.async=true;s.dataset.user=u;s.dataset.account=ac;d.getElementsByTagName('head')[0].appendChild(s);})(document,90670,101302);</script> <!-- / https://optinmonster.com -->
</body></html>