(Scroll Recall Skills (Auto Teleport

M.Moamen · 2 فبراير 2017

اما الاسكرولة دى بيتعمل auto Telepot لوحدها
نخش فى الموضوع على طول

DataBase Side :

RefObjCommon

PHP:

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

PHP:

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

PHP:

IF ((@Operation = 41 ) AND (@ItemRefID = 61508)) 
BEGIN 
exec SRO_VT_SHARD.dbo._Scroll_Reset @CharID 
END

Create New Procedure

PHP:

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

PHP:

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

PHP:

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>

Master · 3 مايو 2017

رد: (Scroll Recall Skills (Auto Teleport

يعنى هتفيد فى ايه الاسكرول ده

هنعمل ايه Auto telepoert ?

مش نفهم بردك

تمام فهمت انا كانت دماغى مشغوله سرحت شويه مشفتش الموضوع حلو

البحث

البحث

(Scroll Recall Skills (Auto Teleport

M.Moamen

خيارات إضافية

Master

خيارات إضافية

كلمة مدير الموقع