Difference between revisions of "Weapon List"
Jump to navigation
Jump to search
>Mornsta-gpuser |
>Mornsta-gpuser |
||
| Line 22: | Line 22: | ||
|named args=yes | |named args=yes | ||
|group by=_pageName | |group by=_pageName | ||
| − | |order by= | + | |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 6 | ||
| + | END ASC, | ||
| + | CASE Type | ||
| + | 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 | ||
|limit=300 | |limit=300 | ||
}} | }} | ||
| Line 50: | Line 70: | ||
|named args=yes | |named args=yes | ||
|group by=_pageName | |group by=_pageName | ||
| − | |order by= | + | |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 6 | ||
| + | END ASC, | ||
| + | CASE Type | ||
| + | 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 | ||
|limit=300 | |limit=300 | ||
}} | }} | ||