Script Xtream-Codes database non-UTF8 fix

[castaway]

This script is to solve the problems with player_api not showing anything and MAG portal not loading because somewhere in the database there is non UTF-8 encoded text or character that JSON encoder cannot parse.
This script will connect to the database and perform conversion of the data in database. Don't break script while working, and before you run the script. perform backup of the database

To backup XC database run:

mysqldump -u root -pPASSWORD xtream_iptvpro --ignore-table=xtream_iptvpro.client_logs --ignore-table=xtream_iptvpro.user_activity > xtream_iptvpro.`date +%d-%m-%Y`.backup.sql

instead of PASSWORD enter correct mysql root password
OR
You can run this for password prompt

mysqldump -u root -p xtream_iptvpro --ignore-table=xtream_iptvpro.client_logs --ignore-table=xtream_iptvpro.user_activity > xtream_iptvpro.`date +%d-%m-%Y`.backup.sql

To view the content, you need to Sign In or Register.

if someone detect issues with script, please let me know to fix script

Use it well

 

[Blackops]

thanks

 

[neoice]

Thanks. will try once we can install LB. since yesterday no crack works on LB adding.

 

[Inzaghi9]

Thanks
I will try it

 

[redcartr]

thank you

 

[shitping]

thanks

 

[ricardosys]

thaks

 

[lucasrodrigo]

does it work on the xc iptv app?

 

[shitping]

i got this error

PHP Notice: Undefined index: in /home/xtreamcodes/iptv_xtream_codes/xcdb_to_utf8.php on line 76

 

[obscuremind]

Give me likes thanks

 

[kuki]

Give me likes