Character Table

Help and Support Help and Support
1

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

2

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

3

is there any way to convert it so I don’t loose my progression?

4

So run that in to my current/old database then extract the accounts + character data?

5

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.

6

Okay so like I said just run it through the old db then extract it will be fine?

7

It will default the characters settings to “0”.

8

that is fine I can confiure them when I am in game with the admin commands :slight_smile:

9

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

10

just me atm

11

Another problem now the character aura table there is no itemguid shall I just delete that data from the query?

12

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?

13

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.

14

try this

[FONT=‘Courier New’] git log – sql/updates/characters/[/FONT]