| 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/newadmin/ |
Upload File : |
<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> <div align="center"><font face=verdana size=+1><strong>NYMP Nav Picker Tester</strong></font></div> <font face=verdana size=-1><br /><br> <Cfquery name="Gettotal" dataSource="#ds#"> select count(id) as total from nympregnavtrack where message not like '%mobile%' </cfquery> <font color="red" size=+2><b> DESKTOP</b></font> <Table cellpadding="8" border="1" cellspacing="0"> <Tr style="background-color: black"> <td style="padding:4px;"> <font color="white"></font> </td> <td style="padding:4px;"> <font color="white">Clicks</font> </td> <td style="padding:4px;"> <font color="white">Percentage</font> </td> </Tr> <cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where message like '%select%' and message not like '%mobile%' </cfquery> <cfoutput query="geter"> <Tr> <Td style="padding:4px;">Select</Td> <Td style="padding:4px;">#geter.counter#</Td> <Td style="padding:4px;"> <center> <cfset per = (geter.counter / #gettotal.total#) * 100> #numberformat(per,'0.00')#% </Td> </Tr> </cfoutput> <cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where message like '%Choose%' and message not like '%mobile%' </cfquery> <cfoutput query="geter"> <Tr> <Td style="padding:4px;">Choose</Td> <Td style="padding:4px;">#geter.counter#</Td> <Td style="padding:4px;"> <center> <cfset per = (geter.counter / #gettotal.total#) * 100> #numberformat(per,'0.00')#% </Td> </Tr> </cfoutput> <cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where message like '%Pick%' and message not like '%mobile%' </cfquery> <cfoutput query="geter"> <Tr> <Td style="padding:4px;">Pick</Td> <Td style="padding:4px;">#geter.counter#</Td> <Td style="padding:4px;"> <center> <cfset per = (geter.counter / #gettotal.total#) * 100> #numberformat(per,'0.00')#% </Td> </Tr> </cfoutput> </Table> <p> <table border="1" cellpadding="4" cellspacing="0" > <Tr> <Td style="padding:4px;"></Td> <Td style="padding:4px;"><b>Manhattan</Td> <Td style="padding:4px;"><b>Brooklyn</Td> <Td style="padding:4px;"><b>Queens</Td> <Td style="padding:4px;"><b>Westchester</Td> <Td style="padding:4px;"><b>Rockland </Td> <Td style="padding:4px;"><b>Nassau</Td> <Td style="padding:4px;"><b>Suffolk</Td> <Td style="padding:4px;"><b>Fairfield</b></Td> </tr> <Tr> <td><b>TOTAL</td> <Td style="padding:4px;"><b><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Manhattan%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td style="padding:4px;"><b><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Brooklyn%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td style="padding:4px;"><b><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Queens%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td style="padding:4px;"><b><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Westchester%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td style="padding:4px;"><b><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Rockland%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td style="padding:4px;"><b><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Nassau%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td style="padding:4px;"><b><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Suffolk%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td style="padding:4px;"><b><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Fairfield%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> </tr> <Tr> <td style="padding:4px;">SELECT</td> <Td style="padding:4px;"><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Manhattan%' and message like '%select%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td style="padding:4px;"><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Brooklyn%' and message like '%select%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td style="padding:4px;"><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Queens%' and message like '%select%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td style="padding:4px;"><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Westchester%' and message like '%select%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td style="padding:4px;"><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Rockland%' and message like '%select%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td style="padding:4px;"><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Nassau%' and message like '%select%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td style="padding:4px;"><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Suffolk%' and message like '%select%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td style="padding:4px;"><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Fairfield%' and message like '%select%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> </tr> <Tr> <td style="padding:4px;">CHOOSE</td> <Td style="padding:4px;"><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Manhattan%' and message like '%choose%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td style="padding:4px;"><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Brooklyn%' and message like '%choose%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td style="padding:4px;"><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Queens%' and message like '%choose%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td style="padding:4px;"><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Westchester%' and message like '%choose%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td style="padding:4px;"><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Rockland%' and message like '%choose%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td style="padding:4px;"><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Nassau%' and message like '%choose%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td style="padding:4px;"><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Suffolk%' and message like '%choose%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td style="padding:4px;"><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Fairfield%' and message like '%choose%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> </tr> <Tr> <td style="padding:4px;">PICK</td> <Td style="padding:4px;"><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Manhattan%' and message like '%pick%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td style="padding:4px;"><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Brooklyn%' and message like '%pick%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td style="padding:4px;"><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Queens%' and message like '%pick%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td style="padding:4px;"><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Westchester%' and message like '%pick%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td style="padding:4px;"><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Rockland%' and message like '%pick%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td style="padding:4px;"><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Nassau%' and message like '%pick%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td style="padding:4px;"><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Suffolk%' and message like '%pick%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td style="padding:4px;"><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Fairfield%' and message like '%pick%' and message not like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> </tr> </td></tr></table> <br><br> <Cfquery name="Gettotal" dataSource="#ds#"> select count(id) as total from nympregnavtrack where message like '%mobile%' </cfquery> <font color="red" size=+2><b> MOBILE</b></font> <Table cellpadding="8" border="1" cellspacing="0"> <Tr style="background-color: black"> <td> <font color="white"></font> </td> <td> <font color="white">Clicks</font> </td> <td> <font color="white">Percentage</font> </td> </Tr> <cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where message like '%select%' and message like '%mobile%' </cfquery> <cfoutput query="geter"> <Tr> <Td>Select</Td> <Td>#geter.counter#</Td> <Td> <center> <cfset per = (geter.counter / #gettotal.total#) * 100> #numberformat(per,'0.00')#% </Td> </Tr> </cfoutput> <cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where message like '%Choose%' and message like '%mobile%' </cfquery> <cfoutput query="geter"> <Tr> <Td>Choose</Td> <Td>#geter.counter#</Td> <Td> <center> <cfset per = (geter.counter / #gettotal.total#) * 100> #numberformat(per,'0.00')#% </Td> </Tr> </cfoutput> <cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where message like '%Pick%' and message like '%mobile%' </cfquery> <cfoutput query="geter"> <Tr> <Td>Pick</Td> <Td>#geter.counter#</Td> <Td> <center> <cfset per = (geter.counter / #gettotal.total#) * 100> #numberformat(per,'0.00')#% </Td> </Tr> </cfoutput> </Table> <p> <table border="1" cellpadding="4" cellspacing="0" > <Tr> <Td></Td> <Td><b>Manhattan</Td> <Td><b>Brooklyn</Td> <Td><b>Queens</Td> <Td><b>Westchester</Td> <Td><b>Rockland </Td> <Td><b>Nassau</Td> <Td><b>Suffolk</Td> <Td><b>Fairfield</b></Td> </tr> <Tr> <td><b>TOTAL</td> <Td><b><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Manhattan%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td><b><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Brooklyn%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td><b><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Queens%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td><b><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Westchester%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td><b><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Rockland%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td><b><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Nassau%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td><b><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Suffolk%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td><b><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Fairfield%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> </tr> <Tr> <td>SELECT</td> <Td><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Manhattan%' and message like '%select%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Brooklyn%' and message like '%select%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Queens%' and message like '%select%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Westchester%' and message like '%select%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Rockland%' and message like '%select%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Nassau%' and message like '%select%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Suffolk%' and message like '%select%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Fairfield%' and message like '%select%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> </tr> <Tr> <td>CHOOSE</td> <Td><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Manhattan%' and message like '%choose%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Brooklyn%' and message like '%choose%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Queens%' and message like '%choose%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Westchester%' and message like '%choose%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Rockland%' and message like '%choose%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Nassau%' and message like '%choose%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Suffolk%' and message like '%choose%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Fairfield%' and message like '%choose%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> </tr> <Tr> <td>PICK</td> <Td><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Manhattan%' and message like '%pick%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Brooklyn%' and message like '%pick%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Queens%' and message like '%pick%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Westchester%' and message like '%pick%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Rockland%' and message like '%pick%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Nassau%' and message like '%pick%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Suffolk%' and message like '%pick%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> <Td><cfquery name="Geter" dataSource="#ds#"> select count(id) as counter from nympregnavtrack where region like '%Fairfield%' and message like '%pick%' and message like '%mobile%' </cfquery> <cfoutput>#geter.counter#</cfoutput> </Td> </tr> </td></tr></table> </cfif> </cfif>