532
edits
User:Illuminatiswag/Sandbox: Difference between revisions
User:Illuminatiswag/Sandbox (view source)
Revision as of 07:51, 9 January 2022
, 07:51, 9 January 2022stat table
No edit summary |
(stat table) |
||
| Line 1: | Line 1: | ||
{{#cargo_query: | |||
tables=Characters | |||
! | |fields=CONCAT('{{favilink id{{!}}', ObjectID, '}}')=Creature, XPValue=XP_Value,XPTier=XP_(Level)_Tier,CONCAT('{{Character/Attribute{{!}}1=Strength{{!}}2=ST{{!}}3=', Strength, '{{!}}5=', IF(StrengthMult IS NULL, 1, StrengthMult), '}}')=Strength, CONCAT('{{Character/Attribute{{!}}1=Agility{{!}}2=AG{{!}}3=', Agility, '{{!}}5=', IF(AgilityMult IS NULL, 1, AgilityMult), '}}')=Agility,CONCAT('{{Character/Attribute{{!}}1=Toughness{{!}}2=TO{{!}}3=', Toughness, '{{!}}5=', IF(ToughnessMult IS NULL, 1, ToughnessMult), '}}')=Toughness | ||
|where=XPValue IS NOT NULL and XPVALUE > 500 AND (_pageNamespace = "0" OR _pageNamespace= "10002") | |||
!1 | |order by=XPValue DESC | ||
!2 | |limit=999 | ||
!3 | }} | ||
! | |||
! | |||
| | |||
| | |||
| | |||