XFileSharing Pro - anti-hacker center

Message
Author
amator
Posts: 72
Joined: Dec 01, 2010 6:51 pm

anti-hacker center

#1 Postby amator » Aug 04, 2012 11:59 am

Hi,

Can anyone help me with this code

Code: Select all

 my $gen_ip = $db->SelectARef("SELECT INET_NTOA(ip) as ip_txt, SUM(money) as money, COUNT(*) as downloads
                                 FROM IP2Files
                                 WHERE created>NOW()-INTERVAL 48 HOUR
                                 GROUP BY ip
                                 ORDER BY money DESC
                                 LIMIT 20");


I need to list all ip's (only premium files / users can make money on our site). So if file is uploaded by normal user or guset this query will not display all IP's that downloaded file

Return to “XFileSharing Pro”



Who is online

Users browsing this forum: No registered users and 0 guests