Adding an item to a mob as a drop - why doesn't work to me ?

[NagySandor96]

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.

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.

[TakeshiVongola]

Your level is too high. Change Strong Mangyang level in database.

Also, don't call yourself 'a pro' because you sucessfully ran a query lol.

[blapanda]

Originally Posted by TakeshiVongola

Also, don't call yourself 'a pro' because you sucessfully ran a query lol.

This is like this:



It is a disease.

[NagySandor96]

Thx for the answer. Btw have you really believed that I keep myself a pro ?! Omg, I could express my problem and also myself) on that way...
-NS

EDIT:The prob has just been solved

[TakeshiVongola]

You said it yourself lol. I just quoted you. Anyways, good that your problem was fixed, could you tell what you did, so if anyone else has the problem, they could fix it?

[vietnguyen09]

I guess he just want to say "like a boss" but he was chose another word for fun.

[NagySandor96]

Originally Posted by TakeshiVongola

You said it yourself lol. I just quoted you. Anyways, good that your problem was fixed, could you tell what you did, so if anyone else has the problem, they could fix it?

In response to your request: Simply, I have restarted my whole system, so the query works well.

-NS