- 917
- 2015
- 23
- Location
- Barryton Michigan USA
There were only a few giant tidecrawlers in howling fjord area. I spaced them out like i saw on youtube, I do not have sniff data to use, But they walk around anyway.
Code:
DELETE FROM `creature` WHERE `guid`=138002;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (138002, 23929, 571, 0, 0, 1, 1, 21936, 0, 493.803, -6285.88, -58.7468, 6.20056, 90, 5, 0, 6986, 0, 1, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=138003;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (138003, 23929, 571, 0, 0, 1, 1, 21936, 0, 471.612, -6212.71, -5.36919, 1.20382, 90, 5, 0, 6986, 0, 1, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=138004;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (138004, 23929, 571, 0, 0, 1, 1, 21936, 0, 880.742, -6087.29, -5.54351, 1.75751, 90, 5, 0, 6986, 0, 1, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=138008;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (138008, 23929, 571, 0, 0, 1, 1, 21936, 0, 844.456, -6112.04, -7.57999, 3.81972, 90, 5, 0, 6986, 0, 1, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=138009;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (138009, 23929, 571, 0, 0, 1, 1, 21936, 0, 925.089, -6181.16, -7.20293, 3.05748, 90, 5, 0, 6986, 0, 1, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=138011;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (138011, 23929, 571, 0, 0, 1, 1, 21936, 0, 512.581, -6255.37, -14.0343, 0.246398, 90, 5, 0, 6986, 0, 1, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=138012;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (138012, 23929, 571, 0, 0, 1, 1, 21936, 0, 818.54, -6098.34, -5.68217, 5.19636, 90, 5, 0, 6986, 0, 1, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=138013;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (138013, 23929, 571, 0, 0, 1, 1, 21936, 0, 956.558, -6219.95, -7.65883, 2.06669, 90, 5, 0, 6986, 0, 1, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=138014;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (138014, 23929, 571, 0, 0, 1, 1, 21936, 0, 907.085, -6122.27, -7.45787, 0.316577, 90, 5, 0, 6986, 0, 1, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=138015;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (138015, 23929, 571, 0, 0, 1, 1, 21936, 0, 2010.34, -6251.85, -20.7359, 4.34928, 90, 5, 0, 6986, 0, 1, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=138016;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (138016, 23929, 571, 0, 0, 1, 1, 21936, 0, 2031.83, -6193.31, -2.88364, 4.83639, 90, 5, 0, 6986, 0, 1, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=138029;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (138029, 23929, 571, 0, 0, 1, 1, 21936, 0, 2085.98, -6212.13, -4.94937, 4.47387, 90, 5, 0, 6986, 0, 1, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=138038;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (138038, 23929, 571, 0, 0, 1, 1, 21936, 0, 2078.55, -6124.3, 4.09472, 4.80558, 90, 5, 0, 6986, 0, 1, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=138039;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (138039, 23929, 571, 0, 0, 1, 1, 21936, 0, 2065.86, -6160.64, 0.922473, 1.86786, 90, 5, 0, 6986, 0, 1, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=729048;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (729048, 23929, 571, 495, 495, 1, 65535, 0, 0, 2119.55, -6139.89, 1.32243, 2.76073, 300, 0, 0, 6761, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=729049;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (729049, 23929, 571, 495, 495, 1, 65535, 0, 0, 2138.81, -6164.19, -0.187676, 5.39966, 300, 0, 0, 6761, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=729050;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (729050, 23929, 571, 495, 495, 1, 65535, 0, 0, 2156.54, -6129.93, 1.63039, 0.977862, 300, 0, 0, 6761, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=729051;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (729051, 23929, 571, 495, 495, 1, 65535, 0, 0, 2178.49, -6105.45, 1.87153, 0.946446, 300, 0, 0, 6761, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=729052;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (729052, 23929, 571, 495, 495, 1, 65535, 0, 0, 2216.77, -6157.08, -3.33476, 5.25829, 300, 0, 0, 6761, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=729053;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (729053, 23929, 571, 495, 495, 1, 65535, 0, 0, 2263.88, -6166.83, -2.4711, 0.0235991, 300, 0, 0, 6761, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=729054;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (729054, 23929, 571, 495, 495, 1, 65535, 0, 0, 2318.57, -6169.39, 1.97034, 5.23472, 300, 0, 0, 6542, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=729055;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (729055, 23929, 571, 495, 495, 1, 65535, 0, 0, 2244.35, -6113.96, -1.56091, 2.48975, 300, 0, 0, 6761, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=729056;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (729056, 23929, 571, 495, 495, 1, 65535, 0, 0, 2230.31, -6080.35, 3.11836, 1.0132, 300, 0, 0, 6542, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=729057;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (729057, 23929, 571, 495, 495, 1, 65535, 0, 0, 2288.47, -6045.82, 1.43026, 0.565526, 300, 0, 0, 6542, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=729058;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (729058, 23929, 571, 495, 495, 1, 65535, 0, 0, 2342.43, -6084.4, 1.35238, 4.04878, 300, 0, 0, 6542, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=729059;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (729059, 23929, 571, 495, 495, 1, 65535, 0, 0, 2378.46, -6066.78, 1.03316, 0.471286, 300, 0, 0, 6542, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=729060;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (729060, 23929, 571, 495, 495, 1, 65535, 0, 0, 2391.97, -6016.87, 1.2183, 1.40984, 300, 0, 0, 6761, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=729061;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (729061, 23929, 571, 495, 495, 1, 65535, 0, 0, 2438.29, -6052.13, -7.36478, 5.63528, 300, 0, 0, 6761, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=729062;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (729062, 23929, 571, 495, 495, 1, 65535, 0, 0, 2424.13, -6120.41, 1.56534, 4.9834, 300, 0, 0, 6761, 0, 0, 0, 0, 0, 0);
DELETE FROM `creature` WHERE `guid`=729063;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (729063, 23929, 571, 495, 495, 1, 65535, 0, 0, 2366.38, -6149.62, -11.6493, 3.62074, 300, 0, 0, 6542, 0, 0, 0, 0, 0, 0);