Thank you for the great information. I have changed the SQL query to include
type 9. I not sure if the offsets are the same with type 9, but a simple test
should tell us.
I posted the new dongle..... http://www.mvpmc.org/~mdrons/dongles/
Thanks, Mike
----- Original Message ----
From: Andy Holdaway <[EMAIL PROTECTED]>
To: Kevin Steen <[EMAIL PROTECTED]>
Cc: Michael Drons <[EMAIL PROTECTED]>; [email protected]
Sent: Monday, September 1, 2008 2:19:29 PM
Subject: Re: [Mvpmc-users] Save current position -- Please TEST
On Mon, Sep 1, 2008 at 9:05 AM, Kevin Steen <[EMAIL PROTECTED]> wrote:
On Sun, 2008-08-31 at 19:02 -0700, Michael Drons wrote:
> Dave,
> I am not sure why the query does not find the needed value. I am hoping
> that someone who understand PAL can help. If you look at the query do the
> values look correct, channel ID and starttime?
>
> Type = 6, is a constant value, and I believe it to be correct for everyone.
>
> the offset is the piece that must be wrong. In the setting of the bookmark,
> offset comes from the mvpmc video seek function. Which basically returns the
> location in the mpeg stream. Mythtv marks the stream at different offsets.
> We need the mark values from the DB that is closest to the offset.
>
> Can you test jumping to a bookmark? I suspect it does not work also.
>
> Can you run a DB query by hand?
>
> SELECT * FROM recordedseek WHERE chanid = '1004' AND type = 6 AND starttime =
> '2008-03-06T00:05:00' (this should return 3000+ rows)
>
> Thanks, Mike
In my database, every entry has a type of '9'. All my recordings are
from a DVB-Terrestrial card from UK transmissions.
I can also confirm that UK DVB-T recordings are type 9.
The log shows:
VIDEO MODE = 1
MIKE -- SELECT mark FROM recordedseek WHERE chanid = 2002 AND offset>=
177187272 AND type = 6 AND starttime = 2008-09-01T18:26:00 ORDER by MARK
MIKE -- mark = 0
Bookmark not set
Regards
Andy
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Mvpmc-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mvpmc-users
mvpmc wiki: http://mvpmc.wikispaces.com/
