DB/Creature: ELM General Purpose Bunny Hide Body (Phase I)

1 files changed, 20 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2019_08_05_05_world.sql b/sql/updates/world/3.3.5/2019_08_05_05_world.sql
new file mode 100644
index 00000000000..e8816141490
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_08_05_05_world.sql
@@ -0,0 +1,20 @@
+-- 
+DELETE FROM `creature` WHERE `guid` IN (116136, 116169, 116170, 116171, 116177, 116178, 116179, 116180, 116188, 116189, 116191, 116192, 116193, 116194, 116198, 116200, 116201) AND `id` IN (29772);
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(116136, 29772, 571, 0, 0, 1, 2, 0, 0, 8244.22, 2765.51, 640.425, 0.174533, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116169, 29772, 571, 0, 0, 1, 2, 0, 0, 8244.79, 2786.84, 641.072, 1.326450, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116170, 29772, 571, 0, 0, 1, 2, 0, 0, 8292.57, 2760.04, 656.108, 6.248280, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116171, 29772, 571, 0, 0, 1, 2, 0, 0, 8294.96, 2782.73, 656.108, 4.817110, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116177, 29772, 571, 0, 0, 1, 2, 0, 0, 8313.34, 2788.83, 656.911, 3.089230, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116178, 29772, 571, 0, 0, 1, 2, 0, 0, 8318.58, 2747.78, 656.012, 0.820305, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116179, 29772, 571, 0, 0, 1, 2, 0, 0, 8337.8, 2785.59, 655.176, 4.9392800, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116180, 29772, 571, 0, 0, 1, 2, 0, 0, 8342.18, 2739.8, 655.726, 1.9896800, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116188, 29772, 571, 0, 0, 1, 2, 0, 0, 8363.65, 2766.72, 656.759, 0.453786, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116189, 29772, 571, 0, 0, 1, 2, 0, 0, 8368.7, 2720.12, 656.94, 6.24828000, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116191, 29772, 571, 0, 0, 1, 2, 0, 0, 8377.84, 2710.62, 655.007, 2.932150, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116192, 29772, 571, 0, 0, 1, 2, 0, 0, 8385.12, 2754.64, 656.509, 2.024580, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116193, 29772, 571, 0, 0, 1, 2, 0, 0, 8393.87, 2710.82, 655.451, 3.543020, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116194, 29772, 571, 0, 0, 1, 2, 0, 0, 8408.45, 2700.3, 655.178, 1.6231600, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116198, 29772, 571, 0, 0, 1, 2, 0, 0, 8411.12, 2734.44, 656.054, 2.687810, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116200, 29772, 571, 0, 0, 1, 2, 0, 0, 8421.87, 2708.55, 655.178, 1.378810, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(116201, 29772, 571, 0, 0, 1, 2, 0, 0, 8586.84, 2638.39, 652.437, 0.802851, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0);