Helps pliss

[ongamanext]

I need Query add all Drop D11 Moon all mobs Alex pliss

[MentaL]

[MikroTekken]

D11 Mon ?

[ongamanext]

Yes yes

[abdo1020]

Spoiler:

USE SRO_VT_SHARDGO
DECLARE @MonsterID intDECLARE @ItemID intDECLARE @DropRatio real


SET @MonsterID = 24160 -- You can find Monster ID's at RefObjCommonSET @DropRatio = 1 -- 100% = 1 / 50% = 0.5 / 0% = 0 of courseSET @ItemID = 25834 -- You can find Item ID's at RefObjCommon

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')

MONSTER ID
ITEM ID
DROP RATE
advice : change the rarity to 3