FunkyBit

Oh yes, it compiles without any problems!

Not a single line to modify yourself.

Hi guys!

Just discovered this wonderfull thread and gave it to our testers.

They love it

But we found a little bug, that took us some time to realy get track of.

First of all - configuration: MaNGOS 0.12 REV 7066 (additional extensions don't touch the following)

Bug:

Wenn you do ".reload creature_questrelation" all quests that are under "game event control" get lost from thier NPCs.

Quests that get activated by a game event don't realy appear in the "creature_questrelation" table. They get somehow integrated on the fly.

Wenn you do the reload command MaNGOS seams to do a full rebuild of the cache from DB and the "on the fly" added quests by any game event are gone.

You have to restart the deamon or the game event to get them back.

Hope you can trace the bug as described

It's not that disturbing it was just as we didn't know about it

Any way, big thanks for this patch!!!

I have the patch up an running and can only say:

It saves A LOT of time!

There even occured the joke:

"If you want your character to be save... delete it!!"

Items can be farmed in less time again. Complete characters a lot more time expensive.

And to build them up from scratch in case a DB structure change has taken place since the deletion... well, I did it a few times... and changing the dump manually was anything else than funny.

This patch is optional. If someone doesn't like it, it can be turned of by config.

And if it is like jdguzman said... it's very well a step forward to support official support behavior.

I realy like it!!!

It saves a lot of time when supporting the community!

Crying Testers: "I accidentally deleted my char, HELP!" can now be solved within seconds!

Thanks a lot!!

I think this will help you a step further.

I added "level" to give an second example for how the comand works. Maybe you want to restrict the search to Chars above a certain Level.

SELECT
   guid,name,
   SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 35), ' ', -1) as level,
   CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1518), ' ', -1) AS UNSIGNED) as killslifetime
FROM characters
ORDER BY killslifetime DESC
LIMIT 10