diff options
| author | Shauren <shauren.trinity@gmail.com> | 2012-05-31 15:39:18 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2012-05-31 15:39:18 +0200 |
| commit | 5eee40249c51b35719a18907da94d64d98f89258 (patch) | |
| tree | c599a974f1734a2eedceaeab38764d3f87a88aa3 /sql | |
| parent | b5443af772f54800321a30cc789cfa6ae85c5188 (diff) | |
Core/Items: Added custom flags field to item_template, currently 2 flag values are available
* ITEM_FLAGS_CU_DURATION_REAL_TIME determines item duration counts even if offline (replaced ugly negative duration workaround, easy to lose data when importing fresh wdb)
* ITEM_FLAGS_CU_IGNORE_QUEST_STATUS quest status will not affect this item appearing in loot, currently needed for Arena Master trinket
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2012_05_31_01_world_item_template.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/2012_05_31_01_world_item_template.sql b/sql/updates/world/2012_05_31_01_world_item_template.sql new file mode 100644 index 00000000000..144ee6715a9 --- /dev/null +++ b/sql/updates/world/2012_05_31_01_world_item_template.sql @@ -0,0 +1,4 @@ +ALTER TABLE `item_template` ADD `flagsCustom` INT(10) UNSIGNED NOT NULL DEFAULT 0 AFTER `maxMoneyLoot`; +UPDATE `item_template` SET `flagsCustom`=`flagsCustom`|0x1 WHERE `Duration`<0; +UPDATE `item_template` SET `duration`=ABS(`duration`); +ALTER TABLE `item_template` CHANGE `Duration` `duration` INT(10) UNSIGNED NOT NULL DEFAULT 0 AFTER `ArmorDamageModifier`; |