| Server IP : 172.67.201.108 / 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 : |
<Cfparam name="url.id" default="1">
<cfif parameterexists(url.strt) and not isnumeric(url.strt)>
<cfabort></cfif>
<cfif parameterexists(url.show) and not isnumeric(url.show)>
<cfabort></cfif>
<Cfif not parameterexists(url.id) or not isnumeric(url.id)>
<Cflocation url="/" addtoken="no" statuscode="301">
</cfif>
<cfquery name="Getme" dataSource="#ds#">
select * from homepagecatman
where id = #url.id#
</cfquery>
<cfif (parameterexists(url.subcat) and len(url.subcat) gt 10) or (parameterexists(url.subcat) and url.subcat contains '=')>
<Cfabort>
</cfif>
<cfif parameterexists(url.subcat) and len(url.subcat) lt 10>
<cfquery name="Getsubcat" dataSource="#ds#">
select cat
FROM Cat#getme.tablename#
where catid = #url.subcat#
</cfquery>
</cfif>
<cfsavecontent variable="headercontent">
<title><Cfoutput><cfif parameterexists(url.subcat)>#getsubcat.cat#</cfif> #getme.name# Listings and Articles</title>
<meta name="description" content="#getme.description#">
</Cfoutput>
</cfsavecontent>
<cfinclude template="header.cfm">
<Cfif #getme.tablename# eq 'CulturalArts'>
<Cfset pixelme = 'Cultural Arts'>
<cfelseif #getme.tablename# eq 'Restaurants'>
<Cfset pixelme = 'Dining'>
<cfelseif #getme.tablename# eq 'ToursAttractions'>
<Cfset pixelme = 'Sightseeing'>
<cfelse>
<Cfset pixelme = '#getme.tablename#'>
</Cfif>
<Cfoutput>
<cfoutput>
<script>
if (typeof gtag === 'function') {
gtag('event', '#pixelme#', {
'event_category': 'Category',
'event_label': 'ListingsCat',
'send_to': ['UA-642804-22'],
'value': '#pixelme#'
});
}
</script>
</cfoutput>
<!---
<img class="google-img" src="https://www.google-analytics.com/collect?v=1&tid=UA-642804-2&cid=555&aip=1&t=event&ec=Category&el=ListingCat&ea=#pixelme#&dp=ListingsCat&dt=#pixelme#">--->
</Cfoutput>
<cfinclude template="rossavings.cfm">
<!-- <div class="container">
<div class="row">
<div class="col-12 text-center"><h4>Be in the know with City Guide. Join our group
<a class="button btn_1" href="https://www.facebook.com/groups/everythingtodonyc/"
target="_blank"><i class="icon-facebook"></i> Everything to Do NYC</a>
Sign Up for our
<a class="button btn_1" href="http://2019.cityguideny.com/register.cfm"><i
class="icon-email"></i> Weekly Event Newsletter</a></h4>
</div>
</div>
</div>-->
<main>
<div class="container">
<div class="row">
<div class="col-12">
<div class="main_title">
<h2><span>
<Cfoutput><cfif parameterexists(url.subcat)>#getsubcat.cat#</cfif> #getme.name#</Cfoutput>
</span> in NYC</h2>
</div>
</div>
</div>
<div class="row">
<aside class="col-lg-3 mobile-hide">
<cfinclude template="rosboxcats.cfm">
<div id='div-gpt-ad-1548258286998-4' style='width:300px;height:250px;'>
<script>
window.googletag = window.googletag || { cmd: [] };
googletag.cmd.push(function () {
googletag.display('div-gpt-ad-1548258286998-4');
});
</script>
</div>
<center>
<div id='div-gpt-ad-1548258286998-6' style='width:300px;height:600px;'>
<script>
window.googletag = window.googletag || { cmd: [] };
googletag.cmd.push(function () {
googletag.display('div-gpt-ad-1548258286998-6');
});
</script>
</div>
</center>
</aside>
<cfparam name="regionid" default="0">
<cfquery name="getmain1" datasource="cg22">
SELECT columntable.id as colid,columnmaster.AuthorName, columntable.Title,
columntable.Blurb,
columntable.DatePosted, columntable.MainSwap,columntable.seo_friendly
FROM columntable INNER JOIN columnmaster ON columntable.ColumnNum = columnmaster.ID
inner join
regionstable on regionstable.colid = columntable.id
WHERE regionstable.regionsid in (#getme.articlecat#) and columntable.status = 1 and
columntable.stopdate >
'#dateformat(currentdatetime,'yyyy-mm-dd')#' and columntable.mainswap <> ''
and columntable.status = 1 and columntable.stopdate >
'#dateformat(currentdatetime,'yyyy-mm-dd')#'
and columntable.stopdate > '#dateformat(currentdatetime,'yyyy-mm-dd')#'
order by columntable.dateposted desc
limit 0,5
</cfquery>
<cfparam name="url.strt" default="1">
<cfparam name="url.show" default="100">
<div class="col-lg-9">
<!--- <h2><Cfoutput>#getme.name#</Cfoutput> Articles</h2> --->
<cfif parameterexists(url.strt) and url.strt lt 2>
<!--- Rob's masterpiece: style="border-width: 4px;border-style: solid;border-color: #254190;" --->
<div class="strip_all_tour_list wow fadeIn" data-wow-delay="0.1s"
style="border: solid 2px #254190">
<div class="row">
<div class="col-lg-4">
<!--flex center removed, image-container wrapper removed -->
<!-- Featured top article photo and description -->
<Cfoutput query="getmain1" maxRows="1"> <a
href="/article/#seo_friendly#"><img
class="image-sizing"
<cfset imag = #rereplacenocase(mainswap,'http://city','https://www.city','all')#> src="#rereplacenocase(imag,'http://www.city','https://www.city','all')#?ModPagespeed=off&cdt=#currentdatetime#</Cfoutput>"
alt="<Cfoutput>#getmain1.title#</Cfoutput>">
<!--- <div class="short_info flex"><span
class="ellipsis-container">
<Cfoutput query="getmain1" maxRows="1">
#title#</Cfoutput>
</span></div>--->
</a>
<!-- End -->
</div>
<div class="col-lg-8 side-box">
<h4 class="strong border-bottom">
<!--- <Cfoutput>#getme.name#</Cfoutput> --->Articles <a
<Cfquery name="Getmorea" dataSource="#ds#">
select seo_friendly from regions where id in (#getme.articlecat#)</Cfquery>
class="strong fl-right font-14"
href="/articles/<cfoutput>#getmorea.seo_friendly#</cfoutput>">View All <Cfoutput>#getme.name#</Cfoutput> Articles</a>
</h4>
<ul class="list-items">
<Cfoutput query="getmain1" maxRows="3" startRow="1">
<!-- REPEATER for each article -->
<li><a href="/article/#seo_friendly#">#title#</a>
</li>
<!-- REPEATER END for each article -->
</Cfoutput>
<li>
</ul>
</div>
</div>
</div>
</cfif>
<h4 class="category-heading">Browse Venues</h4>
<cfset tableme='#getme.tablename#'>
<Cfset dirme='#getme.dirme#'>
<Cfif #url.id# eq 1>
<Cfinclude template="main-categoryincb2.cfm">
<cfelse>
<Cfinclude template="main-categoryincb.cfm">
</cfif>
<div class="col-12 tablet-plus-hide">
<cfinclude template="rosboxcats.cfm">
</div>
<div class="fl-right">
<cfif parameterexists(url.subcat)>
<CF_Search_NextPrevious
QueryRecordCount="#getrecord.RecordCount#"
FileName="/category-page.cfm" MaxresultPages="10"
LINKSTYLE1="page-link" THISPAGESTYLE="page-item active"
ExtraURLString="id=#url.id#&subcat=#url.subcat#"
MaxRowsAllowed="25">
<Cfelse>
<CF_Search_NextPrevious
QueryRecordCount="#getrecord.RecordCount#"
FileName="/category-page.cfm" MaxresultPages="10"
LINKSTYLE1="page-link"
THISPAGESTYLE="page-item active"
ExtraURLString="id=#url.id#" MaxRowsAllowed="25">
</cfif>
</div>
<hr>
<!--- <div class="col-lg-12">
<div id='div-gpt-ad-1548258286998-4' class="ad-300">
<script>
googletag.cmd.push(function () {
googletag.display('div-gpt-ad-1548258286998-4');
});
</script>
</div>
</div>
--->
<!-- Example of pagination -->
<!--- <nav aria-label="Page navigation">
<ul class="pagination justify-content-center">
<li class="page-item">
<a class="page-link" href="#" aria-label="Previous">
<span aria-hidden="true">«</span>
<span class="sr-only">Previous</span>
</a>
</li>
<li class="page-item active"><span class="page-link">1<span class="sr-only">(current)</span></span>
</li>
<li class="page-item"><a class="page-link" href="#">2</a></li>
<li class="page-item"><a class="page-link" href="#">3</a></li>
<li class="page-item">
<a class="page-link" href="#" aria-label="Next">
<span aria-hidden="true">»</span>
<span class="sr-only">Next</span>
</a>
</li>
</ul>
</nav>--->
</div>
</div>
</main>
<cfinclude template="footer.cfm">
</body>
</html>