[bpanonpt]

My head is about to explode! I've got lots of questions, but try to stick to a few at a time. I've read this post and it seems this is the best group for this. I'm using phpmyadmin, apache, sql via wampserver 3.0.6 on Win10. I'm a noob to sql of any type, and after 2 weeks I finally have it running with Kodi 17. Sort of, and half of what I want to do - sync multiple profiles across multiple devices through one server. I want to only install addons and libraries onto one device, the main pc with Win10 in my office, with all other devices to sync from the server on it. I want to share a few local libraries stored on an external usb hard drive, which isn't much, just home movies, music, family photo albums, etc. I want my main profile to be locked with the other accounts open. I'd like to incororate Emby and Traktv.

I had a small win today after mysql finally communicated with Kodi and built databases for the music and video. Which it wasn't working until I added a user via phpmyadmin where the host name is the name of my computer (WorkV2), because at first I was attempting it with the ip address and 'localhost'. Anywho, that's as far as I got.

I'm considering attempting the Database Version 99 from BigMong to get the 8+ user profiles up and running.
1) It mentions Jarvis, will it work with Krypton? Which i've installed to all my devices
2) Where does the query/code get entered on the phpmyadmin? Again, I haven't used it much, but I'm guessing copy and paste into the 'SQL' tab to 'Run SQL query/queries on server'.
3) Will I still need to edit 'advancedsettings.xml' use separate 'path substitution' commands to sync other folders for profiles, addons, lists, sources, etc? Or does this take care of it all?
4) Speaking of the path substitutions, I'm a bit confused: do I need to use my ip address of the server or the workstation's name, since that's what I had to use to make mysql and kodi talk?
a) I tried pathsub a few times from the kodi client on my office pc first before trying from other clients, and errors in the kodi log, repeated for each item I'm trying to substitute, (this is the error for lists):
ERROR: XFILE::CDirectory::Create - Error creating C:\Users\Admin\AppData\Roaming\Kodi\userdata\playlists\
ERROR: XFILE::CDirectory::Create - Error creating special://profile/playlists/
5) What files still need to be copied onto the devices and where? Just the advancedsettings.xml into [userdata] of each device?
6) I tried to sync to another device, firestick, and it didn't seem it was updating anything. Rebooted device and kodi and still appeared as though it was first installed.

I feel i'm super close and hope you guys can help!