(2022-01-21, 12:14)andrzejls Wrote: (2022-01-21, 11:17)Jumpy73 Wrote: (2022-01-21, 02:29)andrzejls Wrote: @'Jumpy73"
If you run Windows use "SQLyog" software or if you run Lunux "DBeaver". Connect to your kodi MyVideos119.db. Open "movie" table find your movie that you are missing studio info. If it is not there just type studio name. Open "studio" table and check that studio name is there, if not add new row and add studio name. This will work if the studio name.png is in Textures.xbt. Fill in studio name, save database and restart kodi.
Hi @andrzejls
for doing what you suggest do I have to follow the instructions as below?
- MySQL/Setting up MySQL (install & setup a MySQLserver for granting access to Kodi)
- MySQL/Setting up Kodi (connect kodi to MySQLserver at kodi startup)
- Direct Connection using MySQL C API (install & setup SQLyog client for directly connecting to MyVideos119.db internal library database)
Is it correct? or
Do you have in mind something else for directly connect SQLyog client to MyVideos119.db kodi database?
In the last case do you know where I can find an "how-to" procedure for doing that?
Regards
Yes, you need to go through all 3 steps to set-up access to database.
@
andrzejls
After renaming media files following the naming convention suggested by you and @
latts9923, installing the last version of script.module.metadatautils ("1.0.45") from marcelveldt's kodi repo and reloaded from scratch the kodi library, now all movies I'm using for testing have both the media bar and the studio info displayed correctly.
Then, I've done all that needed for having kodi DBs on SQLserver. I opened the movie and studio tables, according to your suggestion and I've verified that the studio info is available in both the tables for each movie --> this is the confirmation that all the movies have the studio info displayed correctly!
Only one movie doesn't have the studio icon displayed in media bar. "New regency productions" is listed in Movie and Studio tables but Textures.xbt file does not have the corresponding .png file.
I added the "new regency productions.png" file in the same folder of the Textures.xbt file but kodi still not display it.
If I have a missing studio icon in Textures.xbt file I would like simply adding it in the same folder of the Textures.xbt file rather than decompiling the Textures.xbt file/adding the missing studio icon/recompiling the Textures.xbt file.
Is it possibile doing that or is it not possible contemporary to have single icon files and the Textures.xbt file in the same folder?
Do I have to decompile the Textures.xbt file, leave all the icon files uncompressed and add new studio icons when needed or is there another solution to follow?
@
latts9923
as specified at par 2.3 of "
Media flags" in kodi wiki (media source flags in Confluence), would it be possible to display an
icon for hddvd in case the movie filename contains the hddvd extension?
Thanks and regards