Xtream ui check mag check leaked lines

[Vortex]

Log in to to mysql or php go to mag devices and execute this query.
It will display all mag devices with more than 1 ip used from user activity ( you must have enabled logs for this to work correctly)
For example if someone pulled illegal m3u from mac, and sharing your line etc. you can check this out with this command

SELECT FROM_BASE64(mac), username, PASSWORD, user_activity.user_id, GROUP_CONCAT(DISTINCT user_ip) FROM user_activity
INNER JOIN users ON user_id = users.id AND is_mag = 1
INNER JOIN mag_devices ON users.id = mag_devices.user_id
WHERE 1 GROUP BY user_id HAVING COUNT(DISTINCT user_ip) > 1
You can also use php code




$sql  = 'SELECT FROM_BASE64(mac), username, PASSWORD, user_activity.user_id, GROUP_CONCAT(DISTINCT user_ip) FROM user_activity \n"
. "INNER JOIN users ON user_id = users.id AND is_mag = 1\n"
. "INNER JOIN mag_devices ON users.id = mag_devices.user_id\n"
. "WHERE 1 GROUP BY user_id HAVING COUNT(DISTINCT user_ip) > 1';