Difference between revisions of "User:FabulousCupcake/Skill by SP"
Jump to navigation
Jump to search
>FabulousCupcake |
>FabulousCupcake (thonk) |
||
| (8 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | __TOC__ | ||
| + | |||
== Adventurer Skill 1 sorted by SP Cost == | == Adventurer Skill 1 sorted by SP Cost == | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Skills=s,Adventurers=a | tables=Skills=s,Adventurers=a | ||
|join on=s.Name=a.Skill1Name | |join on=s.Name=a.Skill1Name | ||
| − | | | + | |where=s.Name=a.Skill1Name |
|fields=CONCAT('<center>[[File:', s.SkillLv1IconName, '.png|40px]]</center>')=Icon, s._pageName=Page, s.Sp=SP | |fields=CONCAT('<center>[[File:', s.SkillLv1IconName, '.png|40px]]</center>')=Icon, s._pageName=Page, s.Sp=SP | ||
|order by=s.Sp DESC | |order by=s.Sp DESC | ||
| − | |limit= | + | |limit=30 |
|format=dynamic table | |format=dynamic table | ||
}} | }} | ||
| + | |||
| + | <hr /> | ||
== Adventurer Skill 2 sorted by SP Cost == | == Adventurer Skill 2 sorted by SP Cost == | ||
| Line 14: | Line 18: | ||
tables=Skills=s,Adventurers=a | tables=Skills=s,Adventurers=a | ||
|join on=s.Name=a.Skill2Name | |join on=s.Name=a.Skill2Name | ||
| − | | | + | |where=s.Name=a.Skill2Name |
|fields=CONCAT('<center>[[File:', s.SkillLv2IconName, '.png|40px]]</center>')=Icon, s._pageName=Page, s.Sp=SP | |fields=CONCAT('<center>[[File:', s.SkillLv2IconName, '.png|40px]]</center>')=Icon, s._pageName=Page, s.Sp=SP | ||
|order by=s.Sp DESC | |order by=s.Sp DESC | ||
| − | |limit= | + | |limit=30 |
|format=dynamic table | |format=dynamic table | ||
}} | }} | ||
Latest revision as of 06:45, 31 August 2019
Adventurer Skill 1 sorted by SP Cost
Error: Table Skills not found.
Adventurer Skill 2 sorted by SP Cost
Error: Table Skills not found.