Quick Question

Aberdien · 02/10/2011, 04:53

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

-Infamy- · 02/10/2011, 06:05

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)

Aberdien · 02/10/2011, 06:43

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

zargon05 · 02/10/2011, 06:44

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

-Infamy- · 02/10/2011, 07:57

Yeah zargon, because that looks simpler than what I wrote.

<- SQL nub still learning