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

TheOddLinguist · 2011-02-06 22:39

Seems to be an issue with pysqlite2? This is a Windows 7 machine.

Code:

37:55 T:7808 M:795586560  NOTICE: Traceback (most recent call last):

37:55 T:7808 M:795586560  NOTICE:   File "C:\Users\Christopher\AppData\Roaming\XBMC\addons\script.moviequiz\quizlib\gui.py​", line 180, in onAction

37:55 T:7808 M:795578368  NOTICE: print "SplashDialog.onAction " + str(action)

37:55 T:7808 M:795578368  NOTICE:   File "C:\Users\Christopher\AppData\Roaming\XBMC\addons\script.moviequiz\quizlib\gui.py​", line 168, in onInit

37:55 T:7808 M:795578368  NOTICE: movies = self.database.fetchone('SELECT COUNT(*) AS count, (SUM(c11) / 60) AS total_hours FROM movie')

37:55 T:7808 M:795578368  NOTICE:   File "C:\Users\Christopher\AppData\Roaming\XBMC\addons\script.moviequiz\quizlib\db.py​", line 31, in fetchone

37:55 T:7808 M:795574272  NOTICE: c.execute(sql, parameters)

37:55 T:7808 M:795574272  NOTICE: pysqlite2._sqlite

37:55 T:7808 M:795574272  NOTICE: .

37:55 T:7808 M:795574272  NOTICE: OperationalError

37:55 T:7808 M:795574272  NOTICE: :

37:55 T:7808 M:795574272  NOTICE: no such table: movie

---

Here's another run with debug logging turned on...perhaps there's something more informational here: http://pastebin.com/E8Nx4gmK

TheOddLinguist · 2011-02-06 23:01

Another thing has come to mind; I use a MySQL database for all my XBMC installations. If this addon is trying to access the video database file on my machine...it doesn't exist. (...or if it does exist, it's empty...hehe)

jtucker1972 · 2011-02-06 23:31

If this could be integrated with the Cinema Experience script that would be sweet. Have this script run for the trivia portion. Imagine!

solexalex · 2011-02-07 00:06

TheOddLinguist Wrote:Another thing has come to mind; I use a MySQL database for all my XBMC installations. If this addon is trying to access the video database file on my machine...it doesn't exist. (...or if it does exist, it's empty...hehe)

I didn't have a look in the code, but it is more than possible that it is the reason.
He seems to use SQLite for the requests (interpreting the error in your log) and he needs to use another library to open your remote MySQL database.

You point a new feature request :
- Add the ability to use a remote SQL database.

mad-max · 2011-02-07 08:57

contributing the german translation...

https://code.google.com/p/translations-f...trings.xml

cheers

mad-max · 2011-02-07 08:58

jtucker1972 Wrote:If this could be integrated with the Cinema Experience script that would be sweet. Have this script run for the trivia portion. Imagine!

You can combine this with HCE...

In the HCE options you can run a script before movie starts...

this is not exactly before the trivia, but should work quiet well...

jtucker1972 · 2011-02-07 18:17

mad-max Wrote:You can combine this with HCE...

In the HCE options you can run a script before movie starts...

this is not exactly before the trivia, but should work quiet well...

I tried configuring HCE Misc to point to the c:\Users\username\AppData\Roaming\XBMC\addons\script.moviequiz\addon.py file, but it didn't start.

Do I need to point it to a different file?

twinther · 2011-02-07 20:56

Hi guys,
Thanks for the feedback. I have uploaded a new version to github:
https://github.com/downloads/twinther/sc...-0.1.1.zip

A lot of stuff was changed, but it works pretty good on my htpc.
I added some new question types, most text is translated, and you can configure the numbers of questions as well as max. MPAA rating in the settings.

I'm planning to add a start menu to configure some of these things as well as a better 'game over' screen.

I also need to fix the video bookmarks, but htpc-tac gave me some ideas.
I might also take a look at mysql integration in the future. the sql queries I use are pretty generic afaik.

Br.
Tommy

jtucker1972 · 2011-02-08 01:19

I'm not sure how much work it would be but an option to add a non-interactive mode where it would just show you what the right answer is and not keep a score. The user can set it to either. This is in keeping with integrating it with HCE. Also, it would be nice that even if I get one wrong that it tells me which one was the correct answer.

htpc-tac · 2011-02-09 10:40

Hi twinther,

I tested your new version yesterday and it worked very well! Keep on Nod

One issue which might be a special case:
I have some iso´s in my library. During the quiz instead of playing a part of the movie, the menue of the iso was played then. Not a big problem, but the question is then easy to answer Big Grin

Here are some of my suggestions which came to my mind:

Feature suggestion:

Display the right answer after your answer was wrong.
A setting option only to ask for already watched movies?

Some question types to get more alternation:

What´s the newest/oldest movie? (choose movies from newer/past year -+1)
Which actor was also in movie xy besides actor z?

Some more estimate questions for your library:

How many movies do you have for year xy?
How many studios/actors/ do you have in your db? (actors already on the initial screen, but who reads )

TheOddLinguist Member Posts: 51 Joined: Oct 2008 Reputation: 0	2011-02-06 23:01 Post: #22 Another thing has come to mind; I use a MySQL database for all my XBMC installations. If this addon is trying to access the video database file on my machine...it doesn't exist. (...or if it does exist, it's empty...hehe)
	find quote

jtucker1972 Fan Posts: 366 Joined: Apr 2010 Reputation: 3	2011-02-06 23:31 Post: #23 If this could be integrated with the Cinema Experience script that would be sweet. Have this script run for the trivia portion. Imagine!
	find quote

mad-max Posting Freak Posts: 1,476 Joined: Jul 2010 Reputation: 52 Location: Germany	2011-02-07 08:57 Post: #25 contributing the german translation... https://code.google.com/p/translations-f...trings.xml cheers - - - Tribute to Metallica - - - If I managed to help you, please click my reputation (This post was last modified: 2011-02-07 16:41 by mad-max.)
	find quote

jtucker1972 Fan Posts: 366 Joined: Apr 2010 Reputation: 3	2011-02-08 01:19 Post: #29 I'm not sure how much work it would be but an option to add a non-interactive mode where it would just show you what the right answer is and not keep a score. The user can set it to either. This is in keeping with integrating it with HCE. Also, it would be nice that even if I get one wrong that it tells me which one was the correct answer.
	find quote