elbattawy1st
21-02-2016, 05:23 PM
الموضوع داكان معمول قبل كده بس كان لازم تعمل teleport علشان الاسكرول تشتغل
اما الاسكرولة دى بيتعمل auto Telepot لوحدها
نخش فى الموضوع على طول
DataBase Side :
RefObjCommon
1 61508 ITEM_MALL_RESET_SKILLS ???? ???? ??? (???) xxx SN_ITEM_MALL_RESET_SKILLS SN_ITEM_MALL_RESET_SKILLS_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 3 0 1 0 0 129 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\mall_skill_point_recall_a.ddj xxx xxx 2239122
RefObjItem
2239122 1 2 0 0 3 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 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
ِAdd To _AddLogItem
IF ((@Operation = 41 ) AND (@ItemRefID = 61508))
BEGIN
exec SRO_VT_SHARD.dbo._Scroll_Reset @CharID
END
Create New Procedure
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_Scroll_Reset] Script Date: 2/21/2016 4:06:44 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[_Scroll_Reset]
@CharID INT
AS
BEGIN
declare @TotalSP int
declare @TotalSPMastery int
SELECT @TotalSP = SUM(_RefSkill.ReqLearn_SP) FROM _RefSkill, _CharSkill WHERE _RefSkill.ID=_CharSkill.SkillID AND _CharSkill.CharID=@CharID AND _RefSkill.ReqCommon_MasteryLevel1 <= '120'
SELECT @TotalSPMastery = SUM(_RefLevel.Exp_M) FROM _CharSkillMastery, _RefLevel WHERE _RefLevel.Lvl=_CharSkillMastery.Level AND _CharSkillMastery.CharID=@CharID AND _CharSkillMastery.Level <= '120'
UPDATE _Char SET RemainSkillPoint=RemainSkillPoint+@TotalSP+@TotalS PMastery+200000 WHERE CharID=@CharID
DELETE _CharSkill FROM _RefSkill, _CharSkill WHERE _RefSkill.ID=_CharSkill.SkillID AND _CharSkill.CharID=@CharID AND _RefSkill.ReqCommon_MasteryLevel1 <= '120' AND _RefSkill.ID NOT IN (1,70,40,2,8421,9354,9355,11162,9944,8419,8420,115 26,10625)
UPDATE _CharSkillMastery SET Level='0' WHERE CharID=@CharID AND Level <= '120'
END
-----------------------------------------------------------------
Media Side :
itemdata_45000
1 61508 ITEM_MALL_RESET_SKILLS ???? ???? ??? (???) xxx SN_ITEM_MALL_RESET_SKILLS SN_ITEM_MALL_RESET_SKILLS_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 0 3 1 0 0 129 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\mall_skill_point_recall_a.ddj xxx xxx 1 2 0 0 3 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 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0
textdata_object
1 SN_ITEM_MALL_RESET_SKILLS Skills Reset Scroll
1 SN_ITEM_MALL_RESET_SKILLS_TT_DESC <sml2>After using this you should teleport AutoMatice and it will Reset ur Skills<br><br><font color="255,255,255,0">How to use:</font><br>- Right click on scroll<br>- Have Fun!</sml2>
ملحوظه : الشكر لصاحب الموضوع حمزه انا بس عدلت عليها علشان تكون auto Teleport
اما الاسكرولة دى بيتعمل auto Telepot لوحدها
نخش فى الموضوع على طول
DataBase Side :
RefObjCommon
1 61508 ITEM_MALL_RESET_SKILLS ???? ???? ??? (???) xxx SN_ITEM_MALL_RESET_SKILLS SN_ITEM_MALL_RESET_SKILLS_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 3 0 1 0 0 129 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\mall_skill_point_recall_a.ddj xxx xxx 2239122
RefObjItem
2239122 1 2 0 0 3 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 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
ِAdd To _AddLogItem
IF ((@Operation = 41 ) AND (@ItemRefID = 61508))
BEGIN
exec SRO_VT_SHARD.dbo._Scroll_Reset @CharID
END
Create New Procedure
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_Scroll_Reset] Script Date: 2/21/2016 4:06:44 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[_Scroll_Reset]
@CharID INT
AS
BEGIN
declare @TotalSP int
declare @TotalSPMastery int
SELECT @TotalSP = SUM(_RefSkill.ReqLearn_SP) FROM _RefSkill, _CharSkill WHERE _RefSkill.ID=_CharSkill.SkillID AND _CharSkill.CharID=@CharID AND _RefSkill.ReqCommon_MasteryLevel1 <= '120'
SELECT @TotalSPMastery = SUM(_RefLevel.Exp_M) FROM _CharSkillMastery, _RefLevel WHERE _RefLevel.Lvl=_CharSkillMastery.Level AND _CharSkillMastery.CharID=@CharID AND _CharSkillMastery.Level <= '120'
UPDATE _Char SET RemainSkillPoint=RemainSkillPoint+@TotalSP+@TotalS PMastery+200000 WHERE CharID=@CharID
DELETE _CharSkill FROM _RefSkill, _CharSkill WHERE _RefSkill.ID=_CharSkill.SkillID AND _CharSkill.CharID=@CharID AND _RefSkill.ReqCommon_MasteryLevel1 <= '120' AND _RefSkill.ID NOT IN (1,70,40,2,8421,9354,9355,11162,9944,8419,8420,115 26,10625)
UPDATE _CharSkillMastery SET Level='0' WHERE CharID=@CharID AND Level <= '120'
END
-----------------------------------------------------------------
Media Side :
itemdata_45000
1 61508 ITEM_MALL_RESET_SKILLS ???? ???? ??? (???) xxx SN_ITEM_MALL_RESET_SKILLS SN_ITEM_MALL_RESET_SKILLS_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 0 3 1 0 0 129 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\mall_skill_point_recall_a.ddj xxx xxx 1 2 0 0 3 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 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0
textdata_object
1 SN_ITEM_MALL_RESET_SKILLS Skills Reset Scroll
1 SN_ITEM_MALL_RESET_SKILLS_TT_DESC <sml2>After using this you should teleport AutoMatice and it will Reset ur Skills<br><br><font color="255,255,255,0">How to use:</font><br>- Right click on scroll<br>- Have Fun!</sml2>
ملحوظه : الشكر لصاحب الموضوع حمزه انا بس عدلت عليها علشان تكون auto Teleport