Difference between revisions of "User:Caledor92/Sandbox2"

From Dragalia Lost Wiki
Jump to navigation Jump to search
>Caledor92
(Undo revision 60954 by Caledor92 (talk))
>Caledor92
 
(370 intermediate revisions by 2 users not shown)
Line 1: Line 1:
<noinclude>{{doc}}[[Category:Templates]]<!--
+
<noinclude>{{doc}}</noinclude><includeonly><!--
  
// Cargo Declare
+
### Vardefine and Calculations
-->{{#cargo_declare:
 
_table=Abilities
 
|Id=Integer
 
|GenericName=String
 
|Subcategory=String
 
|Name=String
 
|Details=Wikitext (size=3000)
 
|AbilityIconName=String
 
|AbilityGroup=Integer
 
|PartyPowerWeight=Integer
 
|AbilityLimitedGroupId1=Integer
 
|AbilityLimitedGroupId2=Integer
 
|AbilityLimitedGroupId3=Integer
 
}}</noinclude><includeonly><!--
 
  
// Storing values to Cargo Table
+
# Calculating Stat Values
-->{{#ifeq: {{NAMESPACENUMBER}} | 0 | {{#cargo_store:
 
  _table=Abilities
 
|Id={{{Id|}}}
 
|GenericName={{{GenericName|}}}
 
|Subcategory={{{Subcategory|}}}
 
|Name={{{Name|}}}
 
|Details={{{Details|}}}
 
|AbilityIconName={{#replace:{{{AbilityIconName|}}}| |_}}
 
|AbilityGroup={{{AbilityGroup|}}}
 
|PartyPowerWeight={{{PartyPowerWeight|}}}
 
|AbilityLimitedGroupId1={{{AbilityLimitedGroupId1|}}}
 
|AbilityLimitedGroupId2={{{AbilityLimitedGroupId2|0}}}
 
|AbilityLimitedGroupId3={{{AbilityLimitedGroupId3|0}}}
 
}}
 
| }}<!--
 
  
// Template Display Content
+
-->{{#vardefine:hpMod|{{#expr:{{#var:hp{{#expr:{{{Hierarchy|}}}-1}}}} mod {{#var:totalHpNodes}} }} }}<!--
--><div class="panel" style="margin:auto;max-width:800px">
+
-->{{#vardefine:strMod|{{#expr:{{#var:str{{#expr:{{{Hierarchy|}}}-1}}}} mod {{#var:totalStrNodes}} }} }}<!--
<div class="panel-heading">{{{Name|{{PAGENAME}}}}}</div>
+
-->{{#vardefine:hpStrHpMod|{{#expr:{{#var:hp{{#expr:{{{Hierarchy|}}}-1}}}} mod {{#var:totalHpStrNodes}} }} }}<!--
<div class="panel-body" style="display:flex;flex-direction:row;flex-wrap:wrap;justify-content:center">
+
-->{{#vardefine:hpStrStrMod|{{#expr:{{#var:str{{#expr:{{{Hierarchy|}}}-1}}}} mod {{#var:totalHpStrNodes}} }} }}<!--
<div style="width:350px;text-align:center">{{#ifexist: File:{{{AbilityIconName|}}}.png | [[File:{{{AbilityIconName|}}}.png|60px]] | [[File:Unknown.png|160px|link=File:{{{AbilityIconName|}}}.png]] }}</div>
 
<div class="skill-levels skill-details" style="flex-grow:1;text-align:center">
 
<p style="width:300px;margin:15px auto;border-bottom:1px solid;margin-bottom:15px;font-size:1.2em;font-variant-caps: small-caps;font-weight:bold">Description</p>
 
<div style="flex-grow:1;text-align:center">
 
<div style="width:300px;margin:5px auto 10px;font-style:italic;font-size:.9em;">{{{Details|No details yet.}}}</div>
 
</div>
 
  
{{TermDescription|Might Value|{{{PartyPowerWeight|}}} }}
+
# Assigning Node Color and Content
{{TermDescription|Category|[[{{{GenericName|}}}]] }}
+
-->{{#switch:{{{ManaPieceType|}}}
{{TermDescription|Subcategory|[[{{{Subcategory|}}}]] }}
+
|10101={{#vardefine:bgcolor|a7dca8}}{{#vardefine:bordercolor|439c43}}{{#vardefine:stat|HP}}<!--
{{TermDescription|Wyrmprint Ability Cap|{{#cargo_query:tables=AbilityLimitedGroup|fields=AbilityLimitedText|where=Id="{{{AbilityLimitedGroupId1|}}}"|default=N/A}}}}
+
-->{{#vardefine:title|[[File:Mc StatusUp Hp.png|32px|link=]] HP}}<!--
</div>
+
-->{{#vardefine:hpNodeCounter| {{#expr:{{#var:hpNodeCounter}}-1 }} }}<!--
</div>
+
-->{{#ifexpr: {{#var:hpMod}} > {{#var:hpNodeCounter}} | {{#vardefine:titleAdd| +{{#expr: ceil({{#var:hp{{#expr:{{{Hierarchy|}}}-1}}}} / {{#var:totalHpNodes}}) }} }} }}<!--
<div style="padding:1em;">
+
-->{{#ifexpr: {{#var:hpMod}} = {{#var:hpNodeCounter}} | {{#vardefine:titleAdd| +{{#expr: floor({{#var:hp{{#expr:{{{Hierarchy|}}}-1}}}} / {{#var:totalHpNodes}}) }} }} }}<!--
<p style="margin:15px auto;border-bottom:1px solid;margin-bottom:15px;font-size:1.2em;font-variant-caps: small-caps;font-weight:bold">Adventurers With This Ability</p>
+
-->{{#ifexpr: {{#var:hpMod}} < {{#var:hpNodeCounter}} | {{#vardefine:titleAdd| +{{#expr: floor({{#var:hp{{#expr:{{{Hierarchy|}}}-1}}}} / {{#var:totalHpNodes}}) }} }} }}<!--
{{#cargo_query:tables=Adventurers|fields=CONCAT('[[File:',Id,' 0',VariationId,' r0',Rarity,'.png|24px|link=',_pageName,']] [[',_pageName,']]')|where=Abilities11= "{{{Id|}}}" OR Abilities12= "{{{Id|}}}" OR Abilities13= "{{{Id|}}}" OR Abilities14= "{{{Id|}}}" OR Abilities21= "{{{Id|}}}" OR Abilities22= "{{{Id|}}}" OR Abilities23= "{{{Id|}}}" OR Abilities24= "{{{Id|}}}" OR Abilities31= "{{{Id|}}}" OR Abilities32= "{{{Id|}}}" OR Abilities33= "{{{Id|}}}" OR Abilities34= "{{{Id|}}}"|format=ul|group by=_pageName|default=
 
:''There are no adventurers with this ability.''|order by= ElementalTypeId ASC, WeaponTypeId ASC, Rarity DESC, Id DESC, FullName ASC}}
 
  
<p style="margin:15px auto;border-bottom:1px solid;margin-bottom:15px;font-size:1.2em;font-variant-caps: small-caps;font-weight:bold">Wyrmprints With This Ability</p>
+
-->
{{#cargo_query:tables=Wyrmprints|fields=CONCAT('[[File:',BaseId,' 0',VariationId,'.png|24px|link=',_pageName,']] [[',_pageName,']]')|where=Abilities11= "{{{Id|}}}" OR Abilities12= "{{{Id|}}}" OR Abilities13= "{{{Id|}}}" OR Abilities21= "{{{Id|}}}" OR Abilities22= "{{{Id|}}}" OR Abilities23= "{{{Id|}}}" OR Abilities31= "{{{Id|}}}" OR Abilities32= "{{{Id|}}}" OR Abilities33= "{{{Id|}}}"|format=ul|group by=_pageName|default=
+
|10102={{#vardefine:bgcolor|ffb6c1}}{{#vardefine:bordercolor|cd5c5c}}{{#vardefine:stat|Str}}<!--
:''There are no wyrmprints with this ability.''|order by= Rarity DESC, ReleaseDate DESC, BaseId DESC}}
+
-->{{#vardefine:strNodeCounter| {{#expr:{{#var:strNodeCounter}}-1 }} }}<!--
 +
-->{{#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}}) }} }} }}<!--
 +
-->{{#ifexpr: {{#var:strMod}} = {{#var:strNodeCounter}} | {{#vardefine:titleAdd| +{{#expr: floor({{#var:str{{#expr:{{{Hierarchy|}}}-1}}}} / {{#var:totalStrNodes}}) }} }} }}<!--
 +
-->{{#ifexpr: {{#var:strMod}} < {{#var:strNodeCounter}} | {{#vardefine:titleAdd| +{{#expr: floor({{#var:str{{#expr:{{{Hierarchy|}}}-1}}}} / {{#var:totalStrNodes}}) }} }} }}<!--
  
<p style="margin:15px auto;border-bottom:1px solid;margin-bottom:15px;font-size:1.2em;font-variant-caps: small-caps;font-weight:bold">Dragons With This Ability</p>
+
-->
{{#cargo_query:tables=Dragons|fields=CONCAT('[[File:',BaseId,' 0',VariationId,'.png|24px|link=',_pageName,']] [[',_pageName,']]')|where=Abilities11= "{{{Id|}}}" OR Abilities12= "{{{Id|}}}" OR Abilities21= "{{{Id|}}}" OR Abilities22= "{{{Id|}}}"|format=ul|group by=_pageName|default=
+
|10103={{#vardefine:bgcolor|ffb6c1}}{{#vardefine:bordercolor|cd5c5c}}{{#vardefine:stat|Hp/Str}}<!--
:''There are no dragons with this ability.''|order by= ElementalTypeId ASC, Rarity DESC, Id DESC, FullName ASC}}
+
-->{{#vardefine:hpStrNodeCounter| {{#expr:{{#var:hpStrNodeCounter}}-1 }} }}<!--
 +
-->{{#vardefine:titleAdd|}}<!--
 +
-->{{#ifexpr: {{#var:hpStrHpMod}} > {{#var:hpStrNodeCounter}} | {{#vardefine:titleAdd1| +{{#expr: ceil({{#var:hp{{#expr:{{{Hierarchy|}}}-1}}}} / {{#var:totalHpStrNodes}}) }} }} }}<!--
 +
-->{{#ifexpr: {{#var:hpStrHpMod}} = {{#var:hpStrNodeCounter}} | {{#vardefine:titleAdd1| +{{#expr: floor({{#var:hp{{#expr:{{{Hierarchy|}}}-1}}}} / {{#var:totalHpStrNodes}}) }} }} }}<!--
 +
-->{{#ifexpr: {{#var:hpStrHpMod}} < {{#var:hpStrNodeCounter}} | {{#vardefine:titleAdd1| +{{#expr: floor({{#var:hp{{#expr:{{{Hierarchy|}}}-1}}}} / {{#var:totalHpStrNodes}}) }} }} }}<!--
 +
-->{{#ifexpr: {{#var:hpStrStrMod}} > {{#var:hpStrNodeCounter}} | {{#vardefine:titleAdd2| +{{#expr: ceil({{#var:str{{#expr:{{{Hierarchy|}}}-1}}}} / {{#var:totalHpStrNodes}}) }} }} }}<!--
 +
-->{{#ifexpr: {{#var:hpStrStrMod}} = {{#var:hpStrNodeCounter}} | {{#vardefine:titleAdd2| +{{#expr: floor({{#var:str{{#expr:{{{Hierarchy|}}}-1}}}} / {{#var:totalHpStrNodes}}) }} }} }}<!--
 +
-->{{#ifexpr: {{#var:hpStrStrMod}} < {{#var:hpStrNodeCounter}} | {{#vardefine:titleAdd2| +{{#expr: floor({{#var:str{{#expr:{{{Hierarchy|}}}-1}}}} / {{#var:totalHpStrNodes}}) }} }} }}<!--
 +
-->{{#vardefine:title|[[File:Mc StatusUp HpAtk.png|32px|link=]] HP {{#var:titleAdd1}} / Strength {{#var:titleAdd2}} }}<!--
  
<p style="margin:15px auto;border-bottom:1px solid;margin-bottom:15px;font-size:1.2em;font-variant-caps: small-caps;font-weight:bold">Weapons With This Ability</p>
+
-->
{{#cargo_query:tables=Weapons|fields=CONCAT('[[File:',BaseId,' 01 ',FormId,'.png|24px|link=',_pageName,']] [[',_pageName,']]')|where=Abilities11= "{{{Id|}}}" OR Abilities21= "{{{Id|}}}"|format=ul|group by=_pageName|default=
+
|10201={{#vardefine:bgcolor|cfb3ef}}{{#vardefine:bordercolor|774bb3}}<!--
:''There are no weapons with this ability.''|order by= ElementalTypeId ASC, TypeId ASC, Rarity DESC, Id DESC, WeaponName ASC}}
+
-->{{#vardefine:title|[[File:Mc Burstattack Get.png|32px|link=]] Force Strike}}<!--
 +
-->{{#vardefine:10201Level| {{#expr:{{#var:10201Level}}+1}} }}<!--
 +
-->{{#ifexpr: {{#var:{{{ManaPieceType|}}}Level}} > 1  | {{#vardefine:bgcolor|ffeac4}}{{#vardefine:bordercolor|ffb837}} {{#vardefine:title|[[File:Mc Burstattack Upgrade.png|32px|link=]] Force Strike}}}}<!--
 +
-->{{#vardefine:titleAdd|Lv. {{#var:{{{ManaPieceType|}}}Level}} }}<!--
  
[[Category:Abilities]][[Category:{{{Subcategory|}}} Ability]]</includeonly>
+
-->
 +
|10301={{#vardefine:bgcolor|cfb3ef}}{{#vardefine:bordercolor|774bb3}}<!--
 +
-->{{#vardefine:10301Level| {{#expr:({{#var:10301Level}} + {{{Hierarchy|}}} - ( {{{Hierarchy|}}} mod 2) ) div 2 }} }}<!--
 +
-->{{#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}}}}<!--
 +
-->{{#ifexpr: {{#var:{{{ManaPieceType|}}}Level}} > 1  | {{#vardefine:bgcolor|ffeac4}}{{#vardefine:bordercolor|ffb837}} }}<!--
 +
 
 +
-->
 +
|10302={{#vardefine:bgcolor|cfb3ef}}{{#vardefine:bordercolor|774bb3}}<!--
 +
-->{{#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
 +
 
 +
-->{{#ifeq:{{{IsReleaseStory|}}} | 1 | {{#vardefine:title|[[File:Mc CharaStory.png|32px|link=]] New Adventurer Story}}{{#vardefine:bgcolor|b3deff}}{{#vardefine:bordercolor|00bfff}} | }}<!--
 +
 
 +
### Template Display ###
 +
 
 +
--><div>
 +
{| class="mana-circle-table" style="border:1px solid #{{#var:bordercolor}}"
 +
! style="background-color:#{{#var:bgcolor}}" | {{#var:title}} {{#ifeq:{{{IsReleaseStory|}}} | 1 | | {{#var:titleAdd}} }}<!--
 +
### To-Do: {{#if:{{{might|}}}|<br/><div style="font-size:.8em;">{{Tooltip|+{{{might|}}} Might|+Amount of Might Gained (Total Might Value of Skill)}}</div>}}
 +
-->
 +
|-
 +
| style="text-align:center; position: relative;" | <div><u>'''Cost'''</u><span style="font-weight:normal;"><!--
 +
 
 +
-->{{#ifeq:{{{NecessaryManaPoint|0}}} | 0 | | <br/>{{Icon|Resource|Mana|size=16px|text=1}} x{{{NecessaryManaPoint|0}}} }}<!--
 +
-->{{#switch:{{{ManaPieceType|}}}
 +
|10101
 +
|10102
 +
|10103=
 +
|#default={{#invoke:CargoQuery|main
 +
|q?tables=ManaPieceElement
 +
|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?where=ElementId="{{#var:shortManaCircleName}}" AND ManaPieceType="{{{ManaPieceType|}}}"
 +
|template=MCNodeMaterialDisplay
 +
}}
 +
}}</span></div>
 +
{{#ifeq:{{{IsReleaseStory|}}} | 1 | <div style="font-weight:normal">'''{{#var:stat}} {{#var:titleAdd}}''' upon node unlock</div> }}
 +
|}</div>

Latest revision as of 21:19, 8 July 2020