Jump to content
TrinityCore

Character Table


bblewittAGA
 Share

Recommended Posts

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

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

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

 Share

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...