SCROLL upgrade

[BigboosBigboos عضو تم التحقق منه.]

يجب أن يكون لديك حساب لرؤية الصور

يجب أن يكون لديك حساب لرؤية الصور

جايبلكم اسكرول بتعمل ابجريد لاى حاجه عادى عايز سلح او ايتم اى حاجه
ندخل على الشغل اول حاجه هتعمل الاسكرول

DB
_RefObjCommon

1    49174    ITEM_BIGBOOS_UPGRED    ???? ???? ??? (???)    xxx    SN_ITEM_BIGBOOS_UPGRED    SN_BIGBOOS_UPGRED_TT_DESC    1    0    3    3    13    14    180000    3    0    1    1    1    255    1    1    0    0    129    0    6000    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\akaleb_UPGRED.ddj    xxx    xxx    46061

_RefObjItem

46061    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????(?)    1    [USU1:SKILL_BIGBOOS_UPGRED]                                                                                               -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    -1    xxx    0    0    0

============================================================
====================== MEDIA SIDE ==========================
============================================================

itemdata_45000

1    49174    ITEM_BIGBOOS_UPGRED    ???? ???? ??? (???)    xxx    SN_ITEM_BIGBOOS_UPGRED    SN_BIGBOOS_UPGRED_TT_DESC    1    0    3    3    13    14    180000    3    0    1    1    1    255    1    1    0    0    129    0    6000    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\akaleb_UPGRED.ddj    xxx    xxx    1    2    0    0    1    0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0    0    0    0    0    0    0    0    0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    1000    ????(?)    1    [USU1:SKILL_BIGBOOS_UPGRED]    -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    -1    xxx    0    0

textdata_object
​

1    SN_ITEM_BIGBOOS_UPGRED                                UPGRED Bay Bigboos
1    SN_BIGBOOS_UPGRED_TT_DESC                                <sml2>Thes is a New Scroll Added By Bigboos Team To VSROEGY . Active the Scroll And You Will Gain A Special UPGRED<br><br>This Scroll UPGRED Wepone.<br><br><strong><font color="255,236,219,156">Warning: </font></strong><br><strong><font color="255,255,0,43">- >> Enjoy it !.</font></strong><br><br><strong><font color="255,236,219,156">Created by:</font></strong><br><strong><font color="255,0,255,127">Bigboos</font></strong></sml2>

كده خلصنا الاسكرول ندخل على السيستم
أول حاجة هتكريت الجدول دا

Use SRO_VT_SHARDLOG
Create Table [dbo].[ItemsUpgrade]
([OldRefItemID] [Int] NOT NULL,
 [NewRefItemID] [Int] NOT NULL)

SRO_VT_SHARDLOG.dbo._AddLogItem​

IF (@Operation = 41 and @ItemRefID = 'Scroll CommonID')
 Begin
  Declare @NewItemID Int , @ID64 Int, @Slot Int, @ReqPlus Int, @NewPlus Int, @Name Varchar(100), @Codename Varchar(128), @Msg Varchar(128);
  Set @Slot = 13;   -- Upgrade Slot
  Set @ReqPlus = 8; -- Required Optlevel
  Set @NewPlus = 0; -- New Item OptLevel
  Set @Codename = 'ITEM_MALL_UPGRADE_SCROLL_ALL_SLOT_13'; -- Upgrade Scroll CodeName128
  Set @Msg = 'Target item cannot be upgraded, scroll has returned to your inventory.'; -- Private Message for fail upgrading process
  Set @Name = (Select Charname16 From [SRO_VT_SHARD].[dbo].[_Char] Where CharID = @CharID);
  Select @NewItemID = U.NewRefItemID , @ID64 = I.ID64 From [dbo].[ItemsUpgrade] U Inner Join [SRO_VT_SHARD].[dbo].[_Items] I
  ON U.OldRefItemID = I.RefItemID Inner Join [SRO_VT_SHARD].[dbo].[_Inventory] V ON I.ID64 = V.ItemID Where V.CharID = @CharID
  and V.Slot = @Slot and I.OptLevel = @ReqPlus;
  IF (@NewItemID Is Not Null)
  Begin
    Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @NewItemID , OptLevel = @NewPlus Where ID64 = @ID64;
  End ELSE Begin
    -- Vsro Multi Tool Table
    Insert Into [iLegendBot].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values ('1','Private',@Name,@Msg,Getdate());
    Exec [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @Name,@Codename,1,0;
  End
 End

​

 

[Mohamedkh]

طب دي upgard item ايه

 

[BigboosBigboos عضو تم التحقق منه.]

طب دي upgard item ايه

سلاح او لبس
السيستم ده عباره عن انو بيبدل سلاح او لبس او اكسوسرى من مثلا دجرى 11 لى دجرى 12 وبالبلص اللى انت عيزو

 

[الاسدابومالك]

جميل جدا عاش بس اكتب شرح البروسيدور بالعربى لانى فى ناس هتكون اول مره تعملها ومش هياخد باله من الانجليزى