
Activities: Game
mod_game
Maintained by
Vasilis Daloukas
The game activity module makes use of questions, quizzes and glossaries to create offer a variety of interactive games.
8110 sites
3k downloads
221 fans
Current versions available: 1
This module gets input from quiz, glossary or questions and plays some games. The games are:
* hangman
* crossword
* cryptex
* millionaire
* sudoku
* Snakes and Ladders
* The hidden picture
* Book with questions
If you like this module please consider donating via PayPal at

It's a project that has been active since 2007 and is the number 7 on downloads in the last 12 months according to https://moodle.org/plugins/stats.php?plugin_category=1.
This module is and will remain free, but your donation allows me to continue the development, and any amount is greatly appreciated.
Now is GDPR compliant.
Publications (Google Scholar profile):
Sets
This plugin is part of set Gamification.
Contributors
Vasilis Daloukas (Lead maintainer)
Please login to view contributors details and/or to contact them
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.
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
UPDATE mdl_game_cross SET createscore=0 WHERE createscore isnull
before applying the mod_game update.
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()
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
I am dying for an update for Moodle 3.2. Is a new version in the making? Thanks