aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2016-04-09 17:55:19 +0200
committerShauren <shauren.trinity@gmail.com>2016-04-09 18:01:29 +0200
commit2922b00aa668b1219adc5d4e85da5d8bdd5a89ae (patch)
tree1ff7691032b762f0990db780edd1012aef2e6b67
parent417c19bdad585648b717dcae9253d8548db6abee (diff)
DB/Faction: Fix Rivern Frostwind Faction change issue
And fix a DB error By @meji46 Closes #16761 (cherry picked from commit 697749aafc91c004b387389ba9cfcd7a142c763a)
-rw-r--r--sql/updates/world/2016_04_09_29_world_2016_04_09_03_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/2016_04_09_29_world_2016_04_09_03_world.sql b/sql/updates/world/2016_04_09_29_world_2016_04_09_03_world.sql
new file mode 100644
index 00000000000..732e3d83ee5
--- /dev/null
+++ b/sql/updates/world/2016_04_09_29_world_2016_04_09_03_world.sql
@@ -0,0 +1,5 @@
+--
+DELETE FROM `player_factionchange_reputations` WHERE `alliance_id`= 589;
+INSERT INTO `player_factionchange_reputations` (`alliance_id`, `horde_id`) VALUES
+(589, 1137);
+UPDATE `creature` SET `equipment_id`=0 WHERE `id` IN(17404);