Core/Items: Updated item stat calculations

* Implemented item modifiers
* Implemented item bonuses

1 files changed, 9 insertions, 0 deletions

diff --git a/sql/updates/characters/2014_12_23_00_characters.sql b/sql/updates/characters/2014_12_23_00_characters.sql
new file mode 100644
index 00000000000..d72d71a3e7b
--- /dev/null
+++ b/sql/updates/characters/2014_12_23_00_characters.sql
@@ -0,0 +1,9 @@
+ALTER TABLE `item_instance`
+  ADD `transmogrification` int(10) unsigned not null default '0' AFTER `text`,
+  ADD `upgradeId` int(10) unsigned not null default '0' AFTER `transmogrification`,
+  ADD `enchantIllusion` int(10) unsigned not null default '0' AFTER `upgradeId`,
+  ADD `bonusListIDs` text AFTER `enchantIllusion`;
+
+UPDATE `item_instance` SET `transmogrification`=SUBSTRING_INDEX(SUBSTRING_INDEX(`enchantments`, ' ', 27 + 1), ' ', -1);
+UPDATE `item_instance` SET `enchantments`=SUBSTRING_INDEX(`enchantments`, ' ', 45); -- trim the field to 15 enchantments
+UPDATE `item_instance` SET `enchantments`=CONCAT(SUBSTRING_INDEX(`enchantments`, ' ', 24), ' ', SUBSTRING_INDEX(`enchantments`, ' ', -15));