diff options
| author | Killyana <morphone1@gmail.com> | 2015-10-18 01:23:35 +0200 |
|---|---|---|
| committer | MitchesD <majklprofik@seznam.cz> | 2015-11-06 10:27:48 +0100 |
| commit | 4fddbe3fcfc23862a042fe4b12f701fdf198416e (patch) | |
| tree | 3113c3e8c4837306f71204b32018387b7b1065cb | |
| parent | d9f1571efa95d274d5aecff65c3eb0b1a986c0b2 (diff) | |
DB/Creature: Add missing npcs in Dalaran
(cherry picked from commit 8ff619ddc40fee1739125e91d20b519078c3f2fb)
| -rw-r--r-- | sql/updates/world/2015_11_06_10_world_2015_10_17_02.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/sql/updates/world/2015_11_06_10_world_2015_10_17_02.sql b/sql/updates/world/2015_11_06_10_world_2015_10_17_02.sql new file mode 100644 index 00000000000..3c39921bf60 --- /dev/null +++ b/sql/updates/world/2015_11_06_10_world_2015_10_17_02.sql @@ -0,0 +1,15 @@ +-- +UPDATE `creature` SET `position_x`=5832.238, `position_y`=564.013611, `position_z`=651.771301, `Orientation`=2.596493 WHERE `guid`=105661; +UPDATE `creature_addon` SET `auras`=60191 WHERE `guid` IN (105661, 103039); +DELETE FROM `creature_addon` WHERE `guid` IN (115295, 48251,48252,48253); +INSERT INTO `creature_addon` (`guid`, `bytes1`, `bytes2`, `auras`) VALUES +(115295,65536,1,60191), +(48251,65536,1,60190), +(48252,65536,1,60190), +(48253,65536,1,60190); + +DELETE FROM `creature` WHERE `guid` IN (48251,48252,48253); +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseId`, `position_x`, `position_y`, `position_z`, `Orientation`, `spawntimesecs`) VALUES +(48251, 31851, 571, 1, 169, 5832.240, 564.0139, 651.77099, 2.596490,300), +(48252, 32335, 571, 1, 169, 5833.799, 567.3480, 651.92498, 2.460910,300), +(48253, 32206, 571, 1, 169, 5836.709, 570.0759, 652.10797, 2.146750,300); |