Small tool to order item guids used in VMangos character database. Affected tables:
character_inventory
mail_items
item_instance
Each run also clears out tables related to last world sessions. Affected tables:
creature_respawn
gameobject_respawn
character_spell_cooldown
pet_spell_cooldown
Backup your character db before continuing!
Example: intellij IDE
- File -> Project Structure... -> Modules -> select Dependencies tab
- press [+] -> Add JARs or Directories -> select mysql-connector-java-5.1.49.jar from lib folder
- apply, done.
Enter database user, password and location into gui fields. Press run button.
All item guids at item_instance
are ordered.
Any items which could not be linked to any character
(becasue character was deleted, or a bot ,...) have been removed.
Before run:
- character with guid 1 has items with guids 2,50,767,800
- character with guid 2 has items with guids 5,23,77,9000
After run:
- character with guid 1 has items with guids 1,2,3,4
- character with guid 2 has items with guids 5,6,7,8