SQL] Query to Reset Player Skill By HaMoELMJRM]

MR-DIABLO

MR-DIABLO

[SQL] Query to Reset Player Skill
For CH
​
كود: 
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' 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

For EU​
كود: 
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
For Reset All Char
​
كود: 
USE [SRO_VT_SHARD]
GO
--Made by ModGift for RaGeZoNe

-- edit by InPanic Kev --
update _ClientConfig
set Data = '0'
-- 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'
 
يجب تسجيل الدخول أو التسجيل كي تتمكن من الرد هنا.
عودة
أعلى