الموضوع بأختصار شديد ... random scrolls بمعني ان الاسكرول دي هتحطها في npc
ولو يكن دي اسكرول gold هتحطها مثلا في npc ب 2B Gold وتديلك من 1B gold ل 10B gold
او مثلا تحطها ب 200 arena coin وتعملها تديلك 200 - 1000 Arena coin علي حسب ال procedure متظبط ازاي !!
نخش في الموضوع عشان مطولش عليكو
Random Coin Scroll
_RefObjCommon
كود PHP:
1 113913 ITEM_GAMER_RANDOM_COIN_SCROLL Scroll Random Coin xxx SN_ITEM_GAMER_RANDOM_COIN_SCROLL SN_ITEM_GAMER_RANDOM_COIN_SCROLL_TT_DESC 0 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 1 -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_change_name.ddj xxx xxx 3336134
_RefObjItem
كود PHP:
3336134 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
SRO_VT_SHARDLOG > Stored procedures > _AddLogItem
كود PHP:
IF (@Operation = 41) and (@ItemRefID = 113913)
BEGIN
declare @GAMERChar varchar(64)
declare @GAMER1 int = '1'
declare @GAMER2 int = '1000'
declare @StartRandom int = ROUND(((@GAMER1 - @GAMER2 -1) * RAND() + @GAMER2), 0)
Set @GAMERChar = (select CharName16 from [SRO_VT_SHARD].[dbo].[_Char] where [CharID] = @CharID)
exec [SRO_VT_SHARD].._ADD_ITEM_EXTERN @GAMERChar,'ITEM_ETC_ARENA_COIN',@StartRandom,1
end
Itemdata_45000.txt
كود PHP:
1 113913 ITEM_GAMER_RANDOM_COIN_SCROLL ???? ???? ??? (???) xxx SN_ITEM_GAMER_RANDOM_COIN_SCROLL SN_ITEM_GAMER_RANDOM_COIN_SCROLL_TT_DESC 0 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 1 -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_change_name.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.txt
كود PHP:
1 SN_ITEM_GAMER_RANDOM_COIN_SCROLL Random Coin Scroll
1 SN_ITEM_GAMER_RANDOM_COIN_SCROLL_TT_DESC <sml2>After using this you will recive "Random" Arena Coin! as randomly reward. <br><br><font color="255,255,255,0">How to use:</font><br>- right click and (YES). <br>- BY: Gamer.</sml2>
Random Gold Scroll
_RefObjCommon
كود PHP:
1 113913 ITEM_GAMER_RANDOM_GOLD_SCROLL Scroll Random Gold xxx SN_ITEM_GAMER_RANDOM_GOLD_SCROLL SN_ITEM_GAMER_RANDOM_GOLD_SCROLL_TT_DESC 0 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 1 -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_change_name.ddj xxx xxx 3336134
_RefObjItem
كود PHP:
3336134 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
SRO_VT_SHARDLOG > Stored procedures > _AddLogItem
كود PHP:
IF (@Operation = 41) -- GAMER
BEGIN
IF (@ItemRefID = 113913)
BEGIN
declare @Charname varchar(128)
declare @upper_GAMER int = '1000000' declare @lower_GAMER int = '1000000'
declare @random_GAMER int = ROUND(((@upper_GAMER - @lower_GAMER -1) * RAND() + @lower_GAMER), 0)
set @charname = (select CharName16 from SRO_VT_SHARD.dbo._Char where CharID=@CharID)
Update SRO_VT_SHARD.dbo._Char set RemainGold = RemainGold + @random_GAMER where CharName16 = @charname
end
end
Itemdata_45000.txt
كود PHP:
1 113913 ITEM_GAMER_RANDOM_GOLD_SCROLL ???? ???? ??? (???) xxx SN_ITEM_GAMER_RANDOM_GOLD_SCROLL SN_ITEM_GAMER_RANDOM_GOLD_SCROLL_TT_DESC 0 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 1 -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_change_name.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.txt
كود PHP:
1 SN_ITEM_GAMER_RANDOM_GOLD_SCROLL Random Gold Scroll
1 SN_ITEM_GAMER_RANDOM_GOLD_SCROLL_TT_DESC <sml2>After using this you will recive "Random" Gold! as randomly reward. <br><br><font color="255,255,255,0">How to use:</font><br>- right click and (YES). <br>- BY: Gamer.</sml2>
Random Silk Scroll
_RefObjCommon
كود PHP:
1 113913 ITEM_GAMER_RANDOM_SILK_SCROLL Scroll Random Silk xxx SN_ITEM_GAMER_RANDOM_SILK_SCROLL SN_ITEM_GAMER_RANDOM_SILK_SCROLL_TT_DESC 0 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 1 -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_change_name.ddj xxx xxx 3336134
_RefObjItem
كود PHP:
3336134 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
SRO_VT_SHARD > Stored procedures > _AddTimedJob
كود PHP:
if
(@JobID= '113913')
BEGIN
DECLARE @USERJID int;
SET @USERJID = (SELECT USERJID FROM SRO_VT_SHARD.._USER WHERE CHARID = @CHARID);
IF (SELECT COUNT(*) FROM SRO_VT_ACCOUNT..SK_SILK WHERE JID = @USERJID) > 0
UPDATE SRO_VT_ACCOUNT..SK_SILK SET SILK_OWN = SILK_OWN + 1000 WHERE JID = @USERJID;
END
Itemdata_45000.txt
كود PHP:
1 113913 ITEM_GAMER_RANDOM_SILK_SCROLL ???? ???? ??? (???) xxx SN_ITEM_GAMER_RANDOM_SILK_SCROLL SN_ITEM_GAMER_RANDOM_SILK_SCROLL_TT_DESC 0 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 1 -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_change_name.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.txt
كود PHP:
1 SN_ITEM_GAMER_RANDOM_SILK_SCROLL Random Silk Scroll
1 SN_ITEM_GAMER_RANDOM_SILK_SCROLL_TT_DESC <sml2>After using this you will recive "Random" Silk! as randomly reward. <br><br><font color="255,255,255,0">How to use:</font><br>- right click and (YES). <br>- BY: Gamer.</sml2>