How To Synchronize skill_proto ( Server <> Client )

[VegaS™ 9977]

M2 Download Center

This is the hidden content, please

• Sign In
• or
• Sign Up

( Internal )

 

As the title says, here's how you can synchronize your skill_table from client with skill_proto from server.

[1]. First of all we've to rewrite the enum part of tokens (which is used in CPythonSkill::RegisterSkillTable), that means we change the order of index-tab-line with a new order, because ymir didn't used all columns. In that way we keep the file much cleaner and just with necessary columns (9 columns instead of 27).

Spoiler

// Not used
TABLE_TOKEN_TYPE_NAME
TABLE_TOKEN_TYPE_TYPE
TABLE_TOKEN_TYPE_LEVEL_STEP
TABLE_TOKEN_TYPE_POINT_ON
TABLE_TOKEN_TYPE_MASTER_BONUS_POLY
TABLE_TOKEN_TYPE_ATTACK_GRADE_POLY
TABLE_TOKEN_TYPE_FLAG
TABLE_TOKEN_TYPE_AFFECT_FLAG
TABLE_TOKEN_TYPE_POINT_ON2
TABLE_TOKEN_TYPE_POINT_POLY2
TABLE_TOKEN_TYPE_DURATION_POLY2
TABLE_TOKEN_TYPE_AFFECT_FLAG2
TABLE_TOKEN_TYPE_PREREQUISITE_SKILL_VNUM
TABLE_TOKEN_TYPE_PREREQUISITE_SKILL_LEVEL
TABLE_TOKEN_TYPE_SKILL_TYPE
TABLE_TOKEN_TYPE_MAX_HIT
TABLE_TOKEN_TYPE_SPLASH_AROUND_DAMAGE_ADJUST_POLY
TABLE_TOKEN_TYPE_SPLASH_RANGE

 

Srcs/Client/UserInterface/PythonSkill.h

Search for the next enum:

Spoiler

		enum ESkillTableTokenType
		{
			[...]
		};

 

Replace it with:

Spoiler

#ifdef ENABLE_SKILL_TABLE_RENEW
		enum ESkillTableTokenType
		{
			TABLE_TOKEN_TYPE_VNUM,
			TABLE_TOKEN_TYPE_MAX_LEVEL,
			TABLE_TOKEN_TYPE_LEVEL_LIMIT,
			TABLE_TOKEN_TYPE_POINT_POLY,
			TABLE_TOKEN_TYPE_SP_COST_POLY,
			TABLE_TOKEN_TYPE_DURATION_POLY,
			TABLE_TOKEN_TYPE_DURATION_SP_COST_POLY,
			TABLE_TOKEN_TYPE_COOLDOWN_POLY,
			TABLE_TOKEN_TYPE_TARGET_RANGE,
			TABLE_TOKEN_TYPE_MAX_NUM,
		};
#else
		enum ESkillTableTokenType
		{
			TABLE_TOKEN_TYPE_VNUM,
			TABLE_TOKEN_TYPE_NAME,
			TABLE_TOKEN_TYPE_TYPE,
			TABLE_TOKEN_TYPE_LEVEL_STEP,
			TABLE_TOKEN_TYPE_MAX_LEVEL,
			TABLE_TOKEN_TYPE_LEVEL_LIMIT,
			TABLE_TOKEN_TYPE_POINT_ON,
			TABLE_TOKEN_TYPE_POINT_POLY,
			TABLE_TOKEN_TYPE_SP_COST_POLY,
			TABLE_TOKEN_TYPE_DURATION_POLY,
			TABLE_TOKEN_TYPE_DURATION_SP_COST_POLY,
			TABLE_TOKEN_TYPE_COOLDOWN_POLY,
			TABLE_TOKEN_TYPE_MASTER_BONUS_POLY,
			TABLE_TOKEN_TYPE_ATTACK_GRADE_POLY,
			TABLE_TOKEN_TYPE_FLAG,
			TABLE_TOKEN_TYPE_AFFECT_FLAG,
			TABLE_TOKEN_TYPE_POINT_ON2,
			TABLE_TOKEN_TYPE_POINT_POLY2,
			TABLE_TOKEN_TYPE_DURATION_POLY2,
			TABLE_TOKEN_TYPE_AFFECT_FLAG2,
			TABLE_TOKEN_TYPE_PREREQUISITE_SKILL_VNUM,
			TABLE_TOKEN_TYPE_PREREQUISITE_SKILL_LEVEL,
			TABLE_TOKEN_TYPE_SKILL_TYPE,
			TABLE_TOKEN_TYPE_MAX_HIT,
			TABLE_TOKEN_TYPE_SPLASH_AROUND_DAMAGE_ADJUST_POLY,
			TABLE_TOKEN_TYPE_TARGET_RANGE,
			TABLE_TOKEN_TYPE_SPLASH_RANGE,
			TABLE_TOKEN_TYPE_MAX_NUM,
		};
