diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2018_09_21_04_world_335.sql | 66 |
1 files changed, 66 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_09_21_04_world_335.sql b/sql/updates/world/3.3.5/2018_09_21_04_world_335.sql new file mode 100644 index 00000000000..8abbf1b4ec4 --- /dev/null +++ b/sql/updates/world/3.3.5/2018_09_21_04_world_335.sql @@ -0,0 +1,66 @@ +-- +DELETE FROM `gameobject` WHERE `guid` IN (5449,5456,5457,5460,5462,5478,5480,5481,5505,5545,5548,5563,5568,5570,5582,5584,5589,5597,5604,5626,5633,5640,5643,5655,5660,5661,5671,5684,5758,5760,5763,5767,5772); +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +(5449, 180026, 1, 0, 0, 1, 1, 1217.33, -4392.93, 23.8415, 4.54431, -0, -0, -0.763965, 0.645257, 300, 255, 1), +(5456, 186217, 1, 0, 0, 1, 1, 1217.33, -4392.93, 23.8415, 4.54431, -0, -0, -0.763965, 0.645257, 300, 255, 1), +(5457, 186717, 1, 0, 0, 1, 1, 1220.71, -4393.85, 23.5833, 4.36759, -0, -0, -0.817928, 0.575321, 300, 255, 1), +(5460, 186717, 1, 0, 0, 1, 1, 1213.79, -4392.43, 23.9682, 4.59261, -0, -0, -0.748163, 0.663515, 300, 255, 1), +(5462, 186717, 1, 0, 0, 1, 1, 1190.37, -4387.21, 23.4822, 4.91305, -0, -0, -0.632725, 0.774377, 300, 255, 1), +(5478, 186717, 1, 0, 0, 1, 1, 1183.43, -4389.83, 22.8478, 4.95939, -0, -0, -0.614615, 0.788827, 300, 255, 1), +(5480, 180026, 1, 0, 0, 1, 1, 1186.85, -4388.55, 23.1468, 5.04185, -0, -0, -0.58158, 0.813489, 300, 255, 1), +(5481, 186217, 1, 0, 0, 1, 1, 1186.85, -4388.55, 23.1468, 5.04185, -0, -0, -0.58158, 0.813489, 300, 255, 1), +(5505, 186737, 1, 0, 0, 1, 1, 1289.28, -4426.69, 26.7567, 5.22865, -0, -0, -0.503172, 0.864186, 300, 255, 1), +(5545, 186737, 1, 0, 0, 1, 1, 1189.28, -4333.29, 21.2965, 1.99605, -0, -0, -0.840403, -0.541962, 300, 255, 1), +(5548, 186737, 1, 0, 0, 1, 1, 1177.19, -4306.11, 21.2805, 2.01097, -0, -0, -0.844421, -0.53568, 300, 255, 1), +(5563, 186737, 1, 0, 0, 1, 1, 1193.69, -4266.54, 21.1919, 0.133869, -0, -0, -0.0668847, -0.997761, 300, 255, 1), +(5568, 186737, 1, 0, 0, 1, 1, 1219.77, -4279.83, 21.1917, 5.10308, -0, -0, -0.556405, 0.830911, 300, 255, 1), +(5570, 186737, 1, 0, 0, 1, 1, 1223.66, -4325.93, 21.2946, 4.68627, -0, -0, -0.716281, 0.697812, 300, 255, 1), +(5582, 186737, 0, 0, 0, 1, 1, -5131, -618.245, 397.274, 4.4904, -0, -0, -0.78108, 0.624431, 300, 255, 1), +(5584, 186737, 0, 0, 0, 1, 1, -5188.23, -486.766, 386.902, 3.22904, -0, -0, -0.999044, 0.0437109, 300, 255, 1), +(5589, 180052, 0, 0, 0, 1, 1, -5185.53, -613.431, 397.176, 0.42516, -0, -0, -0.210983, -0.97749, 300, 255, 1), +(5597, 180052, 0, 0, 0, 1, 1, -5142.18, -631.189, 397.203, 5.32605, -0, -0, -0.46051, 0.887655, 300, 255, 1), +(5604, 180052, 0, 0, 0, 1, 1, -5133.22, -595.632, 397.21, 0.851634, -0, -0, -0.413065, -0.910702, 300, 255, 1), +(5626, 180052, 0, 0, 0, 1, 1, -5131.56, -583.362, 397.177, 1.2891, -0, -0, -0.600839, -0.79937, 300, 255, 1), +(5633, 180052, 0, 0, 0, 1, 1, -5150.95, -570.949, 397.176, 2.78528, -0, -0, -0.984172, -0.177214, 300, 255, 1), +(5640, 186737, 0, 0, 0, 1, 1, -5166.16, -561.805, 397.175, 5.72267, -0, -0, -0.276604, 0.960984, 300, 255, 1), +(5643, 180052, 0, 0, 0, 1, 1, -5171.33, -543.152, 397.175, 0.0874343, -0, -0, -0.0437032, -0.999045, 300, 255, 1), +(5655, 180052, 0, 0, 0, 1, 1, -5192.38, -573.622, 397.177, 3.46464, -0, -0, -0.986983, 0.160824, 300, 255, 1), +(5660, 180052, 0, 0, 0, 1, 1, -5195.74, -477.324, 388.331, 0.817851, -0, -0, -0.397624, -0.917549, 300, 255, 1), +(5661, 180052, 1, 0, 0, 1, 1, 1183.08, -4354.83, 21.2945, 3.23581, -0, -0, -0.998891, 0.0470916, 300, 255, 1), +(5671, 180052, 1, 0, 0, 1, 1, 1222.95, -4343.28, 21.2946, 1.49224, -0, -0, -0.678796, -0.734327, 300, 255, 1), +(5684, 180052, 1, 0, 0, 1, 1, 1185.95, -4322.63, 21.2969, 3.70157, -0, -0, -0.961059, 0.276344, 300, 255, 1), +(5758, 180052, 1, 0, 0, 1, 1, 1224.44, -4305.11, 21.1917, 5.00612, -0, -0, -0.59602, 0.80297, 300, 255, 1), +(5760, 180052, 1, 0, 0, 1, 1, 1207.42, -4263.28, 21.1917, 4.60006, -0, -0, -0.745684, 0.6663, 300, 255, 1), +(5763, 180052, 1, 0, 0, 1, 1, 1175.67, -4278.32, 21.1915, 2.21245, -0, -0, -0.894015, -0.448038, 300, 255, 1), +(5767, 180052, 1, 0, 0, 1, 1, 1171.5, -4291.06, 21.2712, 4.34952, -0, -0, -0.823091, 0.56791, 300, 255, 1), +(5772, 180052, 1, 0, 0, 1, 1, 1225.84, -4291.79, 21.2244, 0.0667462, -0, -0, -0.033367, -0.999443, 300, 255, 1); + +DELETE FROM `game_event_gameobject` WHERE `guid` IN (31512,31472,31417,31415,31420,31416,31422,31434,31428,31418,5584,5589,5597,5604,5626,5633,5640,5643,5655,5660,5661,5671,5684,5758,5760,5763,5767,5772,5449,5456,5457,5460,5462,5478,5480,5481,5505,5545,5548,5563,5568,5570,5582,31688,31714,31710,31711,31716,31717,31706,31720,31735,31764,31719,31705,31708,31709,31718,31723,31725,31726,31727,31728,31734,31738,31739,31740,31744,31746,31751,31753,31758,31760,31761,31765,31766,31767, 31767, 31424, 31425, 31426, 31430, 31431, 31437, 31444, 31445, 31446, 31447, 31448, 31449, 31450, 31460, 31461, 31462, 31465, 31466, 31468, 31469, 31470, 31471) AND `eventEntry`=70; +INSERT INTO `game_event_gameobject` (`guid`,`eventEntry`) VALUES +(31688,70),(31714,70),(31710,70),(31711,70), +(31716,70),(31717,70),(31706,70),(31720,70), +(31735,70),(31764,70),(31719,70),(31705,70), +(31708,70),(31709,70),(31718,70),(31723,70), +(31725,70),(31726,70),(31727,70),(31728,70), +(31734,70),(31738,70),(31739,70),(31740,70), +(31744,70),(31746,70),(31751,70),(31753,70), +(31758,70),(31760,70),(31761,70),(31765,70), +(31766,70),(31767,70),(31424,70),(31425,70), +(31426,70),(31430,70),(31431,70),(31437,70), +(31444,70),(31445,70),(31446,70),(31447,70), +(31448,70),(31449,70),(31450,70),(31460,70), +(31461,70),(31462,70),(31465,70),(31466,70), +(31468,70),(31469,70),(31470,70),(31471,70), +(5449,70),(5456,70), (5457,70),(5460,70), +(5462,70),(5478,70),(5480,70),(5481,70), +(5505,70),(5545,70),(5548,70),(5563,70), +(5568,70),(5570,70),(5582,70),(5584,70), +(5589,70),(5597,70),(5604,70),(5626,70), +(5633,70),(5640,70),(5643,70),(5655,70), +(5660,70),(5661,70),(5671,70),(5684,70), +(5758,70),(5760,70),(5763,70),(5767,70), +(5772,70),(31512,70),(31472,70),(31417,70), +(31415,70),(31420,70),(31416,70),(31422,70), +(31434,70),(31428,70),(31418,70); + +UPDATE `game_event` SET `description`="Brewfest Building" WHERE `eventEntry`=70; |