View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 6 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Wed Sep 27, 2006 7:54 pm 
Offline
Joined: Mon Jul 31, 2006 7:47 pm
Posts: 13
From my guide I am getting generally the right channels. 90% or so but the rest are the wrong channel. This is a problem because it is mixing up my recorded shows. How do I tell mythtv to still get the channel guide information it is getting but map a couple channels to different places?

Is this possible?


Top
 Profile  
 
 Post subject:
PostPosted: Wed Sep 27, 2006 8:07 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
Search for posts that mention update_database.sh by me. Remember that to swap two channels you need to use a temporary slot so that you can play "the fox, the goose, and the bag of beans" (or if you're French "le loup, la chèvre, et les choux").


Top
 Profile  
 
 Post subject:
PostPosted: Wed Sep 27, 2006 8:30 pm 
Offline
Joined: Mon Jul 31, 2006 7:47 pm
Posts: 13
for other people looking into this in the future, here is a link to the thread in question.

http://mysettopbox.tv/phpBB2/viewtopic.php?t=10075


Top
 Profile  
 
 Post subject:
PostPosted: Wed Sep 27, 2006 9:10 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
OBTW - In the latest MythTV version extra columns got added to one of those tables. I forget which, but mysql should complain bitterly when you try running it.

OK, this looks like it...
Code:
insert into program
(select '$to_chanid', starttime, endtime, title, subtitle, description,
        category, category_type, airdate, stars, previouslyshown,
        title_pronounce, stereo, subtitled, hdtv, closecaptioned,
        partnumber, parttotal, seriesid, originalairdate, showtype,
        colorcode, syndicatedepisodenumber, programid, manualid,
        generic, listingsource, first, last
        from program
        where chanid = '$from_chanid');


Top
 Profile  
 
 Post subject:
PostPosted: Wed Sep 27, 2006 9:36 pm 
Offline
Joined: Mon Jul 31, 2006 7:47 pm
Posts: 13
Thanks, I have done SQL work before I just wanted to see which tables I needed to modify. I should be able to handle the rest. I will post in here once I get around to doing it for people in the future.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Sep 27, 2006 10:41 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
The function in that script should be pretty close to a complete solution. The main thing I would do is to break all the deletes out as a seperate function so you can use it at the end to get rid of your scratch pad pseudo channel. After that all you need is the mapping from channel 1 to channel 2 and so on.


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 5 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu