Template:Weapon List: Difference between revisions
(longbow query fix) |
(remove shinies/u+ for rods) |
||
| Line 480: | Line 480: | ||
|fields=rarity, Weapons.item_id, Ranks.name=rank, Weapons.name=name, Weapons._pageName=pagename, extra_id=manufacturer, max_pp=pp, max_attack=atk, CONCAT(FORMAT(critical_attack_mod, 2), 'x')=critical attack mod, CONCAT(FORMAT(pa_mod, 2), 'x')=pa mod, variance, stat, 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, CONCAT(FORMAT(se_mod, 2), 'x')=se mod | |fields=rarity, Weapons.item_id, Ranks.name=rank, Weapons.name=name, Weapons._pageName=pagename, extra_id=manufacturer, max_pp=pp, max_attack=atk, CONCAT(FORMAT(critical_attack_mod, 2), 'x')=critical attack mod, CONCAT(FORMAT(pa_mod, 2), 'x')=pa mod, variance, stat, 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, CONCAT(FORMAT(se_mod, 2), 'x')=se mod | ||
|where=subcategory_id = "18" AND NOT Weapons.item_id = "01185603" | |where=subcategory_id = "18" AND NOT Weapons.item_id = "01185603" | ||
AND NOT Weapons.item_id = "01184503" | |||
AND NOT Weapons.item_id = "01185203" | |||
AND NOT Weapons.item_id = "01185503" | |||
AND NOT Weapons.item_id = "01185903" | |||
|join on=Weapons.rank = Ranks.sort_order | |join on=Weapons.rank = Ranks.sort_order | ||
|format=template | |format=template | ||
Revision as of 11:31, 16 May 2024
Shorthand to generate a weapon list per category.