Difference between revisions of "User:Caledor92/Sandbox2"

From Dragalia Lost Wiki
Jump to navigation Jump to search
>Caledor92
(Undo revision 69911 by Caledor92 (talk))
>Caledor92
 
(42 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
{{#css:
+
<noinclude>{{doc}}</noinclude><includeonly><!--
−
@media screen and (min-width: 1600px) {
 
−
.VersionUpdate img {
 
−
width: 300px;
 
−
height: auto;
 
−
}
 
−
}
 
−
@media screen and (max-width: 1599px) {
 
−
.VersionUpdate img {
 
−
width: 100%;
 
−
height: auto;
 
−
}
 
−
}
 
  
−
.np-container-50 img {
+
### Vardefine and Calculations
−
height: auto;
 
−
}
 
  
−
.np-container-50 {
+
# Calculating Stat Values
−
width: 100%;
 
−
}
 
  
−
@media (min-width: 800px) {
+
-->{{#vardefine:hpMod|{{#expr:{{#var:hp{{#expr:{{{Hierarchy|}}}-1}}}} mod {{#var:totalHpNodes}} }} }}<!--
−
.np-container-50 {
+
-->{{#vardefine:strMod|{{#expr:{{#var:str{{#expr:{{{Hierarchy|}}}-1}}}} mod {{#var:totalStrNodes}} }} }}<!--
−
    flex-basis: 50%;
+
-->{{#vardefine:hpStrHpMod|{{#expr:{{#var:hp{{#expr:{{{Hierarchy|}}}-1}}}} mod {{#var:totalHpStrNodes}} }} }}<!--
−
    max-width: 50%;
+
-->{{#vardefine:hpStrStrMod|{{#expr:{{#var:str{{#expr:{{{Hierarchy|}}}-1}}}} mod {{#var:totalHpStrNodes}} }} }}<!--
−
}
 
  
−
}}<div style="display:flex;flex-flow:row wrap;justify-content:center">
+
# Assigning Node Color and Content
−
<div style="width:100%;margin:5px;text-align:center;border:1px solid #9aa99a;">
+
-->{{#switch:{{{ManaPieceType|}}}
−
<div style="margin:5px 5px 0;font-weight:bold;background-color:orange;">Summon Showcases</div>
+
|10101={{#vardefine:bgcolor|a7dca8}}{{#vardefine:bordercolor|439c43}}{{#vardefine:stat|HP}}<!--
−
<div style="padding:10px;text-align:center">
+
-->{{#vardefine:title|[[File:Mc StatusUp Hp.png|32px|link=]] HP}}<!--
−
{{#invoke:CargoQuery|main
+
-->{{#vardefine:hpNodeCounter| {{#expr:{{#var:hpNodeCounter}}-1 }} }}<!--
−
|q?tables=SummonShowcase
+
-->{{#ifexpr: {{#var:hpMod}} > {{#var:hpNodeCounter}} | {{#vardefine:titleAdd| +{{#expr: ceil({{#var:hp{{#expr:{{{Hierarchy|}}}-1}}}} / {{#var:totalHpNodes}}) }} }} }}<!--
−
|q?fields=Title,StartDate,EndDate
+
-->{{#ifexpr: {{#var:hpMod}} = {{#var:hpNodeCounter}} | {{#vardefine:titleAdd| +{{#expr: floor({{#var:hp{{#expr:{{{Hierarchy|}}}-1}}}} / {{#var:totalHpNodes}}) }} }} }}<!--
−
|q?orderBy=Type DESC, StartDate DESC, Title ASC
+
-->{{#ifexpr: {{#var:hpMod}} < {{#var:hpNodeCounter}} | {{#vardefine:titleAdd| +{{#expr: floor({{#var:hp{{#expr:{{{Hierarchy|}}}-1}}}} / {{#var:totalHpNodes}}) }} }} }}<!--
−
|q?groupBy=_pageName
+
 
−
|q?where=NOW() between StartDate and EndDate OR StartDate >= NOW()  
+
-->
−
|template=SummonShowcaseMP
+
|10102={{#vardefine:bgcolor|ffb6c1}}{{#vardefine:bordercolor|cd5c5c}}{{#vardefine:stat|Str}}<!--
−
|default=''No recent summon showcase.''
+
-->{{#vardefine:strNodeCounter| {{#expr:{{#var:strNodeCounter}}-1 }} }}<!--
−
|more results text=
+
-->{{#vardefine:title|[[File:Mc StatusUp Atk.png|32px|link=]] Strength}}<!--
−
}}
+
-->{{#ifexpr: {{#var:strMod}} > {{#var:strNodeCounter}} | {{#vardefine:titleAdd| +{{#expr: ceil({{#var:str{{#expr:{{{Hierarchy|}}}-1}}}} / {{#var:totalStrNodes}}) }} }} }}<!--
−
</div>
+
-->{{#ifexpr: {{#var:strMod}} = {{#var:strNodeCounter}} | {{#vardefine:titleAdd| +{{#expr: floor({{#var:str{{#expr:{{{Hierarchy|}}}-1}}}} / {{#var:totalStrNodes}}) }} }} }}<!--
−
</div>
+
-->{{#ifexpr: {{#var:strMod}} < {{#var:strNodeCounter}} | {{#vardefine:titleAdd| +{{#expr: floor({{#var:str{{#expr:{{{Hierarchy|}}}-1}}}} / {{#var:totalStrNodes}}) }} }} }}<!--
−
<div style="width:100%;margin:5px;text-align:center;border:1px solid #9aa99a;">
+
 
−
<div style="margin:5px 5px 0;font-weight:bold;background-color:#87cc93;">New Adventurers</div>
+
-->
−
{{#invoke:CargoQuery|main
+
|10103={{#vardefine:bgcolor|ffb6c1}}{{#vardefine:bordercolor|cd5c5c}}{{#vardefine:stat|Hp/Str}}<!--
−
|q?tables=Adventurers
+
-->{{#vardefine:hpStrNodeCounter| {{#expr:{{#var:hpStrNodeCounter}}-1 }} }}<!--
−
|q?fields=CONCAT('Adventurer')=Type,FullName=Name
+
-->{{#vardefine:titleAdd|}}<!--
−
|q?where=IsPlayable=1 AND Name not like "Laxi" AND (ReleaseDate>="{{#cargo_query:tables=SummonShowcase
+
-->{{#ifexpr: {{#var:hpStrHpMod}} > {{#var:hpStrNodeCounter}} | {{#vardefine:titleAdd1| +{{#expr: ceil({{#var:hp{{#expr:{{{Hierarchy|}}}-1}}}} / {{#var:totalHpStrNodes}}) }} }} }}<!--
−
|fields=StartDate
+
-->{{#ifexpr: {{#var:hpStrHpMod}} = {{#var:hpStrNodeCounter}} | {{#vardefine:titleAdd1| +{{#expr: floor({{#var:hp{{#expr:{{{Hierarchy|}}}-1}}}} / {{#var:totalHpStrNodes}}) }} }} }}<!--
−
|where=NOW() between StartDate and EndDate
+
-->{{#ifexpr: {{#var:hpStrHpMod}} < {{#var:hpStrNodeCounter}} | {{#vardefine:titleAdd1| +{{#expr: floor({{#var:hp{{#expr:{{{Hierarchy|}}}-1}}}} / {{#var:totalHpStrNodes}}) }} }} }}<!--
−
|group by=StartDate
+
-->{{#ifexpr: {{#var:hpStrStrMod}} > {{#var:hpStrNodeCounter}} | {{#vardefine:titleAdd2| +{{#expr: ceil({{#var:str{{#expr:{{{Hierarchy|}}}-1}}}} / {{#var:totalHpStrNodes}}) }} }} }}<!--
−
|order by=StartDate ASC,
+
-->{{#ifexpr: {{#var:hpStrStrMod}} = {{#var:hpStrNodeCounter}} | {{#vardefine:titleAdd2| +{{#expr: floor({{#var:str{{#expr:{{{Hierarchy|}}}-1}}}} / {{#var:totalHpStrNodes}}) }} }} }}<!--
−
|limit=
+
-->{{#ifexpr: {{#var:hpStrStrMod}} < {{#var:hpStrNodeCounter}} | {{#vardefine:titleAdd2| +{{#expr: floor({{#var:str{{#expr:{{{Hierarchy|}}}-1}}}} / {{#var:totalHpStrNodes}}) }} }} }}<!--
−
|more results text=
+
-->{{#vardefine:title|[[File:Mc StatusUp HpAtk.png|32px|link=]] HP {{#var:titleAdd1}} / Strength {{#var:titleAdd2}} }}<!--
−
|no html
+
 
−
}}" OR ReleaseDate>="{{#cargo_query:tables=Events
+
-->
−
|fields=StartDate
+
|10201={{#vardefine:bgcolor|cfb3ef}}{{#vardefine:bordercolor|774bb3}}<!--
−
|where=NOW() between StartDate and EndDate
+
-->{{#vardefine:title|[[File:Mc Burstattack Get.png|32px|link=]] Force Strike}}<!--
−
|group by=StartDate
+
-->{{#vardefine:10201Level| {{#expr:{{#var:10201Level}}+1}} }}<!--
−
|order by=StartDate ASC
+
-->{{#ifexpr: {{#var:{{{ManaPieceType|}}}Level}} > 1  | {{#vardefine:bgcolor|ffeac4}}{{#vardefine:bordercolor|ffb837}} {{#vardefine:title|[[File:Mc Burstattack Upgrade.png|32px|link=]] Force Strike}}}}<!--
−
|limit=
+
-->{{#vardefine:titleAdd|Lv. {{#var:{{{ManaPieceType|}}}Level}} }}<!--
−
|more results text=
+
 
−
|no html
+
-->
−
}}")
+
|10301={{#vardefine:bgcolor|cfb3ef}}{{#vardefine:bordercolor|774bb3}}<!--
−
|q?groupBy=_pageName
+
-->{{#vardefine:10301Level| {{#expr:({{#var:10301Level}} + {{{Hierarchy|}}} - ( {{{Hierarchy|}}} mod 2) ) div 2 }} }}<!--
−
|q?orderBy= ReleaseDate DESC, Rarity DESC, ElementalTypeId ASC, WeaponTypeId ASC, Id DESC, FullName ASC
+
-->{{#vardefine:title|[[File:{{#var:ability1{{#var:{{{ManaPieceType|}}}Level}}Icon }}.png|32px|link=]] {{#var:ability1{{#var:{{{ManaPieceType|}}}Level}}Name }} }}{{#vardefine:titleAdd|Lv. {{#expr:{{#var:{{{ManaPieceType|}}}Level}}+1}}}}<!--
−
|template=TooltipIcon
+
-->{{#ifexpr: {{#var:{{{ManaPieceType|}}}Level}} > 1  | {{#vardefine:bgcolor|ffeac4}}{{#vardefine:bordercolor|ffb837}} }}<!--
−
|more results text=
+
 
−
|default=''No recent adventurers.''
+
-->
−
}}
+
|10302={{#vardefine:bgcolor|cfb3ef}}{{#vardefine:bordercolor|774bb3}}<!--
−
</div>
+
-->{{#vardefine:10302Level| {{#expr:{{#var:10302Level}}+1}} }}<!--
 +
-->{{#vardefine:title|[[File:{{#var:ability2{{#var:{{{ManaPieceType|}}}Level}}Icon }}.png|32px|link=]] {{#var:ability2{{#var:{{{ManaPieceType|}}}Level}}Name }} Lv. {{#expr:{{#var:{{{ManaPieceType|}}}Level}}+1}} }}{{#vardefine:titleAdd|}}<!--
 +
-->{{#ifexpr: {{#var:{{{ManaPieceType|}}}Level}} > 1  | {{#vardefine:bgcolor|ffeac4}}{{#vardefine:bordercolor|ffb837}} }}<!--
 +
 
 +
-->
 +
|10303={{#vardefine:bgcolor|cfb3ef}}{{#vardefine:bordercolor|774bb3}}<!--
 +
-->{{#vardefine:10303Level| {{#expr:{{#var:10303Level}}+1}} }}<!--
 +
-->{{#vardefine:title|[[File:{{#var:ability3{{#var:{{{ManaPieceType|}}}Level}}Icon}}.png|32px|link=]] {{#var:ability3{{#var:{{{ManaPieceType|}}}Level}}Name}} }}{{#vardefine:titleAdd|}}<!--
 +
-->{{#ifexpr: {{#var:{{{ManaPieceType|}}}Level}} > 1 | {{#vardefine:bgcolor|ffeac4}}{{#vardefine:bordercolor|ffb837}} }}<!--
 +
 
 +
-->
 +
|10401={{#vardefine:bgcolor|ffeac4}}{{#vardefine:bordercolor|ffb837}}<!--
 +
-->{{#vardefine:title|[[File:{{#var:skill1{{#expr:{{#var:10401Level}}+2}}Icon}}.png|32px|link=]] [[{{#var:skill1}}]]}}<!--
 +
-->{{#vardefine:10401Level| {{#expr:{{#var:10401Level}}+1}} }}<!--
 +
-->{{#vardefine:titleAdd|Lv. {{#expr:{{#var:{{{ManaPieceType|}}}Level}}+1}} }}<!--
 +
 
 +
-->
 +
|10402={{#vardefine:bgcolor|cfb3ef}}{{#vardefine:bordercolor|774bb3}}<!--
 +
-->{{#vardefine:title|[[File:{{#var:skill2{{#expr:{{#var:10402Level}}+1}}Icon}}.png|32px|link=]] [[{{#var:skill2}}]]}}<!--
 +
-->{{#vardefine:10402Level| {{#expr:{{#var:10402Level}}+1}} }}<!--
 +
-->{{#vardefine:titleAdd|Lv. {{#var:{{{ManaPieceType|}}}Level}} }}<!--
 +
-->{{#ifexpr: {{#var:{{{ManaPieceType|}}}Level}} > 1  | {{#vardefine:bgcolor|ffeac4}}{{#vardefine:bordercolor|ffb837}} }}<!--
 +
 
 +
-->
 +
|10501={{#vardefine:bgcolor|ffeac4}}{{#vardefine:bordercolor|ffb837}}<!--
 +
-->{{#vardefine:10501Level| {{#expr:{{#var:10501Level}}+1}} }}<!--
 +
-->{{#vardefine:title|[[File:{{#var:coAbilityIcon}}.png|32px|link=]] {{#var:coAbility{{#expr:{{#var:10501Level}}+1}}Name}}}}{{#vardefine:titleAdd|}}<!--
 +
 
 +
-->
 +
|10601={{#vardefine:bgcolor|cfb3ef}}{{#vardefine:bordercolor|774bb3}}<!--
 +
-->{{#vardefine:title|[[File:Mc Material Get.png|32px|link=]] [[Damascus Crystal]]}}{{#vardefine:titleAdd|}}<!--
 +
-->{{#vardefine:10601Level| {{#expr:{{#var:10601Level}}+1}} }}<!--
 +
 
 +
-->
 +
|10701={{#vardefine:bgcolor|cfb3ef}}{{#vardefine:bordercolor|774bb3}}<!--
 +
-->{{#vardefine:title|[[File:Mc Advanced Training.png|32px|link=]] Standard Atk Level Increase}}{{#vardefine:titleAdd|}}<!--
 +
-->{{#vardefine:10701Level| {{#expr:{{#var:10701Level}}+1}} }}<!--
 +
 
 +
-->
 +
|10801={{#vardefine:bgcolor|cfb3ef}}{{#vardefine:bordercolor|774bb3}}<!--
 +
-->{{#vardefine:title|[[File:Mc Unbind Level.png|32px|link=]] Max Level Increase +5}}{{#vardefine:titleAdd|}}<!--
 +
-->{{#vardefine:10801Level| {{#expr:{{#var:10801Level}}+1}} }}
 +
}}<!--
 +
 
 +
# Check if Adventurer Story
  
−
<div style="width:100%;margin:5px;text-align:center;border:1px solid #9aa99a;">
+
-->{{#ifeq:{{{IsReleaseStory|}}} | 1 | {{#vardefine:title|[[File:Mc CharaStory.png|32px|link=]] New Adventurer Story}}{{#vardefine:bgcolor|b3deff}}{{#vardefine:bordercolor|00bfff}} | }}<!--
−
<div style="margin:5px 5px 0;font-weight:bold;background-color:#9a69c7;">New Dragons</div>
 
−
{{#invoke:CargoQuery|main|
 
−
|q?tables=Dragons
 
−
|q?fields=CONCAT('Dragon')=Type,FullName=Name
 
−
|q?where=IsPlayable=1 AND (ReleaseDate>="{{#cargo_query:tables=SummonShowcase
 
−
|fields=StartDate
 
−
|where=NOW() between StartDate and EndDate
 
−
|group by=StartDate
 
−
|order by=StartDate ASC
 
−
|limit=
 
−
|more results text=
 
−
|no html
 
−
}}" OR ReleaseDate>="{{#cargo_query:tables=Events
 
−
|fields=StartDate
 
−
|where=NOW() between StartDate and EndDate
 
−
|group by=StartDate
 
−
|order by=StartDate ASC
 
−
|limit=
 
−
|more results text=
 
−
|no html
 
−
}}")
 
−
|q?groupBy=_pageName
 
−
|q?orderBy= ReleaseDate DESC, Rarity DESC, ElementalTypeId ASC, Id DESC, FullName ASC
 
−
|template=TooltipIcon
 
−
|more results text=
 
−
|default=''No recent dragons.''
 
−
}}
 
−
</div>
 
  
−
<div style="width:100%;margin:5px;text-align:center;border:1px solid #9aa99a;">
+
### Template Display ###
−
<div style="margin:5px 5px 0;font-weight:bold;background-color:#699dc7;">New Wyrmprints</div>
 
−
{{#invoke:CargoQuery|main
 
−
|q?tables=Wyrmprints
 
−
|q?fields=CONCAT('Wyrmprint')=Type,Name=Name
 
−
|q?where=IsPlayable=1 AND (ReleaseDate>="{{#cargo_query:tables=SummonShowcase
 
−
|fields=StartDate
 
−
|where=NOW() between StartDate and EndDate
 
−
|group by=StartDate
 
−
|order by=StartDate ASC
 
−
|limit=
 
−
|more results text=
 
−
|no html
 
−
}}" OR ReleaseDate>="{{#cargo_query:tables=Events
 
−
|fields=StartDate
 
−
|where=NOW() between StartDate and EndDate
 
−
|group by=StartDate
 
−
|order by=StartDate ASC
 
−
|limit=1
 
−
|more results text=
 
−
|no html
 
−
}}")
 
−
|q?groupBy=_pageName
 
−
|q?orderBy=ReleaseDate DESC, Rarity DESC, BaseId DESC, Name ASC
 
−
|template=TooltipIcon
 
−
|more results text=
 
−
|default=''No recent wyrmprints.''
 
−
}}
 
−
</div>
 
  
−
<div class="np-container-50">
+
--><div>
−
<div style="margin:5px;text-align:center;border:1px solid #9aa99a;height: 95%">
+
{| class="mana-circle-table" style="border:1px solid #{{#var:bordercolor}}"
−
<div style="margin:5px 5px 0;font-weight:bold;background-color:#e89090;">Latest Patch</div>
+
! style="background-color:#{{#var:bgcolor}}" | {{#var:title}} {{#ifeq:{{{IsReleaseStory|}}} | 1 | | {{#var:titleAdd}} }}<!--
−
<div class="VersionUpdate" style="padding:10px;display:inline-block;">[[File:Banner_Version_Update.png|300px|link=Version_Changelog]]</div>
+
### To-Do: {{#if:{{{might|}}}|<br/><div style="font-size:.8em;">{{Tooltip|+{{{might|}}} Might|+Amount of Might Gained (Total Might Value of Skill)}}</div>}}
−
'''Version:''' [[Version_Changelog|{{#cargo_query:tables=VersionChangelogs
+
-->
−
|fields=Version,
+
|-
−
|order by=ReleaseDate DESC
+
| style="text-align:center; position: relative;" | <div><u>'''Cost'''</u><span style="font-weight:normal;"><!--
−
|where=ReleaseDate <= NOW()
 
−
|format=list
 
−
|limit = 1
 
−
|more results text=
 
−
}} - {{#cargo_query:tables=VersionChangelogs
 
−
|fields=Name
 
−
|order by=ReleaseDate DESC
 
−
|format=list
 
−
|where=ReleaseDate <= NOW()
 
−
|limit = 1
 
−
|more results text=
 
−
}}]]<br /> '''Release Date:''' {{#cargo_query:tables=VersionChangelogs
 
−
|fields=ReleaseDate,
 
−
|order by=ReleaseDate DESC
 
−
|where=ReleaseDate <= NOW()
 
−
|format=list
 
−
|limit = 1
 
−
|more results text=
 
−
}}
 
−
</div>
 
−
</div>
 
  
−
<div class="np-container-50">
+
-->{{#ifeq:{{{NecessaryManaPoint|0}}} | 0 | | <br/>{{Icon|Resource|Mana|size=16px|text=1}} x{{{NecessaryManaPoint|0}}} }}<!--
−
<div style="margin:5px;text-align:center;border:1px solid #9aa99a;height: 95%">
+
-->{{#switch:{{{ManaPieceType|}}}
−
<div style="margin:5px 5px 0;font-weight:bold;background-color:#ffd800;">Latest Dragalia Life</div>
+
|10101
−
{{#invoke:CargoQuery|main
+
|10102
−
|q?tables=Comics
+
|10103=
−
|q?fields=Id,Title,ReleaseDate,DirectLink
+
|#default={{#invoke:CargoQuery|main
−
|q?orderBy=ReleaseDate DESC
+
|q?tables=ManaPieceElement
−
|q?limit=1
+
|q?fields=NeedDewPoint{{#var:{{{ManaPieceType|}}}Level}}=eldwater,ManaMaterialId{{#var:{{{ManaPieceType|}}}Level}}1=mat1,ManaMaterialId{{#var:{{{ManaPieceType|}}}Level}}2=mat2,ManaMaterialId{{#var:{{{ManaPieceType|}}}Level}}3=mat3,ManaMaterialQuantity{{#var:{{{ManaPieceType|}}}Level}}1=matQuantity1,ManaMaterialQuantity{{#var:{{{ManaPieceType|}}}Level}}2=matQuantity2,ManaMaterialQuantity{{#var:{{{ManaPieceType|}}}Level}}3=matQuantity3
−
|q?groupBy=
+
|q?where=ElementId="{{#var:shortManaCircleName}}" AND ManaPieceType="{{{ManaPieceType|}}}"
−
|q?where=_pageName='Dragalia Life'
+
|template=MCNodeMaterialDisplay
−
|template=DragaliaLifeIssueMP
 
−
|default=
 
−
|more results text=
 
 
}}
 
}}
−
</div>
+
}}</span></div>
−
</div>
+
{{#ifeq:{{{IsReleaseStory|}}} | 1 | <div style="font-weight:normal">'''{{#var:stat}} {{#var:titleAdd}}''' upon node unlock</div> }}
−
</div>
+
|}</div>

Latest revision as of 21:19, 8 July 2020

Retrieved from "https://dlwiki.cherrymint.live/index.php?title=User:Caledor92/Sandbox2&oldid=397659"