Difference between revisions of "List of Featured Dragons"

Latest revision as of 09:11, 27 March 2019

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

Icon	Name	Rarity	Element	Featured In Lua error: Error: Table Dragons not found..

@@ Line 1: / Line 1: @@
+{{See|[[List of Featured Adventurers]], [[List of Featured Dragons]], [[List of Featured Wyrmprints]]}}
 {{DragonListHeader}}
 {{DragonListFilter}}
 {| class="wikitable sortable" style="width:100%"
 |-
@@ Line 11: / Line 11: @@
 {{#invoke:CargoQuery|main
 |q?tables=Dragons
-|q?fields=_pageName=Link,_pageName=Name,Rarity,ElementalType=Element,MaxHp,MaxAtk,BaseId,SkillName,Abilities11,Abilities12,Abilities21,Abilities22,ReleaseDate
+|q?fields=_pageName=Link,FullName=Name,Rarity,ElementalType=Element,MaxHp,MaxAtk,BaseId,SkillName,Abilities11,Abilities12,Abilities21,Abilities22,ReleaseDate
-|q?where=IsPlayable!=0 AND ReleaseDate <= NOW()
+|q?where=Obtain NOT LIKE "%Story%" AND Obtain NOT LIKE "%Event%" AND Obtain NOT LIKE "%Treasure Trade%" AND IsPlayable!=0
 |template=FeaturedDragonTableEntry
 |q?limit=999
-|q?orderBy=
+|q?orderBy= ElementalTypeId 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,
-    Rarity DESC, Id DESC
 |q?groupBy=_pageName
 }}
 |}