Dear Members,
if you are planing to change from Xtream Codes v1.0.60 to Xtream Codes v2.9.3 (Xtream-UI) so you need also import your Database.
So here is solution how can do it. But please note that maybe there some missed Tables.
The changes will do in following tables:
- bouquets
- mag_devices
- packages
- reg_users
- streams
- stream_categories
- users
How to use it:
Login to you Panel and check for and issues, You have assign your streams to your Servers (Loadbalancers) manually.
It would be fine, if you try it out and left your comments.
if you are planing to change from Xtream Codes v1.0.60 to Xtream Codes v2.9.3 (Xtream-UI) so you need also import your Database.
So here is solution how can do it. But please note that maybe there some missed Tables.
The changes will do in following tables:
- bouquets
- mag_devices
- packages
- reg_users
- streams
- stream_categories
- users
How to use it:
- On your Main Server where is Xtream Codes v2.9.3 (Xtream-UI) is already install phpmyadmin
- Very IMPORTANT: Take Backup of your current Xtream Codes v2.9.3 (Xtream-UI) Database
- Create a new Database from phpmyadmin, name it for example "xtream_iptvpro_v16"
- Import your Xtream Codes v1.0.60 Database-Backup in to the new created Database "xtream_iptvpro_v16"
- Run following SQL queries:
Bash:
DELETE FROM xtream_iptvpro.`bouquets`;
DELETE FROM xtream_iptvpro.`mag_devices`;
DELETE FROM xtream_iptvpro.`packages`;
DELETE FROM xtream_iptvpro.`reg_users`;
DELETE FROM xtream_iptvpro.`streams`;
DELETE FROM xtream_iptvpro.`stream_categories`;
DELETE FROM xtream_iptvpro.`users`;
INSERT INTO xtream_iptvpro.`bouquets` (id, bouquet_name, bouquet_channels, bouquet_series)
SELECT id, bouquet_name, bouquet_channels, '[]' FROM xtream_iptvpro_v16.`bouquets`;
INSERT INTO xtream_iptvpro.`mag_devices`
SELECT *, '', 'fit', 0, 'metric', '', 0 FROM xtream_iptvpro_v16.`mag_devices`;
INSERT INTO xtream_iptvpro.`packages`
SELECT *, 1, 0, 0, 0, 0, '', 0 FROM xtream_iptvpro_v16.`packages`;
INSERT INTO xtream_iptvpro.`reg_users`
SELECT *, '', 0, NULL, '' FROM xtream_iptvpro_v16.`reg_users`;
INSERT INTO xtream_iptvpro.`streams`
SELECT
`id`,`type`,`category_id`,`stream_display_name`,`stream_source`,`stream_icon`,`notes`,`created_channel_location`,`enable_transcode`,`transcode_attributes`,`custom_ffmpeg`,`movie_propeties`,`movie_subtitles`,`read_native`,`target_container_id`,`stream_all`,`remove_subtitles`,`custom_sid`,`epg_id`,`channel_id`,`epg_lang`,`order`,`auto_restart`,`transcode_profile_id`,`pids_create_channel`,'',1,`added`,
0,0,0,0,0,0,0,0,0,0,128000,'','',0
FROM xtream_iptvpro_v16.`streams`;
INSERT INTO xtream_iptvpro.`stream_categories`
SELECT *, 0, 0 FROM xtream_iptvpro_v16.`stream_categories`;
INSERT INTO xtream_iptvpro.`users`
SELECT
`id`,`member_id`,`username`,`password`,`exp_date`,`admin_enabled`,`enabled`,`admin_notes`,`reseller_notes`,`bouquet`,`max_connections`,`is_restreamer`,`allowed_ips`,`allowed_ua`,`is_trial`,`created_at`,`created_by`,`pair_id`,`is_mag`,0,`force_server_id`,`is_isplock`,`as_number`,`isp_desc`,`forced_country`,`is_stalker`,0,''
FROM xtream_iptvpro_v16.`users`;
Login to you Panel and check for and issues, You have assign your streams to your Servers (Loadbalancers) manually.
It would be fine, if you try it out and left your comments.