I have to play games with the DB to merge two listing sources into one, however it strikes me that cloning one source into two is probably even easier. Then you can have seperate sources for each tuner based on the seperate channel sets...
The tables you'll have to touch are:
- channel - once
cardinput - once
program - ongoing
credits - ongoing
programgenres - ongoing
programrating - ongoing
Basically each sourceid in the channel table has it's own range of 1000 chanid's. So to clone the channel lineup for say sourceid 2 to source 3, write a script to do something like:
Code:
insert into channel
(select 3000 + (chanid % 1000), channum, freqid, 3, callsign, name, icon,
finetune, videofilters, xmltvid, recpriority, contrast, brightness, colour, hue,
tvformat, commfree, visible, outputfilters, useonairguide, mplexid,
serviceid, atscsrcid)
from channel where sourceid = 2 and channum not in (999, 999, 999);
(select 3000 + (chanid % 1000), channum, freqid, 3, callsign, name, icon,
finetune, videofilters, xmltvid, recpriority, contrast, brightness, colour, hue,
tvformat, commfree, visible, outputfilters, useonairguide, mplexid,
serviceid, atscsrcid)
from channel where sourceid = 2 and channum not in (999, 999, 999);
The 999's are a place holder for the 10 channels you want to exclude. You'll need to do something similar for cardinput, although with just one record there it maybe easier to write it as a straight update
Finally you'll need a customized mythfilldatabase wrapper which A) runs mytfilldatabase as usual, B) clears the ongoing data for source 3 then clones the program data for each of the channels in source 2 which are also in source 3 (you can use the same "not in" syntax to avoid a join), C) run /usr/bin/mythbackend --resched to make sure the scheduler notices the new data.
BTW - Always make a good backup before testing something like this.
