Stat/Plus/FB Scroll

[Bigboos]

You must be registered for see images

You must be registered for see images

Scroll FB+Stats 100% + Plus +16

الاسكرولاية بأختصار لو انت عايز تعمل Reward لي الناس الجديدة ف السيرفر من غير ما تتعب نفسك بتعمل الاسكرول دي( بتعملك الحاجه اللي الشخصية لابساها +16 100% FB ) ممكن تعملها 80% / 0% انت وراحتك وممكن تعدل علي ال + في Procedure برضه انت وراحتك ..
نخش في الموضوع بقا معلش طولت عليكو

Database

_RefObjCommon

1    61536    ITEM_MALL_GAMER_FB    ?????    xxx    SN_ITEM_MALL_SILK_SCROLL_5    SN_ITEM_POINT_1_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    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\archemy_reinforce_athanasia_a.ddj    xxx    xxx    2236467

RefObjItem

2236467    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    ??????                                                                                                                               -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

Media

Itemdata45000.txt

1    61536    ITEM_MALL_GAMER_FB    ?????    xxx    SN_ITEM_MALL_GAMER_FB    SN_ITEM_MALL_GAMER_FB_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    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    pet2\item\item_pet2_system_name_remove.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    1000    ????    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.txt

1    SN_ITEM_MALL_GAMER_FB                                Reward Scroll

_AddLogItem

    IF (@Operation=41 AND @ItemRefID=61536) BEGIN -- Codded By Bigboos
    EXEC FB @CHARID END

Create Procedure

USE [SRO_VT_SHARDLOG] -- Codded By Bigboos
GO
/****** Object:  StoredProcedure [dbo].[FB]    Script Date: 14/03/2017 12:00:00 ص ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================

CREATE PROCEDURE [dbo].[FB]
@CHARID INT
AS
BEGIN

    SET NOCOUNT ON;


DECLARE @ItemID int
,@Charname VarChar(50)
,@PLUS int
, @Head int
,@CHEST int
,@LEGS int
,@SHOULDER int
,@HAND int
, @FOOT int
,@RING1 int
,@RING2 int
,@NECK int
,@ERRING int
,@WEP int
,@SHIELD int

SELECT @Charname=CHARNAME16 FROM SRO_VT_SHARD__JOoOo.._CHAR WHERE CHARID=@Charid
SET @PLUS = '16'
SET @Charid = (select CharID from SRO_VT_SHARD__JOoOo.._Char where CharName16=@Charname)
SET @Head = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=0 and CharID=@Charid)
SET @CHEST = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=1 and CharID=@Charid)
SET @LEGS = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=4 and CharID=@Charid)
SET @SHOULDER = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=2 and CharID=@Charid)
SET @HAND = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=3 and CharID=@Charid)
SET @FOOT = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=5 and CharID=@Charid)
SET @RING1 = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=11 and CharID=@Charid)
SET @RING2 = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=12 and CharID=@Charid)
SET @NECK = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=10 and CharID=@Charid)
SET @ERRING = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=9 and CharID=@Charid)
SET @WEP =(Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=6 and CharID=@Charid)
SET @SHIELD =(Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=7 and CharID=@Charid)

update SRO_VT_SHARD__JOoOo.._Items 
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =5583457484950,
MagParam2 =5583457484962,
MagParam3 =30064771144,
MagParam4=858993459290,
MagParam5=30064771150,
MagParam6=257698037898,
Variance=1073741823
where ID64 =@Head
---------------

update SRO_VT_SHARD__JOoOo.._Items 
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =5583457484950,
MagParam2 =5583457484962,
MagParam3 =30064771144,
MagParam4=858993459290,
MagParam5=30064771150,
MagParam6=257698037898,
Variance=1073741823
where ID64 =@CHEST

----------------------

update SRO_VT_SHARD__JOoOo.._Items 
set MagParamNum=4,
optlevel=@PLUS,
MagParam1 =30064771150,
MagParam2 =30064771144,
MagParam3 =858993459290,
MagParam4=257698037898,
Variance=1073741823
where ID64 =@SHOULDER

----------------------
update SRO_VT_SHARD__JOoOo.._Items 
set MagParamNum=4,
optlevel=@PLUS,
MagParam1 =30064771150,
MagParam2 =30064771144,
MagParam3 =858993459290,
MagParam4=257698037898,
Variance=1073741823
where ID64 =@HAND


update SRO_VT_SHARD__JOoOo.._Items 
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =5583457484950,
MagParam2 =5583457484962,
MagParam3 =30064771144,
MagParam4=858993459290,
MagParam5=30064771150,
MagParam6=257698037898,
Variance=1073741823
where ID64 =@LEGS

-----------------------

update SRO_VT_SHARD__JOoOo.._Items 
set MagParamNum=4,
optlevel=@PLUS,
MagParam1 =30064771150,
MagParam2 =30064771144,
MagParam3 =858993459290,
MagParam4=257698037898,
Variance=1073741823
where ID64 =@FOOT

update SRO_VT_SHARD__JOoOo.._Items 
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =30064771144,
MagParam2 =30064771150,
MagParam3 =85899346100,
MagParam4 =85899346094,
MagParam5 =85899346112,
MagParam6 =85899346106,
Variance=1023
where ID64 =@RING1



update SRO_VT_SHARD__JOoOo.._Items 
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =30064771144,
MagParam2 =30064771150,
MagParam3 =85899346100,
MagParam4 =85899346094,
MagParam5 =85899346112,
MagParam6 =85899346106,
Variance=1023
where ID64 =@RING2

update SRO_VT_SHARD__JOoOo.._Items 
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =30064771144,
MagParam2 =30064771150,
MagParam3 =85899346100,
MagParam4 =85899346094,
MagParam5 =85899346112,
MagParam6 =85899346106,
Variance=1023
where ID64 =@NECK


update SRO_VT_SHARD__JOoOo.._Items 
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =30064771144,
MagParam2 =30064771150,
MagParam3 =85899346100,
MagParam4 =85899346094,
MagParam5 =85899346112,
MagParam6 =85899346106,
Variance=1023
where ID64 =@ERRING

update SRO_VT_SHARD__JOoOo.._Items 
set MagParamNum=4,
optlevel=@PLUS,
MagParam1 =30064771150,
MagParam2 =30064771144,
MagParam3 =858993459290,
MagParam4 =257698037862,
Variance=34359738367
where ID64 =@WEP


update SRO_VT_SHARD__JOoOo.._Items 
set MagParamNum=3,
optlevel=@PLUS,
MagParam1 =30064771150,
MagParam2 =30064771144,
MagParam3 =858993459290,
Variance=1073741823
where ID64 =@SHIELD
set nocount off;
END

لو تلاحظو في ال Procedure انا عامل ال + بالاحمر عشان اللي حابب يعدل عليه ..

تحياتى






​