76561198026315966: Created page with "== Knight Skill Roll Weights == For the Knight class. {{#cargo_query: tables=SkillRollWeight=W, SkillRollTable=T, Translation=Tr | join on=W.table_id=T.id,Tr.target_id=W.skill_id | fields= Tr.name=Skill, CONCAT(SUM(CASE WHEN W.band_kind='default' THEN W.weight ELSE 0 END))=L1, CONCAT(SUM(CASE WHEN W.band_kind='default' THEN W.weight ELSE 0 END))=L2, CONCAT(SUM(CASE WHEN W.band_kind='default' THEN W.weight ELSE 0 END))=L3, CONCAT(..."

2026-05-19T03:15:12Z

Created page with "== Knight Skill Roll Weights == For the Knight class. {{#cargo_query: tables=SkillRollWeight=W, SkillRollTable=T, Translation=Tr | join on=W.table_id=T.id,Tr.target_id=W.skill_id | fields= Tr.name=Skill, CONCAT(SUM(CASE WHEN W.band_kind='default' THEN W.weight ELSE 0 END))=L1, CONCAT(SUM(CASE WHEN W.band_kind='default' THEN W.weight ELSE 0 END))=L2, CONCAT(SUM(CASE WHEN W.band_kind='default' THEN W.weight ELSE 0 END))=L3, CONCAT(..."

New page

== Knight Skill Roll Weights ==

For the [[Knight]] class.

{{#cargo_query:
tables=SkillRollWeight=W, SkillRollTable=T, Translation=Tr
| join on=W.table_id=T.id,Tr.target_id=W.skill_id
| fields=
Tr.name=Skill,
CONCAT(SUM(CASE WHEN W.band_kind='default' THEN W.weight ELSE 0 END))=L1,
CONCAT(SUM(CASE WHEN W.band_kind='default' THEN W.weight ELSE 0 END))=L2,
CONCAT(SUM(CASE WHEN W.band_kind='default' THEN W.weight ELSE 0 END))=L3,
CONCAT(SUM(CASE WHEN W.band_kind='default' OR W.band_kind='magic_levels' THEN W.weight ELSE 0 END))=L4,
CONCAT(SUM(CASE WHEN W.band_kind='default' OR W.band_kind='signature_levels' THEN W.weight ELSE 0 END))=L5,
CONCAT(SUM(CASE WHEN W.band_kind='default' THEN W.weight ELSE 0 END))=L6,
CONCAT(SUM(CASE WHEN W.band_kind='default' THEN W.weight ELSE 0 END))=L7,
CONCAT(SUM(CASE WHEN W.band_kind='default' OR W.band_kind='magic_levels' THEN W.weight ELSE 0 END))=L8,
CONCAT(SUM(CASE WHEN W.band_kind='default' THEN W.weight ELSE 0 END))=L9,
CONCAT(SUM(CASE WHEN W.band_kind='default' OR W.band_kind='signature_levels' THEN W.weight ELSE 0 END))=L10,
CONCAT(SUM(CASE WHEN W.band_kind='default' THEN W.weight ELSE 0 END))=L11,
CONCAT(SUM(CASE WHEN W.band_kind='default' OR W.band_kind='magic_levels' THEN W.weight ELSE 0 END))=L12,
CONCAT(SUM(CASE WHEN W.band_kind='default' THEN W.weight ELSE 0 END))=L13,
CONCAT(SUM(CASE WHEN W.band_kind='default' THEN W.weight ELSE 0 END))=L14,
CONCAT(SUM(CASE WHEN W.band_kind='default' OR W.band_kind='signature_levels' THEN W.weight ELSE 0 END))=L15,
CONCAT(SUM(CASE WHEN W.band_kind='default' OR W.band_kind='magic_levels' THEN W.weight ELSE 0 END))=L16,
CONCAT(SUM(CASE WHEN W.band_kind='default' THEN W.weight ELSE 0 END))=L17,
CONCAT(SUM(CASE WHEN W.band_kind='default' THEN W.weight ELSE 0 END))=L18,
CONCAT(SUM(CASE WHEN W.band_kind='default' THEN W.weight ELSE 0 END))=L19,
CONCAT(SUM(CASE WHEN W.band_kind='default' OR W.band_kind='level_20_mega' THEN W.weight ELSE 0 END))=L20,
CONCAT(SUM(CASE WHEN W.band_kind='default' THEN W.weight ELSE 0 END))=L21,
CONCAT(SUM(CASE WHEN W.band_kind='default' THEN W.weight ELSE 0 END))=L22,
CONCAT(SUM(CASE WHEN W.band_kind='default' THEN W.weight ELSE 0 END))=L23,
CONCAT(SUM(CASE WHEN W.band_kind='default' OR W.band_kind='magic_levels' THEN W.weight ELSE 0 END))=L24,
CONCAT(SUM(CASE WHEN W.band_kind='default' OR W.band_kind='signature_levels' THEN W.weight ELSE 0 END))=L25
| where=
T.class_id="might_human"
AND T.mode="standard"
AND Tr.type="skill"
AND Tr.language="en"
| group by=Tr.name
| order by=Tr.name
| format=table
}}

== Knight Skill Roll Chances ==

Chances that each basic skill shows up in a single slot, for the [[Knight]] class.

