Difference between revisions of "Adventurer Detailed List"
Jump to navigation
Jump to search
">
">
>Yvsdrop m (also query addmaxhp/atk1 for new max stat calculations) |
>Eave m (pass through EditSkillId for filtering) |
||
| (15 intermediate revisions by 3 users not shown) | |||
| Line 18: | Line 18: | ||
! Skill 2 | ! Skill 2 | ||
! {{Tooltip|Co-Ability|Ability shown is the max upgraded ability.}} | ! {{Tooltip|Co-Ability|Ability shown is the max upgraded ability.}} | ||
| + | ! {{Tooltip|Chain Co-Ability|Ability shown is the max upgraded ability.}} | ||
! {{Tooltip|Ability 1|Ability shown is the max upgraded ability.}} | ! {{Tooltip|Ability 1|Ability shown is the max upgraded ability.}} | ||
! {{Tooltip|Ability 2|Ability shown is the max upgraded ability.}} | ! {{Tooltip|Ability 2|Ability shown is the max upgraded ability.}} | ||
| Line 26: | Line 27: | ||
{{#invoke:CargoQuery|main | {{#invoke:CargoQuery|main | ||
|q?tables=Adventurers | |q?tables=Adventurers | ||
| − | |q?fields=_pageName=Link,FullName=Name,ElementalType=Element,Title,WeaponType=Weapon,Rarity,Availability,Id=InternalId,CharaType=Type,MaxHp,AddMaxHp1,PlusHp0,PlusHp1,PlusHp2,PlusHp3,PlusHp4,McFullBonusHp5,MaxAtk,AddMaxAtk1,PlusAtk0,PlusAtk1,PlusAtk2,PlusAtk3,PlusAtk4,McFullBonusAtk5,DefCoef,VariationId,ReleaseDate,Obtain,Abilities11,Abilities12,Abilities13,Abilities14,Abilities21,Abilities22,Abilities23,Abilities24,Abilities31,Abilities32,Abilities33,Abilities34,Skill1Name,Skill2Name,ExAbilityData5,MaxLimitBreakCount | + | |q?fields=_pageName=Link,FullName=Name,ElementalType=Element,Title,WeaponType=Weapon,Rarity,Availability,Id=InternalId,CharaType=Type,MaxHp,AddMaxHp1,PlusHp0,PlusHp1,PlusHp2,PlusHp3,PlusHp4,PlusHp5,McFullBonusHp5,MaxAtk,AddMaxAtk1,PlusAtk0,PlusAtk1,PlusAtk2,PlusAtk3,PlusAtk4,PlusAtk5,McFullBonusAtk5,DefCoef,VariationId,ReleaseDate,Obtain,Abilities11,Abilities12,Abilities13,Abilities14,Abilities21,Abilities22,Abilities23,Abilities24,Abilities31,Abilities32,Abilities33,Abilities34,Skill1Name,Skill2Name,ExAbilityData5,ExAbility2Data5,MaxLimitBreakCount,EditSkillId |
|q?where=IsPlayable!=0 AND ReleaseDate <= NOW() | |q?where=IsPlayable!=0 AND ReleaseDate <= NOW() | ||
|template=CharacterDetailedTableEntry | |template=CharacterDetailedTableEntry | ||
|q?groupBy=_pageName | |q?groupBy=_pageName | ||
|q?limit=999 | |q?limit=999 | ||
| − | |q?orderBy= ElementalTypeId ASC, WeaponTypeId ASC, Rarity DESC, | + | |q?orderBy= ElementalTypeId ASC, WeaponTypeId ASC, Rarity DESC, IdLong DESC, FullName ASC |
}} | }} | ||
|} | |} | ||
</div> | </div> | ||
</div> | </div> | ||