More actions
No edit summary |
No edit summary |
||
| Line 46: | Line 46: | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=InventorySlot, Swords;fields=Swords._pageName=Name, InventorySlot.OwnerCodename, InventorySlot.ItemCodename;where=InventorySlot.OwnerCodename='{{{Codename}}}' and InventorySlot.Slot='Weapon';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='Weapon';join on=Swords.Codename=InventorySlot.ItemCodename | ||
|tables=InventorySlot, Ranged;fields=Ranged._pageName=Name, InventorySlot.OwnerCodename, InventorySlot.ItemCodename;where=InventorySlot.OwnerCodename='{{{Codename}}}' and InventorySlot.Slot='Weapon';join on=Ranged.Codename=InventorySlot.ItemCodename | |tables=InventorySlot, Ranged;fields=CONCAT('[[File:', Swords.Ranged, '.png]]')=Image,Ranged._pageName=Name, InventorySlot.OwnerCodename, InventorySlot.ItemCodename;where=InventorySlot.OwnerCodename='{{{Codename}}}' and InventorySlot.Slot='Weapon';join on=Ranged.Codename=InventorySlot.ItemCodename | ||
|format=table | |format=table | ||
|headers=yes | |headers=yes | ||
| Line 55: | Line 55: | ||
== Potential Back Weapon == | == Potential Back Weapon == | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=InventorySlot, Swords;fields=Swords._pageName=Name, InventorySlot.OwnerCodename, InventorySlot.ItemCodename;where=InventorySlot.OwnerCodename='{{{Codename}}}' and InventorySlot.Slot='BackWeapon';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='BackWeapon';join on=Swords.Codename=InventorySlot.ItemCodename | ||
|tables=InventorySlot, Ranged;fields=Ranged._pageName=Name, InventorySlot.OwnerCodename, InventorySlot.ItemCodename;where=InventorySlot.OwnerCodename='{{{Codename}}}' and InventorySlot.Slot='BackWeapon';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='BackWeapon';join on=Ranged.Codename=InventorySlot.ItemCodename | ||
|format=table | |format=table | ||
|headers=yes | |headers=yes | ||
| Line 64: | Line 64: | ||
{{#cargo_query: | {{#cargo_query: | ||
table=InventorySlot, Body | table=InventorySlot, Body | ||
|fields=Body._pageName=Name | |fields=CONCAT('[[File:', Body.Sprite, '.png]]')=Image,Body._pageName=Name | ||
|where=InventorySlot.OwnerCodename='{{{Codename}}}' | |where=InventorySlot.OwnerCodename='{{{Codename}}}' | ||
|join on = Body.Codename=InventorySlot.ItemCodename | |join on = Body.Codename=InventorySlot.ItemCodename | ||
| Line 75: | Line 75: | ||
{{#cargo_query: | {{#cargo_query: | ||
table=InventorySlot, Brains | table=InventorySlot, Brains | ||
|fields=Brains._pageName=Name | |fields=CONCAT('[[File:', Brains.Sprite, '.png]]')=Image,Brains._pageName=Name | ||
|where=InventorySlot.OwnerCodename='{{{Codename}}}' | |where=InventorySlot.OwnerCodename='{{{Codename}}}' | ||
|join on = Brains.Codename=InventorySlot.ItemCodename | |join on = Brains.Codename=InventorySlot.ItemCodename | ||
Revision as of 00:36, 9 November 2024
This template defines the table "Spawners". View table.</includeonly>