cái này add drop items vô boss hoặc Moster
- Code:
DECLARE @MonsterID intDECLARE @ItemID intDECLARE @DropRatio realDECLARE @UNIQUE VARCHAR (129) DECLARE @items VARCHAR (64)
SET @UNIQUE = 'MOB_CH_TIGERWOMAN_L3' -- Ten BossSET @items = 'ITEM_ETC_SD_TOKEN_04' -- Ten Items can rớt
SET @MonsterID = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @UNIQUE) SET @DropRatio = 1 -------- Ti le 1=100% , 0.5 = 50% SET @ItemID = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @items )
INSERT _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, 1, 1, @DropRatio, 0, 0, 0, 0, 0, 0, 0, 0,0, 0, 0, 0, 0, 0, 0, 0, 0 , 0 , 'xxx')
print '' print '' print 'Hoan Tat !'
