User:Mika/sandbox: Difference between revisions

Latest revision as of 16:37, 6 July 2025

Drops cannot be included from a namespace.

@@ Line 1: / Line 1: @@
-{{#cargo_query:tables=Weapons,Ranks
+{{Drop}}
-|fields=Weapons.name=name, Weapons._pageName=pagename, Ranks.name=rank, subcategory_id, neutral_status_id, neutral_status_level, fire_status_id, fire_status_level, ice_status_id, ice_status_level, lightning_status_id, lightning_status_level, ground_status_id, ground_status_level, light_status_id, light_status_level, dark_status_id, dark_status_level
-|where=subcategory_id != "1B" AND Weapons.name NOT LIKE '%/Z' AND Weapons.name NOT LIKE '%*' AND (neutral_status_id = 1 OR fire_status_id = 1 OR ice_status_id = 1 OR lightning_status_id = 1 OR ground_status_id = 1 OR light_status_id = 1 OR dark_status_id = 1)
-|join on=Weapons.rank = Ranks.sort_order
-|order by=rank, name
-|limit=256
-|default={{Cargo Rows/default}}
-}}