Core/Items: Updated item stat calculations

* Implemented item modifiers
* Implemented item bonuses

2 files changed, 13 insertions, 0 deletions

diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 29f14fa7b39..dff9589e540 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -2213,6 +2213,10 @@ CREATE TABLE `item_instance` (
   `durability` smallint(5) unsigned NOT NULL DEFAULT '0',
   `playedTime` int(10) unsigned NOT NULL DEFAULT '0',
   `text` text,
+  `transmogrification` int(10) unsigned NOT NULL DEFAULT '0',
+  `upgradeId` int(10) unsigned NOT NULL DEFAULT '0',
+  `enchantIllusion` int(10) unsigned NOT NULL DEFAULT '0',
+  `bonusListIDs` text,
   PRIMARY KEY (`guid`),
   KEY `idx_owner_guid` (`owner_guid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Item System';
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));