diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2018_10_09_01_world_335.sql | 71 |
1 files changed, 71 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_10_09_01_world_335.sql b/sql/updates/world/3.3.5/2018_10_09_01_world_335.sql new file mode 100644 index 00000000000..6a5e9a142d9 --- /dev/null +++ b/sql/updates/world/3.3.5/2018_10_09_01_world_335.sql @@ -0,0 +1,71 @@ +-- +DELETE FROM `gameobject` WHERE `guid` IN (6548,6553,6555,6557,6559,6561,6562,6563,6565,6567,6568,6573,6580,6585,6586,6587,6589,6591,6593,6594,6595,6596,6598,6601,6612,6613,6614,6615,6616,6618,6619,6620,6621,6630,6632,6636,6637,6641,6642,6643,6644,6648,6649,6650,6651,6654); +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 +(6548, 180397, 530, 0, 0, 1, 1, -2047, 5349.84, -41.0873, 4.24115, -0, -0, -0.852641, 0.522496, 300, 255, 1), +(6553, 180397, 530, 0, 0, 1, 1, -2032.1, 5221.72, -40.7506, 1.51844, -0, -0, -0.688356, -0.725373, 300, 255, 1), +(6555, 180397, 530, 0, 0, 1, 1, -1941.28, 5409.95, -12.4698, 3.15907, -0, -0, -0.999962, 0.0087363, 300, 255, 1), +(6557, 180397, 530, 0, 0, 1, 1, -1882.33, 5509.25, -12.5392, 1.93731, -0, -0, -0.824125, -0.566409, 300, 255, 1), +(6559, 180397, 530, 0, 0, 1, 1, -1848.87, 5349.6, -12.5184, 4.86947, -0, -0, -0.649449, 0.760405, 300, 255, 1), +(6561, 180397, 530, 0, 0, 1, 1, -1836.9, 5146.54, -42.9014, 2.77507, -0, -0, -0.983255, -0.182237, 300, 255, 1), +(6562, 180397, 530, 0, 0, 1, 1, -1814.73, 5433.6, -12.4561, 3.29869, -0, -0, -0.996917, 0.0784657, 300, 255, 1), +(6563, 180397, 530, 0, 0, 1, 1, -1786.12, 5453.28, -12.5254, 0.261798, -0, -0, -0.130526, -0.991445, 300, 255, 1), +(6565, 180397, 530, 0, 0, 1, 1, -1783.08, 5253.05, -40.3064, 5.44543, -0, -0, -0.406736, 0.913546, 300, 255, 1), +(6567, 180397, 530, 0, 0, 1, 1, -1679.59, 5503.09, -40.4978, 0.837757, -0, -0, -0.406736, -0.913546, 300, 255, 1), +(6568, 180397, 530, 0, 0, 1, 1, -1669.58, 5412.65, -40.5241, 0.0174525, -0, -0, -0.00872607, -0.999962, 300, 255, 1), +(6573, 180397, 530, 0, 0, 1, 1, -1647.68, 5217.71, -42.5536, 3.07177, -0, -0, -0.999391, -0.0349043, 300, 255, 1), +(6580, 180397, 571, 0, 0, 1, 1, 5664.43, 791.297, 653.83, 5.61996, -0, -0, -0.325567, 0.945519, 300, 255, 1), +(6585, 180397, 571, 0, 0, 1, 1, 5674.48, 808.294, 654.311, 4.50296, -0, -0, -0.777144, 0.629323, 300, 255, 1), +(6586, 180397, 1, 0, 0, 1, 1, 9719.91, 2545.86, 1335.68, 5.3058, -0, -0, -0.469471, 0.882948, 300, 255, 1), +(6587, 180397, 1, 0, 0, 1, 1, 9963.39, 2490.04, 1316.1, 0, 0, 0, 0, 1, 300, 255, 1), +(6589, 180397, 1, 0, 0, 1, 1, 9966.02, 2180.19, 1328.12, 3.73501, -0, -0, -0.956305, 0.292372, 300, 255, 1), +(6591, 180397, 1, 0, 0, 1, 1, 9985.58, 2342.43, 1330.79, 3.19186, -0, -0, -0.999684, 0.0251295, 300, 255, 1), +(6593, 180397, 530, 0, 0, 1, 1, -3827.9, -11728.4, -106.771, 2.18166, -0, -0, -0.887011, -0.461749, 300, 255, 1), +(6594, 180397, 530, 0, 0, 1, 1, -3841.83, -11419, -132.059, 3.82228, -0, -0, -0.942641, 0.333809, 300, 255, 1), +(6595, 180397, 530, 0, 0, 1, 1, -3909.87, -11632.8, -138.08, 1.62316, -0, -0, -0.725376, -0.688353, 300, 255, 1), +(6596, 180397, 530, 0, 0, 1, 1, -3947.58, -11696.7, -138.757, 3.52558, -0, -0, -0.981626, 0.190814, 300, 255, 1), +(6598, 180397, 530, 0, 0, 1, 1, -4161.83, -11451.8, -131.011, 0.506145, -0, -0, -0.25038, -0.968148, 300, 255, 1), +(6601, 180397, 0, 0, 0, 1, 1, -4675.39, -985.716, 501.659, 1.37881, -0, -0, -0.636078, -0.771625, 300, 255, 1), +(6612, 180397, 0, 0, 0, 1, 1, -4833.68, -1172.16, 502.195, 1.25664, -0, -0, -0.587786, -0.809016, 300, 255, 1), +(6613, 180397, 0, 0, 0, 1, 1, -4917.24, -844.055, 501.661, 3.82228, -0, -0, -0.942641, 0.333809, 300, 255, 1), +(6614, 180397, 0, 0, 0, 1, 1, -5035.67, -921.683, 501.659, 0, 0, 0, 0, 1, 300, 255, 1), +(6615, 180397, 0, 0, 0, 1, 1, -5039.29, -1259.13, 505.3, 0.715585, -0, -0, -0.350207, -0.936672, 300, 255, 1), +(6616, 180397, 0, 0, 0, 1, 1, -8386.36, 288.661, 120.885, 3.81389, -0, -0, -0.944032, 0.329855, 300, 255, 1), +(6618, 180397, 0, 0, 0, 1, 1, -8404.29, 577.574, 92.069, 5.28835, -0, -0, -0.477158, 0.878817, 300, 255, 1), +(6619, 180397, 0, 0, 0, 1, 1, -8842.51, 654.82, 97.2985, 3.80482, -0, -0, -0.945519, 0.325567, 300, 255, 1), +(6620, 180397, 0, 0, 0, 1, 1, -8847.17, 593.815, 93.454, 2.42601, -0, -0, -0.936673, -0.350206, 300, 255, 1), +(6621, 180397, 0, 0, 0, 1, 1, -8870.55, 545.077, 106.284, 5.06146, -0, -0, -0.573576, 0.819152, 300, 255, 1), +-- alterac +(6630, 180397, 530, 0, 0, 1, 1, -1666.9, 5187.86, -41.4536, 2.04204, -0, -0, -0.852641, -0.522496, 300, 255, 1), +(6632, 180397, 530, 0, 0, 1, 1, -1691.49, 5529.84, -40.4793, 0.087266, -0, -0, -0.0436194, -0.999048, 300, 255, 1), +(6636, 180397, 530, 0, 0, 1, 1, -1801.47, 5479.88, -12.4281, 0.610863, -0, -0, -0.300705, -0.953717, 300, 255, 1), +(6637, 180397, 530, 0, 0, 1, 1, -1812.75, 5367.69, -12.4281, 5.46288, -0, -0, -0.398748, 0.91706, 300, 255, 1), +(6641, 180397, 530, 0, 0, 1, 1, -1869.72, 5145.31, -43.819, 0.279252, -0, -0, -0.139173, -0.990268, 300, 255, 1), +(6642, 180397, 530, 0, 0, 1, 1, -1911.44, 5434.67, -12.4907, 0.436332, -0, -0, -0.216439, -0.976296, 300, 255, 1), +(6643, 180397, 530, 0, 0, 1, 1, -1913.13, 5493.83, -12.4281, 1.97222, -0, -0, -0.833885, -0.551938, 300, 255, 1), +(6644, 180397, 530, 0, 0, 1, 1, -1925.4, 5379.6, -12.4281, 4.08408, -0, -0, -0.891005, 0.453993, 300, 255, 1), +(6648, 180397, 530, 0, 0, 1, 1, -1951.57, 5251.61, -42.7737, 3.83973, -0, -0, -0.939692, 0.342021, 300, 255, 1), +(6649, 180397, 530, 0, 0, 1, 1, -2037.52, 5329.36, -39.9843, 3.28124, -0, -0, -0.997564, 0.0697647, 300, 255, 1), +(6650, 180397, 530, 0, 0, 1, 1, -2057.35, 5247.44, -38.8602, 0.401425, -0, -0, -0.199368, -0.979925, 300, 255, 1), +(6651, 180397, 571, 0, 0, 1, 1, 5913.94, 554.304, 660.998, 0.994837, -0, -0, -0.477158, -0.878817, 300, 255, 1), +(6654, 180397, 571, 0, 0, 1, 1, 5916.52, 566.397, 639.628, 3.56048, -0, -0, -0.978147, 0.207914, 300, 255, 1); + +DELETE FROM `game_event_gameobject` WHERE `guid` IN (6548,6553,6555,6557,6559,6561,6562,6563,6565,6567,6568,6573,6580,6585,6586,6587,6589,6591,6593,6594,6595,6596,6598,6601,6612,6613,6614,6615,6616,6618,6619,6620,6621,6630,6632,6636,6637,6641,6642,6643,6644,6648,6649,6650,6651,6654) AND `eventEntry` IN (18,19); +INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES +(19,6548),(19,6553),(19,6555),(19,6557), +(19,6559),(19,6561),(19,6562),(19,6563), +(19,6565),(19,6567),(19,6568),(19,6573), +(19,6580),(19,6585),(19,6586),(19,6587), +(19,6589),(19,6591),(19,6593),(19,6594), +(19,6595),(19,6596),(19,6598),(19,6601), +(19,6612),(19,6613),(19,6614),(19,6615), +(19,6616),(19,6618),(19,6619),(19,6620), +(19,6621), +-- alterac +(18,6630),(18,6632),(18,6636),(18,6637), +(18,6641),(18,6642),(18,6643),(18,6644), +(18,6648),(18,6649),(18,6650),(18,6651), +(18,6654),(18,6586),(18,6587),(18,6589), +(18,6591),(18,6593),(18,6594),(18,6595), +(18,6596),(18,6598),(18,6601),(18,6612), +(18,6613),(18,6614),(18,6615),(18,6616), +(18,6618),(18,6619),(18,6620),(18,6621); |