diff options
| author | Shauren <shauren.trinity@gmail.com> | 2016-06-24 23:12:03 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2016-06-24 23:12:03 +0200 |
| commit | 2ad96f06f03d8319daf4b142f5b343081133e939 (patch) | |
| tree | 8006113fe32dfc806dd84a8c8717e45ff6bc601e /sql | |
| parent | 103a6998fc2cefa6976ef5b148fac5d38828114f (diff) | |
Core/PacketIO: Updated quest packets
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2016_xx_xx_xx_world_legion_02.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/2016_xx_xx_xx_world_legion_02.sql b/sql/updates/world/2016_xx_xx_xx_world_legion_02.sql new file mode 100644 index 00000000000..c4b7fca6d19 --- /dev/null +++ b/sql/updates/world/2016_xx_xx_xx_world_legion_02.sql @@ -0,0 +1,14 @@ +ALTER TABLE `quest_template` + CHANGE `RewardDisplaySpell` `RewardDisplaySpell1` int(10) unsigned NOT NULL DEFAULT '0' AFTER `RewardBonusMoney`, + ADD `RewardDisplaySpell2` int(10) unsigned NOT NULL DEFAULT '0' AFTER `RewardDisplaySpell1`, + ADD `RewardDisplaySpell3` int(10) unsigned NOT NULL DEFAULT '0' AFTER `RewardDisplaySpell2`, + ADD `RewardArtifactXPDifficulty` int(10) unsigned NOT NULL DEFAULT '0' AFTER `StartItem`, + ADD `RewardArtifactXPMultiplier` float NOT NULL DEFAULT '1' AFTER `RewardArtifactXPDifficulty`, + ADD `RewardArtifactCategoryID` int(10) unsigned NOT NULL DEFAULT '0' AFTER `RewardArtifactXPMultiplier`, + DROP `RewardTalents`, + ADD `RewardFactionCapIn1` int(10) unsigned NOT NULL DEFAULT '0' AFTER `RewardFactionOverride1`, + ADD `RewardFactionCapIn2` int(10) unsigned NOT NULL DEFAULT '0' AFTER `RewardFactionOverride2`, + ADD `RewardFactionCapIn3` int(10) unsigned NOT NULL DEFAULT '0' AFTER `RewardFactionOverride3`, + ADD `RewardFactionCapIn4` int(10) unsigned NOT NULL DEFAULT '0' AFTER `RewardFactionOverride4`, + ADD `RewardFactionCapIn5` int(10) unsigned NOT NULL DEFAULT '0' AFTER `RewardFactionOverride5`, + ADD `QuestRewardID` int(10) unsigned NOT NULL DEFAULT '0' AFTER `AllowableRaces`; |