DB/Creature: Add some missing cosmetic npcs at Culling of Stratholme Dungeon Entrance

1 files changed, 44 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2018_08_29_00_world_335.sql b/sql/updates/world/3.3.5/2018_08_29_00_world_335.sql
new file mode 100644
index 00000000000..594edf6eb6f
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_08_29_00_world_335.sql
@@ -0,0 +1,44 @@
+-- 
+DELETE FROM `creature` WHERE `guid` IN (12605,12606,51692,51697,51699,51704,84509,84510,84511,84604,84609,84610,84611,84629,84630,84646,84647,84663,84716,84743,84744,84851,84862,84863,84900,84902,84939);
+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`, `ScriptName`, `VerifiedBuild`) VALUES
+(12605, 29866, 1, 440, 2300, 1, 1, 0, 0, -8743.8, -4428.17, -201.36, 3.07178, 120, 0, 0, 1, 0, 0, 0, 0, 0, "", 0),
+(12606, 29867, 1, 440, 2300, 1, 1, 0, 1, -8751.68, -4452.36, -199.699, 1.29154, 120, 0, 0, 1, 0, 0, 0, 0, 0, "", 0), -- 
+(51692, 29866, 1, 440, 2300, 1, 1, 0, 0, -8724.14, -4412.39, -203.747, 3.80482, 120, 0, 0, 1, 0, 0, 0, 0, 0, "", 0),
+(51697, 29865, 1, 440, 2300, 1, 1, 0, 0, -8746.62, -4428.1, -201.354, 6.24828, 120, 0, 0, 1, 0, 0, 0, 0, 0, "", 0),
+(51699, 29873, 1, 440, 2300, 1, 1, 0, 0, -8706.65, -4417, -205.124, 2.70526, 120, 0, 0, 1, 0, 0, 0, 0, 0, "", 0),
+(51704, 29867, 1, 440, 2300, 1, 1, 0, 1, -8759.25, -4450.96, -200.123, 1.39626, 120, 0, 0, 1, 0, 0, 0, 0, 0, "", 0), -- 
+(84509, 29868, 1, 440, 2300, 1, 1, 0, 0, -8747.63, -4450.67, -199.451, 3.52556, 120, 0, 0, 1, 0, 0, 0, 0, 0, "", 0),
+(84510, 29868, 1, 440, 2300, 1, 1, 0, 0, -8707.38, -4416.52, -205.047, 5.65487, 120, 0, 0, 1, 0, 0, 0, 0, 0, "", 0),
+(84511, 29868, 1, 440, 2300, 1, 1, 0, 0, -8747.43, -4448.76, -199.175, 3.83972, 120, 0, 0, 1, 0, 0, 0, 0, 0, "", 0),
+(84604, 29865, 1, 440, 2300, 1, 1, 0, 0, -8643.38, -4351.43, -208.111, 6.26573, 120, 0, 0, 1, 0, 0, 0, 0, 0, "", 0),
+(84609, 29866, 1, 440, 2300, 1, 1, 0, 0, -8662.23, -4383.17, -206.934, 5.39307, 120, 0, 0, 1, 0, 0, 0, 0, 0, "", 0),
+(84610, 29868, 1, 440, 2300, 1, 1, 0, 0, -8661.53, -4381.77, -206.93, 6.0912, 120, 0, 0, 1, 0, 0, 0, 0, 0, "", 0),
+(84611, 29866, 1, 440, 2300, 1, 1, 0, 0, -8641.65, -4352.35, -208.204, 2.77507, 120, 0, 0, 1, 0, 0, 0, 0, 0, "", 0),
+(84629, 29865, 1, 440, 2300, 1, 1, 0, 0, -8656.92, -4389.86, -207.436, 2.23402, 120, 0, 0, 1, 0, 0, 0, 0, 0, "", 0),
+(84630, 29867, 1, 440, 2300, 1, 1, 0, 1, -8645.1, -4371.34, -208.185, 0.506145, 120, 0, 0, 1, 0, 0, 0, 0, 0, "", 0),
+(84646, 29866, 1, 440, 2300, 1, 1, 0, 0, -8642.65, -4359.16, -208.243, 4.2586, 120, 0, 0, 1, 0, 0, 0, 0, 0, "", 0),
+(84647, 29866, 1, 440, 2300, 1, 1, 0, 0, -8659.16, -4406.02, -207.438, 2.68781, 120, 0, 0, 1, 0, 0, 0, 0, 0, "", 0),
+(84663, 29865, 1, 440, 2300, 1, 1, 0, 0, -8660.77, -4404.86, -207.4, 5.48033, 120, 0, 0, 1, 0, 0, 0, 0, 0, "", 0),
+(84716, 29867, 1, 440, 2300, 1, 1, 0, 1, -8678.84, -4405.57, -206.534, 4.60767, 120, 0, 0, 1, 0, 0, 0, 0, 0, "", 0),
+(84743, 29865, 1, 440, 2300, 1, 1, 0, 0, -8677.56, -4405.93, -206.679, 3.57792, 120, 0, 0, 1, 0, 0, 0, 0, 0, "", 0),
+(84744, 29867, 1, 440, 2300, 1, 1, 0, 1, -8629.69, -4396.92, -208.617, 3.01942, 120, 0, 0, 1, 0, 0, 0, 0, 0, "", 0), -- 
+(84851, 29865, 1, 440, 2300, 1, 1, 0, 0, -8613.5, -4414.04, -209.149, 1.06465, 120, 0, 0, 1, 0, 0, 0, 0, 0, "", 0),
+(84862, 29868, 1, 440, 2300, 1, 1, 0, 0, -8611.45, -4411.41, -209.398, 3.92699, 120, 0, 0, 1, 0, 0, 0, 0, 0, "", 0),
+(84863, 29866, 1, 440, 2300, 1, 1, 0, 0, -8612.38, -4410.71, -209.356, 4.29351, 120, 0, 0, 1, 0, 0, 0, 0, 0, "", 0),
+(84900, 29868, 1, 440, 2300, 1, 1, 0, 0, -8611.28, -4412.6, -209.366, 3.87463, 120, 0, 0, 1, 0, 0, 0, 0, 0, "", 0),
+(84902, 29867, 1, 440, 2300, 1, 1, 0, 1, -8630.17, -4400.45, -208.464, 1.27409, 120, 0, 0, 1, 0, 0, 0, 0, 0, "", 0),
+(84939, 29868, 1, 440, 2300, 1, 1, 0, 0, -8614.49, -4410.79, -209.182, 4.93928, 120, 0, 0, 1, 0, 0, 0, 0, 0, "", 0);
+
+DELETE FROM `creature_addon` WHERE `guid` IN (12606,51704,84744);
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `auras`) VALUES
+(12606, 0, 14583,"34712"),
+(51704, 0, 14583,"34712"),
+(84744, 0, 14583,"34712");
+
+DELETE FROM `creature_template_addon` WHERE entry IN (29868,29865,29866,29873,29868,29867);
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`, `auras`) VALUES
+(29865, 1, 34712),
+(29866, 1, 34712),
+(29867, 0, 34712),
+(29868, 1, 34712),
+(29873, 1, 34712);