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:
instead of PASSWORD enter correct mysql root password
OR
You can run this for password prompt
if someone detect issues with script, please let me know to fix script
Use it well
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:
PHP:
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
OR
You can run this for password prompt
PHP:
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
if someone detect issues with script, please let me know to fix script
Use it well
Last edited: