Template:Spawners: Difference between revisions

VisualWikitext

Revision as of 17:31, 8 November 2024

This template defines the table "Spawners". View table.

@@ Line 27: / Line 27: @@
 == Potential Main Weapon ==
-{{#cargo_query:
+{{#cargo_compound_query:
-table=InventorySlot, Swords
+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
-|fields=Swords._pageName=Name
+|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
-|where=InventorySlot.OwnerCodename='{{{Codename}}}' and InventorySlot.Slot='Weapon'
-|join on = Swords.Codename=InventorySlot.ItemCodename
 |format=table
 |headers=yes
@@ Line 38: / Line 36: @@
 == Potential Back Weapon ==
-{{#cargo_query:
-table=InventorySlot, Swords
-|fields=Swords._pageName=Name
-|where=InventorySlot.OwnerCodename='{{{Codename}}}' and InventorySlot.Slot='BackWeapon'
-|join on = Swords.Codename=InventorySlot.ItemCodename
-|format=table
-|headers=yes
-}}
-== Compounded ==
 {{#cargo_compound_query:
-tables=InventorySlot, Swords;fields=Swords._pageName=Name, InventorySlot.OwnerCodename, InventorySlot.ItemCodename;where=InventorySlot.OwnerCodename='{{{Codename}}}';join on=Swords.Codename=InventorySlot.ItemCodename
+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, Ranged;fields=Ranged._pageName=Name, InventorySlot.OwnerCodename, InventorySlot.ItemCodename;where=InventorySlot.OwnerCodename='{{{Codename}}}';join on=Ranged.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
 |format=table
 |headers=yes
 }}
 == Potential Second Weapon ==