{{#cargo_query:
tables=SkillRollWeight=W, SkillRollTable=T, Translation=Tr
| join on=W.table_id=T.id,Tr.target_id=W.skill_id
| fields=
Tr.name=Skill,
CONCAT(ROUND(SUM(CASE WHEN W.band_kind='default' THEN W.weight*100.0/2350.0 ELSE 0 END), 1), '%')=L1,
CONCAT(ROUND(SUM(CASE WHEN W.band_kind='default' THEN W.weight*100.0/2350.0 ELSE 0 END), 1), '%')=L2,
CONCAT(ROUND(SUM(CASE WHEN W.band_kind='default' THEN W.weight*100.0/2350.0 ELSE 0 END), 1), '%')=L3,
CONCAT(ROUND(SUM(CASE WHEN W.band_kind='default' OR W.band_kind='magic_levels' THEN W.weight*100.0/2550.0 ELSE 0 END), 1), '%')=L4,
CONCAT(ROUND(SUM(CASE WHEN W.band_kind='default' OR W.band_kind='signature_levels' THEN W.weight*100.0/2550.0 ELSE 0 END), 1), '%')=L5,
CONCAT(ROUND(SUM(CASE WHEN W.band_kind='default' THEN W.weight*100.0/2350.0 ELSE 0 END), 1), '%')=L6,
CONCAT(ROUND(SUM(CASE WHEN W.band_kind='default' THEN W.weight*100.0/2350.0 ELSE 0 END), 1), '%')=L7,
CONCAT(ROUND(SUM(CASE WHEN W.band_kind='default' OR W.band_kind='magic_levels' THEN W.weight*100.0/2550.0 ELSE 0 END), 1), '%')=L8,
CONCAT(ROUND(SUM(CASE WHEN W.band_kind='default' THEN W.weight*100.0/2350.0 ELSE 0 END), 1), '%')=L9,
CONCAT(ROUND(SUM(CASE WHEN W.band_kind='default' OR W.band_kind='signature_levels' THEN W.weight*100.0/2550.0 ELSE 0 END), 1), '%')=L10,
CONCAT(ROUND(SUM(CASE WHEN W.band_kind='default' THEN W.weight*100.0/2350.0 ELSE 0 END), 1), '%')=L11,
CONCAT(ROUND(SUM(CASE WHEN W.band_kind='default' OR W.band_kind='magic_levels' THEN W.weight*100.0/2550.0 ELSE 0 END), 1), '%')=L12,
CONCAT(ROUND(SUM(CASE WHEN W.band_kind='default' THEN W.weight*100.0/2350.0 ELSE 0 END), 1), '%')=L13,
CONCAT(ROUND(SUM(CASE WHEN W.band_kind='default' THEN W.weight*100.0/2350.0 ELSE 0 END), 1), '%')=L14,
CONCAT(ROUND(SUM(CASE WHEN W.band_kind='default' OR W.band_kind='signature_levels' THEN W.weight*100.0/2550.0 ELSE 0 END), 1), '%')=L15,
CONCAT(ROUND(SUM(CASE WHEN W.band_kind='default' OR W.band_kind='magic_levels' THEN W.weight*100.0/2550.0 ELSE 0 END), 1), '%')=L16,
CONCAT(ROUND(SUM(CASE WHEN W.band_kind='default' THEN W.weight*100.0/2350.0 ELSE 0 END), 1), '%')=L17,
CONCAT(ROUND(SUM(CASE WHEN W.band_kind='default' THEN W.weight*100.0/2350.0 ELSE 0 END), 1), '%')=L18,
CONCAT(ROUND(SUM(CASE WHEN W.band_kind='default' THEN W.weight*100.0/2350.0 ELSE 0 END), 1), '%')=L19,
CONCAT(ROUND(SUM(CASE WHEN W.band_kind='default' OR W.band_kind='level_20_mega' THEN W.weight*100.0/2950.0 ELSE 0 END), 1), '%')=L20,
CONCAT(ROUND(SUM(CASE WHEN W.band_kind='default' THEN W.weight*100.0/2350.0 ELSE 0 END), 1), '%')=L21,
CONCAT(ROUND(SUM(CASE WHEN W.band_kind='default' THEN W.weight*100.0/2350.0 ELSE 0 END), 1), '%')=L22,
CONCAT(ROUND(SUM(CASE WHEN W.band_kind='default' THEN W.weight*100.0/2350.0 ELSE 0 END), 1), '%')=L23,
CONCAT(ROUND(SUM(CASE WHEN W.band_kind='default' OR W.band_kind='magic_levels' THEN W.weight*100.0/2550.0 ELSE 0 END), 1), '%')=L24,
CONCAT(ROUND(SUM(CASE WHEN W.band_kind='default' OR W.band_kind='signature_levels' THEN W.weight*100.0/2550.0 ELSE 0 END), 1), '%')=L25
| where=
T.class_id="might_human"
AND T.mode="standard"
AND Tr.type="skill"
AND Tr.language="en"
| group by=Tr.name
| order by=Tr.name
| format=table
}}

== Sums ==

A proper template would probably have this and reference it rather than hard-code it in the previous table:

{{#cargo_query:
tables=SkillRollWeight=W, SkillRollTable=T
| join on=W.table_id=T.id
| fields=
CONCAT(SUM(CASE WHEN W.band_kind='default' THEN W.weight ELSE 0 END))=Default_total,
CONCAT(SUM(CASE WHEN W.band_kind='default' OR W.band_kind='magic_levels' THEN W.weight ELSE 0 END))=Magic_total,
CONCAT(SUM(CASE WHEN W.band_kind='default' OR W.band_kind='signature_levels' THEN W.weight ELSE 0 END))=Signature_total,
CONCAT(SUM(CASE WHEN W.band_kind='default' OR W.band_kind='level_20_mega' THEN W.weight ELSE 0 END))=L20_total
| where=T.class_id="might_human" AND T.mode="standard"
}}

User:76561198026315966/SkillRolls - Revision history