diff options
| author | DDuarte <dnpd.dd@gmail.com> | 2015-07-03 01:33:52 +0100 |
|---|---|---|
| committer | DDuarte <dnpd.dd@gmail.com> | 2015-07-03 01:33:52 +0100 |
| commit | df15f87a9a2733a31149c9d3b6557ab644fc0ae8 (patch) | |
| tree | deac49aca217ea189e37703658954c473c4a472f | |
| parent | dbf51eee460ff7dad0110f2f2f4fde654e25033d (diff) | |
DB/Schema: Increase size of ConditionValueX fields in `world`.`conditions`
Required by bigger masks due to new races in MoP
| -rw-r--r-- | sql/updates/world/2015_04_18_01_world_6x.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/2015_07_03_06_world.sql | 7 |
2 files changed, 8 insertions, 1 deletions
diff --git a/sql/updates/world/2015_04_18_01_world_6x.sql b/sql/updates/world/2015_04_18_01_world_6x.sql index 3a351b5a257..9d066fe4a24 100644 --- a/sql/updates/world/2015_04_18_01_world_6x.sql +++ b/sql/updates/world/2015_04_18_01_world_6x.sql @@ -17,7 +17,7 @@ INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`, (15,10144,1,0,27,77,3,0,0,'','The player must be level 77 or higher', 0), (15,10144,1,0,25,54197,0,0,0,'','Show the gossip if the player doesn''t learn Cold Weather Flying', 1), (15,10144,1,0,2,44229,1,1,0,'','Show the gossip if the player doesn''t have the item', 1), -(15,10144,1,0,16,33555378,0,0,0,'','Show the gossip if the player is from the horde', 0), +-- (15,10144,1,0,16,33555378,0,0,0,'','Show the gossip if the player is from the horde', 0), (14,10144,14088,0,27,77,3,0,0,'','Show the text if the player is level 77 or higher', 0), (14,10144,14088,0,25,54197,0,0,0,'','Show the text if the player doesn''t learn Cold Weather Flying', 1), (14,10144,14088,0,2,44221,1,1,0,'','Show the text if the player doesn''t have the item', 1), diff --git a/sql/updates/world/2015_07_03_06_world.sql b/sql/updates/world/2015_07_03_06_world.sql new file mode 100644 index 00000000000..1bf28459b1b --- /dev/null +++ b/sql/updates/world/2015_07_03_06_world.sql @@ -0,0 +1,7 @@ +ALTER TABLE `conditions` CHANGE `ConditionValue1` `ConditionValue1` INT(10) UNSIGNED NOT NULL DEFAULT '0'; +ALTER TABLE `conditions` CHANGE `ConditionValue2` `ConditionValue2` INT(10) UNSIGNED NOT NULL DEFAULT '0'; +ALTER TABLE `conditions` CHANGE `ConditionValue3` `ConditionValue3` INT(10) UNSIGNED NOT NULL DEFAULT '0'; + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=10144 AND `SourceEntry`=1 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=16; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`,`NegativeCondition`) VALUES +(15,10144,1,0,16,33555378,0,0,0,'','Show the gossip if the player is from the horde', 0); |