PS, if it helps (not sure really what to look for)
An extract from SQL dataset ....
SELECT * FROM recordedseek WHERE chanid = '1004' AND type = 9 AND starttime =
'2008-03-06T00:05:00'
... returns ......
| 1004 | 2008-03-06 00:05:00 | 14040 | 321152692 | 9 |
| 1004 | 2008-03-06 00:05:00 | 14052 | 321375848 | 9 |
| 1004 | 2008-03-06 00:05:00 | 14064 | 321621940 | 9 |
| 1004 | 2008-03-06 00:05:00 | 14076 | 321905256 | 9 |
| 1004 | 2008-03-06 00:05:00 | 14088 | 322173344 | 9 |
| 1004 | 2008-03-06 00:05:00 | 14100 | 322426580 | 9 |
| 1004 | 2008-03-06 00:05:00 | 14112 | 322667596 | 9 |
| 1004 | 2008-03-06 00:05:00 | 14124 | 322904476 | 9 |
| 1004 | 2008-03-06 00:05:00 | 14136 | 323069540 | 9 |
| 1004 | 2008-03-06 00:05:00 | 14148 | 323255096 | 9 |
+--------+---------------------+-------+-----------+------+
ie mark=14135 does not exist in the dataset, the nearest is 14136
----- Original Message -----
From: Dave Ansell
To: Michael Drons ; Andy Holdaway ; Kevin Steen
Cc: [email protected]
Sent: Monday, September 01, 2008 8:02 PM
Subject: Re: [Mvpmc-users] Save current position -- Please TEST
With the new dongle the Yellow button seems to work - the on screen display
confirms position saved.
Then when trying the blue button (after restart show) the on screen display
seems to go into an infinite loop. It says "skipping to bookmark" but in fact
it skips back to the start of the show.
Command line output is
# VIDEO MODE = 1
MIKE -- MARK = 169608
MIKE -- MODE = 1
MIKE -- MARK = 14135
MIKE starttime = 2008-03-06T00:05:00
MIKE -- starttime = 2008-03-06T00:05:00
Jumping to bookmark 14135 : offset 0
----- Original Message -----
From: Michael Drons
To: Andy Holdaway ; Kevin Steen ; Dave Ansell
Cc: [email protected]
Sent: Monday, September 01, 2008 7:33 PM
Subject: Re: [Mvpmc-users] Save current position -- Please TEST
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/
------------------------------------------------------------------------------
-------------------------------------------------------------------------
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/
-------------------------------------------------------------------------
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/
