DELETE FROM `creature` WHERE `id1` IN (16478, 16484, 16495, 16493, 16494, 16490, 16281, 16241, 16255, 16361, 16143, 16285, 29087, 28318, 16786, 16787, 29442, 29441, 16431, 16531); INSERT INTO `creature` (`guid`, `id1`, `id2`, `id3`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`, `CreateObject`, `Comment`) VALUES (9999212, 16478, 0, 0, 0, 0, 0, 1, 1, 0, -9075.86, 413.467, 92.8368, 2.89831, 300, 0, 0, 5000, 0, 0, 0, 0, 0, '', NULL, 0, 'Lieutenant Orrin'), (9999213, 16484, 0, 0, 0, 0, 0, 1, 1, 0, -5034.58, -827.808, 495.193, 1.36453, 300, 0, 0, 247, 0, 0, 0, 0, 0, '', NULL, 0, 'Lieutenant Nevell'), (9999214, 16495, 0, 0, 1, 0, 0, 1, 1, 0, 9926.06, 2196.76, 1328, 6.07924, 300, 0, 0, 247, 0, 0, 0, 0, 0, '', NULL, 0, 'Lieutenant Beitha'), (9999215, 16493, 0, 0, 1, 0, 0, 1, 1, 0, 1504, -4405.42, 22.2996, 4.64426, 300, 0, 0, 247, 0, 0, 0, 0, 0, '', NULL, 0, 'Lieutenant Dagel'), (9999216, 16494, 0, 0, 0, 0, 0, 1, 1, 0, 1741.57, 232.84, 62.2421, 0.522293, 300, 0, 0, 247, 0, 0, 0, 0, 0, '', NULL, 0, 'Lieutenant Rukag'), (9999217, 16490, 0, 0, 1, 0, 0, 1, 1, 0, -1276.45, 135.078, 131.62, 2.19755, 300, 0, 0, 247, 0, 0, 0, 0, 0, '', NULL, 0, 'Lieutenant Lisande'), (9999218, 16281, 0, 0, 0, 0, 0, 1, 1, 1, 2266.48, -5302.08, 82.1662, 1.55131, 300, 0, 0, 7177, 0, 0, 0, 0, 0, '', NULL, 0, 'Keeper of the Rolls'), (9999219, 16241, 0, 0, 0, 0, 0, 1, 1, 1, -5046.2, -817.416, 495.135, 1.13488, 300, 0, 0, 6535, 0, 0, 0, 0, 0, '', NULL, 0, 'Argent Recruiter'), (9999220, 16241, 0, 0, 1, 0, 0, 1, 1, 1, 9927.33, 2491.28, 1317.27, 0.650405, 300, 5, 0, 6535, 0, 1, 0, 0, 0, '', NULL, 0, 'Argent Recruiter'), (9999221, 16241, 0, 0, 0, 0, 0, 1, 1, 1, -8887.16, 588.348, 93.3619, 5.01865, 300, 6, 0, 6535, 0, 1, 0, 0, 0, '', NULL, 0, 'Argent Recruiter'), (9999222, 16241, 0, 0, 0, 0, 0, 1, 1, 1, -8809.56, 620.566, 94.9331, 2.21328, 300, 0, 0, 6535, 0, 0, 0, 0, 0, '', NULL, 0, 'Argent Recruiter'), (9999223, 16255, 0, 0, 1, 0, 0, 1, 1, 1, 1531.86, -4436.12, 14.5323, 1.11923, 300, 0, 0, 7402, 0, 0, 0, 0, 0, '', NULL, 0, 'Argent Scout'), (9999224, 16255, 0, 0, 1, 0, 0, 1, 1, 1, -1273.1, 74.8744, 128.084, 0.412095, 300, 4, 0, 7402, 0, 1, 0, 0, 0, '', NULL, 0, 'Argent Scout'), (9999225, 16255, 0, 0, 0, 0, 0, 1, 1, 1, 1555.93, 247.213, -43.1026, 6.03792, 300, 0, 0, 7177, 0, 0, 0, 0, 0, '', NULL, 0, 'Argent Scout'), (9999226, 16361, 0, 0, 0, 0, 0, 1, 1, 1, 2265.69, -5306.91, 82.1646, 2.37378, 300, 0, 0, 6535, 0, 0, 0, 0, 0, '', NULL, 0, 'Commander Thomas Helleran'), (9999227, 16143, 0, 0, 0, 0, 0, 1, 1, 0, -1357.74, 516.768, 90.9582, 3.20016, 300, 4, 0, 67144, 0, 1, 0, 0, 0, '', NULL, 0, 'Shadow of Doom'), (9999228, 16285, 0, 0, 0, 0, 0, 1, 1, 1, -5055.06, -815.265, 495.386, 0.759309, 300, 0, 0, 6535, 0, 0, 0, 0, 0, '', NULL, 0, 'Argent Emissary'), (9999229, 16285, 0, 0, 1, 0, 0, 1, 1, 1, 9950.27, 2494.3, 1317.25, 4.54779, 300, 0, 0, 6535, 0, 0, 0, 0, 0, '', NULL, 0, 'Argent Emissary'), (9999230, 16285, 0, 0, 0, 0, 0, 1, 1, 1, -8817.5, 630.228, 94.1373, 5.53419, 300, 0, 0, 6535, 0, 0, 0, 0, 0, '', NULL, 0, 'Argent Emissary'), (9999231, 29087, 0, 0, 530, 0, 0, 1, 1, 1, -1816.1, 5441.49, -12.4284, 3.16375, 300, 0, 0, 1229580, 63100, 0, 0, 0, 0, '', NULL, 0, 'Bishop Lazaril'), (9999232, 28318, 0, 0, 530, 0, 0, 1, 1, 0, -1782.21, 5557.39, -12.4282, 4.36274, 300, 0, 0, 13860, 0, 0, 0, 0, 0, '', NULL, 0, 'Grand Apothecary Putress'), (9999233, 16786, 0, 0, 0, 0, 0, 1, 1, 0, -4890.68, -953.546, 501.466, 2.24057, 300, 0, 0, 6535, 0, 0, 0, 0, 0, '', NULL, 0, 'Argent Quartermaster'), (9999234, 16786, 0, 0, 0, 0, 0, 1, 1, 0, -8832.95, 643.866, 94.8079, 4.56603, 300, 0, 0, 6535, 0, 0, 0, 0, 0, '', NULL, 0, 'Argent Quartermaster'), (9999235, 16786, 0, 0, 0, 0, 0, 1, 1, 0, 2257.47, -5323.59, 81.9436, 1.81317, 300, 0, 0, 6535, 0, 0, 0, 0, 0, '', NULL, 0, 'Argent Quartermaster'), (9999236, 16787, 0, 0, 1, 0, 0, 1, 1, 0, 1580.35, -4417.15, 8.00601, 3.43258, 300, 0, 0, 6535, 0, 0, 0, 0, 0, '', NULL, 0, 'Argent Outfitters'), (9999237, 16787, 0, 0, 1, 0, 0, 1, 1, 0, -1249.98, 78.4138, 128.281, 3.69263, 300, 0, 0, 6535, 0, 0, 0, 0, 0, '', NULL, 0, 'Argent Outfitters'), (9999238, 16787, 0, 0, 0, 0, 0, 1, 1, 0, 1585.36, 249.98, -62.0784, 2.69447, 300, 0, 0, 6535, 0, 0, 0, 0, 0, '', NULL, 0, 'Argent Outfitters'), (9999239, 16787, 0, 0, 0, 0, 0, 1, 1, 0, 2264.08, -5311.91, 81.8802, 2.27498, 300, 0, 0, 6535, 0, 0, 0, 0, 0, '', NULL, 0, 'Argent Outfitters'), (9999240, 29442, 0, 0, 530, 0, 0, 1, 1, 0, -4023.84, -11889.5, -1.29016, 4.8869, 300, 0, 0, 247, 0, 0, 0, 0, 0, '', NULL, 0, 'Lieutenant Kregor'), (9999241, 29441, 0, 0, 530, 0, 0, 1, 1, 0, 9338.25, -7284.79, 14.0037, 2.19962, 300, 0, 0, 247, 0, 0, 0, 0, 0, '', NULL, 0, 'Lieutenant Julek'), (9999242, 16431, 0, 0, 0, 0, 0, 1, 1, 0, 2396.58, -5007.82, 73.2928, 2.99716, 300, 0, 0, 6223, 0, 0, 0, 0, 0, '', NULL, 0, 'Cracked Necrotic Crystal'), (9999243, 16431, 0, 0, 0, 0, 0, 1, 1, 0, 2071.04, -5227.94, 84.0269, 3.06184, 300, 0, 0, 6223, 0, 0, 0, 0, 0, '', NULL, 0, 'Cracked Necrotic Crystal'), (9999244, 16431, 0, 0, 0, 0, 0, 1, 1, 0, 2058.28, -4689.9, 78.8891, 0.743971, 300, 0, 0, 6223, 0, 0, 0, 0, 0, '', NULL, 0, 'Cracked Necrotic Crystal'), (9999245, 16431, 0, 0, 0, 0, 0, 1, 1, 0, -7928.36, -2370.42, 122.623, 2.90189, 300, 0, 0, 6223, 0, 0, 0, 0, 0, '', NULL, 0, 'Cracked Necrotic Crystal'), (9999246, 16431, 0, 0, 0, 0, 0, 1, 1, 0, -7715.24, -2229.35, 136.287, 4.16012, 300, 0, 0, 6223, 0, 0, 0, 0, 0, '', NULL, 0, 'Cracked Necrotic Crystal'), (9999247, 16431, 0, 0, 0, 0, 0, 1, 1, 0, -8003.47, -2409.8, 123.754, 2.81639, 300, 0, 0, 6223, 0, 0, 0, 0, 0, '', NULL, 0, 'Cracked Necrotic Crystal'), (9999248, 16431, 0, 0, 1, 0, 0, 1, 1, 0, 3506.45, -4337.38, 126.362, 1.56576, 300, 0, 0, 6223, 0, 0, 0, 0, 0, '', NULL, 0, 'Cracked Necrotic Crystal'), (9999249, 16431, 0, 0, 1, 0, 0, 1, 1, 0, 3578.3, -4060.05, 97.4089, 6.1278, 300, 0, 0, 6223, 0, 0, 0, 0, 0, '', NULL, 0, 'Cracked Necrotic Crystal'), (9999250, 16531, 0, 0, 0, 0, 0, 1, 1, 0, 1985.82, -3087.96, 78.4403, 1.69683, 300, 0, 0, 6223, 0, 0, 0, 0, 0, '', NULL, 0, 'Faint Necrotic Crystal'), (9999251, 16531, 0, 0, 0, 0, 0, 1, 1, 0, 1906.52, -2792.13, 71.7248, 5.99943, 300, 0, 0, 6223, 0, 0, 0, 0, 0, '', NULL, 0, 'Faint Necrotic Crystal'), (9999252, 16531, 0, 0, 0, 0, 0, 1, 1, 0, 1878.4, -2654.59, 71.8428, 5.12489, 300, 0, 0, 6223, 0, 0, 0, 0, 0, '', NULL, 0, 'Faint Necrotic Crystal'), (9999253, 16531, 0, 0, 0, 0, 0, 1, 1, 0, 1822.55, -2686.83, 71.7254, 1.35511, 300, 0, 0, 6223, 0, 0, 0, 0, 0, '', NULL, 0, 'Faint Necrotic Crystal'), (9999254, 16531, 0, 0, 0, 0, 0, 1, 1, 0, 1746.03, -2871.46, 71.834, 0.0979422, 300, 0, 0, 6223, 0, 0, 0, 0, 0, '', NULL, 0, 'Faint Necrotic Crystal'), (9999255, 16531, 0, 0, 0, 0, 0, 1, 1, 0, 1690.53, -3070.52, 78.5079, 0.899959, 300, 0, 0, 6223, 0, 0, 0, 0, 0, '', NULL, 0, 'Faint Necrotic Crystal');