Template:Weapon List: Difference between revisions
(bandaid fix to purge either test/unobtainable weapons or reskins) |
(tcsm syntax error) |
||
| Line 518: | Line 518: | ||
|TCSMs={{#cargo_query:tables=Weapons,Ranks | |TCSMs={{#cargo_query:tables=Weapons,Ranks | ||
|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, CONCAT(FORMAT(se_mod, 2), 'x')=se 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 | |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, CONCAT(FORMAT(se_mod, 2), 'x')=se 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 | ||
|where=subcategory_id = "1A" NOT Weapons.item_id = "011A3B03" AND | |where=subcategory_id = "1A" AND NOT Weapons.item_id = "011A3B03" AND | ||
NOT Weapons.item_id = "011A2700" AND | NOT Weapons.item_id = "011A2700" AND | ||
NOT Weapons.item_id = "011A2800" AND | NOT Weapons.item_id = "011A2800" AND | ||
Revision as of 13:33, 16 April 2024
Shorthand to generate a weapon list per category.