What's new
IPTV SAT FORUM

This is a sample guest message. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!

Xtream ui check mag check leaked lines

Status
Not open for further replies.

Vortex

Administrator
Staff member
Administrator
Joined
Mar 30, 2018
Messages
81
Reaction score
41
Points
18
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

Code:
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';
 
Status
Not open for further replies.
Top
  AdBlock Detected
Sure, ad-blocking software does a great job at blocking ads, but it also blocks some useful and important features of our website. For the best possible site experience please take a moment to disable your AdBlocker.