CleanCharacterDB

[ilija]

What does it exactly? Delete whole character db? make it empty , or delete some cache?

[goodbadguy]

It brushes the teeth and combs the hair of all your characters... duh! Why not try looking at the code? It's really self explanatory and this is a learning project.

[ilija]

Ehh , it is same as .reset all spells or .reset all archievements or .reset all talents, as i understand looking into code -.-

[goodbadguy]

Nope... it doesn't reset anything, it just erases duplicate and wrong data. Basically, it just removes unnecessary data from the character's database.

[Unkle Nuke]

Sometimes, due to server crashes or when updating the database to newer server revisions, "trash" data can be left behind. This can include old spells, items, and pets that are no longer used or have changed IDs, instances that did not reset correctly, mail that was not properly deleted, and so forth.

These "Character Cleaning" SQL scripts attempt to find and remove this old data. Having an accurate, up to date database is important to prevent crashes and "bugged" characters that may become unplayable due to faults in their data. Be careful which cleaning script you choose. Make sure it is for your server and database version, plus check that it uses proper procedures like creating backups in case an error is made and data needs to be restored as well as using IF EXISTS with DELETE and INSERT instead of simply using REPLACE INTO when modifying tables.

To be safe, always make sure you run your own backup of any tables before modifying or cleaning them with any scripts or queries.

[herrtrigger]

Sometimes, due to server crashes or when updating the database to newer server revisions, "trash" data can be left behind. This can include old spells, items, and pets that are no longer used or have changed IDs, instances that did not reset correctly, mail that was not properly deleted, and so forth.

These "Character Cleaning" SQL scripts attempt to find and remove this old data. Having an accurate, up to date database is important to prevent crashes and "bugged" characters that may become unplayable due to faults in their data. Be careful which cleaning script you choose. Make sure it is for your server and database version, plus check that it uses proper procedures like creating backups in case an error is made and data needs to be restored as well as using IF EXISTS with DELETE and INSERT instead of simply using REPLACE INTO when modifying tables.

To be safe, always make sure you run your own backup of any tables before modifying or cleaning them with any scripts or queries.

I think they are referring to:

http://github.com/mangos/mangos/commit/1d1ec20a02eccb9fb3fd43156146f7e71b482c19

[Unkle Nuke]

The principles still apply, the only real difference is the cleaner is now built into the core (and it's about time! lol).