diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2021_08_31_00_world.sql | 377 |
1 files changed, 377 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_08_31_00_world.sql b/sql/updates/world/3.3.5/2021_08_31_00_world.sql new file mode 100644 index 00000000000..aa4dd0b3b99 --- /dev/null +++ b/sql/updates/world/3.3.5/2021_08_31_00_world.sql @@ -0,0 +1,377 @@ +-- +UPDATE `creature` SET `position_x` =27.9988,`position_y`=-45.4944,`position_z`=0.153898,`orientation`=2.33216 WHERE `guid`=83196 AND `id`=19167; +UPDATE `creature` SET `position_x` =28.5941,`position_y`=45.7436,`position_z`=0.0433099,`orientation`=3.81885 WHERE `guid`=83192 AND `id`=20990; +UPDATE `creature` SET `position_x` =29.567,`position_y`=37.1786,`position_z`=0.0143056,`orientation`=4.47002 WHERE `guid`=83191 AND `id`=20059; +UPDATE `creature` SET `position_x` =29.9797,`position_y`=-37.0793,`position_z`=0.00971293,`orientation`=1.69393 WHERE `guid`=83194 AND `id`=20059; +UPDATE `creature` SET `position_x` =30.2197,`position_y`=2.91536,`position_z`=0.0823943,`orientation`=3.29867 WHERE `guid`=83198 AND `id`=19166; +UPDATE `creature` SET `position_x` =33.9527,`position_y`=-44.7567,`position_z`=0.143825,`orientation`=0.585415 WHERE `guid`=83193 AND `id`=20990; +UPDATE `creature` SET `position_x` =34.3992,`position_y`=44.3313,`position_z`=-0.00000338256,`orientation`=5.32653 WHERE `guid`=83190 AND `id`=19510; +UPDATE `creature` SET `position_x` =37.175,`position_y`=-51.869,`position_z`=0.246396,`orientation`=4.11898 WHERE `guid`=83228 AND `id`=19167; +UPDATE `creature` SET `position_x` =37.398,`position_y`=64.646,`position_z`=0.246395,`orientation`=4.13643 WHERE `guid`=83188 AND `id`=19167; +UPDATE `creature` SET `position_x` =37.4107,`position_y`=54.8215,`position_z`=0.246395,`orientation`=2.3911 WHERE `guid`=83187 AND `id`=20990; +UPDATE `creature` SET `position_x` =37.4608,`position_y`=-60.7909,`position_z`=0.246396,`orientation`=2.6529 WHERE `guid`=83227 AND `id`=20990; +UPDATE `creature` SET `position_x` =77.5823,`position_y`=55.4032,`position_z`=15.008,`orientation`=3.19395 WHERE `guid`=83186 AND `id`=20990; +UPDATE `creature` SET `position_x` =77.8174,`position_y`=64.1236,`position_z`=15.008,`orientation`=3.26377 WHERE `guid`=83185 AND `id`=19167; +UPDATE `creature` SET `position_x` =77.9033,`position_y`=-51.9803,`position_z`=15.008,`orientation`=3.31613 WHERE `guid`=83226 AND `id`=19167; +UPDATE `creature` SET `position_x` =77.945,`position_y`=-60.8388,`position_z`=15.008,`orientation`=3.47321 WHERE `guid`=83225 AND `id`=20990; +UPDATE `creature` SET `position_x` =85.5276,`position_y`=20.2005,`position_z`=15.0044,`orientation`=0.663225 WHERE `guid`=83239 AND `id`=19218; +UPDATE `creature` SET `position_x` =92.3548,`position_y`=-79.2986,`position_z`=15.008,`orientation`=5.18363 WHERE `guid`=83220 AND `id`=19716; +UPDATE `creature` SET `position_x` =99.9308,`position_y`=-77.9516,`position_z`=15.0108,`orientation`=3.92699 WHERE `guid`=83219 AND `id`=19716; +UPDATE `creature` SET `position_x` =106.643,`position_y`=51.5014,`position_z`=15.008,`orientation`=3.92699 WHERE `guid`=87087 AND `id`=19716; +UPDATE `creature` SET `position_x` =108.424,`position_y`=-42.7796,`position_z`=15.008,`orientation`=5.16617 WHERE `guid`=83223 AND `id`=19712; +UPDATE `creature` SET `position_x` =109.46,`position_y`=58.5753,`position_z`=15.008,`orientation`=5.28835 WHERE `guid`=83182 AND `id`=19713; +UPDATE `creature` SET `position_x` =109.621,`position_y`=-55.2714,`position_z`=15.0071,`orientation`=0.680678 WHERE `guid`=83222 AND `id`=19712; +UPDATE `creature` SET `position_x` =112.692,`position_y`=45.9758,`position_z`=15.008,`orientation`=1.01229 WHERE `guid`=83183 AND `id`=19713; +UPDATE `creature` SET `position_x` =119.345,`position_y`=85.9118,`position_z`=15.0163,`orientation`=3.45575 WHERE `guid`=83178 AND `id`=19167; +UPDATE `creature` SET `position_x` =119.44,`position_y`=69.174,`position_z`=15.008,`orientation`=3.29867 WHERE `guid`=83179 AND `id`=20990; +UPDATE `creature` SET `position_x` =120.378,`position_y`=-82.3034,`position_z`=15.0098,`orientation`=3.21141 WHERE `guid`=83218 AND `id`=20990; +UPDATE `creature` SET `position_x` =120.598,`position_y`=-65.5737,`position_z`=15.008,`orientation`=3.24631 WHERE `guid`=83217 AND `id`=19167; +UPDATE `creature` SET `position_x` =131.22,`position_y`=-37.1084,`position_z`=0.0833343,`orientation`=3.9968 WHERE `guid`=83161 AND `id`=20988; +UPDATE `creature` SET `position_x` =131.681,`position_y`=40.4787,`position_z`=0.0833343,`orientation`=0.174533 WHERE `guid`=83164 AND `id`=20988; +UPDATE `creature` SET `position_x` =133.419,`position_y`=-40.7442,`position_z`=0.0833333,`orientation`=5.67232 WHERE `guid`=83163 AND `id`=19716; +UPDATE `creature` SET `position_x` =134.556,`position_y`=45.1142,`position_z`=0.0833333,`orientation`=1.32645 WHERE `guid`=83200 AND `id`=19716; +UPDATE `creature` SET `position_x` =138.291,`position_y`=-33.3404,`position_z`=0,`orientation`=1.59635 WHERE `guid`=83199 AND `id`=20988; +UPDATE `creature` SET `position_x` =139.542,`position_y`=149.319,`position_z`=25.659,`orientation`=4.59022 WHERE `guid`=83241 AND `id`=19220; +UPDATE `creature` SET `position_x` =140.177,`position_y`=50.3653,`position_z`=0.0811923,`orientation`=0.907571 WHERE `guid`=83166 AND `id`=19716; +UPDATE `creature` SET `position_x` =149.63,`position_y`=81.2452,`position_z`=6.46902,`orientation`=3.1427 WHERE `guid`=83177 AND `id`=19166; +UPDATE `creature` SET `position_x` =152.633,`position_y`=53.3561,`position_z`=0.0794043,`orientation`=2.68781 WHERE `guid`=83167 AND `id`=19716; +UPDATE `creature` SET `position_x` =160.69,`position_y`=-16.6626,`position_z`=0.0833323,`orientation`=2.0944 WHERE `guid`=83204 AND `id`=19716; +UPDATE `creature` SET `position_x` =165.423,`position_y`=77.9691,`position_z`=1.84254,`orientation`=3.29867 WHERE `guid`=83176 AND `id`=20990; +UPDATE `creature` SET `position_x` =165.639,`position_y`=-19.8589,`position_z`=0.0833333,`orientation`=5.88176 WHERE `guid`=83202 AND `id`=19713; +UPDATE `creature` SET `position_x` =165.7,`position_y`=85.5581,`position_z`=1.76883,`orientation`=3.21141 WHERE `guid`=83175 AND `id`=19510; +UPDATE `creature` SET `position_x` =165.844,`position_y`=-73.6567,`position_z`=1.72647,`orientation`=3.24631 WHERE `guid`=83216 AND `id`=19510; +UPDATE `creature` SET `position_x` =168.528,`position_y`=-11.8862,`position_z`=0.0833323,`orientation`=0.488692 WHERE `guid`=83205 AND `id`=19716; +UPDATE `creature` SET `position_x` =168.96,`position_y`=-87.2767,`position_z`=0.789825,`orientation`=3.19395 WHERE `guid`=83214 AND `id`=20990; +UPDATE `creature` SET `position_x` =169.258,`position_y`=-68.094,`position_z`=0.665288,`orientation`=3.26377 WHERE `guid`=83215 AND `id`=20059; +UPDATE `creature` SET `position_x` =169.373,`position_y`=92.1162,`position_z`=0.659512,`orientation`=3.35103 WHERE `guid`=83174 AND `id`=20059; +UPDATE `creature` SET `position_x` =174.125,`position_y`=-17.4886,`position_z`=0.0833343,`orientation`=3.9619 WHERE `guid`=83203 AND `id`=19713; +UPDATE `creature` SET `position_x` =180.165,`position_y`=34.5334,`position_z`=0.0769383,`orientation`=4.45059 WHERE `guid`=83171 AND `id`=19716; +UPDATE `creature` SET `position_x` =185.819,`position_y`=35.824,`position_z`=0.0775393,`orientation`=4.76475 WHERE `guid`=83201 AND `id`=19716; +UPDATE `creature` SET `position_x` =192.838,`position_y`=35.695,`position_z`=0.0776353,`orientation`=4.85202 WHERE `guid`=83170 AND `id`=19716; +UPDATE `creature` SET `position_x` =207.592,`position_y`=-91.1401,`position_z`=0.0897743,`orientation`=3.80482 WHERE `guid`=83207 AND `id`=19716; +UPDATE `creature` SET `position_x` =214.792,`position_y`=-83.1537,`position_z`=0.0890533,`orientation`=5.51524 WHERE `guid`=83210 AND `id`=19712; +UPDATE `creature` SET `position_x` =216.179,`position_y`=-95.2042,`position_z`=0.0891693,`orientation`=0.20944 WHERE `guid`=83209 AND `id`=19712; +UPDATE `creature` SET `position_x` =223.733,`position_y`=-62.9849,`position_z`=0.0856803,`orientation`=5.044 WHERE `guid`=83212 AND `id`=19712; +UPDATE `creature` SET `position_x` =226.571,`position_y`=60.2797,`position_z`=0.0791843,`orientation`=3.08923 WHERE `guid`=83172 AND `id`=19168; +UPDATE `creature` SET `position_x` =226.595,`position_y`=45.0895,`position_z`=0.0768293,`orientation`=3.1765 WHERE `guid`=83169 AND `id`=19168; +UPDATE `creature` SET `position_x` =227.934,`position_y`=-52.085,`position_z`=0.0838403,`orientation`=0.0523599 WHERE `guid`=83211 AND `id`=19713; +UPDATE `creature` SET `position_x` =272.078,`position_y`=-20.9663,`position_z`=26.4117,`orientation`=6.19592 WHERE `guid`=88276 AND `id`=19168; +UPDATE `creature` SET `position_x` =272.155,`position_y`=-24.6583,`position_z`=26.4117,`orientation`=6.16101 WHERE `guid`=67872 AND `id`=19168; +UPDATE `creature` SET `position_x` =274.302,`position_y`=-17.8064,`position_z`=26.4117,`orientation`=0.15708 WHERE `guid`=83235 AND `id`=19510; +UPDATE `creature` SET `position_x` =290.619,`position_y`=29.1206,`position_z`=25.4695,`orientation`=1.69297 WHERE `guid`=83234 AND `id`=19735; +UPDATE `creature` SET `position_x` =293.057,`position_y`=-13.0295,`position_z`=25.4695,`orientation`=4.86947 WHERE `guid`=83233 AND `id`=19735; +UPDATE `creature` SET `position_x` =309.243,`position_y`=10.2549,`position_z`=25.4695,`orientation`=3.1765 WHERE `guid`=83232 AND `id`=19510; +UPDATE `creature` SET `position_x` =309.331,`position_y`=15.1339,`position_z`=25.4695,`orientation`=3.07178 WHERE `guid`=75951 AND `id`=19168; +UPDATE `creature` SET `position_x` =309.518,`position_y`=20.2797,`position_z`=25.4735,`orientation`=2.70526 WHERE `guid`=83231 AND `id`=19510; +UPDATE `creature` SET `position_x` =326.517,`position_y`=13.1959,`position_z`=27.9199,`orientation`=3.22886 WHERE `guid`=83230 AND `id`=19221; + +UPDATE `creature` SET `position_x`=-177.471,`position_y`=-315.551,`position_z`=26.6426,`orientation`=3.19078 WHERE `guid`=131044 AND `id`=14881; +UPDATE `creature` SET `position_x`=-161.974,`position_y`=-290.733,`position_z`=27.1539,`orientation`=2.15799 WHERE `guid`=83396 AND `id`=18521; +UPDATE `creature` SET `position_x`=-158.783,`position_y`=-264.386,`position_z`=24.5375,`orientation`=1.99998 WHERE `guid`=83402 AND `id`=18521; +UPDATE `creature` SET `position_x`=-156.386,`position_y`=-276.651,`position_z`=26.6657,`orientation`=0.386776 WHERE `guid`=83398 AND `id`=18521; +UPDATE `creature` SET `position_x`=-148.484,`position_y`=-280.849,`position_z`=26.4151,`orientation`=1.44956 WHERE `guid`=83397 AND `id`=18524; +UPDATE `creature` SET `position_x`=-141.888,`position_y`=-252.918,`position_z`=26.7513,`orientation`=3.20392 WHERE `guid`=83410 AND `id`=18521; +UPDATE `creature` SET `position_x`=-139.45,`position_y`=-312.464,`position_z`=26.591,`orientation`=4.88843 WHERE `guid`=83411 AND `id`=18521; +UPDATE `creature` SET `position_x`=-138.909,`position_y`=-205.619,`position_z`=26.591,`orientation`=2.75762 WHERE `guid`=104764 AND `id`=18557; +UPDATE `creature` SET `position_x`=-135.661,`position_y`=-298.889,`position_z`=26.2331,`orientation`=6.26825 WHERE `guid`=83400 AND `id`=18524; +UPDATE `creature` SET `position_x`=-134.908,`position_y`=-246.095,`position_z`=26.4062,`orientation`=2.54641 WHERE `guid`=83393 AND `id`=18524; +UPDATE `creature` SET `position_x`=-133.863,`position_y`=-260.685,`position_z`=26.7964,`orientation`=3.32474 WHERE `guid`=83403 AND `id`=18524; +UPDATE `creature` SET `position_x`=-128.355,`position_y`=-303.92,`position_z`=26.5348,`orientation`=0.535889 WHERE `guid`=83414 AND `id`=18524; +UPDATE `creature` SET `position_x`=-128.317,`position_y`=-319.892,`position_z`=29.0651,`orientation`=2.07003 WHERE `guid`=131045 AND `id`=14881; +UPDATE `creature` SET `position_x`=-126.534,`position_y`=-292.312,`position_z`=27.3787,`orientation`=2.44333 WHERE `guid`=83413 AND `id`=18524; +UPDATE `creature` SET `position_x`=-124.255,`position_y`=-250.335,`position_z`=26.4197,`orientation`=1.14886 WHERE `guid`=83401 AND `id`=18521; +UPDATE `creature` SET `position_x`=-122.563,`position_y`=-166.736,`position_z`=26.6719,`orientation`=0.0698132 WHERE `guid`=83409 AND `id`=18497; +UPDATE `creature` SET `position_x`=-111.23,`position_y`=-170.612,`position_z`=26.5884,`orientation`=6.24808 WHERE `guid`=131042 AND `id`=14881; +UPDATE `creature` SET `position_x`=-110.443,`position_y`=-251.888,`position_z`=26.6921,`orientation`=4.41992 WHERE `guid`=131043 AND `id`=14881; +UPDATE `creature` SET `position_x`=-100.088,`position_y`=-395.205,`position_z`=26.5902,`orientation`=6.00872 WHERE `guid`=131046 AND `id`=14881; +UPDATE `creature` SET `position_x`=-70.3045,`position_y`=-369.064,`position_z`=26.5889,`orientation`=2.93665 WHERE `guid`=83418 AND `id`=18700; +UPDATE `creature` SET `position_x`=-70.1431,`position_y`=-377.464,`position_z`=26.5889,`orientation`=2.41523 WHERE `guid`=83417 AND `id`=18700; +UPDATE `creature` SET `position_x`=-68.5818,`position_y`=-407.449,`position_z`=26.669,`orientation`=2.40191 WHERE `guid`=83430 AND `id`=18700; +UPDATE `creature` SET `position_x`=-64.6625,`position_y`=-370.642,`position_z`=26.5877,`orientation`=5.50918 WHERE `guid`=83422 AND `id`=18700; +UPDATE `creature` SET `position_x`=-63.4261,`position_y`=-403.212,`position_z`=28.2132,`orientation`=2.40976 WHERE `guid`=83429 AND `id`=18700; +UPDATE `creature` SET `position_x`=-61.723,`position_y`=-410.1,`position_z`=26.5842,`orientation`=5.74203 WHERE `guid`=83431 AND `id`=18700; +UPDATE `creature` SET `position_x`=-59.3048,`position_y`=-373.747,`position_z`=26.5865,`orientation`=3.42052 WHERE `guid`=83421 AND `id`=18700; +UPDATE `creature` SET `position_x`=-59.0922,`position_y`=-398.448,`position_z`=28.0773,`orientation`=4.13243 WHERE `guid`=83428 AND `id`=18700; +UPDATE `creature` SET `position_x`=-57.5747,`position_y`=-380.266,`position_z`=26.5862,`orientation`=5.89537 WHERE `guid`=83425 AND `id`=18700; +UPDATE `creature` SET `position_x`=-56.8285,`position_y`=-361.219,`position_z`=26.6057,`orientation`=2.61762 WHERE `guid`=83424 AND `id`=18700; +UPDATE `creature` SET `position_x`=-55.2192,`position_y`=-402.075,`position_z`=30.4996,`orientation`=3.82747 WHERE `guid`=83434 AND `id`=18700; +UPDATE `creature` SET `position_x`=-53.6567,`position_y`=-401.499,`position_z`=30.5935,`orientation`=2.58309 WHERE `guid`=131048 AND `id`=14881; +UPDATE `creature` SET `position_x`=-52.4654,`position_y`=-412.465,`position_z`=27.3812,`orientation`=3.3343 WHERE `guid`=83437 AND `id`=18700; +UPDATE `creature` SET `position_x`=-52.4465,`position_y`=-393.722,`position_z`=26.8618,`orientation`=2.0119 WHERE `guid`=83432 AND `id`=18700; +UPDATE `creature` SET `position_x`=-50.3706,`position_y`=-404.235,`position_z`=30.0937,`orientation`=2.765 WHERE `guid`=83435 AND `id`=18700; +UPDATE `creature` SET `position_x`=-47.2449,`position_y`=-396.088,`position_z`=27.8634,`orientation`=4.01421 WHERE `guid`=83436 AND `id`=18700; +UPDATE `creature` SET `position_x`=-46.395,`position_y`=-374.709,`position_z`=26.5837,`orientation`=0.034518 WHERE `guid`=83433 AND `id`=18700; +UPDATE `creature` SET `position_x`=-45.9901,`position_y`=-396.985,`position_z`=27.6335,`orientation`=0.992938 WHERE `guid`=83438 AND `id`=18700; +UPDATE `creature` SET `position_x`=-45.0082,`position_y`=-364.026,`position_z`=26.5894,`orientation`=0.678474 WHERE `guid`=83420 AND `id`=18700; +UPDATE `creature` SET `position_x`=-37.0656,`position_y`=-354.198,`position_z`=26.9086,`orientation`=3.24631 WHERE `guid`=83419 AND `id`=18700; +UPDATE `creature` SET `position_x`=-35.9457,`position_y`=-339.216,`position_z`=39.7284,`orientation`=2.04204 WHERE `guid`=131047 AND `id`=14881; +UPDATE `creature` SET `position_x`=-33.1605,`position_y`=-399.026,`position_z`=24.1222,`orientation`=2.53145 WHERE `guid`=83445 AND `id`=18700; +UPDATE `creature` SET `position_x`=-31.8871,`position_y`=-417.658,`position_z`=26.6254,`orientation`=2.14758 WHERE `guid`=83441 AND `id`=18700; +UPDATE `creature` SET `position_x`=-31.5695,`position_y`=-365.555,`position_z`=26.5876,`orientation`=2.55308 WHERE `guid`=83439 AND `id`=18700; +UPDATE `creature` SET `position_x`=-30.413,`position_y`=-374.279,`position_z`=22.4392,`orientation`=4.84041 WHERE `guid`=83442 AND `id`=18700; +UPDATE `creature` SET `position_x`=-30.1582,`position_y`=-392.926,`position_z`=21.7793,`orientation`=3.97676 WHERE `guid`=83440 AND `id`=18700; +UPDATE `creature` SET `position_x`=-29.4017,`position_y`=-408.563,`position_z`=26.5948,`orientation`=5.70352 WHERE `guid`=83443 AND `id`=18700; +UPDATE `creature` SET `position_x`=-29.3163,`position_y`=-352.118,`position_z`=28.9317,`orientation`=2.74699 WHERE `guid`=83444 AND `id`=18700; +UPDATE `creature` SET `position_x`=-24.4075,`position_y`=-163.498,`position_z`=26.1806,`orientation`=0 WHERE `guid`=83388 AND `id`=18371; +UPDATE `creature` SET `position_x`=-24.0462,`position_y`=-358.84,`position_z`=26.6029,`orientation`=2.8543 WHERE `guid`=83449 AND `id`=18700; +UPDATE `creature` SET `position_x`=-23.3478,`position_y`=-410.185,`position_z`=26.6766,`orientation`=2.98451 WHERE `guid`=83415 AND `id`=18702; +UPDATE `creature` SET `position_x`=-23.215,`position_y`=-367.904,`position_z`=26.5809,`orientation`=5.23207 WHERE `guid`=83446 AND `id`=18700; +UPDATE `creature` SET `position_x`=-20.7826,`position_y`=-405.465,`position_z`=25.457,`orientation`=3.34263 WHERE `guid`=83451 AND `id`=18700; +UPDATE `creature` SET `position_x`=-20.6588,`position_y`=-365.69,`position_z`=26.6666,`orientation`=2.96706 WHERE `guid`=83416 AND `id`=18702; +UPDATE `creature` SET `position_x`=-18.1281,`position_y`=-417.606,`position_z`=26.6054,`orientation`=5.9907 WHERE `guid`=83448 AND `id`=18700; +UPDATE `creature` SET `position_x`=-17.6507,`position_y`=-354.635,`position_z`=26.592,`orientation`=0.73305 WHERE `guid`=83452 AND `id`=18700; +UPDATE `creature` SET `position_x`=-16.1842,`position_y`=-398.594,`position_z`=20.0514,`orientation`=0.351872 WHERE `guid`=83450 AND `id`=18700; +UPDATE `creature` SET `position_x`=-15.6334,`position_y`=-361.086,`position_z`=26.592,`orientation`=5.39091 WHERE `guid`=88279 AND `id`=18700; +UPDATE `creature` SET `position_x`=-14.0088,`position_y`=-376.06,`position_z`=20.4852,`orientation`=4.41723 WHERE `guid`=83447 AND `id`=18700; +UPDATE `creature` SET `position_x`=-11.1523,`position_y`=-406.241,`position_z`=26.0604,`orientation`=1.29952 WHERE `guid`=88278 AND `id`=18700; +UPDATE `creature` SET `position_x`=-9.05497,`position_y`=-370.899,`position_z`=24.5258,`orientation`=2.36652 WHERE `guid`=88277 AND `id`=18700; +UPDATE `creature` SET `position_x`=3.69389,`position_y`=-402.123,`position_z`=22.7468,`orientation`=1.35306 WHERE `guid`=88285 AND `id`=18700; +UPDATE `creature` SET `position_x`=7.3566,`position_y`=-356.588,`position_z`=26.6072,`orientation`=3.05877 WHERE `guid`=130982 AND `id`=18700; +UPDATE `creature` SET `position_x`=7.60485,`position_y`=-360.054,`position_z`=26.5985,`orientation`=0.594376 WHERE `guid`=130979 AND `id`=18700; +UPDATE `creature` SET `position_x`=8.66713,`position_y`=-372.301,`position_z`=23.4212,`orientation`=3.10271 WHERE `guid`=88281 AND `id`=18700; +UPDATE `creature` SET `position_x`=9.20711,`position_y`=-417.385,`position_z`=26.5897,`orientation`=5.34991 WHERE `guid`=130993 AND `id`=18700; +UPDATE `creature` SET `position_x`=9.49306,`position_y`=-398.799,`position_z`=20.2107,`orientation`=2.7445 WHERE `guid`=88284 AND `id`=18700; +UPDATE `creature` SET `position_x`=10.5346,`position_y`=-405.984,`position_z`=25.8244,`orientation`=3.4646 WHERE `guid`=88289 AND `id`=18700; +UPDATE `creature` SET `position_x`=13.3255,`position_y`=-430.955,`position_z`=30.9726,`orientation`=0.00879814 WHERE `guid`=131049 AND `id`=14881; +UPDATE `creature` SET `position_x`=13.349,`position_y`=-415.713,`position_z`=26.5905,`orientation`=0.471585 WHERE `guid`=88286 AND `id`=18700; +UPDATE `creature` SET `position_x`=16.9976,`position_y`=-383.822,`position_z`=19.835,`orientation`=2.56856 WHERE `guid`=88280 AND `id`=18700; +UPDATE `creature` SET `position_x`=17.9803,`position_y`=-400.051,`position_z`=21.1782,`orientation`=5.53106 WHERE `guid`=88288 AND `id`=18700; +UPDATE `creature` SET `position_x`=21.4631,`position_y`=-374.647,`position_z`=23.3184,`orientation`=1.09664 WHERE `guid`=88283 AND `id`=18700; +UPDATE `creature` SET `position_x`=21.7843,`position_y`=-160.77,`position_z`=13.6514,`orientation`=3.07178 WHERE `guid`=83407 AND `id`=18497; +UPDATE `creature` SET `position_x`=21.8998,`position_y`=-360.027,`position_z`=26.6169,`orientation`=4.6256 WHERE `guid`=88291 AND `id`=18700; +UPDATE `creature` SET `position_x`=22.0397,`position_y`=-380.514,`position_z`=23.8942,`orientation`=4.34587 WHERE `guid`=130981 AND `id`=18700; +UPDATE `creature` SET `position_x`=24.6692,`position_y`=-414.843,`position_z`=26.5985,`orientation`=1.08112 WHERE `guid`=88287 AND `id`=18700; +UPDATE `creature` SET `position_x`=25.2437,`position_y`=-166.95,`position_z`=13.9402,`orientation`=2.79253 WHERE `guid`=83395 AND `id`=18497; +UPDATE `creature` SET `position_x`=25.7139,`position_y`=-340.025,`position_z`=45.4138,`orientation`=2.84489 WHERE `guid`=131052 AND `id`=14881; +UPDATE `creature` SET `position_x`=30.3119,`position_y`=-414.808,`position_z`=26.5964,`orientation`=1.19962 WHERE `guid`=130994 AND `id`=18700; +UPDATE `creature` SET `position_x`=33.1965,`position_y`=-402.76,`position_z`=26.5827,`orientation`=2.463 WHERE `guid`=131000 AND `id`=18700; +UPDATE `creature` SET `position_x`=45.9705,`position_y`=15.7843,`position_z`=-0.130654,`orientation`=1.54717 WHERE `guid`=131005 AND `id`=14881; +UPDATE `creature` SET `position_x`=49.7898,`position_y`=-369.159,`position_z`=26.6682,`orientation`=6.02139 WHERE `guid`=131050 AND `id`=14881; +UPDATE `creature` SET `position_x`=66.7658,`position_y`=-388.345,`position_z`=26.6733,`orientation`=2.93215 WHERE `guid`=83453 AND `id`=18373; +UPDATE `creature` SET `position_x`=72.8591,`position_y`=46.5644,`position_z`=24.3768,`orientation`=6.12611 WHERE `guid`=131003 AND `id`=19416; +UPDATE `creature` SET `position_x`=77.844,`position_y`=-8.14455,`position_z`=0.0200513,`orientation`=4.46804 WHERE `guid`=83362 AND `id`=18495; +UPDATE `creature` SET `position_x`=77.844,`position_y`=-8.14455,`position_z`=0.0200513,`orientation`=4.46804 WHERE `guid`=83361 AND `id`=18493; +UPDATE `creature` SET `position_x`=78.3841,`position_y`=39.2966,`position_z`=4.34502,`orientation`=1.39626 WHERE `guid`=83363 AND `id`=18493; +UPDATE `creature` SET `position_x`=78.3841,`position_y`=39.2966,`position_z`=4.34502,`orientation`=1.39626 WHERE `guid`=83365 AND `id`=18495; +UPDATE `creature` SET `position_x`=81.6418,`position_y`=-8.10273,`position_z`=0.0192883,`orientation`=4.5204 WHERE `guid`=83364 AND `id`=18495; +UPDATE `creature` SET `position_x`=81.6418,`position_y`=-8.10273,`position_z`=0.0192883,`orientation`=4.5204 WHERE `guid`=83360 AND `id`=18493; +UPDATE `creature` SET `position_x`=85.0451,`position_y`=48.407,`position_z`=13.0171,`orientation`=6.21337 WHERE `guid`=131001 AND `id`=19416; +UPDATE `creature` SET `position_x`=85.3603,`position_y`=8.43024,`position_z`=0.0183203,`orientation`=1.41372 WHERE `guid`=83353 AND `id`=18493; +UPDATE `creature` SET `position_x`=85.3603,`position_y`=8.43024,`position_z`=0.0183203,`orientation`=1.41372 WHERE `guid`=83355 AND `id`=18495; +UPDATE `creature` SET `position_x`=85.4925,`position_y`=47.0914,`position_z`=24.3883,`orientation`=6.12611 WHERE `guid`=131002 AND `id`=19416; +UPDATE `creature` SET `position_x`=85.7186,`position_y`=39.3367,`position_z`=4.3449,`orientation`=1.48353 WHERE `guid`=83358 AND `id`=18493; +UPDATE `creature` SET `position_x`=85.7186,`position_y`=39.3367,`position_z`=4.3449,`orientation`=1.48353 WHERE `guid`=83359 AND `id`=18495; +UPDATE `creature` SET `position_x`=86.5258,`position_y`=-4.11577,`position_z`=-0.0558314,`orientation`=3.1491 WHERE `guid`=83379 AND `id`=18493; +UPDATE `creature` SET `position_x`=86.5258,`position_y`=-4.11577,`position_z`=-0.0558314,`orientation`=3.1491 WHERE `guid`=131065 AND `id`=18495; +UPDATE `creature` SET `position_x`=87.4967,`position_y`=-38.8735,`position_z`=4.34452,`orientation`=4.53786 WHERE `guid`=83366 AND `id`=18495; +UPDATE `creature` SET `position_x`=87.4967,`position_y`=-38.8735,`position_z`=4.34452,`orientation`=4.53786 WHERE `guid`=83357 AND `id`=18493; +UPDATE `creature` SET `position_x`=88.9477,`position_y`=43.0602,`position_z`=4.2616,`orientation`=3.46547 WHERE `guid`=131006 AND `id`=14881; +UPDATE `creature` SET `position_x`=89.7787,`position_y`=8.61549,`position_z`=0.0193293,`orientation`=1.48353 WHERE `guid`=83352 AND `id`=18493; +UPDATE `creature` SET `position_x`=89.7787,`position_y`=8.61549,`position_z`=0.0193293,`orientation`=1.48353 WHERE `guid`=83354 AND `id`=18495; +UPDATE `creature` SET `position_x`=97.3622,`position_y`=4.19907,`position_z`=-0.0982199,`orientation`=3.35687 WHERE `guid`=83383 AND `id`=18493; +UPDATE `creature` SET `position_x`=97.3622,`position_y`=4.19907,`position_z`=-0.0982199,`orientation`=3.35687 WHERE `guid`=131067 AND `id`=18495; +UPDATE `creature` SET `position_x`=97.6782,`position_y`=-48.1763,`position_z`=13.0289,`orientation`=3.89208 WHERE `guid`=131007 AND `id`=14881; +UPDATE `creature` SET `position_x`=98.0462,`position_y`=46.837,`position_z`=24.4001,`orientation`=6.12611 WHERE `guid`=131004 AND `id`=19416; +UPDATE `creature` SET `position_x`=117.888,`position_y`=-4.55226,`position_z`=0.0504783,`orientation`=0.872665 WHERE `guid`=83369 AND `id`=18495; +UPDATE `creature` SET `position_x`=122.388,`position_y`=3.71186,`position_z`=-0.0462477,`orientation`=4.10152 WHERE `guid`=83376 AND `id`=18493; +UPDATE `creature` SET `position_x`=122.388,`position_y`=3.71186,`position_z`=-0.0462477,`orientation`=4.10152 WHERE `guid`=83367 AND `id`=18495; +UPDATE `creature` SET `position_x`=125.417,`position_y`=-3.26788,`position_z`=0.206791,`orientation`=2.44346 WHERE `guid`=83390 AND `id`=18497; +UPDATE `creature` SET `position_x`=132.257,`position_y`=-19.2386,`position_z`=6.38628,`orientation`=0.0174533 WHERE `guid`=83375 AND `id`=18493; +UPDATE `creature` SET `position_x`=136.688,`position_y`=-26.0343,`position_z`=9.3865,`orientation`=0.645772 WHERE `guid`=83377 AND `id`=18493; +UPDATE `creature` SET `position_x`=139.131,`position_y`=39.385,`position_z`=4.34416,`orientation`=1.46608 WHERE `guid`=83368 AND `id`=18493; +UPDATE `creature` SET `position_x`=148.659,`position_y`=39.4251,`position_z`=4.3441,`orientation`=1.309 WHERE `guid`=83370 AND `id`=18495; +UPDATE `creature` SET `position_x`=148.659,`position_y`=39.4251,`position_z`=4.3441,`orientation`=1.309 WHERE `guid`=83371 AND `id`=18493; +UPDATE `creature` SET `position_x`=159.082,`position_y`=48.3018,`position_z`=13.0052,`orientation`=2.72271 WHERE `guid`=131008 AND `id`=14881; +UPDATE `creature` SET `position_x`=183.139,`position_y`=-184.69,`position_z`=26.5629,`orientation`=0.0112374 WHERE `guid`=131040 AND `id`=14881; +UPDATE `creature` SET `position_x`=187.004,`position_y`=4.80022,`position_z`=-0.0385287,`orientation`=4.95674 WHERE `guid`=83389 AND `id`=18497; +UPDATE `creature` SET `position_x`=189.555,`position_y`=-3.3563,`position_z`=0.0817743,`orientation`=1.58825 WHERE `guid`=83382 AND `id`=18493; +UPDATE `creature` SET `position_x`=189.555,`position_y`=-3.3563,`position_z`=0.0817743,`orientation`=1.58825 WHERE `guid`=131057 AND `id`=18495; +UPDATE `creature` SET `position_x`=225.46,`position_y`=-163.388,`position_z`=26.6746,`orientation`=6.05629 WHERE `guid`=83387 AND `id`=18493; +UPDATE `creature` SET `position_x`=227.658,`position_y`=-170.581,`position_z`=26.6746,`orientation`=0.523599 WHERE `guid`=83408 AND `id`=18497; +UPDATE `creature` SET `position_x`=227.66,`position_y`=-155.121,`position_z`=26.6746,`orientation`=5.35816 WHERE `guid`=83384 AND `id`=18493; +UPDATE `creature` SET `position_x`=230.386,`position_y`=19.433,`position_z`=0.0195813,`orientation`=1.41372 WHERE `guid`=83380 AND `id`=18493; +UPDATE `creature` SET `position_x`=230.386,`position_y`=19.433,`position_z`=0.0195813,`orientation`=1.41372 WHERE `guid`=131060 AND `id`=18495; +UPDATE `creature` SET `position_x`=238.861,`position_y`=-85.661,`position_z`=26.5913,`orientation`=1.57851 WHERE `guid`=83372 AND `id`=18495; +UPDATE `creature` SET `position_x`=238.921,`position_y`=-76.4597,`position_z`=26.5913,`orientation`=4.70458 WHERE `guid`=83391 AND `id`=18497; +UPDATE `creature` SET `position_x`=239.785,`position_y`=-199.028,`position_z`=26.6746,`orientation`=2.88579 WHERE `guid`=131041 AND `id`=14881; +UPDATE `creature` SET `position_x`=242.325,`position_y`=-15.5678,`position_z`=0.0219153,`orientation`=0.820305 WHERE `guid`=83381 AND `id`=18493; +UPDATE `creature` SET `position_x`=242.325,`position_y`=-15.5678,`position_z`=0.0219153,`orientation`=0.820305 WHERE `guid`=131061 AND `id`=18495; +UPDATE `creature` SET `position_x`=246.983,`position_y`=-88.6826,`position_z`=26.5913,`orientation`=0.040453 WHERE `guid`=131013 AND `id`=14881; +UPDATE `creature` SET `position_x`=247.791,`position_y`=-9.66694,`position_z`=0.0264493,`orientation`=3.92699 WHERE `guid`=83373 AND `id`=18495; +UPDATE `creature` SET `position_x`=247.791,`position_y`=-9.66694,`position_z`=0.0264493,`orientation`=3.92699 WHERE `guid`=131062 AND `id`=18497; +UPDATE `creature` SET `position_x`=248.782,`position_y`=26.7058,`position_z`=0.0120203,`orientation`=2.72271 WHERE `guid`=131009 AND `id`=14881; +UPDATE `creature` SET `position_x`=264.098,`position_y`=-166.266,`position_z`=26.6746,`orientation`=4.64258 WHERE `guid`=131019 AND `id`=14881; +UPDATE `creature` SET `position_x`=278.048,`position_y`=-162.845,`position_z`=26.6746,`orientation`=2.9147 WHERE `guid`=131039 AND `id`=14881; + +UPDATE `creature` SET `position_x`=-268.488,`position_y`=184.286,`position_z`=0.117212,`orientation`=0.610865 WHERE `guid`=48441 AND `id`=18319; +UPDATE `creature` SET `position_x`=-266.165,`position_y`=190.07,`position_z`=0.117231,`orientation`=5.68977 WHERE `guid`=48962 AND `id`=18319; +UPDATE `creature` SET `position_x`=-259.193,`position_y`=191.827,`position_z`=0.119915,`orientation`=5.41052 WHERE `guid`=45076 AND `id`=18328; +UPDATE `creature` SET `position_x`=-256.164,`position_y`=287.916,`position_z`=26.8606,`orientation`=4.77475 WHERE `guid`=45186 AND `id`=21891; +UPDATE `creature` SET `position_x`=-254.629,`position_y`=170.189,`position_z`=0.174548,`orientation`=5.84685 WHERE `guid`=86720 AND `id`=3300; +UPDATE `creature` SET `position_x`=-252.052,`position_y`=278.292,`position_z`=27.2019,`orientation`=4.03605 WHERE `guid`=45137 AND `id`=21891; +UPDATE `creature` SET `position_x`=-248.445,`position_y`=282.806,`position_z`=27.5006,`orientation`=6.15205 WHERE `guid`=45207 AND `id`=21891; +UPDATE `creature` SET `position_x`=-248.428,`position_y`=247.221,`position_z`=26.7268,`orientation`=1.84641 WHERE `guid`=130974 AND `id`=14881; +UPDATE `creature` SET `position_x`=-247.199,`position_y`=294.801,`position_z`=27.0599,`orientation`=0.308006 WHERE `guid`=86734 AND `id`=3300; +UPDATE `creature` SET `position_x`=-246.584,`position_y`=275.858,`position_z`=27.0558,`orientation`=5.84549 WHERE `guid`=45135 AND `id`=21891; +UPDATE `creature` SET `position_x`=-246.218,`position_y`=159.874,`position_z`=0.151296,`orientation`=0.383972 WHERE `guid`=38664 AND `id`=18328; +UPDATE `creature` SET `position_x`=-246.162,`position_y`=212.185,`position_z`=26.8225,`orientation`=4.76475 WHERE `guid`=83280 AND `id`=18322; +UPDATE `creature` SET `position_x`=-245.401,`position_y`=164.807,`position_z`=0.152779,`orientation`=0.0349066 WHERE `guid`=45074 AND `id`=18319; +UPDATE `creature` SET `position_x`=-244.473,`position_y`=289.473,`position_z`=27.3913,`orientation`=0.862899 WHERE `guid`=45209 AND `id`=21891; +UPDATE `creature` SET `position_x`=-244.417,`position_y`=199.308,`position_z`=0.147565,`orientation`=2.56563 WHERE `guid`=130973 AND `id`=14881; +UPDATE `creature` SET `position_x`=-243.294,`position_y`=288.046,`position_z`=27.4779,`orientation`=5.48582 WHERE `guid`=45206 AND `id`=21891; +UPDATE `creature` SET `position_x`=-241.915,`position_y`=155.992,`position_z`=0.145592,`orientation`=1.78024 WHERE `guid`=38931 AND `id`=18319; +UPDATE `creature` SET `position_x`=-241.57,`position_y`=280.769,`position_z`=27.1945,`orientation`=4.58558 WHERE `guid`=46702 AND `id`=21891; +UPDATE `creature` SET `position_x`=-239.393,`position_y`=211.818,`position_z`=26.9014,`orientation`=4.53786 WHERE `guid`=83298 AND `id`=18322; +UPDATE `creature` SET `position_x`=-238.19,`position_y`=275.695,`position_z`=26.7466,`orientation`=1.0172 WHERE `guid`=46674 AND `id`=21891; +UPDATE `creature` SET `position_x`=-235.199,`position_y`=185.948,`position_z`=1.49576,`orientation`=2.20961 WHERE `guid`=45134 AND `id`=21891; +UPDATE `creature` SET `position_x`=-234.728,`position_y`=286.702,`position_z`=26.8192,`orientation`=5.55045 WHERE `guid`=46656 AND `id`=21891; +UPDATE `creature` SET `position_x`=-229.605,`position_y`=190.135,`position_z`=4.00196,`orientation`=5.41001 WHERE `guid`=45077 AND `id`=21891; +UPDATE `creature` SET `position_x`=-227.288,`position_y`=185.072,`position_z`=3.31209,`orientation`=0.352243 WHERE `guid`=45100 AND `id`=21891; +UPDATE `creature` SET `position_x`=-224.817,`position_y`=180.553,`position_z`=1.73431,`orientation`=4.7822 WHERE `guid`=86741 AND `id`=4075; +UPDATE `creature` SET `position_x`=-222.749,`position_y`=187.644,`position_z`=4.64263,`orientation`=5.92952 WHERE `guid`=45101 AND `id`=21891; +UPDATE `creature` SET `position_x`=-218.645,`position_y`=341.311,`position_z`=26.8966,`orientation`=4.01301 WHERE `guid`=86736 AND `id`=4075; +UPDATE `creature` SET `position_x`=-214.735,`position_y`=315.29,`position_z`=32.2854,`orientation`=2.76134 WHERE `guid`=47272 AND `id`=21891; +UPDATE `creature` SET `position_x`=-213.888,`position_y`=313.43,`position_z`=34.4401,`orientation`=3.6881 WHERE `guid`=47275 AND `id`=21891; +UPDATE `creature` SET `position_x`=-213.718,`position_y`=177.579,`position_z`=27.0924,`orientation`=0 WHERE `guid`=130972 AND `id`=14881; +UPDATE `creature` SET `position_x`=-210.945,`position_y`=343.908,`position_z`=26.7195,`orientation`=5.00909 WHERE `guid`=49159 AND `id`=18319; +UPDATE `creature` SET `position_x`=-210.865,`position_y`=318.439,`position_z`=30.8079,`orientation`=0.938359 WHERE `guid`=46987 AND `id`=21891; +UPDATE `creature` SET `position_x`=-209.257,`position_y`=312.305,`position_z`=32.5999,`orientation`=0.934477 WHERE `guid`=47274 AND `id`=21891; +UPDATE `creature` SET `position_x`=-205.541,`position_y`=169.512,`position_z`=0.0943313,`orientation`=0.15708 WHERE `guid`=83294 AND `id`=18322; +UPDATE `creature` SET `position_x`=-205.418,`position_y`=176.437,`position_z`=0.0943633,`orientation`=6.07375 WHERE `guid`=83259 AND `id`=18322; +UPDATE `creature` SET `position_x`=-203.842,`position_y`=336.054,`position_z`=26.7195,`orientation`=2.37365 WHERE `guid`=83292 AND `id`=18325; +UPDATE `creature` SET `position_x`=-202.409,`position_y`=343.725,`position_z`=26.7195,`orientation`=3.71755 WHERE `guid`=84492 AND `id`=18326; +UPDATE `creature` SET `position_x`=-202.409,`position_y`=343.725,`position_z`=26.7195,`orientation`=3.71755 WHERE `guid`=12160 AND `id`=18325; +UPDATE `creature` SET `position_x`=-202.105,`position_y`=179.908,`position_z`=0.0947793,`orientation`=2.16421 WHERE `guid`=95101 AND `id`=4076; +UPDATE `creature` SET `position_x`=-201.274,`position_y`=313.071,`position_z`=27.8368,`orientation`=1.85618 WHERE `guid`=47273 AND `id`=21891; +UPDATE `creature` SET `position_x`=-189.205,`position_y`=316.803,`position_z`=26.7118,`orientation`=5.04503 WHERE `guid`=86735 AND `id`=3300; +UPDATE `creature` SET `position_x`=-188.227,`position_y`=342.497,`position_z`=27.4732,`orientation`=3.44713 WHERE `guid`=47938 AND `id`=21891; +UPDATE `creature` SET `position_x`=-187.882,`position_y`=327.554,`position_z`=25.7593,`orientation`=4.39441 WHERE `guid`=47277 AND `id`=21891; +UPDATE `creature` SET `position_x`=-185.436,`position_y`=281.248,`position_z`=26.6656,`orientation`=0.994838 WHERE `guid`=83293 AND `id`=18325; +UPDATE `creature` SET `position_x`=-181.154,`position_y`=332.425,`position_z`=26.11,`orientation`=2.66803 WHERE `guid`=47930 AND `id`=21891; +UPDATE `creature` SET `position_x`=-178.999,`position_y`=337.939,`position_z`=27.3219,`orientation`=1.38444 WHERE `guid`=47278 AND `id`=21891; +UPDATE `creature` SET `position_x`=-178.804,`position_y`=276.966,`position_z`=26.7434,`orientation`=1.81514 WHERE `guid`=84668 AND `id`=18325; +UPDATE `creature` SET `position_x`=-178.804,`position_y`=276.966,`position_z`=26.7434,`orientation`=1.81514 WHERE `guid`=83291 AND `id`=18326; +UPDATE `creature` SET `position_x`=-171.081,`position_y`=282.286,`position_z`=26.705,`orientation`=3.07178 WHERE `guid`=49161 AND `id`=18319; +UPDATE `creature` SET `position_x`=-163.745,`position_y`=166.369,`position_z`=0.00686605,`orientation`=1.47833 WHERE `guid`=86739 AND `id`=4075; +UPDATE `creature` SET `position_x`=-160.813,`position_y`=157.043,`position_z`=0.0940953,`orientation`=1.0821 WHERE `guid`=132569 AND `id`=18956; +UPDATE `creature` SET `position_x`=-149.697,`position_y`=199.331,`position_z`=0.0107667,`orientation`=0.947749 WHERE `guid`=86740 AND `id`=4075; +UPDATE `creature` SET `position_x`=-148.94,`position_y`=280.837,`position_z`=26.732,`orientation`=4.14789 WHERE `guid`=130975 AND `id`=14881; +UPDATE `creature` SET `position_x`=-144.827,`position_y`=173.557,`position_z`=1.76865,`orientation`=0.0698132 WHERE `guid`=83270 AND `id`=18472; +UPDATE `creature` SET `position_x`=-141.666,`position_y`=283.046,`position_z`=26.8142,`orientation`=2.77507 WHERE `guid`=83299 AND `id`=18322; +UPDATE `creature` SET `position_x`=-141.137,`position_y`=291.284,`position_z`=26.8141,`orientation`=3.78736 WHERE `guid`=83296 AND `id`=18322; +UPDATE `creature` SET `position_x`=-123.771,`position_y`=270.043,`position_z`=27.3312,`orientation`=1.02974 WHERE `guid`=83289 AND `id`=18325; +UPDATE `creature` SET `position_x`=-123.42,`position_y`=176.658,`position_z`=0.0107683,`orientation`=5.56882 WHERE `guid`=89279 AND `id`=4076; +UPDATE `creature` SET `position_x`=-118.563,`position_y`=266.142,`position_z`=27.1713,`orientation`=2.35619 WHERE `guid`=84845 AND `id`=18319; +UPDATE `creature` SET `position_x`=-118.563,`position_y`=266.142,`position_z`=27.1713,`orientation`=2.35619 WHERE `guid`=84844 AND `id`=18326; +UPDATE `creature` SET `position_x`=-118.563,`position_y`=266.142,`position_z`=27.1713,`orientation`=2.35619 WHERE `guid`=49348 AND `id`=18325; +UPDATE `creature` SET `position_x`=-116.565,`position_y`=279.975,`position_z`=26.9728,`orientation`=0.198993 WHERE `guid`=86650 AND `id`=2914; +UPDATE `creature` SET `position_x`=-114.001,`position_y`=268.488,`position_z`=26.8762,`orientation`=2.47837 WHERE `guid`=83283 AND `id`=18320; +UPDATE `creature` SET `position_x`=-102.481,`position_y`=170.061,`position_z`=0.0932373,`orientation`=0.488692 WHERE `guid`=14544 AND `id`=18323; +UPDATE `creature` SET `position_x`=-102.429,`position_y`=177.586,`position_z`=0.0932183,`orientation`=6.16101 WHERE `guid`=14547 AND `id`=18323; +UPDATE `creature` SET `position_x`=-101.464,`position_y`=301.913,`position_z`=26.5678,`orientation`=2.0944 WHERE `guid`=83290 AND `id`=18325; +UPDATE `creature` SET `position_x`=-101.33,`position_y`=309.882,`position_z`=26.6086,`orientation`=5.81195 WHERE `guid`=86084 AND `id`=18319; +UPDATE `creature` SET `position_x`=-101.33,`position_y`=309.882,`position_z`=26.6086,`orientation`=5.81195 WHERE `guid`=86083 AND `id`=18325; +UPDATE `creature` SET `position_x`=-101.33,`position_y`=309.882,`position_z`=26.6086,`orientation`=5.81195 WHERE `guid`=49353 AND `id`=18326; +UPDATE `creature` SET `position_x`=-93.743,`position_y`=315.541,`position_z`=26.5577,`orientation`=4.45059 WHERE `guid`=49354 AND `id`=18320; +UPDATE `creature` SET `position_x`=-89.9677,`position_y`=262.71,`position_z`=26.9184,`orientation`=2.11185 WHERE `guid`=12163 AND `id`=18325; +UPDATE `creature` SET `position_x`=-86.2176,`position_y`=107.357,`position_z`=0.0899813,`orientation`=0.785398 WHERE `guid`=40191 AND `id`=18328; +UPDATE `creature` SET `position_x`=-85.7283,`position_y`=113.408,`position_z`=0.00719496,`orientation`=0.740413 WHERE `guid`=86738 AND `id`=4075; +UPDATE `creature` SET `position_x`=-84.3042,`position_y`=266.641,`position_z`=26.8913,`orientation`=3.00197 WHERE `guid`=86094 AND `id`=18326; +UPDATE `creature` SET `position_x`=-84.3042,`position_y`=266.641,`position_z`=26.8913,`orientation`=3.00197 WHERE `guid`=86093 AND `id`=18325; +UPDATE `creature` SET `position_x`=-84.3042,`position_y`=266.641,`position_z`=26.8913,`orientation`=3.00197 WHERE `guid`=12161 AND `id`=18319; +UPDATE `creature` SET `position_x`=-83.8602,`position_y`=113.572,`position_z`=0.0905293,`orientation`=5.8294 WHERE `guid`=35868 AND `id`=18328; +UPDATE `creature` SET `position_x`=-82.058,`position_y`=273.058,`position_z`=26.8913,`orientation`=3.82227 WHERE `guid`=83278 AND `id`=18320; +UPDATE `creature` SET `position_x`=-80.6658,`position_y`=105.136,`position_z`=0.0905313,`orientation`=2.32129 WHERE `guid`=34049 AND `id`=18327; +UPDATE `creature` SET `position_x`=-80.2958,`position_y`=317.626,`position_z`=27.2346,`orientation`=5.95816 WHERE `guid`=95103 AND `id`=4076; +UPDATE `creature` SET `position_x`=-76.569,`position_y`=83.7339,`position_z`=0.0905353,`orientation`=0.785398 WHERE `guid`=39819 AND `id`=18328; +UPDATE `creature` SET `position_x`=-76.1875,`position_y`=89.6284,`position_z`=0.0905363,`orientation`=5.68977 WHERE `guid`=39820 AND `id`=18328; +UPDATE `creature` SET `position_x`=-75.4351,`position_y`=173.65,`position_z`=0.0930253,`orientation`=5.81195 WHERE `guid`=43422 AND `id`=18328; +UPDATE `creature` SET `position_x`=-75.2177,`position_y`=130.819,`position_z`=0.0905363,`orientation`=4.92183 WHERE `guid`=14332 AND `id`=18323; +UPDATE `creature` SET `position_x`=-74.8093,`position_y`=156.332,`position_z`=0.00707158,`orientation`=5.78743 WHERE `guid`=86780 AND `id`=4076; +UPDATE `creature` SET `position_x`=-69.1325,`position_y`=83.7427,`position_z`=0.0905363,`orientation`=2.82743 WHERE `guid`=34061 AND `id`=18327; +UPDATE `creature` SET `position_x`=-68.5954,`position_y`=173.012,`position_z`=0.0928473,`orientation`=4.17134 WHERE `guid`=43280 AND `id`=18328; +UPDATE `creature` SET `position_x`=-67.7294,`position_y`=178.199,`position_z`=0.0107787,`orientation`=3.88639 WHERE `guid`=86649 AND `id`=2914; +UPDATE `creature` SET `position_x`=-66.5132,`position_y`=314.623,`position_z`=27.116,`orientation`=4.57276 WHERE `guid`=83281 AND `id`=18320; +UPDATE `creature` SET `position_x`=-66.4524,`position_y`=131.136,`position_z`=0.0905423,`orientation`=4.85202 WHERE `guid`=14543 AND `id`=18323; +UPDATE `creature` SET `position_x`=-65.7626,`position_y`=167.779,`position_z`=0.0931773,`orientation`=3.40339 WHERE `guid`=36693 AND `id`=18327; +UPDATE `creature` SET `position_x`=-60.3833,`position_y`=114.664,`position_z`=0.0905323,`orientation`=5.68977 WHERE `guid`=39818 AND `id`=18327; +UPDATE `creature` SET `position_x`=-60.1442,`position_y`=311.666,`position_z`=27.2029,`orientation`=3.87463 WHERE `guid`=86096 AND `id`=18326; +UPDATE `creature` SET `position_x`=-60.1442,`position_y`=311.666,`position_z`=27.2029,`orientation`=3.87463 WHERE `guid`=86095 AND `id`=18325; +UPDATE `creature` SET `position_x`=-60.1442,`position_y`=311.666,`position_z`=27.2029,`orientation`=3.87463 WHERE `guid`=83268 AND `id`=18319; +UPDATE `creature` SET `position_x`=-59.5877,`position_y`=304.91,`position_z`=26.624,`orientation`=3.1765 WHERE `guid`=83287 AND `id`=18325; +UPDATE `creature` SET `position_x`=-58.9359,`position_y`=280.054,`position_z`=26.9994,`orientation`=1.72788 WHERE `guid`=83282 AND `id`=18320; +UPDATE `creature` SET `position_x`=-58.0166,`position_y`=107.975,`position_z`=0.0905323,`orientation`=1.55334 WHERE `guid`=34060 AND `id`=18318; +UPDATE `creature` SET `position_x`=-55.1719,`position_y`=269.535,`position_z`=26.8482,`orientation`=3.16975 WHERE `guid`=86737 AND `id`=4075; +UPDATE `creature` SET `position_x`=-51.8655,`position_y`=110.682,`position_z`=0.0905323,`orientation`=3.78736 WHERE `guid`=38975 AND `id`=18328; +UPDATE `creature` SET `position_x`=-51.7741,`position_y`=285.914,`position_z`=26.9791,`orientation`=4.31096 WHERE `guid`=83284 AND `id`=18325; +UPDATE `creature` SET `position_x`=-49.5232,`position_y`=280.175,`position_z`=26.9465,`orientation`=2.63545 WHERE `guid`=86599 AND `id`=18326; +UPDATE `creature` SET `position_x`=-49.5232,`position_y`=280.175,`position_z`=26.9465,`orientation`=2.63545 WHERE `guid`=86598 AND `id`=18325; +UPDATE `creature` SET `position_x`=-49.5232,`position_y`=280.175,`position_z`=26.9465,`orientation`=2.63545 WHERE `guid`=83285 AND `id`=18319; +UPDATE `creature` SET `position_x`=-44.6356,`position_y`=91.4519,`position_z`=0.363462,`orientation`=3.61136 WHERE `guid`=86752 AND `id`=4076; +UPDATE `creature` SET `position_x`=-15.6102,`position_y`=279.94,`position_z`=26.7316,`orientation`=4.65956 WHERE `guid`=83265 AND `id`=21904; +UPDATE `creature` SET `position_x`=-10.1333,`position_y`=281.479,`position_z`=26.8139,`orientation`=2.79253 WHERE `guid`=83279 AND `id`=18320; +UPDATE `creature` SET `position_x`=-10.1305,`position_y`=292.403,`position_z`=26.814,`orientation`=3.38594 WHERE `guid`=12162 AND `id`=18321; +UPDATE `creature` SET `position_x`=-3.69868,`position_y`=103.478,`position_z`=0.0905183,`orientation`=6.17847 WHERE `guid`=14327 AND `id`=18323; +UPDATE `creature` SET `position_x`=-3.55375,`position_y`=97.3215,`position_z`=0.0905183,`orientation`=0.418879 WHERE `guid`=14326 AND `id`=18323; +UPDATE `creature` SET `position_x`=-1.86749,`position_y`=284.605,`position_z`=26.7797,`orientation`=3.00197 WHERE `guid`=83269 AND `id`=18326; +UPDATE `creature` SET `position_x`=-1.16489,`position_y`=289.906,`position_z`=26.7753,`orientation`=3.21141 WHERE `guid`=83286 AND `id`=18325; +UPDATE `creature` SET `position_x`=11.3015,`position_y`=265.33,`position_z`=26.2511,`orientation`=0.549663 WHERE `guid`=130976 AND `id`=14881; +UPDATE `creature` SET `position_x`=11.9275,`position_y`=102.475,`position_z`=0.506651,`orientation`=0.959931 WHERE `guid`=14561 AND `id`=18318; +UPDATE `creature` SET `position_x`=16.9091,`position_y`=106.144,`position_z`=0.50665,`orientation`=4.45059 WHERE `guid`=34052 AND `id`=18327; +UPDATE `creature` SET `position_x`=20.4726,`position_y`=81.6956,`position_z`=0.0484983,`orientation`=5.51524 WHERE `guid`=14558 AND `id`=18318; +UPDATE `creature` SET `position_x`=21.7359,`position_y`=73.6921,`position_z`=0.598185,`orientation`=1.0821 WHERE `guid`=34051 AND `id`=18327; +UPDATE `creature` SET `position_x`=23.5709,`position_y`=293.13,`position_z`=25.0943,`orientation`=1.72881 WHERE `guid`=86718 AND `id`=2914; +UPDATE `creature` SET `position_x`=27.6608,`position_y`=76.7642,`position_z`=0.286547,`orientation`=2.77507 WHERE `guid`=14551 AND `id`=18318; +UPDATE `creature` SET `position_x`=36.5259,`position_y`=99.3303,`position_z`=0.234139,`orientation`=6.26573 WHERE `guid`=34048 AND `id`=18318; +UPDATE `creature` SET `position_x`=40.1056,`position_y`=52.9475,`position_z`=0.0908273,`orientation`=4.93928 WHERE `guid`=14325 AND `id`=18323; +UPDATE `creature` SET `position_x`=41.987,`position_y`=130.147,`position_z`=0.186184,`orientation`=5.11381 WHERE `guid`=14330 AND `id`=18323; +UPDATE `creature` SET `position_x`=43.636,`position_y`=106.916,`position_z`=0.234138,`orientation`=4.76475 WHERE `guid`=34059 AND `id`=18327; +UPDATE `creature` SET `position_x`=44.7227,`position_y`=286.96,`position_z`=25.1521,`orientation`=3.97935 WHERE `guid`=83300 AND `id`=18473; +UPDATE `creature` SET `position_x`=46.9831,`position_y`=52.3525,`position_z`=0.0908193,`orientation`=4.34587 WHERE `guid`=14324 AND `id`=18323; +UPDATE `creature` SET `position_x`=47.768,`position_y`=130.486,`position_z`=0.173826,`orientation`=4.83456 WHERE `guid`=14331 AND `id`=18323; +UPDATE `creature` SET `position_x`=50.9244,`position_y`=98.9922,`position_z`=0.234138,`orientation`=3.10669 WHERE `guid`=14638 AND `id`=18318; +UPDATE `creature` SET `position_x`=54.8938,`position_y`=328.39,`position_z`=26.6239,`orientation`=1.0398 WHERE `guid`=130977 AND `id`=14881; +UPDATE `creature` SET `position_x`=55.5351,`position_y`=78.7888,`position_z`=-0.00838766,`orientation`=1.29154 WHERE `guid`=34057 AND `id`=18327; +UPDATE `creature` SET `position_x`=58.4921,`position_y`=83.405,`position_z`=0.227436,`orientation`=4.32842 WHERE `guid`=14634 AND `id`=18318; +UPDATE `creature` SET `position_x`=61.906,`position_y`=248.265,`position_z`=26.5268,`orientation`=1.21205 WHERE `guid`=95107 AND `id`=4076; +UPDATE `creature` SET `position_x`=66.6838,`position_y`=101.475,`position_z`=0.0631034,`orientation`=2.34482 WHERE `guid`=86648 AND `id`=2914; +UPDATE `creature` SET `position_x`=75.8563,`position_y`=116.047,`position_z`=0.350004,`orientation`=5.5676 WHERE `guid`=14579 AND `id`=18318; +UPDATE `creature` SET `position_x`=81.9067,`position_y`=112.337,`position_z`=0.412234,`orientation`=3.21141 WHERE `guid`=34056 AND `id`=18327; +UPDATE `creature` SET `position_x`=90.7193,`position_y`=104.321,`position_z`=0.186003,`orientation`=3.56047 WHERE `guid`=14329 AND `id`=18323; +UPDATE `creature` SET `position_x`=90.7534,`position_y`=96.9339,`position_z`=0.0905183,`orientation`=2.94961 WHERE `guid`=14328 AND `id`=18323; + +DELETE FROM `creature_summon_groups` WHERE `summonerId` = 19481 AND `summonerType` = 0; +INSERT INTO `creature_summon_groups` (`summonerId`,`summonerType`,`groupId`,`entry`,`position_x`,`position_y`,`position_z`,`orientation`,`summonType`,`summonTime`,`Comment`) VALUES +(19481,0,0,19916,2240.225341796875, 2234.1865234375, 136.1903228759765625, 0.715584993362426757,3,13000,"Archmage Vargoth - Group 0 - Archmage's Ritual Crystal"), +(19481,0,0,19916,2236.69873046875, 2224.656982421875, 136.419189453125, 5.637413501739501953,3,13000,"Archmage Vargoth - Group 0 - Archmage's Ritual Crystal"), +(19481,0,0,19924,2236.65966796875, 2224.678955078125, 136.4153594970703125, 5.218534469604492187,3,13000,"Archmage Vargoth - Group 0 - Invis Ritual Crystal"), +(19481,0,0,19924,2248.510986328125, 2239.90576171875, 136.592132568359375, 5.044001579284667968,3,13000,"Archmage Vargoth - Group 0 - Invis Ritual Crystal"), +(19481,0,0,19924,2240.181396484375, 2234.1982421875, 136.186431884765625, 0.104719758033752441,3,13000,"Archmage Vargoth - Group 0 - Invis Ritual Crystal"), +(19481,0,0,19916,2248.530517578125, 2239.877685546875, 136.5948028564453125, 5.602506637573242187,3,13000,"Archmage Vargoth - Group 0 - Archmage's Ritual Crystal"); + +UPDATE `gameobject` SET `position_x` = 44.77155685424804687, `position_y` = 150.7210693359375, `position_z` = -0.034145999699831, `orientation` = 1.570795774459838867, `rotation2` = 0.707106590270996093, `rotation3` = 0.707106947898864746, `VerifiedBuild` = 12340 WHERE `guid` = 28507 AND `id` = 183398; +UPDATE `gameobject_addon` SET `parent_rotation2` = 1, `parent_rotation3` = -0.00000004371138828 WHERE `guid` = 28507; + +UPDATE `creature` SET `position_x`=-5272.158203125,`position_y`=471.59375,`position_z`=386.891082763671875,`orientation`=4.171336650848388671 WHERE `guid`=130847 AND `id`=39420; +UPDATE `creature` SET `position_x`=-5299.2880859375,`position_y`=554.82293701171875,`position_z`=386.44189453125,`orientation`=4.171336650848388671 WHERE `guid`=130848 AND `id`=39420; +UPDATE `creature` SET `position_x`=-5299.33154296875,`position_y`=466.90625,`position_z`=386.6923828125,`orientation`=4.171336650848388671 WHERE `guid`=130849 AND `id`=39420; + +DELETE FROM `creature_summon_groups` WHERE `summonerId` = 19671 AND `summonerType` = 0; +DELETE FROM `creature_summon_groups` WHERE `summonerId` = 183850 AND `summonerType` = 1; +INSERT INTO `creature_summon_groups` (`summonerId`,`summonerType`,`groupId`,`entry`,`position_x`,`position_y`,`position_z`,`orientation`,`summonType`,`summonTime`,`Comment`) VALUES +(19671,0,0,18315,-375.89005,-130.7981,-0.95874935,4.699304103851318359,6,300000,"Cryo-Engineer Sha'heen - Group 0 - Ethereal Theurgist"), -- 0xF130478B0000B7B0 +(19671,0,0,18315,-374.61023,-197.6735,-0.9794866,1.653192043304443359,6,300000,"Cryo-Engineer Sha'heen - Group 0 - Ethereal Theurgist"), -- 0xF130478B0000B7B1 +(19671,0,0,18312,-370.30167,-131.25328,-0.95874065,4.57273101806640625,6,300000,"Cryo-Engineer Sha'heen - Group 0 - Ethereal Spellbinder"), -- 0xF13047880000B7B2 +(19671,0,0,18312,-369.85764,-197.36095,-0.9686134,1.860104799270629882,6,300000,"Cryo-Engineer Sha'heen - Group 0 - Ethereal Spellbinder"), -- 0xF13047880000B7B3 +(19671,0,1,18313,-284.01434,-188.3314,-0.35524964,0.929492592811584472,6,300000,"Cryo-Engineer Sha'heen - Group 1 - Ethereal Sorcerer"), -- 0xF13047890000B829 +(19671,0,1,18313,-288.83862,-178.64357,-0.55568826,0.658058345317840576,6,300000,"Cryo-Engineer Sha'heen - Group 1 - Ethereal Sorcerer"), -- 0xF13047890000B82A +(19671,0,1,18313,-224.9607,-172.39752,-1.0441809,2.721638679504394531,6,300000,"Cryo-Engineer Sha'heen - Group 1 - Ethereal Sorcerer"), -- 0xF13047890000B82B +(19671,0,1,18311,-237.70796,-186.74799,-0.95137125,1.658005952835083007,6,300000,"Cryo-Engineer Sha'heen - Group 1 - Ethereal Crypt Raider"), -- 0xF13047870000B82C +(19671,0,2,19666,-36.3667,1.31717,-0.954333,3.2856,6,300000,"Cryo-Engineer Sha'heen - Group 2 - Shadow Lord Xiraxis"), +(183850,1,0,19672,-360.1015,-67.558876,-0.87543267,0.209439516067504882,8,0,"Consortium Transporter - Group 0 - Consortium Laborer"), +(183850,1,0,19673,-375.72964,-88.8795,-0.8754307,3.385938644409179687,8,0,"Consortium Transporter - Group 0 - Consortium Engineer"), +(183850,1,0,19672,-386.84702,-72.835556,-0.8754347,2.635447263717651367,8,0,"Consortium Transporter - Group 0 - Consortium Laborer"), +(183850,1,0,19672,-370.8748,-82.775795,-0.8754287,0.087266460061073303,8,0,"Consortium Transporter - Group 0 - Consortium Laborer"), +(183850,1,0,19672,-374.69434,-63.504593,-0.87543166,0.575958669185638427,8,0,"Consortium Transporter - Group 0 - Consortium Laborer"), +(183850,1,0,19673,-358.8426,-74.0751,-0.87266266,0.680678427219390869,8,0,"Consortium Transporter - Group 0 - Consortium Engineer"), +(183850,1,0,19672,-386.89282,-60.84314,-0.8754397,3.368485450744628906,8,0,"Consortium Transporter - Group 0 - Consortium Laborer"); |