-- Crazed Digger

SET @ID := 46590;

DELETE FROM `creature` WHERE  `id`=@ID;
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
(184869, 46590, 1, 1, 1, 0, 0, -10522.5, -1951.08, 76.689, 5.87111, 120, 0, 0, 1, 0, 0, 0, 0, 0),
(184867, 46590, 1, 1, 1, 0, 0, -10506.8, -1896.27, 91.4371, 2.39005, 120, 0, 0, 1, 0, 0, 0, 0, 0),
(184866, 46590, 1, 1, 1, 0, 0, -10481.5, -1924.14, 90.6569, 3.97935, 120, 0, 0, 1, 0, 0, 0, 0, 0),
(184862, 46590, 1, 1, 1, 0, 0, -10484, -1977.43, 70.6906, 5.32325, 120, 0, 0, 1, 0, 0, 0, 0, 0),
    (184861, 46590, 1, 1, 1, 0, 0, -10471.6, -1987.96, 66.8985, 1.6057, 120, 0, 0, 1, 0, 0, 0, 0, 0),
    (184860, 46590, 1, 1, 1, 0, 0, -10460.1, -1970.53, 66.0224, 3.75246, 120, 0, 0, 1, 0, 0, 0, 0, 0),
    (184853, 46590, 1, 1, 1, 0, 0, -10412.4, -1892.52, 84.4827, 5.64051, 120, 0, 0, 1, 0, 0, 0, 0, 0),
    (184851, 46590, 1, 1, 1, 0, 0, -10428.1, -1887.69, 85.9156, 4.15388, 120, 0, 0, 1, 0, 0, 0, 0, 0),
    (184843, 46590, 1, 1, 1, 0, 0, -10478.8, -1850.06, 92.9116, 2.47837, 120, 0, 0, 1, 0, 0, 0, 0, 0),
    (184842, 46590, 1, 1, 1, 0, 0, -10447.6, -1834.26, 91.3052, 2.47837, 120, 0, 0, 1, 0, 0, 0, 0, 0),
    (184841, 46590, 1, 1, 1, 0, 0, -10416.4, -1814.01, 93.9026, 2.82743, 120, 0, 0, 1, 0, 0, 0, 0, 0),
    (184840, 46590, 1, 1, 1, 0, 0, -10438.1, -1826.81, 90.5086, 2.80998, 120, 0, 0, 1, 0, 0, 0, 0, 0),
    (184836, 46590, 1, 1, 1, 0, 0, -10463.1, -1837.84, 123.205, 5.84685, 120, 0, 0, 1, 0, 0, 0, 0, 0),
    (184835, 46590, 1, 1, 1, 0, 0, -10459.7, -1809.38, 123.681, 0.174533, 120, 0, 0, 1, 0, 0, 0, 0, 0),
    (184834, 46590, 1, 1, 1, 0, 0, -10450.4, -1812.15, 106.143, 3.08923, 120, 0, 0, 1, 0, 0, 0, 0, 0),
    (184833, 46590, 1, 1, 1, 0, 0, -10529.3, -1850.89, 91.2735, 1.48353, 120, 0, 0, 1, 0, 0, 0, 0, 0),
    (184832, 46590, 1, 1, 1, 0, 0, -10502.7, -1855.7, 92.697, 2.32129, 120, 0, 0, 1, 0, 0, 0, 0, 0),
    (184831, 46590, 1, 1, 1, 0, 0, -10493.7, -1838.69, 123.45, 4.64258, 120, 0, 0, 1, 0, 0, 0, 0, 0),
    (184830, 49743, 1, 1, 1, 0, 0, -10542.9, -1857.87, 90.5231, 4.71364, 120, 0, 0, 1, 0, 0, 0, 0, 0),
    (184829, 46590, 1, 1, 1, 0, 0, -10498.3, -1876.92, 90.4057, 0.942478, 120, 0, 0, 1, 0, 0, 0, 0, 0),
    (184828, 46590, 1, 1, 1, 0, 0, -10545.7, -1890.49, 92.1523, 2.89725, 120, 0, 0, 1, 0, 0, 0, 0, 0),
    (184827, 46590, 1, 1, 1, 0, 0, -10544.2, -1867.9, 90.4057, 3.97935, 120, 0, 0, 1, 0, 0, 0, 0, 0),
    (184826, 46590, 1, 1, 1, 0, 0, -10548.5, -1907.01, 94.5245, 1.32645, 120, 0, 0, 1, 0, 0, 0, 0, 0),
    (184825, 46590, 1, 1, 1, 0, 0, -10552.5, -1897.98, 125.058, 3.08923, 120, 0, 0, 1, 0, 0, 0, 0, 0),
    (213, 46590, 1, 1, 1, 0, 0, -10521.2, -1869.43, 90.3234, 5.77446, 600, 0, 0, 42, 0, 0, 0, 0, 0),
    (212, 46590, 1, 1, 1, 0, 0, -10529.3, -1879.28, 90.6953, 3.65389, 600, 0, 0, 42, 0, 0, 0, 0, 0),
    (211, 46590, 1, 1, 1, 0, 0, -10538.9, -1891.77, 92.2704, 4.46285, 600, 0, 0, 42, 0, 0, 0, 0, 0),
    (210, 46590, 1, 1, 1, 0, 0, -10519.4, -1879.65, 90.3239, 1.81213, 600, 0, 0, 42, 0, 0, 0, 0, 0),
    (209, 46590, 1, 1, 1, 0, 0, -10511.9, -1876.55, 90.3239, 0.288457, 600, 0, 0, 42, 0, 0, 0, 0, 0),
    (205, 46590, 1, 1, 1, 0, 0, -10492, -1881.43, 90.3237, 4.66705, 600, 0, 0, 42, 0, 0, 0, 0, 0),
    (204, 46590, 1, 1, 1, 0, 0, -10497, -1903.14, 90.9902, 4.76915, 600, 0, 0, 42, 0, 0, 0, 0, 0),
    (203, 46590, 1, 1, 1, 0, 0, -10480, -1862.76, 91.1783, 1.91816, 600, 0, 0, 42, 0, 0, 0, 0, 0),
    (202, 46590, 1, 1, 1, 0, 0, -10477.3, -1861.86, 91.4511, 1.8514, 600, 0, 0, 42, 0, 0, 0, 0, 0),
    (201, 46590, 1, 1, 1, 0, 0, -10466, -1851.4, 92.6065, 1.52939, 600, 0, 0, 42, 0, 0, 0, 0, 0),
    (199, 46590, 1, 1, 1, 0, 0, -10457.3, -1883.85, 90.3234, 4.34111, 600, 0, 0, 42, 0, 0, 0, 0, 0),
    (198, 46590, 1, 1, 1, 0, 0, -10451, -1890.41, 90.3234, 5.63309, 600, 0, 0, 42, 0, 0, 0, 0, 0),
    (197, 46590, 1, 1, 1, 0, 0, -10445.1, -1900.61, 90.3234, 5.52313, 600, 0, 0, 42, 0, 0, 0, 0, 0),
    (196, 46590, 1, 1, 1, 0, 0, -10432.5, -1901.59, 86.3446, 0.645805, 600, 0, 0, 42, 0, 0, 0, 0, 0),
    (195, 46590, 1, 1, 1, 0, 0, -10442.9, -1909.79, 90.3572, 4.08978, 600, 0, 0, 42, 0, 0, 0, 0, 0),
    (194, 46590, 1, 1, 1, 0, 0, -10452.7, -1914.82, 90.3508, 3.57141, 600, 0, 0, 42, 0, 0, 0, 0, 0),
    (193, 46590, 1, 1, 1, 0, 0, -10460.3, -1913.05, 90.3231, 1.77678, 600, 0, 0, 42, 0, 0, 0, 0, 0),
    (192, 46590, 1, 1, 1, 0, 0, -10472.9, -1896.52, 90.3225, 1.93778, 600, 0, 0, 42, 0, 0, 0, 0, 0),
    (191, 46590, 1, 1, 1, 0, 0, -10527.9, -1894.11, 91.2724, 0.634032, 600, 0, 0, 42, 0, 0, 0, 0, 0);

-- Mekgineer Mixeltweed

SET @ID := 46592;

DELETE FROM `creature` WHERE  `id`=@ID;
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
(342107, 46592, 1, 1, 1, 0, 0, -10495.8, -1890.37, 90.3295, 6.25562, 600, 0, 0, 84, 0, 0, 0, 0, 0),
(184868, 46592, 1, 1, 1, 0, 0, -10486.3, -1891, 90.4474, 3.60075, 120, 0, 0, 1, 0, 0, 0, 0, 0);