SQL Statements for DB Fixes

[Squiffy]

Not sure on that damage fix...

I mean, I haven't tested the database fully, but I imagine at least some mobs are accurate, and to have all level 60 mobs hit for 200 is kinda iffy.

I went with a more selective fix. Namely, a ton of mobs had been set for maxdmg=400, regardless of level. These were the majority of off-balanced mobs. (PC recondites, some skeletons, etc)

So instead of:

UPDATE npc_types SET maxdmg=200 WHERE level=60;

use

UPDATE npc_types SET maxdmg=200 WHERE level=60 and maxdmg=400;

Check this thread: HERE (About halfway down on the first page)

Good compilation otherwise, though. Only thing I see is that it will unbalance any pre-PoP raid zone trash mobs (ie Temple of Veeshan, Sleeper's Tomb, Veeshan's Peak) which tend to hit harder than your average level 60ish mob.

Small steps though, I guess