diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2019_03_18_00_world.sql | 55 |
1 files changed, 55 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_03_18_00_world.sql b/sql/updates/world/3.3.5/2019_03_18_00_world.sql new file mode 100644 index 00000000000..86d06f79ffb --- /dev/null +++ b/sql/updates/world/3.3.5/2019_03_18_00_world.sql @@ -0,0 +1,55 @@ +-- +DELETE FROM `gameobject` WHERE `guid` IN (7174, 7175, 7177, 7182, 7183, 7185, 7188, 7195, 7196, 7198, 7199, 7200, 7206, 7207, 7208, 7209, 7212, 7213, 7218, 7220, 7222, 7230, 7231, 7233, 7235, 7236, 7238, 7241, 7244, 7245, 7246, 7247, 7248, 7250, 7251, 7252, 7254, 7257, 7258, 7261, 7262, 7266, 7268); +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +(7174, 180757, 0, 1, 1, -8636.74, 418.086, 108.89, 2.26892, 0, 0, 0.906306, 0.422622, 300, 0, 1), +(7175, 180763, 530, 1, 1, -1764.76, 5447.28, -11.1643, 0.209439, 0, 0, 0.104528, 0.994522, 300, 0, 1), +(7177, 180763, 571, 1, 1, 5818.33, 648.446, 648.343, 0.750491, 0, 0, 0.366501, 0.930418, 300, 0, 1), +(7182, 180763, 571, 1, 1, 5625.12, 698.713, 654.514, -0.296705, 0, 0, -0.147809, 0.989016, 300, 0, 1), +(7183, 180764, 1, 1, 1, 10146.8, 2574.27, 1322.24, -1.93731, 0, 0, -0.824125, 0.566409, 300, 0, 1), +(7185, 180764, 1, 1, 1, 10149.7, 2592.52, 1332.08, -2.93214, 0, 0, -0.994521, 0.104535, 300, 0, 1), +(7188, 180764, 571, 1, 1, 5622.2, 691.908, 654.555, 2.26892, 0, 0, 0.906306, 0.422622, 300, 0, 1), +(7195, 180764, 571, 1, 1, 5887.51, 525.322, 642.133, 0.331611, 0, 0, 0.165047, 0.986286, 300, 0, 1), +(7196, 180764, 571, 1, 1, 5821.69, 633.573, 648.384, -2.68781, 0, 0, -0.97437, 0.22495, 300, 0, 1), +(7198, 180764, 571, 1, 1, 5882.01, 523.711, 642.1, 2.14675, 0, 0, 0.878816, 0.477161, 300, 0, 1), +(7199, 180764, 530, 1, 1, -1794.38, 5492.93, -11.3934, -2.53072, 0, 0, -0.953716, 0.300709, 300, 0, 1), +(7200, 180768, 530, 1, 1, -2635, 4420.16, 36.1353, 1.02974, 0, 0, 0.492422, 0.870357, 300, 0, 1), +(7206, 180768, 530, 1, 1, -2669.31, 4415.34, 35.8521, 0.436332, 0, 0, 0.216439, 0.976296, 300, 0, 1), +(7207, 180768, 530, 1, 1, -2662.7, 4401.05, 36.8522, 3.05433, 0, 0, 0.999048, 0.0436174, 300, 0, 1), +(7208, 180771, 0, 1, 1, -8580.63, 634.502, 96.338, -2.87979, 0, 0, -0.991445, 0.130528, 300, 0, 1), +(7209, 180772, 0, 1, 1, -8583.95, 633.334, 96.338, -2.87979, 0, 0, -0.991445, 0.130528, 300, 0, 1), +(7212, 180772, 0, 1, 1, -8582.3, 633.937, 96.338, -2.87979, 0, 0, -0.991445, 0.130528, 300, 0, 1), +(7213, 180772, 0, 1, 1, -8585.82, 632.98, 96.338, -2.87979, 0, 0, -0.991445, 0.130528, 300, 0, 1), +(7218, 180773, 571, 1, 1, 5739.93, 677.38, 648.574, -0.698132, 0, 0, -0.34202, 0.939693, 300, 0, 1), +(7220, 180773, 0, 1, 1, -8399.86, 677.257, 108.127, -2.49582, 0, 0, -0.948324, 0.317305, 300, 0, 1), +(7222, 180773, 571, 1, 1, 5828.04, 504.604, 663.942, -1.27409, 0, 0, -0.594823, 0.803857, 300, 0, 1), +(7230, 180775, 571, 1, 1, 5847.91, 588.422, 654.307, 2.00713, 0, 0, 0.843392, 0.537299, 300, 0, 1), +(7231, 180775, 571, 1, 1, 5888.69, 530.019, 644.236, 1.83259, 0, 0, 0.793352, 0.608764, 300, 0, 1), +(7233, 180775, 571, 1, 1, 5837.24, 507.428, 663.806, -1.23918, 0, 0, -0.580701, 0.814117, 300, 0, 1), +(7235, 180775, 571, 1, 1, 5862.43, 606.057, 654.389, 2.82743, 0, 0, 0.987688, 0.156436, 300, 0, 1), +(7236, 180775, 571, 1, 1, 5879.29, 527.823, 644.277, 1.76278, 0, 0, 0.771624, 0.636079, 300, 0, 1), +(7238, 180870, 1, 1, 1, 10159.8, 2604.5, 1332.37, -2.87979, 0, 0, -0.991445, 0.130528, 300, 0, 1), +(7241, 180870, 530, 1, 1, -1768.5, 5435.47, -11.199, -2.91469, 0, 0, -0.993571, 0.113208, 300, 0, 1), +(7244, 180870, 530, 1, 1, -1782.14, 5432.37, -11.1087, -2.96704, 0, 0, -0.996194, 0.0871655, 300, 0, 1), +(7245, 180870, 530, 1, 1, -1771.73, 5447.55, -11.1434, -2.87979, 0, 0, -0.991445, 0.130528, 300, 0, 1), +(7246, 180870, 571, 1, 1, 5822.37, 652.821, 648.454, 2.84488, 0, 0, 0.989015, 0.147813, 300, 0, 1), +(7247, 180870, 530, 1, 1, -1810.03, 5501.46, -11.4559, -2.47837, 0, 0, -0.945519, 0.325567, 300, 0, 1), +(7248, 180870, 530, 1, 1, -1812.15, 5493.6, -11.4976, -2.37364, 0, 0, -0.927182, 0.37461, 300, 0, 1), +(7250, 180870, 530, 1, 1, -1795.72, 5504.96, -11.4906, 0.453785, 0, 0, 0.224951, 0.97437, 300, 0, 1), +(7251, 180870, 530, 1, 1, -1797.88, 5485.51, -11.4143, 0.610864, 0, 0, 0.300705, 0.953717, 300, 0, 1), +(7252, 180871, 1, 1, 1, 10154.5, 2593.53, 1332.05, -3.00195, 0, 0, -0.997563, 0.0697646, 300, 0, 1), +(7254, 180871, 1, 1, 1, 10141.8, 2600.27, 1332.35, 0.296705, 0, 0, 0.147809, 0.989016, 300, 0, 1), +(7257, 180871, 571, 1, 1, 5827.15, 639.102, 648.376, 2.82743, 0, 0, 0.987688, 0.156436, 300, 0, 1), +(7258, 180872, 1, 1, 1, 10148.6, 2610.28, 1332.4, -1.3439, 0, 0, -0.622513, 0.782609, 300, 0, 1), +(7261, 180872, 530, 1, 1, -1791.49, 5499.04, -11.4212, -2.32129, 0, 0, -0.91706, 0.398748, 300, 0, 1), +(7262, 180873, 571, 1, 1, 5815.6, 643.039, 648.351, 0.890117, 0, 0, 0.430511, 0.902586, 300, 0, 1), +(7266, 180873, 571, 1, 1, 5818.44, 635.468, 648.362, 2.80997, 0, 0, 0.986285, 0.165053, 300, 0, 1), +(7268, 180873, 530, 1, 1, -1802.42, 5503.25, -11.3587, -2.68781, 0, 0, -0.97437, 0.22495, 300, 0, 1); + +DELETE FROM `game_event_gameobject` WHERE `guid` IN (7174, 7175, 7177, 7182, 7183, 7185, 7188, 7195, 7196, 7198, 7199, 7200, 7206, 7207, 7208, 7209, 7212, 7213, 7218, 7220, 7222, 7230, 7231, 7233, 7235, 7236, 7238, 7241, 7244, 7245, 7246, 7247, 7248, 7250, 7251, 7252, 7254, 7257, 7258, 7261, 7262, 7266, 7268) AND `eventEntry`=7; +INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES +(7, 7174),(7, 7175),(7, 7177),(7, 7182),(7, 7183),(7, 7185),(7, 7188),(7, 7195), +(7, 7196),(7, 7198),(7, 7199),(7, 7200),(7, 7206),(7, 7207),(7, 7208),(7, 7209), +(7, 7212),(7, 7213),(7, 7218),(7, 7220),(7, 7222),(7, 7230),(7, 7231),(7, 7233), +(7, 7235),(7, 7236),(7, 7238),(7, 7241),(7, 7244),(7, 7245),(7, 7246),(7, 7247), +(7, 7248),(7, 7250),(7, 7251),(7, 7252),(7, 7254),(7, 7257),(7, 7258),(7, 7261), +(7, 7262),(7, 7266),(7, 7268); |