DB/GameObjects: Fix all Wintergrasp Banners

1 files changed, 20 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2019_03_16_00_world.sql b/sql/updates/world/3.3.5/2019_03_16_00_world.sql
new file mode 100644
index 00000000000..ed50f2ed59f
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_03_16_00_world.sql
@@ -0,0 +1,20 @@
+-- 
+DELETE FROM `gameobject` WHERE `guid` IN (74686,74708,74710,74692,74694,74718,74716) AND `id`=192501;
+DELETE FROM `gameobject_addon` WHERE `guid` IN (74686,74708,74710,74692,74694,74718,74716);
+DELETE FROM `gameobject` WHERE `guid` IN (7135,7138,7141,7142,7144,7150,7151,7155,7157,7159,7161,7164,7167,7169,7172);
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
+(7135, 192488, 571, 1, 64, 5280.99, 3064.95, 432.128, 1.5708, 0, 0, 0.707107, 0.707107, 300, 255, 1),
+(7138, 192487, 571, 1, 128, 5158.71, 2882.9, 431.274, 3.14159, 0, 0, -1, 0, 300, 255, 1),
+(7141, 192487, 571, 1, 128, 5160.28, 2798.6, 430.604, -3.12412, 0, 0, -0.999962, 0.00873464, 300, 255, 1),
+(7142, 192501, 571, 1, 64, 4398.82, 2804.7, 429.792, -1.58825, 0, 0, -0.713251, 0.700909, 180, 0, 1),
+(7144, 192501, 571, 1, 64, 4416, 2822.67, 429.851, -0.017452, 0, 0, -0.00872589, 0.999962, 180, 0, 1),
+(7150, 192501, 571, 1, 64, 4559.11, 3606.22, 419.999, -1.48353, 0, 0, -0.67559, 0.737277, 180, 0, 1),
+(7151, 192501, 571, 1, 64, 4539.42, 3622.49, 420.034, -3.07177, 0, 0, -0.999391, 0.0349043, 180, 0, 1),
+(7155, 192501, 571, 1, 64, 4555.26, 3641.65, 419.974, 1.67551, 0, 0, 0.743143, 0.669133, 180, 0, 1),
+(7157, 192501, 571, 1, 64, 4574.87, 3625.91, 420.079, 0.087266, 0, 0, 0.0436192, 0.999048, 180, 0, 1),
+(7159, 192501, 571, 1, 64, 4466.79, 1960.42, 459.144, 1.15192, 0, 0, 0.54464, 0.83867, 180, 0, 1),
+(7161, 192501, 571, 1, 64, 4475.35, 1937.03, 459.07, -0.436332, 0, 0, -0.216439, 0.976296, 180, 0, 1),
+(7164, 192501, 571, 1, 64, 4451.76, 1928.1, 459.076, -2.00713, 0, 0, -0.843391, 0.5373, 180, 0, 1),
+(7167, 192501, 571, 1, 64, 4442.99, 1951.9, 459.093, 2.74016, 0, 0, 0.979924, 0.199371, 180, 0, 1),
+(7169, 192501, 571, 1, 64, 4380.36, 2822.36, 429.763, -3.10665, 0, 0, -0.999847, 0.0174704, 180, 0, 1),
+(7172, 192501, 571, 1, 64, 4397.4, 2840.29, 429.863, 1.5708, 0, 0, 0.707108, 0.707106, 180, 0, 1);