diff options
| author | Rushor <PBienati@web.de> | 2015-03-16 18:34:35 +0100 |
|---|---|---|
| committer | Rushor <PBienati@web.de> | 2015-03-16 18:34:35 +0100 |
| commit | 37462b1f785af2afc44e683850695f1da54f7cd2 (patch) | |
| tree | abefc7907a5526dca1b5b3a664b7e9d743ddaf7f | |
| parent | 69f89144ddf9e297789cf67613a6bb2af204aaf7 (diff) | |
DB/Creature: Darnell
by @Exodius and @Killyana
closes #13761
| -rw-r--r-- | sql/updates/world/2015_03_16_06_world.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/2015_03_16_06_world.sql b/sql/updates/world/2015_03_16_06_world.sql new file mode 100644 index 00000000000..b36f8c6e2d6 --- /dev/null +++ b/sql/updates/world/2015_03_16_06_world.sql @@ -0,0 +1,13 @@ +-- +SET @GUID := 286259; -- Set by TC +DELETE FROM `creature` WHERE `guid`=@GUID; +INSERT INTO `creature` (`guid`, `id`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`) VALUES +(@GUID, 49425, 1, 1, 1962.828, 1417.599, 67.46286, 3.560472, 120); + +DELETE FROM `creature_template_addon` WHERE `entry`=49425; +INSERT INTO `creature_template_addon` (`entry`, `bytes1`, `bytes2`, `auras`) VALUES +(49425, 65536, 0, "49415"); + +DELETE FROM `spell_area` WHERE spell=49417 AND AREA=154; +INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `racemask`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES +(49417, 154, 24970, 24971, 16, 1, 66, 11); |