Table Guide

[Gandalf]

The match reports are saved as tiny database files, in the SQLite format. They are saved in (c:\Users\YOURUSERNAME\Documents\BloodBowlLegendary\Saves\Replays). Here will be a list of the tables in there, what they appear to relate to & the current status of that data within BBDB (may make this into a google sheet?)

Away_AI_Positions - empty table - Not done - the name suggests only applicable to AI-controlled teams.
Away_AI_Tactics - empty table - Not done - the name suggests only applicable to AI-controlled teams.
Away_Equipment_Listing - Not done - Unsure
Away_Player_Casualties - This needs to come from MatchReport.sqlite - it's empty in the replay file.
Away_Player_Listing - stage 1 done - team roster.
Away_Player_Skills - stage 1 done - the bespoke skills (and plus stats??) that the players on the team have.
Away_Player_Type_Skill_Categories_Double - stage 1 done - for every player type, a list of the skill categories (ie agility, passing etc) that the player type can get if they roll a double.
Away_Player_Type_Skill_Categories_Normal - stage 1 done - for every player type, a list of the skill categories (ie agility, passing etc) that the player type can get if they roll a double.
Away_Player_Type_Skills - stage 1 done - a list of the innate skills a player has (ie a freshly bought player). As well as standard player types, this includes all star players. Interestingly includes star players that aren't even available online.
Away_Player_Types - stage 1 done - a list of all player types - their names, stat lines, price and max amount.. Note that each star player that the race has access to counts as its own type.
Away_Races - stage 1 done - small amount of info about the race - name, reroll price and 2 random numbers.
Away_Races_StarPlayers - Not done - unsure, seems to be empty in the examples I can see.
Away_Statistics_Players - stage 1 done - lifetime player stats, before the current game.
This also needs to come from MatchReport.sqlite - the copy there is just for that one match, I think. Note that in this copy, sometimes the idPlayer_Listing = 0, believe this represents a player who missed the match through injury.
Away_Statistics_Season_Players - stage 1 done - season player stats, before the current game.
Away_Statistics_Season_Teams - stage 1 done - season teams stats, before the current game. (1 row)
Away_Statistics_Teams - stage 1 done - lifetime teams stats, before the current game. (1 row)
Away_Team_Listing - stage 1 done - lots of info about the team - name, motto, value, cash, re-rolls, cheerleaders etc.
Away_Team_Rankings - empty table
**** All the above tables are also duplicated with "Home" at the front instead of "Away" - when I do something with an Away table I will also do so with its home equivalent. So I won't bother listing them all here ****
Calendar - 1 row, loads of columns, possibly useless data? This needs to come from MatchReport.sqlite
Replay_NetCommands - stage 1 done - Important table, showing everything that happened in the match.
Rule_Listing - rules that apply - ageing, wizard allowed, max cheerleaders, star players allowed, max turn length and so on. possibly not required?
SavedGameInfo - stage 1 done - things like stadium, file name, and a massive xml column called Match_strSave.
sqlite_sequence - Not needed - internal configuration file only.


One interesting thing is I can't seem to find a table that gives post-match stats - or even the scoreline - so all that information may have to be extracted from the event log. There is a table called "Calendar" that appears to have space for much of that information, but it's all set to 0 on the file I checked.

[Raveen]

I think that the latest match (played, viewed or replayed) is stored in a separate file and it's there and only there that you get the detailed information. This is why you need to replay in order to upload to BBM.

What that file is I have no idea - maybe track which files are accessed as you watch a replay to find out?

[Gandalf]

Agreed there must be some other file.

However I wonder just how much can be retrieved from this Replay_NetCommands (aka "events") table. Logically it must contain everything required to watch the match... and thus contain within it all the information required to create the stats.

It would be nice to work off these files only, and that would get round the "you can only upload the last match played/watched" issue that BBM has. It may prove to be too much work, though.

[lawastooshort]

Completely forgot I can comment on this. UKBBL have their own webbased uploader system.

After a game, you are required to upload:

Replay file
Match report (My Documents/BloodbowlChaos/MatchReport.sqlite)
First log file (My Documents/BloodbowlChaos/BB_Chaos000)
log 001 is optional.

You choose the correct season, division and match day, and then upload.

"Once the result is uploaded you will be taken to a confirmation page which will display your Match ID number"

This is used as a record for dispute resolution, for example, but also like BBM to give a page of automated league tables, team/player/match listings. All games are validated the way the commissioner has to when the cups are set up.

I haven't really got into the stats part of it and couldn't tell you at all how it works.

[id3nt1ty]

I've been taking a look into the exported team files too, so could add some information about that here (probably won't have time until the weekend).

[Gandalf]

Oooh, useful information this is. la.... do you know if UKBBL know anything about the format of replays/logs in Blood Bowl 2?

The teams are in the replay files too - but only as they were before kick-off. This is needed, though, to work out proper stats/probabilities as otherwise you don't know what skills the players involved has. I wonder if the format is similar to the exported team files id has been looking at. It would be nice to have entirely up-to-date teams rather than just what they were before the previous match.

[Raveen]

I don't think anyone knows anything about BB2 until the Beta starts. Cyanide have been deeply uncommunicative which is a damn shame.

[lawastooshort]

I don't think they do yet, know.

Although if I recall there was a problem with the log files being in different formats for different languages, heehee.

[id3nt1ty]

Gandalf, I've also read about some sort of "main" database, but not had a chance to look into my game files yet.

[id3nt1ty]

There is also a cheat sheet on the Old World Football League forum, but I can't paste it here because it won't let me actually post it.

[Raveen]

They coded Fan Favourite even though there's no way to gain it? Madness!

[id3nt1ty]

I wonder if you can add it in the Team Editor (or if it will work if you add it in the one I'm planning to write).

[id3nt1ty]

Apparently Might Blow and Dirty Player don't stack, either.

[Gandalf]

There is also a cheat sheet on the Old World Football League forum, but I can't paste it here because it won't let me actually post it.

I have signed up to their forums, but I have not access to any of their boards apart from the "Welcome!" one. How do you go about getting access to the rest? The "Welcome!" thread appears to suggest introducing yourself, but there is no page/board to introduce yourself...

[id3nt1ty]

I'm not sure I had to do anything other than verify my e-mail address.