Paylaşım vsro karakter skill sifirlama Quary

[alikvp]

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