#endif

 

Srcs/Client/UserInterface/Locale_Inc.h

Spoiler

#define ENABLE_SKILL_TABLE_RENEW // Enable synchronization skill_proto -> skilltable

 

 

[2]. Compile the source client again.

[3]. Open Navicat (preferably the latest versions) and do the following things:

• Open player table
• Export Wizard -> Mark skill_proto -> Export to ../location/skilltable.txt
• Export format -> *.txt
• Unmark All fields then Unselect All
• Select available fields: -> {'dwVnum', 'bMaxLevel', 'bLevelLimit', 'szPointPoly', 'szSPCostPoly', 'szDurationPoly', 'szDurationSPCostPoly', 'szCooldownPoly', 'dwTargetRange'}
• Unmark: Include column titles
• Text Qualifier: None
• Copy the skilltable.txt from Desktop to ../locale/en/

 

HOW-TO - VIDEO (The video is just an example, please follow the tutorial from step [3])

This is the hidden content, please

• Sign In
• or
• Sign Up

 

 

Thanks to @Syreldar for the idea.

Edited August 27, 2022 by Metin2 Dev
Core X - External 2 Internal

[Syreldar 1816]

When you do nothing but still get mentioned in the "Thanks to" by @VegaS™

 

Edited August 25, 2022 by Metin2 Dev
Core X - External 2 Internal

[redbull06 14]

Thanks @VegaS™

[WeedHex 626]

Secrets of long ago thanks boss.

[weryoliveira 22]

can't use skill after make this

[AltanOzkan 16]

Is there anyway to convert official skill_proto.txt to sql for server ? 
Thank you. 

[nazox 210]

Thanks vegas, but not working skills

[nazox 210]

@VegaS™i need edit something in source game? 

[Ravenous 1]

thanks

[Hik 105]

Attention, I believe the skilltable_new is wrong, I think a column is missing.

[VegaS™ 9977]

On 7/28/2021 at 2:20 PM, Hik said:

Attention, I believe the skilltable_new is wrong, I think a column is missing.

You are right, I helped some people with this problem in PM but I forgot to edit the topic.

Update: For those who know what they're doing, I did a small script that doing this faster, otherwise, use the manual method from the first post.

This is the hidden content, please

• Sign In
• or
• Sign Up

Edited December 7, 2021 by VegaS™

[Karbust 4729]

If anyone gets an error like this:

Traceback (most recent call last):
  File "C:\Users\Karbust\Desktop\skill_proto.py", line 26, in <module>
    int(query['dwVnum']): '\t'.join(
TypeError: sequence item 0: expected str instance, int found

Just edit this:

Wrap the columnValue in str().

Edited August 17, 2022 by Metin2 Dev
Core X - External 2 Internal

[DemOnJR 520]

I leave this for peoples that get: 

UnicodeDecodeError: 'utf-8' codec can't decode byte 0xe0 in position 5285: invalid continuation byte

 

#!/usr/bin/env python
# -*- coding: utf-8 -*-
__name__ = "Skill Proto Synchronization"
__author__ = "VegaS"
__date__ = "2020-10-14"
__version__ = "1.0"

import os
import json

# Set working directory
os.chdir(os.path.dirname(os.path.realpath(__file__)))

# Skill proto file name, exported from MySQL.
SKILL_PROTO_FILE_NAME: str = 'skill_proto.json'
SKILL_PROTO_READ_COLUMNS: set[str] = {'dwVnum', 'bMaxLevel', 'bLevelLimit', 'szPointPoly', 'szSPCostPoly', 'szDurationPoly', 'szDurationSPCostPoly', 'szCooldownPoly', 'dwTargetRange'}

# Skill table file name.
SKILL_TABLE_FILE_NAME: str = 'skilltable.txt'
SKILL_TABLE_CONTENT: dict[int, str] = {}

with open(SKILL_PROTO_FILE_NAME, encoding="utf-8", errors="replace") as jsonFile:
    skillProtoContent: dict = json.load(jsonFile)
    for query in skillProtoContent['RECORDS']:
        SKILL_TABLE_CONTENT.update({
            int(query['dwVnum']): '\t'.join(
                [str(columnValue) if isinstance(columnValue, (str, int)) else str() for columnName, columnValue in query.items() if columnName in SKILL_PROTO_READ_COLUMNS])
        })

with open(SKILL_TABLE_FILE_NAME, 'w') as skillTableFile:
    skillTableFile.write('\n'.join(list(dict(sorted(SKILL_TABLE_CONTENT.items())).values())))

 

Edited July 6, 2023 by DemOnJR