Difference between revisions of "Template:EnemyHeaderTest"

From Dragalia Lost Wiki
Jump to navigation Jump to search
imported>Elaeagnifolia
imported>Elaeagnifolia
 
(47 intermediate revisions by the same user not shown)
Line 9: Line 9:
 
-->{{#invoke:CargoQuery|main
 
-->{{#invoke:CargoQuery|main
 
   |q?tables=EnemiesTest
 
   |q?tables=EnemiesTest
   |q?fields=ElementalType,Tribe,RareStayTime,ModelId,PartsA
+
   |q?fields=ElementalType,Tribe,RareStayTime,ModelId,PartsA,PartsB,PartsC,PartsD
 
   |q?where=Name="{{{Name|{{PAGENAME}}}}}"
 
   |q?where=Name="{{{Name|{{PAGENAME}}}}}"
 
   |q?groupBy=ElementalType
 
   |q?groupBy=ElementalType
Line 26: Line 26:
 
           | {{#vardefine:statsTableQueryFields|MissionType=Quest(s),CONCAT('{{InlineIcon|Icon Element|', ElementalType, '}}')=Element,Tribe=Class,HP=HP,Atk=Str,Def=Def,Overwhelm=Overwhelm,MoveSpeed=Move Speed,TurnSpeed=Turn Speed,SuperArmor=Super Armor}}
 
           | {{#vardefine:statsTableQueryFields|MissionType=Quest(s),CONCAT('{{InlineIcon|Icon Element|', ElementalType, '}}')=Element,Tribe=Class,HP=HP,Atk=Str,Def=Def,Overwhelm=Overwhelm,MoveSpeed=Move Speed,TurnSpeed=Turn Speed,SuperArmor=Super Armor}}
 
           | {{#vardefine:statsTableQueryFields|MissionType=Quest(s),CONCAT('{{InlineIcon|Icon Element|', ElementalType, '}}')=Element,Tribe=Class,RareStayTime=Stay Time,HP=HP,Atk=Atk,Def=Def,Overwhelm=Overwhelm,MoveSpeed=Move Speed,TurnSpeed=Turn Speed,SuperArmor=Super Armor}}(Rare)[[Category:Rare Enemies]]
 
           | {{#vardefine:statsTableQueryFields|MissionType=Quest(s),CONCAT('{{InlineIcon|Icon Element|', ElementalType, '}}')=Element,Tribe=Class,RareStayTime=Stay Time,HP=HP,Atk=Atk,Def=Def,Overwhelm=Overwhelm,MoveSpeed=Move Speed,TurnSpeed=Turn Speed,SuperArmor=Super Armor}}(Rare)[[Category:Rare Enemies]]
         }}{{#ifeq:{{#var:RareStayTime}} | 0
+
         }}{{#ifeq:{{#var:PartsA}}{{#var:PartsB}}{{#var:PartsC}}{{#var:PartsD}} | 0000
 
           |  
 
           |  
           | {{#vardefine:statsTableQueryFields|MissionType=Quest(s),CONCAT('{{InlineIcon|Icon Element|', ElementalType, '}}')=Element,Tribe=Class,RareStayTime=Stay Time,HP=HP,Atk=Atk,Def=Def,Overwhelm=Overwhelm,MoveSpeed=Move Speed,TurnSpeed=Turn Speed,SuperArmor=Super Armor}}[[Category:Enemies with Parts]]<!--
+
           | [[Category:Enemies with Multiple Parts]]<!--
 
-->{{#vardefine:PartsAList|{{#cargo_query:tables=EnemiesTest
 
-->{{#vardefine:PartsAList|{{#cargo_query:tables=EnemiesTest
 
   |fields=PartsA
 
   |fields=PartsA
Line 48: Line 48:
 
   |where=Name="{{{Name|{{PAGENAME}}}}}"
 
   |where=Name="{{{Name|{{PAGENAME}}}}}"
 
   |group by=PartsD
 
   |group by=PartsD
   |default=|no html}}}}}}</span>
+
   |default=|no html}}}}}}
 +
{{#vardefine:QuestList|{{#cargo_query:tables=EnemiesTest
 +
  |fields=CONCAT('"', MissionType, '"')
 +
  |where=Name="{{{Name|{{PAGENAME}}}}}"
 +
  |group by=MissionType
 +
  |default=|no html}}}}</span>
 
   </div>
 
   </div>
 
</div>
 
</div>
Line 70: Line 75:
 
}}
 
}}
  
