Titles On Everyone?

[yasuno]

Hello, after i did the recent updated with moving everything from the data field into its own column. Me and my testers have found out that everyone has my titles?!

I am not sure how this is possible, All brand new characters AFTER the update do not start with the titles. All characters before the update, started with all my titles even if they have never had a title on that character.

I find this quite odd, there must be a error some where while its extracting?

Instead of applying that chars titles, to that char, its taking titles and applying them every where. I dont understand it..

[Wowka321]

This sql restore titles.

UPDATE characters, data_backup

SET characters.knownTitles = SUBSTRING(data_backup.data,

length(SUBSTRING_INDEX(data_backup.data, ' ', 626))+2,

length(SUBSTRING_INDEX(data_backup.data, ' ', 631+1))- length(SUBSTRING_INDEX(data_backup.data, ' ', 626)) - 1) WHERE characters.guid=data_backup.guid;