Post-release phase

Game File Reference

Overview

• dbmodel.sql - database model
• gameinfos.inc.php - meta-information
• gameoptions.json - game options & user preferences
• img/ - game art
• Game Metadata Manager - tags and metadata media
• material.inc.php - static data
• misc/ - studio-only storage
• modules/ - additional game code
• states.inc.php - state machine
• stats.json - statistics
• X.action.php - player actions
• X.css - interface stylesheet
• Game.php - main logic
• X.js - interface logic
• X.view.php - dynamic game layout
• X_X.tpl - static game layout

---

Useful Components

Official

• Deck: a PHP component to manage cards (deck, hands, picking cards, moving cards, shuffle deck, ...).
• Draggable: a JS component to manage drag'n'drop actions.
• Counter: a JS component to manage a counter that can increase/decrease (ex: player's score).
• ExpandableSection: a JS component to manage a rectangular block of HTML than can be displayed/hidden.
• Scrollmap: a JS component to manage a scrollable game area (useful when the game area can be infinite. Examples: Saboteur or Takenoko games).
• Stock: a JS component to manage and display a set of game elements displayed at a position.
• Zone: a JS component to manage a zone of the board where several game elements can come and leave, but should be well displayed together (See for example: token's places at Can't Stop).

Undocumented component (if somebody knows please help with docs)

• Wrapper: a JS component to wrap a <div> element around its child, even if these elements are absolute positioned.

Unofficial

• BGA Code Sharing - Shared resources, projects on git hub, common code, other links
• BGA Studio Cookbook - Tips and instructions on using API's, libraries and frameworks
• Common board game elements image resources

---

Game Development Process

• First steps with BGA Studio
• Create a game in BGA Studio: Complete Walkthrough
• Tutorial reversi
• Tutorial gomoku
• Tutorial hearts
• BGA Studio Guidelines
• BGA game Lifecycle
• Pre-release checklist
• Post-release phase
• Player Resources - add player help/rules to your game page

---

Guides for Common Topics

• Translations - make your game translatable
• Game Replay
• Mobile Users
• 3D
• Compatibility

---

Miscellaneous Resources

• Studio FAQ
• Tools and tips of BGA Studio - Tips and instructions on setting up development environment
• Studio logs - Instructions for log access
• Practical debugging - Tips focused on debugging
• Troubleshooting - Most common "I am really stuck" situations
• Studio Bugs - Reports against Studio itself (not BGA!)

Your game is now on BGA: congrats!

But what happened when there are some bugs to fix or when you want to optimize something?

Don't be afraid: you're still allowed to modify your game. You just have to pay attention to the points below.

Bugs reporting

Bugs are reported on the BGA bugs page.

During days after your game has been published and from time to time, please have a look at it to check if everything is fine.

How to submit changes?

There is 3 (short) steps to make your changes visible on BGA (from your Control Panel):

• Commit your changes.
• Build a new version (don't forget to do a successful commit BEFORE your build).
• Deploy your new version in production.

What can be modified after release?

Everything can be modified. BUT, some items requires a special attention, and you must inform us in some cases:

Changes that breaks the games in progress

Some changes will break the games in progress at the moment the release/the hotfix will be performed. Each time you make a change, you should ask you the question "it is safe to make this change in a game in progress", and if the answer is "no" you have to inform us.

Example of changes that break the games in progress:

• Changes in the database schema of the game (dbmodel.sql).
• New global variable or game option accessed during the game (if it's only used during setup, it should be safe).
• Change ID of existing game states (adding new game states is fine).
• Changing flow of game states (for example, if you change 1 -> 2 -> 3 -> 4 to 1 -> 3 -> 2 -> 4, players at state 2 will skip state 3)

Of course, as a rule of thumb, you should avoid to introduce changes that break a game in progress. Sometimes however, you do not have any other choice. In this case:

• Try to group all your updates in one version, thus we won't have to block your game several times.
• Tell us explicitly that you introduce some update that can break games in progress so we can block the game during a short time.

Note: in the near future, we will introduce the possibility for you to block/unblock a game directly from your Control Panel in order to perform all the process by yourself.

Updating game options

• If you add options, you should let us know which value should be used for the arena mode, so that we can update the arena configuration.
• If you remove an option or change a version ID, it will break the arena configuration and prevent creating new arena games, so you should let us know so that we can synchronize to update the configuration at the same time as you deploy the new version.
• Do not change option IDs once the game is in production, it will break ongoing games and audience option statistics.

Updating Statistics

You should be careful when updating a statistics:

• If you want to add a new statistic, please be aware that for ongoing games this statistic won't always be correct since it has not been counted from the start of that game.
• If you want to update a statistic, please update it and do not remove/create another one. Otherwise, the statistic won't keep the same ID and players will lose all the historical statistics data.
• If your game is published on BGA, please don't remove any statistics (historical data will be lost).

Updating the database schema

If you want to update the database schema of the game (dbmodel.sql) and your game is already open to everyone on BGA (from BETA onwards), you should inform us before releasing the new version (see "changes that breaks the games in progress").

Any modification in dbmodel.sql should also appear in your nameofyourgame.game.php, in a function

 function upgradeTableDb( $from_version ){
 
 if( $from_version <= YYMMDDHHMM ){ // where your CURRENT version in production has number YYMMDD-HHMM
 
           // You DB schema update request.
           // Note: all tables names should be prefixed by "DBPREFIX_" to be compatible with the applyDbUpgradeToAllDB method you should use below
           $sql = "CREATE TABLE DBPREFIX_xxxxxxx ....";
 
           // The method below is applying your DB schema update request to all tables, including the BGA framework utility tables like "zz_replayXXXX" or "zz_savepointXXXX".
           // You should really use this request, in conjunction with "DBPREFIX_" in your $sql, so ALL tables are updated. All utility tables MUST have the same schema than the main table, otherwise the game may be blocked.
           self::applyDbUpgradeToAllDB( $sql ); 
 }}

Note1: of course you need to change your dbmodel.sql accordingly, so that new games get your updated scheme.

Note2: this is always risky to modify the DB scheme, so:

• if your game is already open to everyone on BGA (from BETA onwards), it may be worth contacting us before, so we can stop the realtime games during the update (this way, only turn based games are concerned by the DB live upgrade).
• if you can avoid it... try to avoid it :)

Note3: testing on the studio is possible by following the following procedure:

• make sure the current state of your project is correctly committed
• revert to the revision currently in production using the version control tools ("Display commit log" -> find the revision matching the current version in production, then "Overwrite working copy with this revision" to get back the matching code)
• launch a game with this code
• revert to your code latest version using the version control tools (use "Overwrite working copy with this revision" with "head" for the revision)
• access the game database
• in the "global" table, find the row with id 300. Its value is 999999999 by default on the studio. Change it to the current production version number
• hit refresh to reload your game page. Your upgradeTableDb() function will be run and the global value will be updated again to the studio value
• check the database to see if your changes have been correctly applied.

Note4: consider that if your game has some undo support capability through 'db_undo_support' => true,' in the gameinfos.inc.php, calling the undoRestorePoint() could restore to a prior game version and the upgradeTableDb() could be called again. In that case, it's better to secure the SQL Alter Table Request with something like :

      function upgradeTableDb( $from_version ){
        if( $from_version <= YYMMDDHHMM )
        {
          // ! important ! Use DBPREFIX_<table_name> for all tables
          // test first the new column existance since it can exists from a previous call to upgradeTableDb while an undo was performed
          $result = self::getUniqueValueFromDB("SHOW COLUMNS FROM tablename LIKE 'new_column'");
          if (empty($result))
              self::applyDbUpgradeToAllDB("ALTER TABLE DBPREFIX_tablename ADD `new_column` tinyint(4)  unsigned NOT NULL DEFAULT '0';");
        }
      }

Note5: Due to bug #64 (opened 2021-11-20), BGA can generate invalid SQL when you use "DBPREFIX_"! When this happens, an exception is thrown and it will be impossible to load the table in production (it will show a white "unexpected error" page). Until this bug is fixed, use something like this to retry any failing SQL without "DBPREFIX_":

   function upgradeTableDb($from_version)
   {
       $changes = [
           [2209030117, "ALTER TABLE DBPREFIX_player ADD `attempts` INT NOT NULL DEFAULT 0"],
           [2209030117, "UPDATE DBPREFIX_player SET `attempts` = (SELECT `global_value` FROM DBPREFIX_global WHERE `global_id` = 40) WHERE `player_id` = (SELECT `global_value` FROM DBPREFIX_global WHERE `global_id` = 2)"],
           [2209030442, "INSERT INTO DBPREFIX_global (`global_id`, `global_value`) VALUES (171, 1)"],
       ];
       foreach ($changes as [$version, $sql]) {
           if ($from_version <= $version) {
               try {
                   self::warn("upgradeTableDb apply 1: from_version=$from_version, change=[ $version, $sql ]");
                   self::applyDbUpgradeToAllDB($sql);
               } catch (Exception $e) {
                   // See https://studio.boardgamearena.com/bug?id=64
                   // BGA framework can produce invalid SQL with non-existant tables when using DBPREFIX_.
                   // The workaround is to retry the query on the base table only.
                   self::error("upgradeTableDb apply 1 failed: from_version=$from_version, change=[ $version, $sql ]");
                   $sql = str_replace("DBPREFIX_", "", $sql);
                   self::warn("upgradeTableDb apply 2: from_version=$from_version, change=[ $version, $sql ]");
                   self::applyDbUpgradeToAllDB($sql);
               }
           }
       }
       self::warn("upgradeTableDb complete: from_version=$from_version");
   }

Updating string to be translated

When you update a string that has been marked to be translatable, please keep in mind that all current translations done by the BGA community will be lost.

Consequently, when you are about to modify a string to be translated (after release), please ask you the following questions:

• Is it just an English misspelling? In this case, it is better to fix the English translation of the string than the original string to be translated.
• Has the meaning of the string changed? If yes, you HAVE to change the original string in order to invalidate all translations that has been done already.
• Is there a similar string already used elsewhere in my game? In this case, you'd better use it again to enjoy immediately all translations already available.

Tell the community about your changes :)

The player's community is always happy to know that someone is taking care of their preferred game :)

If your are the developer of game XXXX, you are also the administrator of player's group "XXXX's players", and you can publish some news in this group newsfeed.

When you fix a bug or add something, do not hesitate to tell the players about this in this group: you'll get the "thank you" you deserved :)

See for example Werewolves group: https://boardgamearena.com/group?id=2465913

Major changes

If you do some major changes to your game like:

• Introducing a new expansion.
• Major code rewriting/refactoring.

... please tell us. In this case, we can:

• Make your game back from "gold" to "public beta", to incite player to report bugs.
• And eventually, publish a news about it :)