| 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/scheduled/ |
Upload File : |
<cfquery name="getsponrs" dataSource="#ds#">
SELECT columntable.id as colid, columntable.shortTitle as title, columntable.DatePosted, columntable.seo_friendly,columntable.columnnum,columnmaster.authorname
FROM (regionstable INNER JOIN columntable ON regionstable.colid = columntable.ID)
inner join columnmaster on columntable.columnnum = columnmaster.id
WHERE (columntable.mag = 5) and regionstable.regionsid IN (473,487)
and columnnum <> 679
and dateposted < DATE_SUB(NOW(),INTERVAL 1 YEAR)
and status = 1
</cfquery>
<Cfoutput query="getsponrs">
<cfquery name="ups" dataSource="#ds#">
update columntable
set columnnum = 679
where id = #colid#
</cfquery>
</Cfoutput>
<cfhttp
url="https://www.nymetroparents.com/localtest.cfm?geo=New%20City&activities=on&update=on"
method="GET" resolveurl="YES" timeout="50000">
</cfhttp>
<cfhttp
url="https://www.nymetroparents.com/localtest.cfm?geo=New%20City&listings=on&update=on"
method="GET" resolveurl="YES" timeout="50000">
</cfhttp>
<cfhttp
url="https://www.nymetroparents.com/localtest.cfm?geo=Nyack&activities=on&update=on"
method="GET" resolveurl="YES" timeout="50000">
</cfhttp>
<cfhttp
url="https://www.nymetroparents.com/localtest.cfm?geo=Nyack&listings=on&update=on"
method="GET" resolveurl="YES" timeout="50000">
</cfhttp>
DONE!