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.