User:Illuminatiswag/Sandbox: Difference between revisions

From Caves of Qud Wiki
Jump to navigation Jump to search
No edit summary
(hmmm)
Tag: Replaced
Line 1: Line 1:
{{User:Illuminatiswag/Template Sandbox|1=10|2=10|3=10}}
{{favilink|lush acid}}
CONCAT('{{Character/Attribute{{!}}1=Agility{{!}}2=AG{{!}}3=', Agility, '{{!}}5=', COALESCE(AgilityMult, 1), '}}')=Agility
== table ==
{{#cargo_query:
tables=Characters
|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")
|order by=XPValue DESC
|limit=50
}}

Revision as of 18:33, 22 March 2022