21-02-2016, 05:23 PM
|
#1
|
|
|
• الانـتـسـاب » Mar 2014
|
|
• رقـم العـضـويـة » 116941
|
|
• المشـــاركـات » 769
|
|
• الـدولـة » TanTa
|
|
• الـهـوايـة » SilkRoaD
|
|
• اسـم الـسـيـرفـر » Pavo
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 88
|
|
|
|
.gif)
(Scroll Recall Skills (Auto Teleport
الموضوع داكان معمول قبل كده بس كان لازم تعمل 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+@TotalSPMastery+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,11526,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
|
|
|
|