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
/
mapregion.sql

mapregion.sql 2.1 KB
Permalink History Raw

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768 
  1. --
    2. 

  2. -- Table structure for table `mapregion`
    3. 

  3. -- 
    4. 

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

  5. CREATE TABLE `mapregion` (
    6. 

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

  7. `sec0` int(2) NOT NULL default '0',
    8. 

  8. `sec1` int(2) NOT NULL default '0',
    9. 

  9. `sec2` int(2) NOT NULL default '0',
    10. 

  10. `sec3` int(2) NOT NULL default '0',
    11. 

  11. `sec4` int(2) NOT NULL default '0',
    12. 

  12. `sec5` int(2) NOT NULL default '0',
    13. 

  13. `sec6` int(2) NOT NULL default '0',
    14. 

  14. `sec7` int(2) NOT NULL default '0',
    15. 

  15. `sec8` int(2) NOT NULL default '0',
    16. 

  16. `sec9` int(2) NOT NULL default '0',
    17. 

  17. `sec10` int(2) NOT NULL default '0',
    18. 

  18. PRIMARY KEY (`region`)
    19. 

  19. );
    20. 

  20. 

  21. --
    22. 

  22. -- Dumping data for table `mapregion`
    23. 

  23. -- 
    24. 

  24. 

  25. -- 0 = "Talking Island Village"
    26. 

  26. -- 1 = "Elven Village"
    27. 

  27. -- 2 = "Dark Elven Village"
    28. 

  28. -- 3 = "Orc Village"
    29. 

  29. -- 4 = "Dwarven Village"
    30. 

  30. -- 5 = "Town of Gludio"
    31. 

  31. -- 6 = "Gludin Village"
    32. 

  32. -- 7 = "Town of Dion"
    33. 

  33. -- 8 = "Town of Giran"
    34. 

  34. -- 9 = "Town of Oren"
    35. 

  35. -- 10 = "Town of Aden"
    36. 

  36. -- 11 = "Hunters Village"
    37. 

  37. -- 12 = "Giran Harbor"
    38. 

  38. -- 13 = "Heine"
    39. 

  39. -- 14 = "Rune Township"
    40. 

  40. -- 15 = "Town of Goddard"
    41. 

  41. -- 16 = "Town of Shuttgart"
    42. 

  42. -- 17 = "Floran Village"
    43. 

  43. -- 18 = "Primeval Isle"
    44. 

  44. -- 19 = "Kamael Village"
    45. 

  45. -- 20 = "South of Wastelands Camp"
    46. 

  46. -- 21 = "Fantasy Island"
    47. 

  47. -- default = "Town of Aden"
    48. 

  48. 

  49. INSERT INTO mapregion VALUES 
    50. 

  50. --	16	17	18	19	20	21	22	23	24	25	26
    51. 

  51. (0,	3,	3,	3,	3,	3,	4,	4,	4,	4,	4,	4),	-- _8
    52. 

  52. (1,	3,	3,	3,	3,	3,	4,	4,	4,	4,	4,	4),	-- _9
    53. 

  53. (2,	3,	3,	7,	9,	11,	4,	4,	4,	4,	4,	4),	-- _10
    54. 

  54. (3,	3,	3,	3,	3,	3,	4,	4,	4,	4,	4,	4),	-- _11
    55. 

  55. (4,	3,	3,	3,	3,	3,	4,	4,	4,	4,	4,	4),	-- _12
    56. 

  56. (5,	3,	3,	3,	3,	3,	16,	16,	16,	15,	15,	15),	-- _13
    57. 

  57. (6,	3,	3,	3,	3,	3,	16,	16,	16,	15,	15,	15),	-- _14
    58. 

  58. (7,	3,	21,	21,	3,	3,	14,	14,	15,	15,	15,	15),	-- _15
    59. 

  59. (8,	3,	21,	21,	14,	14,	14,	14,	15,	15,	15,	15),	-- _16
    60. 

  60. (9,	2,	2,	2,	2,	18,	14,	9,	9,	10,	10,	10),	-- _17
    61. 

  61. (10,	19,	2,	2,	2,	2,	9,	9,	10,	10,	10,	10),	-- _18
    62. 

  62. (11,	19,	19,	2,	2,	1,	1,	9,	11,	10	,10,	10),	-- _19
    63. 

  63. (12,	19,	6,	2,	5,	1,	1,	9,	11,	11,	11,	11),	-- _20
    64. 

  64. (13,	6,	6,	5,	5,	7,	7,	8,	8,	8,	8,	8),	-- _21
    65. 

  65. (14,	6,	6,	6,	5,	7,	7,	8,	8,	8,	8,	8),	-- _22
    66. 

  66. (15,	0,	6,	6,	5,	17,	12,	13,	13,	13,	13,	13),	-- _23
    67. 

  67. (16,	0,	0,	6,	6,	12,	12,	13,	13,	13,	13,	13),	-- _24
    68. 

  68. (17,	0,	0,	0,	0,	0,	0,	13,	13,	13,	13,	13);	-- _25
    69.