Core/Items: Added loading and saving transmogrification.

1 files changed, 11 insertions, 0 deletions

diff --git a/sql/updates/characters/2012_08_01_00_characters_item_instance_434.sql b/sql/updates/characters/2012_08_01_00_characters_item_instance_434.sql
new file mode 100644
index 00000000000..b87b781e293
--- /dev/null
+++ b/sql/updates/characters/2012_08_01_00_characters_item_instance_434.sql
@@ -0,0 +1,11 @@
+UPDATE `item_instance` SET `enchantments` = REPLACE(`enchantments`,'  ',' ');
+UPDATE `item_instance` SET `enchantments` = CONCAT(TRIM(`enchantments`),' ');
+
+UPDATE `item_instance` SET `enchantments` = CONCAT(
+    SUBSTRING_INDEX(`enchantments`, ' ', 7*3),
+    ' 0 0 0 0 0 0 0 0 0 ',
+    SUBSTRING_INDEX(`enchantments`, ' ', -(12-7)*3 - 1))
+WHERE (LENGTH(`enchantments`) - LENGTH(REPLACE(`enchantments`, ' ', ''))) = 12*3;
+
+UPDATE `item_instance` SET `enchantments` = REPLACE(`enchantments`,'  ',' ');
+UPDATE `item_instance` SET `enchantments` = CONCAT(TRIM(`enchantments`),' ');