Difference between revisions of "User:Mornsta/PageGenerator"

Revision as of 14:11, 25 February 2019

Name	Showcased in	Dragons Voiced Error: Table Adventurers not found.

@@ Line 1: / Line 1: @@
 {| class="wikitable sortable"
-! Name || Characters Voiced || Dragons Voiced
+! Name || Showcased in || Dragons Voiced
-{{#cargo_compound_query:
+{{#cargo_query:
-tables=Adventurers;fields=FullName
+tables=Adventurers
+|fields=FullName
 |format=template
 |template=Test
+|order by=
+    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
 }}
 |}