Difference between revisions of "Template:Afflictions"

From Dragalia Lost Wiki
Jump to navigation Jump to search
>Caledor92
>Caledor92
 
Line 155: Line 155:
 
{{#cargo_query:tables=EnemyPageLinks,EnemiesTest,Quests
 
{{#cargo_query:tables=EnemyPageLinks,EnemiesTest,Quests
 
|join on= EnemiesTest.Name=EnemyPageLinks.Name,EnemiesTest.MissionType=Quests.QuestViewName
 
|join on= EnemiesTest.Name=EnemyPageLinks.Name,EnemiesTest.MissionType=Quests.QuestViewName
|where=EnemiesTest.{{{EnemyRes|{{PAGENAME}}}}} != 0 AND EnemiesTest.Name IS NOT NULL AND EnemyPageLinks.Name IS NOT NULL AND EnemiesTest.MissionType NOT LIKE "%debug%" AND EnemiesTest.HP != 9999999 AND EnemiesTest.Def != 100000
+
|where=EnemiesTest.{{{EnemyRes|{{{Name|{{PAGENAME}}}}}}}} != 0 AND EnemiesTest.Name IS NOT NULL AND EnemyPageLinks.Name IS NOT NULL AND EnemiesTest.MissionType NOT LIKE "%debug%" AND EnemiesTest.HP != 9999999 AND EnemiesTest.Def != 100000
|fields=CONCAT('[[', EnemyPageLinks._pageName, '|', EnemiesTest.Name, ']]')=Name,EnemiesTest.ElementalType=Element,EnemiesTest.Tribe=Class,EnemiesTest.HP=HP,EnemiesTest.Atk=Str,EnemiesTest.Def=Def,EnemiesTest.{{{Name|{{PAGENAME}}}}}={{{Name|{{PAGENAME}}}}} Res Value,CONCAT('[[', Quests._pageName, '|', EnemiesTest.MissionType, ']]')=Quest
+
|fields=CONCAT('[[', EnemyPageLinks._pageName, '|', EnemiesTest.Name, ']]')=Name,EnemiesTest.ElementalType=Element,EnemiesTest.Tribe=Class,EnemiesTest.HP=HP,EnemiesTest.Atk=Str,EnemiesTest.Def=Def,EnemiesTest.{{{EnemyRes|{{{Name|{{PAGENAME}}}}}}}}={{{EnemyRes|{{{Name|{{PAGENAME}}}}}}}} Res Value,CONCAT('[[', Quests._pageName, '|', EnemiesTest.MissionType, ']]')=Quest
 
|group by=EnemiesTest.MonsterId
 
|group by=EnemiesTest.MonsterId
 
|order by=EnemiesTest.HP DESC,EnemiesTest.Name
 
|order by=EnemiesTest.HP DESC,EnemiesTest.Name

Latest revision as of 10:35, 19 July 2020

50px Documentation

Description

For Affliction pages

Usage

{{Afflictions
|Name=
|Icon=
|Description=
|InflictSkills=
|InflictAbilities=
|InflictCoAbilities=
|InflictChainCoAbilities=
|InflictEnemies=
|QuestTraps=
|AdditionalEffectSkills=
|AdditionalEffectAbilities=
|AdditionalEffectCoAbilities=
|AdditionalEffectChainCoAbilities=
|ChainEffectAbilities=
|ChainEffectCoAbilities=
|ChainEffectChainCoAbilities=
|CureSkills=
|AbilityResist=
}}