Difference between revisions of "User:Eave/Sandbox"

From Dragalia Lost Wiki
Jump to navigation Jump to search
>Eave
>Eave
m
 
(19 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
== Filter Icons ==
 +
{{CharacterListFilter}}
 +
<div style="text-align:center">
 +
{{#widget:TestWidget}}
 +
</div>
 +
 
== Boolean {{#if}} proof of concept using IsAffectedByTension ==
 
== Boolean {{#if}} proof of concept using IsAffectedByTension ==
  
Line 14: Line 20:
  
  
−
== Enemy Names ==
+
== Icons ==
−
{{#cargo_query:tables=EnemiesTest,EnemyPageLinks
+
{{#vardefine:1|Icon Element Wind.png}}
−
|join on=EnemiesTest.Name=EnemyPageLinks.Name
+
{{#vardefine:2|Icon Element Flame.png}}
−
|where=MissionType="Ciella's Wrath: Expert"
+
{{#vardefine:size|19}}
−
|fields=CONCAT('[[', EnemyPageLinks._pageName, '|', EnemiesTest.Name, ']]')=Name, CONCAT('{{InlineIcon|Icon Element|', EnemiesTest.ElementalType,'}}')=Element, EnemiesTest.Tribe=Class, EnemiesTest.HP, EnemiesTest.Atk=Str, EnemiesTest.Def
+
{{#vardefine:halfSize|{{#expr:{{#var:size}} / 2}}}}
−
|group by=EnemiesTest.MonsterId
+
<span style="display:inline-flex">
−
|order by=EnemiesTest.HP DESC,EnemiesTest.Name
+
<span style="overflow:hidden;margin-right:-{{#var:halfSize}}px">[[File:{{#var:1}}|{{#var:size}}px|middle|link=]]</span>
−
}}
+
<span style="overflow:hidden;margin-right:-{{#var:halfSize}}px"><span style="position:relative;left:-{{#var:halfSize}}px">[[File:{{#var:2}}|{{#var:size}}px|middle|link=]]</span></span>
−
{{#cargo_query:tables=EnemiesTest,EnemyPageLinks
+
</span> Volk
−
|join on=EnemiesTest.Name=EnemyPageLinks.Name
 
−
|where=MissionType="Ciella's Wrath: Expert"
 
−
|fields=IF(EnemyPageLinks._pageName, CONCAT('[[', EnemyPageLinks._pageName, '|', EnemiesTest.Name, ']]'), EnemiesTest.Name)=Name, CONCAT('{{InlineIcon|Icon Element|', EnemiesTest.ElementalType, '}}')=Element, EnemiesTest.Tribe=Class, EnemiesTest.HP, EnemiesTest.Atk=Str, EnemiesTest.Def
 
−
|group by=EnemiesTest.MonsterId
 
−
|order by=EnemiesTest.HP DESC,EnemiesTest.Name
 
−
}}
 
  
 
== Bad Mobile Thumbnails ==
 
== Bad Mobile Thumbnails ==
Line 34: Line 34:
 
[[File:110274 01 r05 portrait.png|150px]]
 
[[File:110274 01 r05 portrait.png|150px]]
 
[[File:110260_01_r05_portrait.png|150px]]
 
[[File:110260_01_r05_portrait.png|150px]]
 +
 +
 +
== Weird Cargo Query issue ==
 +
Happens when the WHERE clause mentions a List column name, but as the comparison value for a different field
 +
 +
Working:
 +
{{#cargo_query:tables=SummonShowcase
 +
|where=Title="5★ A\dventurer Platinum Showcase (Dec 2019)"
 +
|fields=Image,BannerTopImage,Title,Type,MaxSummons,StartDate,EndDate,Adventurer,Dragons,Wyrmprints,Video
 +
|orderBy=StartDate DESC
 +
|default=''There are currently no ongoing summon showcases.''
 +
}}
 +
 +
Not working:
 +
{{#cargo_query:tables=SummonShowcase
 +
|where=Title="5★ Adventurer Platinum Showcase (Dec 2019)"
 +
|fields=Image,BannerTopImage,Title,Type,MaxSummons,StartDate,EndDate,Adventurer,Dragons,Wyrmprints,Video
 +
|orderBy=StartDate DESC
 +
|default=''There are currently no ongoing summon showcases.''
 +
}}

Latest revision as of 06:40, 24 July 2020

Filter Icons

Affliction Resistance

">
">
">
">
">
">
">