diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2019_04_01_01_world.sql | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_04_01_01_world.sql b/sql/updates/world/3.3.5/2019_04_01_01_world.sql new file mode 100644 index 00000000000..cdd6c9d4b9c --- /dev/null +++ b/sql/updates/world/3.3.5/2019_04_01_01_world.sql @@ -0,0 +1,28 @@ +-- +DELETE FROM `spawn_group` WHERE `SpawnId` IN (20927,20928,20929,20930,20931,20932,20933,20934,21081,21097,21098,21099) AND `spawnType`=1; +DELETE FROM `gameobject` WHERE `id` IN (191814, 191815); +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +(8120, 191814, 571, 1, 3, 7329.99, -3292.08, 859.143, -0.733038, 0, 0, -0.358368, 0.93358, 300, 255, 1), +(8125, 191814, 571, 1, 3, 7354.41, -3223.31, 845.911, 1.0472, 0, 0, 0.500001, 0.866025, 300, 255, 1), +(8128, 191814, 571, 1, 3, 7229.83, -3560.51, 840.158, -1.309, 0, 0, -0.608763, 0.793352, 300, 255, 1), +(8130, 191814, 571, 1, 3, 7214.66, -3579.06, 824.267, 0.314158, 0, 0, 0.156434, 0.987688, 300, 255, 1), +(8132, 191814, 571, 1, 3, 7142.79, -3581.79, 834.891, 1.74533, 0, 0, 0.766045, 0.642787, 300, 255, 1), +(8133, 191814, 571, 1, 3, 7230.95, -3504.92, 835.969, -2.23402, 0, 0, -0.898794, 0.438372, 300, 255, 1), +(8143, 191814, 571, 1, 3, 7160.92, -3487.59, 857.127, 1.62316, 0, 0, 0.725376, 0.688353, 300, 255, 1), +(8144, 191814, 571, 1, 3, 7176.07, -3613.49, 829.169, -2.65289, 0, 0, -0.970294, 0.241927, 300, 255, 1), +(8145, 191814, 571, 1, 3, 7574.39, -3148.09, 847.069, 1.44862, 0, 0, 0.662619, 0.748957, 300, 255, 1), +(8146, 191814, 571, 1, 3, 7184.85, -3042.11, 860.237, 0.401425, 0, 0, 0.199368, 0.979925, 300, 255, 1), +(8147, 191815, 571, 1, 3, 7579.99, -3105.63, 853.369, -0.610864, 0, 0, -0.300705, 0.953717, 300, 255, 1), +(8148, 191815, 571, 1, 3, 7464.85, -3014.68, 851.467, -1.02974, 0, 0, -0.492422, 0.870357, 300, 255, 1), +(8149, 191815, 571, 1, 3, 7514.74, -3264.53, 850.952, 1.65806, 0, 0, 0.737276, 0.675591, 300, 255, 1), +(8162, 191815, 571, 1, 3, 7580.43, -3226.88, 844.577, 1.55334, 0, 0, 0.700908, 0.713252, 300, 255, 1), +(8164, 191815, 571, 1, 3, 7419.19, -3251, 848.563, 3.05433, 0, 0, 0.999048, 0.0436174, 300, 255, 1), +(8166, 191815, 571, 1, 3, 7158.73, -3356.5, 860.18, -1.85005, 0, 0, -0.798636, 0.601815, 300, 255, 1), +(8172, 191815, 571, 1, 3, 7207.49, -3539.53, 827.261, 2.40855, 0, 0, 0.93358, 0.35837, 300, 255, 1), +(8174, 191815, 571, 1, 3, 7170.09, -3644.12, 830.197, -2.28638, 0, 0, -0.909961, 0.414694, 300, 255, 1), +(8179, 191815, 571, 1, 3, 7239.15, -3403.62, 849.801, 2.35619, 0, 0, 0.923879, 0.382686, 300, 255, 1), +(8180, 191815, 571, 1, 3, 7273.54, -3632.39, 829.721, 0.453785, 0, 0, 0.224951, 0.97437, 300, 255, 1), +(8190, 191815, 571, 1, 3, 7181.03, -3332.48, 845.665, -1.65806, 0, 0, -0.737276, 0.675591, 300, 255, 1), +(8191, 191815, 571, 1, 3, 7618.27, -3181.99, 852.252, -0.942477, 0, 0, -0.45399, 0.891007, 300, 255, 1), +(8192, 191815, 571, 1, 3, 7170.52, -2989.24, 864.819, 1.25664, 0, 0, 0.587786, 0.809016, 300, 255, 1), +(8193, 191815, 571, 1, 3, 7209.43, -3170.97, 846.747, 2.46091, 0, 0, 0.942641, 0.333809, 300, 255, 1); |