Hello,
I was wondering how I can add any items to any mob as a drop,
after a quick searching I have found a query.
It's OK - I thought.
I was wondering how I can add any items to any mob as a drop,
after a quick searching I have found a query.
It's OK - I thought.
PHP Code:
USE SRO_VT_SHARD -----> By-Flowushy <-----
GO
DECLARE @ MonsterID int
DECLARE @ ItemID int
DECLARE @ DropRatio real
SET = @ MonsterID = 9383 -------- Mob,Unique ID you want Add Drop in
SET @ DropRatio = 1 -------- Item drop rate 1=100% , 0.3 = 30%
SET @ ItemID = 4042 -------- ITEM ID You want Add in Drops
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(9383 , 4042, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0 , 0 , 'xxx')
I have set @ MonsterID to 9383 - it's > Strong Mangnyang
@ DropRatio to 1 - it has to be correct (at least)
@ ItemID to 4042 - it's > ITEM_CH_SWORD_10_B_RARE
It had been successfully sent ( the command ), and I was happy cuz' of being a pro. Setting the server > Logging in > Spawning Strong Mangnyang and killing it by /mobkill 0 GM command, haven't got that certain D10 SOX drop. I have repeated its spawn 10x,but still there isn't any drop.
Guys, could any of you help me to solve out this problem ?
Thanks, NS
P.s.: there isn't any space between '@' and MonsterID, DropRatio, ItemID.
