Inicio Explorar Axuda
Rexistro Iniciar sesión
L2j
/
l2j-server-datapack
2
0
Fork 0
Ficheiros Incidencias 0 Pull Requests 0 Wiki
Árbore: 761eda4614
Ramas Etiquetas
l2j-server-data...
/
datapack_development
/
sql
/
char_templates.sql

char_templates.sql 13 KB
Histórico Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108 
  1. --
    2. 

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

  3. --
    4. 

  4. DROP TABLE IF EXISTS char_templates;
    5. 

  5. CREATE TABLE `char_templates` (
    6. 

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

  7.   `ClassName` varchar(20) NOT NULL default '',
    8. 

  8.   `RaceId` int(1) NOT NULL default '0',
    9. 

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

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

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

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

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

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

  15.   `P_ATK` int(3) NOT NULL default '0',
    16. 

  16.   `P_DEF` int(3) NOT NULL default '0',
    17. 

  17.   `M_ATK` int(3) NOT NULL default '0',
    18. 

  18.   `M_DEF` int(2) NOT NULL default '0',
    19. 

  19.   `P_SPD` int(3) NOT NULL default '0',
    20. 

  20.   `M_SPD` int(3) NOT NULL default '0',
    21. 

  21.   `ACC` int(3) NOT NULL default '0',
    22. 

  22.   `CRITICAL` int(3) NOT NULL default '0',
    23. 

  23.   `EVASION` int(3) NOT NULL default '0',
    24. 

  24.   `MOVE_SPD` int(3) NOT NULL default '0',
    25. 

  25.   `_LOAD` int(11) NOT NULL default '0',
    26. 

  26.   `x` int(9) NOT NULL default '0',
    27. 

  27.   `y` int(9) NOT NULL default '0',
    28. 

  28.   `z` int(9) NOT NULL default '0',
    29. 

  29.   `canCraft` int(1) NOT NULL default '0',
    30. 

  30.   `M_UNK1` decimal(4,2) NOT NULL default '0.00',
    31. 

  31.   `M_UNK2` decimal(8,6) NOT NULL default '0.000000',
    32. 

  32.   `M_COL_R` decimal(3,1) NOT NULL default '0.0',
    33. 

  33.   `M_COL_H` decimal(4,1) NOT NULL default '0.0',
    34. 

  34.   `F_UNK1` decimal(4,2) NOT NULL default '0.00',
    35. 

  35.   `F_UNK2` decimal(8,6) NOT NULL default '0.000000',
    36. 

  36.   `F_COL_R` decimal(3,1) NOT NULL default '0.0',
    37. 

  37.   `F_COL_H` decimal(4,1) NOT NULL default '0.0',
    38. 

  38.   `items1` int(4) NOT NULL default '0',
    39. 

  39.   `items2` int(4) NOT NULL default '0',
    40. 

  40.   `items3` int(4) NOT NULL default '0',
    41. 

  41.   `items4` int(4) NOT NULL default '0',
    42. 

  42.   `items5` int(10) NOT NULL default '0',
    43. 

  43.   PRIMARY KEY  (`ClassId`)
    44. 

  44. );
    45. 

  45. 

  46. --
    47. 

  47. -- Dumping data for table `char_templates`
    48. 

  48. --
    49. 

  49. 

  50. INSERT INTO char_templates VALUES (0,'Human Fighter',0,40,43,30,21,11,25,4,72,3,47,330,213,33,44,33,115,81900,-71338,258271,-3104,0,1.10,1.188000,9.0,23.0,1.10,1.188000,8.0,23.5,1147,1146,10,2369,5588);
    51. 

  51. INSERT INTO char_templates VALUES (1,'Warrior',0,40,43,30,21,11,25,4,72,3,47,330,213,33,44,33,115,81900,-71338,258271,-3104,0,1.10,1.188000,9.0,23.0,1.10,1.188000,8.0,23.5,1147,1146,10,2369,5588);
    52. 

  52. INSERT INTO char_templates VALUES (2,'Gladiator',0,40,43,30,21,11,25,4,72,3,47,330,213,33,44,33,115,81900,-71338,258271,-3104,0,1.10,1.188000,9.0,23.0,1.10,1.188000,8.0,23.5,1147,1146,10,2369,5588);
    53. 

  53. INSERT INTO char_templates VALUES (3,'Warlord',0,40,43,30,21,11,25,4,72,3,47,330,213,33,44,33,115,81900,-71338,258271,-3104,0,1.10,1.188000,9.0,23.0,1.10,1.188000,8.0,23.5,1147,1146,10,2369,5588);
    54. 

  54. INSERT INTO char_templates VALUES (4,'Human Knight',0,40,43,30,21,11,25,4,72,3,47,330,213,33,44,33,115,81900,-71338,258271,-3104,0,1.10,1.188000,9.0,23.0,1.10,1.188000,8.0,23.5,1147,1146,10,2369,5588);
    55. 

  55. INSERT INTO char_templates VALUES (5,'Paladin',0,40,43,30,21,11,25,4,72,3,47,330,213,33,44,33,115,81900,-71338,258271,-3104,0,1.10,1.188000,9.0,23.0,1.10,1.188000,8.0,23.5,1147,1146,10,2369,5588);
    56. 

  56. INSERT INTO char_templates VALUES (6,'Dark Avenger',0,40,43,30,21,11,25,4,72,3,47,330,213,33,44,33,115,81900,-71338,258271,-3104,0,1.10,1.188000,9.0,23.0,1.10,1.188000,8.0,23.5,1147,1146,10,2369,5588);
    57. 

  57. INSERT INTO char_templates VALUES (7,'Rogue',0,40,43,30,21,11,25,4,72,3,47,330,213,33,44,33,115,81900,-71338,258271,-3104,0,1.10,1.188000,9.0,23.0,1.10,1.188000,8.0,23.5,1147,1146,10,2369,5588);
    58. 

  58. INSERT INTO char_templates VALUES (8,'Treasure Hunter',0,40,43,30,21,11,25,4,72,3,47,330,213,33,44,33,115,81900,-71338,258271,-3104,0,1.10,1.188000,9.0,23.0,1.10,1.188000,8.0,23.5,1147,1146,10,2369,5588);
    59. 

  59. INSERT INTO char_templates VALUES (9,'Hawkeye',0,40,43,30,21,11,25,4,72,3,47,330,213,33,44,33,115,81900,-71338,258271,-3104,0,1.10,1.188000,9.0,23.0,1.10,1.188000,8.0,23.5,1147,1146,10,2369,5588);
    60. 

  60. INSERT INTO char_templates VALUES (10,'Human Mage',0,22,27,21,41,20,39,2,48,7,54,303,333,28,40,28,120,62500,-90890,248027,-3570,0,1.01,0.872640,7.5,22.8,1.01,0.872640,6.5,22.5,425,461,6,5588,0);
    61. 

  61. INSERT INTO char_templates VALUES (11,'Human Wizard',0,22,27,21,41,20,39,2,48,7,54,303,333,28,40,28,120,62500,-90890,248027,-3570,0,1.01,0.872640,7.5,22.8,1.01,0.872640,6.5,22.5,425,461,6,5588,0);
    62. 

  62. INSERT INTO char_templates VALUES (12,'Sorcerer',0,22,27,21,41,20,39,2,48,7,54,303,333,28,40,28,120,62500,-90890,248027,-3570,0,1.01,0.872640,7.5,22.8,1.01,0.872640,6.5,22.5,425,461,6,5588,0);
    63. 

  63. INSERT INTO char_templates VALUES (13,'Necromancer',0,22,27,21,41,20,39,2,48,7,54,303,333,28,40,28,120,62500,-90890,248027,-3570,0,1.01,0.872640,7.5,22.8,1.01,0.872640,6.5,22.5,425,461,6,5588,0);
    64. 

  64. INSERT INTO char_templates VALUES (14,'Warlock',0,22,27,21,41,20,39,2,48,7,54,303,333,28,40,28,120,62500,-90890,248027,-3570,0,1.01,0.872640,7.5,22.8,1.01,0.872640,6.5,22.5,425,461,6,5588,0);
    65. 

  65. INSERT INTO char_templates VALUES (15,'Cleric',0,22,27,21,41,20,39,2,48,7,54,303,333,28,40,28,120,62500,-90890,248027,-3570,0,1.01,0.872640,7.5,22.8,1.01,0.872640,6.5,22.5,425,461,6,5588,0);
    66. 

  66. INSERT INTO char_templates VALUES (16,'Bishop',0,22,27,21,41,20,39,2,48,7,54,303,333,28,40,28,120,62500,-90890,248027,-3570,0,1.01,0.872640,7.5,22.8,1.01,0.872640,6.5,22.5,425,461,6,5588,0);
    67. 

  67. INSERT INTO char_templates VALUES (17,'Human Prophet',0,22,27,21,41,20,39,2,48,7,54,303,333,28,40,28,120,62500,-90890,248027,-3570,0,1.01,0.872640,7.5,22.8,1.01,0.872640,6.5,22.5,425,461,6,5588,0);
    68. 

  68. INSERT INTO char_templates VALUES (18,'Elf Fighter',1,36,36,35,23,14,26,4,72,3,47,345,249,36,46,36,125,73000,45978,41196,-3440,0,1.15,1.242000,7.5,24.0,1.15,1.242000,7.5,23.0,1147,1146,10,2369,5588);
    69. 

  69. INSERT INTO char_templates VALUES (19,'Elf Knight',1,36,36,35,23,14,26,4,72,3,47,345,249,36,46,36,125,73000,45978,41196,-3440,0,1.15,1.242000,7.5,24.0,1.15,1.242000,7.5,23.0,1147,1146,10,2369,5588);
    70. 

  70. INSERT INTO char_templates VALUES (20,'Temple Knight',1,36,36,35,23,14,26,4,72,3,47,345,249,36,46,36,125,73000,45978,41196,-3440,0,1.15,1.242000,7.5,24.0,1.15,1.242000,7.5,23.0,1147,1146,10,2369,5588);
    71. 

  71. INSERT INTO char_templates VALUES (21,'Swordsinger',1,36,36,35,23,14,26,4,72,3,47,345,249,36,46,36,125,73000,45978,41196,-3440,0,1.15,1.242000,7.5,24.0,1.15,1.242000,7.5,23.0,1147,1146,10,2369,5588);
    72. 

  72. INSERT INTO char_templates VALUES (22,'Scout',1,36,36,35,23,14,26,4,72,3,47,345,249,36,46,36,125,73000,45978,41196,-3440,0,1.15,1.242000,7.5,24.0,1.15,1.242000,7.5,23.0,1147,1146,10,2369,5588);
    73. 

  73. INSERT INTO char_templates VALUES (23,'Plains Walker',1,36,36,35,23,14,26,4,72,3,47,345,249,36,46,36,125,73000,45978,41196,-3440,0,1.15,1.242000,7.5,24.0,1.15,1.242000,7.5,23.0,1147,1146,10,2369,5588);
    74. 

  74. INSERT INTO char_templates VALUES (24,'Silver Ranger',1,36,36,35,23,14,26,4,72,3,47,345,249,36,46,36,125,73000,45978,41196,-3440,0,1.15,1.242000,7.5,24.0,1.15,1.242000,7.5,23.0,1147,1146,10,2369,5588);
    75. 

  75. INSERT INTO char_templates VALUES (25,'Elf Mage',1,21,25,24,37,23,40,2,48,6,54,312,386,30,41,30,122,62400,46182,41198,-3440,0,1.04,0.898560,7.5,24.0,1.04,0.898560,7.5,23.0,425,461,6,5588,0);
    76. 

  76. INSERT INTO char_templates VALUES (26,'Elf Wizard',1,21,25,24,37,23,40,2,48,6,54,312,386,30,41,30,122,62400,46182,41198,-3440,0,1.04,0.898560,7.5,24.0,1.04,0.898560,7.5,23.0,425,461,6,5588,0);
    77. 

  77. INSERT INTO char_templates VALUES (27,'Spellsinger',1,21,25,24,37,23,40,2,48,6,54,312,386,30,41,30,122,62400,46182,41198,-3440,0,1.04,0.898560,7.5,24.0,1.04,0.898560,7.5,23.0,425,461,6,5588,0);
    78. 

  78. INSERT INTO char_templates VALUES (28,'Elemental Summoner',1,21,25,24,37,23,40,2,48,6,54,312,386,30,41,30,122,62400,46182,41198,-3440,0,1.04,0.898560,7.5,24.0,1.04,0.898560,7.5,23.0,425,461,6,5588,0);
    79. 

  79. INSERT INTO char_templates VALUES (29,'Oracle',1,21,25,24,37,23,40,2,48,6,54,312,386,30,41,30,122,62400,46182,41198,-3440,0,1.04,0.898560,7.5,24.0,1.04,0.898560,7.5,23.0,425,461,6,5588,0);
    80. 

  80. INSERT INTO char_templates VALUES (30,'Elder',1,21,25,24,37,23,40,2,48,6,54,312,386,30,41,30,122,62400,46182,41198,-3440,0,1.04,0.898560,7.5,24.0,1.04,0.898560,7.5,23.0,425,461,6,5588,0);
    81. 

  81. INSERT INTO char_templates VALUES (31,'DE Fighter',2,41,32,34,25,12,26,4,72,3,47,342,226,35,45,35,122,69000,28377,10916,-4224,0,1.14,1.231200,7.5,24.0,1.14,1.231200,7.0,23.5,1147,1146,10,2369,5588);
    82. 

  82. INSERT INTO char_templates VALUES (32,'Palus Knight',2,41,32,34,25,12,26,4,72,3,47,342,226,35,45,35,122,69000,28377,10916,-4224,0,1.14,1.231200,7.5,24.0,1.14,1.231200,7.0,23.5,1147,1146,10,2369,5588);
    83. 

  83. INSERT INTO char_templates VALUES (33,'Shillien Knight',2,41,32,34,25,12,26,4,72,3,47,342,226,35,45,35,122,69000,28377,10916,-4224,0,1.14,1.231200,7.5,24.0,1.14,1.231200,7.0,23.5,1147,1146,10,2369,5588);
    84. 

  84. INSERT INTO char_templates VALUES (34,'Bladedancer',2,41,32,34,25,12,26,4,72,3,47,342,226,35,45,35,122,69000,28377,10916,-4224,0,1.14,1.231200,7.5,24.0,1.14,1.231200,7.0,23.5,1147,1146,10,2369,5588);
    85. 

  85. INSERT INTO char_templates VALUES (35,'Assassin',2,41,32,34,25,12,26,4,72,3,47,342,226,35,45,35,122,69000,28377,10916,-4224,0,1.14,1.231200,7.5,24.0,1.14,1.231200,7.0,23.5,1147,1146,10,2369,5588);
    86. 

  86. INSERT INTO char_templates VALUES (36,'Abyss Walker',2,41,32,34,25,12,26,4,72,3,47,342,226,35,45,35,122,69000,28377,10916,-4224,0,1.14,1.231200,7.5,24.0,1.14,1.231200,7.0,23.5,1147,1146,10,2369,5588);
    87. 

  87. INSERT INTO char_templates VALUES (37,'Phantom Range',2,41,32,34,25,12,26,4,72,3,47,342,226,35,45,35,122,69000,28377,10916,-4224,0,1.14,1.231200,7.5,24.0,1.14,1.231200,7.0,23.5,1147,1146,10,2369,5588);
    88. 

  88. INSERT INTO char_templates VALUES (38,'DE Mage',2,23,24,23,44,19,37,2,48,7,53,309,316,29,41,29,122,61000,28295,11063,-4224,0,1.14,1.231200,7.5,24.0,1.03,0.889920,7.0,23.5,425,461,6,5588,0);
    89. 

  89. INSERT INTO char_templates VALUES (39,'DE Wizard',2,23,24,23,44,19,37,2,48,7,53,309,316,29,41,29,122,61000,28295,11063,-4224,0,1.14,1.231200,7.5,24.0,1.03,0.889920,7.0,23.5,425,461,6,5588,0);
    90. 

  90. INSERT INTO char_templates VALUES (40,'Spell Howler',2,23,24,23,44,19,37,2,48,7,53,309,316,29,41,29,122,61000,28295,11063,-4224,0,1.14,1.231200,7.5,24.0,1.03,0.889920,7.0,23.5,425,461,6,5588,0);
    91. 

  91. INSERT INTO char_templates VALUES (41,'Phantom Summoner',2,23,24,23,44,19,37,2,48,7,53,309,316,29,41,29,122,61000,28295,11063,-4224,0,1.14,1.231200,7.5,24.0,1.03,0.889920,7.0,23.5,425,461,6,5588,0);
    92. 

  92. INSERT INTO char_templates VALUES (42,'Shillien Oracle',2,23,24,23,44,19,37,2,48,7,53,309,316,29,41,29,122,61000,28295,11063,-4224,0,1.14,1.231200,7.5,24.0,1.03,0.889920,7.0,23.5,425,461,6,5588,0);
    93. 

  93. INSERT INTO char_templates VALUES (43,'Shillien Elder',2,23,24,23,44,19,37,2,48,7,53,309,316,29,41,29,122,61000,28295,11063,-4224,0,1.14,1.231200,7.5,24.0,1.03,0.889920,7.0,23.5,425,461,6,5588,0);
    94. 

  94. INSERT INTO char_templates VALUES (44,'Orc Fighter',3,40,47,26,18,12,27,4,72,2,48,318,226,31,42,31,117,87000,-56693,-113610,-690,0,1.06,1.144800,11.0,28.0,1.06,1.144800,7.0,27.0,1147,1146,2368,2369,5588);
    95. 

  95. INSERT INTO char_templates VALUES (45,'Raider',3,40,47,26,18,12,27,4,72,2,48,318,226,31,42,31,117,87000,-56693,-113610,-690,0,1.06,1.144800,11.0,28.0,1.06,1.144800,7.0,27.0,1147,1146,2368,2369,5588);
    96. 

  96. INSERT INTO char_templates VALUES (46,'Destroyer',3,40,47,26,18,12,27,4,72,2,48,318,226,31,42,31,117,87000,-56693,-113610,-690,0,1.06,1.144800,11.0,28.0,1.06,1.144800,7.0,27.0,1147,1146,2368,2369,5588);
    97. 

  97. INSERT INTO char_templates VALUES (47,'Monk',3,40,47,26,18,12,27,4,72,2,48,318,226,31,42,31,117,87000,-56682,-56693,-113610,0,1.06,1.144800,11.0,28.0,1.06,1.144800,7.0,27.0,1147,1146,2368,2369,5588);
    98. 

  98. INSERT INTO char_templates VALUES (48,'Tyrant',3,40,47,26,18,12,27,4,72,2,48,318,226,31,42,31,117,87000,-56693,-113610,-690,0,1.06,1.144800,11.0,28.0,1.06,1.144800,7.0,27.0,1147,1146,2368,2369,5588);
    99. 

  99. INSERT INTO char_templates VALUES (49,'Orc Mage',3,27,31,24,31,15,42,2,48,4,56,312,265,30,41,30,121,68000,-56682,-113730,-690,0,1.04,0.898560,7.0,27.5,1.04,0.898560,8.0,25.5,425,461,2368,5588,0);
    100. 

  100. INSERT INTO char_templates VALUES (50,'Shaman',3,27,31,24,31,15,42,2,48,4,56,312,265,30,41,30,121,68000,-56682,-113730,-690,0,1.04,0.898560,7.0,27.5,1.04,0.898560,8.0,25.5,425,461,2368,5588,0);
    101. 

  101. INSERT INTO char_templates VALUES (51,'Overlord',3,27,31,24,31,15,42,2,48,4,56,312,265,30,41,30,121,68000,-56682,-113730,-690,0,1.04,0.898560,7.0,27.5,1.04,0.898560,8.0,25.5,425,461,2368,5588,0);
    102. 

  102. INSERT INTO char_templates VALUES (52,'Warcryer',3,27,31,24,31,15,42,2,48,4,56,312,265,30,41,30,121,68000,-56682,-113730,-690,0,1.04,0.898560,7.0,27.5,1.04,0.898560,8.0,25.5,425,461,2368,5588,0);
    103. 

  103. INSERT INTO char_templates VALUES (53,'Dwarf Fighter',4,39,45,29,20,10,27,4,72,3,48,327,203,33,43,33,115,83000,108512,-174026,-400,1,1.09,1.487196,9.0,18.0,1.09,1.487196,5.0,19.0,1147,1146,10,2370,5588);
    104. 

  104. INSERT INTO char_templates VALUES (54,'Scavenger',4,39,45,29,20,10,27,4,72,3,48,327,203,33,43,33,115,83000,108512,-174026,-400,1,1.09,1.487196,9.0,18.0,1.09,1.487196,5.0,19.0,1147,1146,10,2370,5588);
    105. 

  105. INSERT INTO char_templates VALUES (55,'Bounty Hunter',4,39,45,29,20,10,27,4,72,3,48,327,203,33,43,33,115,83000,108512,-174026,-400,1,1.09,1.487196,9.0,18.0,1.09,1.487196,5.0,19.0,1147,1146,10,2370,5588);
    106. 

  106. INSERT INTO char_templates VALUES (56,'Artisan',4,39,45,29,20,10,27,4,72,3,48,327,203,33,43,33,115,83000,108512,-174026,-400,1,1.09,1.487196,9.0,18.0,1.09,1.487196,5.0,19.0,1147,1146,10,2370,5588);
    107. 

  107. INSERT INTO char_templates VALUES (57,'Warsmith',4,39,45,29,20,10,27,4,72,3,48,327,203,33,43,33,115,83000,108512,-174026,-400,1,1.09,1.487196,9.0,18.0,1.09,1.487196,5.0,19.0,1147,1146,10,2370,5588);
    108. 

  108.