User:Mika/sandbox: Difference between revisions

From Phantasy Star Universe Clementine
mNo edit summary
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
Default fields: Rarity, Name, MFR, PP, ATK_STAT, PA_MOD, VAR, STAT_EQUIP, SE
{{Drop}}
 
==List of Swords==
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 = "01" 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=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}}
}}

Latest revision as of 16:37, 6 July 2025

Drops cannot be included from a namespace.

Retrieved from ‘https://psu-clementine.com/wiki/index.php?title=User:Mika/sandbox&oldid=56721’