Difference between revisions of "ArmorsLists"
From P6 Spheres
(Created page with "<noinclude>Creates an armor table, containing the armors pulled with the provided where string '''Required Fields:''' where (sql where string) </noinclude><includeonly>{{#car...") |
|||
| (3 intermediate revisions by the same user not shown) | |||
| Line 5: | Line 5: | ||
|join on=Base_Items._pageName = Items_Armors._pageName | |join on=Base_Items._pageName = Items_Armors._pageName | ||
|where={{{where}}} | |where={{{where}}} | ||
| − | |order by= | + | |order by=ACBonus, MaxDex DESC, ACP DESC |
| − | |fields=CONCAT( '[[', Base_Items._pageName, '|', SortName, ']]' ) = Name,PrettyPrice = Cost, | + | |fields=CONCAT( '[[', Base_Items._pageName, '|', SortName, ']]' ) = Name,PrettyPrice = Cost,PrettyAC = AC<br>Bonus,PrettyMaxDex = Maximum<br>Dex<br>Bonus,PrettyACP= Armor<br>Check<br>Penalty,ASF = Arcane<br>Spell<br>Failure,Speed,PrettyWeight = Weight |
|format=table | |format=table | ||
}}</includeonly> | }}</includeonly> | ||
Latest revision as of 22:42, 21 March 2020
Creates an armor table, containing the armors pulled with the provided where string
Required Fields: where (sql where string)