If you want to look for the current highest mastery counter for a specific mastery inside your database (row, column and level wise), match your current "skilldata_xxxxxenc.txt" with _RefSkill, execute the following query and match the row counter at skillmasterydata.txt as well:
PHP Code:
USE SRO_VT_SHARD
SELECT Service, ID, Basic_Code, Basic_Level, UI_SkillTab, UI_SkillPage, UI_SkillColumn, UI_SkillRow, UI_IconFile FROM _RefSkill
WHERE UI_SkillColumn >= 0
AND Service = 1
AND Basic_Code LIKE 'SKILL_CH_SWORD_%'
-- SKILL_CH_SWORD_ SKILL_CH_SPEAR_ SKILL_CH_BOW_ SKILL_CH_COLD_ SKILL_CH_LIGHTNING_ SKILL_CH_FIRE_ SKILL_CH_WATER_
--
-- SKILL_EU_WARRIOR_ SKILL_EU_ROG_ SKILL_EU_WIZARD_ SKILL_EU_WARLOCK_ SKILL_EU_BARD_ SKILL_EU_CLERIC_
AND NOT UI_SkillColumn = 255
ORDER BY UI_SkillColumn DESC
Just replace the part with "SKILL_CH_SWORD_" with the mastery you want to check on.
