HowTo Streams & Ondemand fix after importing DB V2 into Xtream Codes V1.0.60
Hello Guys,
I am glad to annouce that I found a way to get Streams & Ondemand fully working again on Xtream Codes V1.
It is much work to do wiht an DB Editor, for example phpmyadmin, but I hope that you will understand.
Here is the Guid and Happy IPTV
Hidden text, you need have 100 likes, now you have 395 likes.
First of all you need to have an DB Editor Like phpmyadmin to edit your current ported V2 DB that is "half" working on V1 and for Safty store a current Backup of your DB.
if you have your backup allready installed and your "Streams" are showen but Ondemand Movies are all offline than you have to edit your streams Table Like this:
Code:
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` int(11) NOT NULL,
`category_id` int(11) DEFAULT NULL,
`stream_display_name` text NOT NULL,
`stream_source` text,
`stream_icon` text NOT NULL,
`notes` text,
`created_channel_location` int(11) DEFAULT NULL,
`enable_transcode` tinyint(4) NOT NULL DEFAULT '0',
`transcode_attributes` text NOT NULL,
`custom_ffmpeg` text NOT NULL,
`movie_propeties` text,
`movie_subtitles` varchar(255) NOT NULL,
`read_native` tinyint(4) NOT NULL DEFAULT '1',
`target_container_id` int(11) DEFAULT NULL,
`stream_all` tinyint(4) NOT NULL DEFAULT '0',
`remove_subtitles` tinyint(4) NOT NULL DEFAULT '0',
`custom_sid` varchar(255) DEFAULT NULL,
`epg_id` int(11) DEFAULT NULL,
`channel_id` varchar(255) DEFAULT NULL,
`epg_lang` varchar(255) DEFAULT NULL,
`order` int(11) NOT NULL DEFAULT '0',
`auto_restart` int(11) NOT NULL DEFAULT '0',
`transcode_profile_id` int(11) NOT NULL DEFAULT '0',
`pids_create_channel` text NOT NULL,
`create_channel_queue` text NOT NULL,
`gen_pts` tinyint(4) NOT NULL DEFAULT '1',
`added` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `type` (`type`),
KEY `category_id` (`category_id`),
KEY `created_channel_location` (`created_channel_location`),
KEY `enable_transcode` (`enable_transcode`),
KEY `read_native` (`read_native`),
KEY `epg_id` (`epg_id`),
KEY `channel_id` (`channel_id`),
KEY `order` (`order`)
whit this Structur your Streams and Movies should all be showen Valid in V1 but still Ondemand not showed running.
If you have more tabels that are not showen here you should delete them to get all working.
Now we need to update target_container_id, its for the file extension (mkv, mp4) ID_mkv= 2 ID_mp4=1
You need to know your target_container_id, if you know it you can procced whit Updating the ID with:
Code:
UPDATE `streams` SET `target_container_id`=2 WHERE `type`=2
This command sets all Ondemand movies to mkv, if you need mp4 one:
Code:
UPDATE `streams` SET `target_container_id`=1 WHERE `type`=2
After done this we have to work on the streams_sys Tabel
It must have this structure:
Code:
`server_stream_id` int(11) NOT NULL AUTO_INCREMENT,
`stream_id` int(11) NOT NULL,
`server_id` int(11) NOT NULL,
`parent_id` int(11) DEFAULT NULL,
`pid` int(11) DEFAULT NULL,
`to_analyze` tinyint(4) NOT NULL DEFAULT '0',
`stream_status` int(11) NOT NULL DEFAULT '0',
`stream_started` int(11) DEFAULT NULL,
`stream_info` text NOT NULL,
`analyze_start` int(11) DEFAULT NULL,
`analyze_pid` int(11) DEFAULT NULL,
`current_source` text,
`crashed_analyze` tinyint(4) NOT NULL DEFAULT '0',
`integrity` varchar(32) DEFAULT NULL,
`bitrate` int(11) DEFAULT NULL,
PRIMARY KEY (`server_stream_id`),
UNIQUE KEY `stream_id_2` (`stream_id`,`server_id`),
KEY `stream_id` (`stream_id`),
KEY `pid` (`pid`),
KEY `server_id` (`server_id`),
KEY `stream_status` (`stream_status`),
KEY `stream_started` (`stream_started`),
KEY `parent_id` (`parent_id`),
KEY `to_analyze` (`to_analyze`)
If you have more tabels that are not showen here you should delete them to get all working.
Here we have to Update the server_id if it is not allready the right one.
If you dont know your server_id you can get it from Tabel: streaming_servers there the: id is equal to server_id in streams_sys.
I make one example:
Ondemad Server ID on V2 Server was: 5
Now in V1 the same Server has ID: 10
To change that we run this SQL Command:
Code:
UPDATE `streams_sys` SET `server_id`=10 WHERE `server_id`=5
Whit this we have changed the "Position" of Streams or Ondemand Movies and now they should be online and working.
Hope that everything is clear.
I dont give support in private, what I wrote is all testet and working.
Give me some Likes, i'm new here