aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2018-09-11 01:11:15 +0200
committerKillyana <morphone1@gmail.com>2018-09-11 01:11:15 +0200
commit8f91a85aaa789276e0b9a6486ae96b978ec281d9 (patch)
treed63cadd433b326d477aa44a94f3e2ce64a49d1c0
parent8f60d48ea96b4677576127ece8007be9c8862a23 (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.sql9
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');