diff options
author | Killyana <morphone1@gmail.com> | 2018-09-11 01:11:15 +0200 |
---|---|---|
committer | Killyana <morphone1@gmail.com> | 2018-09-11 01:11:15 +0200 |
commit | 8f91a85aaa789276e0b9a6486ae96b978ec281d9 (patch) | |
tree | d63cadd433b326d477aa44a94f3e2ce64a49d1c0 | |
parent | 8f60d48ea96b4677576127ece8007be9c8862a23 (diff) |
DB/Spell/Item: The Ancient Frostsaber and the Nightsaber
Closes #8194
-rw-r--r-- | sql/updates/world/3.3.5/2018_09_11_00_world.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_09_11_00_world.sql b/sql/updates/world/3.3.5/2018_09_11_00_world.sql new file mode 100644 index 00000000000..0bf494a2349 --- /dev/null +++ b/sql/updates/world/3.3.5/2018_09_11_00_world.sql @@ -0,0 +1,9 @@ +-- +DELETE FROM `player_factionchange_spells` WHERE `alliance_id` IN (16056, 16055); +INSERT INTO `player_factionchange_spells` (`alliance_id`, `horde_id`) VALUES +(16056, 18991), (16055, 18992); + +DELETE FROM `player_factionchange_items` WHERE `alliance_id` IN (12302,12303); +INSERT INTO `player_factionchange_items` (`race_A`, `alliance_id`, `commentA`, `race_H`, `horde_id`, `commentH`) VALUE +(0, 12302, 'Reins of the Ancient Frostsaber', 0, 15292, 'Green Kodo'), +(0, 12303, 'Reins of the Nightsaber', 0, 15293, 'Teal Kodo'); |