Random Gold Scroll

[roske]

المشاركة الأصلية كتبت بواسطة ameral عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

لا مش ناقص مادام انت غيرت ال IDs يبقى لازم تغيرو كمان فى ال Procedure زى ماغيرتو فى ال RefObjItem

RefObjCommon

1	115730	ITEM_ROSKE_GOLD	???? ???? ??? (???)	xxx	SN_ITEM_ROSKE_GOLD	SN_ITEM_ROSKE_GOLD_TT_DESC	1	0	3	3	3	1	180000	3	2	0	1	0	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	comatose\uniq_point_scroll.ddj	xxx	xxx	68715

RefObjItem

68715	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

Itemdata_xxxx

1	115730	ITEM_ROSKE_GOLD	???? ???? ??? (???)	xxx	SN_ITEM_ROSKE_GOLD	SN_ITEM_ROSKE_GOLD_TT_DESC	1	0	3	3	3	1	180000	3	2	0	1	0	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	comatose\uniq_point_scroll.ddj	xxx	xxx 68715

Textdata_Object

1	SN_ITEM_ROSKE_GOLD								Random Gold Scroll
1	SN_ITEM_ROSKE_GOLD_TT_DESC								Active This Scroll And You Will See Your Luck.

Procedure

#AddlogItem

IF (@Operation = 41) 
BEGIN
    IF (@ItemRefID = 115730) 
    BEGIN
    declare @Charname varchar(128)
declare @upper_RI3O int = '1000000000' declare @lower_RI3O int = '100'
 declare @random_RI3O int = ROUND(((@upper_RI3O - @lower_RI3O -1) * RAND() + @lower_RI3O), 0)
 set @charname = (select CharName16  from sro_vt_shard.dbo._Char where CharID=@CharID)
Update SRO_VT_SHARD.dbo._Char set RemainGold = RemainGold + @random_RI3O  where CharName16 = @charname      
end