- إنضم
- 14 يناير 2020
- المشاركات
- 133
جايبلكم اسكرول بتعمل ابجريد لاى حاجه عادى عايز سلح او ايتم اى حاجه
ندخل على الشغل اول حاجه هتعمل الاسكرول
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 0textdata_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>كده خلصنا الاسكرول ندخل على السيستم
أول حاجة هتكريت الجدول دا
SRO_VT_SHARDLOG.dbo._AddLogItem
أول حاجة هتكريت الجدول دا
كود:
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
