diff options
| -rw-r--r-- | sql/updates/5036_character_updates_dual_spec.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/5036_character_updates_dual_spec.sql b/sql/updates/5036_character_updates_dual_spec.sql index 5db569a04b1..545420407fe 100644 --- a/sql/updates/5036_character_updates_dual_spec.sql +++ b/sql/updates/5036_character_updates_dual_spec.sql @@ -13,6 +13,17 @@ CREATE TABLE `character_glyphs` ( PRIMARY KEY (`guid`,`spec`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +-- Get glyphs from correct field in data blob and insert into character_glyphs as spec = 0 +INSERT INTO `character_glyphs` +SELECT `guid`, 0, +(CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1288), ' ', -1) AS UNSIGNED)) AS `glyph1`, +(CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1289), ' ', -1) AS UNSIGNED)) AS `glyph2`, +(CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1290), ' ', -1) AS UNSIGNED)) AS `glyph3`, +(CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1291), ' ', -1) AS UNSIGNED)) AS `glyph4`, +(CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1292), ' ', -1) AS UNSIGNED)) AS `glyph5`, +(CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1293), ' ', -1) AS UNSIGNED)) AS `glyph6` +FROM `characters`; + CREATE TABLE `character_talent` ( `guid` int(11) unsigned NOT NULL, `spell` int(11) unsigned NOT NULL, @@ -44,4 +55,5 @@ CREATE TABLE `character_action` ( INSERT INTO `character_action` (`guid`,`button`,`action`,`type`) SELECT `guid`,`button`,`action`,`type` FROM `character_action_old`; DROP TABLE `character_action_old`; + COMMIT; |