Difference between revisions of "User:Eave/Sandbox"

From Dragalia Lost Wiki
Jump to navigation Jump to search
>Eave
>Eave
m
 
(41 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 Parts ==
+
== Icons ==
−
{{#vardefine:PartsAList|{{#cargo_query:tables=EnemiesTest
+
{{#vardefine:1|Icon Element Wind.png}}
−
  |fields=PartsA
+
{{#vardefine:2|Icon Element Flame.png}}
−
  |where=Name="Sabnock"
+
{{#vardefine:size|19}}
−
  |group by=PartsA
+
{{#vardefine:halfSize|{{#expr:{{#var:size}} / 2}}}}
−
  |default=|no html}}}}
+
<span style="display:inline-flex">
−
{{#vardefine:PartsBList|{{#cargo_query:tables=EnemiesTest
+
<span style="overflow:hidden;margin-right:-{{#var:halfSize}}px">[[File:{{#var:1}}|{{#var:size}}px|middle|link=]]</span>
−
  |fields=PartsB
+
<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>
−
  |where=Name="Sabnock"
+
</span> Volk
−
  |group by=PartsB
+
 
−
  |default=|no html}}}}
+
== Bad Mobile Thumbnails ==
−
{{#vardefine:PartsCList|{{#cargo_query:tables=EnemiesTest
+
[[File:110009 01 r05 portrait.png|150px]]
−
  |fields=PartsC
+
[[File:110274 01 r05 portrait.png|150px]]
−
  |where=Name="Sabnock"
+
[[File:110260_01_r05_portrait.png|150px]]
−
  |group by=PartsC
+
 
−
  |default=|no html}}}}
+
 
−
{{#vardefine:PartsDList|{{#cargo_query:tables=EnemiesTest
+
== Weird Cargo Query issue ==
−
  |fields=PartsD
+
Happens when the WHERE clause mentions a List column name, but as the comparison value for a different field
−
  |where=Name="Sabnock"
+
 
−
  |group by=PartsD
+
Working:
−
  |default=|no html}}}}
+
{{#cargo_query:tables=SummonShowcase
−
{{#cargo_query:tables=EnemiesTest
+
|where=Title="5★ A\dventurer Platinum Showcase (Dec 2019)"
−
  |fields=Name
+
|fields=Image,BannerTopImage,Title,Type,MaxSummons,StartDate,EndDate,Adventurer,Dragons,Wyrmprints,Video
−
  |where=MonsterId IN ({{#var:PartsAList}},{{#var:PartsBList}},{{#var:PartsCList}},{{#var:PartsDList}})
+
|orderBy=StartDate DESC
−
  |group by=Name
+
|default=''There are currently no ongoing summon showcases.''
−
  |default=|no html}}
+
}}
 +
 
 +
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

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