Need a Query to new chars wich setup MASTERY LVL all class at max.

01/09/2016 02:54 szokersonik#1
Hi guys. I will appreciate if some1 write here a query to SRO_VT_SHARD to Programability To StoreProcedures to _AddNewChar, what i mean i need something like that: I Created a new char and he is at all class from the beggining at MAX LVL -> example bicheon 120/heuksal120 /pacheon 120lvl/fire120lvl/ice120lvl/light120lvl/force120lvl. Ofc my starting chars are setup to 120lvl instant btw so i guess i wont be any conflicts between Char lvl 120 and all classes/skills 120.

ps. Anyway i tryed to change Max Mastery Level Limit to 720 for EU in sro_client.exe and gameserver by Ollyodbg , but this not working for EU , but for Chinese works well i used this [Only registered and activated users can see links. Click Here To Register...] and i changed CHinese Max Mastery Level limit to 840 and its working(randomly graphic bug shows up something like that 840/360, but usually is 840/840)

Thx for any help.
01/09/2016 08:52 magicanoo#2
In _AddNewChar, look for the part where rows are inserted into _CharSkillMastery.. Change the zero to 120.

Code:
INSERT INTO _CharSkillMastery (CharID, MasteryID, Level)        
	SELECT @NewCharID, MasteryID, 0        
	FROM _RefCharDefault_SkillMastery  with(nolock)      
	WHERE Race = @country or Race = 3
01/09/2016 14:00 szokersonik#3
Quote:
Originally Posted by magicanoo View Post
In _AddNewChar, look for the part where rows are inserted into _CharSkillMastery.. Change the zero to 120.

Code:
INSERT INTO _CharSkillMastery (CharID, MasteryID, Level)        
	SELECT @NewCharID, MasteryID, 0        
	FROM _RefCharDefault_SkillMastery  with(nolock)      
	WHERE Race = @country or Race = 3

:handsdown:BIG THANKS :* <3 :) its working :) :handsdown: