[SQL] Query to Reset Player Skill

[xxNukertube]

for Reset All Char;

Dont Reset Client DATA

:S

Any Can help me ?

 

[ModGift]

for Reset All Char;

Dont Reset Client DATA

:S

Any Can help me ?

Updated. GL

USE [SRO_VT_SHARD]
GO
--Made by ModGift for RaGeZoNe 

-- edit by InPanic Kev --
update _ClientConfig
set Data = '0'
where CharID = @CharID
-- edit by InPanic Kev --

DELETE FROM [dbo].[_CharSkill]
      WHERE  SKillID NOT LIKE '1' and  SKillID NOT LIKE '2' and  SKillID NOT LIKE '40'
	  and  SKillID NOT LIKE '70' and  SKillID NOT LIKE '8421' and  SKillID NOT LIKE '8419'
	  and  SKillID NOT LIKE '8420' and  SKillID NOT LIKE '9354' and  SKillID NOT LIKE '9355'
	  and  SKillID NOT LIKE '9944' and  SKillID NOT LIKE '10625' and  SKillID NOT LIKE '11162'
	  and  SKillID NOT LIKE '11526'
GO 

UPDATE [dbo].[_CharSkillMastery]
   SET 
      [Level] = '0'