Carrying over Characters

[elshawn]

From UWC 1.3.0 to Kobold....
Is it as simple as taking them from the ".save" files, and moving them into the database via navicat, or are there more complexities...

[MentaL]

[[lexx]]

no, it isn't

[tr4shm4n]

This is officialy for mangos but maybee it will work for cobold as well . Or you just need to do some editing in tables i dunno .

Hi all,

This is my tool to convert Wad account + characters to Mangos.
This works with build 2302 and up if the database does not change.
2302 is a minimum requirement because it needs table player_levelupgains

You do not need to remove anything from MaNGOS database, wad accounts and characters will be added.
And be patient wink.gif It requires a long time to import larges wad databases (1000+ accounts).

here it is: RapidShare: 1-Click Webhosting
Final version?

Requirement:
Python : http://www.python.org/ftp/python/2.4.3/python-2.4.3.msi
MySQLdb : Browsing Download Server: /mysql-python/MySQL-python.exe-1.2.1_p2.win32-py2.4.exe
PySQLite in you plan to import honor: http://initd.org/pub/software/pysqli...in32-py2.4.exe

Backup your mangos database:
Then you will be able to restore it in case of problem. This is highly recommended.
CODE
mysqldump -u root -p mangos > C:\mangosbackup.sql


Backup your realmd database:
CODE
mysqldump -u root -p realmd > C:\realmdbackup.sql


Configure the import script:
You have to configure the options of the script, edit it and change in configuration section.
Here is the default:
CODE
########################################################################
# Configuration part #
########################################################################

LoginDatabaseInfo="127.0.0.1;3306;mangos;mangos;realmd"
WorldDatabaseInfo="127.0.0.1;3306;mangos;mangos;mangos"

ImportAccountsOnly=0 # Put 1 if you want to import only accounts to MaNGOS
RealmID=1 # Change here the RealmID. If you have only one realm (default), set this value to 1
savepath="saves" # Name of the subfolder containing the wademu save files (players.save, accounts.dat...)
ImportHonor=0 # Put 0 if you do not want to import Honor.
HonorDbName="sqldb.db3" # Name of the SQLite file containing the Honor data
OfferBankSlots=1 # Set to 1 to offer all players the bank slots for free. If you set to 0 all bags on
# these slots and there content will be deleted


Run the import script:
Put the script on the root folder of you WadEmu
Open a command prompt and enter:
CODE
WadToMangos_1.0.py

You are done.

In case you want to restore:
CODE
mysql -u root -p mangos < C:\mangosbackup.sql
mysql -u root -p realmd < C:\realmdbackup.sql


Tool to convert 1.10.2 all characters to 1.12.1 format
This is a tool needed to convert character for MaNGOS 2391 and up (1.12.1 client support).
It is usefull in case you need to convert your 1.10.2 characters from old MaNGOS release to the 1.12.1 one.
here it is: RapidShare: 1-Click Webhosting

Tool to recompute all characters stats to Blizzlike
You can run it as often as you want. If you want to increase/reduce the health or mana, there is a configuration part inside.
here it is: RapidShare: 1-Click Webhosting

WadToMaNGOS script history:
CODE
0.1 24/06/2006 Initial release after long work
0.2 25/06/2006 Corrected some values in 'data' field of 'character' table
Update the script for version 1635 of MaNGOS Core
09/07/2006 Updated for compatiblility with database 1722
0.3 10/07/2006 Added TAUREN size 1.35 thank to dark3ning
11/07/2006 Working even if database is empty and corrected the bug that crashed the client... YES!!!
0.4 12/07/2006 Rewritten the inventory proc and corrected the bag bug :)
Added functionality to import only wademu Accounts and no character
Truncated account name to 16 letters in case it is longer in wademu
Support the localised letters, but the players.save MUST BE in UTF-8
Found and implemented the number of remaining Talent Points (CP)
0.5 13/07/2006 Added a check for DELAY field when it is not in players.save (never played character)
Added a check to not add item instances not linked to a used account
0.6 30/07/2006 Converted all Stat values to Float because of a change in the core (version 1906 now)
Attack power values are now correct (I missed PLAYER_FIELD_MOD_DAMAGE_DONE_PCT)
31/07/2006 Implemented reputation (not working) and added some more checks (character with no name !)
0.7 21/08/2006 Added some checks to prevent errors on missing HAIR, GENDER, XYZ...
Implemented UTF-8 reading of accounts.dat
Begin implemetation of Honor from sqlite db
23/08/2006 Corrected 4 bugs:
- Items on head were not imported
- Item instances owner guid were not in the correct order
- float_to_int and int_to_float function did return non 0 result when converting 0
- Health was not correct
24/08/2006 Corrupted items and characters are not imported at all (for corrupted players.save)
Begin implementation of Guilds migration
0.8 25/08/2006 Last used IP is now loaded from wad account database and added to account table
Switched the account loading from UTF-8 to Latin-1 and added a check for invalid password
Health is now correct with the use of the list 'healthmod'
Mana is now correct also with the use of the list 'powermod'
Guild import fully implemented in full UTF-8
Honor can be imported by setting variables ImportHonor and HonorDbName
Added the option to offer banks slots
------ I consider program stable enough and declare all functionalies implemeted: now release candidate ------
0.9 29/08/2006 Implemented TaxiMask import (not sure it works fine)
Added some Honor missing entries in character table
Corrected Characters loading to be in full UTF-8 format
Implemented imported buttons
1.0 31/08/2006 Created list of 1.8.2 talents no more in 1.10.2 so that they are converted to Talent Points
Added a check for non latin-1 letters in guilds name and motd
06/09/2006 Exported the full list of 1.8 talents to an external file (Talents_18.py), now Talent Tree
is reseted. Removing delta 1.10.2/1.8.2 did not work.
Swaped Configuration part and this ChangeLog part for easy configuration access
07/09/2006 Re-extracted 1.8.2 talents because they can cost 1,2,3,4 or 5 Talent Points. Now working.
Added more database cleaning code so that several imports add less duplicate data.
Switched Character Loading from UTF-8 to Latin1 for more compatibility
Added one more check on WAD Character GUID when players.save is corrupted
1.1 11/09/2006 Truncated eMail @ if longer than 50 letters
14/09/2006 Added code and data to replace info removed from Playercreateinfo table. Work with 2210.
1.2 01/10/2006 Changed again the HP/Mana calculation, now use the table player_levelupgains.
1.2r2 01/10/2006 Changed also all stats, armor and resist. Need 2302 database minimum
1.3 14/10/2006 Corrected some bugs: Spirit value, WorldDB connect, error when account name is not ascii
Moved the support 1.12.1


To do:
CODE
- Import Reputation if someone can tell me the meaning of the values in players.save


Neo2003