Difference between revisions of "List of Shareable Skills"

From Dragalia Lost Wiki
Jump to navigation Jump to search
>Eave
(remove fields that are no longer necessary with the join)
>Eave
(add class to table for styling)
Line 1: Line 1:
<includeonly>
+
<includeonly>{{#widget:Template/SharedSkillTable/css}}
  <div class="table-wrapper">
+
{| class="shared-skill-table wikitable sortable" style="width:100%"
    {| class="wikitable sortable" style="width:100%"
+
|-
    |-
+
! Icon
    ! Icon
+
! style="width:10%" | Name
    ! style="width:10%" | Name
+
! Cost
    ! Cost
+
! style="width:15%" | Shareable Skill
    ! style="width:15%" | Shareable Skill
+
! {{Tooltip|SP|SP Cost when used as a shared skill}}
    ! {{Tooltip|SP|SP Cost when used as a shared skill}}
+
! Description
    ! Description
+
{{#invoke:CargoQuery|main
    {{#invoke:CargoQuery|main
+
  |q?tables=Adventurers,Skills
      |q?tables=Adventurers,Skills
+
  |q?join=Adventurers.EditSkillId=Skills.SkillId
      |q?join=Adventurers.EditSkillId=Skills.SkillId
+
  |q?fields=Adventurers._pageName=Link,FullName=Name,ElementalType,WeaponType,Rarity,Availability,Id=InternalId,CharaType,VariationId,EditSkillCost,
      |q?fields=Adventurers._pageName=Link,FullName=Name,ElementalType,WeaponType,Rarity,Availability,Id=InternalId,CharaType,VariationId,EditSkillCost,
+
            Skills.Name=SkillName,Skills._pageName=SkillLink,MaxSkillLevel,SpLv4Edit,
                Skills.Name=SkillName,Skills._pageName=SkillLink,MaxSkillLevel,SpLv4Edit,
+
            SkillLv1IconName,SkillLv2IconName,SkillLv3IconName,SkillLv4IconName,
                SkillLv1IconName,SkillLv2IconName,SkillLv3IconName,SkillLv4IconName,
+
            Description1,Description2,Description3,Description4
                Description1,Description2,Description3,Description4
+
  |q?where=IsPlayable!=0 AND ReleaseDate <= NOW() AND EditSkillLevelNum>0
      |q?where=IsPlayable!=0 AND ReleaseDate <= NOW() AND EditSkillLevelNum>0
+
  |template=SharedSkillTableEntry
      |template=SharedSkillTableEntry
+
  |q?groupBy=Adventurers._pageName
      |q?groupBy=Adventurers._pageName
+
  |q?limit=999
      |q?limit=999
+
  |q?orderBy= ElementalTypeId ASC, WeaponTypeId ASC, Rarity DESC, IdLong DESC, FullName ASC
      |q?orderBy= ElementalTypeId ASC, WeaponTypeId ASC, Rarity DESC, IdLong DESC, FullName ASC
+
  }}
      }}
+
|}<!--
    |}
+
--></includeonly><noinclude>
  </div>
 
</includeonly>
 
<noinclude>
 
 
[[Category:Templates]]
 
[[Category:Templates]]
 
{{SharedSkillTable}}
 
{{SharedSkillTable}}
 
</noinclude>
 
</noinclude>

Revision as of 17:52, 25 May 2020