Difference between revisions of "Adventurer Detailed List"

From Dragalia Lost Wiki
Jump to navigation Jump to search
imported>Elaeagnifolia
>Eave
m (pass through EditSkillId for filtering)
 
(88 intermediate revisions by 9 users not shown)
Line 17: Line 17:
 
! Skill 1
 
! Skill 1
 
! Skill 2
 
! Skill 2
−
! Co-Ability
+
! {{Tooltip|Co-Ability|Ability shown is the max upgraded ability.}}
−
! Ability 1
+
! {{Tooltip|Chain Co-Ability|Ability shown is the max upgraded ability.}}
−
! Ability 2
+
! {{Tooltip|Ability 1|Ability shown is the max upgraded ability.}}
−
! Ability 3
+
! {{Tooltip|Ability 2|Ability shown is the max upgraded ability.}}
 +
! {{Tooltip|Ability 3|Ability shown is the max upgraded ability.}}
 
! Def
 
! Def
 
! Release Date
 
! Release Date
−
{{#cargo_query:tables=Adventurers
+
! Obtain
−
|fields=_pageName=Link,FullName=Name,ElementalType=Element,Title,WeaponType=Weapon,Rarity,Id=InternalId,CharaType=Type,MaxHp,PlusHp0,PlusHp1,PlusHp2,PlusHp3,PlusHp4,McFullBonusHp5,MaxAtk,PlusAtk0,PlusAtk1,PlusAtk2,PlusAtk3,PlusAtk4,McFullBonusAtk5,DefCoef,VariationId,ReleaseDate,Abilities11,Abilities12,Abilities21,Abilities22,Abilities31,Abilities32,Skill1Name,Skill2Name,ExAbilityData1,ExAbilityData2,ExAbilityData3,ExAbilityData4,ExAbilityData5
+
{{#invoke:CargoQuery|main
−
|where=IsPlayable!=0 AND DATEDIFF(ReleaseDate,NOW()) <= 0
+
|q?tables=Adventurers
−
|format=template
+
|q?fields=_pageName=Link,FullName=Name,ElementalType=Element,Title,WeaponType=Weapon,Rarity,Availability,Id=InternalId,CharaType=Type,MaxHp,AddMaxHp1,PlusHp0,PlusHp1,PlusHp2,PlusHp3,PlusHp4,PlusHp5,McFullBonusHp5,MaxAtk,AddMaxAtk1,PlusAtk0,PlusAtk1,PlusAtk2,PlusAtk3,PlusAtk4,PlusAtk5,McFullBonusAtk5,DefCoef,VariationId,ReleaseDate,Obtain,Abilities11,Abilities12,Abilities13,Abilities14,Abilities21,Abilities22,Abilities23,Abilities24,Abilities31,Abilities32,Abilities33,Abilities34,Skill1Name,Skill2Name,ExAbilityData5,ExAbility2Data5,MaxLimitBreakCount,EditSkillId
 +
|q?where=IsPlayable!=0 AND ReleaseDate <= NOW()
 
|template=CharacterDetailedTableEntry
 
|template=CharacterDetailedTableEntry
−
|named args=yes
+
|q?groupBy=_pageName
−
|group by=_pageName
+
|q?limit=999
−
|order by=  
+
|q?orderBy= ElementalTypeId ASC, WeaponTypeId ASC, Rarity DESC, IdLong DESC, FullName ASC
−
    CASE ElementalType
 
−
    WHEN 'Flame' THEN 1
 
−
    WHEN 'Water' THEN 2
 
−
    WHEN 'Wind' THEN 3
 
−
    WHEN 'Light' THEN 4
 
−
    WHEN 'Shadow' THEN 5
 
−
    ELSE 0
 
−
    END ASC,  
 
−
    CASE WeaponType
 
−
    WHEN 'Sword' THEN 1
 
−
    WHEN 'Blade' THEN 2
 
−
    WHEN 'Dagger' THEN 3
 
−
    WHEN 'Axe' THEN 4
 
−
    WHEN 'Lance' THEN 5
 
−
    WHEN 'Bow' THEN 6
 
−
    WHEN 'Wand' THEN 7
 
−
    WHEN 'Staff' THEN 8
 
−
    ELSE 0
 
−
    END ASC,
 
−
    Rarity DESC, Id DESC
 
 
}}
 
}}
 
|}
 
|}
 
</div>
 
</div>
 
</div>
 
</div>

Latest revision as of 00:32, 27 June 2020

Affliction Resistance

">
">
">
">
">
">
">