طلب

[merazz012]

عايز الProsedür صح بتاع reset stats and reset skill`s and remove premium?

[komnda]

عاوز تمسح البرميم من اى حد
USE SRO_VT_SHARD
DELETE FROM _TimedJob WHERE CharID = 'ID'

Reset Chines Skill
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
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

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'

[merazz012]

يا باشا انا قصدي prosedür بتاع الscrolls :] :] مش دي

اللي هيا scroll remove premium scroll reset stats ........ انا عايز الprosedü اللي هو addtimedjob

[komnda]

اه معلش مختش بالى اتفضل هتتشال من كلو
if(@JobID= '10000')
begin
DECLARE @CharName Varchar (64)
declare @ID INT
SET @CharID = (Select CharID FROM _Char Where CharName16 = @CharName) DELETE FROM _TimedJob WHERE CharID = @CharID
DELETE FROM _TimedJob WHERE Category = '5' OR Category = '3' OR Category = '0'
end
وشوف الفيديو ده عشان تتشال من char

http://www.youtube.com/watch?v=El5wP...ature=youtu.be
وشوف د ه
http://www.silkroad4arab.com/vb/showthread.php?p=5048652

[merazz012]

تمام باقي بس الREMOVE skills

[komnda]

ال state بس مش متأكد
if(@JobID = '45001')
begin
declare @Strength int
declare @Intellect int
declare @MaxLevel int
declare @RemainStatPoint int
select @MaxLevel = MaxLevel from _Char where CharID = @CharID
set @RemainStatPoint = (@MaxLevel*3)-3
set @MaxLevel = @MaxLevel+19
UPDATE _Char SET Strength=@MaxLevel, Intellect=@MaxLevel, RemainStatPoint=@RemainStatPoint WHERE CharID=@CharID
return -3
end

[merazz012]

دا اللي عندي هيا بص المشكله بضرب السكرول و تمام كل حاجه بس برميم مش بتتشال و لما اعمل stats , skills نفس الكلام شغاله بس مفيش حاجه بتتشال دا معرفش من ايه بالظبط و اللي ضايف السكرول وشغاله عنده مش بيرضي يفيد الناس :] بيعمل عبيط معرفش ليه يريد لو حد يعرف يقول

[komnda]

http://www.mediafire.com/download/tp1su2qrwup9anj/Stat_Recall_Scroll_By_Komnda.rar
حمل ده

[Hero]

لازم تحط ال ID بتاعك الاسكروال فىprosedür

[merazz012]

لازم تحط ال ID بتاعك الاسكروال فىprosedür

حاطط الip يا هيرو :D

[merazz012]

http://www.mediafire.com/download/tp1su2qrwup9anj/Stat_Recall_Scroll_By_Komnda.rar
حمل ده

عارف اني تعبتك معايا بس السكرول دي عندي كلها و عملتها بردو بفس المشكله :D

[merazz012]

up

[MeMo@Love]

ممنوع الاسبام اعمل up كل 24 ساعه لحد لما يرد على حضرتك

[Hero]

بص هات ال prosedür و هات ال ID ref.skill بتاع الاسكروال و انا اظبطهولك

[merazz012]

بص هات ال prosedür و هات ال ID ref.skill بتاع الاسكروال و انا اظبطهولك

if(@JobID = '99997')
begin
declare @Strength int
declare @Intellect int
declare @MaxLevel int
declare @RemainStatPoint int
select @MaxLevel = MaxLevel from _Char where CharID = @CharID
set @RemainStatPoint = (@MaxLevel*3)-3
set @MaxLevel = @MaxLevel+19
UPDATE _Char SET Strength=@MaxLevel, Intellect=@MaxLevel, RemainStatPoint=@RemainStatPoint WHERE CharID=@CharID
return -3
end




ref skill




1 45001 1201 SKILL_MALL_STATS_POINT_RECALL_A_KARA ???? ???? SKILL_MALL_STATS_POINT_RECALL_A_KARA 0 1 1 0 0 0 0 0 1000 0 0 0 3599 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 255 255 0 0 0 0 0 255 255 255 255 item\etc\mall_stats_point_recall_81lv.ddj SN_ITEM__MALL_STATS_POINT_RECALL_A xxx SN_ITEM_MALL_STATS_POINT_RECALL_A_TT_DESC xxx 0 0 3 1667396966 1851946342 1685418593 1500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

[Hero]

ابعتهم فى رسالة و يكونة صح او هات ال ID بتاع الاسكرول بس

[merazz012]

up