Difference between revisions of "List of Featured Adventurers"

From Dragalia Lost Wiki
Jump to navigation Jump to search
>Mornsta-gpuser
>Mornsta-gpuser
 
(10 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
{{See|[[List of Featured Adventurers]], [[List of Featured Dragons]], [[List of Featured Wyrmprints]]}}
 
{{CharacterListHeader}}
 
{{CharacterListHeader}}
 
{{CharacterListFilter}}
 
{{CharacterListFilter}}
Line 13: Line 14:
 
|q?tables=Adventurers
 
|q?tables=Adventurers
 
|q?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,ExAbilityData5
 
|q?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,ExAbilityData5
−
|q?where= ManaCircleName!="MC_0403" AND ManaCircleName!="MC_0402" AND MaxFriendshipPoint=0
+
|q?where= ManaCircleName!="MC_0403" AND ManaCircleName!="MC_0402" AND MaxFriendshipPoint=0 AND IsPlayable!=0
 
|template=FeaturedCharacterTableEntry
 
|template=FeaturedCharacterTableEntry
 
|q?groupBy=_pageName
 
|q?groupBy=_pageName
 
|q?limit=999
 
|q?limit=999
−
|q?orderBy=  
+
|q?orderBy= ElementalTypeId ASC, WeaponTypeId ASC, Rarity DESC, Id 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>

Latest revision as of 09:11, 27 March 2019

See: List of Featured Adventurers, List of Featured Dragons, List of Featured Wyrmprints

Affliction Resistance

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