[Question]Explanation about changing drops

01/25/2012 20:43 Miike.#1

Hey peoples :D

I want to change some drops, but I don't understand anything of it. 'Cause the only things I found were like:

Code:

 Update PS_GameDefs.dbo.MobItems
set [Grade] = [Item's_Grade], [DropRate] = [%] where [Grade] = [Current_Item's], and [Mob_ID] = [Mob's_ID]

Could some one get me an example of how it should look if I want, let's say Dentatus to drop Conflict and Pursuer Pieces with 10% drop rate?

Thanks in advance!

01/26/2012 06:59 AnyChat#2

First you need a Grade:

Code:

UPDATE [PS_GameDefs].[dbo].[Items]
SET Grade= '16'
WHERE ItemID= '100010'

( 16 is the new Grade... 100010 is KO-Noss and now in Grade 16)

Now you set the new Grade in a mob:

Code:

UPDATE [PS_GameDefs].[dbo].[MobItems]

SET Grade= '16'
WHERE MobID= '1899'

Last you must set the Droprate:

Code:

UPDATE [PS_GameDefs].[dbo].[MobItems]

SET DropRate= '10'
WHERE MobID= '1899'

this is only one way to do that. there are certainly better ways

01/26/2012 07:13 taZツ#3

Or just simply modify this script, and execute it.

update PS_GameDefs.dbo.MobItems
set Grade=0, DropRate=0
where MobID= AND ItemOrder=0
OR MobID= AND ItemOrder=0
OR MobID= AND ItemOrder=0
OR MobID= AND ItemOrder=0
OR MobID= AND ItemOrder=0
OR MobID= AND ItemOrder=0
OR MobID= AND ItemOrder=0

01/26/2012 07:26 JohnHeatz#4

Taking AnyChat's explanation you should get it all done by:

1- Item's Grade into a MobID
2-Drop Rate for the Item
3- Remember that you need the ItemOrder of the item, as every mo can drop different items at the same time

So it has to be something like:

Code:

Update PS_GameDefs.dbo.MobItems
set Grade = [Grade], DropRate = [%] where MobID = [Mob] and ItemOrder = [between 1 and 9]

01/26/2012 13:18 Miike.#5

Quote:
Originally Posted by AnyChat
First you need a Grade:
Code:
UPDATE [PS_GameDefs].[dbo].[Items]
SET Grade= '16'
WHERE ItemID= '100010'
( 16 is the new Grade... 100010 is KO-Noss and now in Grade 16)

Now you set the new Grade in a mob:
Code:
UPDATE [PS_GameDefs].[dbo].[MobItems]

SET Grade= '16'
WHERE MobID= '1899'
Last you must set the Droprate:
Code:
UPDATE [PS_GameDefs].[dbo].[MobItems]

SET DropRate= '10'
WHERE MobID= '1899'
this is only one way to do that. there are certainly better ways

So let me get it right, you first set an item in a Grade. Can that grade just be a random number?

And if I want to let a mob drop more then 1 item, I just get all those items I want the mob(s) to drop into for example Grade 16?

And, do I make a new query for it? Or do I just edit an already excisting one?

Really thanks for the help!

Quote:
Originally Posted by JohnHeatz
Taking AnyChat's explanation you should get it all done by:

1- Item's Grade into a MobID
2-Drop Rate for the Item
3- Remember that you need the ItemOrder of the item, as every mo can drop different items at the same time

So it has to be something like:
Code:
Update PS_GameDefs.dbo.MobItems
set Grade = [Grade], DropRate = [%] where MobID = [Mob] and ItemOrder = [between 1 and 9]

That ItemOrder, is that something that already excists, or just like a random number between 1-9 and that it will drop in an order(for example, ItemOrder 1 will drop faster then ItemOrder9)?

Thanks Alot!

01/26/2012 15:07 [Dev]Ansem#6

Quote:

Originally Posted by Miike.

So let me get it right, you first set an item in a Grade. Can that grade just be a random number?

Yes. Most items have grades between 1 and 999.

Quote:

Originally Posted by Miike.

And if I want to let a mob drop more then 1 item, I just get all those items I want the mob(s) to drop into for example Grade 16?

Not really. If you want 1 Mob to drop more items you can enter 9 Grades to the mob. The Grade is like a group of items.
Example: One mob in CT drops goddess armors, all goddess armors of both sides use the Grade 728. And the Bosses in CT have entered the grade 728. That means they will randomly drop items from the grade 728.
If you want that boss to drop "Enchant Items" also, just put all enchant items into one Grade (example: 421) and enter that Grade to the Mob on ItemOrder 2.

Quote:

Originally Posted by Miike.

That ItemOrder, is that something that already excists, or just like a random number between 1-9 and that it will drop in an order(for example, ItemOrder 1 will drop faster then ItemOrder9)?

No. Only the "DropRate" from dbo.MobItems.

01/26/2012 16:42 JohnHeatz#7

Ok, every item is under one Grade; you do not need to change the grade of the items, you can simply get the Grade by searching for the item:

Code:

Use PS_GameDefs
Select ItemName, Grade from dbo.Items where ItemName = [ItemName]

Now, as for the ItemOrder, well, lets say that every mob has the chance to drop items from 9 different Grades; this means that a single mob could drop 9 items every time you kill it. For every grade that you want it to drop, it has the "space" for it under the ItemOrder, but for you to have one item being dropped more than the others, you must change their DropRate (%)

01/26/2012 19:58 Miike.#8

Alright, thanks for all the useful information! Found out how to do it.

Thanks both! :D