(2015-08-24 07:34)mcfang Wrote: I'm still using the design from timmyj9's post and it's been very easy to upgrade for each successive version of XBMC since Frodo.
This is the design updated to Kodi v15: http://pastebin.com/rtaLhFBj
Simply it adds a new playCount and lastWatched fields to the master files table for secondary user and creates a new database with views to the master database for everything except for the bookmarks table.
I'm guessing not because there are no references to triggers in the script, but would library updates/deletions work regardless of which user is logged on? Also, am I supposed to let Kodi 15 build a db from scratch and then run your query?