A few more northrend mammoth exchanges upon faction change.
has to some degree been tested.
[CODE]-- exchange mammoth mounts (item + spell)
DELETE FROM player_factionchange_itemsWHERE alliance_id IN (43956, 43961, 43958, 44235, 44230, 43959) AND horde_id IN (44077, 44086, 44080, 44234, 44231, 44083);
INSERT INTO player_factionchange_items (race_A, alliance_id, commentA, race_H, horde_id, commentH) VALUES
(0, 43956, ‘Reins of the Black War Mammoth(40)’, 0, 44077, ‘Reins of the Black War Mammoth(40)’),
(0, 43961, ‘Reins of the Grand Ice Mammoth(40)’, 0, 44086, ‘Reins of the Grand Ice Mammoth(40)’),
(0, 43958, ‘Reins of the Ice Mammoth(40)’, 0, 44080, ‘Reins of the Ice Mammoth(40)’),
(0, 44235, ‘Reins of the Traveler’‘s Tundra Mammoth(40)’, 0, 44234, ‘Reins of the Traveler’‘s Tundra Mammoth(40)’),
(0, 44230, ‘Reins of the Wooly Mammoth(40)’, 0, 44231, ‘Reins of the Wooly Mammoth(40)’),
(0, 43959, ‘Reins of the Grand Black War Mammoth(40)’, 0, 44083, ‘Reins of the Grand Black War Mammoth(40)’);
DELETE FROM player_factionchange_spells WHERE alliance_id IN (59785, 61470, 59799, 61425, 59791, 61465) AND horde_id IN (59788, 61469, 59797, 61447, 59793, 61467);
INSERT INTO player_factionchange_spells (alliance_id, horde_id) VALUES
(59785, 59788), – black war
(61470, 61469), – grand ice
(59799, 59797), – ice
(61425, 61447), – travelers tundra
(59791, 59793), – wooly
(61465, 61467); – grand black war[/sql][/CODE]