2016-04-26, 17:00
Where KODI stored video bookmarks?
What file ?
What file ?
2016-04-26, 18:04
Where i can find this file ?
What app can open it?
What app can open it?
2016-04-26, 18:46
It is not a file, it is an SQLite3 relational database. And I wouldn't advise editing it unless you are 100% certain you know what you are doing.
See database (wiki).
See database (wiki).
2016-04-26, 21:54
(2016-04-26, 18:04)FreakMurderer Wrote: Where i can find this file ?
What app can open it?
(2016-04-26, 19:04)FreakMurderer Wrote: I know about sql databases....
Then I assume you know what apps can open it then
2019-04-09, 18:37
(2016-04-26, 21:54)black_eagle Wrote:(2016-04-26, 18:04)FreakMurderer Wrote: Where i can find this file ?
What app can open it?(2016-04-26, 19:04)FreakMurderer Wrote: I know about sql databases....
Then I assume you know what apps can open it then
I myself am a retired database developer and could figure this out if I needed to, but I only have a few questions before I go that route. If I bookmark a video, but change the file name or move the file to a different drive, the bookmarks disappear. This tells me that the database entry for bookmarks uses the full path name for the file. Is this true or not? Presuming I could fire up some sort of SQL processor and hack the database, might I be able to take out the drive part of the path name so no matter what drive the file is on, as long as I don't change the file name, the bookmarks would still be available? Would be helpful to know if anybody out there can answer.
2019-04-09, 19:52
The bookmark table used the idFile of the video file. Changing a name or any part of the (network) path to the video, will result in a new video idFile value in the database. And hence, the old bookmark is no longer viable.
2019-04-10, 11:27
(2019-04-09, 19:52)Klojum Wrote: The bookmark table used the idFile of the video file. Changing a name or any part of the (network) path to the video, will result in a new video idFile value in the database. And hence, the old bookmark is no longer viable.Thanks! Very helpful! Is the idFile generated by Kodi or by android?
2019-04-10, 11:49
It's generated by Kodi. I should hope that Android's nosiness will never go that far.
2019-04-10, 14:27
(2019-04-10, 11:49)Klojum Wrote: It's generated by Kodi. I should hope that Android's nosiness will never go that far.
LOL. Do you know if there is a way to generate the fileID on demand? Could then find out what it is and do a UPDATE tablename SET fieldname = 'newvalue' WHERE FIELDNAME = 'oldvalue'. Might even make it worth my while to get back into C++ (?). Now where's that compiler....
2019-04-10, 15:49
You could have seen it already if you had a look at the MyVideos database. The idFile field in 'files' is an autoincrement value, in MySQL at least. In SQLite, I don't know.
2019-04-10, 20:11
(2019-04-10, 15:49)Klojum Wrote: You could have seen it already if you had a look at the MyVideos database. The idFile field in 'files' is an autoincrement value, in MySQL at least. In SQLite, I don't know.
OK thanks. Right now, I'm running Kodi on a Minix, which is kind of balky. Thinking also of getting a Windows laptop to take its place.
