Game

Hi Vasilis,
thanks for fix the bug with the umlauts (game 'millioniare': instead of 'A, Ä, B, C' now 'A, B, C, D').
Unfortunately, there is another problem in the game 'millioniare': If the question is answered incorrectly, it is not the right answer which will displayed with 'color: DarkOrange' but always the previous response proposal. Is there a connection between the umlauts and this display?
I changed the line 251 in the file millioniare/play.php:
instead of : if ($state == 15 and $i + 1 == $query->correct) {
now: if ($state == 15 and $i == $query->correct) {
Can you verify this?
Thank you very much.
Michael

moodle 2.4
after copy plugin in /mod/game
Debug info: Errors found in XMLDB file: Problem loading table game, Some FIELDS previous/next values are incorrect
Error code: ddlxmlfileerror
Stack trace:
line 349 of /lib/ddl/database_manager.php: ddl_exception thrown
line 365 of /lib/ddl/database_manager.php: call to database_manager->load_xmldb_file()
line 596 of /lib/upgradelib.php: call to database_manager->install_from_xmldb_file()
line 360 of /lib/upgradelib.php: call to upgrade_plugins_modules()
line 1544 of /lib/upgradelib.php: call to upgrade_plugins()
line 349 of /admin/index.php: call to upgrade_noncore()

I was able to work around the error by executing this on my Moodle database in PostgreSQL:
UPDATE mdl_game_cross SET createscore=0 WHERE createscore isnull
before applying the mod_game update.

I have more or less the same error with moodle 3.1.1 dB postgres as Dante Dinawanao
mod_game
Fehler: DDL sql execution
Weitere Informationen über diesen Fehler
×Debug info: ERROR: column "createscore" contains null values
BEGIN ISOLATION LEVEL SERIALIZABLE;
ALTER TABLE mdl_game_cross ALTER COLUMN createscore TYPE DOUBLE PRECISION
;
ALTER TABLE mdl_game_cross ALTER COLUMN createscore SET DEFAULT 0
;
ALTER TABLE mdl_game_cross ALTER COLUMN createscore SET NOT NULL
; COMMIT
Error code: ddlexecuteerror
×Stack trace:
• line 480 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
• line 244 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
• line 680 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
• line 77 of /lib/ddl/database_manager.php: call to pgsql_native_moodle_database->change_database_structure()
• line 595 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
• line 1553 of /mod/game/db/upgrade.php: call to database_manager->change_field_type()
• line 726 of /lib/upgradelib.php: call to xmldb_game_upgrade()
• line 432 of /lib/upgradelib.php: call to upgrade_plugins_modules()
• line 1742 of /lib/upgradelib.php: call to upgrade_plugins()
• line 683 of /admin/index.php: call to upgrade_noncore()
Can I help you?
Thanks. Jürg

Hi,
I encountered the following errors when I attempted to update mod_game on my Moodle 2.9+ installation to the current version:
mod_game
DDL sql execution error
More information about this error
Debug info: ERROR: column "createscore" contains null values
BEGIN ISOLATION LEVEL SERIALIZABLE;
ALTER TABLE mdl_game_cross ALTER COLUMN createscore TYPE DOUBLE PRECISION
;
ALTER TABLE mdl_game_cross ALTER COLUMN createscore SET DEFAULT 0
;
ALTER TABLE mdl_game_cross ALTER COLUMN createscore SET NOT NULL
; COMMIT
Error code: ddlexecuteerror
Stack trace:
line 449 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
line 244 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
line 671 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
line 76 of /lib/ddl/database_manager.php: call to pgsql_native_moodle_database->change_database_structure()
line 583 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
line 1553 of /mod/game/db/upgrade.php: call to database_manager->change_field_type()
line 706 of /lib/upgradelib.php: call to xmldb_game_upgrade()
line 424 of /lib/upgradelib.php: call to upgrade_plugins_modules()
line 1630 of /lib/upgradelib.php: call to upgrade_plugins()
line 433 of /admin/index.php: call to upgrade_noncore()
Any workaround on this?
Thanks.

Hello, just wondering when this is going to be updated for 3.1? Thanks,

You can translate it to any language. Also supports RTL languages. Now is translated to about 20 languages.

Hi Vasilis, great plugin. A quick question: can the crossword puzzles and hangman be used with non-latin characters like Arabic?

Hi,
I need your help.
When I set the score, errors occurred and the loading rate is very slow.
Uncaught SyntaxError: Unexpected token < attempt.php:751
Uncaught SyntaxError: Unexpected token < attempt.php:763
Uncaught SyntaxError: Unexpected token < attempt.php:775
Uncaught SyntaxError: Unexpected token < attempt.php:787
Uncaught SyntaxError: Unexpected token < attempt.php:811
Uncaught SyntaxError: Unexpected token < attempt.php:823
Uncaught SyntaxError: Unexpected token < attempt.php:835
Uncaught SyntaxError: Unexpected token < attempt.php:847
Uncaught SyntaxError: Unexpected token < attempt.php:859

Hi,
The plugin is amazing. My only problem is that BEFORE you start the actual game I get a page that summarizes the previous attempts. I would like to disable it.
Is that possible?
Emanuele

I'm using 2.7 and I would insert picture in millionare-question. I'm using questions with images but during the millionare game they're not visible. Why?

Im using version 1.9

When using a quiz with the millionare game it doesnt work, It works using questions but it repeat the questions often.

All the problems of module Game are fixed. Also new abilities like user defined language in hangman, multianswer questions on games.

CONTRIB-5816: Question bank category not retrieved when Crossword is edited (fixed with version 3.30.12)