The Game data tab of a Game page is a browser for everything Asterobot extracted from a game version: items, monsters, spells, maps, quests, texts and much more. You don't need SQL for it, and it's the easiest place to find a table or a column name before using it in a script or in the SQL tab.
Open it
Open the version's Game page from Game Manager, then its Game data tab. It has three tabs of its own: Search, Tables and SQL.
Above them, badges sum up the game data: the number of tables that mirror the game's files (table(s)), the number of tables Asterobot derived from them (derived), the total number of rows, and the codes of the languages it holds texts for, such as de · en · es · fr · pt.
When the version has no extracted game data, the tab shows No extracted data for this version and "Extract this game version's data to browse it here." See Extract game data.
The tab you're on, the table and the record you open are all in the page's address, so you can bookmark them or reopen them from your browser's history.
Raw and derived tables
Most tables mirror the game's own data, one table per kind of record. Others are derived by Asterobot to answer questions the game's files can't answer directly, such as every name in every language, or which maps hold which interactive elements. A derived table's name contains two underscores, like maps__interactive_elements, and each of its rows points to its parent row with _parent_id. The _names table links every name to its record, in every extracted language.
Search
Search finds records by what they're called, which the game's own files can't do: they map a number to a text, and nothing goes the other way.
- On the Search tab, type in Query, for example
Bouftou Royal. - Choose the Search mode: By name, the default, or In game text.
- With By name, you can narrow the search with Table, or leave it on Any table.
Results appear as you type, up to 100 of them.
| Mode | What it searches | Results |
|---|---|---|
| By name | The names of records, in the tables that have names. Each word matches as the start of a word, and the best matches come first. | The table, the name and the record's number after #. Click a result to open the record. |
| In game text | Every text the game can show, not only names. | The text's number after #, and the text. These results don't open anything. |
The Table list only offers tables whose records have names.
Names and texts are searched in the Language chosen in the Game page's header. When the game data has no text in that language, a warning under the field names the language it used instead. Nothing found means there was no match, and The search failed means Asterobot couldn't run the search.
Tables
The Tables tab lists every table on the left, with its number of rows. Derived tables are greyed.
- Filter tables... keeps the tables whose name contains what you type.
- Show derived, on by default, hides the derived tables when you turn it off.
Click a table to browse it. Until you do, the right side says "Pick a table to browse it."
Browse a table
Above the rows, you see the table's name, a Derived badge on derived tables, and a line starting with "Derived from" that names the part of the game data the table comes from, followed by the kind of record when the table has one. The number of rows is on the right.
Rows come 25 per page, with page buttons under the table when there are more. Each column shows its name and its type, such as INTEGER for whole numbers. When the table's records have names, a first Name column shows each row's name in the page's language. Long values are cut: point at a cell to read it in full.
Filter the rows
Under each column's name, a column = value field keeps only the rows where that column holds exactly the value you type. Filters on several columns add up, and the table goes back to its first page. The value is read the way the column stores it, so letters in a column of whole numbers give an error such as column "level" is an integer, but "abc" is not.
On tables whose records have names, Find by name... lists the rows whose name matches what you type, up to 25, best first. The count then reads "matching rows" and the page buttons go away. Empty the field to see the whole table again.
When no row matches, the table says "This table is empty." When the rows can't be loaded, a red alert shows the reason, or Couldn't load the rows.
Open a record
Click a row to open its record. Rows of some derived tables can't be opened, because they have no _id of their own.
The record view
A record shows each column that holds a value, one per line, with the column's type. Columns without a value are left out. The top line has a button with the table's name, which takes you back to the rows, the record's number after #, and its name when it has one.
- Links. When a column points at records of another table, and Asterobot checked during extraction that it really does, its values are buttons showing the name of the record they point at. Pointing at one shows "Open" followed by the table and the record's number, and clicking it opens that record. A value that leads to no existing record stays a plain number, and so do the values of a very long list past its first 500.
- Nested values, such as a list of effects or the cells of a map, unfold one level at a time.
- not in the catalog marks a field the table's description doesn't list. It shouldn't happen, and it's shown rather than hidden.
When a record can't be displayed, the view shows "isn't a valid record id." after an address that isn't a number, the reason Asterobot gave, such as datacenter: no such record, or Couldn't load the record.
Other ways in
- On the Maps tab, each search result of the world map and each monster or item of the region panel links to its record. See World map.
- On the Text tab, Find what uses this opens this tab. See Game texts.
For script authors
The table and column names shown here are the ones scripts use with record(), table(), find() and query(). Lookups and SQL queries explain how. The package editor also has this browser beside your code, under Datacenter in its Game panel (The editor).