aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/2012_01_27_00_player_factionchange_items.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/2012_01_27_00_player_factionchange_items.sql b/sql/updates/world/2012_01_27_00_player_factionchange_items.sql
new file mode 100644
index 00000000000..1dc2749807e
--- /dev/null
+++ b/sql/updates/world/2012_01_27_00_player_factionchange_items.sql
@@ -0,0 +1,4 @@
+-- DB/Faction change: Add some missing items
+DELETE FROM `player_factionchange_items` WHERE `alliance_id` IN (47711) AND horde_id IN (47870);
+INSERT INTO `player_factionchange_items` (`race_A`,`alliance_id`,`commentA`,`race_H`,`horde_id`,`commentH`) VALUES
+(0,47711, 'Girdle of the Nether Champion',0,47870, 'Belt of the Nether Championt');