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

char_templates.sql 29 KB
History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139 
  1. -- 
    2. 

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

  3. -- 
    4. 

  4. 

  5. DROP TABLE IF EXISTS `char_templates`;
    6. 

  6. CREATE TABLE `char_templates` (
    7. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  44.   PRIMARY KEY  (`ClassId`)
    45. 

  45. ) TYPE=MyISAM;
    46. 

  46. 

  47. -- 
    48. 

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

  49. -- 
    50. 

  50. 

  51. INSERT INTO `char_templates` VALUES ('0', 'Human Fighter', '0', '40', '43', '30', '21', '11', '25', '4', '80', '6', '41', '300', '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 ('1', 'Warrior', '0', '40', '43', '30', '21', '11', '25', '4', '80', '6', '41', '300', '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 ('2', 'Gladiator', '0', '40', '43', '30', '21', '11', '25', '4', '80', '6', '41', '300', '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 ('3', 'Warlord', '0', '40', '43', '30', '21', '11', '25', '4', '80', '6', '41', '300', '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 ('4', 'Human Knight', '0', '40', '43', '30', '21', '11', '25', '4', '80', '6', '41', '300', '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 ('5', 'Paladin', '0', '40', '43', '30', '21', '11', '25', '4', '80', '6', '41', '300', '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 ('6', 'Dark Avenger', '0', '40', '43', '30', '21', '11', '25', '4', '80', '6', '41', '300', '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 ('7', 'Rogue', '0', '40', '43', '30', '21', '11', '25', '4', '80', '6', '41', '300', '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 ('8', 'Treasure Hunter', '0', '40', '43', '30', '21', '11', '25', '4', '80', '6', '41', '300', '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 ('9', 'Hawkeye', '0', '40', '43', '30', '21', '11', '25', '4', '80', '6', '41', '300', '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');
    61. 

  61. INSERT INTO `char_templates` VALUES ('10', 'Human Mage', '0', '22', '27', '21', '41', '20', '39', '3', '56', '6', '41', '300', '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 ('11', 'Human Wizard', '0', '22', '27', '21', '41', '20', '39', '3', '56', '6', '41', '300', '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 ('12', 'Sorcerer', '0', '22', '27', '21', '41', '20', '39', '3', '56', '6', '41', '300', '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 ('13', 'Necromancer', '0', '22', '27', '21', '41', '20', '39', '3', '56', '6', '41', '300', '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 ('14', 'Warlock', '0', '22', '27', '21', '41', '20', '39', '3', '56', '6', '41', '300', '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 ('15', 'Cleric', '0', '22', '27', '21', '41', '20', '39', '3', '56', '6', '41', '300', '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 ('16', 'Bishop', '0', '22', '27', '21', '41', '20', '39', '3', '56', '6', '41', '300', '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 ('17', 'Human Prophet', '0', '22', '27', '21', '41', '20', '39', '3', '56', '6', '41', '300', '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');
    69. 

  69. INSERT INTO `char_templates` VALUES ('18', 'Elf Fighter', '1', '36', '36', '35', '23', '14', '26', '4', '80', '6', '41', '300', '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 ('19', 'Elf Knight', '1', '36', '36', '35', '23', '14', '26', '4', '80', '6', '41', '300', '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 ('20', 'Temple Knight', '1', '36', '36', '35', '23', '14', '26', '4', '80', '6', '41', '300', '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 ('21', 'Swordsinger', '1', '36', '36', '35', '23', '14', '26', '4', '80', '6', '41', '300', '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 ('22', 'Scout', '1', '36', '36', '35', '23', '14', '26', '4', '80', '6', '41', '300', '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 ('23', 'Plains Walker', '1', '36', '36', '35', '23', '14', '26', '4', '80', '6', '41', '300', '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 ('24', 'Silver Ranger', '1', '36', '36', '35', '23', '14', '26', '4', '80', '6', '41', '300', '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');
    76. 

  76. INSERT INTO `char_templates` VALUES ('25', 'Elf Mage', '1', '21', '25', '24', '37', '23', '40', '3', '56', '6', '41', '300', '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 ('26', 'Elf Wizard', '1', '21', '25', '24', '37', '23', '40', '3', '56', '6', '41', '300', '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 ('27', 'Spellsinger', '1', '21', '25', '24', '37', '23', '40', '3', '56', '6', '41', '300', '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 ('28', 'Elemental Summoner', '1', '21', '25', '24', '37', '23', '40', '3', '56', '6', '41', '300', '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 ('29', 'Oracle', '1', '21', '25', '24', '37', '23', '40', '3', '56', '6', '41', '300', '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 ('30', 'Elder', '1', '21', '25', '24', '37', '23', '40', '3', '56', '6', '41', '300', '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');
    82. 

  82. INSERT INTO `char_templates` VALUES ('31', 'DE Fighter', '2', '41', '32', '34', '25', '12', '26', '4', '80', '6', '41', '300', '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 ('32', 'Palus Knight', '2', '41', '32', '34', '25', '12', '26', '4', '80', '6', '41', '300', '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 ('33', 'Shillien Knight', '2', '41', '32', '34', '25', '12', '26', '4', '80', '6', '41', '300', '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 ('34', 'Bladedancer', '2', '41', '32', '34', '25', '12', '26', '4', '80', '6', '41', '300', '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 ('35', 'Assassin', '2', '41', '32', '34', '25', '12', '26', '4', '80', '6', '41', '300', '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 ('36', 'Abyss Walker', '2', '41', '32', '34', '25', '12', '26', '4', '80', '6', '41', '300', '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 ('37', 'Phantom Ranger', '2', '41', '32', '34', '25', '12', '26', '4', '80', '6', '41', '300', '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');
    89. 

  89. INSERT INTO `char_templates` VALUES ('38', 'DE Mage', '2', '23', '24', '23', '44', '19', '37', '3', '56', '6', '41', '300', '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 ('39', 'DE Wizard', '2', '23', '24', '23', '44', '19', '37', '3', '56', '6', '41', '300', '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 ('40', 'Spell Howler', '2', '23', '24', '23', '44', '19', '37', '3', '56', '6', '41', '300', '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 ('41', 'Phantom Summoner', '2', '23', '24', '23', '44', '19', '37', '3', '56', '6', '41', '300', '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 ('42', 'Shillien Oracle', '2', '23', '24', '23', '44', '19', '37', '3', '56', '6', '41', '300', '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 ('43', 'Shillien Elder', '2', '23', '24', '23', '44', '19', '37', '3', '56', '6', '41', '300', '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');
    95. 

  95. INSERT INTO `char_templates` VALUES ('44', 'Orc Fighter', '3', '40', '47', '26', '18', '12', '27', '4', '80', '6', '41', '300', '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 ('45', 'Raider', '3', '40', '47', '26', '18', '12', '27', '4', '80', '6', '41', '300', '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 ('46', 'Destroyer', '3', '40', '47', '26', '18', '12', '27', '4', '80', '6', '41', '300', '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');
    98. 

  98. INSERT INTO `char_templates` VALUES ('47', 'Monk', '3', '40', '47', '26', '18', '12', '27', '4', '80', '6', '41', '300', '226', '31', '42', '31', '117', '87000', '-56682', '-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 ('48', 'Tyrant', '3', '40', '47', '26', '18', '12', '27', '4', '80', '6', '41', '300', '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');
    100. 

  100. INSERT INTO `char_templates` VALUES ('49', 'Orc Mage', '3', '27', '31', '24', '31', '15', '42', '3', '56', '6', '41', '300', '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 ('50', 'Shaman', '3', '27', '31', '24', '31', '15', '42', '3', '56', '6', '41', '300', '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 ('51', 'Overlord', '3', '27', '31', '24', '31', '15', '42', '3', '56', '6', '41', '300', '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 ('52', 'Warcryer', '3', '27', '31', '24', '31', '15', '42', '3', '56', '6', '41', '300', '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');
    104. 

  104. INSERT INTO `char_templates` VALUES ('53', 'Dwarf Fighter', '4', '39', '45', '29', '20', '10', '27', '4', '80', '6', '41', '300', '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 ('54', 'Scavenger', '4', '39', '45', '29', '20', '10', '27', '4', '80', '6', '41', '300', '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 ('55', 'Bounty Hunter', '4', '39', '45', '29', '20', '10', '27', '4', '80', '6', '41', '300', '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 ('56', 'Artisan', '4', '39', '45', '29', '20', '10', '27', '4', '80', '6', '41', '300', '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. INSERT INTO `char_templates` VALUES ('57', 'Warsmith', '4', '39', '45', '29', '20', '10', '27', '4', '80', '6', '41', '300', '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');
    109. 

  109. INSERT INTO `char_templates` VALUES ('88', 'Duelist', '0', '40', '43', '30', '21', '11', '25', '4', '80', '6', '41', '300', '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');
    110. 

  110. INSERT INTO `char_templates` VALUES ('89', 'DreadNought', '0', '40', '43', '30', '21', '11', '25', '4', '80', '6', '41', '300', '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');
    111. 

  111. INSERT INTO `char_templates` VALUES ('90', 'Phoenix Knight', '0', '40', '43', '30', '21', '11', '25', '4', '80', '6', '41', '300', '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');
    112. 

  112. INSERT INTO `char_templates` VALUES ('91', 'Hell Knight', '0', '40', '43', '30', '21', '11', '25', '4', '80', '6', '41', '300', '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');
    113. 

  113. INSERT INTO `char_templates` VALUES ('92', 'Sagittarius', '0', '40', '43', '30', '21', '11', '25', '4', '80', '6', '41', '300', '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');
    114. 

  114. INSERT INTO `char_templates` VALUES ('93', 'Adventurer', '0', '40', '43', '30', '21', '11', '25', '4', '80', '6', '41', '300', '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');
    115. 

  115. INSERT INTO `char_templates` VALUES ('94', 'Archmage', '0', '22', '27', '21', '41', '20', '39', '3', '56', '6', '41', '300', '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');
    116. 

  116. INSERT INTO `char_templates` VALUES ('95', 'Soultaker', '0', '22', '27', '21', '41', '20', '39', '3', '56', '6', '41', '300', '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');
    117. 

  117. INSERT INTO `char_templates` VALUES ('96', 'Arcana Lord', '0', '22', '27', '21', '41', '20', '39', '3', '56', '6', '41', '300', '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');
    118. 

  118. INSERT INTO `char_templates` VALUES ('97', 'Cardinal', '0', '22', '27', '21', '41', '20', '39', '3', '56', '6', '41', '300', '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');
    119. 

  119. INSERT INTO `char_templates` VALUES ('98', 'Hierophant', '0', '22', '27', '21', '41', '20', '39', '3', '56', '6', '41', '300', '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');
    120. 

  120. INSERT INTO `char_templates` VALUES ('99', 'Eva Templar', '1', '36', '36', '35', '23', '14', '26', '4', '80', '6', '41', '300', '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');
    121. 

  121. INSERT INTO `char_templates` VALUES ('100', 'Sword Muse', '1', '36', '36', '35', '23', '14', '26', '4', '80', '6', '41', '300', '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');
    122. 

  122. INSERT INTO `char_templates` VALUES ('101', 'Wind Rider', '1', '36', '36', '35', '23', '14', '26', '4', '80', '6', '41', '300', '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');
    123. 

  123. INSERT INTO `char_templates` VALUES ('102', 'Moonlight Sentinel', '1', '36', '36', '35', '23', '14', '26', '4', '80', '6', '41', '300', '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');
    124. 

  124. INSERT INTO `char_templates` VALUES ('103', 'Mystic Muse', '1', '21', '25', '24', '37', '23', '40', '3', '56', '6', '41', '300', '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');
    125. 

  125. INSERT INTO `char_templates` VALUES ('104', 'Elemental Master', '1', '21', '25', '24', '37', '23', '40', '3', '56', '6', '41', '300', '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');
    126. 

  126. INSERT INTO `char_templates` VALUES ('105', 'Eva Saint', '1', '21', '25', '24', '37', '23', '40', '3', '56', '6', '41', '300', '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');
    127. 

  127. INSERT INTO `char_templates` VALUES ('106', 'Shillien Templar', '2', '41', '32', '34', '25', '12', '26', '4', '80', '6', '41', '300', '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');
    128. 

  128. INSERT INTO `char_templates` VALUES ('107', 'Spectral Dancer', '2', '41', '32', '34', '25', '12', '26', '4', '80', '6', '41', '300', '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');
    129. 

  129. INSERT INTO `char_templates` VALUES ('108', 'Ghost Hunter', '2', '41', '32', '34', '25', '12', '26', '4', '80', '6', '41', '300', '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');
    130. 

  130. INSERT INTO `char_templates` VALUES ('109', 'Ghost Sentinel', '2', '41', '32', '34', '25', '12', '26', '4', '80', '6', '41', '300', '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');
    131. 

  131. INSERT INTO `char_templates` VALUES ('110', 'Storm Screamer', '2', '23', '24', '23', '44', '19', '37', '3', '56', '6', '41', '300', '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');
    132. 

  132. INSERT INTO `char_templates` VALUES ('111', 'Spectral Master', '2', '23', '24', '23', '44', '19', '37', '3', '56', '6', '41', '300', '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');
    133. 

  133. INSERT INTO `char_templates` VALUES ('112', 'Shillen Saint', '2', '23', '24', '23', '44', '19', '37', '3', '56', '6', '41', '300', '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');
    134. 

  134. INSERT INTO `char_templates` VALUES ('113', 'Titan', '3', '40', '47', '26', '18', '12', '27', '4', '80', '6', '41', '300', '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');
    135. 

  135. INSERT INTO `char_templates` VALUES ('114', 'Grand Khauatari', '3', '40', '47', '26', '18', '12', '27', '4', '80', '6', '41', '300', '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');
    136. 

  136. INSERT INTO `char_templates` VALUES ('115', 'Dominator', '3', '27', '31', '24', '31', '15', '42', '3', '56', '6', '41', '300', '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');
    137. 

  137. INSERT INTO `char_templates` VALUES ('116', 'Doomcryer', '3', '27', '31', '24', '31', '15', '42', '3', '56', '6', '41', '300', '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');
    138. 

  138. INSERT INTO `char_templates` VALUES ('117', 'Fortune Seeker', '4', '39', '45', '29', '20', '10', '27', '4', '80', '6', '41', '300', '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');
    139. 

  139. INSERT INTO `char_templates` VALUES ('118', 'Maestro', '4', '39', '45', '29', '20', '10', '27', '4', '80', '6', '41', '300', '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');
    140.