User:Mika/sandbox: Difference between revisions

From Phantasy Star Universe Clementine
(Replaced content with "{{#cargo_query:tables=Weapons,Ranks |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...")
Tag: Replaced
Line 1: Line 1:
Default fields: Rarity, Name, MFR, PP, ATK_STAT, PA_MOD, VAR, STAT_EQUIP, SE
==List of Swords==
Special fields: Crit Mod, SE Mod, Range, Accuracy
{{#cargo_query:tables=Weapons,Ranks
{{#cargo_query:tables=Weapons,Ranks
|fields=rarity, 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=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 = "01" AND Weapons.name NOT LIKE '%/Z' AND Weapons.name NOT LIKE '%*'
|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
|join on=Weapons.rank = Ranks.sort_order
|format=template
|order by=rank, name
|template=Cargo Rows/Weapon Lists
|limit=256
|named args=yes
|intro={{Cargo Rows/Weapon Lists/Start|weapon type=Sword}}
|outro={{!}}}
|limit=25
|default={{Cargo Rows/default}}
}}
 
==List of Knuckles==
Special fields: Crit Mod, SE Mod, Range, Accuracy
{{#cargo_query:tables=Weapons,Ranks
|fields=rarity, 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 Weapons.name NOT LIKE '%/Z' AND Weapons.name NOT LIKE '%*'
|join on=Weapons.rank = Ranks.sort_order
|format=template
|template=Cargo Rows/Weapon Lists
|named args=yes
|intro={{Cargo Rows/Weapon Lists/Start|weapon type=Knuckles}}
|outro={{!}}}
|limit=3
|default={{Cargo Rows/default}}
}}
==List of Spears==
Special fields: Crit Mod, SE Mod, Range, Accuracy
{{#cargo_query:tables=Weapons,Ranks
|fields=rarity, 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 Weapons.name NOT LIKE '%/Z' AND Weapons.name NOT LIKE '%*'
|join on=Weapons.rank = Ranks.sort_order
|format=template
|template=Cargo Rows/Weapon Lists
|named args=yes
|intro={{Cargo Rows/Weapon Lists/Start|weapon type=Spear}}
|outro={{!}}}
|limit=3
|default={{Cargo Rows/default}}
}}
==List of Double Sabers==
Special fields: Crit Mod, SE Mod, Range, Accuracy
{{#cargo_query:tables=Weapons,Ranks
|fields=rarity, 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 Weapons.name NOT LIKE '%/Z' AND Weapons.name NOT LIKE '%*'
|join on=Weapons.rank = Ranks.sort_order
|format=template
|template=Cargo Rows/Weapon Lists
|named args=yes
|intro={{Cargo Rows/Weapon Lists/Start|weapon type=Double Saber}}
|outro={{!}}}
|limit=3
|default={{Cargo Rows/default}}
}}
==List of Axes==
Special fields: Crit Mod, SE Mod, Range, Accuracy
{{#cargo_query:tables=Weapons,Ranks
|fields=rarity, 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 Weapons.name NOT LIKE '%/Z' AND Weapons.name NOT LIKE '%*'
|join on=Weapons.rank = Ranks.sort_order
|format=template
|template=Cargo Rows/Weapon Lists
|named args=yes
|intro={{Cargo Rows/Weapon Lists/Start|weapon type=Axe}}
|outro={{!}}}
|limit=3
|default={{Cargo Rows/default}}
}}
==List of Twin Sabers==
Special fields: Crit Mod, SE Mod, Range, Accuracy
{{#cargo_query:tables=Weapons,Ranks
|fields=rarity, 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 Weapons.name NOT LIKE '%/Z' AND Weapons.name NOT LIKE '%*'
|join on=Weapons.rank = Ranks.sort_order
|format=template
|template=Cargo Rows/Weapon Lists
|named args=yes
|intro={{Cargo Rows/Weapon Lists/Start|weapon type=Twin Saber}}
|outro={{!}}}
|limit=3
|default={{Cargo Rows/default}}
}}
==List of Twin Daggers==
Special fields: Crit Mod, SE Mod, Range, Accuracy
{{#cargo_query:tables=Weapons,Ranks
|fields=rarity, 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 Weapons.name NOT LIKE '%/Z' AND Weapons.name NOT LIKE '%*'
|join on=Weapons.rank = Ranks.sort_order
|format=template
|template=Cargo Rows/Weapon Lists
|named args=yes
|intro={{Cargo Rows/Weapon Lists/Start|weapon type=Twin Dagger}}
|outro={{!}}}
|limit=3
|default={{Cargo Rows/default}}
}}
==List of Twin Claws==
Special fields: Crit Mod, SE Mod, Range, Accuracy
{{#cargo_query:tables=Weapons,Ranks
|fields=rarity, 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 Weapons.name NOT LIKE '%/Z' AND Weapons.name NOT LIKE '%*'
|join on=Weapons.rank = Ranks.sort_order
|format=template
|template=Cargo Rows/Weapon Lists
|named args=yes
|intro={{Cargo Rows/Weapon Lists/Start|weapon type=Twin Saber}}
|outro={{!}}}
|limit=3
|default={{Cargo Rows/default}}
}}
==List of Sabers==
Special fields: Crit Mod, SE Mod, Range, Accuracy
{{#cargo_query:tables=Weapons,Ranks
|fields=rarity, 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 Weapons.name NOT LIKE '%/Z' AND Weapons.name NOT LIKE '%*'
|join on=Weapons.rank = Ranks.sort_order
|format=template
|template=Cargo Rows/Weapon Lists
|named args=yes
|intro={{Cargo Rows/Weapon Lists/Start|weapon type=Saber}}
|outro={{!}}}
|limit=3
|default={{Cargo Rows/default}}
}}
==List of Daggers==
Special fields: Crit Mod, SE Mod, Range, Accuracy
{{#cargo_query:tables=Weapons,Ranks
|fields=rarity, 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 Weapons.name NOT LIKE '%/Z' AND Weapons.name NOT LIKE '%*'
|join on=Weapons.rank = Ranks.sort_order
|format=template
|template=Cargo Rows/Weapon Lists
|named args=yes
|intro={{Cargo Rows/Weapon Lists/Start|weapon type=Dagger}}
|outro={{!}}}
|limit=3
|default={{Cargo Rows/default}}
}}
==List of Claws==
Special fields: Crit Mod, SE Mod, Range, Accuracy
{{#cargo_query:tables=Weapons,Ranks
|fields=rarity, 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 Weapons.name NOT LIKE '%/Z' AND Weapons.name NOT LIKE '%*'
|join on=Weapons.rank = Ranks.sort_order
|format=template
|template=Cargo Rows/Weapon Lists
|named args=yes
|intro={{Cargo Rows/Weapon Lists/Start|weapon type=Claw}}
|outro={{!}}}
|limit=3
|default={{Cargo Rows/default}}
}}
==List of Whips==
Special fields: Crit Mod, SE Mod, Range, Accuracy
{{#cargo_query:tables=Weapons,Ranks
|fields=rarity, 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 Weapons.name NOT LIKE '%/Z' AND Weapons.name NOT LIKE '%*'
|join on=Weapons.rank = Ranks.sort_order
|format=template
|template=Cargo Rows/Weapon Lists
|named args=yes
|intro={{Cargo Rows/Weapon Lists/Start|weapon type=Whip}}
|outro={{!}}}
|limit=3
|default={{Cargo Rows/default}}
}}
==List of Slicers==
Special fields: Crit Mod, SE Mod, Accuracy
{{#cargo_query:tables=Weapons,Ranks
|fields=rarity, 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 Weapons.name NOT LIKE '%/Z' AND Weapons.name NOT LIKE '%*'
|join on=Weapons.rank = Ranks.sort_order
|format=template
|template=Cargo Rows/Weapon Lists
|named args=yes
|intro={{Cargo Rows/Weapon Lists/Start|weapon type=Slicer}}
|outro={{!}}}
|limit=3
|default={{Cargo Rows/default}}
}}
==List of Rifles==
Special fields: Crit Mod, SE Mod, Accuracy
{{#cargo_query:tables=Weapons,Ranks
|fields=rarity, 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 Weapons.name NOT LIKE '%/Z' AND Weapons.name NOT LIKE '%*'
|join on=Weapons.rank = Ranks.sort_order
|format=template
|template=Cargo Rows/Weapon Lists
|named args=yes
|intro={{Cargo Rows/Weapon Lists/Start|weapon type=Rifle}}
|outro={{!}}}
|limit=3
|default={{Cargo Rows/default}}
}}
==List of Shotguns==
Special fields: Crit Mod, SE Mod, Accuracy, Penetration
{{#cargo_query:tables=Weapons,Ranks
|fields=rarity, 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 Weapons.name NOT LIKE '%/Z' AND Weapons.name NOT LIKE '%*'
|join on=Weapons.rank = Ranks.sort_order
|format=template
|template=Cargo Rows/Weapon Lists
|named args=yes
|intro={{Cargo Rows/Weapon Lists/Start|weapon type=Shotgun}}
|outro={{!}}}
|limit=3
|default={{Cargo Rows/default}}
}}
 
