Question Mag insert problem

[misteremil]

I have an issue with the new mag mac address insertion to XtreamUI. It appear mac is already exisit in portal. But I cant find this mac address in XtreamUI. This is fully new Xtream portal and this mac address never used in portal before,
Anyone can help me? I can't find this mac address in sql database also. I think mac address coded in database

 

[akawi11]

Base64 Encode and Decode - Online

Encode to Base64 format or decode from it with various advanced options. Our site has an easy to use online tool to convert your data.

www.base64encode.org

encode the mac address, then search for it in your sql database in mag devices table, maybe it's already there by an mistake double click or something...

 

[misteremil]

Base64 Encode and Decode - Online

Encode to Base64 format or decode from it with various advanced options. Our site has an easy to use online tool to convert your data.

www.base64encode.org

encode the mac address, then search for it in your sql database in mag devices table, maybe it's already there by an mistake double click or something...

Thanks. I already try it. But no result. Cant find inn mag_devices table as well. Still got this issue

 

[akawi11]

Thanks. I already try it. But no result. Cant find inn mag_devices table as well. Still got this issue

are you sure you search in "mac" ? mag_device table?
for an example
MDA6MDA6MDA6MDE6MDE6MDE=
you will need to search "MDA6MDA6MDA6MDE6MDE6MDE=" in mac

 

[misteremil]

are you sure you search in "mac" ? mag_device table?
for an example
MDA6MDA6MDA6MDE6MDE6MDE=
you will need to search "MDA6MDA6MDA6MDE6MDE6MDE=" in mac

Of cause mate. I encode normal 00:1a:79:XX:XX:XX to XXXXXXXXXXXX for example. and search XXXXXXXXXXXX in all lists mag_devices table. No result

 

[misteremil]

Sorry it was my mistake. I found this mac in sql database. uppercase problem during encoding mac address. Problem was solved. thanks a lot

 

[noris]

use mysql to delete all hiden mag devices.

mysql -u root -p
use xtream_iptvpro;
delete FROM `mag_devices` where user_id not in (SELECT id FROM `users`);

 

[misteremil]

use mysql to delete all hiden mag devices.

mysql -u root -p
use xtream_iptvpro;
delete FROM `mag_devices` where user_id not in (SELECT id FROM `users`);

Thanks mate. I already delete it with phpmyadmjn.