| 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 : |
<Cfif not parameterexists(url.article)><cflocation url="https://www.cityguideny.com/activities/" addToken="no"></Cfif>
<Cfquery name="Getme" dataSource="#ds#">select tablename from cgmaster where seo_friendly = '#url.article#'
</cfquery>
<cfparam name="url.table" default="#getme.tablename#">
<cfif #url.table# eq '' or not parameterexists(url.table)>
<cfset #url.table#='Theater'>
</cfif>
<cfif #url.table# eq 'shopping'>
<cfset #url.table#='Shopping'>
</cfif>
<cfif #url.table# eq 'culturalarts'>
<cfset #url.table#='CulturalArts'>
</cfif>
<cfif #url.table# eq 'restaurants'>
<cfset #url.table#='Restaurants'>
</cfif>
<Cfif len(url.table) lt 3>
<cfset #url.table#='Theater'>
</cfif>
<Cfif #url.table# eq 'toursattractions'>
<cfset #url.table#='ToursAttractions'>
</cfif>
<Cfif #url.table# eq 'theater'>
<cfset #url.table#='Theater'>
</cfif>
<Cfif #Url.table# is not 'ToursAttractions' and #url.table# is not 'Galleries' and #url.table# is not 'CulturalArts' and
#url.table# is not 'Nightlife' and #url.table# is not 'Theater' and #url.table# is not 'Restaurants' and #url.table#
is not 'Shopping' and #url.table# is not 'CarServices' and #url.table# is not 'FamilyFun' and #url.table# is
not 'RealEstate' and #url.table# is not 'BeautyHealth' and #url.table# is not 'Travel' and #url.table# is
not 'Museums' and #url.table#
is not 'Services' and #url.table#
is not 'LuggageStorage' >
<cfoutput>#url.table#</cfoutput>
1 <Cfabort>
</cfif>
<cfquery name="getlistings" datasource="#ds#" >
select
id,name,address,city,state,zip,catid,seo_friendly,description,website,socialfb,socialig,phone,advertiser,fulldescription,enhancedlisting,trackingpixel,ccainfo,metatitle,socialtt,ticketlink,maplink
from #url.table#
<cfif parameterexists(url.article)>
where seo_friendly = '#url.article#'
<Cfelse>
where id = #getlistings.id#
</Cfif>
limit 0,1
</cfquery>
<script type="application/ld+json">
{
"@context": "http://schema.org",
"@type": "LocalBusiness",
"address": {
"@type": "PostalAddress",
"addressLocality": "<cfoutput>#getlistings.city#</cfoutput>",
"addressRegion": "<cfoutput>#getlistings.state#</cfoutput>",
"streetAddress": "<cfoutput>#getlistings.address#</cfoutput>"
},
"description": "<cfoutput>#getlistings.description#</cfoutput>",
"name": "<cfoutput>#getlistings.name#</cfoutput>",
"telephone": "<cfoutput>#getlistings.phone#</cfoutput>"
}
</script>
<cfquery name="getmastercat" dataSource="#ds#">
select SubCatID,SubCatName
from _SubCat
where SubCatTableName = '#url.table#'
</cfquery>
<cfif #getlistings.recordcount# eq 0>
<cfoutput></cfoutput>
2<cfabort></cfif>
<!---
<cfquery name="getsubcat" dataSource="#ds#">
select Cat from Cat#url.table#
where Catid = #getlistings.catid#
</cfquery>--->
<cfset today=#DateFormat(now(),"yyyy-mm-dd")#>
<Cfset yesterday=#dateadd('d',-1,today)#>
<Cfset yesterdayb=#dateadd('d',-2,today)#>
<cfset yesterday=#DateFormat(yesterday,"yyyy-mm-dd")#>
<cfset yesterdayb=#DateFormat(yesterdayb,"yyyy-mm-dd")#>
<cfquery name="getstats" datasource="#ds#">
select id from ListingsStats
where id > 41810000 and showdate = '#today#' and showid = #getlistings.id# and tablename = '#url.table#'
</cfquery>
<Cfif #getstats.recordcount# gt 0>
<cfquery name="updatehits" datasource="#ds#">
INSERT delayed INTO columntemp5listing(photoid)
VALUES (#getlistings.id#)
</cfquery>
<cfelse>
<cfquery name=addphoto datasource="#ds#">
INSERT INTO ListingsStats (showid,showdate,views,tablename,mag)
VALUES (#getlistings.id#,'#today#',1,'#url.table#',1)
</cfquery>
</CFIF>
<CFQUERY name="wb" datasource="#ds#" cachedwithin="#createtimespan(0,1,0,0)#">
select columntext_cg.id,columntext_cg.id as
colid,columntext_cg.title,columntable.MainSwap,columntext_cg.blurb,columntable.seo_friendly from columntext_cg inner
join columntable on columntable.id = columntext_cg.id
<cfif #getlistings.name# contains 'intrepid'>
where (match (columntext_cg.title,columntext_cg.copy) against ('"Intrepid"' IN BOOLEAN MODE)
<cfelseif #getlistings.name# contains 'Del Frisco'>
where (match (columntext_cg.title,columntext_cg.copy) against ('"Del Frisco"' IN BOOLEAN MODE)
<cfelseif #getlistings.name# contains 'Escape to Margarit'>
where (match (columntext_cg.title,columntext_cg.copy) against ('"Del Frisaaaco"' IN BOOLEAN MODE)
<cfelseif #getlistings.name# contains 'Pretty Woman: The Musical'>
where (match (columntext_cg.title,columntext_cg.copy) against ('"Pretty Woman"' IN BOOLEAN MODE)
<cfelseif #getlistings.name# contains 'Frozen'>
where (match (columntext_cg.title,columntext_cg.copy) against ('"St. James Theatre"' IN BOOLEAN MODE)
and (match (columntext_cg.title,columntext_cg.copy) against ('"Frozen"' IN BOOLEAN MODE))
<cfelse>
where (match (columntext_cg.title,columntext_cg.copy) against ('"#getlistings.name#"' IN BOOLEAN
MODE)
</cfif>
<!---
<cfif #right(getlistings.name,1)# is not 's'>
or match (columntext_cg.title,columntext_cg.copy) against ('"#getlistings.name#s"' IN BOOLEAN MODE)
</cfif>--->
)
<cfif #getlistings.name# eq 'Crocs'>
and columntext_cg.id <> 120826
</cfif>
and stopdate > #currentdatetime#
and year(columntext_cg.dateposted) > 2019
order by id desc
limit 0,15
</CFQUERY>
<cfsavecontent variable="headercontent">
<cfoutput><title><Cfif #getlistings.metatitle# is not ''>#getlistings.metatitle#<cfelse>#getlistings.name#</Cfif></title>
<meta name="description" content="#getlistings.description#">
</cfoutput>
</cfsavecontent>
<cfinclude template="header.cfm">
<Cfif #url.table# eq 'CulturalArts'>
<Cfset pixelme = 'Cultural Arts'>
<cfelseif #url.table# eq 'Restaurants'>
<Cfset pixelme = 'Dining'>
<cfelseif #url.table# eq 'ToursAttractions'>
<Cfset pixelme = 'Sightseeing'>
<cfelse>
<Cfset pixelme = '#url.table#'>
</Cfif>
<cfoutput>
<script>
gtag('event', '#pixelme#', {
'event_category': 'Category',
'event_label': 'Listing',
'send_to': ['UA-642804-22'],
'value': '#pixelme#'
});
</script>
</cfoutput>
<!---
<Cfoutput>
<img src="https://www.google-analytics.com/collect?v=1&tid=UA-642804-2&cid=555&aip=1&t=event&ec=Category&ea=#pixelme#&el=Listing&dp=Listing&dt=#pixelme#">
</Cfoutput>---->
<cfinclude template="rossavings.cfm">
<main>
<div class="container">
<div class="row">
<cfquery name="getbread" dataSource="#ds#">select * from homepagecatman where tablename =
'#url.table#'</cfquery>
<div class="col-12 breadcrumb-section"><a href="/activities/">Activities</a> <span class=" icon-angle-right"></span> <cfoutput><a
href="/#getbread.dirme#/">#getmastercat.SubCatName#</cfoutput>
Listings</a> </div>
<div class="col-12">
<div class="main_title">
<h2><span>
<cfoutput>#getmastercat.SubCatName#</cfoutput>
</span> Listings</h2>
</div>
</div>
</div>
<div class="row">
<aside class="col-lg-3 mobile-hide">
<cfinclude template="/rosboxcats.cfm">
<center>
<div id='div-gpt-ad-1548258286998-2' style='width:300px;height:250px;'>
<script>
googletag.cmd.push(function () {
googletag.display('div-gpt-ad-1548258286998-2');
});
</script>
</div>
</center>
<div class="mobile-hide mb-20">
<center>
<div id='div-gpt-ad-1548258286998-4' style='width:300px;height:250px;'>
<script>
googletag.cmd.push(function () {
googletag.display('div-gpt-ad-1548258286998-4');
});
</script>
</div>
</center>
</div>
</aside>
<div class="col-lg-9">
<div class="box_style_1">
<div class="post nopadding">
<!-- ARTICLE -->
<cfoutput query="getlistings">
<cfif parameterexists(cookie.email) and (cookie.email IS NOT -1) and (cookie.email contains 'davlermedia' or cookie.email contains 'broadwayworld')>
<a href="/newadmin/listingsedit.cfm?id=#getlistings.id#&table=#url.table#&requesttimeout=50000"><div style="float:right;border-width: 1px;background-color:black;color:white;padding:10px;">Edit Listing</div></a></cfif>
<!-- Article Title -->
<h1 id="articleTitle">#name#</h1>
<Cfif #address# is not ''><span>#address# <cfset gaddress=rereplace (address,' ','
+','ALL')>
<br>#phone#</span> </cfif>
<cfif #address# eq '' and phone is not ''>
#phone#<Br></cfif>
<!-- Article Meta -->
<div id="articleMeta" class="post_info clearfix">
</div>
<!-- Article Content (example copied from production + added image classes for responsive)-->
<div id="articleContent">
<Cfquery name="findgraphic" datasource="#ds#">
select id,thumbnail
from ListingsPhotos
where tablename='11#url.table#' and itemid=#getlistings.id# and (mag =1 or mag =3)
order by rand()
limit 0,1
</Cfquery>
<cfquery name="getrelated" datasource="cg22">
select id,linktitle,linktype
from ListingsRelated
where tablename='#url.table#' and itemid=#getlistings.id# and (mag =1 or mag =3)
</cfquery>
<cfif #findgraphic.recordcount# gt 0>
<cfoutput>
<cfloop from="1" to="#findgraphic.recordcount#" index="i">
<img
src="https://www.cityguideny.com/listingsphotos/#findgraphic.thumbnail[i]#"
border="0" class="fotgal" hspace=10 width="250"
alt="#getlistings.name#"></a>
</cfloop>
</cfoutput>
</cfif>
<!-- for microsites -->
<div class="button-row">
<cfif #len(getlistings.maplink)# gt 0 > <a class="button btn_1"
href="#getlistings.maplink#"
target="_blank">Map</a></cfif>
<cfif #getrelated.recordcount# gt 1> <a class="button btn_1"
href="/discountrelatedtrack.cfm?id=#getrelated.id#"
target="_blank">Buy Tickets</a></cfif>
<Cfquery name="findcoupon" datasource="#ds#">
select id,expire,description,trackingpixel,seo_friendly,storylink
from ListingsCoupons
where tablename='#url.table#' and itemid=#getlistings.id# and (mag =1)
and expire > #currentdatetime#
order by id desc
limit 0,1
</Cfquery>
<Cfif #findcoupon.recordcount# gt 0>
<a class="button btn_1 white"
href="#findcoupon.storylink#">Get
Coupon</a>
</Cfif>
<cfif #website# is not ''>
<a class="button btn_1 white"
href="/linktrack.cfm?id=#getlistings.id#&table=#url.table#"
target="_blank">Website</a>
</cfif>
<cfif #ticketlink# is not ''>
<a class="button btn_1 white"
href="/linktrack.cfm?id=#getlistings.id#&table=#url.table#&tl=on"
target="_blank">Buy Tickets</a>
</cfif>
<cfif #socialfb# is not ''>
<a class="button btn_1 white"
href="/linktrack.cfm?id=#getlistings.id#&table=#url.table#&fb=on"
target="_blank">Facebook</a>
</cfif>
<cfif #socialig# is not ''>
<a class="button btn_1 white"
href="/linktrack.cfm?id=#getlistings.id#&table=#url.table#&ig=on"
target="_blank">Instagram</a>
</cfif>
<cfif #socialtt# is not ''>
<a class="button btn_1 white"
href="/linktrack.cfm?id=#getlistings.id#&table=#url.table#&tt=on"
target="_blank">TikTok</a>
</cfif>
<!--- <a class="button btn_1 white" href="##group">Group <cfif #url.table# eq 'Restaurants'>Info<cfelse>Tickets</cfif></a>--->
</div>
<Cfif #enhancedlisting# is not ''>
<Cfset
zzz=rereplace(enhancedlisting,'http://cityguideny.com/','http://www.cityguideny.com/','ALL')>
<Cfset
zzz=rereplace(zzz,'http://www.cityguideny.com/','http://www.cityguideny.com/','ALL')>
<cfset zzz = #rereplacenocase(zzz,'<iframe ','<iframe style=" position: relative;border: none;max-width: 100%;max-height: 500px; height: calc(98vw*(9/16));"','all')#>
#zzz# <cfelse>
#paragraphformat(fulldescription)#
</cfif>
</div>
</cfoutput>
<cfif #url.table# eq '11'>
<cfoutput>
<form action="/asktheexperts2.cfm?from=listing-#url.article#" method="post">
</cfoutput>
<input name="Live" value="0" type="hidden">
<input name="currentdatetime" value="<Cfoutput>#currentdatetime#</Cfoutput>" type="hidden">
<a name="group">
<div class="row">
<div class="col-12">
<h3>Looking for free group planning services? </h3>
<p> Get free advice on planning your group's trip to New York.</p>
</div>
<div class="col-lg-6">
<div class="form-group">
<label for="name">Name </label>
<input id="name" size="27" required name="name" type="text"
class="form-control">
</div>
</div>
<div class="col-lg-6">
<div class="form-group">
<label for="email">Email </label>
<input id="email" size="27" required name="email" type="email"
class="form-control">
</div>
</div>
<div class="col-lg-6">
<div class="form-group">
<label for="groupname">Type of Group</label>
<select id="groupname" required name="groupname"
class="form-control">
<option value="">Please Pick One</option>
<option value="Youth">Youth</option>
<option value="Affinity">Affinity</option>
<option value="Celebration">Celebration</option>
<option value="Seniors">Seniors</option>
<option value="Corporate">Corporate</option>
<option value="Other">Other</option>
</select>
</div>
</div>
<div class="col-lg-6">
<div class="form-group">
<label for="numberinparty">Group Size</label>
<select id="numberinparty" name="numberinparty"
class="form-control">
<Cfif #url.table# eq 'ToursAttractions' or #url.table# eq 'Services'>
<option value="6-11">6-11</option>
<cfelse>
<option value="2-11">2-11</option>
</Cfif>
<option value="12 or more">12 or more</option>
</select>
</div>
</div>
<div class="col-lg-12">
<div class="form-group">
<label for="subject">Date of Trip</label>
<input id="subject" name="Subject" type="text" size="20" required
class="form-control">
<input name="Subject_required" type="hidden"
value="You must enter the dates of your trip.">
</div>
</div>
<!--- <div class="col-lg-12"> <label>Areas of Interest</label>
</div>
<div class="col-lg-6">
<div class="form-group">
<ul class="list-items">
<li><input class="form-control" name="questiontype" type="checkbox"
value="Sightseeing" checked="">Sightseeing</li>
<li><input class="form-control" name="questiontype" type="checkbox"
value="Dining"> Dining</li>
<li><input class="form-control" name="questiontype" type="checkbox"
value="Theater"> Theater</li>
<li><input class="form-control" name="questiontype" type="checkbox"
value="Culture"> Culture</li>
</ul>
</div>
</div>
<div class="col-lg-6">
<div class="form-group">
<ul class="list-items">
<li><input class="form-control" name="questiontype" type="checkbox"
value="Shopping"> Shopping</li>
<li><input class="form-control" name="questiontype" type="checkbox"
value="Transportation"> Transportation</li>
<li><input class="form-control" name="questiontype" type="text"
placeholder="Other" size="10"></li>
</ul>
</div>
</div> --->
<div class="col-lg-12">
<div class="form-group">
<label for="blurb">Message</label>
<textarea id="blurb" class="form-control" rows="10" required
name="blurb"
placeholder="What information would you like?"></textarea>
</div>
</div>
<div class="col-lg-12">
<div class="form-group">
Enter the code:
<strong>3972</strong>
<input name="chide" value="3972" type="hidden">
<input class="form-control inline-block" required name="captchaText"
type="text" size="10" maxlength="10">
</div>
</div>
<div class="col-lg-12">
<div class="form-group text-center">
<input class="button btn_1" type="submit" value="Send E-Mail">
</div>
</div>
</div>
</form></cfif>
<!-- ARTICLE END -->
</div>
</div>
<div class="col-12 tablet-plus-hide">
<cfinclude template="rosboxcats.cfm">
</div>
<div class="col-lg-12">
<h3>Related Articles</h3>
</div>
<div class="col-lg-12 strip_all_tour_list" style="display: none;">
<div class="row">
<div class="col-sm-12 col-md-2 no-gutter"><a href="dealurl"
class="button btn_1 white fl-right promo-button"></a></div>
</div>
</div>
<cfoutput query="wb">
<Cfif #title# does not contain 'things to do' and #title# does not contain 'CG:'>
<div class="col-lg-12 strip_all_tour_list">
<div class="row">
<div class="col-md-3 image-container no-gutter">
<Cfif mainswap is not ''>
<a href="/article/#seo_friendly#"><img
class="thumbnail-image-medium"
src="#rereplace(mainswap,'http://','https://','all')#"
alt="#title#"></a>
</Cfif>
</div>
<div class="col-md-7 side-box">
<a href="/article/#seo_friendly#">
<h5>#title# </h5>
</a>
<p>#blurb# </p>
</div>
<div class="col-sm-12 col-md-2 no-gutter"><a
href="/article/#seo_friendly#"
class="button btn_1 white fl-right promo-button">Read</a></div>
</div>
</div>
</Cfif>
</cfoutput>
</div>
</div>
</div>
<cfinclude template="rossavingsbottom.cfm">
</main>
<cfinclude template="footer.cfm">
</body>
</html>