USE SRO_VT_SHARD DELETE FROM _TimedJob WHERE CharID = 'ID'
Reset Chines Skill
كود PHP:
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 omarahmed500 -- update _ClientConfig set Data = '0' where CharID = @CharID -- edit by omarahmed500 --
--- Do Not Change Here --- --- made by omarahmed500 for S4a --- 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
Reset EU skill
كود بلغة HTML:
update _ClientConfig
set Data = '0'
where CharID = @CharID
-- edit by omarahmed500 --
--- Do Not Change Here ---
--- made by omarahmed500 for S4a ---
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 all char
كود بلغة HTML:
USE [SRO_VT_SHARD]
GO
--Made by omarahmed500 for silkroad4arab
-- edit by omarahmed500 --
update _ClientConfig
set Data = '0'
-- edit by omarahmed500 --
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'