* Add query to 5036_character_updates_dual_spec.sql to prevent loss of glyphs on players from transition to dual spec.

Note: has no effect on characters after r5036

--HG--
branch : trunk

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;