View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 12 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
 Post subject: Southpark episodes
PostPosted: Mon Oct 17, 2005 9:57 am 
Offline
Joined: Tue Aug 30, 2005 6:04 am
Posts: 39
Location: Madison, WI
I have been recording a ton of south park episodes and they don't have any episode info or any discripion other then the generic one line blurb that is the same for all the episodes.
also, the timming is a little off.
I will catch a batch of 4 episodes in one night. and they all have the same discription.

is anyone else seeing this? all my oher recordings are getting the right info.
any help or ideas on whats going wrong?
thanks


Top
 Profile  
 
 Post subject: i share your pain
PostPosted: Mon Oct 17, 2005 4:34 pm 
Offline
Joined: Sun Jul 24, 2005 4:15 pm
Posts: 170
speaking of south park...

I have every episode of south park in RM format, most are pretty good quality. We can't play RM on MythVideo though can we! I have to install the binary and play the files using the mouse on the X desktop. Gay. Totally gay!

So how do we hack it?

_________________
Image


Top
 Profile  
 
 Post subject:
PostPosted: Mon Oct 17, 2005 7:15 pm 
Offline
Joined: Fri Sep 19, 2003 7:05 pm
Posts: 5088
Location: Fontana, Ca
Jacking a thread is gay. Will you cover my legal fees if I include all codecs under the sun? What is wrong with recompiling MPlayer and getting the needed codecs? Doing so, one can play .rm, .ram or whatever else via MythVideo. To answer the original question, it is Zap2it that is providing the same description for the different episodes. I don't think there is much you can do about that... However, if you have the knowledge, you could manually edit the data in the db.

_________________
cesman

When the source is open, the possibilities are endless!


Top
 Profile  
 
 Post subject:
PostPosted: Tue Oct 18, 2005 5:02 pm 
Offline
Joined: Mon Jan 24, 2005 11:38 pm
Posts: 109
I used the script someone wrote to get episode data from tv.com (no time to look, serach the forum for tv.com) and it got descriptions for SP episodes.


Top
 Profile  
 
 Post subject:
PostPosted: Tue Oct 18, 2005 7:19 pm 
Offline
Joined: Tue Aug 30, 2005 6:04 am
Posts: 39
Location: Madison, WI
Where in tv.com did you find the data to compare the episode number with the episode title and description?

I was looking in mysql and I can see the episode numbers are unique.

thanks
the also sometimes happens with the simpsons.


Top
 Profile  
 
 Post subject: indeed
PostPosted: Wed Oct 19, 2005 1:14 pm 
Offline
Joined: Sun Jul 24, 2005 4:15 pm
Posts: 170
You're right threadjacking is gay! Also, didn't realise that Mplayer could play RM files at all, but now that I do I think that you should include it and ask this guy to be your free US lawyer...

http://www.lessig.org/contact/


Top
 Profile  
 
 Post subject:
PostPosted: Wed Oct 19, 2005 1:18 pm 
Offline
Joined: Tue Aug 30, 2005 6:04 am
Posts: 39
Location: Madison, WI
does anyone know where I can find a listing that lets me go from episode number to at least a title or description?
thanks


Top
 Profile  
 
 Post subject: epguides.com
PostPosted: Wed Oct 19, 2005 2:40 pm 
Offline
Joined: Sun Jul 24, 2005 4:15 pm
Posts: 170
http://epguides.com/SouthPark/


Top
 Profile  
 
 Post subject:
PostPosted: Wed Oct 19, 2005 2:56 pm 
Offline
Joined: Tue Aug 30, 2005 6:04 am
Posts: 39
Location: Madison, WI
hey thanks for the link, this is what I have in my database:

mysql> select recordid,seriesid,programid from recorded where title ='south park';
+----------+----------+--------------+
| recordid | seriesid | programid |
+----------+----------+--------------+
| 31 | SH229827 | EP2298270002 |
| 31 | SH229827 | EP2298270039 |
| 31 | SH229827 | SH2298270000 |
| 31 | SH229827 | EP2298270136 |
| 31 | SH229827 | EP2298270016 |
| 31 | SH229827 | EP2298270057 |
| 31 | SH229827 | EP2298270142 |
| 31 | SH229827 | EP2298270138 |
| 31 | SH229827 | EP2298270038 |
| 31 | SH229827 | EP2298270144 |
| 31 | SH229827 | EP2298270096 |
| 31 | SH229827 | SH2298270000 |
| 31 | SH229827 | EP2298270064 |
| 31 | SH229827 | EP2298270137 |
| 31 | SH229827 | EP2298270055 |
| 31 | SH229827 | EP2298270143 |
| 31 | SH229827 | EP2298270067 |
| 31 | SH229827 | SH2298270000 |
| 31 | SH229827 | SH2298270000 |
| 31 | SH229827 | SH2298270000 |
| 31 | SH229827 | SH2298270000 |
| 31 | SH229827 | SH2298270000 |
| 31 | SH229827 | SH2298270000 |
| 31 | SH229827 | SH2298270000 |
| 31 | SH229827 | SH2298270000 |
| 31 | SH229827 | SH2298270000 |
| 31 | SH229827 | SH2298270000 |
| 31 | SH229827 | SH2298270000 |
| 31 | SH229827 | SH2298270000 |
| 31 | SH229827 | EP2298270056 |
| 31 | SH229827 | EP2298270119 |
+----------+----------+--------------+
31 rows in set (0.00 sec)

