Terraria Wiki:Cargo tables
The Terraria Wiki stores some data about Terraria in databases via the MediaWiki extension Cargo. The data is usually stored in single, central locations on the wiki and can be queried on any page, facilitating quick and dynamic updates.
List of tables
All available databases (or tables) are listed at Special:CargoTables. They are described below.
Items
Database | Special:CargoTables/Items |
---|---|
Manual querying | Special:Drilldown/Items |
The Items Cargo table contains data about all items in the game, including attributes like damage, max stack, use time, and numerous others.
The data is entered into this table using {{item infobox}}
. Virtually all articles about items use one or more {{item infobox}}
es to display item information, and in the background that information is stored to the Cargo table. Many of the parameters of {{item infobox}}
directly store their value in the respective column of the Cargo table.
For example, consider the following transclusion of {{item infobox}}
on the page Dirt Block:
{{item infobox | name = Dirt Block | id = 2 | type = Block / Crafting material | autoswing = yes | stack = 9999 | research = 100 | rare = {{rare|0}} | use = 15 | placeable = yes | width = 1 | height = 1 }}
This transclusion would both:
- display this data in the visible infobox and
- store this data to the Cargo table in the background.
The table row (or database entry) in the Items table for the Dirt Block would then look something like this (not all columns included, for brevity):
Page | itemid | name | type | autoswing | stack | damage | damagetype | knockback | research | rare | buy | sell | use | placeable | placedwidth | placedheight |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Dirt Block | 2 | Dirt Block | block • crafting material | Yes | 999 | 100 | 0 | 15 | Yes | 1 | 1 |
This is the essence of the Items table:
Almost all of the Items Cargo table's columns are directly connected to the
{{item infobox}}
template parameters.
For instance, if you want to list all block items by querying the Items Cargo table for block
in the type
column, and you notice that the Dirt Block does not show up, then make sure that block
is in the | type =
parameter of the Dirt Block's {{item infobox}}
.
There are more details about the behavior of {{item infobox}}
which are explained in the following section, but the principle above still applies.
NPCs
Database | Special:CargoTables/NPCs |
---|---|
Manual querying | Special:Drilldown/NPCs |
Recipes
Database | Special:CargoTables/Recipes |
---|---|
Manual querying | Special:Drilldown/Recipes |
Drops
Database | Special:CargoTables/Drops |
---|---|
Manual querying | Special:Drilldown/Drops |
Exclusive
Database | Special:CargoTables/Exclusive |
---|---|
Manual querying | Special:Drilldown/Exclusive |