Database table "bookmarks" explained
#1
I'm writing an integration mechanism to keep my "resume points" synced across multiple different players, XBMC being one of them.

For XBMC , I am updating the bookmarks table in my video database (centralized w/ MySQL). However I need some help to determine what the different fields are.

I've already read http://wiki.xbmc.org/index.php?title=The...e#bookmark but it isn't up to date and doesn't give explanations.

Particularly, I'm wondering about these columns:

  1. timeInSeconds and totalTimeInSeconds. What is the difference between these two?
  2. type - What do the integer types map to?
Also, how can i determine if a Video has been flagged as watched by querying the database? Is this a stored value, or is it calculated?

Let's figure it out, and I'll update the wiki.
Thanks for the help
XBMC.MyLibrary (add anything to the library)
ForTheLibrary (Argus TV & XBMC Library PVR Integration)
SageTV & XBMC PVR Integration
Reply
#2
At a guess, timeInSeconds == time of the bookmark, totalTimeInSeconds == total time of the movie?

The type determines whether it's an episode bookmark, resume bookmark or traditional user-set bookmark.

Code:
enum EType
  {
    STANDARD = 0,
    RESUME = 1,
    EPISODE = 2
  } type;

Cheers,
Jonathan
Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.


Image
Reply
#3
Thanks for the info. I've updated the Wiki
XBMC.MyLibrary (add anything to the library)
ForTheLibrary (Argus TV & XBMC Library PVR Integration)
SageTV & XBMC PVR Integration
Reply

Logout Mark Read Team Forum Stats Members Help
Database table "bookmarks" explained0