[RELEASE] Movie Quiz - how well do you know your movie collection?

Is there actual plans to add MySQL support? Sorry to hassle.

There is actually already MySQL support. It parses the connection values from the advancedsettings.xml file.
With version 0.5.0 you will have to specify the <name> tag as well, with the prefix of the database name, usually <name>MyVideos</name>

Br.
Tommy

Oh sorry, is there a single post or documentation on what needs to be done exactly?

It's supposed to work out-of-the-box if XBMC is already using MySQL. The addon parses the MySQL connection information from the advancedsettings.xml. There's a guide for setting that up on the wiki: http://wiki.xbmc.org/index.php?title=Mysql
What is not on the wiki is the mention of the <name> tag, which you must provide for this addon to work - I will fix this in the next version though.

If you get any errors I would like to see your xbmc.log file

Br.
Tommy

---

Hi all,
I have updated the Movie Quiz website at http://moviequiz.xbmc.info/ with a new design, more information and an improved highscore browser. I'm planning on adding a "Country battle" and possible other competitive things in the future.

Right now I'll concentrate on the next version of the addon

I think I've managed to capture the error (because it didn't work)



XBMC log below, Advanced settings file just here

" <videodatabase>
<type>mysql</type>
<host>192.168.0.16</host>
<port>3306</port>
<name>myvideos60</name>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase> "

New line I just added

