Toggle menu
Toggle personal menu
Not logged in
Your IP address will be publicly visible if you make any edits.

Template:Spawners: Difference between revisions

Template page
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
|default=No results
    |headers=yes
|headers=yes
}} | <!-- if false -->
None
}}
}}



Revision as of 04:13, 9 November 2024

This template defines the table "Spawners". View table.</includeonly>