<title>Calendar Link</title>
<h1>Calendar Link</h1>

<cfset userAgent = CGI.HTTP_USER_AGENT />

<!--- Use array to manage user agents for easy updating --->
<cfset excludedAgents = [
    "bot", "spider", "slurp", "crawler", "AhrefsBot", "Baiduspider", 
    "Ezooms", "MJ12bot", "YandexBot", "bingbot", "googlebot", "facebookexternalhit", "verity", "newspaper","Firefox/12.0",
    "MSIE 6", "addthis","ias-va","thetradedesk","58.0","rest-client","2.0.0.13","admantx","Jaunt","centuryb","weborama","github"
] />

<cfset isCrawler = false />

<!--- Loop through each user agent in the exclusion list --->
<cfloop array="#excludedAgents#" index="agent">
    <cfif FindNoCase(agent, userAgent)>
        <cfset isCrawler = true />
        <cfbreak />
    </cfif>
</cfloop>
<cfif NOT isCrawler>


<cfif parameterexists(url.id) and isnumeric(url.id)>

<cfif not parameterexists(url.table)>
<cfabort></cfif>

<cfoutput>
<link rel="canonical"
href="https://www.cityguideny.com/calendarlinktrack.cfm?table=#url.table#&id=#url.id#"></cfoutput>

<h1>Calendar Link</h1>

<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 'ActivityPlanner'

and #url.table# is not 'Travel'
and #url.table# is not 'Museums'>
<Cfabort>
</cfif>

<cfset today=#DateFormat(now(),"yyyy-mm-dd")#>

<cfquery name="checker" datasource="cg22">
    select id from clicktrack 
    where ipadd = '#cgi.remote_addr#' and micrositeid = #url.id#
</cfquery>

<cfif #checker.recordcount# eq 0>

<cfquery name=addphoto datasource="cg22">
INSERT  INTO clicktrack (datetime,micrositeid,ipadd)
VALUES	(#currentdatetime#,#url.id#,'#cgi.remote_addr#')
</cfquery>


<cfquery name="getstats" datasource="#ds#">
select id from CalendarLinkStats
where showdate = '#today#' and showid = #url.id# and mag = 1  and tablename = '#url.table#'
</cfquery>

<Cfif #getstats.recordcount# gt 0>
<CFQUERY datasource="#ds#">
	UPDATE CalendarLinkStats
	SET views = views + 1
	WHERE ID = #getstats.id#
	</CFQUERY>
<cfelse>
<cfquery name=addphoto datasource="#ds#">
INSERT INTO CalendarLinkStats (showid,showdate,views,tablename,mag)
VALUES	(#url.id#,'#today#',1,'#url.table#',1)
</cfquery>

</CFIF>

<Cfif #url.table# eq 'activityplanner'>
<Cfset #url.table# = 'ActivityPlanner'>
</cfif>



<cfif parameterexists(url.buy)>

	
	<cfquery name="getstats" datasource="#ds#">
select id from CalendarLinkStatsBuy
where showdate = '#today#' and showid = #url.id# and mag = 1  and tablename = '#url.table#'
</cfquery>

<Cfif #getstats.recordcount# gt 0>
<CFQUERY datasource="#ds#">
	UPDATE CalendarLinkStatsBuy
	SET views = views + 1
	WHERE ID = #getstats.id#
	</CFQUERY>
<cfelse>
<cfquery name=addphoto datasource="#ds#">
INSERT INTO CalendarLinkStatsBuy (showid,showdate,views,tablename,mag)
VALUES	(#url.id#,'#today#',1,'#url.table#',1)
</cfquery>

</CFIF>
</cfif>
	
<Cfif #url.buy# contains 'http'>
	<cflocation url="#url.buy#" addtoken="no" statuscode="301">
<cfelse>
        <cflocation url="http://#url.buy#" addtoken="no" statuscode="301">

</cfif>
<cfelse>


<cfquery name="getlistings" datasource="#ds#">
select website
from #url.table#
where id = #url.id#
</cfquery>

<Cfif #getlistings.recordcount# eq 0>
<cflocation statuscode="301" url="/" addtoken="no">
</cfif>

<Cfif #getlistings.website# contains 'http'>
<cflocation url="#getlistings.website#" addtoken="no">
<Cfelse>
<cflocation url="http://#getlistings.website#" addtoken="no">
</cfif>

</cfif>

</cfif>

<cfelse>

<cfoutput>
<link rel="canonical"
href="https://www.cityguideny.com/events/"></cfoutput>

</Cfif>