Spare

Machine Man
.
.
Katılım
28 May 2018
Mesajlar
2,982
Tepkime puanı
3,116
Puanları
605
Yaş
26
Konum
İstanbul
Kredi
77.73[TL]
vsro
Skillerden dolayı bugta kalma veya Skill sıfırlama olmayan serverlerde bu query sayesinde skill sıfırlayabilirsiniz.

Sadece CH karakter ve Char Adı girerek;
Kod:
USE SRO_VT_SHARDDECLARE @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 Spare VSROBiz --
update _ClientConfig
set Data = '0'
where CharID = @charID
-- edit by Spare VSROBiz --

--- Do Not Change Here ---
--- made by Spare for VSROBiz ---
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

Sadece EU karakter ve Char adı girerek;
Kod:
USE SRO_VT_SHARDDECLARE @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 Spare VSROBiz --
update _ClientConfig
set Data = '0'
where CharID = @charID
-- edit by Spare VSROBiz --

--- Do Not Change Here ---
--- made by Spare vsrobiz  ---
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

Bütün karakterler skill sıfırlama!
Kod:
USE [SRO_VT_SHARD]
GO
--Made by Spare for VSROBiz

-- edit by Spare vsrobiz --
update _ClientConfig
set Data = '0'
-- edit by Spare vsrobiz --

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'
 
Üst