diff options
| author | Killyana <morphone1@gmail.com> | 2018-09-11 01:11:15 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-10-27 00:01:53 +0200 |
| commit | 496d017bac83742b3e13a9cd795996f0c44c6c49 (patch) | |
| tree | ea0df814d5a90db737b5fab4601ccad47f0a6d0a | |
| parent | 175f210e912a010cea9d912da4f5d3e7d22bdfcd (diff) | |
DB/Spell/Item: The Ancient Frostsaber and the Nightsaber
Closes #8194
(cherry picked from commit 8f91a85aaa789276e0b9a6486ae96b978ec281d9)
| -rw-r--r-- | sql/updates/world/master/2021_10_26_04_world_2018_09_11_00_world.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_10_26_04_world_2018_09_11_00_world.sql b/sql/updates/world/master/2021_10_26_04_world_2018_09_11_00_world.sql new file mode 100644 index 00000000000..0bf494a2349 --- /dev/null +++ b/sql/updates/world/master/2021_10_26_04_world_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'); |