Template:Weapon List: Difference between revisions
(sort) |
(unblacklist God Hands/U+ (01023803)) |
||
| (3 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 | |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 | |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 41: | 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 | |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 59: | 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 | |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 73: | 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 | |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 89: | 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 | |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 118: | 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 | |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 135: | 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 | |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 151: | 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 | |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 176: | 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 | |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 193: | 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 | |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 207: | 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 | |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 225: | 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 | |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 244: | 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 | |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 260: | 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 | |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 273: | 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 | |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 288: | 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 | |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 304: | 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 | |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 318: | 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 | |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 334: | 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 | |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 349: | 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 | |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 365: | 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 | |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 378: | 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 | |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 394: | 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 | |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 407: | 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 | |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 428: | 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 | |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 445: | 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 | |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 480: | 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 | |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.