Difference between revisions of "User:FabulousCupcake/Skill by SP"
Jump to navigation
Jump to search
>FabulousCupcake |
>FabulousCupcake (thonk) |
||
| (10 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | __TOC__ | ||
| + | |||
| + | == 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 | + | |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 | ||
}} | }} | ||
| − | [[File: | + | <hr /> |
| + | |||
| + | == Adventurer Skill 2 sorted by SP Cost == | ||
| + | {{#cargo_query: | ||
| + | tables=Skills=s,Adventurers=a | ||
| + | |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 | ||
| + | |order by=s.Sp DESC | ||
| + | |limit=30 | ||
| + | |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.