Template:Weapon List: Difference between revisions

From Phantasy Star Universe Clementine
(update queries for ultimate patch)
(unblacklist God Hands/U+ (01023803))
 
(4 intermediate revisions by the same user not shown)
Line 25: Line 25:
|limit=256
|limit=256
|default={{Cargo Rows/default}}
|default={{Cargo Rows/default}}
|order by=Weapons.rarity, Weapons.name LIKE '%☆%', Weapons.name LIKE '%/U*+', Weapons.name LIKE '%/U+', Weapons.name LIKE '%/U*', Weapons.name LIKE '%/U', Weapons.name
}}
}}
|Knuckles={{#cargo_query:tables=Weapons,Ranks
|Knuckles={{#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 = "02" AND NOT Weapons.item_id = "01023803" AND  
|where=subcategory_id = "02" AND  
NOT Weapons.item_id = "01022803" AND
NOT Weapons.item_id = "01022803" AND
NOT Weapons.item_id = "01020E02" AND
NOT Weapons.item_id = "01020E02" AND
Line 40: Line 41:
|limit=256
|limit=256
|default={{Cargo Rows/default}}
|default={{Cargo Rows/default}}
|order by=Weapons.rarity, Weapons.name LIKE '%☆%', Weapons.name LIKE '%/U*+', Weapons.name LIKE '%/U+', Weapons.name LIKE '%/U*', Weapons.name LIKE '%/U', Weapons.name
}}
}}
|Spears={{#cargo_query:tables=Weapons,Ranks
|Spears={{#cargo_query:tables=Weapons,Ranks
Line 57: Line 59:
|limit=256
|limit=256
|default={{Cargo Rows/default}}
|default={{Cargo Rows/default}}
|order by=Weapons.rarity, Weapons.name LIKE '%☆%', Weapons.name LIKE '%/U*+', Weapons.name LIKE '%/U+', Weapons.name LIKE '%/U*', Weapons.name LIKE '%/U', Weapons.name
}}
}}
|Double Sabers={{#cargo_query:tables=Weapons,Ranks
|Double Sabers={{#cargo_query:tables=Weapons,Ranks
Line 70: Line 73:
|limit=256
|limit=256
|default={{Cargo Rows/default}}
|default={{Cargo Rows/default}}
|order by=Weapons.rarity, Weapons.name LIKE '%☆%', Weapons.name LIKE '%/U*+', Weapons.name LIKE '%/U+', Weapons.name LIKE '%/U*', Weapons.name LIKE '%/U', Weapons.name
}}
}}
|Axes={{#cargo_query:tables=Weapons,Ranks
|Axes={{#cargo_query:tables=Weapons,Ranks
Line 85: Line 89:
|limit=256
|limit=256
|default={{Cargo Rows/default}}
|default={{Cargo Rows/default}}
|order by=Weapons.rarity, Weapons.name LIKE '%☆%', Weapons.name LIKE '%/U*+', Weapons.name LIKE '%/U+', Weapons.name LIKE '%/U*', Weapons.name LIKE '%/U', Weapons.name
}}
}}
|Twin Sabers={{#cargo_query:tables=Weapons,Ranks
|Twin Sabers={{#cargo_query:tables=Weapons,Ranks
Line 113: Line 118:
|limit=256
|limit=256
|default={{Cargo Rows/default}}
|default={{Cargo Rows/default}}
|order by=Weapons.rarity, Weapons.name LIKE '%☆%', Weapons.name LIKE '%/U*+', Weapons.name LIKE '%/U+', Weapons.name LIKE '%/U*', Weapons.name LIKE '%/U', Weapons.name
}}
}}
|Twin Daggers={{#cargo_query:tables=Weapons,Ranks
|Twin Daggers={{#cargo_query:tables=Weapons,Ranks
Line 129: Line 135:
|limit=256
|limit=256
|default={{Cargo Rows/default}}
|default={{Cargo Rows/default}}
|order by=Weapons.rarity, Weapons.name LIKE '%☆%', Weapons.name LIKE '%/U*+', Weapons.name LIKE '%/U+', Weapons.name LIKE '%/U*', Weapons.name LIKE '%/U', Weapons.name
}}
}}
|Twin Claws={{#cargo_query:tables=Weapons,Ranks
|Twin Claws={{#cargo_query:tables=Weapons,Ranks
Line 144: Line 151:
|limit=256
|limit=256
|default={{Cargo Rows/default}}
|default={{Cargo Rows/default}}
|order by=Weapons.rarity, Weapons.name LIKE '%☆%', Weapons.name LIKE '%/U*+', Weapons.name LIKE '%/U+', Weapons.name LIKE '%/U*', Weapons.name LIKE '%/U', Weapons.name
}}
}}
|Sabers={{#cargo_query:tables=Weapons,Ranks
|Sabers={{#cargo_query:tables=Weapons,Ranks
Line 168: Line 176:
|limit=256
|limit=256
|default={{Cargo Rows/default}}
|default={{Cargo Rows/default}}
|order by=Weapons.rarity, Weapons.name LIKE '%☆%', Weapons.name LIKE '%/U*+', Weapons.name LIKE '%/U+', Weapons.name LIKE '%/U*', Weapons.name LIKE '%/U', Weapons.name
}}
}}
|Daggers={{#cargo_query:tables=Weapons,Ranks
|Daggers={{#cargo_query:tables=Weapons,Ranks
Line 184: Line 193:
|limit=256
|limit=256
|default={{Cargo Rows/default}}
|default={{Cargo Rows/default}}
|order by=Weapons.rarity, Weapons.name LIKE '%☆%', Weapons.name LIKE '%/U*+', Weapons.name LIKE '%/U+', Weapons.name LIKE '%/U*', Weapons.name LIKE '%/U', Weapons.name
}}
}}
|Claws={{#cargo_query:tables=Weapons,Ranks
|Claws={{#cargo_query:tables=Weapons,Ranks
Line 197: Line 207:
|limit=256
|limit=256
|default={{Cargo Rows/default}}
|default={{Cargo Rows/default}}
|order by=Weapons.rarity, Weapons.name LIKE '%☆%', Weapons.name LIKE '%/U*+', Weapons.name LIKE '%/U+', Weapons.name LIKE '%/U*', Weapons.name LIKE '%/U', Weapons.name
}}
}}
|Whips={{#cargo_query:tables=Weapons,Ranks
|Whips={{#cargo_query:tables=Weapons,Ranks
Line 214: Line 225:
|limit=256
|limit=256
|default={{Cargo Rows/default}}
|default={{Cargo Rows/default}}
|order by=Weapons.rarity, Weapons.name LIKE '%☆%', Weapons.name LIKE '%/U*+', Weapons.name LIKE '%/U+', Weapons.name LIKE '%/U*', Weapons.name LIKE '%/U', Weapons.name
}}
}}
|Slicers={{#cargo_query:tables=Weapons,Ranks
|Slicers={{#cargo_query:tables=Weapons,Ranks
Line 232: Line 244:
|limit=256
|limit=256
|default={{Cargo Rows/default}}
|default={{Cargo Rows/default}}
|order by=Weapons.rarity, Weapons.name LIKE '%☆%', Weapons.name LIKE '%/U*+', Weapons.name LIKE '%/U+', Weapons.name LIKE '%/U*', Weapons.name LIKE '%/U', Weapons.name
}}
}}
|Rifles={{#cargo_query:tables=Weapons,Ranks
|Rifles={{#cargo_query:tables=Weapons,Ranks
Line 247: Line 260:
|limit=256
|limit=256
|default={{Cargo Rows/default}}
|default={{Cargo Rows/default}}
|order by=Weapons.rarity, Weapons.name LIKE '%☆%', Weapons.name LIKE '%/U*+', Weapons.name LIKE '%/U+', Weapons.name LIKE '%/U*', Weapons.name LIKE '%/U', Weapons.name
}}
}}
|Shotguns={{#cargo_query:tables=Weapons,Ranks
|Shotguns={{#cargo_query:tables=Weapons,Ranks
Line 259: Line 273:
|limit=256
|limit=256
|default={{Cargo Rows/default}}
|default={{Cargo Rows/default}}
|order by=Weapons.rarity, Weapons.name LIKE '%☆%', Weapons.name LIKE '%/U*+', Weapons.name LIKE '%/U+', Weapons.name LIKE '%/U*', Weapons.name LIKE '%/U', Weapons.name
}}
}}
|Longbows={{#cargo_query:tables=Weapons,Ranks
|Longbows={{#cargo_query:tables=Weapons,Ranks
Line 273: Line 288:
|limit=256
|limit=256
|default={{Cargo Rows/default}}
|default={{Cargo Rows/default}}
|order by=Weapons.rarity, Weapons.name LIKE '%☆%', Weapons.name LIKE '%/U*+', Weapons.name LIKE '%/U+', Weapons.name LIKE '%/U*', Weapons.name LIKE '%/U', Weapons.name
}}
}}
|Grenades={{#cargo_query:tables=Weapons,Ranks
|Grenades={{#cargo_query:tables=Weapons,Ranks
Line 288: Line 304:
|limit=256
|limit=256
|default={{Cargo Rows/default}}
|default={{Cargo Rows/default}}
|order by=Weapons.rarity, Weapons.name LIKE '%☆%', Weapons.name LIKE '%/U*+', Weapons.name LIKE '%/U+', Weapons.name LIKE '%/U*', Weapons.name LIKE '%/U', Weapons.name
}}
}}
|Laser Cannons={{#cargo_query:tables=Weapons,Ranks
|Laser Cannons={{#cargo_query:tables=Weapons,Ranks
Line 301: Line 318:
|limit=256
|limit=256
|default={{Cargo Rows/default}}
|default={{Cargo Rows/default}}
|order by=Weapons.rarity, Weapons.name LIKE '%☆%', Weapons.name LIKE '%/U*+', Weapons.name LIKE '%/U+', Weapons.name LIKE '%/U*', Weapons.name LIKE '%/U', Weapons.name
}}
}}
|Twin Handguns={{#cargo_query:tables=Weapons,Ranks
|Twin Handguns={{#cargo_query:tables=Weapons,Ranks
Line 316: Line 334:
|limit=256
|limit=256
|default={{Cargo Rows/default}}
|default={{Cargo Rows/default}}
|order by=Weapons.rarity, Weapons.name LIKE '%☆%', Weapons.name LIKE '%/U*+', Weapons.name LIKE '%/U+', Weapons.name LIKE '%/U*', Weapons.name LIKE '%/U', Weapons.name
}}
}}
|Handguns={{#cargo_query:tables=Weapons,Ranks
|Handguns={{#cargo_query:tables=Weapons,Ranks
Line 330: Line 349:
|limit=256
|limit=256
|default={{Cargo Rows/default}}
|default={{Cargo Rows/default}}
|order by=Weapons.rarity, Weapons.name LIKE '%☆%', Weapons.name LIKE '%/U*+', Weapons.name LIKE '%/U+', Weapons.name LIKE '%/U*', Weapons.name LIKE '%/U', Weapons.name
}}
}}
|Crossbows={{#cargo_query:tables=Weapons,Ranks
|Crossbows={{#cargo_query:tables=Weapons,Ranks
Line 345: Line 365:
|limit=256
|limit=256
|default={{Cargo Rows/default}}
|default={{Cargo Rows/default}}
|order by=Weapons.rarity, Weapons.name LIKE '%☆%', Weapons.name LIKE '%/U*+', Weapons.name LIKE '%/U+', Weapons.name LIKE '%/U*', Weapons.name LIKE '%/U', Weapons.name
}}
}}
|Cards={{#cargo_query:tables=Weapons,Ranks
|Cards={{#cargo_query:tables=Weapons,Ranks
Line 357: Line 378:
|limit=256
|limit=256
|default={{Cargo Rows/default}}
|default={{Cargo Rows/default}}
|order by=Weapons.rarity, Weapons.name LIKE '%☆%', Weapons.name LIKE '%/U*+', Weapons.name LIKE '%/U+', Weapons.name LIKE '%/U*', Weapons.name LIKE '%/U', Weapons.name
}}
}}
|Machineguns={{#cargo_query:tables=Weapons,Ranks
|Machineguns={{#cargo_query:tables=Weapons,Ranks
Line 372: Line 394:
|limit=256
|limit=256
|default={{Cargo Rows/default}}
|default={{Cargo Rows/default}}
|order by=Weapons.rarity, Weapons.name LIKE '%☆%', Weapons.name LIKE '%/U*+', Weapons.name LIKE '%/U+', Weapons.name LIKE '%/U*', Weapons.name LIKE '%/U', Weapons.name
}}
}}
|Rods={{#cargo_query:tables=Weapons,Ranks
|Rods={{#cargo_query:tables=Weapons,Ranks
Line 384: Line 407:
|limit=256
|limit=256
|default={{Cargo Rows/default}}
|default={{Cargo Rows/default}}
|order by=Weapons.rarity, Weapons.name LIKE '%☆%', Weapons.name LIKE '%/U*+', Weapons.name LIKE '%/U+', Weapons.name LIKE '%/U*', Weapons.name LIKE '%/U', Weapons.name
}}
}}
|Wands={{#cargo_query:tables=Weapons,Ranks
|Wands={{#cargo_query:tables=Weapons,Ranks
Line 404: Line 428:
|limit=256
|limit=256
|default={{Cargo Rows/default}}
|default={{Cargo Rows/default}}
|order by=Weapons.rarity, Weapons.name LIKE '%☆%', Weapons.name LIKE '%/U*+', Weapons.name LIKE '%/U+', Weapons.name LIKE '%/U*', Weapons.name LIKE '%/U', Weapons.name
}}
}}
|TCSMs={{#cargo_query:tables=Weapons,Ranks
|TCSMs={{#cargo_query:tables=Weapons,Ranks
Line 420: Line 445:
|limit=256
|limit=256
|default={{Cargo Rows/default}}
|default={{Cargo Rows/default}}
|order by=Weapons.rarity, Weapons.name LIKE '%☆%', Weapons.name LIKE '%/U*+', Weapons.name LIKE '%/U+', Weapons.name LIKE '%/U*', Weapons.name LIKE '%/U', Weapons.name
}}
}}
|RCSMs={{#cargo_query:tables=Weapons,Ranks
|RCSMs={{#cargo_query:tables=Weapons,Ranks
Line 454: Line 480:
|limit=256
|limit=256
|default={{Cargo Rows/default}}
|default={{Cargo Rows/default}}
|order by=Weapons.rarity, Weapons.name LIKE '%☆%', Weapons.name LIKE '%/U*+', Weapons.name LIKE '%/U+', Weapons.name LIKE '%/U*', Weapons.name LIKE '%/U', Weapons.name
}}
}}
|#default=Invalid weapon type provided.
|#default=Invalid weapon type provided.
}}</includeonly><noinclude>{{{{FULLPAGENAME}}/doc}}[[Category: Templates using Cargo]]</noinclude>
}}</includeonly><noinclude>{{{{FULLPAGENAME}}/doc}}[[Category: Templates using Cargo]]</noinclude>

Latest revision as of 21:58, 21 April 2025

Shorthand to generate a weapon list per category.

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