diff options
| author | Naddley <NaddleyTC@gmail.com> | 2024-01-30 00:04:25 +0100 |
|---|---|---|
| committer | Naddley <NaddleyTC@gmail.com> | 2024-01-30 00:04:25 +0100 |
| commit | 6bf90be24d0264959c806473c7ce86386d61efcf (patch) | |
| tree | 3e886095a89e75789263bad9ed3d835469a42f75 | |
| parent | 3b5ff702a2760f404038cea00b512baa4b82bce2 (diff) | |
DB/Stormwind: Update positions for Allied Race Emissary spawns
+ added phase names for them
| -rw-r--r-- | sql/updates/world/master/2024_01_30_00_world.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_01_30_00_world.sql b/sql/updates/world/master/2024_01_30_00_world.sql new file mode 100644 index 00000000000..8b7caeecacd --- /dev/null +++ b/sql/updates/world/master/2024_01_30_00_world.sql @@ -0,0 +1,13 @@ +-- Update Position +UPDATE `creature` SET `position_x` = -8200.7705078125, `position_y` = 746.35418701171875, `position_z` = 76.3188934326171875, `orientation` = 0.877556860446929931 WHERE `guid` = 1050136; -- Keira Onyxraven +UPDATE `creature` SET `position_x` = -8200.625, `position_y` = 746.342041015625, `position_z` = 76.33197021484375, `orientation` = 0.724010705947875976 WHERE `guid` = 1050135; -- Vindicator Minkey +UPDATE `creature` SET `position_x` = -8200.59375, `position_y` = 746.27777099609375, `position_z` = 76.33333587646484375, `orientation` = 0.855998575687408447 WHERE `guid` = 850144; -- Mudrik Leger +UPDATE `creature` SET `position_x` = -8200.7548828125, `position_y` = 746.34552001953125, `position_z` = 76.3201904296875, `orientation` = 0.807905077934265136 WHERE `guid` = 850145; -- Lulana + +-- Phase names +DELETE FROM `phase_name` WHERE `ID` IN (10037, 10036, 11867, 14345); +INSERT INTO `phase_name` (`ID`, `Name`) VALUES +(10037, 'Cosmetic - See Keira Onyxraven in Stormwind Embassy'), +(10036, 'Cosmetic - See Vindicator Minkey in Stormwind Embassy'), +(11867, 'Cosmetic - See Mudrik Leger in Stormwind Embassy'), +(14345, 'Cosmetic - See Lulana in Stormwind Embassy'); |