-- ---------------------------------
-- Table structure for walker_routes
-- ---------------------------------
DROP TABLE IF EXISTS `walker_routes`;
CREATE TABLE `walker_routes` (
  `route_id` int(11) NOT NULL default '0',
  `npc_id` int(11) NOT NULL default '0',
  `move_point` int(9) NOT NULL,
  `chatText` varchar(255) default NULL,
  `move_x` int(9) NOT NULL default '0',
  `move_y` int(9) NOT NULL default '0',
  `move_z` int(9) NOT NULL default '0',
  `delay`  int(9) NOT NULL default '0',
  `running`  tinyint(1) NOT NULL default '0',
   PRIMARY KEY (`route_id`,`npc_id`,`move_point`)
) DEFAULT CHARSET=utf8;

--
-- Dumping data for table `walker_routes`
--

INSERT INTO `walker_routes` VALUES 
(1,31361,1,NULL,22418,10249,-3648,61,1),
(1,31361,2,NULL,23423,11165,-3720,0,1),
(1,31361,3,NULL,20182,11101,-3720,0,1),
(1,31361,4,NULL,17327,13603,-3728,1,1),
(1,31361,5,'The mass of darkness will start in a couple of days. Pay more attention to the guard!',17410,13038,-3736,10,1),
(1,31361,6,NULL,20176,12902,-3712,0,1),
(1,31361,7,NULL,21669,13378,-3616,0,1),
(1,31361,8,NULL,20675,10401,-3712,0,1),
(2,31360,1,NULL,10820,14770,-4240,62,0),
(2,31360,2,NULL,10947,14642,-4240,0,0),
(2,31360,3,NULL,11301,15844,-4584,0,0),
(2,31360,4,NULL,12107,16431,-4584,0,0),
(2,31360,5,'You''re a hard worker,Rayla!',15097,15662,-4376,6,0),
(2,31360,6,NULL,15269,16281,-4376,7,0),
(2,31360,7,NULL,12336,16921,-4584,0,0),
(2,31360,8,NULL,11786,17663,-4564,0,0),
(2,31360,9,NULL,11246,17650,-4568,0,0),
(2,31360,10,NULL,10649,17284,-4584,0,0),
(2,31360,11,'You''re a hard worker!',7692,18041,-4376,6,0),
(2,31360,12,NULL,10549,16780,-4584,0,0),
(2,31360,13,NULL,10722,16538,-4584,0,0),
(2,31360,14,NULL,11008,15927,-4584,0,0),
(3,31362,1,'Mr. Lid,Murdoc,and Airy! How are you doing?',114847,-180066,-877,30,0),
(3,31362,2,NULL,114834,-179685,-877,2,0),
(3,31362,3,NULL,116122,-179457,-1068,1,0),
(3,31362,4,NULL,116798,-180391,-1200,2,0),
(3,31362,5,NULL,116324,-181564,-1384,2,0),
(3,31362,6,NULL,115797,-181563,-1336,0,0),
(3,31362,7,'Care to go a round?',116054,-181575,-1352,0,0),
(3,31362,8,NULL,116506,-181478,-1384,2,0),
(3,31362,9,NULL,116634,-180029,-1160,1,0),
(3,31362,10,NULL,115347,-178623,-928,1,0),
(3,31362,11,NULL,115763,-177591,-888,2,0),
(3,31362,12,'Have a nice day,Mr. Garita and Mion!',115801,-177342,-880,1,0),
(3,31362,13,NULL,115869,-177340,-880,15,0),
(3,31362,14,NULL,115788,-177482,-880,3,0),
(3,31362,15,NULL,115124,-179821,-885,1,0),
(3,31362,16,NULL,115103,-180065,-877,1,0),
(4,31363,1,'Where is that fool hiding?',116731,-182477,-1512,10,1),
(4,31363,2,NULL,115870,-183280,-1472,0,1),
(4,31363,3,NULL,115746,-183428,-1472,1,1),
(4,31363,4,NULL,115870,-183280,-1472,1,1),
(4,31363,5,NULL,115999,-183246,-1480,0,1),
(4,31363,6,NULL,116094,-183113,-1480,1,1),
(4,31363,7,'Have you seen Torocco today?',116584,-184294,-1568,11,1),
(4,31363,8,NULL,116392,-184100,-1560,1,1),
(4,31363,9,NULL,117093,-182524,-1528,1,1),
(4,31363,10,'Have you seen Torocco?',117789,-182540,-1528,11,1),
(5,31359,1,NULL,45744,50561,-3065,61,0),
(5,31359,2,NULL,46444,49742,-3065,2,0),
(5,31359,3,'How can we save the Mother Tree?',46103,48798,-3065,5,0),
(5,31359,4,'The Mother Tree is slowly dying',45403,48436,-3065,5,0),
(5,31359,5,NULL,44444,49078,-3065,0,0),
(5,31359,6,NULL,44414,50025,-3065,0,0),
(5,31359,7,NULL,44957,50568,-3065,0,0),
(5,31359,8,NULL,44414,50025,-3065,0,0),
(5,31359,9,NULL,44444,49078,-3065,0,0),
(5,31359,10,'The Mother Tree is slowly dying',45403,48436,-3065,5,0),
(5,31359,11,'How can we save the Mother Tree?',46103,48798,-3065,5,0),
(5,31359,12,NULL,46444,49742,-3065,2,0),
(6,31358,1,'Lady Mirabel,may the peace of the lake be with you!',47015,51278,-2992,65,0),
(6,31358,2,NULL,47437,50441,-2992,0,0),
(6,31358,3,NULL,47509,49038,-2992,0,0),
(6,31358,4,NULL,46725,47755,-2992,0,0),
(6,31358,5,'The Mother Tree is always so gorgeous!',45319,47339,-2992,5,0),
(6,31358,6,NULL,43998,47672,-2992,0,0),
(6,31358,7,NULL,43037,49310,-2992,0,0),
(6,31358,8,NULL,43310,50382,-2992,0,0),
(6,31358,9,NULL,43896,51060,-2992,0,0),
(6,31358,10,NULL,43312,50362,-2992,0,0),
(6,31358,11,NULL,43040,49311,-2992,0,0),
(6,31358,12,NULL,44018,47645,-2992,0,0),
(6,31358,13,'The Mother Tree is always so gorgeous!',45301,47340,-2992,5,0),
(6,31358,14,NULL,46693,47752,-2992,0,0),
(6,31358,15,NULL,47489,48976,-2992,0,0),
(6,31358,16,NULL,47441,50455,-2992,0,0),
(7,31357,1,'Where did he go?',-86328,241120,-3734,60,0),
(7,31357,2,NULL,-86505,240727,-3704,0,0),
(7,31357,3,NULL,-86081,240402,-3712,0,0),
(7,31357,4,'Have you seen Windawood?',-86078,240853,-3720,15,0),
(7,31357,5,NULL,-85957,241389,-3728,0,0),
(7,31357,6,'Where has he gone?',-83993,242766,-3728,10,0),
(7,31357,7,NULL,-82952,244461,-3728,0,0),
(7,31357,8,NULL,-82370,244919,-3720,0,0),
(7,31357,9,NULL,-82129,245020,-3720,0,0),
(7,31357,10,NULL,-82198,245350,-3712,0,0),
(7,31357,11,NULL,-82554,245137,-3716,1,0),
(7,31357,12,NULL,-82198,245350,-3712,0,0),
(7,31357,13,NULL,-82129,245020,-3720,0,0),
(7,31357,14,NULL,-82370,244919,-3720,0,0),
(7,31357,15,NULL,-82952,244461,-3728,0,0),
(7,31357,16,'Where has he gone?',-83993,242766,-3728,10,0),
(7,31357,17,NULL,-85957,241389,-3728,0,0),
(7,31357,18,'Have you seen Windawood?',-86078,240853,-3720,15,0),
(7,31357,19,NULL,-86081,240402,-3712,0,0),
(7,31357,20,NULL,-86505,240727,-3704,0,0),
(8,31356,1,'A delivery for Mr. Lector? Very good!',-81681,243384,-3712,61,1),
(8,31356,2,NULL,-81915,243870,-3712,1,1),
(8,31356,3,NULL,-82084,243659,-3712,0,1),
(8,31356,4,NULL,-83148,243731,-3728,0,1),
(8,31356,5,'I need a break!',-84497,243241,-3728,6,1),
(8,31356,6,NULL,-85212,243184,-3728,0,1),
(8,31356,7,NULL,-86161,242898,-3728,0,1),
(8,31356,8,NULL,-86281,242963,-3720,0,1),
(8,31356,9,'Hello,Mr. Lector! Long time no see,Mr. Jackson!',-86356,243201,-3720,7,1),
(8,31356,10,NULL,-86491,242781,-3720,0,1),
(8,31356,11,NULL,-86497,242585,-3728,0,1),
(8,31356,12,NULL,-86114,241587,-3728,0,1),
(8,31356,13,NULL,-85184,240679,-3728,0,1),
(8,31356,14,'Lulu!',-84075,241282,-3728,3,1),
(8,31356,15,'Lulu!',-84075,241282,-3728,3,1),
(8,31356,16,'Lulu!',-83709,241238,-3728,0,1),
(8,31356,17,NULL,-83182,241141,-3728,1,1),
(8,31356,18,NULL,-82383,242926,-3720,1,1),
(9,31364,1,NULL,-46506,-109402,-238,10,0),
(9,31364,2,NULL,-45752,-111652,-240,0,0),
(9,31364,3,NULL,-44028,-112688,-240,0,0),
(9,31364,4,NULL,-44049,-114536,-240,0,0),
(9,31364,5,NULL,-45540,-115415,-240,0,0),
(9,31364,6,NULL,-46526,-117731,-240,0,0),
(9,31364,7,NULL,-45540,-115415,-240,0,0),
(9,31364,8,NULL,-44049,-114536,-240,0,0),
(9,31364,9,NULL,-44028,-112688,-240,0,0),
(9,31364,10,NULL,-45752,-111652,-240,0,0),
(10,31365,1,NULL,-48807,-113489,-241,61,0),
(10,31365,2,NULL,-48821,-113746,-232,1,0),
(10,31365,3,NULL,-48823,-113505,-232,61,0),
(10,31365,4,NULL,-47339,-113581,-232,1,0),
(10,31365,5,NULL,-45740,-113562,-240,0,0),
(10,31365,6,NULL,-44851,-112965,-240,0,0),
(10,31365,7,NULL,-44308,-113207,-240,0,0),
(10,31365,8,NULL,-44204,-113743,-240,0,0),
(10,31365,9,NULL,-44659,-114171,-240,0,0),
(10,31365,10,NULL,-45167,-114034,-224,0,0),
(10,31365,11,NULL,-45658,-113633,-240,0,0),
(10,31365,12,NULL,-47363,-113621,-224,0,0),
(10,31365,13,NULL,-48829,-113746,-232,0,0),
(10,31365,14,NULL,-47363,-113621,-224,0,0),
(10,31365,15,NULL,-45658,-113633,-240,0,0),
(10,31365,16,NULL,-45167,-114034,-224,0,0),
(10,31365,17,NULL,-44659,-114171,-240,0,0),
(10,31365,18,NULL,-44204,-113743,-240,0,0),
(10,31365,19,NULL,-44308,-113207,-240,0,0),
(10,31365,20,NULL,-44851,-112965,-240,0,0),
(10,31365,21,NULL,-45740,-113562,-240,1,0),
(11,32072,1,NULL,84429,-144065,-1542,10,0),
(11,32072,2,NULL,84465,-142493,-1536,0,0),
(11,32072,3,NULL,85234,-140963,-1536,0,0),
(11,32072,4,NULL,87351,-140059,-1536,5,0),
(11,32072,5,NULL,89343,-140746,-1536,0,0),
(11,32072,6,NULL,90605,-143167,-1536,0,0),
(11,32072,7,NULL,90271,-143869,-1536,10,0),
(11,32072,8,NULL,90605,-143167,-1536,0,0),
(11,32072,9,NULL,89343,-140746,-1536,0,0),
(11,32072,10,NULL,87351,-140059,-1536,5,0),
(11,32072,11,NULL,85234,-140963,-1536,0,0),
(11,32072,12,NULL,84465,-142493,-1536,0,0),
(12,32070,1,NULL,90271,-143869,-1547,10,1),
(12,32070,2,NULL,90605,-143167,-1536,1,1),
(12,32070,3,NULL,89343,-140746,-1536,1,1),
(12,32070,4,NULL,87351,-140059,-1536,5,1),
(12,32070,5,NULL,85234,-140963,-1536,1,1),
(12,32070,6,NULL,84465,-142493,-1536,1,1),
(12,32070,7,NULL,84434,-144061,-1528,10,1),
(12,32070,8,NULL,84465,-142493,-1536,1,1),
(12,32070,9,NULL,85234,-140963,-1536,1,1),
(12,32070,10,NULL,87351,-140059,-1536,5,1),
(12,32070,11,NULL,89343,-140746,-1536,1,1),
(12,32070,12,NULL,90605,-143167,-1536,1,1);

