Quick Question

02/10/2011 04:53 Aberdien#1

I'm in the process of testing my item drops from mobs. Testing the troll base bosses in jungle and the boss dropped a 56 wep. When I looked in the dbo.MobItems the bosses in jungle do not have the grade number for the 56 weps. I used the query by Alladrios =) and the grade number doesn't go to anything else but the 56 weps. Is there another place I might have missed to edit the mob item drops? Or is this just something really random. Thanks

02/10/2011 06:05 -Infamy-#2

Just do this..

Code:

Select *
From PS_GameDefs.dbo.MobItems
Where MobID=(troll boss mobid)

And search the grades that appear, find the one that is dropping the weapon and remove it.

Code:

Select *
From PS_GameDefs.dbo.Items
Where Grade=(the grade that appeared in the previous results)

02/10/2011 06:43 Aberdien#3

Thanks Infamy. Definitely made my searching more accurate. =)

02/10/2011 06:44 zargon05#4

or simply

Code:

SELECT * FROM
PS_Gamedefs.dbo.MobItems AS mi INNER JOIN PS_Gamedefs.dbo.Items AS i
ON mi.grade=i.grade WHERE m.mobid=(mob id here)

For convenience replace the * with mobname,itemname...etc otherwise it will display a lot of unwanted columns

02/10/2011 07:57 -Infamy-#5

Yeah zargon, because that looks simpler than what I wrote. :p <- SQL nub still learning