Home Explore Help
Register Sign In
L2j
/
l2j-server-datapack
2
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: datapack_development
Branches Tags
l2j-server-data...
/
sql
/
walker_routes.sql

walker_routes.sql 11 KB
Permalink History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248 
  1. -- ---------------------------------
    2. 

  2. -- Table structure for walker_routes
    3. 

  3. -- ---------------------------------
    4. 

  4. DROP TABLE IF EXISTS `walker_routes`;
    5. 

  5. CREATE TABLE `walker_routes` (
    6. 

  6.   `route_id` int(11) NOT NULL default '0',
    7. 

  7.   `npc_id` int(11) NOT NULL default '0',
    8. 

  8.   `move_point` int(9) NOT NULL,
    9. 

  9.   `chatText` varchar(255) default NULL,
    10. 

  10.   `move_x` int(9) NOT NULL default '0',
    11. 

  11.   `move_y` int(9) NOT NULL default '0',
    12. 

  12.   `move_z` int(9) NOT NULL default '0',
    13. 

  13.   `delay`  int(9) NOT NULL default '0',
    14. 

  14.   `running`  tinyint(1) NOT NULL default '0',
    15. 

  15.    PRIMARY KEY (`route_id`,`npc_id`,`move_point`)
    16. 

  16. ) DEFAULT CHARSET=utf8;
    17. 

  17. 

  18. --
    19. 

  19. -- Dumping data for table `walker_routes`
    20. 

  20. --
    21. 

  21. 

  22. INSERT INTO `walker_routes` VALUES 
    23. 

  23. (1,31361,1,NULL,22418,10249,-3648,61,1),
    24. 

  24. (1,31361,2,NULL,23423,11165,-3720,0,1),
    25. 

  25. (1,31361,3,NULL,20182,11101,-3720,0,1),
    26. 

  26. (1,31361,4,NULL,17327,13603,-3728,1,1),
    27. 

  27. (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),
    28. 

  28. (1,31361,6,NULL,20176,12902,-3712,0,1),
    29. 

  29. (1,31361,7,NULL,21669,13378,-3616,0,1),
    30. 

  30. (1,31361,8,NULL,20675,10401,-3712,0,1),
    31. 

  31. (2,31360,1,NULL,10820,14770,-4240,62,0),
    32. 

  32. (2,31360,2,NULL,10947,14642,-4240,0,0),
    33. 

  33. (2,31360,3,NULL,11301,15844,-4584,0,0),
    34. 

  34. (2,31360,4,NULL,12107,16431,-4584,0,0),
    35. 

  35. (2,31360,5,'You''re a hard worker,Rayla!',15097,15662,-4376,6,0),
    36. 

  36. (2,31360,6,NULL,15269,16281,-4376,7,0),
    37. 

  37. (2,31360,7,NULL,12336,16921,-4584,0,0),
    38. 

  38. (2,31360,8,NULL,11786,17663,-4564,0,0),
    39. 

  39. (2,31360,9,NULL,11246,17650,-4568,0,0),
    40. 

  40. (2,31360,10,NULL,10649,17284,-4584,0,0),
    41. 

  41. (2,31360,11,'You''re a hard worker!',7692,18041,-4376,6,0),
    42. 

  42. (2,31360,12,NULL,10549,16780,-4584,0,0),
    43. 

  43. (2,31360,13,NULL,10722,16538,-4584,0,0),
    44. 

  44. (2,31360,14,NULL,11008,15927,-4584,0,0),
    45. 

  45. (3,31362,1,'Mr. Lid,Murdoc,and Airy! How are you doing?',114847,-180066,-877,30,0),
    46. 

  46. (3,31362,2,NULL,114834,-179685,-877,2,0),
    47. 

  47. (3,31362,3,NULL,116122,-179457,-1068,1,0),
    48. 

  48. (3,31362,4,NULL,116798,-180391,-1200,2,0),
    49. 

  49. (3,31362,5,NULL,116324,-181564,-1384,2,0),
    50. 

  50. (3,31362,6,NULL,115797,-181563,-1336,0,0),
    51. 

  51. (3,31362,7,'Care to go a round?',116054,-181575,-1352,0,0),
    52. 

  52. (3,31362,8,NULL,116506,-181478,-1384,2,0),
    53. 

  53. (3,31362,9,NULL,116634,-180029,-1160,1,0),
    54. 

  54. (3,31362,10,NULL,115347,-178623,-928,1,0),
    55. 

  55. (3,31362,11,NULL,115763,-177591,-888,2,0),
    56. 

  56. (3,31362,12,'Have a nice day,Mr. Garita and Mion!',115801,-177342,-880,1,0),
    57. 

  57. (3,31362,13,NULL,115869,-177340,-880,15,0),
    58. 

  58. (3,31362,14,NULL,115788,-177482,-880,3,0),
    59. 

  59. (3,31362,15,NULL,115124,-179821,-885,1,0),
    60. 

  60. (3,31362,16,NULL,115103,-180065,-877,1,0),
    61. 

  61. (4,31363,1,'Where is that fool hiding?',116731,-182477,-1512,10,1),
    62. 

  62. (4,31363,2,NULL,115870,-183280,-1472,0,1),
    63. 

  63. (4,31363,3,NULL,115746,-183428,-1472,1,1),
    64. 

  64. (4,31363,4,NULL,115870,-183280,-1472,1,1),
    65. 

  65. (4,31363,5,NULL,115999,-183246,-1480,0,1),
    66. 

  66. (4,31363,6,NULL,116094,-183113,-1480,1,1),
    67. 

  67. (4,31363,7,'Have you seen Torocco today?',116584,-184294,-1568,11,1),
    68. 

  68. (4,31363,8,NULL,116392,-184100,-1560,1,1),
    69. 

  69. (4,31363,9,NULL,117093,-182524,-1528,1,1),
    70. 

  70. (4,31363,10,'Have you seen Torocco?',117789,-182540,-1528,11,1),
    71. 

  71. (5,31359,1,NULL,45744,50561,-3065,61,0),
    72. 

  72. (5,31359,2,NULL,46444,49742,-3065,2,0),
    73. 

  73. (5,31359,3,'How can we save the Mother Tree?',46103,48798,-3065,5,0),
    74. 

  74. (5,31359,4,'The Mother Tree is slowly dying',45403,48436,-3065,5,0),
    75. 

  75. (5,31359,5,NULL,44444,49078,-3065,0,0),
    76. 

  76. (5,31359,6,NULL,44414,50025,-3065,0,0),
    77. 

  77. (5,31359,7,NULL,44957,50568,-3065,0,0),
    78. 

  78. (5,31359,8,NULL,44414,50025,-3065,0,0),
    79. 

  79. (5,31359,9,NULL,44444,49078,-3065,0,0),
    80. 

  80. (5,31359,10,'The Mother Tree is slowly dying',45403,48436,-3065,5,0),
    81. 

  81. (5,31359,11,'How can we save the Mother Tree?',46103,48798,-3065,5,0),
    82. 

  82. (5,31359,12,NULL,46444,49742,-3065,2,0),
    83. 

  83. (6,31358,1,'Lady Mirabel,may the peace of the lake be with you!',47015,51278,-2992,65,0),
    84. 

  84. (6,31358,2,NULL,47437,50441,-2992,0,0),
    85. 

  85. (6,31358,3,NULL,47509,49038,-2992,0,0),
    86. 

  86. (6,31358,4,NULL,46725,47755,-2992,0,0),
    87. 

  87. (6,31358,5,'The Mother Tree is always so gorgeous!',45319,47339,-2992,5,0),
    88. 

  88. (6,31358,6,NULL,43998,47672,-2992,0,0),
    89. 

  89. (6,31358,7,NULL,43037,49310,-2992,0,0),
    90. 

  90. (6,31358,8,NULL,43310,50382,-2992,0,0),
    91. 

  91. (6,31358,9,NULL,43896,51060,-2992,0,0),
    92. 

  92. (6,31358,10,NULL,43312,50362,-2992,0,0),
    93. 

  93. (6,31358,11,NULL,43040,49311,-2992,0,0),
    94. 

  94. (6,31358,12,NULL,44018,47645,-2992,0,0),
    95. 

  95. (6,31358,13,'The Mother Tree is always so gorgeous!',45301,47340,-2992,5,0),
    96. 

  96. (6,31358,14,NULL,46693,47752,-2992,0,0),
    97. 

  97. (6,31358,15,NULL,47489,48976,-2992,0,0),
    98. 

  98. (6,31358,16,NULL,47441,50455,-2992,0,0),
    99. 

  99. (7,31357,1,'Where did he go?',-86328,241120,-3734,60,0),
    100. 

  100. (7,31357,2,NULL,-86505,240727,-3704,0,0),
    101. 

  101. (7,31357,3,NULL,-86081,240402,-3712,0,0),
    102. 

  102. (7,31357,4,'Have you seen Windawood?',-86078,240853,-3720,15,0),
    103. 

  103. (7,31357,5,NULL,-85957,241389,-3728,0,0),
    104. 

  104. (7,31357,6,'Where has he gone?',-83993,242766,-3728,10,0),
    105. 

  105. (7,31357,7,NULL,-82952,244461,-3728,0,0),
    106. 

  106. (7,31357,8,NULL,-82370,244919,-3720,0,0),
    107. 

  107. (7,31357,9,NULL,-82129,245020,-3720,0,0),
    108. 

  108. (7,31357,10,NULL,-82198,245350,-3712,0,0),
    109. 

  109. (7,31357,11,NULL,-82554,245137,-3716,1,0),
    110. 

  110. (7,31357,12,NULL,-82198,245350,-3712,0,0),
    111. 

  111. (7,31357,13,NULL,-82129,245020,-3720,0,0),
    112. 

  112. (7,31357,14,NULL,-82370,244919,-3720,0,0),
    113. 

  113. (7,31357,15,NULL,-82952,244461,-3728,0,0),
    114. 

  114. (7,31357,16,'Where has he gone?',-83993,242766,-3728,10,0),
    115. 

  115. (7,31357,17,NULL,-85957,241389,-3728,0,0),
    116. 

  116. (7,31357,18,'Have you seen Windawood?',-86078,240853,-3720,15,0),
    117. 

  117. (7,31357,19,NULL,-86081,240402,-3712,0,0),
    118. 

  118. (7,31357,20,NULL,-86505,240727,-3704,0,0),
    119. 

  119. (8,31356,1,'A delivery for Mr. Lector? Very good!',-81681,243384,-3712,61,1),
    120. 

  120. (8,31356,2,NULL,-81915,243870,-3712,1,1),
    121. 

  121. (8,31356,3,NULL,-82084,243659,-3712,0,1),
    122. 

  122. (8,31356,4,NULL,-83148,243731,-3728,0,1),
    123. 

  123. (8,31356,5,'I need a break!',-84497,243241,-3728,6,1),
    124. 

  124. (8,31356,6,NULL,-85212,243184,-3728,0,1),
    125. 

  125. (8,31356,7,NULL,-86161,242898,-3728,0,1),
    126. 

  126. (8,31356,8,NULL,-86281,242963,-3720,0,1),
    127. 

  127. (8,31356,9,'Hello,Mr. Lector! Long time no see,Mr. Jackson!',-86356,243201,-3720,7,1),
    128. 

  128. (8,31356,10,NULL,-86491,242781,-3720,0,1),
    129. 

  129. (8,31356,11,NULL,-86497,242585,-3728,0,1),
    130. 

  130. (8,31356,12,NULL,-86114,241587,-3728,0,1),
    131. 

  131. (8,31356,13,NULL,-85184,240679,-3728,0,1),
    132. 

  132. (8,31356,14,'Lulu!',-84075,241282,-3728,3,1),
    133. 

  133. (8,31356,15,'Lulu!',-84075,241282,-3728,3,1),
    134. 

  134. (8,31356,16,'Lulu!',-83709,241238,-3728,0,1),
    135. 

  135. (8,31356,17,NULL,-83182,241141,-3728,1,1),
    136. 

  136. (8,31356,18,NULL,-82383,242926,-3720,1,1),
    137. 

  137. (9,31364,1,NULL,-46506,-109402,-238,10,0),
    138. 

  138. (9,31364,2,NULL,-45752,-111652,-240,0,0),
    139. 

  139. (9,31364,3,NULL,-44028,-112688,-240,0,0),
    140. 

  140. (9,31364,4,NULL,-44049,-114536,-240,0,0),
    141. 

  141. (9,31364,5,NULL,-45540,-115415,-240,0,0),
    142. 

  142. (9,31364,6,NULL,-46526,-117731,-240,0,0),
    143. 

  143. (9,31364,7,NULL,-45540,-115415,-240,0,0),
    144. 

  144. (9,31364,8,NULL,-44049,-114536,-240,0,0),
    145. 

  145. (9,31364,9,NULL,-44028,-112688,-240,0,0),
    146. 

  146. (9,31364,10,NULL,-45752,-111652,-240,0,0),
    147. 

  147. (10,31365,1,NULL,-48807,-113489,-241,61,0),
    148. 

  148. (10,31365,2,NULL,-48821,-113746,-232,1,0),
    149. 

  149. (10,31365,3,NULL,-48823,-113505,-232,61,0),
    150. 

  150. (10,31365,4,NULL,-47339,-113581,-232,1,0),
    151. 

  151. (10,31365,5,NULL,-45740,-113562,-240,0,0),
    152. 

  152. (10,31365,6,NULL,-44851,-112965,-240,0,0),
    153. 

  153. (10,31365,7,NULL,-44308,-113207,-240,0,0),
    154. 

  154. (10,31365,8,NULL,-44204,-113743,-240,0,0),
    155. 

  155. (10,31365,9,NULL,-44659,-114171,-240,0,0),
    156. 

  156. (10,31365,10,NULL,-45167,-114034,-224,0,0),
    157. 

  157. (10,31365,11,NULL,-45658,-113633,-240,0,0),
    158. 

  158. (10,31365,12,NULL,-47363,-113621,-224,0,0),
    159. 

  159. (10,31365,13,NULL,-48829,-113746,-232,0,0),
    160. 

  160. (10,31365,14,NULL,-47363,-113621,-224,0,0),
    161. 

  161. (10,31365,15,NULL,-45658,-113633,-240,0,0),
    162. 

  162. (10,31365,16,NULL,-45167,-114034,-224,0,0),
    163. 

  163. (10,31365,17,NULL,-44659,-114171,-240,0,0),
    164. 

  164. (10,31365,18,NULL,-44204,-113743,-240,0,0),
    165. 

  165. (10,31365,19,NULL,-44308,-113207,-240,0,0),
    166. 

  166. (10,31365,20,NULL,-44851,-112965,-240,0,0),
    167. 

  167. (10,31365,21,NULL,-45740,-113562,-240,1,0),
    168. 

  168. (11,32072,1,NULL,84429,-144065,-1542,10,0),
    169. 

  169. (11,32072,2,NULL,84465,-142493,-1536,0,0),
    170. 

  170. (11,32072,3,NULL,85234,-140963,-1536,0,0),
    171. 

  171. (11,32072,4,NULL,87351,-140059,-1536,5,0),
    172. 

  172. (11,32072,5,NULL,89343,-140746,-1536,0,0),
    173. 

  173. (11,32072,6,NULL,90605,-143167,-1536,0,0),
    174. 

  174. (11,32072,7,NULL,90271,-143869,-1536,10,0),
    175. 

  175. (11,32072,8,NULL,90605,-143167,-1536,0,0),
    176. 

  176. (11,32072,9,NULL,89343,-140746,-1536,0,0),
    177. 

  177. (11,32072,10,NULL,87351,-140059,-1536,5,0),
    178. 

  178. (11,32072,11,NULL,85234,-140963,-1536,0,0),
    179. 

  179. (11,32072,12,NULL,84465,-142493,-1536,0,0),
    180. 

  180. (12,32070,1,NULL,90271,-143869,-1547,10,1),
    181. 

  181. (12,32070,2,NULL,90605,-143167,-1536,1,1),
    182. 

  182. (12,32070,3,NULL,89343,-140746,-1536,1,1),
    183. 

  183. (12,32070,4,NULL,87351,-140059,-1536,5,1),
    184. 

  184. (12,32070,5,NULL,85234,-140963,-1536,1,1),
    185. 

  185. (12,32070,6,NULL,84465,-142493,-1536,1,1),
    186. 

  186. (12,32070,7,NULL,84434,-144061,-1528,10,1),
    187. 

  187. (12,32070,8,NULL,84465,-142493,-1536,1,1),
    188. 

  188. (12,32070,9,NULL,85234,-140963,-1536,1,1),
    189. 

  189. (12,32070,10,NULL,87351,-140059,-1536,5,1),
    190. 

  190. (12,32070,11,NULL,89343,-140746,-1536,1,1),
    191. 

  191. (12,32070,12,NULL,90605,-143167,-1536,1,1);
    192. 

  192. 

  193. INSERT INTO `walker_routes` VALUES
    194. 

  194. (13,29095,1,NULL,141569,-45908,-2387,10,0),
    195. 

  195. (13,29095,2,NULL,142494,-45456,-2397,0,0),
    196. 

  196. (13,29095,3,NULL,142922,-44561,-2395,0,0),
    197. 

  197. (13,29095,4,NULL,143672,-44130,-2398,0,0),
    198. 

  198. (13,29095,5,NULL,144557,-43378,-2325,0,0),
    199. 

  199. (13,29095,6,NULL,145839,-43267,-2301,0,0),
    200. 

  200. (13,29095,7,NULL,147044,-43601,-2307,0,0),
    201. 

  201. (13,29095,8,NULL,148140,-43206,-2303,0,0),
    202. 

  202. (13,29095,9,NULL,148815,-43434,-2328,5,0),
    203. 

  203. (13,29095,10,NULL,149862,-44151,-2558,0,0),
    204. 

  204. (13,29095,11,NULL,151037,-44197,-2708,5,0),
    205. 

  205. (13,29095,12,NULL,152555,-42756,-2836,0,0),
    206. 

  206. (13,29095,13,NULL,154808,-39546,-3236,0,0),
    207. 

  207. (13,29095,14,NULL,155333,-39962,-3272,0,0),
    208. 

  208. (13,29095,15,NULL,156531,-41240,-3470,0,0),
    209. 

  209. (13,29095,16,NULL,156863,-43232,-3707,0,0),
    210. 

  210. (13,29095,17,NULL,156783,-44198,-3764,0,0),
    211. 

  211. (13,29095,18,NULL,158169,-45163,-3541,0,0),
    212. 

  212. (13,29095,19,NULL,158952,-45479,-3473,0,0),
    213. 

  213. (13,29095,20,NULL,160039,-46514,-3634,0,0),
    214. 

  214. (13,29095,21,NULL,160244,-47429,-3656,3,0),
    215. 

  215. (13,29095,22,NULL,159155,-48109,-3665,0,0),
    216. 

  216. (13,29095,23,NULL,159558,-51027,-3523,0,0),
    217. 

  217. (13,29095,24,NULL,159396,-53362,-3244,3,0),
    218. 

  218. (13,29095,25,NULL,160872,-56556,-2789,0,0),
    219. 

  219. (13,29095,26,NULL,160857,-59072,-2613,5,0),
    220. 

  220. (13,29095,27,NULL,160410,-59888,-2647,0,0),
    221. 

  221. (13,29095,28,NULL,158770,-60173,-2673,0,0),
    222. 

  222. (13,29095,29,NULL,156368,-59557,-2638,3,0),
    223. 

  223. (13,29095,30,NULL,155188,-59868,-2642,0,0),
    224. 

  224. (13,29095,31,NULL,154118,-60591,-2731,0,0),
    225. 

  225. (13,29095,32,NULL,153571,-61567,-2821,0,0),
    226. 

  226. (13,29095,33,NULL,153457,-62819,-2886,3,0),
    227. 

  227. (13,29095,34,NULL,152939,-63778,-3003,0,0),
    228. 

  228. (13,29095,35,NULL,151816,-64209,-3120,0,0),
    229. 

  229. (13,29095,36,NULL,147655,-64826,-3433,0,0),
    230. 

  230. (13,29095,37,NULL,145422,-64576,-3369,0,0),
    231. 

  231. (13,29095,38,NULL,144097,-64320,-3404,0,0),
    232. 

  232. (13,29095,39,NULL,140780,-61618,-3096,0,0),
    233. 

  233. (13,29095,40,NULL,139688,-61450,-3062,0,0),
    234. 

  234. (13,29095,41,NULL,138267,-61743,-3056,3,0),
    235. 

  235. (13,29095,42,NULL,138613,-58491,-3465,0,0),
    236. 

  236. (13,29095,43,NULL,138139,-57252,-3517,5,0),
    237. 

  237. (13,29095,44,NULL,139555,-56044,-3310,0,0),
    238. 

  238. (13,29095,45,NULL,139107,-54537,-3240,0,0),
    239. 

  239. (13,29095,46,NULL,139279,-53781,-3091,0,0),
    240. 

  240. (13,29095,47,NULL,139810,-52687,-2866,0,0),
    241. 

  241. (13,29095,48,NULL,139657,-52041,-2793,0,0),
    242. 

  242. (13,29095,49,NULL,139215,-51355,-2698,0,0),
    243. 

  243. (13,29095,50,NULL,139334,-50514,-2594,0,0),
    244. 

  244. (13,29095,51,NULL,139817,-49715,-2449,0,0),
    245. 

  245. (13,29095,52,NULL,139824,-48976,-2263,0,0),
    246. 

  246. (13,29095,53,NULL,140130,-47578,-2213,0,0),
    247. 

  247. (13,29095,54,NULL,140483,-46339,-2382,5,0),
    248. 

  248. (13,29095,55,NULL,141569,-45908,-2387,0,0);
    249.