532
edits
User:Illuminatiswag/Sandbox: Difference between revisions
User:Illuminatiswag/Sandbox (view source)
Revision as of 20:00, 11 January 2022
, 20:00, 11 January 2022no edit summary
(stat table) |
No edit summary |
||
| Line 1: | Line 1: | ||
{{User:Illuminatiswag/Template Sandbox|1=10|2=10|3=10}} | |||
CONCAT('{{Character/Attribute{{!}}1=Agility{{!}}2=AG{{!}}3=', Agility, '{{!}}5=', COALESCE(AgilityMult, 1), '}}')=Agility | |||
== table == | |||
{{#cargo_query: | {{#cargo_query: | ||
tables=Characters | tables=Characters | ||
|fields=CONCAT('{{favilink id{{!}}', ObjectID, '}}')=Creature, XPValue=XP_Value,XPTier=XP_(Level)_Tier,CONCAT('{{ | |fields=CONCAT('{{favilink id{{!}}', ObjectID, '}}')=Creature, XPValue=XP_Value,XPTier=XP_(Level)_Tier,CONCAT('{{User:Illuminatiswag/Template Sandbox{{!}}1=', Strength, '{{!}}2=', COALESCE(StrengthMult, 1), '{{!}}3=0}}')=Strength, CONCAT('{{User:Illuminatiswag/Template Sandbox{{!}}1=', Agility, '{{!}}2=', COALESCE(AgilityMult, 1), '{{!}}3=0}}')=Agility, CONCAT('{{User:Illuminatiswag/Template Sandbox{{!}}1=', Toughness, '{{!}}2=', COALESCE(ToughnessMult, 1), '{{!}}3=0}}')=Toughness, CONCAT('{{User:Illuminatiswag/Template Sandbox{{!}}1=', Intelligence, '{{!}}2=', COALESCE(IntelligenceMult, 1), '{{!}}3=0}}')=Intelligence, CONCAT('{{User:Illuminatiswag/Template Sandbox{{!}}1=', Willpower, '{{!}}2=', COALESCE(WillpowerMult, 1), '{{!}}3=0}}')=Willpower, CONCAT('{{User:Illuminatiswag/Template Sandbox{{!}}1=', Ego, '{{!}}2=', COALESCE(EgoMult, 1), '{{!}}3=0}}')=Ego | ||
|where=XPValue IS NOT NULL and XPVALUE > 500 AND (_pageNamespace = "0" OR _pageNamespace= "10002") | |where=XPValue IS NOT NULL and XPVALUE > 500 AND (_pageNamespace = "0" OR _pageNamespace= "10002") | ||
|order by=XPValue DESC | |order by=XPValue DESC | ||
|limit= | |limit=50 | ||
}} | }} | ||