Moodle plugins directory: Game

I am working on Moodle 3.3 and Moodle 3.4. In the next 15 days will be available. If you like the Game activity module please consider donating at http://bdaloukas.gr/donate/moodlegame/ to help me have more time to continue working on this project. This module is and will remain free, but your donation allows me to continue the development, and any amount is greatly appreciated.

Thanks a lot. I think we really apreciate you work.

Thanks a lot.

The new version of module Game (compatible with Moodle 3.4 and without warnings and errors at code prechecks) is availabe.
If you like this module please consider donating at https://www.paypal.me/moodlegame to help me have more time to continue working on this project.
It's a project that is active for 10 years and is the number 10 on downloads 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.

With Moodle 3.1.3 to 3.3+ upgrade and latest mod_games (2016091701 to new 2017061901):

Debug info: ERROR: column "usedcols" is of type smallint but expression is of type character varying
LINE 1: UPDATE pcilms_game_cross SET usedcols=cols
^
HINT: You will need to rewrite or cast the expression.
UPDATE pcilms_game_cross SET usedcols=cols
[array (
)]
Error code: dmlwriteexception


Stack trace:

line 489 of /lib/dml/moodle_database.php: dml_write_exception thrown
line 242 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
line 700 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
line 1569 of /mod/game/db/upgrade.php: call to pgsql_native_moodle_database->execute()
line 738 of /lib/upgradelib.php: call to xmldb_game_upgrade()
line 444 of /lib/upgradelib.php: call to upgrade_plugins_modules()
line 1754 of /lib/upgradelib.php: call to upgrade_plugins()
line 699 of /admin/index.php: call to upgrade_noncore()

Christopher Molnar: The version 2017062002 fixes the above problem.

Hi, thank you so much for the update. The Cryptex word box has disappeared though, whether activities have been upgraded or newly created - only the questions are visible. I've tried on both Moodle 3.2 and 3.3 with version 2017062002.

Hi Vasilis,

I seem to get the following error when upgrading to Moodle 3.3+ and MariaDB 10.2, using plugin version 2017062002

mod_game
Error reading from database

More information about this error

×Debug info: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows,usedrows FROM mdl_game_cross' at line 1
SELECT id,rows,usedrows FROM mdl_game_cross
[array (
)]
Error code: dmlreadexception
×Stack trace:
line 486 of \lib\dml\moodle_database.php: dml_read_exception thrown
line 1175 of \lib\dml\mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 56 of \mod\game\db\upgrade.php: call to mysqli_native_moodle_database->get_records_sql()
line 1593 of \mod\game\db\upgrade.php: call to mpgame_db_copy_string_to_int()
line 738 of \lib\upgradelib.php: call to xmldb_game_upgrade()
line 444 of \lib\upgradelib.php: call to upgrade_plugins_modules()
line 1754 of \lib\upgradelib.php: call to upgrade_plugins()
line 699 of \admin\index.php: call to upgrade_noncore()

Maude vuille, Joshua Todd Cowper: The problem is fixed in version 2017062702

Thanks so much for all your work on this plugin Vasilis, looks like there's similar but slightly different error now when I try to upgrade to 2017062702:

mod_game
DDL sql execution error

More information about this error

×Debug info: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows' at line 1
ALTER TABLE mdl_game_cross DROP COLUMN rows
Error code: ddlexecuteerror
×Stack trace:
line 492 of \lib\dml\moodle_database.php: ddl_change_structure_exception thrown
line 1000 of \lib\dml\mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 77 of \lib\ddl\database_manager.php: call to mysqli_native_moodle_database->change_database_structure()
line 570 of \lib\ddl\database_manager.php: call to database_manager->execute_sql_arr()
line 1594 of \mod\game\db\upgrade.php: call to database_manager->drop_field()
line 738 of \lib\upgradelib.php: call to xmldb_game_upgrade()
line 444 of \lib\upgradelib.php: call to upgrade_plugins_modules()
line 1754 of \lib\upgradelib.php: call to upgrade_plugins()
line 699 of \admin\index.php: call to upgrade_noncore()

Joshua Todd Cowper: Version 2017062801 fixes the above problem by simply don't drop the column.

Hi! I have problems in many games: Crossword does not see the glossary and its categories, Millionaire does not see the questions, Can you help mee?

Аида Маркосян: Goto settings of game, select the correct glossary and press save. If the problem continues please goto at https://moodle.org/mod/forum/view.php?id=7220, open a discussion and send a printscreen of settings to understand the problem.

New: version 2017070301 auto detects for common problems e.g. words with spaces and not allowing spaces in the game, multichoice without only only one correct anwer, words containing letters that not contained in the used language.

Added high scores in each game (version 2017081104)