View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 130 posts ] 
Go to page Previous  1 ... 3, 4, 5, 6, 7, 8, 9  Next

Print view Previous topic   Next topic  
Author Message
Search for:
 Post subject:
PostPosted: Tue Aug 16, 2005 5:09 pm 
Offline
Joined: Tue Apr 13, 2004 12:41 pm
Posts: 24
I'll take a look at it and see if I can apply it to my situation. Thanks!


Top
 Profile  
 
 Post subject:
PostPosted: Wed Aug 17, 2005 6:20 am 
Offline
Joined: Mon May 10, 2004 8:08 pm
Posts: 1891
Location: Adelaide, Australia
MikeyDIUP wrote:
Any ideas?
You could try executing the query manually to see if it gives a useful error message.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Aug 17, 2005 10:33 am 
Offline
Joined: Tue Apr 13, 2004 12:41 pm
Posts: 24
I had to change the MySQL queries a bit to get it to function. It ran and completed successfully...but the file size is actually a bit bigger!!! Are they dependancies that I could be missing? It's 1 meg bigger.

Thanks again.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Aug 17, 2005 5:27 pm 
Offline
Joined: Mon May 10, 2004 8:08 pm
Posts: 1891
Location: Adelaide, Australia
There are no dependencies. I'm amazed that it could make a bigger file since all it does is copy sections from one file to another. Does the resultant file play ok? Are the cut sections removed?


Top
 Profile  
 
 Post subject:
PostPosted: Wed Aug 17, 2005 6:05 pm 
Offline
Joined: Tue Apr 13, 2004 12:41 pm
Posts: 24
-rw-r--r-- 1 root root 1167177664 Aug 17 09:52 1043_20050814090000_20050814093000.nuv.tmp
-rw-r--r-- 1 root root 1166079936 Aug 14 18:00 1043_20050814173000_20050814180000.nuv

those are the two files. tmp being the one with commercials cut. The resultant file does indeed play fine..and the commercials are still there. I'll post what I got when I ran the program in a few minutes.


Last edited by MikeyDIUP on Wed Aug 17, 2005 7:35 pm, edited 1 time in total.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Aug 17, 2005 6:40 pm 
Offline
Joined: Tue Apr 13, 2004 12:41 pm
Posts: 24
Here's the end of the log. Is it supposed to end with this message?

Code:
new map 3586: INSERT INTO recordedmarkup VALUES (1043,'20050812143100',3586,'1167212544',6)Entered recordedmarkup into db successfully!
new map 3587: INSERT INTO recordedmarkup VALUES (1043,'20050812143100',3587,'1167435776',6)Entered recordedmarkup into db successfully!
new map 3588: INSERT INTO recordedmarkup VALUES (1043,'20050812143100',3588,'1167632384',6)Entered recordedmarkup into db successfully!
new end time Fri Aug 12 15:00:00 2005
SELECT * FROM recorded WHERE chanid = 1043 AND starttime = '20050812143000'
Queried the database successfully!
Result with 25 fields
Adding field 21 - 2000-11-16
Adding field 22 - 0
Adding field 23 - 0
Adding field 24 - 0
INSERT INTO recorded VALUES (1043,'20050812143100','20050812150000','SpongeBob SquarePants','Big Pink Loser; Bubble Buddy','Pat tries to be like SpongeBob; SpongeBob talks to a bubble, making people think he is crazy.','Children','localhost.localdomain',NULL,0,'',1,1,'Default',15,'SH307766','EP3077660032','2005-08-12 15:14:14',1167687616,0,1,'2000-11-16','0','0','0')
Queried the database successfully!
UPDATE jobqueue SET status=5 where chanid=1043 and starttime=20050812143000 and type=1
jobqueue set to stopped.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Aug 17, 2005 7:10 pm 
Offline
Joined: Mon May 10, 2004 8:08 pm
Posts: 1891
Location: Adelaide, Australia
MikeyDIUP wrote:
Is it supposed to end with this message?
Yes.
You did enter a cutlist didn't you? You do know that commercial cut does not actually detect commercials, but just uses the myth entered cutlist dont you?


