Difference between revisions of "List of Shareable Skills"

From Dragalia Lost Wiki
Jump to navigation Jump to search
>Boblers
(redirecting template call away from the original sandbox)
>Eave
(use a join query to reduce xref queries to skills table in the entry template)
Line 1: Line 1:
 
<includeonly>
 
<includeonly>
    <div class="table-wrapper">
+
  <div class="table-wrapper">
        {| class="wikitable sortable" style="width:100%"
+
    {| class="wikitable sortable" style="width:100%"
        |-
+
    |-
        ! style="width:10%" | Icon
+
    ! style="width:10%" | Icon
        ! style="width:5%" | Name
+
    ! style="width:5%" | Name
        ! style="width:5%" | Cost
+
    ! style="width:5%" | Cost
        ! style="width:15%" | Shareable Skill
+
    ! style="width:15%" | Shareable Skill
        ! style="width:5%" | SP
+
    ! style="width:5%" | {{Tooltip|SP|SP Cost when used as a shared skill}}
        ! Description
+
    ! Description
        {{#invoke:CargoQuery|main
+
    {{#invoke:CargoQuery|main
    |q?tables=Adventurers
+
      |q?tables=Adventurers,Skills
    |q?fields=_pageName=Link,FullName=Name,ElementalType=Element,Title,WeaponType=Weapon,Rarity,Availability,Id=InternalId,CharaType=Type,VariationId,ReleaseDate,Skill1Name,Skill2Name,EditSkillLevelNum,EditSkillCost
+
      |q?join=Adventurers.EditSkillId=Skills.SkillId
    |q?where=IsPlayable!=0 AND ReleaseDate <= NOW() AND EditSkillLevelNum>0
+
      |q?fields=Adventurers._pageName=Link,FullName=Name,ElementalType,WeaponType,Rarity,Availability,Id=InternalId,CharaType,VariationId,
    |template=SharedSkillTableEntry
+
                Skill1Name,Skill2Name,EditSkillLevelNum,EditSkillCost,
    |q?groupBy=_pageName
+
                Skills.Name=SkillName,Skills._pageName=SkillLink,MaxSkillLevel,
    |q?limit=999
+
                SkillLv1IconName,SkillLv2IconName,SkillLv3IconName,SkillLv4IconName,
    |q?orderBy= ElementalTypeId ASC, WeaponTypeId ASC, Rarity DESC, IdLong DESC, FullName ASC
+
                Description1,Description2,Description3,Description4
    }}
+
      |q?where=IsPlayable!=0 AND ReleaseDate <= NOW() AND EditSkillLevelNum>0
        |}
+
      |template=SharedSkillTableEntry
    </div>
+
      |q?groupBy=Adventurers._pageName
 +
      |q?limit=999
 +
      |q?orderBy= ElementalTypeId ASC, WeaponTypeId ASC, Rarity DESC, IdLong DESC, FullName ASC
 +
      }}
 +
    |}
 +
  </div>
 
</includeonly>
 
</includeonly>
 
<noinclude>
 
<noinclude>

Revision as of 17:18, 25 May 2020