==List of Longbows==
Special fields: Crit Mod, SE Mod, Accuracy
{{#cargo_query:tables=Weapons,Ranks
|fields=rarity, 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 Weapons.name NOT LIKE '%/Z' AND Weapons.name NOT LIKE '%*'
|join on=Weapons.rank = Ranks.sort_order
|format=template
|template=Cargo Rows/Weapon Lists
|named args=yes
|intro={{Cargo Rows/Weapon Lists/Start|weapon type=Longbow}}
|outro={{!}}}
|limit=3
|default={{Cargo Rows/default}}
}}
==List of Grenades==
Special fields: Crit Mod, SE Mod, Accuracy
{{#cargo_query:tables=Weapons,Ranks
|fields=rarity, 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 = "11" AND Weapons.name NOT LIKE '%/Z' AND Weapons.name NOT LIKE '%*'
|join on=Weapons.rank = Ranks.sort_order
|format=template
|template=Cargo Rows/Weapon Lists
|named args=yes
|intro={{Cargo Rows/Weapon Lists/Start|weapon type=Grenade}}
|outro={{!}}}
|limit=3
|default={{Cargo Rows/default}}
}}
==List of Laser Cannons==
Special fields: Crit Mod, SE Mod, Accuracy
{{#cargo_query:tables=Weapons,Ranks
|fields=rarity, 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 Weapons.name NOT LIKE '%/Z' AND Weapons.name NOT LIKE '%*'
|join on=Weapons.rank = Ranks.sort_order
|format=template
|template=Cargo Rows/Weapon Lists
|named args=yes
|intro={{Cargo Rows/Weapon Lists/Start|weapon type=Laser Cannon}}
|outro={{!}}}
|limit=3
|default={{Cargo Rows/default}}
}}
==List of Twin Handguns==
Special fields: Crit Mod, SE Mod, Accuracy
{{#cargo_query:tables=Weapons,Ranks
|fields=rarity, 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 Weapons.name NOT LIKE '%/Z' AND Weapons.name NOT LIKE '%*'
|join on=Weapons.rank = Ranks.sort_order
|format=template
|template=Cargo Rows/Weapon Lists
|named args=yes
|intro={{Cargo Rows/Weapon Lists/Start|weapon type=Twin Handgun}}
|outro={{!}}}
|limit=3
|default={{Cargo Rows/default}}
}}
==List of Handguns==
Special fields: Crit Mod, SE Mod, Accuracy
{{#cargo_query:tables=Weapons,Ranks
|fields=rarity, 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 Weapons.name NOT LIKE '%/Z' AND Weapons.name NOT LIKE '%*'
|join on=Weapons.rank = Ranks.sort_order
|format=template
|template=Cargo Rows/Weapon Lists
|named args=yes
|intro={{Cargo Rows/Weapon Lists/Start|weapon type=Handgun}}
|outro={{!}}}
|limit=3
|default={{Cargo Rows/default}}
}}
==List of Crossbows==
Special fields: Crit Mod, SE Mod, Accuracy
{{#cargo_query:tables=Weapons,Ranks
|fields=rarity, 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 Weapons.name NOT LIKE '%/Z' AND Weapons.name NOT LIKE '%*'
|join on=Weapons.rank = Ranks.sort_order
|format=template
|template=Cargo Rows/Weapon Lists
|named args=yes
|intro={{Cargo Rows/Weapon Lists/Start|weapon type=Crossbow}}
|outro={{!}}}
|limit=3
|default={{Cargo Rows/default}}
}}
==List of Cards==
Special fields: Crit Mod, SE Mod, Accuracy
{{#cargo_query:tables=Weapons,Ranks
|fields=rarity, 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 Weapons.name NOT LIKE '%/Z' AND Weapons.name NOT LIKE '%*'
|join on=Weapons.rank = Ranks.sort_order
|format=template
|template=Cargo Rows/Weapon Lists
|named args=yes
|intro={{Cargo Rows/Weapon Lists/Start|weapon type=Card}}
|outro={{!}}}
|limit=3
|default={{Cargo Rows/default}}
}}
==List of Machineguns==
Special fields: Crit Mod, SE Mod, Accuracy
{{#cargo_query:tables=Weapons,Ranks
|fields=rarity, 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 Weapons.name NOT LIKE '%/Z' AND Weapons.name NOT LIKE '%*'
|join on=Weapons.rank = Ranks.sort_order
|format=template
|template=Cargo Rows/Weapon Lists
|named args=yes
|intro={{Cargo Rows/Weapon Lists/Start|weapon type=Machinegun}}
|outro={{!}}}
|limit=3
|default={{Cargo Rows/default}}
}}
==List of Rods==
Special fields: Crit Mod, SE Mod
{{#cargo_query:tables=Weapons,Ranks
|fields=rarity, 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 Weapons.name NOT LIKE '%/Z' AND Weapons.name NOT LIKE '%*'
|join on=Weapons.rank = Ranks.sort_order
|format=template
|template=Cargo Rows/Weapon Lists
|named args=yes
|intro={{Cargo Rows/Weapon Lists/Start|weapon type=Rod}}
|outro={{!}}}
|limit=3
|default={{Cargo Rows/default}}
}}
==List of Wands==
Special fields: Crit Mod, SE Mod
{{#cargo_query:tables=Weapons,Ranks
|fields=rarity, 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 Weapons.name NOT LIKE '%/Z' AND Weapons.name NOT LIKE '%*'
|join on=Weapons.rank = Ranks.sort_order
|format=template
|template=Cargo Rows/Weapon Lists
|named args=yes
|intro={{Cargo Rows/Weapon Lists/Start|weapon type=Wand}}
|outro={{!}}}
|limit=3
|default={{Cargo Rows/default}}
}}
==List of TCSMs==
Special fields: Crit Mod, SE Mod
{{#cargo_query:tables=Weapons,Ranks
|fields=rarity, 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 Weapons.name NOT LIKE '%/Z' AND Weapons.name NOT LIKE '%*'
|join on=Weapons.rank = Ranks.sort_order
|format=template
|template=Cargo Rows/Weapon Lists
|named args=yes
|intro={{Cargo Rows/Weapon Lists/Start|weapon type=TCSM}}
|outro={{!}}}
|limit=3
|default={{Cargo Rows/default}}
}}
==List of RCSMs==
Special fields: Accuracy, explicit SEs, shot type, shot delay
{{#cargo_query:tables=Weapons,Ranks
|fields=rarity, 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
|where=subcategory_id = "1B" AND Weapons.name NOT LIKE '%/Z' AND Weapons.name NOT LIKE '%*'
|join on=Weapons.rank = Ranks.sort_order
|format=template
|template=Cargo Rows/Weapon Lists
|named args=yes
|intro={{Cargo Rows/Weapon Lists/Start|weapon type=RCSM}}
|outro={{!}}}
|limit=500
|default={{Cargo Rows/default}}
|default={{Cargo Rows/default}}
}}
}}

