[HIDE]
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)
update _ClientConfig
set Data = '0'
where CharID = @charID
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
[/HIDE]
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)
update _ClientConfig
set Data = '0'
where CharID = @charID
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
[/HIDE]
