/*
 фракция https://tracker.legionbugs.com/view.php?id=18219
*/

UPDATE `creature_template` SET `faction` = 124 WHERE `entry` = 12677;




/*
 https://tracker.legionbugs.com/view.php?id=20555
*/


UPDATE `creature` SET `MovementType` = 0, `spawndist` = 0 WHERE `id` IN (3128,3129);
UPDATE `creature_template` SET `unit_flags` = 33555330 WHERE `entry` IN (3128,3129);
DELETE FROM `creature_template_addon` WHERE `entry` = 3128;
INSERT INTO `creature_template_addon` (`entry`, `auras`, `LoadExpansion`) VALUES
(3128, '29266', 4);
UPDATE `creature_template_addon` SET `bytes1` = 0, `bytes2` = 0, `auras` = '29266' WHERE `entry` = 3129;







/*
 https://tracker.legionbugs.com/view.php?id=23571
*/


DELETE FROM `creature` WHERE `id` = 50831;
INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `randomMoveType`, `randomMoveMinTimer`, `randomMoveMaxTimer`, `ScriptName`, `npcflag`, `npcflag2`, `unit_flags`, `unit_flags3`, `dynamicflags`, `isActive`, `skipClone`, `personal_size`, `isTeemingSpawn`, `MiscData`, `GroupID`, `inhabitType`, `realmMask`, `VerifiedBuild`, `Comment`, `LoadBuild`, `LoadExpansion`) VALUES
(207732, 50831, 870, 5841, 6087, 1, 1, '', 44246, 0, 2990.71, 1881.05, 640.842, 1.80867, 3200, 0, 0, 2442384, 2442384, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 4),
(477130, 50831, 870, 5841, 6087, 1, 1, '', 0, 0, 2898.94, 2031.82, 638.384, 4.47034, 300, 0, 0, 310554, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 4),
(477131, 50831, 870, 5841, 5841, 1, 1, '', 0, 0, 2959.69, 2033.48, 643.7, 4.87718, 300, 0, 0, 310554, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 4),
(477132, 50831, 870, 5841, 6087, 1, 1, '', 0, 0, 3053.35, 1946.09, 640.799, 3.11787, 300, 0, 0, 310554, 0, 0, 1, 500, 3500, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 4);


DELETE FROM `pool_creature` WHERE `pool_entry` = 50831;
INSERT INTO `pool_creature` (`guid`, `pool_entry`, `chance`, `description`) VALUES
(207732, 50831, 0, 'Scritch1'),
(477130, 50831, 0, 'Scritch2'),
(477131, 50831, 0, 'Scritch3'),
(477132, 50831, 0, 'Scritch4');


DELETE FROM `pool_template` WHERE `entry` = 50831;
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
(50831, 1, 'Scritch')