diff options
| author | Killyana <morphone1@gmail.com> | 2015-12-14 18:31:46 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2015-12-14 18:31:46 +0100 |
| commit | 04e0b19cb199b790b9ed613ff8e5450b39865223 (patch) | |
| tree | 1cbb9ec3a2cbeeb7755dfd5928a402031ffd4f09 | |
| parent | 882c9ce9810b2362f7b922cfd964b5d9856d8127 (diff) | |
DB/Creature: Add missing training dummy on Eversong Woods for class quests
| -rw-r--r-- | sql/updates/world/2015_12_14_00_world.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/2015_12_14_00_world.sql b/sql/updates/world/2015_12_14_00_world.sql new file mode 100644 index 00000000000..61aea89e192 --- /dev/null +++ b/sql/updates/world/2015_12_14_00_world.sql @@ -0,0 +1,10 @@ +-- +SET @Guid:=250887; +DELETE FROM `creature` WHERE `id`=44937 AND `guid` BETWEEN @guid+0 AND @guid+5; +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseid`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES +(@guid+0, 44937, 530, 1, 0, 3019, 0, 10325, -6403.6, 37.2317, 2.93215, 300, 0, 0, 142, 0, 0), +(@guid+1, 44937, 530, 1, 0, 3019, 0, 10381.8, -6381.9, 37.8308, 0.977384, 300, 0, 0, 142, 0, 0), +(@guid+2, 44937, 530, 1, 0, 3019, 0, 10328.4, -6393.98, 37.1472, 2.63545, 300, 0, 0, 142, 0, 0), +(@guid+3, 44937, 530, 1, 0, 3019, 0, 10373.3, -6377.87, 37.2858, 1.29154, 300, 0, 0, 142, 0, 0), +(@guid+4, 44937, 530, 1, 0, 3019, 0, 10363.9, -6375.25, 37.0142, 1.58825, 300, 0, 0, 142, 0, 0), +(@guid+5, 44937, 530, 1, 0, 3019, 0, 10334.4, -6386.11, 36.5143, 2.3911, 300, 0, 0, 142, 0, 0); |
