[Bouken]

Drop Items

USE/**/[SRO_VT_SHARD]/**/
--Credits to Hean
/*Edited By nukertube*/
GO
DECLARE @Mob VarChar(MAX),@Item VarChar(MAX),@MonsterID iNt,@ItemID iNt,@DropRatio ReaL, @DropAmountMin INT, @DropAmountMax INT
--------------------------------------------------------------------------
SET @Mob            =    'MOB_TQ_WHITESNAKE'/*Monster Code*/
SET @Item            =    'ITEM_MALL_GLOBAL_CHATTING'/*Item Code*/
SET @DropAmountMin    =    10 /*Drop Min*/
SET @DropAmountMax    =    50 /*Drop Max*/
SET @DropRatio        =    0.9 /*0.5 = '50%' */
--------------------------------------------------------------------------
SET @MonsterID    =    (SELECT ID FROM [dbo].[_RefObjCommon] WHERE CodeName128 = @Mob)/**/
SET @ItemID        =    (SELECT ID FROM [dbo].[_RefObjCommon] WHERE CodeName128 = @Item)/**/
INSERT [dbo].[_RefMonster_AssignedItemDrop]/**/
(RefMonsterID,RefItemID,DropGroupType,OptLevel,DropAmountMin,DropAmountMax,DropRatio,RefMagicOptionID1,CustomValue1,RefMagicOptionID2,CustomValue2,RefMagicOptionID3,CustomValue3,RefMagicOptionID4,CustomValue4,RefMagicOptionID5,CustomValue5,RefMagicOptionID6,CustomValue6,RefMagicOptionID7,CustomValue7,RefMagicOptionID8,CustomValue8,RefMagicOptionID9,CustomValue9,RentCodeName)/**/
VALUES(@MonsterID,@ItemID,0,0,@DropAmountMin,@DropAmountMax,@DropRatio,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')/**/

*******************

لو عايز تعدل فى الحاجه ألى فى ال NPC يعنى تشيل و تحط من RefShopGoods


و لو عايز تعد الاسعار _RefPricePolicyOfItem

*********************

بتظهر بس أكيد مش هتظهرلك مخصوص ليها مواعيد و لو عايز تعدل ع المواعيد من RefNest



#