|
You last visited: Today at 08:56
Advertisement
Adding an item to a mob as a drop - why doesn't work to me ?
Discussion on Adding an item to a mob as a drop - why doesn't work to me ? within the SRO Private Server forum part of the Silkroad Online category.
03/09/2016, 18:56
|
#1
|
elite*gold: 0
Join Date: Oct 2011
Posts: 144
Received Thanks: 23
|
Adding an item to a mob as a drop - why doesn't work to me ?
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.
|
|
|
03/10/2016, 01:39
|
#2
|
elite*gold: 0
Join Date: Mar 2012
Posts: 137
Received Thanks: 29
|
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.
|
|
|
03/10/2016, 03:09
|
#3
|
elite*gold: 0
Join Date: Jul 2009
Posts: 1,860
Received Thanks: 757
|
Quote:
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.
|
|
|
03/10/2016, 12:55
|
#4
|
elite*gold: 0
Join Date: Oct 2011
Posts: 144
Received Thanks: 23
|
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
|
|
|
03/11/2016, 01:05
|
#5
|
elite*gold: 0
Join Date: Mar 2012
Posts: 137
Received Thanks: 29
|
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?
|
|
|
03/11/2016, 10:42
|
#6
|
elite*gold: 290
Join Date: Oct 2013
Posts: 263
Received Thanks: 191
|
I guess he just want to say "like a boss" but he was chose another word for fun.
|
|
|
03/11/2016, 23:29
|
#7
|
elite*gold: 0
Join Date: Oct 2011
Posts: 144
Received Thanks: 23
|
Quote:
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
|
|
|
|
Similar Threads
|
I need help! Alternative drop doesn't work for me.
10/16/2014 - Metin2 Private Server - 0 Replies
Hi guys!
I have a problem. I have a server and I use server files.
Here is a solution, but it doesn't work for me.
http://www.elitepvpers.com/forum/metin2-pserver-d iscussions-questions/2637422-bugs-probleme-fehler- sammelthread-2013-files-invoice.html
Can you help me with an other solution? Or something help...
|
[S4 EMU]repair item doesn't work!
05/05/2014 - S4 League - 0 Replies
repair item doesn't work! it gives a error.and click repair all button,the client stuck,the server log shows unknown packet.how to fix this problem?
source code is here https://bitbucket.org/wtfblub/trashnet/overview
|
Item icon gone when adding new item (ItemMinIcon Problem)
04/13/2012 - EO PServer Hosting - 0 Replies
When i adding new casual for my new quest,and try to login to my Test server for checking it all item icon are gone.I really confident this problem was cause by ItemMinIcon.ani,why im saying that? cause when i move the item from ItemMinIcon.ani the problem solve...but the casual dont have icon...i bet some of ElitePvpers member know especially TheFlames ;) (Im Using Client Flames LOL)
Screenshot:
Item that i add (Casual) :
|
Adding more than 3 skills in DB-Bot doesn't work
08/01/2010 - SRO Private Server - 3 Replies
Hey All
my bot use only 3 skills if i add more than 3 skills in attack skill list it only use the first 3 skills
except the buffs
it use all buffs i add
i'm using bot: SRO-DB Bot v1.0b2
|
All times are GMT +2. The time now is 08:56.
|
|