Template:Weapon List: Difference between revisions

From Phantasy Star Universe Clementine
(model id for nades)
(update queries for ultimate patch)
Line 3: Line 3:
|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, weapon_range, accuracy
|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, weapon_range, accuracy
|where=subcategory_id = "01" AND
|where=subcategory_id = "01" AND
NOT Weapons.item_id = "01017F03" AND
NOT Weapons.item_id = "01014803" AND
NOT Weapons.item_id = "01016E03" AND
NOT Weapons.item_id = "01014303" AND
NOT Weapons.item_id = "01017D03" AND
NOT Weapons.item_id = "01013503" AND
NOT Weapons.item_id = "01017003" AND
NOT Weapons.item_id = "01012303" AND
NOT Weapons.item_id = "01016803" AND
NOT Weapons.item_id = "01012403" AND
NOT Weapons.item_id = "01016303" AND
NOT Weapons.item_id = "01012003" AND
NOT Weapons.item_id = "01015D03" AND
NOT Weapons.item_id = "01011D03" AND
NOT Weapons.item_id = "01014803" AND  
NOT Weapons.item_id = "01011803" AND
NOT Weapons.item_id = "01014303" AND  
NOT Weapons.item_id = "01011700" AND
NOT Weapons.item_id = "01013503" AND  
NOT Weapons.item_id = "01011603" AND
NOT Weapons.item_id = "01012303" AND  
NOT Weapons.item_id = "01010D01" AND
NOT Weapons.item_id = "01012403" AND  
NOT Weapons.item_id = "01010D00" AND
NOT Weapons.item_id = "01012003" AND  
NOT Weapons.item_id = "01010803" AND
NOT Weapons.item_id = "01011D03" AND  
NOT Weapons.item_id = "01011803" AND  
NOT Weapons.item_id = "01011700" AND
NOT Weapons.item_id = "01011600" AND
NOT Weapons.item_id = "01011500" AND  
NOT Weapons.item_id = "01011603" AND  
NOT Weapons.item_id = "01010D01" AND  
NOT Weapons.item_id = "01010D00" AND  
NOT Weapons.item_id = "01010803" AND  
NOT Weapons.item_id = "01010701"
NOT Weapons.item_id = "01010701"
|join on=Weapons.rank = Ranks.sort_order
|join on=Weapons.rank = Ranks.sort_order
Line 38: Line 29:
|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, weapon_range, accuracy
|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, weapon_range, accuracy
|where=subcategory_id = "02" AND NOT Weapons.item_id = "01023803" AND  
|where=subcategory_id = "02" AND NOT Weapons.item_id = "01023803" AND  
NOT Weapons.item_id = "01022803" AND
NOT Weapons.item_id = "01022803" AND
NOT Weapons.item_id = "01021302" AND
NOT Weapons.item_id = "01020E02" AND
NOT Weapons.item_id = "01021202" AND  
NOT Weapons.item_id = "01020E02" AND  
NOT Weapons.item_id = "01020003"
NOT Weapons.item_id = "01020003"
|join on=Weapons.rank = Ranks.sort_order
|join on=Weapons.rank = Ranks.sort_order
Line 54: Line 43:
|Spears={{#cargo_query:tables=Weapons,Ranks
|Spears={{#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, 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, weapon_range, accuracy
|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, weapon_range, accuracy
|where=subcategory_id = "03" AND NOT Weapons.item_id = "01034603" AND
|where=subcategory_id = "03" AND
NOT Weapons.item_id = "01034103" AND  
NOT Weapons.item_id = "01032A03" AND
NOT Weapons.item_id = "01032A03" AND  
NOT Weapons.item_id = "01031B03" AND
NOT Weapons.item_id = "01031B03" AND  
NOT Weapons.item_id = "01031903" AND
NOT Weapons.item_id = "01031903" AND
NOT Weapons.item_id = "01030C03" AND
NOT Weapons.item_id = "01031502" AND
NOT Weapons.item_id = "01031402" AND  
NOT Weapons.item_id = "01030C03" AND  
NOT Weapons.item_id = "01030403"
NOT Weapons.item_id = "01030403"
|join on=Weapons.rank = Ranks.sort_order
|join on=Weapons.rank = Ranks.sort_order
Line 74: Line 60:
|Double Sabers={{#cargo_query:tables=Weapons,Ranks
|Double Sabers={{#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, 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, weapon_range, accuracy
|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, weapon_range, accuracy
|where=subcategory_id = "04" AND NOT Weapons.item_id = "01044303" AND
|where=subcategory_id = "04" AND  
NOT Weapons.item_id = "01043E03" AND
NOT Weapons.item_id = "01042503"
NOT Weapons.item_id = "01043C03" AND  
NOT Weapons.item_id = "01042503" AND
NOT Weapons.item_id = "01041100" AND
NOT Weapons.item_id = "01041000"
|join on=Weapons.rank = Ranks.sort_order
|join on=Weapons.rank = Ranks.sort_order
|format=template
|format=template
Line 91: Line 73:
|Axes={{#cargo_query:tables=Weapons,Ranks
|Axes={{#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, 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, weapon_range, accuracy
|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, weapon_range, accuracy
|where=subcategory_id = "05" AND NOT Weapons.item_id = "01053003" AND  
|where=subcategory_id = "05" AND
NOT Weapons.item_id = "01051C03" AND
NOT Weapons.item_id = "01051C03" AND
NOT Weapons.item_id = "01051B02" AND
NOT Weapons.item_id = "01051402" AND
NOT Weapons.item_id = "01051C02" AND
NOT Weapons.item_id = "01051802" AND
NOT Weapons.item_id = "01051702" AND  
NOT Weapons.item_id = "01051402" AND  
NOT Weapons.item_id = "01051203"
NOT Weapons.item_id = "01051203"
|join on=Weapons.rank = Ranks.sort_order
|join on=Weapons.rank = Ranks.sort_order
Line 110: Line 88:
|Twin Sabers={{#cargo_query:tables=Weapons,Ranks
|Twin Sabers={{#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, 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, weapon_range, accuracy
|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, weapon_range, accuracy
|where=subcategory_id = "06" AND NOT Weapons.item_id = "01066703" AND
|where=subcategory_id = "06" AND
NOT Weapons.item_id = "01066503" AND
NOT Weapons.item_id = "01064303" AND
NOT Weapons.item_id = "01065F03" AND  
NOT Weapons.item_id = "01064403" AND
NOT Weapons.item_id = "01064303" AND  
NOT Weapons.item_id = "01064203" AND
NOT Weapons.item_id = "01064403" AND  
NOT Weapons.item_id = "01063803" AND
NOT Weapons.item_id = "01064203" AND  
NOT Weapons.item_id = "01063303" AND
NOT Weapons.item_id = "01063803" AND  
NOT Weapons.item_id = "01063203" AND
NOT Weapons.item_id = "01063303" AND  
NOT Weapons.item_id = "01062903" AND
NOT Weapons.item_id = "01063203" AND  
NOT Weapons.item_id = "01062003" AND
NOT Weapons.item_id = "01062903" AND  
NOT Weapons.item_id = "01061D03" AND
NOT Weapons.item_id = "01062003" AND
NOT Weapons.item_id = "01061C03" AND
NOT Weapons.item_id = "01061D00" AND  
NOT Weapons.item_id = "01061903" AND
NOT Weapons.item_id = "01061D03" AND
NOT Weapons.item_id = "01060E01" AND
NOT Weapons.item_id = "01061B00" AND  
NOT Weapons.item_id = "01060D01" AND
NOT Weapons.item_id = "01061C03" AND  
NOT Weapons.item_id = "01060B03" AND
NOT Weapons.item_id = "01061903" AND
NOT Weapons.item_id = "01060702" AND
NOT Weapons.item_id = "01061A00" AND
NOT Weapons.item_id = "01061800" AND
NOT Weapons.item_id = "01061700" AND
NOT Weapons.item_id = "01061600" AND
NOT Weapons.item_id = "01061500" AND
NOT Weapons.item_id = "01061400" AND  
NOT Weapons.item_id = "01060E01" AND  
NOT Weapons.item_id = "01060D01" AND  
NOT Weapons.item_id = "01060B03" AND  
NOT Weapons.item_id = "01060702" AND  
NOT Weapons.item_id = "01060203"
NOT Weapons.item_id = "01060203"
|join on=Weapons.rank = Ranks.sort_order
|join on=Weapons.rank = Ranks.sort_order
Line 148: Line 116:
|Twin Daggers={{#cargo_query:tables=Weapons,Ranks
|Twin Daggers={{#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, 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, weapon_range, accuracy
|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, weapon_range, accuracy
|where=subcategory_id = "07" AND NOT Weapons.item_id = "01074703" AND
|where=subcategory_id = "07" AND
NOT Weapons.item_id = "01074103" AND
NOT Weapons.item_id = "01071B03" AND
NOT Weapons.item_id = "01074003" AND  
NOT Weapons.item_id = "01071603" AND
NOT Weapons.item_id = "01071B03" AND  
NOT Weapons.item_id = "01070D03" AND
NOT Weapons.item_id = "01071603" AND
NOT Weapons.item_id = "01071101" AND
NOT Weapons.item_id = "01071001" AND  
NOT Weapons.item_id = "01070D03" AND  
NOT Weapons.item_id = "01070A00"
NOT Weapons.item_id = "01070A00"
|join on=Weapons.rank = Ranks.sort_order
|join on=Weapons.rank = Ranks.sort_order
Line 168: Line 132:
|Twin Claws={{#cargo_query:tables=Weapons,Ranks
|Twin Claws={{#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, 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, weapon_range, accuracy
|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, weapon_range, accuracy
|where=subcategory_id = "08" AND NOT Weapons.item_id = "01083B03" AND
|where=subcategory_id = "08" AND
NOT Weapons.item_id = "01083D03" AND
NOT Weapons.item_id = "01082803" AND
NOT Weapons.item_id = "01083903" AND
NOT Weapons.item_id = "01082503" AND
NOT Weapons.item_id = "01083603" AND  
NOT Weapons.item_id = "01080D03"
NOT Weapons.item_id = "01082803" AND  
NOT Weapons.item_id = "01082503" AND
NOT Weapons.item_id = "01080F01" AND  
NOT Weapons.item_id = "01080D03" AND
NOT Weapons.item_id = "01080E01"
|join on=Weapons.rank = Ranks.sort_order
|join on=Weapons.rank = Ranks.sort_order
|format=template
|format=template
Line 188: Line 147:
|Sabers={{#cargo_query:tables=Weapons,Ranks
|Sabers={{#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, 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, weapon_range, accuracy
|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, weapon_range, accuracy
|where=subcategory_id = "09" AND NOT Weapons.item_id = "01098703" AND
|where=subcategory_id = "09" AND
NOT Weapons.item_id = "01097A03" AND  
NOT Weapons.item_id = "01094F03" AND
NOT Weapons.item_id = "01094F03" AND  
NOT Weapons.item_id = "01094603" AND
NOT Weapons.item_id = "01094603" AND  
NOT Weapons.item_id = "01094403" AND
NOT Weapons.item_id = "01094403" AND  
NOT Weapons.item_id = "01092E03" AND
NOT Weapons.item_id = "01092E03" AND  
NOT Weapons.item_id = "01092503" AND
NOT Weapons.item_id = "01092503" AND
NOT Weapons.item_id = "01091803" AND
NOT Weapons.item_id = "01091C00" AND
NOT Weapons.item_id = "01091200" AND
NOT Weapons.item_id = "01091900" AND  
NOT Weapons.item_id = "01090E01" AND
NOT Weapons.item_id = "01091803" AND
NOT Weapons.item_id = "01090E03" AND
NOT Weapons.item_id = "01091800" AND  
NOT Weapons.item_id = "01090E03" AND
NOT Weapons.item_id = "01091200" AND  
NOT Weapons.item_id = "01090B02" AND
NOT Weapons.item_id = "01090E01" AND  
NOT Weapons.item_id = "01090E03" AND  
NOT Weapons.item_id = "01090E03" AND  
NOT Weapons.item_id = "01090B02" AND  
NOT Weapons.item_id = "01090902"
NOT Weapons.item_id = "01090902"
|join on=Weapons.rank = Ranks.sort_order
|join on=Weapons.rank = Ranks.sort_order
Line 216: Line 171:
|Daggers={{#cargo_query:tables=Weapons,Ranks
|Daggers={{#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, 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, weapon_range, accuracy
|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, weapon_range, accuracy
|where=subcategory_id = "0A" AND NOT Weapons.item_id = "010A4903" AND  
|where=subcategory_id = "0A" AND
NOT Weapons.item_id = "010A1E03" AND
NOT Weapons.item_id = "010A1E03" AND
NOT Weapons.item_id = "010A4403" AND
NOT Weapons.item_id = "010A2C03" AND
NOT Weapons.item_id = "010A3F03" AND
NOT Weapons.item_id = "010A1D03" AND
NOT Weapons.item_id = "010A3E03" AND
NOT Weapons.item_id = "010A1C03"
NOT Weapons.item_id = "010A3C03" AND
NOT Weapons.item_id = "010A3D03" AND
NOT Weapons.item_id = "010A3B03" AND  
NOT Weapons.item_id = "010A2C03" AND  
NOT Weapons.item_id = "010A1D03" AND  
NOT Weapons.item_id = "010A1C03" AND
NOT Weapons.item_id = "010A1101" AND
NOT Weapons.item_id = "010A1001"
|join on=Weapons.rank = Ranks.sort_order
|join on=Weapons.rank = Ranks.sort_order
|format=template
|format=template
Line 240: Line 187:
|Claws={{#cargo_query:tables=Weapons,Ranks
|Claws={{#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, 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, weapon_range, accuracy
|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, weapon_range, accuracy
|where=subcategory_id = "0B" AND NOT Weapons.item_id = "010B3103" AND
|where=subcategory_id = "0B" AND  
NOT Weapons.item_id = "010B2F03" AND  
NOT Weapons.item_id = "010B1D03"
NOT Weapons.item_id = "010B1D03" AND
NOT Weapons.item_id = "010B0F01" AND
NOT Weapons.item_id = "010B0E01"
|join on=Weapons.rank = Ranks.sort_order
|join on=Weapons.rank = Ranks.sort_order
|format=template
|format=template
Line 256: Line 200:
|Whips={{#cargo_query:tables=Weapons,Ranks
|Whips={{#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, 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, weapon_range, accuracy
|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, weapon_range, accuracy
|where=subcategory_id = "0C" AND NOT Weapons.item_id = "010C2B03" AND
|where=subcategory_id = "0C" AND
NOT Weapons.item_id = "010C2703" AND
NOT Weapons.item_id = "010C1103" AND
NOT Weapons.item_id = "010C2503" AND
NOT Weapons.item_id = "010C0A03" AND
NOT Weapons.item_id = "010C1502" AND
NOT Weapons.item_id = "010C0803" AND
NOT Weapons.item_id = "010C1402" AND  
NOT Weapons.item_id = "010C0703" AND
NOT Weapons.item_id = "010C1103" AND
NOT Weapons.item_id = "010C0C00" AND  
NOT Weapons.item_id = "010C0A03" AND  
NOT Weapons.item_id = "010C0803" AND  
NOT Weapons.item_id = "010C0703" AND  
NOT Weapons.item_id = "010C0603"
NOT Weapons.item_id = "010C0603"
|join on=Weapons.rank = Ranks.sort_order
|join on=Weapons.rank = Ranks.sort_order
Line 278: Line 217:
|Slicers={{#cargo_query:tables=Weapons,Ranks
|Slicers={{#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, 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, accuracy
|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, accuracy
|where=subcategory_id = "0D" AND NOT Weapons.item_id = "010D3C03" AND
|where=subcategory_id = "0D" AND
NOT Weapons.item_id = "010D3A03" AND
NOT Weapons.item_id = "010D1903" AND
NOT Weapons.item_id = "010D3703" AND
NOT Weapons.item_id = "010D1203" AND
NOT Weapons.item_id = "010D3003" AND  
NOT Weapons.item_id = "010D1003" AND
NOT Weapons.item_id = "010D1903" AND  
NOT Weapons.item_id = "010D0503" AND
NOT Weapons.item_id = "010D1203" AND
NOT Weapons.item_id = "010D0403" AND
NOT Weapons.item_id = "010D1201" AND  
NOT Weapons.item_id = "010D1003" AND
NOT Weapons.item_id = "010D1101" AND  
NOT Weapons.item_id = "010D0503" AND  
NOT Weapons.item_id = "010D0403" AND  
NOT Weapons.item_id = "010CFF03"
NOT Weapons.item_id = "010CFF03"
|join on=Weapons.rank = Ranks.sort_order
|join on=Weapons.rank = Ranks.sort_order
Line 301: Line 235:
|Rifles={{#cargo_query:tables=Weapons,Ranks
|Rifles={{#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, 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, accuracy
|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, accuracy
|where=subcategory_id = "0E" AND NOT Weapons.item_id = "010E3B03" AND
|where=subcategory_id = "0E" AND
NOT Weapons.item_id = "010E3703" AND
NOT Weapons.item_id = "010E1000" AND
NOT Weapons.item_id = "010E3403" AND
NOT Weapons.item_id = "010E0D02" AND
NOT Weapons.item_id = "010E1300" AND
NOT Weapons.item_id = "010E1200" AND
NOT Weapons.item_id = "010E1100" AND  
NOT Weapons.item_id = "010E1000" AND  
NOT Weapons.item_id = "010E0D02" AND  
NOT Weapons.item_id = "010E0A03"
NOT Weapons.item_id = "010E0A03"
|join on=Weapons.rank = Ranks.sort_order
|join on=Weapons.rank = Ranks.sort_order
Line 321: Line 250:
|Shotguns={{#cargo_query:tables=Weapons,Ranks
|Shotguns={{#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, 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, accuracy, IF(penetration_override = 1, 'Yes', 'No') = penetration override
|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, accuracy, IF(penetration_override = 1, 'Yes', 'No') = penetration override
|where=subcategory_id = "0F" AND NOT Weapons.item_id = "010F3003" AND
|where=subcategory_id = "0F"
NOT Weapons.item_id = "010F2903" AND
NOT Weapons.item_id = "010F1B02" AND
NOT Weapons.item_id = "010F1A02" AND
NOT Weapons.item_id = "010F1702" AND
NOT Weapons.item_id = "010F1602" AND
NOT Weapons.item_id = "010F1502" AND
NOT Weapons.item_id = "010F1402" AND
NOT Weapons.item_id = "010F1302"
|join on=Weapons.rank = Ranks.sort_order
|join on=Weapons.rank = Ranks.sort_order
|format=template
|format=template
Line 341: Line 262:
|Longbows={{#cargo_query:tables=Weapons,Ranks
|Longbows={{#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, 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, accuracy
|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, accuracy
|where=subcategory_id = "10" AND NOT Weapons.item_id = "01102B03" AND
|where=subcategory_id = "10" AND
NOT Weapons.item_id = "01102703" AND
NOT Weapons.item_id = "01100E01" AND
NOT Weapons.item_id = "01100F01" AND  
NOT Weapons.item_id = "01100E01" AND  
NOT Weapons.item_id = "01100B03"
NOT Weapons.item_id = "01100B03"
|join on=Weapons.rank = Ranks.sort_order
|join on=Weapons.rank = Ranks.sort_order
Line 357: Line 276:
|Grenades={{#cargo_query:tables=Weapons,Ranks
|Grenades={{#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, 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, accuracy, subcategory_id, model_id
|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, accuracy, subcategory_id, model_id
|where=subcategory_id = "11" AND NOT Weapons.item_id = "01114103" AND
|where=subcategory_id = "11" AND
NOT Weapons.item_id = "01113C03" AND  
NOT Weapons.item_id = "01111103" AND
NOT Weapons.item_id = "01111103" AND  
NOT Weapons.item_id = "01111003" AND
NOT Weapons.item_id = "01111003" AND
NOT Weapons.item_id = "01110A03"
NOT Weapons.item_id = "01110E02" AND  
NOT Weapons.item_id = "01110A03" AND
NOT Weapons.item_id = "01110F02"
|join on=Weapons.rank = Ranks.sort_order
|join on=Weapons.rank = Ranks.sort_order
|format=template
|format=template
Line 375: Line 291:
|Laser Cannons={{#cargo_query:tables=Weapons,Ranks
|Laser Cannons={{#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, 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, accuracy
|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, accuracy
|where=subcategory_id = "12" AND NOT Weapons.item_id = "01122D03" AND
|where=subcategory_id = "12" AND
NOT Weapons.item_id = "01122A03" AND
NOT Weapons.item_id = "01122A03" AND
NOT Weapons.item_id = "01121700" AND  
NOT Weapons.item_id = "01120713"
NOT Weapons.item_id = "01120713"
|join on=Weapons.rank = Ranks.sort_order
|join on=Weapons.rank = Ranks.sort_order
Line 391: Line 304:
|Twin Handguns={{#cargo_query:tables=Weapons,Ranks
|Twin Handguns={{#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, 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, accuracy
|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, accuracy
|where=subcategory_id = "13" AND NOT Weapons.item_id = "01133E03" AND
|where=subcategory_id = "13" AND
NOT Weapons.item_id = "01133B03" AND
NOT Weapons.item_id = "01132503" AND
NOT Weapons.item_id = "01133803" AND  
NOT Weapons.item_id = "01131303" AND
NOT Weapons.item_id = "01132503" AND
NOT Weapons.item_id = "01131502" AND
NOT Weapons.item_id = "01131400" AND
NOT Weapons.item_id = "01131402" AND  
NOT Weapons.item_id = "01131303" AND  
NOT Weapons.item_id = "01131103"
NOT Weapons.item_id = "01131103"
|join on=Weapons.rank = Ranks.sort_order
|join on=Weapons.rank = Ranks.sort_order
Line 411: Line 319:
|Handguns={{#cargo_query:tables=Weapons,Ranks
|Handguns={{#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, 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, accuracy
|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, accuracy
|where=subcategory_id = "14" AND NOT Weapons.item_id = "01143B03" AND  
|where=subcategory_id = "14" AND
NOT Weapons.item_id = "01142203" AND
NOT Weapons.item_id = "01142203" AND
NOT Weapons.item_id = "01141000" AND  
NOT Weapons.item_id = "01140F03"
NOT Weapons.item_id = "01140F03" AND
NOT Weapons.item_id = "01140C02" AND
NOT Weapons.item_id = "01140B02"
|join on=Weapons.rank = Ranks.sort_order
|join on=Weapons.rank = Ranks.sort_order
|format=template
|format=template
Line 428: Line 333:
|Crossbows={{#cargo_query:tables=Weapons,Ranks
|Crossbows={{#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, 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, accuracy
|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, accuracy
|where=subcategory_id = "15" AND NOT Weapons.item_id = "01151B03" AND  
|where=subcategory_id = "15" AND
NOT Weapons.item_id = "01151A03" AND
NOT Weapons.item_id = "01151B03" AND
NOT Weapons.item_id = "01151002" AND
NOT Weapons.item_id = "01151A03" AND
NOT Weapons.item_id = "01150E02" AND
NOT Weapons.item_id = "01150F02" AND  
NOT Weapons.item_id = "01150600"
NOT Weapons.item_id = "01150600"
|join on=Weapons.rank = Ranks.sort_order
|join on=Weapons.rank = Ranks.sort_order
Line 445: Line 348:
|Cards={{#cargo_query:tables=Weapons,Ranks
|Cards={{#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, 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, accuracy
|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, accuracy
|where=subcategory_id = "16" AND NOT Weapons.item_id = "01162703" AND
|where=subcategory_id = "16"
NOT Weapons.item_id = "01162003" AND
NOT Weapons.item_id = "01161F03" AND
NOT Weapons.item_id = "01160E01" AND
NOT Weapons.item_id = "01160D01" AND
NOT Weapons.item_id = "01160C01"
|join on=Weapons.rank = Ranks.sort_order
|join on=Weapons.rank = Ranks.sort_order
|format=template
|format=template
Line 462: Line 360:
|Machineguns={{#cargo_query:tables=Weapons,Ranks
|Machineguns={{#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, 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, accuracy
|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, accuracy
|where=subcategory_id = "17" AND NOT Weapons.item_id = "01172E03" AND
|where=subcategory_id = "17" AND
NOT Weapons.item_id = "01172803" AND  
NOT Weapons.item_id = "01171703" AND
NOT Weapons.item_id = "01171703" AND
NOT Weapons.item_id = "01170C03" AND
NOT Weapons.item_id = "01171400" AND
NOT Weapons.item_id = "01171300" AND  
NOT Weapons.item_id = "01170C03" AND  
NOT Weapons.item_id = "01170803"
NOT Weapons.item_id = "01170803"
|join on=Weapons.rank = Ranks.sort_order
|join on=Weapons.rank = Ranks.sort_order
Line 480: Line 375:
|Rods={{#cargo_query:tables=Weapons,Ranks
|Rods={{#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, 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 = "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
Line 496: Line 387:
|Wands={{#cargo_query:tables=Weapons,Ranks
|Wands={{#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, 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 = "19" AND NOT Weapons.item_id = "01194F03" AND  
|where=subcategory_id = "19" AND
NOT Weapons.item_id = "01194700" AND  
NOT Weapons.item_id = "01194700" AND
NOT Weapons.item_id = "01194600" AND  
NOT Weapons.item_id = "01194600" AND
NOT Weapons.item_id = "01193603" AND
NOT Weapons.item_id = "01193603" AND
NOT Weapons.item_id = "01191A01" AND
NOT Weapons.item_id = "01191101" AND
NOT Weapons.item_id = "01191901" AND
NOT Weapons.item_id = "01191103" AND
NOT Weapons.item_id = "01191801" AND
NOT Weapons.item_id = "01190903" AND
NOT Weapons.item_id = "01191701" AND
NOT Weapons.item_id = "01190403" AND
NOT Weapons.item_id = "01191601" AND
NOT Weapons.item_id = "01191401" AND
NOT Weapons.item_id = "01191501" AND  
NOT Weapons.item_id = "01191101" AND  
NOT Weapons.item_id = "01191103" AND  
NOT Weapons.item_id = "01190903" AND  
NOT Weapons.item_id = "01190403" AND  
NOT Weapons.item_id = "01190203"
NOT Weapons.item_id = "01190203"
|join on=Weapons.rank = Ranks.sort_order
|join on=Weapons.rank = Ranks.sort_order
Line 523: Line 407:
|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" AND NOT Weapons.item_id = "011A3B03" AND
|where=subcategory_id = "1A" AND
NOT Weapons.item_id = "011A2700" AND
NOT Weapons.item_id = "011A1403" AND
NOT Weapons.item_id = "011A2800" AND  
NOT Weapons.item_id = "011A0A03" AND
NOT Weapons.item_id = "011A1403" AND  
NOT Weapons.item_id = "011A0803" AND
NOT Weapons.item_id = "011A0A03" AND  
NOT Weapons.item_id = "011A0301"  
NOT Weapons.item_id = "011A0803" AND  
NOT Weapons.item_id = "011A0301"
|join on=Weapons.rank = Ranks.sort_order
|join on=Weapons.rank = Ranks.sort_order
|format=template
|format=template
Line 541: Line 423:
|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, rcsm_number_of_shot
|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 = "011B2000" AND
NOT Weapons.item_id = "011B2103" AND
NOT Weapons.item_id = "011B1F00" AND  
NOT Weapons.item_id = "011B1B00" AND
NOT Weapons.item_id = "011B1B00" AND  
NOT Weapons.item_id = "011B1C00" AND
NOT Weapons.item_id = "011B1C00" AND  
NOT Weapons.item_id = "011B1900" AND
NOT Weapons.item_id = "011B1900" AND  
NOT Weapons.item_id = "011B1800" AND
NOT Weapons.item_id = "011B1800" AND  
NOT Weapons.item_id = "011B1600" AND
NOT Weapons.item_id = "011B1600" AND  
NOT Weapons.item_id = "011B1703" AND
NOT Weapons.item_id = "011B1703" AND  
NOT Weapons.item_id = "011B1500" AND
NOT Weapons.item_id = "011B1500" AND  
NOT Weapons.item_id = "011B1400" AND
NOT Weapons.item_id = "011B1400" AND  
NOT Weapons.item_id = "011B1300" AND
NOT Weapons.item_id = "011B1300" AND  
NOT Weapons.item_id = "011B1303" AND
NOT Weapons.item_id = "011B1303" AND  
NOT Weapons.item_id = "011B1203" AND
NOT Weapons.item_id = "011B1203" AND  
NOT Weapons.item_id = "011B1200" AND
NOT Weapons.item_id = "011B1200" AND  
NOT Weapons.item_id = "011B1000" AND
NOT Weapons.item_id = "011B1000" AND  
NOT Weapons.item_id = "011B1100" AND
NOT Weapons.item_id = "011B1100" AND  
NOT Weapons.item_id = "011B0F00" AND
NOT Weapons.item_id = "011B0F00" AND  
NOT Weapons.item_id = "011B0D03" AND
NOT Weapons.item_id = "011B0D03" AND  
NOT Weapons.item_id = "011B0D00" AND
NOT Weapons.item_id = "011B0D00" AND  
NOT Weapons.item_id = "011B0E00" AND
NOT Weapons.item_id = "011B0E00" AND  
NOT Weapons.item_id = "011B0503" AND
NOT Weapons.item_id = "011B0503" AND  
NOT Weapons.item_id = "011B0502" AND
NOT Weapons.item_id = "011B0502" AND  
NOT Weapons.item_id = "011B0402"
NOT Weapons.item_id = "011B0402"
|join on=Weapons.rank = Ranks.sort_order
|join on=Weapons.rank = Ranks.sort_order

Revision as of 21:59, 6 June 2024

Shorthand to generate a weapon list per category.

Retrieved from ‘https://psu-clementine.com/wiki/index.php?title=Template:Weapon_List&oldid=49782’