الـجـروب الـخـاص بـالـمـنـتـدي Silkroad4arab Facebook | Official Group 

SET @CharName = 'CharName' --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 omarahmed500 -- 
update _ClientConfig 
set Data = '0' 
where CharID = @CharID 
-- edit by omarahmed500 -- 

--- Do Not Change Here --- 
--- made by omarahmed500 for S4a --- 
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 
GO

USE SRO_VT_SHARD
DECLARE @CharName varchar (64)
DECLARE  @CharID int
DECLARE @GiveSP int
SET @CharName = 'CharName' --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 InPanic Kev --
update _ClientConfig
set Data = '0'
where CharID = @CharID
-- edit by InPanic Kev --

--- Do Not Change Here ---
--- made by ModGift for RZ  ---
DELETE [dbo].[_CharSkill]
   WHERE [CharID] = @CharID and [SkillID] > '2'

INSERT INTO [dbo].[_CharSkill]
           ([CharID]
           ,[SkillID]
           ,[Enable])
     VALUES
           (@CharID
           ,'8421'
           ,'1')
INSERT INTO [dbo].[_CharSkill]
           ([CharID]
           ,[SkillID]
           ,[Enable])
     VALUES
           (@CharID
		   ,'8419'
           ,'1')

INSERT INTO [dbo].[_CharSkill]
           ([CharID]
           ,[SkillID]
           ,[Enable])
     VALUES
           (@CharID,
           '8420'
           ,'1')

INSERT INTO [dbo].[_CharSkill]
           ([CharID]
           ,[SkillID]
           ,[Enable])
     VALUES
           (@CharID,
           '9354'
           ,'1')

INSERT INTO [dbo].[_CharSkill]
           ([CharID]
           ,[SkillID]
           ,[Enable])
     VALUES
           (@CharID,
           '9355'
           ,'1')

INSERT INTO [dbo].[_CharSkill]
           ([CharID]
           ,[SkillID]
           ,[Enable])
     VALUES
           (@CharID,
           '9944'
           ,'1')
INSERT INTO [dbo].[_CharSkill]
           ([CharID]
           ,[SkillID]
           ,[Enable])
     VALUES
           (@CharID,
           '10625'
           ,'1')
INSERT INTO [dbo].[_CharSkill]
           ([CharID]
           ,[SkillID]
           ,[Enable])
     VALUES
           (@CharID,
           '11162'
           ,'1')
INSERT INTO [dbo].[_CharSkill]
           ([CharID]
           ,[SkillID]
           ,[Enable])
     VALUES
           (@CharID,
           '11526'
           ,'1')
UPDATE [dbo].[_CharSkillMastery]
   SET 
      [Level] = '0'
 WHERE CharID= @CharID
UPDATE [dbo].[_Char]
  SET RemainSkillPoint= @GiveSP
  WHERE CharName16 = @CharName
GO

USE SRO_VT_SHARD
DELETE FROM _TimedJob WHERE CharID = 'CharID'