Ravie
24.10.2014, 16:11
-- Месть Ормера[294]
DELETE FROM creature WHERE guid=10426;
INSERT INTO creature VALUES (10426,1021,0,1,1,0,0,-3604.69,-1395.16,10.6392,3.10633,600,5,0,664,0,0,1);
DELETE FROM creature WHERE guid=10487;
INSERT INTO creature VALUES (10487,1021,0,1,1,0,0,-3688.78,-1341.39,12.7086,0.0715559,600,5,0,664,0,0,1);
DELETE FROM creature WHERE guid=10576;
INSERT INTO creature VALUES (10576,1021,0,1,1,0,0,-3740.83,-1346.08,25.3309,0.845945,600,5,0,712,0,0,1);
DELETE FROM creature WHERE guid=9749;
INSERT INTO creature VALUES (9749,1021,0,1,1,0,0,-3646.61,-1275.26,10.4607,4.88446,600,5,0,664,0,0,1);
DELETE FROM creature WHERE guid=9744;
INSERT INTO creature VALUES (9744,1021,0,1,1,0,0,-3488.2,-1375.17,9.22856,4.6944,600,5,0,664,0,0,1);
DELETE FROM creature WHERE guid=9739;
INSERT INTO creature VALUES (9739,1021,0,1,1,0,0,-3379.21,-1463.55,9.45494,3.876,600,5,0,712,0,0,1);
--------------------------------------------------------------------------------------------------------------
-- Месть Ормера[295]
DELETE FROM creature WHERE guid=2975;
INSERT INTO creature VALUES (2975,1023,0,1,1,0,0,-3452.43,-1847.98,24.6042,2.89303,600,6,0,839,0,0,1);
DELETE FROM creature WHERE guid=10284;
INSERT INTO creature VALUES (10284,1023,0,1,1,0,0,-3312.48,-1913.93,33.5016,3.56687,600,9,0,839,0,0,1);
DELETE FROM creature WHERE guid=10753;
INSERT INTO creature VALUES (10753,1022,0,1,1,0,0,-3321.21,-1876.75,25.0645,3.03702,600,5,0,787,0,0,1);
DELETE FROM creature WHERE guid=10795;
INSERT INTO creature VALUES (10795,1022,0,1,1,0,0,-3519.95,-1791.44,24.731,4.89973,600,5,0,787,0,0,1);
DELETE FROM creature WHERE guid=10831;
INSERT INTO creature VALUES (10831,1022,0,1,1,0,0,-3402.66,-1806.24,17.3725,3.1522,600,5,0,787,0,0,1);
DELETE FROM creature WHERE guid=10842;
INSERT INTO creature VALUES (10842,1022,0,1,1,0,0,-3443.74,-1782.35,17.3056,2.72415,600,5,0,787,0,0,1);
DELETE FROM creature WHERE guid=10879;
INSERT INTO creature VALUES (10879,1022,0,1,1,0,0,-3311.35,-1924.02,34.646,2.60475,600,5,0,787,0,0,1);
--------------------------------------------------------------------------------------------------------------
-- Месть Ормера[296]
UPDATE creature SET position_x = '-3568.646973', position_y = '-1766.171875', position_z = '80.791023', orientation = '0.956603' WHERE guid = '10134';
--------------------------------------------------------------------------------------------------------------
-- Угроза из глубин[279]
UPDATE creature SET position_x = '-3187.011963', position_y = '-1034.915894', position_z = '9.265803', orientation = '0.141741' WHERE guid = '10492';
UPDATE creature SET position_x = '-3284.095215', position_y = '-1019.165039', position_z = '9.145651', orientation = '2.879061' WHERE guid = '10322';
--------------------------------------------------------------------------------------------------------------
-- Альгазская битва[455]
DELETE FROM creature WHERE guid=9745;
DELETE FROM creature WHERE guid=9752;
DELETE FROM creature WHERE guid=9853;
INSERT INTO creature VALUES (9853,2103,0,1,1,0,0,-4220.72,-2468.99,282.868,4.31969,600,0,0,449,0,0,0);
DELETE FROM creature WHERE guid=9828;
INSERT INTO creature VALUES (9828,2103,0,1,1,0,0,-4339.18,-2518.95,258.575,1.63363,600,0,0,484,0,0,0);
DELETE FROM creature WHERE guid=9748;
INSERT INTO creature VALUES (9748,2103,0,1,1,0,0,-4281.59,-2482.69,246.828,1.8182,600,0,0,449,0,0,0);
DELETE FROM creature WHERE guid=9759;
INSERT INTO creature VALUES (9759,2103,0,1,1,0,0,-4206.87,-2331.11,221.969,3.57927,600,4,0,449,0,0,1);
DELETE FROM creature WHERE guid=9754;
INSERT INTO creature VALUES (9754,2103,0,1,1,0,0,-4286.41,-2350.73,230.011,5.40925,600,0,0,449,0,0,0);
DELETE FROM creature WHERE guid=9753;
INSERT INTO creature VALUES (9753,2103,0,1,1,0,0,-4210.52,-2419.34,229.575,2.60301,600,9,0,484,0,0,1);
DELETE FROM creature WHERE guid=10186;
INSERT INTO creature VALUES (10186,2103,0,1,1,0,0,-4420.75,-2426.63,250.903,0.976501,600,4,0,449,0,0,1);
DELETE FROM creature WHERE guid=10205;
INSERT INTO creature VALUES (10205,2103,0,1,1,0,0,-4272.44,-2410.38,238.686,2.92112,600,0,0,449,0,0,0);
DELETE FROM creature WHERE guid=10217;
INSERT INTO creature VALUES (10217,2103,0,1,1,0,0,-4246.86,-2445.22,257.542,1.70754,600,9,0,484,0,0,1);
DELETE FROM creature WHERE guid=10218;
INSERT INTO creature VALUES (10218,2103,0,1,1,0,0,-4207.36,-2374.42,216.83,2.45968,600,0,0,484,0,0,0);
DELETE FROM creature WHERE guid=10200;
INSERT INTO creature VALUES (10200,2102,0,1,1,0,0,-4331.72,-2412.7,212.229,4.39372,600,4,0,531,0,0,1);
DELETE FROM creature WHERE guid=10176;
INSERT INTO creature VALUES (10176,2102,0,1,1,0,0,-4297.28,-2385.32,208.8,5.46185,600,7,0,531,0,0,1);
DELETE FROM creature WHERE guid=10173;
INSERT INTO creature VALUES (10173,2102,0,1,1,0,0,-4265.42,-2371.91,206.859,3.74183,600,0,0,531,0,0,0);
DELETE FROM creature WHERE guid=10203;
INSERT INTO creature VALUES (10203,2102,0,1,1,0,0,-4327.44,-2437.96,212.835,4.40866,600,4,0,531,0,0,1);
DELETE FROM creature WHERE guid=52644;
INSERT INTO creature VALUES (52644,2102,0,1,1,0,0,-4263.63,-2333.73,220.542,5.83884,600,7,0,531,0,0,1);
UPDATE creature SET position_x = '-4193.249512', position_y = '-2365.032715', position_z = '209.707794', orientation = '5.360396' WHERE guid = '9757';
UPDATE creature SET position_x = '-3409.754883', position_y = '-2276.599854', position_z = '51.898567', orientation = '4.626521' WHERE guid = '10209';
UPDATE creature SET position_x = '-3399.275146', position_y = '-2273.202148', position_z = '51.898567', orientation = '4.772604' WHERE guid = '10211';
--------------------------------------------------------------------------------------------------------------
-- Джеймс Хьяль[1301]
UPDATE creature SET position_x = '-3849.271973', position_y = '-736.593811', position_z = '8.596987', orientation = '1.317894' WHERE guid = '9945';
--------------------------------------------------------------------------------------------------------------
-- Таверна
UPDATE creature SET position_x = '-3830.303711', position_y = '-836.210083', position_z = '10.090680', orientation = '6.189299' WHERE guid = '9944';
UPDATE creature SET position_x = '-3823.648193', position_y = '-836.120789', position_z = '10.090699', orientation = '1.699169' WHERE guid = '9931';
DELETE FROM creature WHERE guid=10426;
INSERT INTO creature VALUES (10426,1021,0,1,1,0,0,-3604.69,-1395.16,10.6392,3.10633,600,5,0,664,0,0,1);
DELETE FROM creature WHERE guid=10487;
INSERT INTO creature VALUES (10487,1021,0,1,1,0,0,-3688.78,-1341.39,12.7086,0.0715559,600,5,0,664,0,0,1);
DELETE FROM creature WHERE guid=10576;
INSERT INTO creature VALUES (10576,1021,0,1,1,0,0,-3740.83,-1346.08,25.3309,0.845945,600,5,0,712,0,0,1);
DELETE FROM creature WHERE guid=9749;
INSERT INTO creature VALUES (9749,1021,0,1,1,0,0,-3646.61,-1275.26,10.4607,4.88446,600,5,0,664,0,0,1);
DELETE FROM creature WHERE guid=9744;
INSERT INTO creature VALUES (9744,1021,0,1,1,0,0,-3488.2,-1375.17,9.22856,4.6944,600,5,0,664,0,0,1);
DELETE FROM creature WHERE guid=9739;
INSERT INTO creature VALUES (9739,1021,0,1,1,0,0,-3379.21,-1463.55,9.45494,3.876,600,5,0,712,0,0,1);
--------------------------------------------------------------------------------------------------------------
-- Месть Ормера[295]
DELETE FROM creature WHERE guid=2975;
INSERT INTO creature VALUES (2975,1023,0,1,1,0,0,-3452.43,-1847.98,24.6042,2.89303,600,6,0,839,0,0,1);
DELETE FROM creature WHERE guid=10284;
INSERT INTO creature VALUES (10284,1023,0,1,1,0,0,-3312.48,-1913.93,33.5016,3.56687,600,9,0,839,0,0,1);
DELETE FROM creature WHERE guid=10753;
INSERT INTO creature VALUES (10753,1022,0,1,1,0,0,-3321.21,-1876.75,25.0645,3.03702,600,5,0,787,0,0,1);
DELETE FROM creature WHERE guid=10795;
INSERT INTO creature VALUES (10795,1022,0,1,1,0,0,-3519.95,-1791.44,24.731,4.89973,600,5,0,787,0,0,1);
DELETE FROM creature WHERE guid=10831;
INSERT INTO creature VALUES (10831,1022,0,1,1,0,0,-3402.66,-1806.24,17.3725,3.1522,600,5,0,787,0,0,1);
DELETE FROM creature WHERE guid=10842;
INSERT INTO creature VALUES (10842,1022,0,1,1,0,0,-3443.74,-1782.35,17.3056,2.72415,600,5,0,787,0,0,1);
DELETE FROM creature WHERE guid=10879;
INSERT INTO creature VALUES (10879,1022,0,1,1,0,0,-3311.35,-1924.02,34.646,2.60475,600,5,0,787,0,0,1);
--------------------------------------------------------------------------------------------------------------
-- Месть Ормера[296]
UPDATE creature SET position_x = '-3568.646973', position_y = '-1766.171875', position_z = '80.791023', orientation = '0.956603' WHERE guid = '10134';
--------------------------------------------------------------------------------------------------------------
-- Угроза из глубин[279]
UPDATE creature SET position_x = '-3187.011963', position_y = '-1034.915894', position_z = '9.265803', orientation = '0.141741' WHERE guid = '10492';
UPDATE creature SET position_x = '-3284.095215', position_y = '-1019.165039', position_z = '9.145651', orientation = '2.879061' WHERE guid = '10322';
--------------------------------------------------------------------------------------------------------------
-- Альгазская битва[455]
DELETE FROM creature WHERE guid=9745;
DELETE FROM creature WHERE guid=9752;
DELETE FROM creature WHERE guid=9853;
INSERT INTO creature VALUES (9853,2103,0,1,1,0,0,-4220.72,-2468.99,282.868,4.31969,600,0,0,449,0,0,0);
DELETE FROM creature WHERE guid=9828;
INSERT INTO creature VALUES (9828,2103,0,1,1,0,0,-4339.18,-2518.95,258.575,1.63363,600,0,0,484,0,0,0);
DELETE FROM creature WHERE guid=9748;
INSERT INTO creature VALUES (9748,2103,0,1,1,0,0,-4281.59,-2482.69,246.828,1.8182,600,0,0,449,0,0,0);
DELETE FROM creature WHERE guid=9759;
INSERT INTO creature VALUES (9759,2103,0,1,1,0,0,-4206.87,-2331.11,221.969,3.57927,600,4,0,449,0,0,1);
DELETE FROM creature WHERE guid=9754;
INSERT INTO creature VALUES (9754,2103,0,1,1,0,0,-4286.41,-2350.73,230.011,5.40925,600,0,0,449,0,0,0);
DELETE FROM creature WHERE guid=9753;
INSERT INTO creature VALUES (9753,2103,0,1,1,0,0,-4210.52,-2419.34,229.575,2.60301,600,9,0,484,0,0,1);
DELETE FROM creature WHERE guid=10186;
INSERT INTO creature VALUES (10186,2103,0,1,1,0,0,-4420.75,-2426.63,250.903,0.976501,600,4,0,449,0,0,1);
DELETE FROM creature WHERE guid=10205;
INSERT INTO creature VALUES (10205,2103,0,1,1,0,0,-4272.44,-2410.38,238.686,2.92112,600,0,0,449,0,0,0);
DELETE FROM creature WHERE guid=10217;
INSERT INTO creature VALUES (10217,2103,0,1,1,0,0,-4246.86,-2445.22,257.542,1.70754,600,9,0,484,0,0,1);
DELETE FROM creature WHERE guid=10218;
INSERT INTO creature VALUES (10218,2103,0,1,1,0,0,-4207.36,-2374.42,216.83,2.45968,600,0,0,484,0,0,0);
DELETE FROM creature WHERE guid=10200;
INSERT INTO creature VALUES (10200,2102,0,1,1,0,0,-4331.72,-2412.7,212.229,4.39372,600,4,0,531,0,0,1);
DELETE FROM creature WHERE guid=10176;
INSERT INTO creature VALUES (10176,2102,0,1,1,0,0,-4297.28,-2385.32,208.8,5.46185,600,7,0,531,0,0,1);
DELETE FROM creature WHERE guid=10173;
INSERT INTO creature VALUES (10173,2102,0,1,1,0,0,-4265.42,-2371.91,206.859,3.74183,600,0,0,531,0,0,0);
DELETE FROM creature WHERE guid=10203;
INSERT INTO creature VALUES (10203,2102,0,1,1,0,0,-4327.44,-2437.96,212.835,4.40866,600,4,0,531,0,0,1);
DELETE FROM creature WHERE guid=52644;
INSERT INTO creature VALUES (52644,2102,0,1,1,0,0,-4263.63,-2333.73,220.542,5.83884,600,7,0,531,0,0,1);
UPDATE creature SET position_x = '-4193.249512', position_y = '-2365.032715', position_z = '209.707794', orientation = '5.360396' WHERE guid = '9757';
UPDATE creature SET position_x = '-3409.754883', position_y = '-2276.599854', position_z = '51.898567', orientation = '4.626521' WHERE guid = '10209';
UPDATE creature SET position_x = '-3399.275146', position_y = '-2273.202148', position_z = '51.898567', orientation = '4.772604' WHERE guid = '10211';
--------------------------------------------------------------------------------------------------------------
-- Джеймс Хьяль[1301]
UPDATE creature SET position_x = '-3849.271973', position_y = '-736.593811', position_z = '8.596987', orientation = '1.317894' WHERE guid = '9945';
--------------------------------------------------------------------------------------------------------------
-- Таверна
UPDATE creature SET position_x = '-3830.303711', position_y = '-836.210083', position_z = '10.090680', orientation = '6.189299' WHERE guid = '9944';
UPDATE creature SET position_x = '-3823.648193', position_y = '-836.120789', position_z = '10.090699', orientation = '1.699169' WHERE guid = '9931';