Faction Change Transition Information for
-
Argent Tournament Achievements
-
Reins of the Grand Black War Mammoth
not been tested thus far, but should work.
[CODE]-- argent tournament achievements
DELETE FROM player_factionchange_achievement WHERE alliance_id IN (2781, 2764, 2780, 2763, 2777, 2760, 2778, 2761, 2779, 2762, 3676, 2782, 2817);
INSERT INTO player_factionchange_achievement (alliance_id, horde_id) VALUES
(2781, 2783), – Champion of Stormwind/Orgrimmar
(2764, 2765), – Exalted […]
(2780, 2786), – Champion of Ironforge/Thunder Bluff
(2763, 2768), – Exalted […]
(2777, 2787), – Champion of Darnassus/Undercity
(2760, 2769), – Exalted […]
(2778, 2785), – Champion of Exodar/Silvermoon
(2761, 2767), – Exalted […]
(2779, 2784), – Champion of Gnomeregan/Senjin
(2762, 2766), – Exalted […]
(3676, 3677), – The Silver Covenant / The Sunreavers
(2782, 2788), – Champion of the Alliance / Champion of the Horde
(2817, 2816); – Exalted […]
– exchange alliance/horde mount from vault of archavon (item + spell)
DELETE FROM player_factionchange_items WHERE alliance_id = 43959 AND horde_id = 44083;
INSERT INTO player_factionchange_items (race_A, alliance_id, commentA, race_H, horde_id, commentH) VALUES
(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 = 61465 AND horde_id = 61467;
INSERT INTO player_factionchange_spells (alliance_id, horde_id) VALUES
(61465, 61467); – Grand Black War Mammoth
[/sql][/CODE]