Untitled

insert into creature_template (entry,modelid_m,name,minlevel,maxlevel,faction,speed,size,bounding_radius,trainer_type,`type`) VALUES ('18974','17210','Z\'kral','62','62','14','1','1','0','0','3')
update creature_template set minhealth='5400',maxhealth='5400',armor='20',speed='1.48',bounding_radius='2' where (entry='18974');
update creature_template set mingold='1011',maxgold='4051' where (entry='18974');
update creature_template set mindmg='150',maxdmg='325' where (entry='18974');
update creature_template set attackpower='100' where (entry='18974');
update creature_template set baseattacktime='1530' where (entry='18974');
update creature_template set rangeattacktime='1900',minrangedmg='203.77',maxrangedmg='289.86',rangedattackpower='100',combat_reach='3',lootid='18974',MovementType='1' where (entry='18974');
DELETE FROM `creature` WHERE `guid` = '108831983';
INSERT INTO `creature` VALUES (108831983,18974,530,-633.046,2631.54,-3.08868,2.27582,25,0,0,-633.046,2631.54,-3.08868,0,5400,0,0,1,'');
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`waittime`) VALUES ('108831983','1','-636.856506', '2636.021240', '-3.142437','2');
UPDATE `creature` SET `MovementType` = '2' WHERE `guid` = '108831983';
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`waittime`) VALUES ('108831983','2','-646.657227', '2645.959717', '-3.003696','2');
UPDATE `creature` SET `MovementType` = '2' WHERE `guid` = '108831983';
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`waittime`) VALUES ('108831983','3','-633.624023', '2659.038330', '-2.318876','2');
UPDATE `creature` SET `MovementType` = '2' WHERE `guid` = '108831983';
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`waittime`) VALUES ('108831983','4','-651.300659', '2680.766846', '-0.481313','2');
UPDATE `creature` SET `MovementType` = '2' WHERE `guid` = '108831983';
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`waittime`) VALUES ('108831983','5','-668.268555', '2696.395264', '0.407012','2');
UPDATE `creature` SET `MovementType` = '2' WHERE `guid` = '108831983';
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`waittime`) VALUES ('108831983','6','-690.557800', '2684.771973', '2.167335','2');
UPDATE `creature` SET `MovementType` = '2' WHERE `guid` = '108831983';
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`waittime`) VALUES ('108831983','7','-682.592346', '2665.586426', '1.231701','2');
UPDATE `creature` SET `MovementType` = '2' WHERE `guid` = '108831983';
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`waittime`) VALUES ('108831983','8','-667.830811', '2649.215576', '0.739467','2');
UPDATE `creature` SET `MovementType` = '2' WHERE `guid` = '108831983';
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`waittime`) VALUES ('108831983','9','-649.256104', '2642.730713', '-2.180982','2');
UPDATE `creature` SET `MovementType` = '2' WHERE `guid` = '108831983';
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`waittime`) VALUES ('108831983','10','-642.313599', '2641.840088', '-3.228328','2');
UPDATE `creature` SET `MovementType` = '2' WHERE `guid` = '108831983';
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`waittime`) VALUES ('108831983','11','-632.504028', '2630.171875', '-3.122601','2');
UPDATE `creature` SET `MovementType` = '2' WHERE `guid` = '108831983';
update creature set spawntimesecs='360' where (guid='108831983');