LinHES Forums
http://forum.linhes.org/

Southpark episodes
http://forum.linhes.org/viewtopic.php?f=17&t=6469		 Page 1 of 1
Author:  badgers [ Mon Oct 17, 2005 9:57 am ]
Post subject:  Southpark episodes
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
Author:  parkinpants [ Mon Oct 17, 2005 4:34 pm ]
Post subject:  i share your pain
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?
Author:  cesman [ Mon Oct 17, 2005 7:15 pm ]
Post subject: 
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.
Author:  aaronb [ Tue Oct 18, 2005 5:02 pm ]
Post subject: 
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.
Author:  badgers [ Tue Oct 18, 2005 7:19 pm ]
Post subject: 
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.
Author:  parkinpants [ Wed Oct 19, 2005 1:14 pm ]
Post subject:  indeed
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/
Author:  badgers [ Wed Oct 19, 2005 1:18 pm ]
Post subject: 
does anyone know where I can find a listing that lets me go from episode number to at least a title or description?
thanks
Author:  parkinpants [ Wed Oct 19, 2005 2:40 pm ]
Post subject:  epguides.com
http://epguides.com/SouthPark/
Author:  badgers [ Wed Oct 19, 2005 2:56 pm ]
Post subject: 
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?
Author:  badgers [ Wed Oct 19, 2005 2:58 pm ]
Post subject: 
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
Author:  tjc [ Wed Oct 19, 2005 8:33 pm ]
Post subject: 
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.
Author:  badgers [ Thu Oct 20, 2005 7:23 am ]
Post subject: 
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
Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/