Template:Weapon List: Difference between revisions
(adjust rcsm query to include more bullet types) |
(remove duplicate field) |
||
| Line 540: | Line 540: | ||
}} | }} | ||
|RCSMs={{#cargo_query:tables=Weapons,Ranks | |RCSMs={{#cargo_query:tables=Weapons,Ranks | ||
|fields=rarity, Weapons.item_id, Ranks.name=rank, Weapons.name=name, Weapons._pageName=pagename, extra_id=manufacturer, max_attack=atk, 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, accuracy, rcsm_bullet_type, CONCAT(FORMAT(rcsm_fire_time/30, 2), 's')= rcsm fire time, '1'=expand_se | |fields=rarity, Weapons.item_id, Ranks.name=rank, Weapons.name=name, Weapons._pageName=pagename, extra_id=manufacturer, max_attack=atk, 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, accuracy, rcsm_bullet_type, CONCAT(FORMAT(rcsm_fire_time/30, 2), 's')= rcsm fire time, '1'=expand_se, rcsm_number_of_shot | ||
|where=subcategory_id = "1B" AND NOT Weapons.item_id = "011B2103" AND | |where=subcategory_id = "1B" AND NOT Weapons.item_id = "011B2103" AND | ||
NOT Weapons.item_id = "011B2000" AND | NOT Weapons.item_id = "011B2000" AND | ||
Revision as of 13:07, 23 May 2024
Shorthand to generate a weapon list per category.