DELETE FROM gameobject WHERE guid IN(81100,81098,81099,81097,81094,81087,81111,81101,81114,81113,81107,81110,81090,81086,81091);

UPDATE `gameobject` SET `id`='191879' WHERE (`guid`='37671');
UPDATE `gameobject` SET `id`='191879' WHERE (`guid`='37672');
UPDATE `gameobject` SET `id`='190064' WHERE (`guid`='37673');
UPDATE `gameobject` SET `id`='190065' WHERE (`guid`='37674');
UPDATE `gameobject` SET `id`='190066' WHERE (`guid`='37675');
UPDATE `gameobject` SET `id`='190040' WHERE (`guid`='37676');
UPDATE `gameobject` SET `id`='190068' WHERE (`guid`='37677');
UPDATE `gameobject` SET `id`='190069' WHERE (`guid`='37678');
UPDATE `gameobject` SET `id`='190070' WHERE (`guid`='37679');
UPDATE `gameobject` SET `id`='190071' WHERE (`guid`='37680');
UPDATE `gameobject` SET `id`='190112' WHERE (`guid`='81117');
UPDATE `gameobject` SET `id`='190073' WHERE (`guid`='37682');
UPDATE `gameobject` SET `id`='190074' WHERE (`guid`='37683');
UPDATE `gameobject` SET `id`='190075' WHERE (`guid`='37684');
UPDATE `gameobject` SET `id`='190076' WHERE (`guid`='37685');
UPDATE `gameobject` SET `id`='190077' WHERE (`guid`='37686');
UPDATE `gameobject` SET `id`='190078' WHERE (`guid`='37687');
UPDATE `gameobject` SET `id`='190079' WHERE (`guid`='37688');
UPDATE `gameobject` SET `id`='190080' WHERE (`guid`='37689');
UPDATE `gameobject` SET `id`='190082' WHERE (`guid`='37690');
UPDATE `gameobject` SET `id`='190083' WHERE (`guid`='37691');
UPDATE `gameobject` SET `id`='190084' WHERE (`guid`='37692');
UPDATE `gameobject` SET `id`='190085' WHERE (`guid`='37693');
UPDATE `gameobject` SET `id`='190087' WHERE (`guid`='37694');
UPDATE `gameobject` SET `id`='190103' WHERE (`guid`='37695');
UPDATE `gameobject` SET `id`='190111' WHERE (`guid`='37696');
UPDATE `gameobject` SET `id`='194066' WHERE (`guid`='37697');
UPDATE `gameobject` SET `id`='194069' WHERE (`guid`='37698');
UPDATE `gameobject` SET `id`='194067' WHERE (`guid`='37699');
UPDATE `gameobject` SET `id`='194061' WHERE (`guid`='37700');
UPDATE `gameobject` SET `id`='194060' WHERE (`guid`='37701');
UPDATE `gameobject` SET `id`='190044' WHERE (`guid`='37702');
UPDATE `gameobject` SET `id`='191878' WHERE (`guid`='37703');
UPDATE `gameobject` SET `id`='194063' WHERE (`guid`='37704');
UPDATE `gameobject` SET `id`='191880' WHERE (`guid`='37705');
UPDATE `gameobject` SET `id`='194077' WHERE (`guid`='37706');
UPDATE `gameobject` SET `id`='192018' WHERE (`guid`='37707');
UPDATE `gameobject` SET `id`='190086' WHERE (`guid`='37708');
UPDATE `gameobject` SET `id`='190106' WHERE (`guid`='37709');
UPDATE `gameobject` SET `id`='190088' WHERE (`guid`='37710');
UPDATE `gameobject` SET `id`='190089' WHERE (`guid`='37711');
UPDATE `gameobject` SET `id`='190097' WHERE (`guid`='37712');
UPDATE `gameobject` SET `id`='190101' WHERE (`guid`='37713');
UPDATE `gameobject` SET `id`='190115' WHERE (`guid`='37714');
UPDATE `gameobject` SET `id`='190098' WHERE (`guid`='37715');
UPDATE `gameobject` SET `id`='190096' WHERE (`guid`='37716');
UPDATE `gameobject` SET `id`='190109' WHERE (`guid`='37717');
UPDATE `gameobject` SET `id`='190099' WHERE (`guid`='37718');
UPDATE `gameobject` SET `id`='190114' WHERE (`guid`='37719');
UPDATE `gameobject` SET `id`='190091' WHERE (`guid`='37720');
UPDATE `gameobject` SET `id`='190090' WHERE (`guid`='37721');
UPDATE `gameobject` SET `id`='194078' WHERE (`guid`='37722');
UPDATE `gameobject` SET `id`='194079' WHERE (`guid`='37723');
UPDATE `gameobject` SET `id`='190067' WHERE (`guid`='37724');
UPDATE `gameobject` SET `id`='190042' WHERE (`guid`='37725');
UPDATE `gameobject` SET `id`='190037' WHERE (`guid`='37726');
UPDATE `gameobject` SET `id`='190059' WHERE (`guid`='37727');
UPDATE `gameobject` SET `id`='190055' WHERE (`guid`='37728');
UPDATE `gameobject` SET `id`='190061' WHERE (`guid`='37730');
UPDATE `gameobject` SET `id`='190062' WHERE (`guid`='37731');
UPDATE `gameobject` SET `id`='190039' WHERE (`guid`='39839');
UPDATE `gameobject` SET `id`='190047' WHERE (`guid`='81089');

