Difference between revisions of "Template:EnemyHeaderTest"

Latest revision as of 22:47, 26 April 2020

Template:EnemyHeaderTest/doc

@@ Line 7: / Line 7: @@
 --><!--
--->__TOC__
+-->{{#invoke:CargoQuery|main
+  |q?tables=EnemiesTest
+  |q?fields=ElementalType,Tribe,RareStayTime,ModelId,PartsA,PartsB,PartsC,PartsD
+  |q?where=Name="{{{Name|{{PAGENAME}}}}}"
+  |q?groupBy=ElementalType
+  |template=vardefine}}<!--
+-->__NOTOC__
 <div class="panel enemy-container" style="max-width:850px; border:1px solid #aaa; margin-bottom:1em;">
-<div class="panel-heading"><div>{{InlineIcon|Icon Element|{{#cargo_query:tables=EnemiesTest|where=Name="{{{Name|{{PAGENAME}}}}}"|fields=ElementalType|group by=Name|limit=1|more results text=|no html}}}} {{{Name|{{PAGENAME}}}}} <span style="font-size:.6em;">{{#ifeq:{{#cargo_query:tables=EnemiesTest|where=Name="{{{Name|{{PAGENAME}}}}}"|fields=RareStayTime|group by=Name|limit=1|more results text=|default=0|no html}} | 0 | {{#vardefine:statsTableQueryFields|MissionType=MissionType,HP=HP,Atk=Atk,Def=Def,Weapon=Weapon,Overwhelm=Overwhelm,MoveSpeed=MoveSpeed,TurnSpeed=TurnSpeed,SuperArmor=SuperArmor}} | (Rare){{#vardefine:statsTableQueryFields|MissionType=MissionType,RareStayTime=RareStayTime,HP=HP,Atk=Atk,Def=Def,Weapon=Weapon,Overwhelm=Overwhelm,MoveSpeed=MoveSpeed,TurnSpeed=TurnSpeed,SuperArmor=SuperArmor}} }}</span></div></div>
+<div class="panel-heading">
+  <div style="margin-bottom:-8px"><!--
+  -->{{InlineIcon|Icon Element|{{#var:ElementalType}}}} <span style="font-size:.7em;">{{#var:Tribe}}</span>
+  </div>
+  <div><!--
+  -->{{{Name|{{PAGENAME}}}}} <!--
+  --><span style="font-size:.6em;"><!--
+    -->{{#ifeq:{{#var:RareStayTime}} | 0
+          | {{#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]]
+        }}{{#ifeq:{{#var:PartsA}}{{#var:PartsB}}{{#var:PartsC}}{{#var:PartsD}} | 0000
+          |
+          | [[Category:Enemies with Multiple Parts]]<!--
+-->{{#vardefine:PartsAList|{{#cargo_query:tables=EnemiesTest
+  |fields=PartsA
+  |where=Name="{{{Name|{{PAGENAME}}}}}"
+  |group by=PartsA
+  |default=|no html}}}}
+{{#vardefine:PartsBList|{{#cargo_query:tables=EnemiesTest
+  |fields=PartsB
+  |where=Name="{{{Name|{{PAGENAME}}}}}"
+  |group by=PartsB
+  |default=|no html}}}}
+{{#vardefine:PartsCList|{{#cargo_query:tables=EnemiesTest
+  |fields=PartsC
+  |where=Name="{{{Name|{{PAGENAME}}}}}"
+  |group by=PartsC
+  |default=|no html}}}}
+{{#vardefine:PartsDList|{{#cargo_query:tables=EnemiesTest
+  |fields=PartsD
+  |where=Name="{{{Name|{{PAGENAME}}}}}"
+  |group by=PartsD
+  |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 style="padding:1em;">
 {{#widget:EnemyMapDropdown
 |maps={{#cargo_query:tables=EnemiesTest
-|where=Name="{{{Name|{{PAGENAME}}}}}"
+|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%")
 |fields=CONCAT("\"", MissionType, "\"")
 |group by=MonsterId
@@ Line 25: / Line 71: @@
 |more results text=
 |no html
-|order by=Hp
+|order by=HP DESC
 }}
 }}
+{{#if:{{#var:PartsAList}}{{#var:PartsBList}}{{#var:PartsCList}}{{#var:PartsDList}} | <!--
+### Part Name Vardefines
+-->{{#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: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}}}}
+}}
+<div class="enemy-info-table">
 {{StylizedHeader|Stats}}
-{{#cargo_query:tables=EnemiesTest
+{{#if:{{#var:PartsAName}}{{#var:PartsBName}}{{#var:PartsCName}}{{#var:PartsDName}}{{{ExtraPart|}}} |
-|where=Name="{{{Name|{{PAGENAME}}}}}"
+{{tab/start}}
-|fields={{#var:statsTableQueryFields}}
+{{tab/header|{{{Name|{{PAGENAME}}}}}}}
-|format=table
+{{EnemyHeaderInfoTable|Name={{{Name|{{PAGENAME}}}}}|Fields={{#var:statsTableQueryFields}}}}<!--
-|named args=yes
+-->
-|order by=Hp
+{{#if:{{#var:PartsAName}} |
-|limit=99
+{{tab/header|{{#var:PartsAName}}}}
-|group by=MonsterId
+{{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:PartsCName}} |
+{{tab/header|{{#var:PartsCName}}}}
+{{EnemyHeaderInfoTable|Query=MonsterId IN ({{#var:PartsCList}})|Fields={{#var:statsTableQueryFields}}}}
+}}
+{{#if:{{#var:PartsDName}} |
+{{tab/header|{{#var:PartsDName}}}}
+{{EnemyHeaderInfoTable|Query=MonsterId IN ({{#var:PartsDList}})|Fields={{#var:statsTableQueryFields}}}}
+}}
+{{#if:{{{ExtraPart|}}} |
+{{tab/header|{{{ExtraPart|}}}}}
+{{EnemyHeaderInfoTable|Query=Name="{{{ExtraPart|}}}" AND MissionType IN ({{#var:QuestList}})|Fields={{#var:statsTableQueryFields}}}}
+}}
+{{tab/end}}
+| {{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}}
-{{#cargo_query:tables=EnemiesTest
+{{#if:{{#var:PartsAName}}{{#var:PartsBName}}{{#var:PartsCName}}{{#var:PartsDName}}{{{ExtraPart|}}} |
-|where=Name="{{{Name|{{PAGENAME}}}}}"
+{{tab/start}}
-|fields=MissionType=MissionType,BaseOD=BaseOD,BaseBreak=BaseBreak,BreakDuration=BreakDuration,ODAtkRate=ODAtkRate,ODDefRate=ODDefRate,BreakAtkRate=BreakAtkRate,BreakDefRate=BreakDefRate
+{{tab/header|{{{Name|{{PAGENAME}}}}}}}
-|format=table
+{{EnemyHeaderInfoTable|Name={{{Name|{{PAGENAME}}}}}|Fields={{#var:ODBreakQueryFields}}}}<!--
-|named args=yes
+-->
-|order by=Hp
+{{#if:{{#var:PartsAName}} |
-|limit=99
+{{tab/header|{{#var:PartsAName}}}}
-|group by=MonsterId
+{{EnemyHeaderInfoTable|Query=MonsterId IN ({{#var:PartsAList}})|Fields={{#var:ODBreakQueryFields}}}}
+}}
+{{#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}}}}
 }}
+{{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}}
-{{#cargo_query:tables=EnemiesTest
+{{#if:{{#var:PartsAName}}{{#var:PartsBName}}{{#var:PartsCName}}{{#var:PartsDName}}{{{ExtraPart|}}} |
-|where=Name="{{{Name|{{PAGENAME}}}}}"
+{{tab/start}}
-|fields=MissionType=MissionType,Poison=Poison,Burn=Burn,Freeze=Freeze,Paralysis=Paralysis,Blind=Blind,Stun=Stun,Curse=Curse,Bog=Bog,Sleep=Sleep
+{{tab/header|{{{Name|{{PAGENAME}}}}}}}
-|format=table
+{{EnemyHeaderInfoTable|Name={{{Name|{{PAGENAME}}}}}|Fields={{#var:AfflictionQueryFields}}}}<!--
-|named args=yes
+-->
-|order by=Hp
+{{#if:{{#var:PartsAName}} |
-|limit=99
+{{tab/header|{{#var:PartsAName}}}}
-|group by=MonsterId
+{{EnemyHeaderInfoTable|Query=MonsterId IN ({{#var:PartsAList}})|Fields={{#var:AfflictionQueryFields}}}}
+}}
+{{#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}}}}
 }}
+{{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.''
+{{{Skills|}}}}}
-{{#if:{{{Skills|}}} |
+{{StylizedHeader|3D Model}}
-{{StylizedHeader|Skills}}
+{{#if:{{{Model|}}} | {{{Model|}}} |
-''Similar to [[Combat Mechanics#Basic Attacks|basic attack modifiers]], enemies also have skill modifiers unique to each enemy's skill animation.''
+{{#widget:3DModelNotteMoe|id={{#var:ModelId}}}}
-{{{Skills|}}}
 }}
+{{StylizedHeader|Enemy Icons}}
+{{Exists|page=File:{{{Name|}}} Enemy Icon.png|then=[[File:{{{Name|}}} Enemy Icon.png]]|else=}}
+{{Exists|page=File:{{{Name|}}} Enemy Icon Double Drops.png|then=[[File:{{{Name|}}} Enemy Icon Double Drops.png]]|else=}}
 [[Category:Enemies]]
 </div>
 </div>
 </includeonly>

Difference between revisions of "Template:EnemyHeaderTest"

Latest revision as of 22:47, 26 April 2020

Navigation menu

Search