| 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/newadmin/ |
Upload File : |
<Cfset today = '#dateformat(currentdatetime,'yyyy-mm-dd')#'>
<Cfset last30 = dateadd('d',-30,currentdatetime)>
<Cfset last30 = '#dateformat(last30,'yyyy-mm-dd')#'>
<Cfset last60 = dateadd('d',-60,currentdatetime)>
<Cfset last60 = '#dateformat(last60,'yyyy-mm-dd')#'>
<Cfset last90 = dateadd('d',-90,currentdatetime)>
<Cfset last90 = '#dateformat(last90,'yyyy-mm-dd')#'>
<Table cellpadding="4"><Tr bgcolor="b20223">
<Td width="25%">
<font color="white" face="verdana" size="-1">
<b>TOP 250 TODAY</b></font>
</Td>
<Td width="25%">
<font color="white" face="verdana" size="-1">
<b>TOP 250 LAST 30 DAYS</b></font>
</Td>
<Td width="25%">
<font color="white" face="verdana" size="-1">
<b>TOP 250 LAST 60 DAYS</b></font>
</Td>
<!--- <Td width="25%">
<font color="white" face="verdana" size="-1">
<b>TOP 250 LAST 90 DAYS</b></font>
</Td>--->
</Tr>
<tr>
<td valign="top">
<table border="0" cellpadding="2" cellspacing="0" width="100%"><Tr bgcolor="black">
<Td width="50%" valign="top">
<font color="white" face="verdana" size="-1">
<b>ARTICLE</b></font>
</td></tr>
<Tr>
<Cfquery name="geter" dataSource="#ds#">
select sum(ArticleStats.views) as counter
from ArticleStats
<Cfif parameterexists(url.cat)>
inner join regionstable on regionstable.colid = ArticleStats.showid
</cfif>
where 1 =1
and showdate >= '#today#'
<Cfif parameterexists(url.cat)>
and regionstable.regionsid = #Url.cat#
</cfif>
</cfquery>
<tr><Td><font face="verdana" size="-2">
<b>Total Views -
<Cfoutput><cfset zz = #geter.counter# * 1.2> #round(zz)#</Cfoutput></b>
</Td>
</tr>
<td valign="top">
<Cfquery name="geter" dataSource="#ds#">
select ArticleStats.showid, sum(ArticleStats.views) as counter, columntable.title,columntable.dateposted
from ArticleStats inner join columntable on ArticleStats.showid = columntable.id
<Cfif parameterexists(url.cat)>
inner join regionstable on regionstable.colid = ArticleStats.showid
</cfif>
where showdate >= '#today#'
and columntable.mag = 1 and columntable.columnnum <> 803
<cfif parameterexists(url.reg)>
and (columntable.region = '#url.reg#' or columntable.title like '%#url.reg#%')
</cfif>
<Cfif parameterexists(url.cat)>
and regionstable.regionsid = #Url.cat#
</cfif>
group by showid
order by counter desc
limit 0,250
</cfquery>
<table width="100%" border="1" cellpadding="2" cellspacing="0"><cfoutput query="geter"><Cfif #title# does not contain 'CG:'>
<Tr><td valign="top"><font face="verdana" size="-2"><a href="http://cityguideny.com/story.cfm?colid=#showid#">#title#</a></td><td valign="top"><font face="verdana" size="-2">#dateformat(dateposted,'m/d/yyyy')#</td><td valign="top"><font face="verdana" size="-2"><cfset zz = #geter.counter# * 1.3> #round(zz)#</b>
</td></Tr></cfif>
</cfoutput>
</table>
</td>
</tr></table>
</td>
<td valign="top">
<table border="0" cellpadding="2" cellspacing="0"><Tr bgcolor="black">
<Td width="50%" valign="top">
<font color="white" face="verdana" size="-1">
<b>ARTICLE</b></font>
</td></tr>
<Tr>
<Cfquery name="geter" dataSource="#ds#">
select sum(ArticleStats.views) as counter
from ArticleStats
<Cfif parameterexists(url.cat)>
inner join regionstable on regionstable.colid = ArticleStats.showid
</cfif>
where showdate >= '#last30#'
<Cfif parameterexists(url.cat)>
and regionstable.regionsid = #Url.cat#
</cfif>
</cfquery>
<tr><Td><font face="verdana" size="-2">
<b>Total Views - <Cfoutput><cfset zz = #geter.counter# * 1.2> #round(zz)#</Cfoutput></b>
</b>
</Td>
</tr>
<Tr>
<td valign="top">
<Cfquery name="geter" dataSource="#ds#">
select ArticleStats.showid, sum(ArticleStats.views) as counter, columntable.title,columntable.dateposted
from ArticleStats inner join columntable on ArticleStats.showid = columntable.id
<Cfif parameterexists(url.cat)>
inner join regionstable on regionstable.colid = ArticleStats.showid
</cfif>
where showdate >= '#last30#'
and columntable.mag = 1 and columntable.columnnum <> 803
<cfif parameterexists(url.reg)>
and (columntable.region = '#url.reg#' or columntable.title like '%#url.reg#%')
</cfif>
<Cfif parameterexists(url.cat)>
and regionstable.regionsid = #Url.cat#
</cfif>
group by showid
order by counter desc
limit 0,250
</cfquery>
<table width="100%" border="1" cellpadding="2" cellspacing="0"><cfoutput query="geter"><Cfif #title# does not contain 'CG:'>
<Tr><td valign="top"><font face="verdana" size="-2"><a href="http://cityguideny.com/story.cfm?colid=#showid#">#title#</a></td><td valign="top"><font face="verdana" size="-2">#dateformat(dateposted,'m/d/yyyy')#</td><td valign="top"><font face="verdana" size="-2"><cfset zz = #geter.counter# * 1.3> #round(zz)#</td></Tr>
</cfif></cfoutput>
</table>
</td>
</tr></table>
</td>
<td valign="top">
<table border="0" cellpadding="2" cellspacing="0"><Tr bgcolor="black">
<Td width="50%" valign="top">
<font color="white" face="verdana" size="-1">
<b>ARTICLE</b></font>
</td></tr>
<Tr>
<Cfquery name="geter" dataSource="#ds#">
select sum(ArticleStats.views) as counter
from ArticleStats
<Cfif parameterexists(url.cat)>
inner join regionstable on regionstable.colid = ArticleStats.showid
</cfif>
where showdate >= '#last60#'
<Cfif parameterexists(url.cat)>
and regionstable.regionsid = #Url.cat#
</cfif>
</cfquery>
<tr><Td><font face="verdana" size="-2">
<b>Total Views - <Cfoutput><cfset zz = #geter.counter# * 1.2> #round(zz)#</Cfoutput></b>
</b>
</Td>
</tr>
<Tr>
<td valign="top">
<Cfquery name="geter" dataSource="#ds#">
select ArticleStats.showid, sum(ArticleStats.views) as counter, columntable.title,columntable.dateposted
from ArticleStats inner join columntable on ArticleStats.showid = columntable.id
<Cfif parameterexists(url.cat)>
inner join regionstable on regionstable.colid = ArticleStats.showid
</cfif>
where showdate >= '#last60#'
and columntable.mag = 1 and columntable.columnnum <> 803
<Cfif parameterexists(url.cat)>
and regionstable.regionsid = #Url.cat#
</cfif>
<cfif parameterexists(url.reg)>
and (columntable.region = '#url.reg#' or columntable.title like '%#url.reg#%')
</cfif>
group by showid
order by counter desc
limit 0,250
</cfquery>
<table width="100%" border="1" cellpadding="2" cellspacing="0"><cfoutput query="geter"><Cfif #title# does not contain 'CG:'>
<Tr><td valign="top"><font face="verdana" size="-2"><a href="http://cityguideny.com/story.cfm?colid=#showid#">#title#</a></td><td valign="top"><font face="verdana" size="-2">#dateformat(dateposted,'m/d/yyyy')#</td><td valign="top"><font face="verdana" size="-2"><cfset zz = #geter.counter# * 1.3> #round(zz)#</td></Tr>
</cfif></cfoutput>
</table>
</td>
</tr></table>
</td>
<!---
<td valign="top">
<table border="0" cellpadding="2" cellspacing="0"><Tr bgcolor="black">
<Td width="50%" valign="top">
<font color="white" face="verdana" size="-1">
<b>ARTICLE</b></font>
</td></tr>
<Tr>
<Cfquery name="geter" dataSource="#ds#">
select sum(ArticleStats.views) as counter
from ArticleStats
<Cfif parameterexists(url.cat)>
inner join regionstable on regionstable.colid = ArticleStats.showid
</cfif>
where showdate >= '#last90#'
<Cfif parameterexists(url.cat)>
and regionstable.regionsid = #Url.cat#
</cfif>
</cfquery>
<tr><Td><font face="verdana" size="-2">
<b>Total Views - <Cfoutput><cfset zz = #geter.counter# * 1.4> #round(zz)#</Cfoutput></b></b>
</Td>
</tr>
<Tr>
<td valign="top">
<Cfquery name="geter" dataSource="#ds#">
select ArticleStats.showid, sum(ArticleStats.views) as counter, columntable.title,columntable.dateposted
from ArticleStats inner join columntable on ArticleStats.showid = columntable.id
<Cfif parameterexists(url.cat)>
inner join regionstable on regionstable.colid = ArticleStats.showid
</cfif>
where showdate >= '#last90#'
and columntable.mag = 1 and columntable.columnnum <> 803
<Cfif parameterexists(url.cat)>
and regionstable.regionsid = #Url.cat#
</cfif>
<cfif parameterexists(url.reg)>
and (columntable.region = '#url.reg#' or columntable.title like '%#url.reg#%')
</cfif>
group by showid
order by counter desc
limit 0,250
</cfquery>
<table width="100%" border="1" cellpadding="2" cellspacing="0"><cfoutput query="geter"><Cfif #title# does not contain 'CG:'>
<Tr><td valign="top"><font face="verdana" size="-2"><a href="http://cityguideny.com/story.cfm?colid=#showid#">#title#</a></td><td valign="top"><font face="verdana" size="-2">#dateformat(dateposted,'m/d/yyyy')#</td><td valign="top"><font face="verdana" size="-2"><cfset zz = #geter.counter# * 1.4> #round(zz)#</td></Tr>
</cfif></cfoutput>
</table>
</td>
</tr></table>
</td>
--->
</tr>
</table>