UPDATE `gameobject` SET `id`='190057', `map`='0', `position_x`='-5603.85', `position_y`='-530.659', `position_z`='399.654', `orientation`='1.54203' WHERE (`guid`='37729');

UPDATE `gameobject` SET `id`='190043', `map`='530', `position_x`='-171.965', `position_y`='5530.08', `position_z`='29.4078', `orientation`='4.94988' WHERE (`guid`='81093');

UPDATE `gameobject` SET `id`='190052', `map`='530', `position_x`='8698.16', `position_y`='-6640.18', `position_z`='72.7448', `orientation`='5.3818' WHERE (`guid`='81088');

UPDATE `gameobject` SET `id`='190081', `map`='530', `position_x`='7551.6', `position_y`='-6896.34', `position_z`='96.0265', `orientation`='0.933564' WHERE (`guid`='81109');

UPDATE `gameobject` SET `id`='190100', `map`='0', `position_x`='-624.94', `position_y`='-4586.59', `position_z`='11.6872', `orientation`='5.53197' WHERE (`guid`='81104');

UPDATE `gameobject` SET `id`='190102', `map`='0', `position_x`='-12432.1', `position_y`='210.795', `position_z`='2.36545', `orientation`='1.22114' WHERE (`guid`='81102');

UPDATE `gameobject` SET `id`='190105', `map`='0', `position_x`='513.686', `position_y`='1637.57', `position_z`='125.944', `orientation`='3.15406' WHERE (`guid`='81103');

UPDATE `gameobject` SET `id`='190107', `map`='1', `position_x`='-4459.55', `position_y`='246.44', `position_z`='39.1063', `orientation`='0.0569013' WHERE (`guid`='81105');

UPDATE `gameobject` SET `id`='190113', `map`='530', `position_x`='2401.44', `position_y`='5949.53', `position_z`='152.14', `orientation`='1.65854' WHERE (`guid`='81106');

UPDATE `gameobject` SET `map`='0', `position_x`='381.327', `position_y`='-2130.04', `position_z`='121.007', `orientation`='3.44255' WHERE (`guid`='81116');

UPDATE `gameobject` SET `map`='1', `position_x`='2727.07', `position_y`='1498.07', `position_z`='236.826', `orientation`='1.61501' WHERE (`guid`='81119');

UPDATE `gameobject` SET `map`='530', `position_x`='-4141.05', `position_y`='1124.696', `position_z`='44.531124', `orientation`='0.63' WHERE (`guid`='81117');

UPDATE `gameobject` SET `id`='190072', `map`='530', `position_x`='-4085.189', `position_y`='2189.320', `position_z`='107.502', `orientation`='1.65854' WHERE (`guid`='37681');

UPDATE `gameobject` SET `id`='190036', `map`='1', `position_x`='-3114.780', `position_y`='-2876.758', `position_z`='34.945107', `orientation`='3.82854' WHERE (`guid`='81118');

