aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorVincent-Michael <Vincent_Michael@gmx.de>2013-06-25 18:28:22 +0200
committerVincent-Michael <Vincent_Michael@gmx.de>2013-06-25 18:29:42 +0200
commitb80d09fd6aad61bcceb429c982393d5dd89256fa (patch)
tree0769709996397efd3766560e75f2ee3623ba44d4
parentb23a6d2d00106fa4865049b4061f505af775e5a6 (diff)
DB/FactionChange: Add missing player_factionchange_spells for Black War Bear / Black War Mammoth
-rw-r--r--sql/updates/characters/2013_06_23_00_characters_game_event.sql (renamed from sql/updates/characters/2013_03_23_00_characters_game_event.sql)0
-rw-r--r--sql/updates/world/2013_06_25_00_world_player_factionchange_spells.sql5
2 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/characters/2013_03_23_00_characters_game_event.sql b/sql/updates/characters/2013_06_23_00_characters_game_event.sql
index d8a58832ce1..d8a58832ce1 100644
--- a/sql/updates/characters/2013_03_23_00_characters_game_event.sql
+++ b/sql/updates/characters/2013_06_23_00_characters_game_event.sql
diff --git a/sql/updates/world/2013_06_25_00_world_player_factionchange_spells.sql b/sql/updates/world/2013_06_25_00_world_player_factionchange_spells.sql
new file mode 100644
index 00000000000..ee50f3ea952
--- /dev/null
+++ b/sql/updates/world/2013_06_25_00_world_player_factionchange_spells.sql
@@ -0,0 +1,5 @@
+DELETE FROM `player_factionchange_spells` WHERE `alliance_id`=60118 AND `horde_id`=60119; -- Black War Bear
+DELETE FROM `player_factionchange_spells` WHERE `alliance_id`=59785 AND `horde_id`=59788; -- Black War Mammoth
+INSERT INTO `player_factionchange_spells` (`alliance_id`, `horde_id`) VALUES
+(60118, 60119), -- Black War Bear
+(59785, 59788); -- Black War Mammoth