Converting my old characters

provocating · #1 12-22-2010, 10:27 AM

Thought I would convert my old characters and bots over today. I wrote some SQL and everything seemed to convert over, or I thought. I have the characters with exactly the same Account ID but they do not show up. I created a new character since the character list is empty, brought him in the game and logged out. I compared with table entry with my converted ones and by all means the others should show up. Here is a little of the data from Characters. If I copy the entire thing then the profile will make this post huge.

Code:

INSERT INTO `unknown` (`id`, `account_id`, `name`, `class`, `level`, `lfp`, `lfg`) VALUES (4, 2, 'Provocating', 13, 65, 0, 0);
INSERT INTO `unknown` (`id`, `account_id`, `name`, `class`, `level`, `lfp`, `lfg`) VALUES (38, 2, 'NewGuy', 1, 1, 0, 0);

The account id's are the same, and in the past I thought that was all that was needed to bring over old accounts.

provocating · #2 12-22-2010, 10:48 AM

Okay, I know now it is the profile field.

How do I fix this ? Is there a way to convert, obviously it has changed formats.