{{StylizedHeader|Stats}}
+
{{#if:{{#var:PartsAList}}{{#var:PartsBList}}{{#var:PartsCList}}{{#var:PartsDList}} | <!--
{{#if:{{#var:PartsAList}} |
 
{{tab/start}}  
 
{{tab/header|{{{Name|{{PAGENAME}}}}}}}
 
{{EnemyHeaderInfoTable|Name={{{Name|{{PAGENAME}}}}}}}
 
<!--
 
  
Part Name Vardefines
+
### Part Name Vardefines
  
 
-->{{#vardefine:PartsAName|{{#cargo_query:tables=EnemiesTest|fields=Name|where=MonsterId IN ({{#var:PartsAList}})|group by=Name|default=|no html}}}}<!--
 
-->{{#vardefine:PartsAName|{{#cargo_query:tables=EnemiesTest|fields=Name|where=MonsterId IN ({{#var:PartsAList}})|group by=Name|default=|no html}}}}<!--
 
-->{{#vardefine:PartsBName|{{#cargo_query:tables=EnemiesTest|fields=Name|where=MonsterId IN ({{#var:PartsBList}})|group by=Name|default=|no html}}}}<!--
 
-->{{#vardefine:PartsBName|{{#cargo_query:tables=EnemiesTest|fields=Name|where=MonsterId IN ({{#var:PartsBList}})|group by=Name|default=|no html}}}}<!--
 
-->{{#vardefine:PartsCName|{{#cargo_query:tables=EnemiesTest|fields=Name|where=MonsterId IN ({{#var:PartsCList}})|group by=Name|default=|no html}}}}<!--
 
-->{{#vardefine:PartsCName|{{#cargo_query:tables=EnemiesTest|fields=Name|where=MonsterId IN ({{#var:PartsCList}})|group by=Name|default=|no html}}}}<!--
-->{{#vardefine:PartsDName|{{#cargo_query:tables=EnemiesTest|fields=Name|where=MonsterId IN ({{#var:PartsDList}})|group by=Name|default=|no html}}}}<!--
+
-->{{#vardefine:PartsDName|{{#cargo_query:tables=EnemiesTest|fields=Name|where=MonsterId IN ({{#var:PartsDList}})|group by=Name|default=|no html}}}}
 +
}}
  
### Part Tabs
+
<div class="enemy-info-table">
 +
{{StylizedHeader|Stats}}
 +
{{#if:{{#var:PartsAName}}{{#var:PartsBName}}{{#var:PartsCName}}{{#var:PartsDName}}{{{ExtraPart|}}} |
 +
{{tab/start}}
 +
{{tab/header|{{{Name|{{PAGENAME}}}}}}}
 +
{{EnemyHeaderInfoTable|Name={{{Name|{{PAGENAME}}}}}|Fields={{#var:statsTableQueryFields}}}}<!--
 
-->
 
-->
{{#if:{{#var:PartsAName}} | {{tab/header|{{#var:PartsAName}}
+
{{#if:{{#var:PartsAName}} |  
{{EnemyHeaderInfoTable|Query=MonsterId IN ({{#var:PartsAList}})}}
+
{{tab/header|{{#var:PartsAName}}}}
 +
{{EnemyHeaderInfoTable|Query=MonsterId IN ({{#var:PartsAList}})|Fields={{#var:statsTableQueryFields}}}}
 +
}}
 +
{{#if:{{#var:PartsBName}} |
 +
{{tab/header|{{#var:PartsBName}}}}
 +
{{EnemyHeaderInfoTable|Query=MonsterId IN ({{#var:PartsBList}})|Fields={{#var:statsTableQueryFields}}}}
 
}}
 
}}
{{#if:{{#var:PartsBName}} | {{tab/header|{{#var:PartsBName}}
+
{{#if:{{#var:PartsCName}} |  
{{EnemyHeaderInfoTable|Query=MonsterId IN ({{#var:PartsBList}})}}
+
{{tab/header|{{#var:PartsCName}}}}
 +
{{EnemyHeaderInfoTable|Query=MonsterId IN ({{#var:PartsCList}})|Fields={{#var:statsTableQueryFields}}}}
 
}}
 
}}
{{#if:{{#var:PartsCName}} | {{tab/header|{{#var:PartsCName}}
+
{{#if:{{#var:PartsDName}} |  
{{EnemyHeaderInfoTable|Query=MonsterId IN ({{#var:PartsCList}})}}
+
{{tab/header|{{#var:PartsDName}}}}
 +
{{EnemyHeaderInfoTable|Query=MonsterId IN ({{#var:PartsDList}})|Fields={{#var:statsTableQueryFields}}}}
 
}}
 
}}
{{#if:{{#var:PartsDName}} | {{tab/header|{{#var:PartsDName}}
+
{{#if:{{{ExtraPart|}}} |
{{EnemyHeaderInfoTable|Query=MonsterId IN ({{#var:PartsDList}})}}
+
{{tab/header|{{{ExtraPart|}}}}}
 +
{{EnemyHeaderInfoTable|Query=Name="{{{ExtraPart|}}}" AND MissionType IN ({{#var:QuestList}})|Fields={{#var:statsTableQueryFields}}}}
 
}}
 
}}
 
{{tab/end}}
 
{{tab/end}}
| {{EnemyHeaderInfoTable|Name={{{Name|{{PAGENAME}}}}}}}
+
| {{EnemyHeaderInfoTable|Name={{{Name|{{PAGENAME}}}}}|Fields={{#var:statsTableQueryFields}}}}
 +
{{#if:{{{ExtraPart|}}} |
 +
{{tab/header|{{{ExtraPart|}}}}}
 +
{{EnemyHeaderInfoTable|Query=Name="{{{ExtraPart|}}}" AND MissionType IN ({{#var:QuestList}})|Fields={{#var:statsTableQueryFields}}}}
 
}}
 
}}
 +
}}</div>
  
 
+
{{#vardefine:ODBreakQueryFields|MissionType=Quest(s),BaseOD=Base OD,BaseBreak=Base Break,BreakDuration=Break Duration,ODAtkRate=OD Str Rate,ODDefRate=OD Def Rate,BreakAtkRate=Break Str Rate,BreakDefRate=Break Def Rate}}
 +
<div class="enemy-info-table">
 
{{StylizedHeader|Overdrive/Break Stats}}
 
{{StylizedHeader|Overdrive/Break Stats}}
<div class="enemy-info-table">
+
{{#if:{{#var:PartsAName}}{{#var:PartsBName}}{{#var:PartsCName}}{{#var:PartsDName}}{{{ExtraPart|}}} |
{{#cargo_query:tables=EnemiesTest
+
{{tab/start}}
|where=(Name="{{{Name|{{PAGENAME}}}}}" AND EnemiesTest.MissionType NOT LIKE "%debug%") AND ((EnemiesTest.MissionType LIKE "%Flame%" AND EnemiesTest.MissionType NOT RLIKE "[7][1-9]" AND EnemiesTest.MissionType NOT RLIKE "[8-9][0-9]") OR (EnemiesTest.MissionType LIKE "%Water%" AND EnemiesTest.MissionType NOT RLIKE "[7][1-9]" AND EnemiesTest.MissionType NOT RLIKE "[8-9][0-9]") OR (EnemiesTest.MissionType LIKE "%Wind%" AND EnemiesTest.MissionType NOT RLIKE "[7][1-9]" AND EnemiesTest.MissionType NOT RLIKE "[8-9][0-9]") OR (EnemiesTest.MissionType LIKE "%Light%" AND EnemiesTest.MissionType NOT RLIKE "[7][1-9]" AND EnemiesTest.MissionType NOT RLIKE "[8-9][0-9]") OR (EnemiesTest.MissionType LIKE "%Shadow%" AND EnemiesTest.MissionType NOT RLIKE "[7][1-9]" AND EnemiesTest.MissionType NOT RLIKE "[8-9][0-9]") OR EnemiesTest.MissionType NOT LIKE "%The Mercurial Gauntlet%")
+
{{tab/header|{{{Name|{{PAGENAME}}}}}}}
|fields=MissionType=Quest(s),BaseOD=Base OD,BaseBreak=Base Break,BreakDuration=Break Duration,ODAtkRate=OD Str Rate,ODDefRate=OD Def Rate,BreakAtkRate=Break Str Rate,BreakDefRate=Break Def Rate
+
{{EnemyHeaderInfoTable|Name={{{Name|{{PAGENAME}}}}}|Fields={{#var:ODBreakQueryFields}}}}<!--
|format=table
+
-->
|named args=yes
+
{{#if:{{#var:PartsAName}} |
|order by=HP DESC
+
{{tab/header|{{#var:PartsAName}}}}
|limit=160
+
{{EnemyHeaderInfoTable|Query=MonsterId IN ({{#var:PartsAList}})|Fields={{#var:ODBreakQueryFields}}}}
|more results text=
+
}}
|group by=MonsterId
+
{{#if:{{#var:PartsBName}} |
 +
{{tab/header|{{#var:PartsBName}}}}
 +
{{EnemyHeaderInfoTable|Query=MonsterId IN ({{#var:PartsBList}})|Fields={{#var:ODBreakQueryFields}}}}
 +
}}
 +
{{#if:{{#var:PartsCName}} |
 +
{{tab/header|{{#var:PartsCName}}}}
 +
{{EnemyHeaderInfoTable|Query=MonsterId IN ({{#var:PartsCList}})|Fields={{#var:ODBreakQueryFields}}}}
 +
}}
 +
{{#if:{{#var:PartsDName}} |
 +
{{tab/header|{{#var:PartsDName}}}}
 +
{{EnemyHeaderInfoTable|Query=MonsterId IN ({{#var:PartsDList}})|Fields={{#var:ODBreakQueryFields}}}}
 +
}}
 +
{{#if:{{{ExtraPart|}}} |
 +
{{tab/header|{{{ExtraPart|}}}}}
 +
{{EnemyHeaderInfoTable|Query=Name="{{{ExtraPart|}}}" AND MissionType IN ({{#var:QuestList}})|Fields={{#var:ODBreakQueryFields}}}}
 
}}
 
}}
</div>
+
{{tab/end}}
 +
| {{EnemyHeaderInfoTable|Name={{{Name|{{PAGENAME}}}}}|Fields={{#var:ODBreakQueryFields}}}}
 +
}}</div>
  
 +
{{#vardefine:AfflictionQueryFields|MissionType=Quest(s),Poison=Poison,Burn=Burn,Freeze=Freeze,Paralysis=Paralysis,Blind=Blind,Stun=Stun,Curse=Curse,Bog=Bog,Sleep=Sleep,Frostbite=Frostbite}}
 +
<div class="enemy-info-table">
 
{{StylizedHeader|Affliction Resists}}
 
{{StylizedHeader|Affliction Resists}}
<div class="enemy-info-table">
+
{{#if:{{#var:PartsAName}}{{#var:PartsBName}}{{#var:PartsCName}}{{#var:PartsDName}}{{{ExtraPart|}}} |
{{#cargo_query:tables=EnemiesTest
+
{{tab/start}}
|where=(Name="{{{Name|{{PAGENAME}}}}}" AND EnemiesTest.MissionType NOT LIKE "%debug%") AND ((EnemiesTest.MissionType LIKE "%Flame%" AND EnemiesTest.MissionType NOT RLIKE "[7][1-9]" AND EnemiesTest.MissionType NOT RLIKE "[8-9][0-9]") OR (EnemiesTest.MissionType LIKE "%Water%" AND EnemiesTest.MissionType NOT RLIKE "[7][1-9]" AND EnemiesTest.MissionType NOT RLIKE "[8-9][0-9]") OR (EnemiesTest.MissionType LIKE "%Wind%" AND EnemiesTest.MissionType NOT RLIKE "[7][1-9]" AND EnemiesTest.MissionType NOT RLIKE "[8-9][0-9]") OR (EnemiesTest.MissionType LIKE "%Light%" AND EnemiesTest.MissionType NOT RLIKE "[7][1-9]" AND EnemiesTest.MissionType NOT RLIKE "[8-9][0-9]") OR (EnemiesTest.MissionType LIKE "%Shadow%" AND EnemiesTest.MissionType NOT RLIKE "[7][1-9]" AND EnemiesTest.MissionType NOT RLIKE "[8-9][0-9]") OR EnemiesTest.MissionType NOT LIKE "%The Mercurial Gauntlet%")
+
{{tab/header|{{{Name|{{PAGENAME}}}}}}}
|fields=MissionType=Quest(s),Poison=Poison,Burn=Burn,Freeze=Freeze,Paralysis=Paralysis,Blind=Blind,Stun=Stun,Curse=Curse,Bog=Bog,Sleep=Sleep,Frostbite=Frostbite
+
{{EnemyHeaderInfoTable|Name={{{Name|{{PAGENAME}}}}}|Fields={{#var:AfflictionQueryFields}}}}<!--
|format=table
+
-->
|named args=yes
+
{{#if:{{#var:PartsAName}} |
|order by=HP DESC
+
{{tab/header|{{#var:PartsAName}}}}
|limit=160
+
{{EnemyHeaderInfoTable|Query=MonsterId IN ({{#var:PartsAList}})|Fields={{#var:AfflictionQueryFields}}}}
|more results text=
+
}}
|group by=MonsterId
+
{{#if:{{#var:PartsBName}} |
 +
{{tab/header|{{#var:PartsBName}}}}
 +
{{EnemyHeaderInfoTable|Query=MonsterId IN ({{#var:PartsBList}})|Fields={{#var:AfflictionQueryFields}}}}
 +
}}
 +
{{#if:{{#var:PartsCName}} |
 +
{{tab/header|{{#var:PartsCName}}}}
 +
{{EnemyHeaderInfoTable|Query=MonsterId IN ({{#var:PartsCList}})|Fields={{#var:AfflictionQueryFields}}}}
 +
}}
 +
{{#if:{{#var:PartsDName}} |
 +
{{tab/header|{{#var:PartsDName}}}}
 +
{{EnemyHeaderInfoTable|Query=MonsterId IN ({{#var:PartsDList}})|Fields={{#var:AfflictionQueryFields}}}}
 +
}}
 +
{{#if:{{{ExtraPart|}}} |
 +
{{tab/header|{{{ExtraPart|}}}}}
 +
{{EnemyHeaderInfoTable|Query=Name="{{{ExtraPart|}}}" AND MissionType IN ({{#var:QuestList}})|Fields={{#var:AfflictionQueryFields}}}}
 
}}
 
}}
</div>{{#if:{{{Skills|}}} |{{StylizedHeader|Skills}}
+
{{tab/end}}
 +
| {{EnemyHeaderInfoTable|Name={{{Name|{{PAGENAME}}}}}|Fields={{#var:AfflictionQueryFields}}}}
 +
}}</div>{{#if:{{{Skills|}}} |{{StylizedHeader|Skills}}
 
''Similar to [[Combat Mechanics#Basic Attacks|basic attack modifiers]], enemies also have skill modifiers unique to each enemy's skill animation.''
 
''Similar to [[Combat Mechanics#Basic Attacks|basic attack modifiers]], enemies also have skill modifiers unique to each enemy's skill animation.''
 
{{{Skills|}}}}}
 
{{{Skills|}}}}}

Latest revision as of 22:47, 26 April 2020