2012-11-24, 01:34
(2012-11-23, 23:29)Angelscry Wrote:(2012-11-23, 21:36)DigitalAnvil Wrote: I'm been searching and searching without success to know if Advanced Launcher works with MySQL? I am currently using Frodo (an older version prior to Beta 1) that I have setup with MySQL for all my movies. All of them are stored on a Synology NAS with their thumbs, nfo, fanart and everything in their own respective folders. This content is being shared amongst 2 laptops, 2 desktops and 3 HTPCs scattered around the house. I use only 1 of my desktops to scrape upon boot up (and run it right away after adding new content). It works great because the content is updated through MySQL and available right away on the other boxesNo, Advanced Launcher do not use MySQL databse, and I do not think it will be possible to do it for several reasons :
Is it possible to use Advanced Launcher in the same manner where I only setup and scape emulators/files once using one box and have it all stored (in folders and MySQL) to make it easily shareable amongst the other boxes (without having to setup each one individually?)?
- First, Advanced Launcher do not only manage media files but also script or executable files. These script or executable files are closely linked to the system on which they are installed. For example emulators or .bat scripts installed on a Windows XBMC system would not be used by a Linux XBMC system. So each XBMC system needs it proper launchers setup. Even if you have all your systems under the same OS, you may still have different emulator settings (due for example for different gamepad, or different display resolution). So storing Advanced Launcher's executable setup on a common MySQL database is not possible.
- Concerning the item/roms paths it is also a problem. A large number of emulators do not support samba paths into their command line. So the only ultimate solution to start items/roms located on a NAS share is to locally mount your NAS share folder into your OS an access to it like as a virtual local drive. Now, because each OS locally mount network shares differently, virtual local paths will be different for each of your XBMC system and so, storing these item/roms paths into a common database is not conceivable.
- Finally, concerning thumbs, nfo and fanart paths it will be effectively possible to store them into a common MySQL database. But because they are closely linked to the items/roms, you will still need to scan/update your items/roms list on each system to display them. So it will solve nothing.
I saw that SMB paths don't work correctly (a possible fix in the future maybe?) in several posts and mouting drives would be the best bet (especially since windows allows you to mount them automatically at bootup) So to effectively execute this, the best option would be to set it up on 1 system. Let it scrape and create it own db locally. Manually fix any file that were named incorrectly and/or adjust whatever needs to be fixed up in terms of thumbs, art and nfo. Once done, I can just copy that locally stored db to the 2nd machine (of course after having installed the addon and setting it up for the 2nd box). The only reason I don't want to scrape it again and again on each machine is mainly so the db is consistent on each box.