Bilgi Vꜱʀᴏ Kᴀʀᴀᴋᴛᴇʀ Sᴋɪʟʟ Sɪғɪʀʟᴀᴍᴀ Qᴜᴀʀʏ

[Can VAROL]

USE SRO_VT_SHARD
DECLARE @charname varchar (64)
DECLARE @charID int
DECLARE @GiveSP int
SET @charname = 'CHAR ISMINI BURAYA YAZINIZ' --Your Char Name
SET @GiveSP = '10000000' --Write the amount of Skill Point
SET @charID = (SELECT CharID FROM _Char WHERE CharName16 = @charname) --Do not change

-- edit by MaxGame.org --
update _ClientConfig
set Data = '0'
where CharID = @charID
-- edit by MaxGame.org --

--- Do Not Change Here ---
-- edit by MaxGame.org --
DELETE [dbo].[_CharSkill]
WHERE [CharID] = @charID and [SkillID] > '2' and SkillID<'40'

DELETE [dbo].[_CharSkill]
WHERE [CharID] = @charID and [SkillID] > '40' and SkillID<'70'

DELETE [dbo].[_CharSkill]
WHERE [CharID] = @charID and [SkillID] > '70'

UPDATE [dbo].[_CharSkillMastery]
SET
[Level] = '0'
WHERE CharID= @charID

UPDATE [dbo].[_Char]
SET RemainSkillPoint= @GiveSP
WHERE CharName16 = @charname