From 26c7773503092569537e46ea05de23a0179fbf05 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Mon, 7 Nov 2011 17:11:09 +0100 Subject: DB/Faction change: Add some missing items --- .../world/2011_11_06_00_world_player_factionchange_items.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/2011_11_06_00_world_player_factionchange_items.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2011_11_06_00_world_player_factionchange_items.sql b/sql/updates/world/2011_11_06_00_world_player_factionchange_items.sql new file mode 100644 index 00000000000..e839a065dcc --- /dev/null +++ b/sql/updates/world/2011_11_06_00_world_player_factionchange_items.sql @@ -0,0 +1,6 @@ +INSERT INTO `player_factionchange_items` (`race_A`, `alliance_id`, `commentA`, `race_H`, `horde_id`, `commentH`) VALUES +('0', '48076', 'Velen\'s Mantle of Conquest', '0', '48101', 'Zabra\'s Mantle of Conquest'), +('0', '48075', 'Velen\'s Raiments of Conquest', '0', '48100', 'Zabra\'s Raiments of Conquest'), +('0', '48074', 'Velen\'s Pants of Conquest', '0', '48099', 'Zabra\'s Pants of Conquest'), +('0', '48072', 'Velen\'s Handwraps of Conquest', '0', '48097', 'Zabra\'s Handwraps of Conquest'), +('0', '48073', 'Velen\'s Circlet of Conquest', '0', '48098', 'Zabra\'s Circlet of Conquest '); -- cgit v1.2.3 From e123210c5400daaf0665112618d58838452169cb Mon Sep 17 00:00:00 2001 From: Aokromes Date: Mon, 7 Nov 2011 17:12:19 +0100 Subject: DB:Areatrigger teleport: Fix orientation of triggers from AQ40 --- sql/updates/world/2011_11_06_01_world_areatrigger_teleport.sql | 3 +++ 1 file changed, 3 insertions(+) create mode 100644 sql/updates/world/2011_11_06_01_world_areatrigger_teleport.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2011_11_06_01_world_areatrigger_teleport.sql b/sql/updates/world/2011_11_06_01_world_areatrigger_teleport.sql new file mode 100644 index 00000000000..7a0dd8200b4 --- /dev/null +++ b/sql/updates/world/2011_11_06_01_world_areatrigger_teleport.sql @@ -0,0 +1,3 @@ +-- Correct AQ40's areatrigger_teleport orientation +UPDATE `areatrigger_teleport` SET `target_position_z`='129.330612', `target_orientation`='0.929912' WHERE `id`=4010; +UPDATE `areatrigger_teleport` SET `target_orientation`='4.030663' WHERE `id`=4012; -- cgit v1.2.3