More actions
No edit summary Tag: 2017 source edit |
No edit summary |
||
| Line 72: | Line 72: | ||
== Inventory == | == Inventory == | ||
{{#if: {{#cargo_compound_query: | |||
tables=InventorySlot, Swords;fields=CONCAT('[[File:', Swords.Sprite, '.png]]')=Image,Swords._pageName=Name, InventorySlot.OwnerCodename, InventorySlot.ItemCodename;where=InventorySlot.OwnerCodename='{{{Codename}}}' and InventorySlot.Slot='Inventory';join on=Swords.Codename=InventorySlot.ItemCodename | |||
|tables=InventorySlot, Ranged;fields=CONCAT('[[File:', Ranged.Sprite, '.png]]')=Image,Ranged._pageName=Name, InventorySlot.OwnerCodename, InventorySlot.ItemCodename;where=InventorySlot.OwnerCodename='{{{Codename}}}' and InventorySlot.Slot='Inventory';join on=Ranged.Codename=InventorySlot.ItemCodename | |||
|tables=InventorySlot, Resources;fields=CONCAT('[[File:', Resources.Sprite, '.png]]')=Image,Resources._pageName=Name, InventorySlot.OwnerCodename, InventorySlot.ItemCodename;where=InventorySlot.OwnerCodename='{{{Codename}}}' and InventorySlot.Slot='Inventory';join on=Resources.Codename=InventorySlot.ItemCodename | |||
|tables=InventorySlot, Codecs;fields=CONCAT('[[File:', Codecs.Sprite, '.png]]')=Image,Codecs._pageName=Name, InventorySlot.OwnerCodename, InventorySlot.ItemCodename;where=InventorySlot.OwnerCodename='{{{Codename}}}' and InventorySlot.Slot='Inventory';join on=Codecs.Codename=InventorySlot.ItemCodename | |||
|tables=InventorySlot, AnimalCodecs;fields=CONCAT('[[File:', AnimalCodecs.Sprite, '.png]]')=Image,AnimalCodecs._pageName=Name, InventorySlot.OwnerCodename, InventorySlot.ItemCodename;where=InventorySlot.OwnerCodename='{{{Codename}}}' and InventorySlot.Slot='Inventory';join on=AnimalCodecs.Codename=InventorySlot.ItemCodename | |||
|tables=InventorySlot, Bounties;fields=CONCAT('[[File:', Bounties.Sprite, '.png]]')=Image,Bounties._pageName=Name, InventorySlot.OwnerCodename, InventorySlot.ItemCodename;where=InventorySlot.OwnerCodename='{{{Codename}}}' and InventorySlot.Slot='Inventory';join on=Bounties.Codename=InventorySlot.ItemCodename | |||
|tables=InventorySlot, Body;fields=CONCAT('[[File:', Body.Sprite, '.png]]')=Image,Body._pageName=Name, InventorySlot.OwnerCodename, InventorySlot.ItemCodename;where=InventorySlot.OwnerCodename='{{{Codename}}}' and InventorySlot.Slot='Inventory';join on=Body.Codename=InventorySlot.ItemCodename | |||
|format=count | |||
}} | <!-- if true --> | |||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=InventorySlot, Swords;fields=CONCAT('[[File:', Swords.Sprite, '.png]]')=Image,Swords._pageName=Name, InventorySlot.OwnerCodename, InventorySlot.ItemCodename;where=InventorySlot.OwnerCodename='{{{Codename}}}' and InventorySlot.Slot='Inventory';join on=Swords.Codename=InventorySlot.ItemCodename | tables=InventorySlot, Swords;fields=CONCAT('[[File:', Swords.Sprite, '.png]]')=Image,Swords._pageName=Name, InventorySlot.OwnerCodename, InventorySlot.ItemCodename;where=InventorySlot.OwnerCodename='{{{Codename}}}' and InventorySlot.Slot='Inventory';join on=Swords.Codename=InventorySlot.ItemCodename | ||
|tables=InventorySlot, Ranged;fields=CONCAT('[[File:', Ranged.Sprite, '.png]]')=Image,Ranged._pageName=Name, InventorySlot.OwnerCodename, InventorySlot.ItemCodename;where=InventorySlot.OwnerCodename='{{{Codename}}}' and InventorySlot.Slot='Inventory';join on=Ranged.Codename=InventorySlot.ItemCodename | |tables=InventorySlot, Ranged;fields=CONCAT('[[File:', Ranged.Sprite, '.png]]')=Image,Ranged._pageName=Name, InventorySlot.OwnerCodename, InventorySlot.ItemCodename;where=InventorySlot.OwnerCodename='{{{Codename}}}' and InventorySlot.Slot='Inventory';join on=Ranged.Codename=InventorySlot.ItemCodename | ||
|tables=InventorySlot, Resources;fields=CONCAT('[[File:', Resources.Sprite, '.png]]')=Image,Resources._pageName=Name, InventorySlot.OwnerCodename, InventorySlot.ItemCodename;where=InventorySlot.OwnerCodename='{{{Codename}}}' and InventorySlot.Slot='Inventory';join on=Resources.Codename=InventorySlot.ItemCodename | |tables=InventorySlot, Resources;fields=CONCAT('[[File:', Resources.Sprite, '.png]]')=Image,Resources._pageName=Name, InventorySlot.OwnerCodename, InventorySlot.ItemCodename;where=InventorySlot.OwnerCodename='{{{Codename}}}' and InventorySlot.Slot='Inventory';join on=Resources.Codename=InventorySlot.ItemCodename | ||
| Line 80: | Line 90: | ||
|tables=InventorySlot, Bounties;fields=CONCAT('[[File:', Bounties.Sprite, '.png]]')=Image,Bounties._pageName=Name, InventorySlot.OwnerCodename, InventorySlot.ItemCodename;where=InventorySlot.OwnerCodename='{{{Codename}}}' and InventorySlot.Slot='Inventory';join on=Bounties.Codename=InventorySlot.ItemCodename | |tables=InventorySlot, Bounties;fields=CONCAT('[[File:', Bounties.Sprite, '.png]]')=Image,Bounties._pageName=Name, InventorySlot.OwnerCodename, InventorySlot.ItemCodename;where=InventorySlot.OwnerCodename='{{{Codename}}}' and InventorySlot.Slot='Inventory';join on=Bounties.Codename=InventorySlot.ItemCodename | ||
|tables=InventorySlot, Body;fields=CONCAT('[[File:', Body.Sprite, '.png]]')=Image,Body._pageName=Name, InventorySlot.OwnerCodename, InventorySlot.ItemCodename;where=InventorySlot.OwnerCodename='{{{Codename}}}' and InventorySlot.Slot='Inventory';join on=Body.Codename=InventorySlot.ItemCodename | |tables=InventorySlot, Body;fields=CONCAT('[[File:', Body.Sprite, '.png]]')=Image,Body._pageName=Name, InventorySlot.OwnerCodename, InventorySlot.ItemCodename;where=InventorySlot.OwnerCodename='{{{Codename}}}' and InventorySlot.Slot='Inventory';join on=Body.Codename=InventorySlot.ItemCodename | ||
|format=table | |format=table | ||
| | |headers=yes | ||
| | }} | <!-- if false --> | ||
None | |||
}} | }} | ||
Revision as of 04:13, 9 November 2024
This template defines the table "Spawners". View table.</includeonly>