DELETE FROM `creature` WHERE `guid` IN (5513, 5514, 44078, 44322, 37858, 37877, 37888, 38027, 41986, 41983, 41982, 42014, 44322, 41954, 34283, 34895, 35656, 49031, 49152, 49058, 49042, 49253, 49256, 49120, 50938, 50780, 50799, 5634);
DELETE FROM creature WHERE guid=5520;
INSERT INTO `creature` VALUES (5520,8962,0,-9351,-2205.82,61.8977,3.11822,60,80,0,0,-9351,-2205.82,61.8977,3.11822,43,0,60,0,2,12,0,NULL);
UPDATE `creature` SET `position_x`=-14453.945313,`position_y`=479.065002,`position_z`=15.036799,`orientation`=5.331269,`spawn_position_x`=-14453.945313,`spawn_position_y`=479.065002,`spawn_position_z`=15.036799,`spawn_orientation`=5.331269 WHERE `id`=10060;
UPDATE `creature` SET `position_x`=-14467.829102,`position_y`=468.092377,`position_z`=15.028458,`orientation`=0.027470,`spawn_position_x`=-14467.829102,`spawn_position_y`=468.092377,`spawn_position_z`=15.028458,`spawn_orientation`=0.027470 WHERE `id`=2843;
UPDATE `creature` SET `position_x`=-14449.649414,`position_y`=479.175507,`position_z`=15.108914,`orientation`=5.276298,`spawn_position_x`=-14449.649414,`spawn_position_y`=479.175507,`spawn_position_z`=15.108914,`spawn_orientation`=5.276298 WHERE `id`=15076;
UPDATE `creature` SET `npcflags`=16388 WHERE id=167;
DELETE FROM creature WHERE guid IN (60758, 1386, 1428, 5350);
INSERT INTO creature VALUES 
(60758, 2994, 1, -1004.41, -1124.27, 44.4156, 2.152, 25000, 25000, 0, 0, -1004.41, -1124.27, 44.4156, 0, 372, 0, 0, 0, 2, 104, 0, NULL),
(1386,5894,0,417.046,1822.660,12.617,1.643,180,200,7,0,417.046,1822.660,12.617,1.643,497,0,180,0,0,15,0,NULL),
(1428, 1147, 0, -14453.2, 406.441, 25.5913, 2.4426, 25000, 25000, 0, 0, -14453.2, 406.441, 25.5913, 0, 2471, 0, 0, 0, 6, 120, 0, NULL),
(5350, 3143, 1, -600.06, -4177.91, 41.2442, 4.73762, 25000, 25000, 0, 0, -600.06, -4177.91, 41.2442, 0, 166, 0, 0, 0, 2, 29, 0, NULL);
DELETE FROM creature WHERE id IN (8674,4548, 11858, 8723, 15076, 5600, 4183,4187,4189,4193, 5083, 11858, 486, 4074, 16012, 16013, 16014, 16015, 16016, 16031, 16032, 16033, 16043, 16044, 16045, 16046, 16047, 16048, 16073, 16079);
INSERT INTO creature (id,map,position_x,position_y,position_z,orientation,spawntimemin,spawntimemax,spawndist,currentwaypoint,spawn_position_x,spawn_position_y,spawn_position_z,spawn_orientation,curhealth,curmana,respawntimer,state,npcflags,faction,MovementType,auras) VALUES 
(4548, 1, -4727.91,-1257.65,-53.0793,5.7554,25000,25000,0,0,-4727.91,-1257.65,-53.0793,0,1668,0,0,0,0,38,0, NULL),
(11858,1, 127.638,-367.036,3.1439,3.54754,25000,25000,0,0,127.638,-367.036,3.1439,0,393,0,0,0,0,16,0, NULL),
(8674, 1, -1210.39, 94.8753, 134.418, 3.18872, 0, 3600, 0, 0, -1210.39, 94.8753, 134.418, 3.18872, 3517, 2103, 0, 0, 4098, 104, 0, NULL),
(8723, 1, 9857.34, 2342.97, 1321.59, 5.95803, 0, 3600, 0, 0, 9857.34, 2342.97, 1321.59, 5.95803, 3517, 2103, 0, 0, 4098, 79, 0, NULL),
(15076,0, -14449.65,479.18,15.11,5.28,6360000,6360000,5,0,-14449.649414,479.175507,15.108914,5.276298,8017,0,3600,0,2,1574,0,NULL),
(5600, 1, -1020.37, 900.154, 92.6542, 1.97999, 25000, 25000, 0, 0, -1020.37, 900.154, 92.6542, 1.97999, 1341, 0, 0, 0, 0, 130, 0,NULL),
(4183,1,6572.8,480.387,8.24914,1.96821,120,180,0,0,6572.8,480.387,8.24914,0,919,0,0,0,16388,80,0,NULL), 
(4187,1,6530.2,514.048,9.06005,5.14593,120,180,0,0,6530.2,514.048,9.06005,0,1106,0,0,0,16388,80,0,NULL), 
(4189,1,6561.35,441.924,9.05938,0.402124,120,180,0,0,6561.35,441.924,9.05938,0,594,0,0,0,6,80,0,NULL), 
(4193,1,6564.02,437.979,9.05938,1.82527,120,180,0,0,6564.02,437.979,9.05938,0,1528,0,0,0,18,80,0,NULL),
(5083, 1, -3816.9, -4502.75, 11.4068, 0.0461595, 360, 380, 0, 0, -3816.9, -4502.75, 11.4068, 0, 919, 0, 360, 0, 2, 894, 0, NULL),
(11858, 1, 125.243, -344.564, 3.59644, 3.67173, 360, 380, 0, 0, 125.243, -344.564, 3.59644, 0, 393, 0, 360, 0, 0, 16, 0, NULL),
(486, 0, -9421.06, 3080.5, 136.7, 2.15, 1200, 1800, 0, 0, -9421.06, 3080.5, 136.7, 2.15, 2131, 1216, 1600, 0, 0, 40, 0, NULL),
(4074, 1, 1124.57, 38.5534, 3.68223, 1.99022, 25000, 25000, 0, 0, 1124.57, 38.5534, 3.68223, 0, 592, 0, 0, 0, 0, 16, 0, NULL),
(16013, 0, -4842.47, -1059.04, 502.189, 1.28019, 25000, 25000, 0, 0, -4842.47, -1059.04, 502.189, 0, 4400, 5751, 0, 0, 2, 57, 0, NULL),
(16012, 1, 1914.75, -4227.34, 42.0962, 0.604739, 25000, 25000, 0, 0, 1914.75, -4227.34, 42.0962, 0, 4000, 0, 0, 0, 2, 85, 0, NULL),
(16014, 1, -7120.45, -3833.25, 8.79057, 1.27235, 25000, 25000, 0, 0, -7120.45, -3833.25, 8.79057, 0, 2400, 0, 0, 0, 2, 474, 0, NULL),
(16016, 0, 3367.63, -3379.76, 144.98, 3.04182, 25000, 25000, 0, 0, 3367.63, -3379.76, 144.98, 0, 3700, 0, 0, 0, 2, 35, 0, NULL),
(16031, 329, 4039.93, -3337.56, 115.059, 4.5202, 25000, 25000, 0, 0, 4039.93, -3337.56, 115.059, 0, 2600, 0, 0, 0, 2, 35, 0, NULL),
(16032, 429, 113.509, 445.716, -48.4668, 0.111299, 25000, 25000, 0, 0, 113.509, 445.716, -48.4668, 0, 710, 0, 0, 0, 2, 35, 0, NULL),
(16043, 0, -8166.82, -1298, 131.512, 0.581195, 25000, 25000, 0, 0, -8166.82, -1298, 131.512, 0, 4700, 0, 0, 0, 0, 14, 0, NULL),
(16044, 229, -15.9034, -455.282, -18.6442, 3.15971, 25000, 25000, 0, 0, -15.9034, -455.282, -18.6442, 0, 42, 0, 0, 0, 0, 35, 0, NULL),
(16048, 229, 44.7101, -536.049, 110.936, 1.56143, 25000, 25000, 0, 0, 44.7101, -536.049, 110.936, 0, 42, 0, 0, 0, 0, 35, 0, NULL),
(16047, 289, -25.5408, 141.648, 83.9711, 6.27455, 25000, 25000, 0, 0, -25.5408, 141.648, 83.9711, 0, 42, 0, 0, 0, 0, 35, 0, NULL),
(16046, 329, 3422.71, -3054.91, 136.499, 5.35431, 25000, 25000, 0, 0, 3422.71, -3054.91, 136.499, 0, 42, 0, 0, 0, 0, 35, 0, NULL),
(16045, 429, 262.974, -442.555, -119.962, 4.61136, 25000, 25000, 0, 0, 262.974, -442.555, -119.962, 0, 42, 0, 0, 0, 0, 35, 0, NULL),
(16033, 0, -7534.79, -1212.62, 285.44, 5.2131, 25000, 25000, 0, 0, -7534.79, -1212.62, 285.44, 0, 3500, 5751, 0, 0, 2, 35, 0, NULL);
UPDATE creature SET faction=44 WHERE id=1961;
UPDATE creature SET npcflags=16390 WHERE id=4556;
UPDATE `creature` SET npcflags=16388 WHERE id=6300;
UPDATE `creature` SET npcflags=0, faction=122 WHERE id IN (3376, 3378);
UPDATE creature SET npcflags=4 WHERE id=4189;
UPDATE creature SET npcflags=16 WHERE id=4193;
UPDATE creature SET faction=35 WHERE id=11596;