Arcemu Database to Hearthstone

[LJwow]

I tryed a convertor, The one who is in RivalDB i use the arcemu version of rivalDB. Im trying to get it to aspire but the core is 3.1.1 im sure because with a new database it works. Anybody knows how i could mayby fix this problem. When i try to login it says: The information u entered is vailed.. Im 100% sure its correct.

[LJwow]

I want to keep all my old information on the database and update it to 3.1.1 if its possible.

[y2kss66]

there is a convertor in the aspire svn.

svn://svn.aspiredev.org/AspireCore/branches/3_1_0/sql/converters

you should be able to keep your old db and just convert with these. although sometimes they may not work. but they should.

[LJwow]

Yes there are some inside but theres only 1 from arcemu to aspire only the characters.

[y2kss66]

alright here is another:

AspireDev.org - Login

RivalDB - Revision 244: /Developement/changesets <--- this one works.

[kreegoth]

I found that one to still have many problems.. Aspire's DB is VERY different than Arcemu's now..

They have removed the Playerglyphs and playerspells from the character table and made
independant tables for them. I dont see how its going to be possible to get the info from the character table to the right format in the playerspells table or otherwise with a single easy to use converter.

After using the Converter directly from Aspire there were still many manual edits needed ( not that im knocking Aspire attempts to make a converter) just pointing out the difficulties in it.

Arcemus Quests tables still have extra columns that aspires doesnt

And a few more changes that were not included like Aspire requires total_talentpoints instead of available_talentpoints ( cant remember exact names but thats close)

Aspire also has a few columns that didnt get added that Arcemu doesnt have like in the char table i needed to add the last 2 columns for Active_spec and another to do with dual specs( I can understand why Arc doesnt use these columns obviously as they are still working on 3.09) Also there were other columns in the characters table that i cant remember atm i think it had to do with finisheddailies or something. Also one of the Talent point columns needed to be removed or the count was off and all the chars spells were given to him/her as Auras

But overall the converter did a very good job its just there are things that need to be manually edited.


Atm if you convert your DB to Aspire from arcemu Players that are currently in the DB log in with no spells in their spellbooks.. they can learn them all again at the Trainers but they do not even have the normal starter spells such as Attack or shoot or Autoshot racial abilities Etc.

[kreegoth]

Well if you examine the tables on the aspire logon structure and World Structure NIghtfoxx you can make the changes i listed above and few extra ones i probably forgot and get it to so that it loads correctly and you can log in but as i said the player spells and such are still messed up.

its gonna take a lot more work than just running that converter query.