Terraria Wiki:Projects/Fix Cargo Query Database

Fix Cargo Query Database

This project aims to correct some missing data in the Cargo Query table for Items.

When you query the Cargo Table for Items, and filter by items where Items.itemid IS NOT NULL, you will find about some item IDs that are currently not listed in the result. There are no easy workarounds for a these items, and they still need fixing.

These item IDS are currently:

• Shellphone 5437

The Shellphone base item ID is not in the table, probably because the icon is only a placeholder for the crafting menu. It still needs an entry in the database.

I also have a small suggestion just so it's easier to differentiate between where the items are used. For example, there are a handful of entries where the item is 3DS exclusive, such as itemid 255: Purple Thread which shares an ID with itemid 255: Green Thread on the PC, Mobile, and Console versions of the game. There are also duplicate entries for items that are linked to multiple pages, such as certain chests/furniture/walls

• Wooden Beams have 2 entries, one for the basic ones crafted from forest wood, and one that links to the page on all crafted beams.
• The Ruler has 2 entries, one for the old 1.3 accessory item (still an accessory in the console and 3DS versions) and another for the updated 1.4 version that is a weapon (also with the updated sprite art.) The might need manual fixing in the Exclusive cargo table to have separating information
• The Obsidian Brick Wall seems to have an issue since it's currently considered to be a OldGen/3DS-Exclusive item, despite the fact that this specific item ID Obsidian Brick Wall 330 is craftable and obtainable in the 1.4 versions (Desktop, Mobile, and Console). The article itself probably needs better explanation for this behavior. This entry hasn't been updated since the 1.4.0.1 release.

For example, there could be a bit for whether the item is 3DS exclusive or not, and another for if the item entry is for the individual item page (if applicable) or not. I am aware that there are some items that do not have individual item pages, like most furniture items, but for those item entries the only entry will be marked as the primary item entry in the Items table. This can be implemented with a unique constraint, tentatively named IsPrimaryItemEntry, that only 1 entry per itemid can have the IsPrimaryItemEntry set to 1.