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

Konuyu başlatan #1
Katılım
29 Ocak 2016
Mesajlar
296
Beğeniler
3
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