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

<cfif not parameterexists(url.table)>
<cfabort></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'>
<Cfabort>
</cfif>

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

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


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

<Cfif #getstats.recordcount# gt 0>
<CFQUERY datasource="#ds#">
	UPDATE low_priority ListingsLinkStats 
	SET views = views + 1
	WHERE ID = #getstats.id#
	</CFQUERY>
<cfelse>

<Cfif #url.id# gt 1000000 or url.id lt 0>
<cfabort></cfif>

<cfquery name=addphoto datasource="#ds#">
INSERT INTO ListingsLinkStats (showid,showdate,views,tablename,mag)
VALUES	(#url.id#,'#today#',1,'#url.table#',1)
</cfquery>
	
</CFIF>


<cfif parameterexists(url.fb)>
	
<cfquery name="getlistings" datasource="#ds#" cachedwithin="#createtimespan(0,1,3,0)#">
select socialfb as website
from #url.table#
where id = #url.id#
</cfquery>
<cfelseif parameterexists(url.ig)>
<cfquery name="getlistings" datasource="#ds#" cachedwithin="#createtimespan(0,1,3,0)#">
select socialig as website
from #url.table#
where id = #url.id#
</cfquery>

<cfelseif parameterexists(url.tt)>
<cfquery name="getlistings" datasource="#ds#" cachedwithin="#createtimespan(0,1,3,0)#">
select socialtt as website
from #url.table#
where id = #url.id#
</cfquery>

<cfelseif parameterexists(url.tl)>
<cfquery name="getlistings" datasource="#ds#" cachedwithin="#createtimespan(0,1,3,0)#">
select ticketlink as website
from #url.table#
where id = #url.id#
</cfquery>


<cfelse>

<cfquery name="getlistings" datasource="#ds#" cachedwithin="#createtimespan(0,1,3,0)#">
select website
from #url.table#
where id = #url.id#
</cfquery>
</cfif>

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

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

<cfif parameterexists(getlistings.recordcount) and getlistings.recordcount 
eq 0>
<cflocation url="/" addtoken="no" statuscode="301">
</cfif>