-- unit_flags=4 - DISABLE_MOVE UPDATE `creature_template` SET `speed_walk`=0, `speed_run`=0, `unit_flags`=4 WHERE `entry` IN (28833);