DB/Creature: Add some missing spawns

1 files changed, 27 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2017_03_06_01_world_355.sql b/sql/updates/world/3.3.5/2017_03_06_01_world_355.sql
new file mode 100644
index 00000000000..2b3de410bb0
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_03_06_01_world_355.sql
@@ -0,0 +1,27 @@
+-- 
+DELETE FROM `creature` WHERE `guid` IN (74034,74142,77646,77647,77815,77864,77865,77866,77906,77937,77938,77939,77940);
+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
+(74034, 10236, 1, 0, 0, 1, 1, 0, 0, -987.7825, 907.5942, 91.825447, 1.332844, 72000, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(74142, 10237, 1, 0, 0, 1, 1, 0, 0, -2233.709229, 2662.238037, 60.862415, 0.230543, 72000, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(77646, 10238, 1, 0, 0, 1, 1, 0, 0, -1731.53051, 941.00701, 91.10691, 1.104273, 72000, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(77647, 3652, 1, 0, 0, 1, 1, 0, 0, -661.625488, -2221.64282, 14.840741, 5.371956, 72000, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(77815, 10819, 0, 0, 0, 1, 1, 0, 1, 3122.367676, -3725.473877, 133.100647, 3.151204, 72000, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(77864, 10818, 0, 0, 0, 1, 1, 0, 1, 3022.930908, -4942.98925, 100.734642, 3.020036, 72000, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(77865, 1849, 0, 0, 0, 1, 1, 0, 0, 1752.820435, -2333.548828, 59.800247, 2.518181, 72000, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(77866, 5348, 0, 0, 0, 1, 1, 0, 0, -10712.430664, -2533.73584, 27.762363, 6.150045, 72000, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(77906, 14341, 1, 0, 0, 1, 1, 0, 1, 5552.092773, -718.22052, 340.85080, 1.649167, 72000, 8, 0, 0, 0, 1, 0, 0, 0, 0),
+(77937, 22062, 530, 0, 0, 1, 1, 0, 0, 7165.62744, -6604.59228, 60.65881, 5.199848, 72000, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(77938, 22062, 530, 0, 0, 1, 1, 0, 0, 7226.793, -6406.289, 56.1663, 4.067284, 72000, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(77939, 22062, 530, 0, 0, 1, 1, 0, 0, 6294.86865, -6463.20703, 83.01150, 0.262043, 72000, 0, 0, 0, 0, 0, 0, 0, 0, 0),
+(77940, 22062, 530, 0, 0, 1, 1, 0, 0, 6299.13378, -6250.60693, 77.81383, 0.069625, 72000, 0, 0, 0, 0, 0, 0, 0, 0, 0);
+
+DELETE FROM `pool_template` WHERE `entry` = 373;
+INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
+(373, 1, 'Dr. Whitherlimb');
+
+DELETE FROM `pool_creature` WHERE `pool_entry` IN (373);
+INSERT INTO `pool_creature` (`guid`, `pool_entry`, `chance`, `description`) VALUES
+(77937, 373, 0, 'Dr. Whitherlimb 1'),
+(77938, 373, 0, 'Dr. Whitherlimb 2'),
+(77939, 373, 0, 'Dr. Whitherlimb 3'),
+(77940, 373, 0, 'Dr. Whitherlimb 4');