gwerwqewe

-- creature
UPDATE `creature_template` SET `ScriptName` = "npc_kristoff_manheim" WHERE `entry` = 39640;

-- texts

DELETE FROM `script_texts` WHERE `npc_entry` = 39640;
INSERT INTO `script_texts` (`npc_entry`, `entry`, `content_default`, `type`, `comment`) VALUES
(39640,-1559000,"Okay, let's do this! You fight the ogres, and I will... not fight them. Head for the exit!",1,"Kristoff-SayStartWP"),
(39640,-1559001,"That one's huge. You shouldn't have made him angry.",1,"Kristoff-SayAggroWP"),
(39640,-1559002,"We made it! I'll find my way back on my own. Do me a favor and go tell Royce Duskwhisper where he can stick his stupid Eye of Twilight.",1,"Kristoff-SayEndWP");

-- waypoints

DELETE FROM `waypoints` WHERE `entry` = 39640;
DELETE FROM `script_waypoint` WHERE `entry` = 39640;
INSERT INTO `script_waypoint` VALUES
(39640,0,5054.00,-2089.51,1277.56,0,"Kristoff-WP1"),
(39640,1,5069.14,-2097.08,1280.01,0,"Kristoff-WP2"),
(39640,2,5080.70,-2100.73,1281.03,0,"Kristoff-WP3"),
(39640,3,5086.15,-2103.57,1280.31,0,"Kristoff-WP41"),
(39640,4,5101.95,-2105.61,1276.45,0,"Kristoff-WP5"),
(39640,5,5113.23,-2107.11,1277.35,0,"Kristoff-WP6"),
(39640,6,5120.91,-2101.72,1278.10,0,"Kristoff-WP7"),
(39640,7,5124.94,-2093.96,1277.72,0,"Kristoff-WP8"),
(39640,8,5127.17,-2083.14,1277.09,0,"Kristoff-WP9"),
(39640,9,5138.43,-2073.17,1276.89,0,"Kristoff-WP10"),
(39640,10,5156.97,-2066.92,1278.20,0,"Kristoff-WP12"),
(39640,11,5166.75,-2069.29,1281.09,0,"Kristoff-WP11"),
(39640,12,5177.82,-2077.73,1282.54,0,"Kristoff-Wp13"),
(39640,13,5180.69,-2080.53,1282.15,0,"Kristoff-WP13"),
(39640,14,5185.87,-2084.54,1281.33,0,"Kristoff-WP14");