DB/GamObjects: Add some missing spawns

1 files changed, 22 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2019_03_11_01_world.sql b/sql/updates/world/3.3.5/2019_03_11_01_world.sql
new file mode 100644
index 00000000000..9d13f7d3f9d
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_03_11_01_world.sql
@@ -0,0 +1,22 @@
+-- 
+DELETE FROM `gameobject` WHERE `guid` IN (7100,7101,7104,7105,7106,7107,7110,7111,7118,7121,7122,7124,7127,7129,7130,7131,7133,7134);
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
+(7100, 177484, 109, 1, 1, -443.55, 53.9243, -148.74, 0.90757, 0, 0, 0, 1,30, 255, 1),
+(7101, 177484, 109, 1, 1, -444.448, 136.106, -148.74, 0.331611, 0, 0, 0, 1, 30, 255, 1),
+(7104, 177484, 109, 1, 1, -491.396, 53.5787, -148.74, -0.471238, 0, 0, -0.233445, 0.97237, 30, 255, 1),
+(7105, 177484, 109, 1, 1, -515.046, 95.1471, -148.74, 2.74016, 0, 0, 0.979924, 0.199371, 30, 255, 1),
+(7106, 177484, 109, 1, 1, -420.155, 94.3731, -148.74, -2.32129, 0, 0, -0.91706, 0.398748, 30, 255, 1),
+(7107, 177484, 109, 1, 1, -490.969, 135.714, -148.74, 0.226892, 0, 0, 0.113203, 0.993572, 30, 255, 1),
+(7110, 177485, 109, 1, 1, -443.55, 53.9243, -148.74, 0.90757, 0, 0, 0.438371, 0.898794, 30, 255, 1),
+(7111, 177485, 109, 1, 1, -444.448, 136.106, -148.74, 0.331611, 0, 0, 0.165047, 0.986286, 30, 255, 1),
+(7118, 177485, 109, 1, 1, -490.969, 135.714, -148.74, 0.226892, 0, 0, 0, 1, 30, 255, 1),
+(7121, 177485, 109, 1, 1, -491.396, 53.5787, -148.74, -0.471238, 0, 0, 0, 1, 30, 255, 1),
+(7122, 177485, 109, 1, 1, -420.155, 94.3731, -148.74, -2.32129, 0, 0, 0, 1, 30, 255, 1),
+(7124, 177485, 109, 1, 1, -515.046, 95.1471, -148.74, 2.74016, 0, 0, 0, 1, 30, 255, 1 ),
+(7127, 148837, 109, 1, 1, -443.55, 53.9243, -148.74, 0.90757, 0, 0, 0.438371, 0.898794, 30, 255, 1),
+(7129, 148837, 109, 1, 1, -444.448, 136.106, -148.74, 0.331611, 0, 0, 0.165047, 0.986286, 30, 255, 1),
+(7130, 148837, 109, 1, 1, -490.969, 135.714, -148.74, 0.226892, 0, 0, 0, 1, 30, 255, 1),
+(7131, 148837, 109, 1, 1, -491.396, 53.5787, -148.74, -0.471238, 0, 0, 0, 1, 30, 255, 1),
+(7133, 148837, 109, 1, 1, -420.155, 94.3731, -148.74, -2.32129, 0, 0, 0, 1, 30, 255, 1),
+(7134, 148837, 109, 1, 1, -515.046, 95.1471, -148.74, 2.74016, 0, 0, 0, 1, 30, 255, 1); 
+ 
\ No newline at end of file