Dungeon mob EXP Rate

[mescottjr]

Anyone know the code on changing the dungeon mob exp without affecting field mobs. Been looking for awhile and on my server they all give same exp just trying to fix it.

[SilentBill]

They're in Arcadia, MonsterResource, and they have a clearly marked exp column, more than that, you're on your own.

[mescottjr]

OK thanks I see the exp column was just curious if maybe there was a query command i could execute to change them all in 1 shot

[ismokedrow]

Yes actually such a query is possible, I'll even give you a couple hints:

You want to do it in ranges, trust me it's way easier to keep track when doing a massive experience or gold drop overhaul. For instance I did mine in 1-10, 11-20 etc...

Here's what you'll need, sadly I must encourage the use of google on the proper use of the following:

USE
UPDATE
SET
WHERE BETWEEN
GO