vSRO Bütün Karakterlerin Skillerini Sıfırlama Query

Katılım
29 Ocak 2016
Mesajlar
296
Puanları
18
Yaş
20
Konum
İZMİR
Kod:
USE [SRO_VT_SHARD] 
GO 
update _ClientConfig 
set Data = '0' 
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' 


--- 
UPDATE [dbo].[_Char] 
  SET RemainSkillPoint = RemainSkillPoint + @GiveSP 
  WHERE CharName16 = @CharName
Shard a Excute Ediniz :)
 
Üst