USE SRO_VT_SHARD DECLARE @charname varchar (64) DECLARE @charID int DECLARE @GiveSP int SET @charname = 'Covid_19' --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