Activate lines and mags on XC V1

[lpintuitiv]

For those who can't conect lines or mags to V1xx Xtream Codes panel, i have MySQL scripts that automate the process to correct the database.

Many migration do not fill the output format for the lines

To fix it you just check how many user id's you have in DB and just run this code in sql

backup DB first
Truncate database user_output

Paste this into SQL

You have to adjust value 200 to fit your needs ( check the last user_id inside user_output database )

**CODE**

drop procedure if exists doWhile;
DELIMITER //
CREATE PROCEDURE doWhile()
BEGIN
DECLARE i INT DEFAULT 1;
WHILE (i <= 200) DO
INSERT INTO `user_output` (`user_id`, `access_output_id`) values (i, 2);
SET i = i+1;
END WHILE;
END;
//

CALL doWhile();

**END CODE**

You should now have all lines with the selected output format as mpegts

Please hit like if it helps you

 

[daredevil]

For those who can't conect lines or mags to V1xx Xtream Codes panel, i have MySQL scripts that automate the process to correct the database.

PM ME and hit like

This forum is not for sale. Is for sharing. If you want post the stuff.
@redhat

 

[lpintuitiv]

This forum is not for sale. Is for sharing. If you want post the stuff.
@redhat

You see me selling anything ???
It's something that is dependent of the record numbers in the DB, so it's not fool proof.
I have to know values to change the procedure each time.
I even helped people remotely, ask anyone if i asked for money.

You shoould think twice before acusing people.