DB/Creature: Add missing spawns

(cherry picked from commit 082eeda7fef26928090d42d1632e0dce1dfe5ab0)

1 files changed, 55 insertions, 0 deletions

diff --git a/sql/updates/world/2016_01_17_18_world_2015_12_31_00.sql b/sql/updates/world/2016_01_17_18_world_2015_12_31_00.sql
new file mode 100644
index 00000000000..43f86e84cb3
--- /dev/null
+++ b/sql/updates/world/2016_01_17_18_world_2015_12_31_00.sql
@@ -0,0 +1,55 @@
+-- 
+SET @guid := 87490;
+DELETE FROM `creature` WHERE `guid` BETWEEN @guid+0 AND @guid+23;
+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, 32262, 571, 1, 169, 0, 0, 8210.67, 2058.87, 550.78, 1.8675, 300, 0, 0, 10080, 17272, 0),
+(@guid+1, 32262, 571, 1, 169, 0, 0, 8194.63, 2063.66, 550.78, 0.698132, 300, 0, 0, 10080, 17272, 0),
+(@guid+2, 32262, 571, 1, 169, 0, 0, 8200.36, 2050.99, 550.78, 1.43117, 300, 0, 0, 10080, 17272, 0),
+(@guid+3, 32297, 571, 1, 169, 0, 0, 8174.97, 2127.87, 499.92, 1.6057, 300, 0, 0, 10080, 17628, 0),
+(@guid+4, 32297, 571, 1, 169, 0, 0, 8204.41, 2125.31, 499.837, 4.72564, 300, 0, 0, 10080, 17628, 0),
+(@guid+5, 32297, 571, 1, 169, 0, 0, 8199.44, 2123.24, 499.837, 6.07577, 300, 0, 0, 10080, 17628, 0),
+(@guid+6, 32297, 571, 1, 169, 0, 0, 8151.77, 2128.06, 499.92, 1.65806, 300, 0, 0, 10080, 17628, 0),
+(@guid+7, 32297, 571, 1, 169, 0, 0, 8163.05, 2127.68, 499.92, 1.65806, 300, 0, 0, 10080, 17628, 0),
+(@guid+8, 32297, 571, 1, 169, 0, 0, 8144.97, 2100.36, 499.92, 4.7822, 300, 0, 0, 10080, 17628, 0),
+(@guid+9, 32297, 571, 1, 169, 0, 0, 8133.19, 2100.51, 499.92, 4.66003, 300, 0, 0, 10080, 17628, 0),
+(@guid+10, 32297, 571, 1, 169, 0, 0, 8157.47, 2102.37, 499.92, 3.08923, 300, 0, 0, 10080, 17628, 0),
+(@guid+11, 32297, 571, 1, 169, 0, 0, 8183.99, 2100.45, 499.92, 4.59022, 300, 0, 0, 10080, 17628, 0),
+(@guid+12, 32297, 571, 1, 169, 0, 0, 8172.34, 2100.43, 499.92, 4.67748, 300, 0, 0, 10080, 17628, 0),
+(@guid+13, 32297, 571, 1, 169, 0, 0, 8168.38, 2100.2, 499.92, 4.72984, 300, 0, 0, 10080, 17628, 0),
+(@guid+14, 32297, 571, 1, 169, 0, 0, 8202.52, 2103.62, 499.92, 0.10472, 300, 0, 0, 10080, 17628, 0),
+(@guid+15, 32297, 571, 1, 169, 0, 0, 8192.9, 2100.59, 499.92, 4.81711, 300, 0, 0, 10080, 17628, 0),
+(@guid+16, 32297, 571, 1, 169, 0, 0, 8214, 2126.49, 499.92, 6.26573, 300, 0, 0, 10080, 17628, 0),
+(@guid+17, 32297, 571, 1, 169, 0, 0, 8132.54, 2115.139, 499.837, 1.874436, 300, 0, 0, 10080, 17628, 0),
+(@guid+18, 32297, 571, 1, 169, 0, 0, 8133.218, 2119.662, 499.737, 3.914777, 300, 0, 0, 10080, 17628, 0),
+(@guid+19, 32297, 571, 1, 169, 0, 0, 8129.094, 2118.386, 499.737, 5.876702, 300, 0, 0, 10080, 17628, 0),
+(@guid+20, 32297, 571, 1, 169, 0, 0, 8203.914, 2120.223, 499.737, 2.054170, 300, 0, 0, 10080, 17628, 0),
+(@guid+21, 32297, 571, 1, 169, 0, 0, 8158.015, 2134.9663, 499.737, 4.673187, 300, 0, 0, 10080, 17628, 0),
+(@guid+22, 32297, 571, 1, 169, 0, 0, 8169.999, 2134.4260, 499.737, 4.708543, 300, 0, 0, 10080, 17628, 0),
+(@guid+23, 32276, 571, 1, 169, 0, 0, 8029.4, 2172.71, 499.918, 3.01942, 300, 0, 0, 12175, 0, 0);
+  
+DELETE FROM `creature_addon` WHERE `guid` BETWEEN @guid+0 AND @guid+23;
+INSERT INTO `creature_addon` (`guid`, `bytes2`, `emote`) VALUES
+(@guid+0, 1, 0), 
+(@guid+1, 1, 0),
+(@guid+2, 1, 0),
+(@guid+3, 1, 69),
+(@guid+4, 1, 396),
+(@guid+5, 1, 396),
+(@guid+6, 1, 69),
+(@guid+7, 1, 69),
+(@guid+8, 1, 69),
+(@guid+9, 1, 69),
+(@guid+10, 1, 69),
+(@guid+11, 1, 69),
+(@guid+12, 1, 69),
+(@guid+13, 1, 69),
+(@guid+14, 1, 69),
+(@guid+15, 1, 69),
+(@guid+16, 1, 69),
+(@guid+17, 1, 396),
+(@guid+18, 1, 396),
+(@guid+19, 1, 396),
+(@guid+20, 1, 396),
+(@guid+21, 1, 69),
+(@guid+22, 1, 69),
+(@guid+23, 1, 0);