Board Game Arena

Code: Select all

    function LoadDebug()
    {
        $my_player_id = 2317319;
        $tomodify = [ 'player' => [ 'player_id' ],
                      'global' => [ 'global_value' ],
                      'stats' => [ 'stats_player_id' ],
                      'movement' => [ 'player_moving' ],
                      'car' => [ 'car_owner' ],
                      'power' => [ 'power_owner' ],
                      'card' => [ 'card_location_arg' ]
        ];
        $players_id = [];
      
        foreach ( self::getObjectListFromDB ( "SELECT * from player" ) as $player )
            $players_id [ ] = $player [ 'player_id' ];
      
        for ( $i = 0 ; $i < sizeof($players_id); $i++ )
            foreach ( $tomodify as $table => $fields )
                foreach ( $fields as $field )
                    self::DbQuery ( sprintf ( "UPDATE `%s` SET `%s`=%d WHERE `%s`=%d",
                                              $table, $field, $my_player_id + $i, $field, $players_id [ $i ] ) );
    }

Code: Select all

public function loadSaveStateDb($saveNbr) {
  // run SQL UPDATEs here to fix player IDs, etc.
}

Code: Select all

  /*
   * loadBug: in studio, type loadBug(20762) into the table chat to load a bug report from production
   * client side JavaScript will fetch each URL below in sequence, then refresh the page
   */
  public function loadBug($reportId)
  {
    $db = explode('_', self::getUniqueValueFromDB("SELECT SUBSTRING_INDEX(DATABASE(), '_', -2)"));
    $game = $db[0];
    $tableId = $db[1];
    self::notifyAllPlayers('loadBug', "Trying to load <a href='https://boardgamearena.com/bug?id=$reportId' target='_blank'>bug report $reportId</a>", [
      'urls' => [
        // Emulates "load bug report" in control panel
        "https://studio.boardgamearena.com/admin/studio/getSavedGameStateFromProduction.html?game=$game&report_id=$reportId&table_id=$tableId",
        
        // Emulates "load 1" at this table
        "https://studio.boardgamearena.com/table/table/loadSaveState.html?table=$tableId&state=1",
        
        // Calls the function below to update SQL
        "https://studio.boardgamearena.com/1/$game/$game/loadBugSQL.html?table=$tableId&report_id=$reportId",
        
        // Emulates "clear PHP cache" in control panel
        // Needed at the end because BGA is caching player info
        "https://studio.boardgamearena.com/admin/studio/clearGameserverPhpCache.html?game=$game",
      ]
    ]);
  }

  /*
   * loadBugSQL: in studio, this is one of the URLs triggered by loadBug() above
   */
  public function loadBugSQL($reportId)
  {
    $studioPlayer = self::getCurrentPlayerId();
    $players = $this->playerManager->getPlayers();

    // Change for your game
    // We are setting the current state to match the start of a player's turn if it's already game over
    $sql = [
      "UPDATE global SET global_value=" . ST_MOVE . " WHERE global_id=1 AND global_value=" . ST_BGA_GAME_END
    ];
    foreach ($players as $player) {
      $pId = $player->getId();
      // All game can keep this SQL
      $sql[] = "UPDATE player SET player_id=$studioPlayer WHERE player_id=$pId";
      $sql[] = "UPDATE global SET global_value=$studioPlayer WHERE global_value=$pId";
      $sql[] = "UPDATE stats SET stats_player_id=$studioPlayer WHERE stats_player_id=$pId";

      // Change the below SQL to update the specific tables for your game
      $sql[] = "UPDATE card SET card_location_arg=$studioPlayer WHERE card_location_arg=$pId";
      $sql[] = "UPDATE piece SET player_id=$studioPlayer WHERE player_id=$pId";
      $sql[] = "UPDATE log SET player_id=$studioPlayer WHERE player_id=$pId";
      $sql[] = "UPDATE log SET action_arg=REPLACE(action_arg, $pId, $studioPlayer)";

      // This could be improved, it assumes you had sequential studio accounts before loading
      // e.g., quietmint0, quietmint1, quietmint2, etc. are at the table
      $studioPlayer++;
    }
    $msg = "<b>Loaded <a href='https://boardgamearena.com/bug?id=$reportId' target='_blank'>bug report $reportId</a></b><hr><ul><li>" . implode(';</li><li>', $sql) . ';</li></ul>';
    self::warn($msg);
    self::notifyAllPlayers('message', $msg, []);

    foreach ($sql as $q) {
      self::DbQuery($q);
    }
    self::reloadPlayersBasicInfos();
  }

Code: Select all

  public function loadBugSQL()
  {
    self::setAjaxMode();
    $reportId = (int) self::getArg('report_id', AT_int, true);
    $this->game->loadBugSQL($reportId);
    self::ajaxResponse();
  }

Code: Select all

  notif_loadBug: function (n) {
    function fetchNextUrl() {
      var url = n.args.urls.shift();
      console.log('Fetching URL', url);
      dojo.xhrGet({
        url: url,
        load: function (success) {
          // This could be improved, I don't check the response for errors
          console.log('Success for URL', url, success);
          if (n.args.urls.length > 0) {
            fetchNextUrl();
          } else {
            console.log('Done, reloading page');
            window.location.reload();
          }
        }
      });
    }

    console.log('Notif: load bug', n.args);
    fetchNextUrl();
  },