bblewittAGA Posted April 9, 2017 Report Share Posted April 9, 2017 I am moving over all my accounts from 1 database of the TDB 59 to the TDB 62 core and there is skin, face, hair and facial hair coloums not playerbytes 1 and 2? Branch: 3.3.5a TrinityCore rev. f852667+ 2017-04-08 21:47:38 +0200 (3.3.5 branch) (Win64, Release, Static) (worldserver-daemon) TDB 335.62 Windows 10 x64 Link to comment Share on other sites More sharing options...
CDawg Posted April 9, 2017 Report Share Posted April 9, 2017 That was changed over a year ago https://github.com/TrinityCore/TrinityCore/blob/a249d86b00eb0854cb925f8bea76ddbb364208df/sql/old/6.x/characters/03_2016_04_11/2016_01_05_00_characters.sql Link to comment Share on other sites More sharing options...
bblewittAGA Posted April 9, 2017 Author Report Share Posted April 9, 2017 is there any way to convert it so I don't loose my progression? Link to comment Share on other sites More sharing options...
bblewittAGA Posted April 9, 2017 Author Report Share Posted April 9, 2017 So run that in to my current/old database then extract the accounts + character data? Link to comment Share on other sites More sharing options...
CDawg Posted April 9, 2017 Report Share Posted April 9, 2017 I created a script that converted it. I'm looking for it. It's been awhile. But what I did was, defaulted the hairStyle, hairColor, etc., etc, to "0"; Then I ran a script that matched the GUID to each and did a php explode for each PlayerBytes1 & 2, and converted it that way. Link to comment Share on other sites More sharing options...
bblewittAGA Posted April 9, 2017 Author Report Share Posted April 9, 2017 Okay so like I said just run it through the old db then extract it will be fine? Link to comment Share on other sites More sharing options...
CDawg Posted April 9, 2017 Report Share Posted April 9, 2017 It will default the characters settings to "0". Link to comment Share on other sites More sharing options...
bblewittAGA Posted April 9, 2017 Author Report Share Posted April 9, 2017 that is fine I can confiure them when I am in game with the admin commands Link to comment Share on other sites More sharing options...
CDawg Posted April 9, 2017 Report Share Posted April 9, 2017 If you have friends that play, and you decide to force the settings to 0, you can also force "at_login" to 8. That way your friends can customize their characters on the new table. https://trinitycore.atlassian.net/wiki/pages/viewpage.action?pageId=2129969#characters(table)-at_login Good luck Link to comment Share on other sites More sharing options...
bblewittAGA Posted April 9, 2017 Author Report Share Posted April 9, 2017 just me atm Link to comment Share on other sites More sharing options...
bblewittAGA Posted April 9, 2017 Author Report Share Posted April 9, 2017 Another problem now the character aura table there is no itemguid shall I just delete that data from the query? Link to comment Share on other sites More sharing options...
bblewittAGA Posted April 9, 2017 Author Report Share Posted April 9, 2017 my character inventory is not being transferred? I have inputted into the database and when I load up the game and server it has all gone? close the server down and my client and look in the database and it is empty? Link to comment Share on other sites More sharing options...
CDawg Posted April 9, 2017 Report Share Posted April 9, 2017 There have been a ton of changes to the architect of the db over a year span and It's really difficult to go over each column/table change without updates. One thing that you could try is to go each database change commit from the past to your version/commit, then to run each update or dissect each change that was made over the year and few months. https://github.com/TrinityCore/TrinityCore/search?l=SQL&q=sql&type=&utf8=✓ also be sure to just check 3.3.5a for those update changes and may have to manually do each change. Link to comment Share on other sites More sharing options...
CDawg Posted April 9, 2017 Report Share Posted April 9, 2017 try this git log -- sql/updates/characters/ Link to comment Share on other sites More sharing options...
Recommended Posts