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