diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2017_03_20_01_world_335.sql | 96 |
1 files changed, 96 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_03_20_01_world_335.sql b/sql/updates/world/3.3.5/2017_03_20_01_world_335.sql new file mode 100644 index 00000000000..a0bd400a2e5 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_03_20_01_world_335.sql @@ -0,0 +1,96 @@ +SET @OGUID := 55735; +DELETE FROM `gameobject` WHERE `map`=568; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +(@OGUID+0 ,186305,568,1,1,124.203,1022.95,34.1441,-1.57952,0,0,-0.710185,0.704015,43200,255,1), +(@OGUID+1 ,186733,568,1,1,-150.912,1343.15,49.785,-1.02974,0,0,-0.492423,0.870356,1,255,1), +(@OGUID+2 ,187359,568,1,1,134.009,1642.8,42.0841,3.14159,0,0,-1,0,25,255,1), +(@OGUID+3 ,186728,568,1,1,120.294,1605.67,63.1804,3.13883,0,0,0.999999,0.00138107,180,255,1), +(@OGUID+4 ,186633,568,1,1,-79.2179,1125.98,5.53967,-1.93732,0,0,-0.824126,0.566406,-604800,255,1), +(@OGUID+5 ,186633,568,1,1,-80.7119,1124.81,5.59401,-1.95477,0,0,-0.829037,0.559194,-604800,255,1), +(@OGUID+6 ,186633,568,1,1,332.322,1084.61,6.23159,-0.872664,0,0,-0.422618,0.906308,-604800,255,1), +(@OGUID+7 ,186633,568,1,1,332.423,1083.13,6.30574,2.46091,0,0,0.942641,0.333808,-604800,255,1), +(@OGUID+8 ,186633,568,1,1,331.155,1084.52,6.2764,0.750491,0,0,0.366501,0.930418,-604800,255,1), +(@OGUID+9 ,186633,568,1,1,333.545,1085.66,6.32405,-0.733038,0,0,-0.358368,0.93358,-604800,255,1), +(@OGUID+10,186633,568,1,1,330.726,1086.47,6.22998,0.767944,0,0,0.374606,0.927184,-604800,255,1), +(@OGUID+11,186633,568,1,1,343.771,1151.66,6.34366,-2.87979,0,0,-0.991445,0.130528,-604800,255,1), +(@OGUID+12,186633,568,1,1,341.88,1151.76,6.34366,-0.820303,0,0,-0.398748,0.91706,-604800,255,1), +(@OGUID+13,186633,568,1,1,345.407,1152.75,6.34366,-1.309,0,0,-0.608761,0.793354,-604800,255,1), +(@OGUID+14,186633,568,1,1,343.2,1150.49,6.34366,0.087266,0,0,0.0436192,0.999048,-604800,255,1), +(@OGUID+15,186633,568,1,1,424.528,1081.66,6.75976,1.11701,0,0,0.529919,0.848048,-604800,255,1), +(@OGUID+16,186633,568,1,1,425.217,1085.2,6.49234,-1.64061,0,0,-0.731354,0.681998,-604800,255,1), +(@OGUID+17,186633,568,1,1,423.058,1082.9,6.68479,-0.349065,0,0,-0.173648,0.984808,-604800,255,1), +(@OGUID+18,186633,568,1,1,305.952,1466.29,81.6448,-2.19912,0,0,-0.891006,0.453991,-604800,255,1), +(@OGUID+19,186633,568,1,1,304.405,1465.53,81.6934,-2.75761,0,0,-0.981627,0.190812,-604800,255,1), +(@OGUID+20,186633,568,1,1,305.355,1467.36,81.6934,0.837757,0,0,0.406736,0.913546,-604800,255,1), +(@OGUID+21,186634,568,1,1,-79.5859,1124.89,5.57584,0.90757,0,0,0.438371,0.898794,-604800,255,1), +(@OGUID+22,186634,568,1,1,-80.4313,1126.02,5.59401,-0.575957,0,0,-0.284015,0.95882,-604800,255,1), +(@OGUID+23,186634,568,1,1,304.023,1467.73,81.5893,0.750491,0,0,0.366501,0.930418,-604800,255,1), +(@OGUID+24,186648,568,1,1,-135.194,1333.05,48.1739,2.3911,0,0,0.930417,0.366502,604800,255,1), +(@OGUID+25,186658,568,1,1,-79.9851,1125.34,5.594,-3.05433,0,0,-0.999048,0.0436193,604800,255,1), +(@OGUID+26,180771,568,1,1,141.189,717.505,45.1114,-1.55334,0,0,-0.700909,0.713251,-604800,255,1), +(@OGUID+27,180771,568,1,1,99.5758,717.845,45.1114,1.55334,0,0,0.700909,0.713251,-604800,255,1), +(@OGUID+28,180771,568,1,1,119.808,657.875,51.679,1.65806,0,0,0.737277,0.675591,-604800,255,1), +(@OGUID+29,186667,568,1,1,-80.0906,1125.3,5.594,-1.29154,0,0,-0.601814,0.798636,604800,255,1), +(@OGUID+30,186671,568,1,1,343.357,1152.03,6.34366,-2.93214,0,0,-0.994521,0.104536,180,255,1), +(@OGUID+31,186671,568,1,1,344.333,1084.68,6.96691,2.96704,0,0,0.996194,0.087165,180,255,1), +(@OGUID+32,186671,568,1,1,332.369,1084.42,6.28005,3.07177,0,0,0.999391,0.0349061,180,255,1), +(@OGUID+33,186671,568,1,1,424.256,1083.61,6.60608,1.09956,0,0,0.522498,0.85264,180,255,1), +(@OGUID+34,186672,568,1,1,424.102,1083.67,6.60312,0.680677,0,0,0.333806,0.942642,604800,255,1), +(@OGUID+35,186430,568,1,1,251.429,996.856,10.912,2.11185,0,0,0.870356,0.492424,604800,255,1), +(@OGUID+36,185434,568,1,1,-146.864,1332.22,48.1739,-0.95993,0,0,-0.461748,0.887011,180,255,1), +(@OGUID+37,185434,568,1,1,-75.1178,1137.77,5.21104,1.16937,0,0,0.551936,0.833886,180,255,1), +(@OGUID+38,185434,568,1,1,293.915,1458.4,81.5059,-1.25664,0,0,-0.587785,0.809017,180,255,1), +(@OGUID+39,185434,568,1,1,343.361,1311.33,81.5876,0.017452,0,0,0.00872612,0.999962,180,255,1), +(@OGUID+40,185434,568,1,1,-73.5284,1139.15,5.19407,-2.26892,0,0,-0.906307,0.422619,180,255,1), +(@OGUID+41,185434,568,1,1,-23.8944,1332.41,48.1739,0.645772,0,0,0.317305,0.948324,180,255,1), +(@OGUID+42,185434,568,1,1,392.563,1155.37,6.34364,-1.81514,0,0,-0.788011,0.615662,180,255,1), +(@OGUID+43,185438,568,1,1,-150.023,1350.04,48.1739,-0.575957,0,0,-0.284015,0.95882,180,255,1), +(@OGUID+44,185438,568,1,1,398.786,1086.32,5.35751,2.84488,0,0,0.989016,0.147811,180,255,1), +(@OGUID+45,185454,568,1,1,-28.1068,1338.44,48.1739,-1.53589,0,0,-0.694658,0.71934,180,255,1), +(@OGUID+46,185454,568,1,1,-132.61,1341.92,48.1739,0.890117,0,0,0.430511,0.902586,180,255,1), +(@OGUID+47,185454,568,1,1,305.403,1460.19,81.5059,-1.18682,0,0,-0.559193,0.829038,180,255,1), +(@OGUID+48,185454,568,1,1,297.778,1461.44,81.5059,-1.8675,0,0,-0.803857,0.594823,180,255,1), +(@OGUID+49,185454,568,1,1,337.444,1323.92,81.5876,-2.89724,0,0,-0.992546,0.12187,180,255,1), +(@OGUID+50,185454,568,1,1,-150.251,1337.35,48.1739,0.855211,0,0,0.414693,0.909961,180,255,1), +(@OGUID+51,185454,568,1,1,346.202,1314.28,81.5876,1.95477,0,0,0.829038,0.559193,180,255,1), +(@OGUID+52,185454,568,1,1,396.143,1148.68,6.34339,2.56563,0,0,0.958819,0.284016,180,255,1), +(@OGUID+53,185454,568,1,1,345.458,1324.55,81.5876,0.837757,0,0,0.406736,0.913546,180,255,1), +(@OGUID+54,185454,568,1,1,411.937,1123.93,6.10051,-0.436332,0,0,-0.216439,0.976296,180,255,1), +(@OGUID+55,185455,568,1,1,-133.912,1335.87,48.1739,0.226892,0,0,0.113203,0.993572,180,255,1), +(@OGUID+56,185455,568,1,1,341.998,1320.82,81.5876,-0.90757,0,0,-0.438371,0.898794,180,255,1), +(@OGUID+57,185455,568,1,1,291.797,1464.71,81.506,0.680677,0,0,0.333806,0.942642,180,255,1), +(@OGUID+58,185455,568,1,1,-147.718,1342.07,48.1739,-0.541051,0,0,-0.267238,0.963631,180,255,1), +(@OGUID+59,185455,568,1,1,-24.0499,1343.66,48.1739,-0.069812,0,0,-0.0348988,0.999391,180,255,1), +(@OGUID+60,185455,568,1,1,298.285,1454.72,81.5059,0.244346,0,0,0.121869,0.992546,180,255,1), +(@OGUID+61,185455,568,1,1,335.697,1314.94,81.5876,0.314158,0,0,0.156434,0.987688,180,255,1), +(@OGUID+62,185455,568,1,1,300.462,1470.83,81.506,1.88495,0,0,0.809016,0.587786,180,255,1), +(@OGUID+63,186482,568,1,1,-74.6319,1138.7,5.20206,0,0,0,0,1,180,255,0), +(@OGUID+64,186482,568,1,1,341.059,1311.29,81.5876,0.017452,0,0,0.00872612,0.999962,180,255,0), +(@OGUID+65,186482,568,1,1,383.488,1152.29,6.34366,3.12412,0,0,0.999962,0.00873464,180,255,0), +(@OGUID+66,186482,568,1,1,294.252,1457.96,81.5059,-1.3439,0,0,-0.622514,0.782609,180,255,0), +(@OGUID+67,186482,568,1,1,-149.09,1349.99,48.1739,-2.19912,0,0,-0.891006,0.453991,180,255,0), +(@OGUID+68,186482,568,1,1,-22.0915,1350.19,48.1739,2.26892,0,0,0.906307,0.422619,180,255,0), +(@OGUID+69,186745,568,1,1,120.146,665.572,51.7082,-0.453785,0,0,-0.224951,0.97437,-604800,255,1), +(@OGUID+70,186748,568,1,1,99.8802,694.349,45.1114,0.837757,0,0,0.406736,0.913546,-604800,255,1), +(@OGUID+71,186750,568,1,1,140.644,694.009,45.1114,-2.00713,0,0,-0.843391,0.5373,-604800,255,1), +(@OGUID+72,187021,568,1,1,305.775,1467.31,81.5875,1.53589,0,0,0.694658,0.71934,604800,255,1), +(@OGUID+73,187035,568,1,1,132.464,1334.19,-9.37467,-2.53072,0,0,-0.953716,0.300708,180,255,1), +(@OGUID+74,187036,568,1,1,98.8152,1245.41,-9.49482,1.43117,0,0,0.656058,0.75471,180,255,1), +(@OGUID+75,187037,568,1,1,132.373,1244.41,-9.6476,0.296705,0,0,0.147809,0.989016,180,255,1), +(@OGUID+76,186303,568,1,1,305.908,1112.09,9.9566,3.14159,0,0,-1,0,180,255,1), +(@OGUID+77,186304,568,1,1,375.41,1057.67,9.86144,-1.5708,0,0,-0.707107,0.707107,180,255,0), +(@OGUID+78,186306,568,1,1,123.256,914.421,34.1441,-1.57952,0,0,-0.710185,0.704015,180,255,1), +(@OGUID+79,186338,568,1,1,397.309,1083.46,5.41724,-0.017452,0,0,-0.00872612,0.999962,180,255,1), +(@OGUID+80,186338,568,1,1,-23.4402,1333.18,48.1739,0.017452,0,0,0.00872612,0.999962,180,255,1), +(@OGUID+81,186338,568,1,1,398.437,1152.45,6.34364,3.14159,0,0,-1,0,180,255,1), +(@OGUID+82,191460,568,1,1,245.824,1018.73,3.55061,-2.92342,0,0,-0.994056,0.108872,180,255,1), +(@OGUID+83,186858,568,1,1,337.066,1396.09,74.1723,-2.8536,0,0,-0.989651,0.143497,180,255,0), +(@OGUID+84,186859,568,1,1,120.294,732.008,45.011,1.56207,0,0,0.704015,0.710185,180,255,0), +(@OGUID+85,186860,568,1,1,99.9827,1333.95,-9.39569,0.59341,0,0,0.292371,0.956305,180,255,1), +(@OGUID+86,187377,568,1,1,-147.731,1333.47,48.1739,-0.872664,0,0,-0.422618,0.906308,180,255,1), +(@OGUID+87,186865,568,1,1,92.7648,707.518,45.1114,0.017452,0,0,0.00872612,0.999962,-604800,255,1), +(@OGUID+88,187378,568,1,1,296.334,1468.37,81.506,-2.51327,0,0,-0.951056,0.309017,180,255,1), +(@OGUID+89,187379,568,1,1,-73.7866,1164.58,5.2034,3.14159,0,0,-1,0,180,255,1), +(@OGUID+90,187380,568,1,1,383.674,1083.18,5.75323,0.017452,0,0,0.00872612,0.999962,180,255,1), +(@OGUID+91,186622,568,1,1,305.514,1467.34,81.5059,-2.32129,0,0,-0.91706,0.39875,180,255,1), +(@OGUID+92,186623,568,1,1,307.208,1464.14,81.6032,-0.104719,0,0,-0.0523357,0.99863,180,255,1); |