INSERT INTO `walker_routes` VALUES
(13,29095,1,NULL,141569,-45908,-2387,10,0),
(13,29095,2,NULL,142494,-45456,-2397,0,0),
(13,29095,3,NULL,142922,-44561,-2395,0,0),
(13,29095,4,NULL,143672,-44130,-2398,0,0),
(13,29095,5,NULL,144557,-43378,-2325,0,0),
(13,29095,6,NULL,145839,-43267,-2301,0,0),
(13,29095,7,NULL,147044,-43601,-2307,0,0),
(13,29095,8,NULL,148140,-43206,-2303,0,0),
(13,29095,9,NULL,148815,-43434,-2328,5,0),
(13,29095,10,NULL,149862,-44151,-2558,0,0),
(13,29095,11,NULL,151037,-44197,-2708,5,0),
(13,29095,12,NULL,152555,-42756,-2836,0,0),
(13,29095,13,NULL,154808,-39546,-3236,0,0),
(13,29095,14,NULL,155333,-39962,-3272,0,0),
(13,29095,15,NULL,156531,-41240,-3470,0,0),
(13,29095,16,NULL,156863,-43232,-3707,0,0),
(13,29095,17,NULL,156783,-44198,-3764,0,0),
(13,29095,18,NULL,158169,-45163,-3541,0,0),
(13,29095,19,NULL,158952,-45479,-3473,0,0),
(13,29095,20,NULL,160039,-46514,-3634,0,0),
(13,29095,21,NULL,160244,-47429,-3656,3,0),
(13,29095,22,NULL,159155,-48109,-3665,0,0),
(13,29095,23,NULL,159558,-51027,-3523,0,0),
(13,29095,24,NULL,159396,-53362,-3244,3,0),
(13,29095,25,NULL,160872,-56556,-2789,0,0),
(13,29095,26,NULL,160857,-59072,-2613,5,0),
(13,29095,27,NULL,160410,-59888,-2647,0,0),
(13,29095,28,NULL,158770,-60173,-2673,0,0),
(13,29095,29,NULL,156368,-59557,-2638,3,0),
(13,29095,30,NULL,155188,-59868,-2642,0,0),
(13,29095,31,NULL,154118,-60591,-2731,0,0),
(13,29095,32,NULL,153571,-61567,-2821,0,0),
(13,29095,33,NULL,153457,-62819,-2886,3,0),
(13,29095,34,NULL,152939,-63778,-3003,0,0),
(13,29095,35,NULL,151816,-64209,-3120,0,0),
(13,29095,36,NULL,147655,-64826,-3433,0,0),
(13,29095,37,NULL,145422,-64576,-3369,0,0),
(13,29095,38,NULL,144097,-64320,-3404,0,0),
(13,29095,39,NULL,140780,-61618,-3096,0,0),
(13,29095,40,NULL,139688,-61450,-3062,0,0),
(13,29095,41,NULL,138267,-61743,-3056,3,0),
(13,29095,42,NULL,138613,-58491,-3465,0,0),
(13,29095,43,NULL,138139,-57252,-3517,5,0),
(13,29095,44,NULL,139555,-56044,-3310,0,0),
(13,29095,45,NULL,139107,-54537,-3240,0,0),
(13,29095,46,NULL,139279,-53781,-3091,0,0),
(13,29095,47,NULL,139810,-52687,-2866,0,0),
(13,29095,48,NULL,139657,-52041,-2793,0,0),
(13,29095,49,NULL,139215,-51355,-2698,0,0),
(13,29095,50,NULL,139334,-50514,-2594,0,0),
(13,29095,51,NULL,139817,-49715,-2449,0,0),
(13,29095,52,NULL,139824,-48976,-2263,0,0),
(13,29095,53,NULL,140130,-47578,-2213,0,0),
(13,29095,54,NULL,140483,-46339,-2382,5,0),
(13,29095,55,NULL,141569,-45908,-2387,0,0);