INSERT INTO gameobject_involvedrelation VALUES
(189303, 12286),
(190036, 12383),
(191879, 12404),
(190064, 12335),
(190065, 12336),
(190066, 12331),
(190040, 12338),
(190068, 12333),
(190069, 12357),
(190070, 12356),
(190071, 12409),
(190112, 12409),
(190073, 12352),
(190074, 12353),
(190075, 12354),
(190076, 12355),
(190077, 12358),
(190078, 12359),
(190079, 12406),
(190080, 12407),
(190082, 12408),
(190083, 12343),
(190084, 12346),
(190085, 12361),
(190087, 12366),
(190103, 12363),
(190111, 12368),
(194066, 12369),
(194069, 12370),
(194067, 12364),
(194061, 12362),
(194060, 12367),
(190044, 12340),
(191878, 12344),
(194063, 12342),
(191880, 12339),
(194077, 12400),
(192018, 12345),
(190086, 12396),
(190106, 12349),
(190088, 12348),
(190089, 12350),
(190097, 12401),
(190101, 12399),
(190115, 12385),
(190098, 12380),
(190096, 12376),
(190109, 12397),
(190099, 12374),
(190114, 12375),
(190091, 12379),
(190090, 12377),
(194078, 12378),
(194079, 12381),
(190067, 12392),
(190042, 12390),
(190037, 12394),
(190059, 12391),
(190055, 12395),
(190061, 12388),
(190062, 12389),
(190039, 12384),
(190047, 12334),
(190057, 12332),
(190043, 12403),
(190052, 12365),
(190081, 12373),
(190100, 12387),
(190102, 12382),
(190105, 12371),
(190107, 12386),
(190113, 12393),
(190110, 12351),
(190116, 12347),
(190045, 12341),
(190104, 12398),
(190041, 12337),
(190072, 12360),
(190108, 12402);
INSERT INTO gameobject_questrelation VALUES
(189303, 12286),
(190036, 12383),
(191879, 12404),
(190064, 12335),
(190065, 12336),
(190066, 12331),
(190040, 12338),
(190068, 12333),
(190069, 12357),
(190070, 12356),
(190071, 12409),
(190112, 12409),
(190073, 12352),
(190074, 12353),
(190075, 12354),
(190076, 12355),
(190077, 12358),
(190078, 12359),
(190079, 12406),
(190080, 12407),
(190082, 12408),
(190083, 12343),
(190084, 12346),
(190085, 12361),
(190087, 12366),
(190103, 12363),
(190111, 12368),
(194066, 12369),
(194069, 12370),
(194067, 12364),
(194061, 12362),
(194060, 12367),
(190044, 12340),
(191878, 12344),
(194063, 12342),
(191880, 12339),
(194077, 12400),
(192018, 12345),
(190086, 12396),
(190106, 12349),
(190088, 12348),
(190089, 12350),
(190097, 12401),
(190101, 12399),
(190115, 12385),
(190098, 12380),
(190096, 12376),
(190109, 12397),
(190099, 12374),
(190114, 12375),
(190091, 12379),
(190090, 12377),
(194078, 12378),
(194079, 12381),
(190067, 12392),
(190042, 12390),
(190037, 12394),
(190059, 12391),
(190055, 12395),
(190061, 12388),
(190062, 12389),
(190039, 12384),
(190047, 12334),
(190057, 12332),
(190043, 12403),
(190052, 12365),
(190081, 12373),
(190100, 12387),
(190102, 12382),
(190105, 12371),
(190107, 12386),
(190113, 12393),
(190110, 12351),
(190116, 12347),
(190045, 12341),
(190104, 12398),
(190041, 12337),
(190072, 12360),
(190108, 12402);

UPDATE gameobject_template SET faction = 0 WHERE entry IN(190039,190040,190044,190047,189303);

UPDATE quest_template SET RequiredRaces = 1101 WHERE entry IN
(12332,12286,12351,12339,12336,12343,12344,12346,12335,12342,12340,12358,12352,12357,12356,12354,12359,12353,12360,12355,12345,12341,12334,12349,12350,12331,12333,12338,12348,12337,12347);

UPDATE quest_template SET RequiredRaces = 690 WHERE entry IN
(12380,12365,12373,12387,12369,12382,12363,12385,12364,12376,12370,12371,12384,12368.12394,12389,12388,12391,12393,12392,12395,12390,12375,12381,12383,12362,12378,12379,12377,12374,12361,12386,12366,12367);