From bbc649a45f1316c9690859ad3ead6222bfc5b7fb Mon Sep 17 00:00:00 2001 From: Odyssey Date: Sun, 29 Jul 2012 02:47:56 +0100 Subject: DB/Faction Change: Faction change item/spell conversion for Reins of the Traveler's Tundra Mammoth Closes #7174 Signed-off-by: Nay --- sql/updates/world/2012_07_29_00_world_factionchange.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 sql/updates/world/2012_07_29_00_world_factionchange.sql (limited to 'sql') diff --git a/sql/updates/world/2012_07_29_00_world_factionchange.sql b/sql/updates/world/2012_07_29_00_world_factionchange.sql new file mode 100644 index 00000000000..ca6c36630bc --- /dev/null +++ b/sql/updates/world/2012_07_29_00_world_factionchange.sql @@ -0,0 +1,9 @@ +-- Faction change item conversion for Reins of the Traveler's Tundra Mammoth +DELETE FROM `player_factionchange_items` WHERE `alliance_id`=44235; +INSERT INTO `player_factionchange_items` (`race_A`, `alliance_id`, `commentA`, `race_H`, `horde_id`, `commentH`) VALUES +(0,44235,'Reins of the Traveler''s Tundra Mammoth',0,44234,'Reins of the Traveler''s Tundra Mammoth'); + +-- Faction change spell conversion for Reins of the Traveler's Tundra Mammoth +DELETE FROM `player_factionchange_spells` WHERE `alliance_id`=61425; +INSERT INTO `player_factionchange_spells` (`alliance_id`,`horde_id`) VALUES +(61425,61447); -- cgit v1.2.3