Top
 Profile  
 
 Post subject:
PostPosted: Wed Aug 17, 2005 7:17 pm 
Offline
Joined: Tue Apr 13, 2004 12:41 pm
Posts: 24
I did not *load* a cutlist, but mythtv is doing a commercial detection job after each show. Do I have to load one into commercial_cut? Doesn't it detect it by itself?


Top
 Profile  
 
 Post subject:
PostPosted: Wed Aug 17, 2005 8:57 pm 
Offline
Joined: Mon May 10, 2004 8:08 pm
Posts: 1891
Location: Adelaide, Australia
I have not explored commercial detecton fully, so I dont know everything that is possible. Having said that, when myth does a commercial detection, I dont think it stores the commercial detection points as cut points, but stores them separately somehow.

From http://mythtv.org/docs/mythtv-HOWTO-11.html

In edit mode
Left/Right : move forward and backward
Up/Down: alter the amount of time you jump forward and backward. Increments are: nearest cutpoint, nearest video keyframe, 1 frame, 0.5 seconds, 1 second, 20 seconds, 1 minute, 5 minutes, and 10 minutes.
PageUp/PageDown move forward and backward to the nearest cut point
< or > move forward or backward by 10 times the normal jump amount
Space/Enter: allows you to set or delete a cut point
Z : loads the commercial skip list (if one exists) into the cutlist
C or Q: clear all cut points in the cutlist
I: Inverts the cutlist

So you need to go into edit mode and then press Z to load the commercial detection points as a cutlist. Also note that commercial detection is not always 100% accurate.

I guess it would be possible to get commercial_cut to use the commercial detection points instead of the cutlist, but given that the detection is not always acurate, this would be somewhat dangerous. You should probably check the commercial detection before cutting.


Top
 Profile  
 
 Post subject:
PostPosted: Thu Aug 18, 2005 8:50 am 
Offline
Joined: Sun May 15, 2005 8:47 am
Posts: 54
What I do is after the mythcommflag has run, I call it again

mythcommflag --chanid xxx --starttime yyyyyy --gencutlist

this automatically loads the cutlist into the database without manual intervention. Then I run commercial_cut on it.

So my modified mythcommflag script looks like

mythcommflag.orig --all the params being passed
mythcommflag.orig --chanid xx --starttime yyyyyyyyy --gencutlist
commercial_cut.modified -c xxxx -s xxxx


Top
 Profile  
 
 Post subject:
PostPosted: Thu Aug 18, 2005 8:52 am 
Offline
Joined: Tue Apr 13, 2004 12:41 pm
Posts: 24
Thanks, I'll try that.

Mike


Top
 Profile  
 
 Post subject:
PostPosted: Thu Aug 18, 2005 8:53 am 
Offline
Joined: Sun May 15, 2005 8:47 am
Posts: 54
MikeyDIUP wrote:
Thanks, I'll try that.

Mike


I'll post my mythcommflag script if you want.


Top
 Profile  
 
 Post subject:
PostPosted: Thu Aug 18, 2005 8:56 am 
Offline
Joined: Tue Apr 13, 2004 12:41 pm
Posts: 24
Yes, please.


Top
 Profile  
 
 Post subject:
PostPosted: Thu Aug 18, 2005 8:59 am 
Offline
Joined: Sun May 15, 2005 8:47 am
Posts: 54
MikeyDIUP wrote:
Yes, please.

you have a PM


Top
 Profile  
 
 Post subject:
PostPosted: Thu Aug 18, 2005 7:35 pm 
Offline
Joined: Mon May 10, 2004 8:08 pm
Posts: 1891
Location: Adelaide, Australia
If the script isnt too long, you should post it in this thread so that others can benefit too.


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 130 posts ] 
Go to page Previous  1 ... 3, 4, 5, 6, 7, 8, 9  Next



All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 8 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:  
cron
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu