Difference between revisions of "ArmorsLists"
From P6 Spheres
| 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=ACBonus, MaxDex, ACP | + | |order by=ACBonus, MaxDex DESC, ACP DESC |
|fields=CONCAT( '[[', Base_Items._pageName, '|', SortName, ']]' ) = Name,PrettyPrice = Cost,CONCAT('+',ACBonus) = AC<br>Bonus,CONCAT('+',MaxDex) = Maximum<br>Dex<br>Bonus,ACP= Armor<br>Check<br>Penalty,ASF = Arcane<br>Spell<br>Failure,Speed,PrettyWeight = Weight | |fields=CONCAT( '[[', Base_Items._pageName, '|', SortName, ']]' ) = Name,PrettyPrice = Cost,CONCAT('+',ACBonus) = AC<br>Bonus,CONCAT('+',MaxDex) = Maximum<br>Dex<br>Bonus,ACP= Armor<br>Check<br>Penalty,ASF = Arcane<br>Spell<br>Failure,Speed,PrettyWeight = Weight | ||
|format=table | |format=table | ||
}}</includeonly> | }}</includeonly> | ||
Revision as of 22:11, 21 March 2020
Creates an armor table, containing the armors pulled with the provided where string
Required Fields: where (sql where string)