Revision as of 13:48, 15 May 2024

name pagename 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
Dragon Slayer Dragon Slayer A 01 1 2 1 2 1 2 1 2 1 2 1 2 1 2
Elysion Elysion A 09 1 3 1 3 1 3 1 3 1 3 1 3 1 3
Elysions Elysions A 06 1 3 1 3 1 3 1 3 1 3 1 3 1 3
Evil Fang Evil Fang A 0B 1 3 1 3 1 3 1 3 1 3 1 3 1 3
Frying Pan Frying Pan A 09 1 2 1 2 1 2 1 2 1 2 1 2 1 2
GIRLS Bouquet GIRLS Bouquet A 09 1 3 1 3 1 3 1 3 1 3 1 3 1 3
GIRLS Bouquet Set GIRLS Bouquet Set A 06 1 3 1 3 1 3 1 3 1 3 1 3 1 3
Nightmare Dust Nightmare Dust A 08 1 2 1 2 1 2 1 2 1 2 1 2 1 2
Power Whip Power Whip A 0C 1 3 1 3 1 3 1 3 1 3 1 3 1 3
Ra Bangle Ra Bangle A 0A 1 2 1 2 1 2 1 2 1 2 1 2 1 2
Ra Bangle/U Ra Bangle/U A 0A 1 2 1 2 1 2 1 2 1 2 1 2 1 2
Ra Bangler Ra Bangler A 07 1 2 1 2 1 2 1 2 1 2 1 2 1 2
Ra Bangler/U Ra Bangler/U A 07 1 2 1 2 1 2 1 2 1 2 1 2 1 2
Vish Kuseb Vish Kuseb A 0C 0 0 1 2 6 2 0 0 0 0 0 0 0 0
Drago Puppet Drago Puppet B 0B 1 3 1 3 1 3 1 3 1 3 1 3 1 3
Amatsu-mikaboshi Amatsu-mikaboshi S 09 1 3 1 3 1 3 1 3 1 3 1 3 1 3
Amatsu-mikaboshi/U Amatsu-mikaboshi/U S 09 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Amatsu-mikaboshi/U+ Amatsu-mikaboshi/U+ S 09 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Ank Kakka/U Ank Kakka/U S 05 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Ank Kakka/U+ Ank Kakka/U+ S 05 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Beefedge Wellda Beefedge Wellda S 09 1 3 1 3 1 3 1 3 1 3 1 3 1 3
Beefslayer Welldone Beefslayer Welldone S 01 1 2 1 2 1 2 1 2 1 2 1 2 1 2
Blaze Haze Blaze Haze S 04 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Crimson/U Crimson/U S 09 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Crimson/U+ Crimson/U+ S 09 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Dagger of Serafi/U+ Dagger of Serafi/U+ S 07 1 5 1 5 1 5 1 5 1 5 1 5 1 5
De Ragan Slayer De Ragan Slayer S 01 1 1 1 1 1 1 1 1 1 1 1 1 1 1
De Ragan Slayer/U De Ragan Slayer/U S 01 1 5 1 5 1 5 1 5 1 5 1 5 1 5
De Ragan Slayer/U+ De Ragan Slayer/U+ S 01 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Divine Yaoroz/U Divine Yaoroz/U S 06 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Divine Yaoroz/U+ Divine Yaoroz/U+ S 06 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Drago Puppet/U Drago Puppet/U S 0B 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Drago Puppet/U+ Drago Puppet/U+ S 0B 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Dunas Fluge/U+ Dunas Fluge/U+ S 01 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Enma-hiken/U Enma-hiken/U S 0D 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Enma-hiken/U+ Enma-hiken/U+ S 0D 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Evil Fang/U+ Evil Fang/U+ S 0B 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Flamberge Flamberge S 01 1 3 1 3 1 3 1 3 1 3 1 3 1 3
Flamberge/U+ Flamberge/U+ S 01 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Gudda Igga/U Gudda Igga/U S 02 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Guren Guren S 09 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Guren/U+ Guren/U+ S 09 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Halp Serafi/U+ Halp Serafi/U+ S 0A 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Juggernaut Juggernaut S 02 1 3 1 3 1 3 1 3 1 3 1 3 1 3
Juggernaut/U+ Juggernaut/U+ S 02 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Kagu-tsuchi Kagu-tsuchi S 06 0 0 1 3 6 3 1 3 6 3 1 3 6 3
Kagu-tsuchi/U+ Kagu-tsuchi/U+ S 06 0 0 1 5 6 5 1 5 6 5 1 5 6 5
Nightmare Dust/U+ Nightmare Dust/U+ S 08 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Rengokuto Rensa/U Rengokuto Rensa/U S 04 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Rengokuto Rensa/U*+ Rengokuto Rensa/U*+ S 04 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Rengokuto Rensa/U+ Rengokuto Rensa/U+ S 04 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Rep Nasur/U Rep Nasur/U S 03 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Rep Nasur/U+ Rep Nasur/U+ S 03 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Roasted Welldone Roasted Welldone S 05 1 3 1 3 1 3 1 3 1 3 1 3 1 3
Rocket Punchers Rocket Punchers S 02 1 2 1 2 1 2 1 2 1 2 1 2 1 2
Shuzak Shuzak S 01 1 2 1 2 1 2 1 2 1 2 1 2 1 2
Shuzak/U+ Shuzak/U+ S 01 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Toop Yupke/U+ Toop Yupke/U+ S 0D 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Twin Blaze Twin Blaze S 04 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Twin Kitty Claw/U Twin Kitty Claw/U S 08 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Twin Kitty Claw/U*+ Twin Kitty Claw/U*+ S 08 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Twin Kitty Claw/U+ Twin Kitty Claw/U+ S 08 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Two-headed Ragnus/U Two-headed Ragnus/U S 06 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Two-headed Ragnus/U+ Two-headed Ragnus/U+ S 06 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Vermillion/U+ Vermillion/U+ S 02 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Vish Diraga Vish Diraga S 0C 1 3 1 3 1 3 1 3 1 3 1 3 1 3
Vish Diraga/U+ Vish Diraga/U+ S 0C 1 5 1 5 1 5 1 5 1 5 1 5 1 5
Retrieved from ‘https://psu-clementine.com/wiki/index.php?title=User:Mika/sandbox&oldid=42278’