urgent case i need to remove vip skills from all players

[ali2008x]

urgent case please i need to remove vip skills from all players

[mudik]

_CharSkillMastary

[Hercules*]

Wrong Section .

[JohnDornel^]

It's a wrong section but you need to get the skill ids from _RefSkill table of all your VIP skills and simply do a

delete from _CharSkill WHERE SkillID IN (1,2,3,4...all ids)

[Hercules*]

Originally Posted by JohnDornel^

It's a wrong section but you need to get the skill ids from _RefSkill table of all your VIP skills and simply do a

delete from _CharSkill WHERE SkillID IN (1,2,3,4...all ids)

SO WE CAN DO IT BY THIS QUERY

DELETE FROM _CHARSKILL WHERE SKILLID IN (SELECT SKILLID FROM _REFSKILL WHERE BASIC_CODE LIKE '%VIP_SKILL%') -- 80% FROM SKILL -----CODE THAT SAME AT ALL SKILLS

[ali2008x]

Originally Posted by Hercules*

SO WE CAN DO IT BY THIS QUERY

DELETE FROM _CHARSKILL WHERE SKILLID IN (SELECT SKILLID FROM _REFSKILL WHERE BASIC_CODE LIKE '%VIP_SKILL%') -- 80% FROM SKILL -----CODE THAT SAME AT ALL SKILLS

im so sorry i dont know what is right section thx to you all i when i try i get

(0 row(s) affected)

[ZαKuRα]

Originally Posted by ali2008x

im so sorry i dont know what is right section thx to you all i when i try i get

(0 row(s) affected)

look for the name assigned to the skill in the group and look it up with query

[NESTA3!!]

Use the query Rest Skill from all players

USE [SRO_VT_SHARD]
GO
--Made by ModGift

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

if You Need Rest Skill from by CharName Use the query


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 Eur

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 ---
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

[Hercules*]

Originally Posted by NESTA3!!

Use the query Rest Skill from all players




if You Need Rest Skill from by CharName Use the query


for CH



___

for Eur

First you need those steps
1st- try to read the thread
2nd- think
3rd- comment

He need to remove Specific MASTERY SKILLS
NOT RESET ALL MASTERY SKILLS FOR ALL PLAYERS