aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/2014_11_19_01_world.sql15
1 files changed, 15 insertions, 0 deletions
diff --git a/sql/updates/world/2014_11_19_01_world.sql b/sql/updates/world/2014_11_19_01_world.sql
new file mode 100644
index 00000000000..3019db4045f
--- /dev/null
+++ b/sql/updates/world/2014_11_19_01_world.sql
@@ -0,0 +1,15 @@
+DELETE FROM `player_factionchange_reputations` WHERE `alliance_id` IN (1134, 1174, 1242, 1353, 1376, 1387, 1419, 1682, 1691, 1710, 1731, 1733, 1738);
+INSERT INTO `player_factionchange_reputations` (`alliance_id`, `horde_id`) VALUES
+(1134, 1133), -- Gilneas <-> Bilgewater Cartel
+(1174, 1172), -- Wildhammer Clan <-> Dragonmaw Clan
+(1242, 1228), -- Pearlfin Jinyu <-> Forest Hozen
+(1353, 1352), -- Tushui Pandaren <-> Huojin Pandaren
+(1376, 1375), -- Operation: Shieldwall <-> Dominance Offensive
+(1387, 1388), -- Kirin Tor Offensive <-> Sunreaver Onslaught
+(1419, 1374), -- Bizmo's Brawlpub (Season 1) <-> Brawl'gar Arena (Season 1)
+(1682, 1681), -- Wrynn's Vanguard <-> Vol'jin's Spear
+(1691, 1690), -- Bizmo's Brawlpub <-> Brawl'gar Arena
+(1710, 1708), -- Sha'tari Defense <-> Laughing Skull Orcs
+(1731, 1445), -- Council of Exarchs <-> Frostwolf Orcs
+(1733, 1739), -- Delvar Ironfist <-> Vivianne
+(1738, 1740); -- Defender Illona <-> Aeda Brightdawn