Quote:22:56:13 T:152 DEBUG: ------ Window Init (MyPrograms.xml) ------
22:56:13 T:152 INFO: Loading skin file: MyPrograms.xml
22:56:13 T:152 DEBUG: CGUIMediaWindow::GetDirectory (addons://sources/executable/)
22:56:13 T:152 DEBUG: ParentPath = [addons://sources/executable/]
22:56:13 T:8520 DEBUG: Thread Background Loader start, auto delete: 0
22:56:13 T:8520 WARNING: XFILE::CFileFactory::CreateLoader - Unsupported protocol(addons) in addons://more/executable.tbn
22:56:13 T:8520 DEBUG: Thread Background Loader 8520 terminating
22:56:15 T:152 DEBUG: CApplication::ProcessMouse: trying mouse action leftclick
22:56:15 T:152 INFO: initializing python engine.
22:56:15 T:152 DEBUG: new python thread created. id=5
22:56:15 T:8304 DEBUG: Thread XBPyThread start, auto delete: 0
22:56:15 T:8304 DEBUG: Python thread: start processing
22:56:15 T:8304 NOTICE: -->Python Interpreter Initialized<--
22:56:15 T:8304 DEBUG: XBPyThread::Process - The source file to load is C:\Users\scott\AppData\Roaming\XBMC\addons\script.moviequiz\addon.py
22:56:15 T:8304 DEBUG: XBPyThread::Process - Setting the Python path to C:\Users\scott\AppData\Roaming\XBMC\addons\script.moviequiz;C:\Users\scott\AppDa​ta\Roaming\XBMC\addons\script.module.xbmcswift\lib;C:\Users\scott\AppData\Roamin​g\XBMC\addons\script.module.simplejson\lib;C:\Users\scott\AppData\Roaming\XBMC\a​ddons\script.module.myconnpy\lib;C:\Users\scott\AppData\Roaming\XBMC\addons\scri​pt.module.beautifulsoup\lib;C:\Program Files (x86)\XBMC\addons\script.module.pil\lib;C:\Users\scott\AppData\Roaming\XBMC\addo​ns\script.common.plugin.cache\lib;C:\Users\scott\AppData\Roaming\XBMC\addons\scr​ipt.module.simple.downloader\lib;C:\Users\scott\AppData\Roaming\XBMC\addons\scri​pt.module.parsedom\lib;C:\Users\scott\AppData\Roaming\XBMC\addons\script.module.​elementtree\lib;C:\Program Files (x86)\XBMC\addons\script.module.pysqlite\lib;C:\Program Files (x86)\XBMC\system\python\DLLs;C:\Program Files (x86)\XBMC\system\python\Lib;C:\Program Files (x86)\XBMC\python26.zip;C:\Program Files (x86)\XBMC\system\python\lib\plat-win;C:\Program Files (x86)\XBMC\system\python\lib\lib-tk;C:\Program Files (x86)\XBMC;C:\Program Files (x86)\XBMC\system\python;C:\Program Files (x86)\XBMC\system\python\lib\site-packages;
22:56:15 T:8304 DEBUG: XBPyThread::Process - Entering source directory C:\Users\scott\AppData\Roaming\XBMC\addons\script.moviequiz
22:56:15 T:8304 DEBUG: Instantiating addon using automatically obtained id of "script.moviequiz" dependent on version 2.0 of the xbmc.python api
22:56:15 T:8304 NOTICE: Loaded DB settings: {'host': '192.168.0.16', 'type': 'mysql', 'user': 'xbmc', 'pass': 'xbmc'}
22:56:15 T:8304 NOTICE: Connecting to MySQL database...
22:56:15 T:8304 INFO: -->Python script returned the following error<--
22:56:15 T:8304 ERROR: Error Type: <type 'exceptions.KeyError'>
22:56:15 T:8304 ERROR: Error Contents: ('name',)
22:56:15 T:8304 ERROR: Traceback (most recent call last):
File "C:\Users\scott\AppData\Roaming\XBMC\addons\script.moviequiz\addon.py", line 20, in <module>
w = MenuGui()
File "C:\Users\scott\AppData\Roaming\XBMC\addons\script.moviequiz\quizlib\gui.py", line 83, in __init__
self.database = db.Database.connect()
File "C:\Users\scott\AppData\Roaming\XBMC\addons\script.moviequiz\quizlib\db.py", line 79, in connect
return MySQLDatabase(allowedRatings, onlyWatched, settings)
File "C:\Users\scott\AppData\Roaming\XBMC\addons\script.moviequiz\quizlib\db.py", line 657, in __init__
dbName = self._find_newest_database(settings)
File "C:\Users\scott\AppData\Roaming\XBMC\addons\script.moviequiz\quizlib\db.py", line 680, in _find_newest_database
c.execute('SELECT schema_name FROM schemata WHERE schema_name LIKE "' + settings['name'] + '%"')
KeyError: ('name',)
22:56:15 T:8304 INFO: -->End of Python script error report<--
22:56:15 T:8304 INFO: Python script stopped
22:56:15 T:8304 DEBUG: Thread XBPyThread 8304 terminating
22:56:15 T:152 DEBUG: waiting for python thread 5 to stop
22:56:15 T:152 DEBUG: python thread 5 destructed
22:56:15 T:152 DEBUG: ------ Window Init (DialogKaiToast.xml) ------
22:56:15 T:152 ERROR: CLocalizeStrings::ClearBlock: Trying to clear non existent block C:\Users\scott\AppData\Roaming\XBMC\addons\script.moviequiz
22:56:17 T:152 DEBUG: CApplication::ProcessMouse: trying mouse action leftclick
22:56:17 T:152 DEBUG: CApplication::ExecuteXBMCAction : Translating ActivateWindow(Home)
22:56:17 T:152 DEBUG: CApplication::ExecuteXBMCAction : To ActivateWindow(Home)
22:56:17 T:152 DEBUG: Activating window ID: 10000
22:56:18 T:152 DEBUG: ------ Window Deinit (MyPrograms.xml) ------
22:56:18 T:152 DEBUG: ------ Window Init (Home.xml) ------

It should just be
<name>myvideos</name> - not the 60, it will find that automatically.

But it looks like it doesn't pick up the name form the settings:
22:56:15 T:8304 NOTICE: Loaded DB settings: {'host': '192.168.0.16', 'type': 'mysql', 'user': 'xbmc', 'pass': 'xbmc'}


Alternatively you can try this workaround until it release the next versions:
http://forum.xbmc.org/showthread.php?tid...pid1047740

Br.
Tommy

I think based on that, I'll just wait for the next version. It sounds WAY too addictive right now anyhow
Thanks for the hard work.

the fix you suggest here
http://forum.xbmc.org/showthread.php?tid...pid1047740
worked great thanks, love this game.

as does my wife.

(2012-04-18 01:20)ravid394 Wrote:  the fix you suggest here
http://forum.xbmc.org/showthread.php?tid...pid1047740
worked great thanks, love this game.

as does my wife.

my wife bugs me daily about this addon. I'm waiting (hoping) for a nice final version. fingers are crossed it is released soon.

I got sidetracked on some other addons, but I think I could make a new test release soon.
The updated website was first step and it's done. Step two is the addon and I think I have implemented most of the changes I wanted to do,
that just leaves a little testing before a test release