DELETE FROM creature WHERE guid IN(250498,250496,250497,250494,250492,250493,250495);
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
('250494', '50001', '571', '1', '1', '0', '497', '5964.42', '691.555', '641.595', '3.98363', '300', '0', '0', '65165', '0', '0', '2', '0', '0', '0'),
('250492', '50001', '571', '1', '1', '0', '497', '5960.18', '694.24', '641.268', '3.91687', '300', '0', '0', '65165', '0', '0', '2', '0', '0', '0'),
('250493', '50001', '571', '1', '1', '0', '497', '5962.07', '692.634', '641.383', '3.99934', '300', '0', '0', '65165', '0', '0', '2', '0', '0', '0'),
('250495', '50001', '571', '1', '1', '0', '497', '5966.79', '689.922', '641.768', '3.78885', '300', '0', '0', '65165', '0', '0', '2', '0', '0', '0'),
('250496', '50000', '571', '1', '1', '0', '0', '5970', '686.747', '642.069', '3.39222', '300', '0', '0', '175946', '0', '0', '2', '0', '0', '0'),
('250497', '50000', '571', '1', '1', '0', '0', '5953.71', '692.782', '640.912', '4.16584', '300', '0', '0', '175946', '0', '0', '2', '0', '0', '0'),
('250498', '50002', '571', '1', '1', '0', '0', '5960.36', '686.029', '640.543', '3.58465', '300', '0', '0', '56700', '0', '0', '2', '0', '0', '0');
DELETE FROM `creature_addon` WHERE `guid` IN(250498);
INSERT INTO `creature_addon` VALUES
(250498,1000006,0,0,1,0,NULL);
DELETE FROM creature_formations WHERE memberGUID IN(250498,250496,250497,250494,250492,250493,250495);
INSERT INTO creature_formations VALUES
(250498,250498,0,0,2),
(250498,250496,90,3,2),
(250498,250497,126,3,2),
(250498,250494,162,3,2),
(250498,250492,198,3,2),
(250498,250493,234,3,2),
(250498,250495,270,3,2);
DELETE FROM `creature_template` WHERE `entry` IN(50000,50001,50002);
INSERT INTO `creature_template` VALUES
(50000,0,0,0,0,0,15958,0,0,0,'Bile Retcher','',NULL,0,81,81,2,21,21,0,1,1.14286,1,1,464,604,0,708,7.5,2000,0,1,0,0,0,0,0,0,0,353,512,112,6,72,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,3,13.5,2,1,0,0,0,0,0,0,0,144,1,0,8388624,0,'',12340),
(50001,0,0,0,0,0,26563,0,0,0,'Skeletal Smith','',NULL,0,81,81,2,21,21,0,1,1.14286,1,1,464,604,0,708,7.5,2000,0,1,0,0,0,0,0,0,0,353,512,112,6,72,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,3,5,1,1,0,0,0,0,0,0,0,148,1,497,8388624,0,'',12340),
(50002,0,0,0,0,0,16178,0,0,0,'Soul Weaver','',NULL,0,80,80,2,21,21,0,1,1.14286,1,1,422,586,0,642,7.5,2000,0,1,0,0,0,0,0,0,0,345,509,103,6,72,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,3,4.5,1,1,0,0,0,0,0,0,0,64,1,0,8388624,0,'',12340);
DELETE FROM `game_event` WHERE `eventEntry`=65;
INSERT INTO `game_event` (`eventEntry`, `start_time`, `end_time`, `occurence`, `length`, `description`) VALUES ('65', '2011-07-12 18:29:34', '2011-08-01 18:29:41', '60', '15', 'Das Ausmerzen von Dalaran');
DELETE FROM `game_event_creature` WHERE `eventEntry`=65;
INSERT INTO `game_event_creature` VALUES
('65', '250498'),
('65', '250496'),
('65', '250497'),
('65', '250494'),
('65', '250492'),
('65', '250493'),
('65', '250495');
DELETE FROM linked_respawn WHERE guid IN(250498,250496,250497,250494,250492,250493,250495) OR linkedGuid IN(250498,250496,250497,250494,250492,250493,250495);
INSERT INTO linked_respawn VALUES
(250496,250498,0),
(250497,250498,0),
(250494,250498,0),
(250492,250498,0),
(250493,250498,0),
(250495,250498,0);
DELETE FROM `locales_creature` WHERE `entry` IN(50000,50001,50002);
INSERT INTO locales_creature(entry, name_loc3) VALUES
(50000, 'Gallwürger'),
(50001, 'Skelettschmied'),
(50002, 'Seelenwirker');
DELETE FROM `waypoint_data` WHERE `id`=1000000;
INSERT INTO `waypoint_data` VALUES
(1000000,1,5946.91,682.477,640.671,0,1,0,100,0),
(1000000,2,5943.218,673.046,640.887,0,1,0,100,0),
(1000000,3,5938.511,656.149,642.662,0,1,0,100,0),
(1000000,4,5922.627,648.990,644.413,0,1,0,100,0),
(1000000,5,5912.548,640.307,645.128,0,1,0,100,0);