Shows Phoenix Clones by IP Address

[TheJacob]

This is a simple SQL query to show clones by IP address. Enjoy!

Instructions

Open your MySQL client (probably PHPMyAdmin) and then connect to your database server. Click "New Query" or "Query" and then copy/paste the SQL query below into your console window. Change the configuration then press "run", "query", "submit", etc. It will then display the results accordingly.

-- SHOWS PHOENIX CLONES BY IP ADDRESS
-- @author: iDHotel.
--
-- @todo: Show something more valuable than an account id and account name to identify the main users clones.

##############################################################
## Configuration (edit)

-- Database name.
USE phoenix;

-- Minimum number of accounts accounts before being displayed.
SET @min = 2;

##############################################################
## Query (do not edit)

SELECT users2.id AS 'Account ID',
        users2.username AS 'Random Account From List',
        users2.ip_reg AS 'IP Register',
        users2.ip_last AS 'IP Last',
        COUNT(users.username) AS Count,
        GROUP_CONCAT(users.username ORDER BY users.username ASC SEPARATOR ', ') AS 'Account List By IP'
FROM users users
INNER JOIN users users2
    ON users2.id = users.id
WHERE users2.ip_last <> ''
    AND users2.ip_reg <> ''
GROUP BY users.ip_last, users.ip_reg
HAVING Count >= @min
ORDER BY Count DESC;

 

[Kryptos]

Nice release, pretty useful IMHO! Easy to use, just look the user who has 80 clones(In your care) and IP ban him, simplez.