temp

//stonecore

UPDATE `creature` SET `position_x`=917.16, `position_y`=979.31, `position_z`=316.76, `orientation`=2.96 WHERE `id` = 43391 AND `map` = 725;

DELETE FROM gameobject WHERE id = 204337 AND map = 725;
DELETE FROM creature WHERE id = 43014 AND map = 725;
DELETE FROM creature WHERE id = 49267 AND map = 725;
DELETE FROM creature WHERE id = 42499 AND map = 725;
DELETE FROM creature WHERE id = 43242 AND map = 725;
DELETE FROM creature WHERE guid IN(
6646690,
6646692,
6646689,
6646691,
6646687,
6646686,
6646685,
6646688,
6646733,
6646734,
6646735,
6646736,
6646755,
6646757,
6646756,
6646754,
6646766,
6646751,
6646753,
6646750,
6646752,
6646765,
6646763,
6646764,
6646762,
6646759,
6646761,
6646760,
6646758);

//blackrock caverns

DELETE FROM `creature` WHERE `id` = 50376 AND `map` = 645;
DELETE FROM `creature` WHERE `id` = 51398 AND `map` = 645;
DELETE FROM `creature` WHERE `id` = 50417 AND `map` = 645;
DELETE FROM `creature` WHERE `id` = 49930 AND `map` = 645;
DELETE FROM `creature` WHERE `id` = 40011 AND `map` = 645;
DELETE FROM `creature` WHERE `id` = 40013 AND `map` = 645;
DELETE FROM `creature` WHERE `id` = 40008 AND `map` = 645;

DELETE FROM `creature` WHERE `guid` IN (
6646361,
6646359,
6646360,
6646358,
6645772,
6645773,
6645774,
6645764,
6645767,
6645765,
6645766);

UPDATE `creature` SET `position_x` = 73.26, `position_y` = 593.84, `position_z` = 77.74, `orientation` = 5.92 WHERE `guid` = 405270;
UPDATE `creature` SET `MovementType` = 0 WHERE id IN (40015, 39700, 40011, 40013);
UPDATE `creature_template` SET `MovementType` = 0 WHERE entry IN (40015, 39700, 40011, 40013);