Posts: 7
Joined: Nov 2010
Reputation:
0
I'll have to look into the DB. Unfortunately, I will have to look at it a little later. I believe the db only contains a link to the set FanArt and Thumbs that are stored locally. I can not recall which fields.
Posts: 654
Joined: May 2010
Reputation:
28
Hello joemorin73
If i query XBMC via JSON-RPC i get in my case for e.g. the movie 'Alice in Wonderland'
the thumb link 'special://masterprofile/Thumbnails/Video/babe3dda.tbn' and for the fanart 'special://masterprofile/Thumbnails/Video/Fanart/babe3dda.tbn'
If i query the mysql database for the movie i only find field c08,c20 from the table movie. In this fields there are the links to themoviedb.org but not the links to the local stored files.
My goal is not to use JSON-RPC for query. I want to use the mysql because JSON-RPC misses some info i want to query. e.g. actors,movie resolution etc.
So how can i get the links to the local stored files? The interesting part of the link is /Video/Fanart/babe3dda.tbn.
Do i have to calculate from checksum or is it not possible to get these links from the database?
Posts: 67
Joined: Jan 2010
Reputation:
0
I've looked through the schema and I don't see a date entry for when the file was added to the library. Is this something that can be added? If I missed it, can someone point me to it?
Posts: 104
Joined: Jul 2009
Reputation:
0
firnsy
Team-XBMC Developer
Posts: 104
Thanks for the information.
The Database schema has been put on hold to focus on the design of the internal data structures that would ultimately be stored by the design.
It will be these data structures that inform the schema design.
Posts: 3
Joined: Jan 2012
Reputation:
0
This is exactly the feature that I've been hoping for. I've four systems at my home.
Please, let's implement this. I'm postgresql user, will to help if needed.
Posts: 3
Joined: Mar 2011
Reputation:
0
just out of curiosity do you think this setup could be bundled into the xbmcbuntu package so that each new install come with a potential sql server to enable the host or share amongst computers?
Posts: 5,184
Joined: Jan 2009
Reputation:
131
If it will ever make it into XBMC it will most likely also be available in XBMCbuntu because XBMCbuntu does not really modify how XBMC itself works.
Always read the
online manual (wiki),
FAQ (wiki) and search the forum before posting.
Do not e-mail Team Kodi members directly asking for support. Read/follow the
forum rules (wiki).
Please read the pages on
troubleshooting (wiki) and
bug reporting (wiki) before reporting issues.