does anyone know how to correlate that with what the database has?


Top
 Profile  
 
 Post subject:
PostPosted: Wed Oct 19, 2005 2:58 pm 
Offline
Joined: Tue Aug 30, 2005 6:04 am
Posts: 39
Location: Madison, WI
here is the full info of some of the selected items, notice the description "the adventures of four boys who live in South Park, Colo.
those are the ones I want to fix...
| 1053 | 2005-10-14 23:30:00 | 2005-10-15 00:00:00 | South Park | | The adventures of four boys who live in South Park, Colo. | Sitcom | myth_host | NULL | 0 | NULL | 0 | 1 | Default | 31 | SH229827 | SH2298270000 | 2005-10-15 00:16:40 | 939524096 | 0 | 1 | 1997-08-13 | 0 | 0 | 0 |
| 1053 | 2005-10-15 00:00:00 | 2005-10-15 00:30:00 | South Park | | The adventures of four boys who live in South Park, Colo. | Sitcom | myth_host | NULL | 0 | NULL | 0 | 1 | Default | 31 | SH229827 | SH2298270000 | 2005-10-15 00:46:47 | 940572672 | 0 | 1 | 1997-08-13 | 0 | 0 | 0 |
| 1053 | 2005-10-15 00:30:00 | 2005-10-15 01:00:00 | South Park | | The adventures of four boys who live in South Park, Colo. | Sitcom | myth_host | NULL | 0 | NULL | 0 | 1 | Default | 31 | SH229827 | SH2298270000 | 2005-10-15 01:16:42 | 940572672 | 0 | 1 | 1997-08-13 | 0 | 0 | 0 |
| 1053 | 2005-10-15 21:30:00 | 2005-10-15 22:00:00 | South Park | | The adventures of four boys who live in South Park, Colo. | Sitcom | myth_host | NULL | 0 | NULL | 0 | 1 | Default | 31 | SH229827 | SH2298270000 | 2005-10-15 22:16:42 | 938790848 | 0 | 1 | 1997-08-13 | 0 | 0 | 0 |
| 1053 | 2005-10-15 20:00:00 | 2005-10-15 20:30:00 | South Park | | The adventures of four boys who live in South Park, Colo. | Sitcom | myth_host | NULL | 0 | NULL | 0 | 1 | Default | 31 | SH229827 | SH2298270000 | 2005-10-15 20:46:18 | 938481600 | 0 | 1 | 1997-08-13 | 0 | 0 | 0 |
| 1053 | 2005-10-15 20:30:00 | 2005-10-15 21:00:00 | South Park | | The adventures of four boys who live in South Park, Colo. | Sitcom | myth_host | NULL | 0 | NULL | 0 | 1 | Default | 31 | SH229827 | SH2298270000 | 2005-10-15 21:17:29 | 939837376 | 0 | 1 | 1997-08-13 | 0 | 0 | 0 |
| 1053 | 2005-10-15 21:00:00 | 2005-10-15 21:30:00 | South Park | | The adventures of four boys who live in South Park, Colo. | Sitcom | myth_host | NULL | 0 | NULL | 0 | 1 | Default | 31 | SH229827 | SH2298270000 | 2005-10-15 21:46:16 | 938672064 | 0 | 1 | 1997-08-13 | 0 | 0 | 0 |
| 1053 | 2005-10-15 23:30:00 | 2005-10-16 00:00:00 | South Park | | The adventures of four boys who live in South Park, Colo. | Sitcom | myth_host | NULL | 0 | NULL | 0 | 1 | Default | 31 | SH229827 | SH2298270000 | 2005-10-16 00:16:32 | 940582848 | 0 | 1 | 1997-08-13 | 0 | 0 | 0 |
| 1053 | 2005-10-15 23:00:00 | 2005-10-15 23:30:00 | South Park | | The adventures of four boys who live in South Park, Colo. | Sitcom | myth_host | NULL | 0 | NULL | 0 | 1 | Default | 31 | SH229827 | SH22982


Top
 Profile  
 
 Post subject:
PostPosted: Wed Oct 19, 2005 8:33 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
If you don't have webmin set up do that first.

Bring up two browser windows or tabs, point the first one at:
http://YOURBOX/mythweb/recorded_program ... South+Park
And the second one at (you'll have to give it he password then re-enter the URL):
https://YOURBOX:10000/mysql/edit_table. ... dedprogram
Then click on the view data button. At the bottom of the screen "Search for rows where field" [title] [contains] [south park]. You're now looking at just the records you want to edit.

Look at the programs in window/tab1 identify the episode and date/time then match it up with the DB editing session in window/tab2.

A third window/tab which lets you look up episode descriptions from TV Tome or the like really helps.


Top
 Profile  
 
 Post subject:
PostPosted: Thu Oct 20, 2005 7:23 am 
Offline
Joined: Tue Aug 30, 2005 6:04 am
Posts: 39
Location: Madison, WI
thanks for the reply but I do not understand. I don't use mythweb.
looking at it further it seems that the episodes in question all came through with the same program id number
0000

can you explain a little more what mythweb does?
I am used to just opening mysql and changing the data directly.

thanks for you help


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 12 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