Jump to content
×
×
  • Create New...

r34 - Official Metin2 SQL Tables


Shogun

Recommended Posts

  • Premium

M2 Download Center

This is the hidden content, please
( Internal )

Since many people may need it, here's my complete official db structure for game 34k, including:
 
- All Indexes and Options included
- All auto increment values are set to 1 (except player that is set to 100 to avoid some issues)
- Some non-fatal errors caused by original YMIR table structure are fixed
 

34k_official_db_structure.zip 69 KB
https://mega.co.nz/#!SB1CzYyI!T8c_wILefEJBpYjNJXKW2BVaPzp2SRMjNuVDh2WEXkU

Tables

refine_proto (official, valid for all game revisions)
 

Spoiler

-- ----------------------------
-- Table structure for `refine_proto`
-- ----------------------------
DROP TABLE IF EXISTS `refine_proto`;
CREATE TABLE `refine_proto` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vnum0` int(10) unsigned NOT NULL DEFAULT '0',
  `count0` smallint(6) NOT NULL DEFAULT '0',
  `vnum1` int(10) unsigned NOT NULL DEFAULT '0',
  `count1` smallint(6) NOT NULL DEFAULT '0',
  `vnum2` int(10) unsigned NOT NULL DEFAULT '0',
  `count2` smallint(6) NOT NULL DEFAULT '0',
  `vnum3` int(10) unsigned NOT NULL DEFAULT '0',
  `count3` smallint(6) NOT NULL DEFAULT '0',
  `vnum4` int(10) unsigned NOT NULL DEFAULT '0',
  `count4` smallint(6) NOT NULL DEFAULT '0',
  `cost` int(11) NOT NULL DEFAULT '0',
  `src_vnum` int(10) unsigned NOT NULL DEFAULT '0',
  `result_vnum` int(10) unsigned NOT NULL DEFAULT '0',
  `prob` smallint(6) NOT NULL DEFAULT '100',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=760 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of refine_proto
-- ----------------------------
INSERT INTO `refine_proto` VALUES ('1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '600', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('4', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('6', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('7', '30053', '1', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('8', '30073', '2', '0', '0', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('9', '30033', '2', '0', '0', '0', '0', '0', '0', '0', '0', '75000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('10', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('11', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('12', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('13', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('14', '30030', '2', '0', '0', '0', '0', '0', '0', '0', '0', '13000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('15', '30075', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('16', '30056', '2', '27799', '1', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('17', '30022', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '70000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('18', '30067', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('19', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('21', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('22', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('23', '30079', '1', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('24', '30015', '1', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('25', '30016', '2', '27992', '1', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('26', '30089', '2', '27993', '1', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '20');
INSERT INTO `refine_proto` VALUES ('27', '30091', '2', '27994', '1', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '10');
INSERT INTO `refine_proto` VALUES ('28', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '600', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('29', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('30', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('31', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('32', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('33', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('34', '30034', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('35', '30011', '2', '0', '0', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('36', '30035', '2', '0', '0', '0', '0', '0', '0', '0', '0', '75000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('37', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('38', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('39', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('40', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('41', '30052', '2', '0', '0', '0', '0', '0', '0', '0', '0', '13000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('42', '30046', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('43', '30045', '2', '27799', '1', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('44', '30025', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '70000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('45', '30058', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('46', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('47', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('48', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('49', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('50', '30083', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('51', '30060', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('52', '30061', '2', '27992', '1', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('53', '30088', '2', '27993', '1', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '20');
INSERT INTO `refine_proto` VALUES ('54', '30019', '2', '27994', '1', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '10');
INSERT INTO `refine_proto` VALUES ('55', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '600', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('56', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('57', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('58', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('59', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('60', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('61', '30070', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('62', '30072', '2', '0', '0', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('63', '30017', '2', '0', '0', '0', '0', '0', '0', '0', '0', '75000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('64', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('65', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('66', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('67', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('68', '30041', '1', '0', '0', '0', '0', '0', '0', '0', '0', '13000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('69', '30008', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('70', '30057', '1', '27799', '1', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('71', '30081', '1', '27987', '1', '0', '0', '0', '0', '0', '0', '70000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('72', '30077', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('73', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('74', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('75', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('76', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('77', '30009', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('78', '30039', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('79', '30040', '2', '27992', '1', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('80', '30048', '2', '27993', '1', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '20');
INSERT INTO `refine_proto` VALUES ('81', '30090', '2', '27994', '1', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '10');
INSERT INTO `refine_proto` VALUES ('82', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '600', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('83', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('84', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('85', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('86', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('87', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('88', '30031', '1', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('89', '30032', '2', '0', '0', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('90', '30033', '2', '0', '0', '0', '0', '0', '0', '0', '0', '75000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('91', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('92', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('93', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('94', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('95', '30008', '2', '0', '0', '0', '0', '0', '0', '0', '0', '13000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('96', '30075', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('97', '30006', '2', '27799', '1', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('98', '30022', '1', '27987', '1', '0', '0', '0', '0', '0', '0', '70000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('99', '30067', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('100', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('101', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('102', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('103', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('104', '30079', '1', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('105', '30015', '1', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('106', '30086', '2', '27992', '1', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('107', '30050', '2', '27993', '1', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '20');
INSERT INTO `refine_proto` VALUES ('108', '30091', '2', '27994', '1', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '10');
INSERT INTO `refine_proto` VALUES ('109', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '600', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('110', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('111', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('112', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('113', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('114', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('115', '30071', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('116', '30018', '2', '0', '0', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('117', '30017', '2', '0', '0', '0', '0', '0', '0', '0', '0', '75000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('118', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('119', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('121', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('122', '30005', '2', '0', '0', '0', '0', '0', '0', '0', '0', '13000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('123', '30076', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('124', '30051', '1', '27799', '1', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('125', '30081', '1', '27987', '1', '0', '0', '0', '0', '0', '0', '70000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('126', '30047', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('127', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('128', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('129', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('130', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('131', '30009', '1', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('132', '30080', '1', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('133', '30040', '2', '27992', '1', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('134', '30049', '2', '27993', '1', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '20');
INSERT INTO `refine_proto` VALUES ('135', '30090', '2', '27994', '1', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '10');
INSERT INTO `refine_proto` VALUES ('136', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '600', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('137', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('138', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('139', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('140', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('141', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('142', '30038', '1', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('143', '30023', '2', '0', '0', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('144', '30074', '2', '0', '0', '0', '0', '0', '0', '0', '0', '75000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('145', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('146', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('147', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('148', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('149', '30007', '2', '0', '0', '0', '0', '0', '0', '0', '0', '13000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('150', '30078', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('151', '30045', '2', '27799', '1', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('152', '30055', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '70000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('153', '30047', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('154', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('155', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('156', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('157', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('158', '30059', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('159', '30080', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('160', '30085', '2', '27992', '1', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('161', '30014', '2', '27993', '1', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '20');
INSERT INTO `refine_proto` VALUES ('162', '30042', '2', '27994', '1', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '10');
INSERT INTO `refine_proto` VALUES ('163', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '600', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('164', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('165', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('166', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('167', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('168', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('169', '30010', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('170', '30031', '1', '0', '0', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('171', '30032', '2', '0', '0', '0', '0', '0', '0', '0', '0', '75000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('172', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('173', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('174', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('175', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('176', '30021', '2', '0', '0', '0', '0', '0', '0', '0', '0', '13000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('177', '30008', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('178', '30057', '2', '27799', '1', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('179', '30006', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '70000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('180', '30022', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('181', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('182', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('183', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('184', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('185', '30082', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('186', '30079', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('187', '30087', '2', '27992', '1', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('188', '30086', '2', '27993', '1', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '20');
INSERT INTO `refine_proto` VALUES ('189', '30050', '2', '27994', '1', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '10');
INSERT INTO `refine_proto` VALUES ('190', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '600', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('191', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('192', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('193', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('194', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('195', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('196', '30038', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('197', '30011', '2', '0', '0', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('198', '30074', '1', '0', '0', '0', '0', '0', '0', '0', '0', '75000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('199', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('200', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('201', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('202', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('203', '30007', '2', '0', '0', '0', '0', '0', '0', '0', '0', '13000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('204', '30046', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('205', '30045', '2', '27799', '1', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('206', '30055', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '70000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('207', '30058', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('208', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('209', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('210', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('211', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('212', '30059', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('213', '30060', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('214', '30061', '2', '27992', '1', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('215', '30014', '2', '27993', '1', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '20');
INSERT INTO `refine_proto` VALUES ('216', '30042', '2', '27994', '1', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '10');
INSERT INTO `refine_proto` VALUES ('217', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '600', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('218', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('219', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('220', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('221', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('222', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('223', '30071', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('224', '30023', '1', '0', '0', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('225', '30074', '2', '0', '0', '0', '0', '0', '0', '0', '0', '75000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('226', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('227', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('228', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('229', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('230', '30005', '1', '0', '0', '0', '0', '0', '0', '0', '0', '13000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('231', '30078', '1', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('232', '30051', '1', '27799', '1', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('233', '30055', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '70000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('234', '30047', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('235', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('236', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('237', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('238', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('239', '30059', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('240', '30080', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('241', '30085', '2', '27992', '1', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('242', '30049', '2', '27993', '1', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '20');
INSERT INTO `refine_proto` VALUES ('243', '30042', '2', '27994', '1', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '10');
INSERT INTO `refine_proto` VALUES ('244', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '600', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('245', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('246', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('247', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('248', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('249', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('250', '30070', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('251', '30018', '2', '0', '0', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('252', '30017', '2', '0', '0', '0', '0', '0', '0', '0', '0', '75000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('253', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('254', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('255', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('256', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('257', '30041', '2', '0', '0', '0', '0', '0', '0', '0', '0', '13000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('258', '30076', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('259', '30051', '2', '27799', '1', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('260', '30081', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '70000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('261', '30077', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('262', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('263', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('264', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('265', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('266', '30009', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('267', '30039', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('268', '30040', '2', '27992', '1', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('269', '30048', '2', '27993', '1', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '20');
INSERT INTO `refine_proto` VALUES ('270', '30090', '2', '27994', '1', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '10');
INSERT INTO `refine_proto` VALUES ('271', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '600', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('272', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('273', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('274', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('275', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('276', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('277', '30010', '1', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('278', '30072', '2', '0', '0', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('279', '30032', '1', '0', '0', '0', '0', '0', '0', '0', '0', '75000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('280', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('281', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('282', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('283', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('284', '30021', '1', '0', '0', '0', '0', '0', '0', '0', '0', '13000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('285', '30008', '1', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('286', '30057', '1', '27799', '1', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('287', '30006', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '70000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('288', '30077', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('289', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('290', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('291', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('292', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('293', '30082', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('294', '30039', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('295', '30087', '2', '27992', '1', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('296', '30086', '2', '27993', '1', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '20');
INSERT INTO `refine_proto` VALUES ('297', '30050', '2', '27994', '1', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '10');
INSERT INTO `refine_proto` VALUES ('298', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '600', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('299', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('300', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('301', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('302', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('303', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('304', '30053', '1', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('305', '30073', '1', '0', '0', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('306', '30035', '2', '0', '0', '0', '0', '0', '0', '0', '0', '75000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('307', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('308', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('309', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('310', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('311', '30030', '2', '0', '0', '0', '0', '0', '0', '0', '0', '13000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('312', '30075', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('313', '30056', '2', '27799', '1', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('314', '30025', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '70000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('315', '30067', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('316', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('317', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('318', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('319', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('320', '30083', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('321', '30015', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('322', '30016', '2', '27992', '1', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('323', '30089', '2', '27993', '1', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '20');
INSERT INTO `refine_proto` VALUES ('324', '30019', '2', '27994', '1', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '10');
INSERT INTO `refine_proto` VALUES ('325', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '600', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('326', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('327', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('328', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('329', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('330', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('331', '30034', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('332', '30073', '2', '0', '0', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('333', '30035', '2', '0', '0', '0', '0', '0', '0', '0', '0', '75000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('334', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('335', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('336', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('337', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('338', '30052', '2', '0', '0', '0', '0', '0', '0', '0', '0', '13000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('339', '30046', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('340', '30056', '2', '27799', '1', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('341', '30025', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '70000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('342', '30058', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('343', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('344', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('345', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('346', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('347', '30083', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('348', '30060', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('349', '30061', '2', '30193', '2', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('350', '30088', '2', '30193', '4', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '20');
INSERT INTO `refine_proto` VALUES ('351', '30019', '2', '30193', '6', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '10');
INSERT INTO `refine_proto` VALUES ('352', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('353', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '6000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('354', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '12000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('355', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '25000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('356', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('357', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '60000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('358', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('359', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('360', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('400', '30192', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('401', '30194', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('402', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('403', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('404', '30083', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('405', '30060', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('406', '30061', '2', '30193', '2', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('407', '30088', '2', '30193', '4', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '20');
INSERT INTO `refine_proto` VALUES ('408', '30019', '2', '30193', '6', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '10');
INSERT INTO `refine_proto` VALUES ('501', '25040', '2', '70031', '1', '0', '0', '0', '0', '0', '0', '100000', '0', '0', '100');
INSERT INTO `refine_proto` VALUES ('502', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('503', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '140000', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('504', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '170000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('505', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '200000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('506', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '240000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('507', '30050', '2', '0', '0', '0', '0', '0', '0', '0', '0', '290000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('508', '30083', '2', '27992', '1', '0', '0', '0', '0', '0', '0', '340000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('509', '30040', '2', '27993', '1', '0', '0', '0', '0', '0', '0', '410000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('510', '30089', '2', '27994', '1', '0', '0', '0', '0', '0', '0', '500000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('531', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '7500', '0', '0', '90');
INSERT INTO `refine_proto` VALUES ('532', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '15000', '0', '0', '80');
INSERT INTO `refine_proto` VALUES ('533', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '25000', '0', '0', '70');
INSERT INTO `refine_proto` VALUES ('534', '30196', '2', '0', '0', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '60');
INSERT INTO `refine_proto` VALUES ('535', '30090', '3', '0', '0', '0', '0', '0', '0', '0', '0', '65000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('536', '30195', '2', '0', '0', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('537', '30197', '4', '27992', '1', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('538', '30198', '2', '27993', '1', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '20');
INSERT INTO `refine_proto` VALUES ('539', '30199', '2', '27994', '1', '0', '0', '0', '0', '0', '0', '200000', '0', '0', '10');
INSERT INTO `refine_proto` VALUES ('701', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '500000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('702', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2000000', '0', '0', '25');
INSERT INTO `refine_proto` VALUES ('703', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100');
INSERT INTO `refine_proto` VALUES ('751', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100000', '0', '0', '40');
INSERT INTO `refine_proto` VALUES ('752', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '500000', '0', '0', '50');
INSERT INTO `refine_proto` VALUES ('753', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2000000', '0', '0', '30');
INSERT INTO `refine_proto` VALUES ('758', '71123', '2', '71129', '3', '0', '0', '0', '0', '0', '0', '125000', '0', '0', '100');
INSERT INTO `refine_proto` VALUES ('759', '71123', '3', '71129', '4', '0', '0', '0', '0', '0', '0', '200000', '0', '0', '100');


object_proto (modified from official with smaller limits for buildings so they actually fit in your land)
 

Spoiler

CREATE TABLE `object_proto` (
  `vnum` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(32) NOT NULL DEFAULT '',
  `price` int(10) unsigned NOT NULL DEFAULT '0',
  `materials` varchar(64) NOT NULL DEFAULT '',
  `upgrade_vnum` int(10) unsigned NOT NULL DEFAULT '0',
  `upgrade_limit_time` int(10) unsigned NOT NULL DEFAULT '0',
  `life` int(11) NOT NULL DEFAULT '0',
  `reg_1` int(11) NOT NULL DEFAULT '0',
  `reg_2` int(11) NOT NULL DEFAULT '0',
  `reg_3` int(11) NOT NULL DEFAULT '0',
  `reg_4` int(11) NOT NULL DEFAULT '0',
  `npc` int(10) unsigned NOT NULL DEFAULT '0',
  `group_vnum` int(10) unsigned NOT NULL DEFAULT '0',
  `dependent_group` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`vnum`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
-- ----------------------------
-- Records of object_proto
-- ----------------------------
INSERT INTO `object_proto` VALUES ('14013', '?? ???', '20000000', '90010,20/90011,30/90012,20', '0', '0', '0', '-10', '-10', '10', '10', '20044', '2', '1');
INSERT INTO `object_proto` VALUES ('14014', '??? ???', '20000000', '90010,20/90011,30/90012,20', '0', '0', '0', '-10', '-10', '10', '10', '20045', '2', '1');
INSERT INTO `object_proto` VALUES ('14015', '???? ???', '20000000', '90010,20/90011,30/90012,20', '0', '0', '0', '-10', '-10', '10', '10', '20046', '2', '1');
INSERT INTO `object_proto` VALUES ('14043', '????? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20060', '3', '1');
INSERT INTO `object_proto` VALUES ('14045', '??? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20062', '3', '1');
INSERT INTO `object_proto` VALUES ('14046', '?? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20063', '3', '1');
INSERT INTO `object_proto` VALUES ('14047', '? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20064', '3', '1');
INSERT INTO `object_proto` VALUES ('14048', '? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20065', '3', '1');
INSERT INTO `object_proto` VALUES ('14049', '?? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20066', '3', '1');
INSERT INTO `object_proto` VALUES ('14050', '??? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20067', '3', '1');
INSERT INTO `object_proto` VALUES ('14051', '?? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20068', '3', '1');
INSERT INTO `object_proto` VALUES ('14052', '?? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20069', '3', '1');
INSERT INTO `object_proto` VALUES ('14053', '?? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20070', '3', '1');
INSERT INTO `object_proto` VALUES ('14054', '??? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20071', '3', '1');
INSERT INTO `object_proto` VALUES ('14055', '?? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20072', '3', '1');
INSERT INTO `object_proto` VALUES ('14061', '?? ??', '25000000', '90010,25/90011,25/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20077', '4', '1');
INSERT INTO `object_proto` VALUES ('14062', '?? ??', '500000000', '90010,50/90011,50/90012,50', '0', '0', '0', '-10', '-10', '10', '10', '20078', '4', '4');
INSERT INTO `object_proto` VALUES ('14063', '?? ??', '750000000', '90010,75/90011,75/90012,75', '0', '0', '0', '-10', '-10', '10', '10', '20079', '4', '4');
INSERT INTO `object_proto` VALUES ('14100', '?(1)', '20000000', '90010,20/90011,30/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '0', '1', '0');
INSERT INTO `object_proto` VALUES ('14110', '?(2)', '20000000', '90010,20/90011,30/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '0', '1', '0');
INSERT INTO `object_proto` VALUES ('14120', '?(3)', '20000000', '90010,20/90011,30/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '0', '1', '0');
INSERT INTO `object_proto` VALUES ('14200', '?? ??', '3000000', '90011,5/90012,5', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '1');
INSERT INTO `object_proto` VALUES ('14300', '?1', '300000', '90010,5', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14301', '?2', '300000', '90010,5', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14302', '?3', '300000', '90010,7', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14303', '?4', '300000', '90010,7', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14304', '?5', '300000', '90010,7', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14305', '?6', '300000', '90010,8', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14306', '?7', '300000', '90010,8', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14307', '?8', '300000', '90010,8', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14308', '?9', '300000', '90010,9', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14309', '?10', '300000', '90010,9', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14400', '??1', '2000000', '90011,5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14401', '??2', '2000000', '90011,5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14402', '??3', '2000000', '90011,7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14403', '??4', '2000000', '90011,7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14404', '??5', '2000000', '90011,7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14405', '??6', '2000000', '90011,9', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14406', '??7', '2000000', '90011,9', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14407', '??8', '2000000', '90011,9', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `object_proto` VALUES ('14408', '??9', '2000000', '90011,9', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
 

[/spoiler]

 
40k_item_attr (New bonuses: resist to earth, ice and dark)
 

Spoiler



SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `item_attr`
-- ----------------------------
DROP TABLE IF EXISTS `item_attr`;
CREATE TABLE `item_attr` (
  `apply` enum('MAX_HP','MAX_SP','CON','INT','STR','DEX','ATT_SPEED','MOV_SPEED','CAST_SPEED','HP_REGEN','SP_REGEN','POISON_PCT','STUN_PCT','SLOW_PCT','CRITICAL_PCT','PENETRATE_PCT','ATTBONUS_HUMAN','ATTBONUS_ANIMAL','ATTBONUS_ORC','ATTBONUS_MILGYO','ATTBONUS_UNDEAD','ATTBONUS_DEVIL','STEAL_HP','STEAL_SP','MANA_BURN_PCT','DAMAGE_SP_RECOVER','BLOCK','DODGE','RESIST_SWORD','RESIST_TWOHAND','RESIST_DAGGER','RESIST_BELL','RESIST_FAN','RESIST_BOW','RESIST_FIRE','RESIST_ELEC','RESIST_MAGIC','RESIST_WIND','REFLECT_MELEE','REFLECT_CURSE','POISON_REDUCE','KILL_SP_RECOVER','EXP_DOUBLE_BONUS','GOLD_DOUBLE_BONUS','ITEM_DROP_BONUS','POTION_BONUS','KILL_HP_RECOVER','IMMUNE_STUN','IMMUNE_SLOW','IMMUNE_FALL','SKILL','BOW_DISTANCE','ATT_GRADE_BONUS','DEF_GRADE_BONUS','MAGIC_ATT_GRADE','MAGIC_DEF_GRADE','CURSE_PCT','MAX_STAMINA','ATT_BONUS_TO_WARRIOR','ATT_BONUS_TO_ASSASSIN','ATT_BONUS_TO_SURA','ATT_BONUS_TO_SHAMAN','NORMAL_HIT_DEFEND_BONUS','SKILL_DEFEND_BONUS','NOUSE1','RESIST_ICE','RESIST_EARTH','RESIST_DARK','NOUSE6','NOUSE7','NOUSE8','NOUSE9','NOUSE10','NOUSE11','NOUSE12','NOUSE13','NOUSE14','RESIST_WARRIOR','RESIST_ASSASSIN','RESIST_SURA','RESIST_SHAMAN') NOT NULL DEFAULT 'MAX_HP',
  `prob` varchar(100) NOT NULL DEFAULT '',
  `lv1` varchar(100) NOT NULL DEFAULT '',
  `lv2` varchar(100) NOT NULL DEFAULT '',
  `lv3` varchar(100) NOT NULL DEFAULT '',
  `lv4` varchar(100) NOT NULL DEFAULT '',
  `lv5` varchar(100) NOT NULL DEFAULT '',
  `weapon` varchar(100) NOT NULL DEFAULT '',
  `body` varchar(100) NOT NULL DEFAULT '',
  `wrist` varchar(100) NOT NULL DEFAULT '',
  `foots` varchar(100) NOT NULL DEFAULT '',
  `neck` varchar(100) NOT NULL DEFAULT '',
  `head` varchar(100) NOT NULL DEFAULT '',
  `shield` varchar(100) NOT NULL DEFAULT '',
  `ear` varchar(100) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of item_attr
-- ----------------------------
INSERT INTO `item_attr` VALUES ('MAX_HP', '35', '500', '500', '1000', '1500', '2000', '0', '5', '5', '5', '5', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('MAX_SP', '35', '10', '20', '30', '50', '80', '0', '0', '5', '5', '5', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('CON', '11', '2', '4', '6', '8', '12', '5', '0', '0', '0', '0', '0', '5', '0');
INSERT INTO `item_attr` VALUES ('INT', '11', '2', '4', '6', '8', '12', '5', '0', '0', '0', '0', '0', '5', '0');
INSERT INTO `item_attr` VALUES ('STR', '11', '2', '4', '6', '8', '12', '5', '0', '0', '0', '0', '0', '5', '0');
INSERT INTO `item_attr` VALUES ('DEX', '11', '2', '4', '6', '8', '12', '5', '0', '0', '0', '0', '0', '5', '0');
INSERT INTO `item_attr` VALUES ('ATT_SPEED', '8', '1', '2', '3', '5', '8', '0', '0', '0', '5', '0', '5', '0', '0');
INSERT INTO `item_attr` VALUES ('MOV_SPEED', '18', '2', '4', '6', '10', '20', '0', '0', '0', '5', '0', '0', '0', '5');
INSERT INTO `item_attr` VALUES ('CAST_SPEED', '8', '2', '4', '6', '10', '20', '5', '5', '0', '0', '0', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('HP_REGEN', '60', '4', '8', '12', '20', '30', '0', '0', '0', '0', '5', '5', '0', '0');
INSERT INTO `item_attr` VALUES ('SP_REGEN', '60', '4', '8', '12', '20', '30', '0', '0', '0', '0', '5', '5', '0', '0');
INSERT INTO `item_attr` VALUES ('POISON_PCT', '8', '1', '2', '3', '5', '8', '5', '0', '0', '0', '0', '5', '0', '0');
INSERT INTO `item_attr` VALUES ('STUN_PCT', '18', '1', '2', '3', '5', '8', '5', '0', '0', '5', '5', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('SLOW_PCT', '35', '1', '2', '3', '5', '8', '5', '0', '0', '5', '0', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('CRITICAL_PCT', '18', '1', '2', '3', '5', '10', '5', '0', '0', '5', '5', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('PENETRATE_PCT', '30', '1', '2', '3', '5', '10', '5', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('ATTBONUS_HUMAN', '15', '1', '2', '3', '5', '10', '5', '0', '5', '0', '0', '5', '5', '5');
INSERT INTO `item_attr` VALUES ('ATTBONUS_ANIMAL', '35', '2', '4', '6', '10', '20', '5', '0', '5', '0', '0', '5', '5', '5');
INSERT INTO `item_attr` VALUES ('ATTBONUS_ORC', '35', '2', '4', '6', '10', '20', '5', '0', '5', '0', '0', '5', '5', '5');
INSERT INTO `item_attr` VALUES ('ATTBONUS_MILGYO', '35', '2', '4', '6', '10', '20', '5', '0', '5', '0', '0', '5', '5', '5');
INSERT INTO `item_attr` VALUES ('ATTBONUS_UNDEAD', '35', '2', '4', '6', '10', '20', '5', '0', '5', '0', '0', '5', '5', '5');
INSERT INTO `item_attr` VALUES ('ATTBONUS_DEVIL', '35', '2', '4', '6', '10', '20', '5', '0', '5', '0', '0', '5', '5', '5');
INSERT INTO `item_attr` VALUES ('STEAL_HP', '50', '1', '2', '3', '5', '10', '0', '5', '5', '0', '0', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('STEAL_SP', '50', '1', '2', '3', '5', '10', '0', '5', '0', '0', '5', '5', '0', '0');
INSERT INTO `item_attr` VALUES ('MANA_BURN_PCT', '18', '1', '2', '3', '5', '10', '0', '0', '5', '0', '0', '0', '0', '5');
INSERT INTO `item_attr` VALUES ('BLOCK', '10', '2', '4', '6', '10', '15', '0', '0', '0', '0', '0', '0', '5', '0');
INSERT INTO `item_attr` VALUES ('DODGE', '10', '2', '4', '6', '10', '15', '0', '0', '0', '5', '0', '5', '0', '0');
INSERT INTO `item_attr` VALUES ('RESIST_SWORD', '18', '2', '4', '6', '10', '15', '0', '5', '0', '5', '5', '0', '0', '5');
INSERT INTO `item_attr` VALUES ('RESIST_TWOHAND', '18', '2', '4', '6', '10', '15', '0', '5', '0', '5', '5', '0', '0', '5');
INSERT INTO `item_attr` VALUES ('RESIST_DAGGER', '18', '2', '4', '6', '10', '15', '0', '5', '0', '5', '5', '0', '0', '5');
INSERT INTO `item_attr` VALUES ('RESIST_BELL', '18', '2', '4', '6', '10', '15', '0', '5', '0', '5', '5', '0', '0', '5');
INSERT INTO `item_attr` VALUES ('RESIST_FAN', '18', '2', '4', '6', '10', '15', '0', '5', '0', '5', '5', '0', '0', '5');
INSERT INTO `item_attr` VALUES ('RESIST_BOW', '18', '2', '4', '6', '10', '15', '0', '5', '0', '5', '5', '0', '0', '5');
INSERT INTO `item_attr` VALUES ('RESIST_FIRE', '18', '2', '4', '6', '10', '15', '0', '5', '5', '0', '0', '5', '0', '0');
INSERT INTO `item_attr` VALUES ('RESIST_ELEC', '18', '2', '4', '6', '10', '15', '0', '5', '5', '0', '0', '5', '0', '0');
INSERT INTO `item_attr` VALUES ('RESIST_MAGIC', '25', '2', '4', '6', '10', '15', '0', '5', '5', '0', '0', '5', '0', '0');
INSERT INTO `item_attr` VALUES ('RESIST_WIND', '18', '2', '4', '6', '10', '15', '0', '5', '5', '0', '0', '5', '0', '0');
INSERT INTO `item_attr` VALUES ('REFLECT_MELEE', '18', '1', '2', '3', '6', '10', '0', '5', '0', '0', '0', '0', '5', '0');
INSERT INTO `item_attr` VALUES ('POISON_REDUCE', '18', '1', '2', '3', '4', '5', '0', '0', '0', '0', '0', '0', '0', '5');
INSERT INTO `item_attr` VALUES ('EXP_DOUBLE_BONUS', '10', '2', '4', '6', '8', '20', '0', '0', '0', '5', '5', '0', '5', '0');
INSERT INTO `item_attr` VALUES ('GOLD_DOUBLE_BONUS', '10', '2', '4', '6', '8', '20', '0', '0', '0', '5', '5', '0', '5', '0');
INSERT INTO `item_attr` VALUES ('ITEM_DROP_BONUS', '7', '2', '4', '6', '8', '20', '0', '0', '5', '0', '0', '0', '0', '5');
INSERT INTO `item_attr` VALUES ('IMMUNE_STUN', '3', '1', '1', '1', '1', '1', '0', '0', '0', '0', '0', '0', '1', '0');
INSERT INTO `item_attr` VALUES ('IMMUNE_SLOW', '3', '1', '1', '1', '1', '1', '0', '0', '0', '0', '0', '0', '1', '0');
INSERT INTO `item_attr` VALUES ('ATT_GRADE_BONUS', '9', '5', '10', '15', '30', '50', '0', '5', '0', '0', '0', '0', '0', '0');
INSERT INTO `item_attr` VALUES ('RESIST_DARK', '18', '2', '4', '6', '10', '15', '0', '5', '5', '0', '0', '5', '0', '0');
INSERT INTO `item_attr` VALUES ('RESIST_ICE', '18', '2', '4', '6', '10', '15', '0', '5', '5', '0', '0', '5', '0', '0');
INSERT INTO `item_attr` VALUES ('RESIST_EARTH', '18', '2', '4', '6', '10', '15', '0', '5', '5', '0', '0', '5', '0', '0');


skill_proto (SG, has a couple of small differences in regards to GF)
 

Spoiler

DROP TABLE IF EXISTS `skill_proto`;
CREATE TABLE `skill_proto` (
  `dwVnum` int(11) NOT NULL DEFAULT '0',
  `szName` varchar(32) NOT NULL DEFAULT '',
  `bType` tinyint(4) NOT NULL DEFAULT '0',
  `bLevelStep` tinyint(4) NOT NULL DEFAULT '0',
  `bMaxLevel` tinyint(4) NOT NULL DEFAULT '0',
  `bLevelLimit` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `szPointOn` varchar(100) NOT NULL DEFAULT '0',
  `szPointPoly` varchar(100) NOT NULL DEFAULT '',
  `szSPCostPoly` varchar(100) NOT NULL DEFAULT '',
  `szDurationPoly` varchar(100) NOT NULL DEFAULT '',
  `szDurationSPCostPoly` varchar(100) NOT NULL DEFAULT '',
  `szCooldownPoly` varchar(100) NOT NULL DEFAULT '',
  `szMasterBonusPoly` varchar(100) NOT NULL DEFAULT '',
  `szAttackGradePoly` varchar(100) NOT NULL DEFAULT '',
  `setFlag` set('ATTACK','USE_MELEE_DAMAGE','COMPUTE_ATTGRADE','SELFONLY','USE_MAGIC_DAMAGE','USE_HP_AS_COST','COMPUTE_MAGIC_DAMAGE','SPLASH','GIVE_PENALTY','USE_ARROW_DAMAGE','PENETRATE','IGNORE_TARGET_RATING','ATTACK_SLOW','ATTACK_STUN','HP_ABSORB','SP_ABSORB','ATTACK_FIRE_CONT','REMOVE_BAD_AFFECT','REMOVE_GOOD_AFFECT','CRUSH','ATTACK_POISON','TOGGLE','DISABLE_BY_POINT_UP','CRUSH_LONG') DEFAULT NULL,
  `setAffectFlag` enum('YMIR','INVISIBILITY','SPAWN','POISON','SLOW','STUN','DUNGEON_READY','FORCE_VISIBLE','BUILDING_CONSTRUCTION_SMALL','BUILDING_CONSTRUCTION_LARGE','BUILDING_UPGRADE','MOV_SPEED_POTION','ATT_SPEED_POTION','FISH_MIDE','JEONGWIHON','GEOMGYEONG','CHEONGEUN','GYEONGGONG','EUNHYUNG','GWIGUM','TERROR','JUMAGAP','HOSIN','BOHO','KWAESOK','MANASHIELD','MUYEONG','REVIVE_INVISIBLE','FIRE','GICHEON','JEUNGRYEOK','') DEFAULT NULL,
  `szPointOn2` varchar(100) NOT NULL DEFAULT 'NONE',
  `szPointPoly2` varchar(100) NOT NULL DEFAULT '',
  `szDurationPoly2` varchar(100) NOT NULL DEFAULT '',
  `setAffectFlag2` enum('YMIR','INVISIBILITY','SPAWN','POISON','SLOW','STUN','DUNGEON_READY','FORCE_VISIBLE','BUILDING_CONSTRUCTION_SMALL','BUILDING_CONSTRUCTION_LARGE','BUILDING_UPGRADE','MOV_SPEED_POTION','ATT_SPEED_POTION','FISH_MIDE','JEONGWIHON','GEOMGYEONG','CHEONGEUN','GYEONGGONG','EUNHYUNG','GWIGUM','TERROR','JUMAGAP','HOSIN','BOHO','KWAESOK','MANASHIELD') NOT NULL DEFAULT 'YMIR',
  `szPointOn3` varchar(100) NOT NULL DEFAULT 'NONE',
  `szPointPoly3` varchar(100) NOT NULL DEFAULT '',
  `szDurationPoly3` varchar(100) NOT NULL DEFAULT '',
  `szGrandMasterAddSPCostPoly` varchar(100) NOT NULL DEFAULT '',
  `prerequisiteSkillVnum` int(11) NOT NULL DEFAULT '0',
  `prerequisiteSkillLevel` int(11) NOT NULL DEFAULT '0',
  `eSkillType` enum('NORMAL','MELEE','RANGE','MAGIC') NOT NULL DEFAULT 'NORMAL',
  `iMaxHit` tinyint(4) NOT NULL DEFAULT '0',
  `szSplashAroundDamageAdjustPoly` varchar(100) NOT NULL DEFAULT '1',
  `dwTargetRange` int(11) NOT NULL DEFAULT '1000',
  `dwSplashRange` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`dwVnum`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of skill_proto
-- ----------------------------
INSERT INTO `skill_proto` VALUES ('1', '»ï¿¬Âü', '1', '1', '1', '0', 'HP', '-( 1.1*atk + (0.5*atk +  1.5 * str)*k)', '40+100*k', '', '', '12', '-( 1.1*atk + (0.5*atk +  1.5 * str)*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '40+100*k', '0', '0', 'MELEE', '5', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('2', 'Æȹædz¿ì', '1', '1', '1', '0', 'HP', '-(3*atk + (0.8*atk + str*5 + dex*3 +con)*k)', '50+130*k', '', '', '15', '-(3*atk + (0.8*atk + str*5 + dex*3 +con)*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '50+130*k', '0', '0', 'MELEE', '12', '1', '0', '200');
INSERT INTO `skill_proto` VALUES ('3', 'Àü±ÍÈ¥', '1', '1', '1', '0', 'ATT_SPEED', '50*k', '50+140*k', '60+90*k', '', '63+10*k', '50*k', '', 'SELFONLY', 'JEONGWIHON', 'MOV_SPEED', '20*k', '60+90*k', '', '', '', '', '50+140*k', '0', '0', 'NORMAL', '1', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('4', '°Ë°æ', '1', '1', '1', '0', 'ATT_GRADE', '(100 + str + lv * 3)*k', '100+200*k', '30+50*k', '', '30+10*k', '(100 + str + lv * 3)*k', '', 'SELFONLY', 'GEOMGYEONG', 'NONE', '', '', '', '', '', '', '100+200*k', '0', '0', 'NORMAL', '1', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('5', 'źȯ°Ý', '1', '1', '1', '0', 'HP', '-(2*atk + (atk + dex*3 + str*7 + con)*k)', '60+120*k', '', '', '12', '-(2*atk + (atk + dex*3 + str*7 + con)*k)', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH', '', 'MOV_SPEED', '150', '3', '', '', '', '', '60+120*k', '0', '0', 'MELEE', '4', '1', '0', '200');
INSERT INTO `skill_proto` VALUES ('16', '±â°øÂü', '1', '1', '1', '0', 'HP', '-(2.3*atk + (4*atk  + str*4 + con)*k)', '60+120*k', '', '', '15', '-(2.3*atk + (4*atk  + str*4 + con)*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '60+120*k', '0', '0', 'MELEE', '4', '1', '0', '100');
INSERT INTO `skill_proto` VALUES ('17', '°Ý»êŸ¿ì', '1', '1', '1', '0', 'HP', '-(2.3*atk + (3*atk + str*4 + con*3)*k)', '60+150*k', '', '', '15', '-(2.3*atk + (3*atk + str*4 + con*3)*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '60+150*k', '0', '0', 'MELEE', '8', '1', '0', '200');
INSERT INTO `skill_proto` VALUES ('18', '´ëÁø°¢', '1', '1', '1', '0', 'HP', '-(2*atk + (2*atk + 2*dex + 2*con + str*4)*k)', '50+140*k', '', '', '25', '-(2*atk + (2*atk + 2*dex + 2*con + str*4)*k)', '', 'ATTACK,USE_MELEE_DAMAGE,SELFONLY,SPLASH,ATTACK_STUN', '', 'NONE', '100+k*1000/6', '2', '', '', '', '', '50+140*k', '0', '0', 'MELEE', '10', '1', '0', '400');
INSERT INTO `skill_proto` VALUES ('19', 'õ±ÙÃß', '1', '1', '1', '0', 'DEF_GRADE', '(200 + str*0.2 + con*0.5 ) *k', '80+220*k', '60+90*k', '', '63+10*k', '(200 + str*0.2 + con*0.5 ) *k', '', 'SELFONLY', 'CHEONGEUN', 'MOV_SPEED', '-(1+9*k)', '60+90*k', '', '', '', '', '80+220*k', '0', '0', 'NORMAL', '1', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('20', '°Ëdz', '1', '1', '1', '0', 'HP', '-(2*atk + (atk + dex*3 + str*5 + con)*k)', '40+120*k', '', '', '20', '-(2*atk + (atk + dex*3 + str*5 + con)*k)', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH', '', 'NONE', '', '', '', '', '', '', '40+120*k', '0', '0', 'MELEE', '10', '0.5', '1200', '200');
INSERT INTO `skill_proto` VALUES ('31', '¾Ï½À', '2', '1', '1', '0', 'HP', '-(atk + (1.2 * atk + number(500, 700) + dex*4+ str*4 )*k)', '40+160*k', '', '', '15', '-(atk + (1.2 * atk + number(500, 700) + dex*4+ str*4 )*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '40+160*k', '0', '0', 'MELEE', '6', '0.8', '0', '0');
INSERT INTO `skill_proto` VALUES ('32', '±Ã½Åź¿µ', '2', '1', '1', '0', 'HP', '-(atk + (1.6* atk + number(200,300) + dex*7 + str*7)*k)', '40+160*k', '', '', '20', '-(atk + (1.6* atk + number(200,300) + dex*7 + str*7)*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '40+160*k', '0', '0', 'MELEE', '6', '0.8', '800', '0');
INSERT INTO `skill_proto` VALUES ('33', 'Â÷·û»ì', '2', '1', '1', '0', 'HP', '-(2*atk + (0.5*atk + dex*9 + str*7)*k)', '50+140*k', '', '', '25', '-(2*atk + (0.5*atk + dex*9 + str*7)*k)', '', 'ATTACK,USE_MELEE_DAMAGE,ATTACK_POISON', '', 'NONE', '40*k', '', '', '', '', '', '50+140*k', '0', '0', 'MELEE', '12', '0.8', '0', '0');
INSERT INTO `skill_proto` VALUES ('34', 'ÀºÇü¹ý', '2', '1', '1', '0', 'NONE', '', '30+60*k', '15+30*k', '', '60', '', '', 'SELFONLY', 'EUNHYUNG', 'NONE', '', '', '', '', '', '', '30+60*k', '0', '0', 'NORMAL', '1', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('35', '»ê°øºÐ', '2', '1', '1', '0', 'HP', '-(lv*2+(atk + str*3 + dex*18)*k)', '40+130*k', '', '', '25', '-(lv*2+(atk + str*3 + dex*18)*k)', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,ATTACK_POISON', '', 'NONE', '60*k', '5+25*k', '', '', '', '', '40+130*k', '0', '0', 'MAGIC', '0', '0.5', '800', '200');
INSERT INTO `skill_proto` VALUES ('46', '¿¬»ç', '2', '1', '1', '0', 'HP', '-(atk + 0.3*atk*floor(2+k*6)+ (0.8*atk+dex*8*ar) *k)', '40+130*k', '', '', '15', '-(atk + 0.2*atk*floor(2+k*6)+ (0.8*atk+dex*8*ar) *k)', '', 'ATTACK,USE_ARROW_DAMAGE', '', 'NONE', '', '', '', '', '', '', '40+130*k', '0', '0', 'RANGE', '1', '1', '2500', '0');
INSERT INTO `skill_proto` VALUES ('47', '°ü°Ý¼ú', '2', '1', '1', '0', 'HP', '-(atk + (1.9*atk + dex*2+ str*2)*k)', '30+130*k', '', '', '12', '-(atk + (1.7*atk + dex*2+ str*2)*k)', '', 'ATTACK,USE_ARROW_DAMAGE', '', 'NONE', '', '', '', '', '', '', '30+130*k', '0', '0', 'RANGE', '8', '1', '2500', '0');
INSERT INTO `skill_proto` VALUES ('48', 'È­Á¶ÆÄ', '2', '1', '1', '0', 'HP', '-(1.5*atk + (2.8*atk + number(100, 300))*k)', '50+130*k', '', '', '25', '-(1.5*atk + (2.6*atk + number(100, 300))*k)', '', 'ATTACK,SPLASH,USE_ARROW_DAMAGE', '', 'NONE', '', '', '', '', '', '', '50+130*k', '0', '0', 'RANGE', '12', '0.6', '2500', '300');
INSERT INTO `skill_proto` VALUES ('49', '°æ°ø¼ú', '2', '1', '1', '0', 'MOV_SPEED', '60*k', '30+40*k', '15+30*k', '', '30+30*k', '60*k', '', 'SELFONLY', 'GYEONGGONG', 'NONE', '', '', '', '', '', '', '30+40*k', '0', '0', 'NORMAL', '1', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('50', 'µ¶±â±Ã', '2', '1', '1', '0', 'HP', '-(atk + (1.5*atk + number(100, 200)+dex*6+str*2)*k)', '40+160*k', '', '', '25', '-(atk + (1.2*atk + number(100, 200)+dex*6+str*2)*k)', '', 'ATTACK,SPLASH,USE_ARROW_DAMAGE,CRUSH,ATTACK_POISON', '', 'NONE', '80*k', '15+30*k', '', '', '', '', '40+160*k', '0', '0', 'RANGE', '12', '0.5', '2500', '300');
INSERT INTO `skill_proto` VALUES ('61', '¼â·ÉÁö', '3', '1', '1', '0', 'HP', '-(atk + 2*lv + iq*2 + ( 2*atk + str*4 + iq*14) * k)', '30+140*k', '', '', '10', '-(atk + 2*lv + iq*2 + ( 2*atk + str*4 + iq*14) * k)', '', 'ATTACK,USE_MELEE_DAMAGE,PENETRATE', '', 'NONE', '1+k*9', '', '', '', '', '', '30+140*k', '0', '0', 'MELEE', '4', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('62', '¿ë±ÇÆÄ', '3', '1', '1', '0', 'HP', '-(1.1 * atk + 2*lv + iq*2+(1.5*atk + str + iq*12) * k)', '50+150*k', '', '', '15', '-(1.1 * atk + 2*lv + iq*2+(1.5*atk + str + iq*12) * k)', '', 'ATTACK,USE_MELEE_DAMAGE,SELFONLY,SPLASH,IGNORE_TARGET_RATING', '', 'NONE', '1+k*9', '', '', '', '', '', '50+150*k', '0', '0', 'MELEE', '12', '1', '0', '500');
INSERT INTO `skill_proto` VALUES ('63', '±Í°Ë', '3', '1', '1', '0', 'ATT_GRADE', '(3 * iq + 2 * lv)*k', '20+240*k', '50+100*k', '2+23*k', '0', '(3 * iq + 2 * lv)*k', '', 'SELFONLY,TOGGLE', 'GWIGUM', 'HIT_HP_RECOVER', '10*k', '50+80*k', '', '', '', '', '20+240*k', '0', '0', 'NORMAL', '1', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('64', '°øÆ÷', '3', '1', '1', '0', 'DODGE', '1 + 29 * k', '60+120*k', '60+100*k', '', '100', '1 + 29 * k', '', 'SELFONLY', 'TERROR', 'NONE', '', '', '', '', '', '', '60+120*k', '0', '0', 'NORMAL', '1', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('65', 'ÁÖ¸¶°©', '3', '1', '1', '0', 'DEF_GRADE', '(iq+30)*k', '70+170*k', '30+120*k', '', '33+140*k', '(iq+30)*k', '', 'SELFONLY', 'JUMAGAP', 'REFLECT_MELEE', '(iq/4+10)*k', '30+120*k', '', '', '', '', '70+170*k', '0', '0', 'NORMAL', '1', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('66', 'ÆĹý¼ú', '3', '1', '1', '0', 'HP', '-(40 +5*lv + 2*iq+(10*iq + 7*mwep + number(50,100) )*ar*k)', '30+120*k', '', '', '12', '-(40 +5*lv + 2*iq+(10*iq + 7*mwep + number(50,100) )*ar*k)', '', 'ATTACK,COMPUTE_MAGIC_DAMAGE,SPLASH,REMOVE_GOOD_AFFECT', '', 'NONE', '10+40*k', '7+23*k', '', '', '', '', '30+120*k', '0', '0', 'NORMAL', '5', '0.6', '1800', '200');
INSERT INTO `skill_proto` VALUES ('76', '¸¶·É', '3', '1', '1', '0', 'HP', '-(40 +5*lv + 2*iq +(13*iq + 6*mwep + number(50,100) )*ar*k)', '30+140*k', '', '', '7', '-(40 +5*lv + 2*iq +(13*iq + 6*mwep + number(50,100) )*ar*k)', '', 'ATTACK,COMPUTE_MAGIC_DAMAGE,SPLASH', '', 'NONE', '', '', '', '', '', '', '30+140*k', '0', '0', 'MAGIC', '5', '0.6', '1500', '200');
INSERT INTO `skill_proto` VALUES ('77', 'È­¿°Æø', '3', '1', '1', '0', 'HP', '-(5*lv + 2*iq+(10*iq + 6*mwep + str*4 + con*2 + number(180,200) )*k)', '60+140*k', '', '', '12', '-(5*lv + 2*iq+(10*iq + 6*mwep + str*4 + con*2 + number(180,200) )*k)', '', 'ATTACK,SELFONLY,COMPUTE_MAGIC_DAMAGE,SPLASH', '', 'NONE', '', '', '', '', '', '', '60+140*k', '0', '0', 'MAGIC', '15', '0.8', '0', '500');
INSERT INTO `skill_proto` VALUES ('78', '¹«¿µÁø', '3', '1', '1', '0', 'HP', '-(30+ 2*lv + 2*iq+(7*iq + 6*mwep + number(200,500))*ar*k)', '20+30*k', '40+30*k', '5+40*k', '43+30*k', '-(30+ 2*lv + 2*iq+(7*iq + 6*mwep + number(200,500))*ar*k)', '', 'ATTACK,COMPUTE_MAGIC_DAMAGE,SPLASH,TOGGLE', '', 'NONE', '', '', '', '', '', '', '20+30*k', '0', '0', 'MAGIC', '1', '1', '800', '0');
INSERT INTO `skill_proto` VALUES ('79', 'Èæ½Å¼öÈ£', '3', '1', '1', '0', 'DEF_GRADE', '(0.5*iq+15)*k', '20+30*k', '60+120*k', '5+10*k', '63+10*k', '(0.5*iq+15)*k', '', 'SELFONLY,TOGGLE', 'MANASHIELD', 'MANASHIELD', '100-((iq*0.84)*k)', '60+10*k', '', '', '', '', '20+30*k', '0', '0', 'MAGIC', '1', '0.8', '0', '0');
INSERT INTO `skill_proto` VALUES ('80', 'Åõ¼Ó¸¶·É', '3', '1', '1', '0', 'HP', '-(40 + 2* lv + 2*iq +(2 * con + 2 * dex + 13*iq + 6*mwep + number(180, 200))*ar*k)', '40+120*k', '', '', '12', '-(40 + 2* lv + 2*iq +(2 * con + 2 * dex + 13*iq + 6*mwep + number(180, 200))*ar*k)', '', 'ATTACK,COMPUTE_MAGIC_DAMAGE,SPLASH,ATTACK_SLOW', '', 'NONE', '333+300*k', '10+10*k', '', '', '', '', '40+120*k', '0', '0', 'MAGIC', '9', '0.8', '1200', '400');
INSERT INTO `skill_proto` VALUES ('81', '¸¶È¯°Ý', '3', '1', '1', '0', 'HP', '-(120 + 6*lv + (5 * con + 5 * dex + 29*iq + 9*mwep)*ar*k)', '80+220*k', '', '', '24', '-(120 + 6*lv + (5 * con + 5 * dex + 29*iq + 9*mwep)*ar*k)', '', 'ATTACK,COMPUTE_MAGIC_DAMAGE,SPLASH', '', 'NONE', '', '', '', '', '', '', '80+220*k', '0', '0', 'MAGIC', '9', '0.4', '1500', '200');
INSERT INTO `skill_proto` VALUES ('91', 'ºñÆĺÎ', '4', '1', '1', '0', 'HP', '-(70 + 4*lv + (20*iq+5*mwep+50)*ar*k)', '30+160*k', '', '', '7', '-(70 + 4*lv + (20*iq+5*mwep+50)*ar*k)', '', 'ATTACK,COMPUTE_MAGIC_DAMAGE,SPLASH', '', 'NONE', '', '', '', '', '', '', '30+160*k', '0', '0', 'MAGIC', '5', '0.5', '1800', '201');
INSERT INTO `skill_proto` VALUES ('92', '¿ëÆÄ»ê', '4', '1', '1', '0', 'HP', '-(60 + 5*lv + (18*iq + 6*mwep + 120)*ar*k)', '50+160*k', '', '', '8', '-(60 + 5*lv + (18*iq + 6*mwep + 120)*ar*k)', '', 'ATTACK,ATTACK_FIRE_CONT', '', 'NONE', 'lv+5*iq *k', 'iq*0.2*k', '', '', '', '', '50+160*k', '0', '0', 'MAGIC', '10', '0.8', '0', '0');
INSERT INTO `skill_proto` VALUES ('93', 'ÆзæÆø', '4', '1', '1', '0', 'HP', '-(80 + 6*lv + (20*iq+14*mwep+120)*ar*k)', '50+160*k', '', '', '20', '-(80 + 6*lv + (20*iq+14*mwep+120)*ar*k)', '', 'ATTACK,SELFONLY,SPLASH,ATTACK_FIRE_CONT', '', 'NONE', 'lv+5*iq *k', 'iq*0.2*k', '', '', '', '', '50+160*k', '0', '0', 'MAGIC', '15', '0.8', '0', '500');
INSERT INTO `skill_proto` VALUES ('94', 'È£½Å', '4', '1', '1', '0', 'RESIST_NORMAL', '(iq*0.3+5)*(2*k+0.5)/(k+1.5)', '40+160*k', '60+200*k', '', '10', '(iq*0.3+5)*(2*k+0.5)/(k+1.5)', '', '', 'HOSIN', 'NONE', '', '', '', '', '', '', '40+160*k', '0', '0', 'NORMAL', '1', '1', '800', '0');
INSERT INTO `skill_proto` VALUES ('95', '¹Ý»ç', '4', '1', '1', '0', 'REFLECT_MELEE', '5+(iq*0.3 + 5)*k', '40+160*k', '60+200*k', '', '10', '5+(iq*0.3 + 5)*k', '', '', 'BOHO', 'NONE', '', '', '', '', '', '', '40+160*k', '0', '0', 'NORMAL', '1', '1', '1000', '0');
INSERT INTO `skill_proto` VALUES ('96', '±âõ´ë°ø', '4', '1', '1', '0', 'CRITICAL', '(iq*0.3+5)*(2*k+0.5)/(k+1.5)', '40+160*k', '60+100*k', '', '10', '(iq*0.3+5)*(2*k+0.5)/(k+1.5)', '', '', 'GICHEON', 'NONE', '', '', '', '', '', '', '40+160*k', '0', '0', 'NORMAL', '1', '1', '1000', '0');
INSERT INTO `skill_proto` VALUES ('106', '³úÀü·É', '4', '1', '1', '0', 'HP', '-(60 + 4*lv + (7*iq+8*mwep+number(iq*5,iq*15))*ar*k)', '30+150*k', '', '', '7', '-(60 + 4*lv + (7*iq+8*mwep+number(iq*5,iq*15))*ar*k)', '', 'ATTACK,SPLASH', '', 'NONE', '', '', '', '', '', '', '30+150*k', '0', '0', 'MAGIC', '5', '0.6', '1800', '200');
INSERT INTO `skill_proto` VALUES ('107', 'º­¶ô', '4', '1', '1', '0', 'HP', '-(40 + 4*lv + (13*iq+7*mwep+number(iq*5,iq*16))*ar*k)', '50+150*k', '', '', '15', '-(40 + 4*lv + (13*iq+7*mwep+number(iq*5,iq*16))*ar*k)', '', 'ATTACK,SPLASH,ATTACK_STUN', '', 'NONE', '50+1000*k/6', '5', '', '', '', '', '50+150*k', '0', '0', 'MAGIC', '15', '0.8', '1500', '400');
INSERT INTO `skill_proto` VALUES ('108', 'Æø·Ú°Ý', '4', '1', '1', '0', 'HP', '-(50 + 5*lv + (6*iq+6*mwep+number(1,800))*ar*k) * (1-chain*0.13)', '40+180*k', '', '', '10', '-(50 + 5*lv + (6*iq+6*mwep+number(1,800))*ar*k) * (1-chain*0.13)', '', 'ATTACK', '', 'NONE', '', '', '', '', '', '', '40+180*k', '0', '0', 'MAGIC', '7', '0.8', '2500', '0');
INSERT INTO `skill_proto` VALUES ('109', 'Á¤¾÷ÀÎ', '4', '1', '1', '0', 'HP', '200+7*lv+(30*iq+6*mwep+600)*k', '40+200*k', '', '', '10', '200+7*lv+(30*iq+6*mwep+600)*k', '', 'REMOVE_BAD_AFFECT', '', 'NONE', '20+80*k', '0', '', '', '', '', '40+200*k', '0', '0', 'NORMAL', '1', '1', '1000', '0');
INSERT INTO `skill_proto` VALUES ('110', 'Äè¼Ó', '4', '1', '1', '0', 'MOV_SPEED', '5 + 35*k', '60+120*k', '60+100*k', '', '10', '5 + 35*k', '', '', 'KWAESOK', 'CASTING_SPEED', '3+33*k', '60+100*k', '', '', '', '', '60+120*k', '0', '0', 'NORMAL', '1', '1', '1000', '0');
INSERT INTO `skill_proto` VALUES ('111', 'Áõ·Â¼ú', '4', '1', '1', '0', 'ATT_GRADE', '10+(iq*0.4 +20)*k', '60+120*k', '60+100*k', '', '10', '10+(iq*0.4 +30)*k', '', '', 'JEUNGRYEOK', 'NONE', '', '', '', '', '', '', '60+120*k', '0', '0', 'NORMAL', '1', '1', '1000', '0');
INSERT INTO `skill_proto` VALUES ('121', 'Åë¼Ö·Â', '0', '1', '40', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('122', '¿¬°è±â', '0', '1', '2', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('124', '䱤¼ú', '0', '1', '40', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('125', 'º¯½Å', '0', '1', '40', '0', 'NONE', '', '', '10+1000*k', '', '', '', '', 'DISABLE_BY_POINT_UP', 'YMIR', 'NONE', '', '', 'YMIR', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '1000', '0');
INSERT INTO `skill_proto` VALUES ('126', '½Å¼ö¾î', '0', '1', '20', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('127', 'õÁ¶¾î', '0', '1', '20', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('128', 'Áø³ë¾î', '0', '1', '20', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('129', 'µÐ°©¼ú', '0', '1', '40', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', 'NONE', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('130', '½Â¸¶', '0', '1', '1', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('131', '¸»¼Òȯ', '0', '1', '10', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('137', '³­¹«', '5', '1', '1', '50', 'HP', '-(atk+(2*atk*k))', '60+80*k', '', '', '5-(4*k)', '', '', 'ATTACK,USE_MELEE_DAMAGE,CRUSH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'MELEE', '10', '1', '300', '0');
INSERT INTO `skill_proto` VALUES ('138', 'µ¹°Ý', '5', '1', '1', '52', 'HP', '-(2.4*(200+1.5*lv)+(3*200*k))', '60+120*k', '', '', '15', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH_LONG', '', 'MOV_SPEED', '50', '5', '', '', '', '', '', '0', '0', 'MELEE', '6', '1', '400', '100');
INSERT INTO `skill_proto` VALUES ('139', 'Å»Ãâ', '5', '1', '1', '55', 'HP', '-(2*(200+1.5*lv)+(3*200*k))', '60+160*k', '', '', '20', '', '', 'ATTACK,USE_MELEE_DAMAGE,SELFONLY,SPLASH,CRUSH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'MELEE', '12', '1', '400', '250');
INSERT INTO `skill_proto` VALUES ('140', '³­¹«(È°)', '5', '1', '1', '50', 'HP', '-(atk+(2*atk*k))', '60+80*k', '', '', '10', '', '', 'ATTACK,USE_ARROW_DAMAGE,CRUSH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', '', '5', '1', '2500', '0');
INSERT INTO `skill_proto` VALUES ('151', '¿ë¾È', '0', '1', '7', '0', 'NONE', '', '', '', '', '', '', '', '', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('152', '¿ë½ÅÀÇÇÇ', '0', '1', '7', '0', 'MAX_HP', 'maxhp*0.2*k', '150+150*k', '300', '', '600', '', '', '', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('153', '¿ë½ÅÀÇÃູ', '0', '1', '7', '0', 'MAX_SP', 'maxsp*0.2*k', '150+150*k', '300', '', '600', '', '', '', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('154', '¼ºÈÖ°©', '0', '1', '7', '0', 'DEF_GRADE', 'odef*0.1*k', '150+150*k', '180', '', '480', '', '', '', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('155', '°¡¼ÓÈ­', '0', '1', '7', '0', 'MOV_SPEED', '15*k', '150+150*k', '180', '', '480', '', '', '', '', 'ATT_SPEED', '15*k', '180', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('156', '¿ë½ÅÀǺгë', '0', '1', '7', '0', 'CRITICAL', '50*k', '150+150*k', '180', '', '480', '', '', 'SELFONLY', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('157', 'ÁÖ¹®¼ú', '0', '1', '7', '0', 'CASTING_SPEED', '50*k', '150+150*k', '180', '', '480', '', '', 'SELFONLY', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('158', '±æµåÀ̵¿', '0', '1', '3', '0', 'NONE', '', '', '', '', '', '', '', 'SELFONLY', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('159', '°ø°£Àǹ®', '0', '1', '5', '0', 'NONE', '', '', '', '', '', '', '', 'SELFONLY', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('160', '°¡¼ÓÈ­', '0', '1', '5', '0', 'NONE', '3*k', '80-12*k', '300', '', '', '', '', 'SELFONLY', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('161', '°ø°£Àǹ®', '0', '1', '2', '0', 'NONE', '', '50', '', '', '', '', '', '', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('162', '°ø°£À̵¿', '0', '1', '2', '0', 'NONE', '', '20', '', '', '', '', '', '', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('256', 'CRUSH200½ºÅ³', '0', '1', '1', '0', 'HP', '-5*k*atk', '', '', '', '4', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'MELEE', '0', '1', '0', '300');
INSERT INTO `skill_proto` VALUES ('257', 'ÀϹݹüÀ§350½ºÅ³', '0', '1', '1', '0', 'HP', '-5*k*atk', '', '', '', '6', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'MELEE', '0', '1', '0', '525');
INSERT INTO `skill_proto` VALUES ('258', 'CRUSH300½ºÅ³', '0', '1', '1', '0', 'HP', '-5*k*atk', '', '', '', '8', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'MELEE', '0', '1', '0', '450');
INSERT INTO `skill_proto` VALUES ('259', 'ÀϹݹüÀ§200½ºÅ³', '0', '1', '1', '0', 'HP', '-5*k*atk', '', '', '', '10', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'MELEE', '0', '1', '0', '300');
INSERT INTO `skill_proto` VALUES ('260', 'CURSH400½ºÅ³', '0', '1', '1', '0', 'HP', '-5*k*atk', '', '', '', '12', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'MELEE', '0', '1', '0', '600');
INSERT INTO `skill_proto` VALUES ('261', 'µ¶250½ºÅ³', '0', '1', '1', '0', 'HP', '-5*k*atk', '', '', '', '10', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,ATTACK_POISON', '', 'NONE', '80', '', '', '', '', '', '', '0', '0', 'MELEE', '0', '1', '0', '375');
INSERT INTO `skill_proto` VALUES ('262', 'SLOW300½ºÅ³', '0', '1', '1', '0', 'HP', '-5*k*atk', '', '', '', '14', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH', '', 'MOV_SPEED', '-20', '10', '', '', '', '', '', '0', '0', 'MELEE', '0', '1', '0', '450');


shop_item (SG)
 

Spoiler

-- ----------------------------
-- Table structure for `shop_item`
-- ----------------------------
DROP TABLE IF EXISTS `shop_item`;
CREATE TABLE `shop_item` (
  `shop_vnum` int(11) NOT NULL DEFAULT '0',
  `item_vnum` int(11) NOT NULL DEFAULT '0',
  `count` tinyint(4) unsigned NOT NULL DEFAULT '1',
  UNIQUE KEY `vnum_unique` (`shop_vnum`,`item_vnum`,`count`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of shop_item
-- ----------------------------
INSERT INTO `shop_item` VALUES ('1', '20', '1');
INSERT INTO `shop_item` VALUES ('1', '40', '1');
INSERT INTO `shop_item` VALUES ('1', '60', '1');
INSERT INTO `shop_item` VALUES ('1', '80', '1');
INSERT INTO `shop_item` VALUES ('1', '1040', '1');
INSERT INTO `shop_item` VALUES ('1', '2010', '1');
INSERT INTO `shop_item` VALUES ('1', '2030', '1');
INSERT INTO `shop_item` VALUES ('1', '2050', '1');
INSERT INTO `shop_item` VALUES ('1', '2070', '1');
INSERT INTO `shop_item` VALUES ('1', '3010', '1');
INSERT INTO `shop_item` VALUES ('1', '3030', '1');
INSERT INTO `shop_item` VALUES ('1', '3050', '1');
INSERT INTO `shop_item` VALUES ('1', '3070', '1');
INSERT INTO `shop_item` VALUES ('1', '4000', '1');
INSERT INTO `shop_item` VALUES ('1', '4010', '1');
INSERT INTO `shop_item` VALUES ('1', '4020', '1');
INSERT INTO `shop_item` VALUES ('1', '5010', '1');
INSERT INTO `shop_item` VALUES ('1', '5030', '1');
INSERT INTO `shop_item` VALUES ('1', '7010', '1');
INSERT INTO `shop_item` VALUES ('1', '7030', '1');
INSERT INTO `shop_item` VALUES ('1', '7050', '1');
INSERT INTO `shop_item` VALUES ('1', '8000', '100');
INSERT INTO `shop_item` VALUES ('1', '8000', '200');
INSERT INTO `shop_item` VALUES ('2', '27400', '1');
INSERT INTO `shop_item` VALUES ('2', '27600', '1');
INSERT INTO `shop_item` VALUES ('2', '27610', '1');
INSERT INTO `shop_item` VALUES ('2', '27800', '5');
INSERT INTO `shop_item` VALUES ('2', '27800', '50');
INSERT INTO `shop_item` VALUES ('2', '27801', '5');
INSERT INTO `shop_item` VALUES ('2', '27801', '50');
INSERT INTO `shop_item` VALUES ('3', '14000', '1');
INSERT INTO `shop_item` VALUES ('3', '15000', '1');
INSERT INTO `shop_item` VALUES ('3', '16000', '1');
INSERT INTO `shop_item` VALUES ('3', '17000', '1');
INSERT INTO `shop_item` VALUES ('3', '27001', '5');
INSERT INTO `shop_item` VALUES ('3', '27001', '20');
INSERT INTO `shop_item` VALUES ('3', '27001', '200');
INSERT INTO `shop_item` VALUES ('3', '27002', '5');
INSERT INTO `shop_item` VALUES ('3', '27002', '20');
INSERT INTO `shop_item` VALUES ('3', '27002', '200');
INSERT INTO `shop_item` VALUES ('3', '27003', '5');
INSERT INTO `shop_item` VALUES ('3', '27003', '20');
INSERT INTO `shop_item` VALUES ('3', '27003', '200');
INSERT INTO `shop_item` VALUES ('3', '27004', '5');
INSERT INTO `shop_item` VALUES ('3', '27004', '20');
INSERT INTO `shop_item` VALUES ('3', '27004', '200');
INSERT INTO `shop_item` VALUES ('3', '27005', '5');
INSERT INTO `shop_item` VALUES ('3', '27005', '20');
INSERT INTO `shop_item` VALUES ('3', '27005', '200');
INSERT INTO `shop_item` VALUES ('3', '27006', '5');
INSERT INTO `shop_item` VALUES ('3', '27006', '20');
INSERT INTO `shop_item` VALUES ('3', '27006', '200');
INSERT INTO `shop_item` VALUES ('3', '50200', '1');
INSERT INTO `shop_item` VALUES ('3', '50901', '10');
INSERT INTO `shop_item` VALUES ('3', '71113', '20');
INSERT INTO `shop_item` VALUES ('4', '11200', '1');
INSERT INTO `shop_item` VALUES ('4', '11220', '1');
INSERT INTO `shop_item` VALUES ('4', '11230', '1');
INSERT INTO `shop_item` VALUES ('4', '11400', '1');
INSERT INTO `shop_item` VALUES ('4', '11420', '1');
INSERT INTO `shop_item` VALUES ('4', '11430', '1');
INSERT INTO `shop_item` VALUES ('4', '11600', '1');
INSERT INTO `shop_item` VALUES ('4', '11620', '1');
INSERT INTO `shop_item` VALUES ('4', '11630', '1');
INSERT INTO `shop_item` VALUES ('4', '11800', '1');
INSERT INTO `shop_item` VALUES ('4', '11820', '1');
INSERT INTO `shop_item` VALUES ('4', '11830', '1');
INSERT INTO `shop_item` VALUES ('4', '12200', '1');
INSERT INTO `shop_item` VALUES ('4', '12340', '1');
INSERT INTO `shop_item` VALUES ('4', '12480', '1');
INSERT INTO `shop_item` VALUES ('4', '12620', '1');
INSERT INTO `shop_item` VALUES ('4', '13000', '1');
INSERT INTO `shop_item` VALUES ('5', '3100', '1');
INSERT INTO `shop_item` VALUES ('5', '5020', '1');
INSERT INTO `shop_item` VALUES ('5', '5030', '1');
INSERT INTO `shop_item` VALUES ('5', '5040', '1');
INSERT INTO `shop_item` VALUES ('5', '5050', '1');
INSERT INTO `shop_item` VALUES ('5', '5070', '1');
INSERT INTO `shop_item` VALUES ('5', '5080', '1');
INSERT INTO `shop_item` VALUES ('5', '7020', '1');
INSERT INTO `shop_item` VALUES ('5', '7050', '1');
INSERT INTO `shop_item` VALUES ('5', '7060', '1');
INSERT INTO `shop_item` VALUES ('5', '7090', '1');
INSERT INTO `shop_item` VALUES ('5', '7100', '1');
INSERT INTO `shop_item` VALUES ('6', '14000', '1');
INSERT INTO `shop_item` VALUES ('6', '14020', '1');
INSERT INTO `shop_item` VALUES ('6', '14040', '1');
INSERT INTO `shop_item` VALUES ('6', '14060', '1');
INSERT INTO `shop_item` VALUES ('6', '14080', '1');
INSERT INTO `shop_item` VALUES ('6', '14140', '1');
INSERT INTO `shop_item` VALUES ('6', '15000', '1');
INSERT INTO `shop_item` VALUES ('6', '15020', '1');
INSERT INTO `shop_item` VALUES ('6', '15040', '1');
INSERT INTO `shop_item` VALUES ('6', '15060', '1');
INSERT INTO `shop_item` VALUES ('6', '15080', '1');
INSERT INTO `shop_item` VALUES ('6', '15160', '1');
INSERT INTO `shop_item` VALUES ('6', '16000', '1');
INSERT INTO `shop_item` VALUES ('6', '16020', '1');
INSERT INTO `shop_item` VALUES ('6', '16040', '1');
INSERT INTO `shop_item` VALUES ('6', '16060', '1');
INSERT INTO `shop_item` VALUES ('6', '16080', '1');
INSERT INTO `shop_item` VALUES ('6', '16180', '1');
INSERT INTO `shop_item` VALUES ('6', '17000', '1');
INSERT INTO `shop_item` VALUES ('6', '17020', '1');
INSERT INTO `shop_item` VALUES ('6', '17040', '1');
INSERT INTO `shop_item` VALUES ('6', '17060', '1');
INSERT INTO `shop_item` VALUES ('6', '17080', '1');
INSERT INTO `shop_item` VALUES ('6', '17180', '1');
INSERT INTO `shop_item` VALUES ('7', '80003', '1');
INSERT INTO `shop_item` VALUES ('7', '80004', '1');
INSERT INTO `shop_item` VALUES ('7', '80005', '1');
INSERT INTO `shop_item` VALUES ('7', '80006', '1');
INSERT INTO `shop_item` VALUES ('7', '80007', '1');
INSERT INTO `shop_item` VALUES ('8', '50100', '100');
INSERT INTO `shop_item` VALUES ('8', '50101', '100');
INSERT INTO `shop_item` VALUES ('8', '50102', '100');
INSERT INTO `shop_item` VALUES ('8', '50103', '100');
INSERT INTO `shop_item` VALUES ('8', '50104', '100');
INSERT INTO `shop_item` VALUES ('8', '50105', '100');
INSERT INTO `shop_item` VALUES ('9', '11901', '1');
INSERT INTO `shop_item` VALUES ('9', '11903', '1');
INSERT INTO `shop_item` VALUES ('9', '50201', '1');
INSERT INTO `shop_item` VALUES ('10', '29101', '1');
INSERT INTO `shop_item` VALUES ('11', '50054', '1');
INSERT INTO `shop_item` VALUES ('11', '50055', '1');
INSERT INTO `shop_item` VALUES ('11', '50056', '1');
INSERT INTO `shop_item` VALUES ('1001', '10', '1');
INSERT INTO `shop_item` VALUES ('1001', '20', '1');
INSERT INTO `shop_item` VALUES ('1001', '30', '1');
INSERT INTO `shop_item` VALUES ('1001', '40', '1');
INSERT INTO `shop_item` VALUES ('1001', '50', '1');
INSERT INTO `shop_item` VALUES ('1001', '60', '1');
INSERT INTO `shop_item` VALUES ('1001', '70', '1');
INSERT INTO `shop_item` VALUES ('1001', '80', '1');
INSERT INTO `shop_item` VALUES ('1001', '90', '1');
INSERT INTO `shop_item` VALUES ('1001', '100', '1');
INSERT INTO `shop_item` VALUES ('1001', '110', '1');
INSERT INTO `shop_item` VALUES ('1001', '120', '1');
INSERT INTO `shop_item` VALUES ('1001', '130', '1');
INSERT INTO `shop_item` VALUES ('1002', '1000', '1');
INSERT INTO `shop_item` VALUES ('1002', '1010', '1');
INSERT INTO `shop_item` VALUES ('1002', '1020', '1');
INSERT INTO `shop_item` VALUES ('1002', '1030', '1');
INSERT INTO `shop_item` VALUES ('1002', '1040', '1');
INSERT INTO `shop_item` VALUES ('1002', '1050', '1');
INSERT INTO `shop_item` VALUES ('1002', '1060', '1');
INSERT INTO `shop_item` VALUES ('1002', '1070', '1');
INSERT INTO `shop_item` VALUES ('1002', '1080', '1');
INSERT INTO `shop_item` VALUES ('1002', '1090', '1');
INSERT INTO `shop_item` VALUES ('1002', '4000', '1');
INSERT INTO `shop_item` VALUES ('1002', '4010', '1');
INSERT INTO `shop_item` VALUES ('1002', '4020', '1');
INSERT INTO `shop_item` VALUES ('1003', '2000', '1');
INSERT INTO `shop_item` VALUES ('1003', '2010', '1');
INSERT INTO `shop_item` VALUES ('1003', '2020', '1');
INSERT INTO `shop_item` VALUES ('1003', '2030', '1');
INSERT INTO `shop_item` VALUES ('1003', '2040', '1');
INSERT INTO `shop_item` VALUES ('1003', '2050', '1');
INSERT INTO `shop_item` VALUES ('1003', '2060', '1');
INSERT INTO `shop_item` VALUES ('1003', '2070', '1');
INSERT INTO `shop_item` VALUES ('1003', '2080', '1');
INSERT INTO `shop_item` VALUES ('1003', '2090', '1');
INSERT INTO `shop_item` VALUES ('1003', '2100', '1');
INSERT INTO `shop_item` VALUES ('1003', '2110', '1');
INSERT INTO `shop_item` VALUES ('1003', '2120', '1');
INSERT INTO `shop_item` VALUES ('1003', '8000', '50');
INSERT INTO `shop_item` VALUES ('1003', '8000', '200');
INSERT INTO `shop_item` VALUES ('1004', '3000', '1');
INSERT INTO `shop_item` VALUES ('1004', '3010', '1');
INSERT INTO `shop_item` VALUES ('1004', '3020', '1');
INSERT INTO `shop_item` VALUES ('1004', '3030', '1');
INSERT INTO `shop_item` VALUES ('1004', '3040', '1');
INSERT INTO `shop_item` VALUES ('1004', '3050', '1');
INSERT INTO `shop_item` VALUES ('1004', '3060', '1');
INSERT INTO `shop_item` VALUES ('1004', '3070', '1');
INSERT INTO `shop_item` VALUES ('1004', '3080', '1');
INSERT INTO `shop_item` VALUES ('1004', '3090', '1');
INSERT INTO `shop_item` VALUES ('1004', '3100', '1');
INSERT INTO `shop_item` VALUES ('1004', '3110', '1');
INSERT INTO `shop_item` VALUES ('1004', '3120', '1');
INSERT INTO `shop_item` VALUES ('1005', '5000', '1');
INSERT INTO `shop_item` VALUES ('1005', '5010', '1');
INSERT INTO `shop_item` VALUES ('1005', '5020', '1');
INSERT INTO `shop_item` VALUES ('1005', '5030', '1');
INSERT INTO `shop_item` VALUES ('1005', '5040', '1');
INSERT INTO `shop_item` VALUES ('1005', '5050', '1');
INSERT INTO `shop_item` VALUES ('1005', '5060', '1');
INSERT INTO `shop_item` VALUES ('1005', '5070', '1');
INSERT INTO `shop_item` VALUES ('1005', '5080', '1');
INSERT INTO `shop_item` VALUES ('1006', '7000', '1');
INSERT INTO `shop_item` VALUES ('1006', '7010', '1');
INSERT INTO `shop_item` VALUES ('1006', '7020', '1');
INSERT INTO `shop_item` VALUES ('1006', '7030', '1');
INSERT INTO `shop_item` VALUES ('1006', '7040', '1');
INSERT INTO `shop_item` VALUES ('1006', '7050', '1');
INSERT INTO `shop_item` VALUES ('1006', '7060', '1');
INSERT INTO `shop_item` VALUES ('1006', '7070', '1');
INSERT INTO `shop_item` VALUES ('1006', '7080', '1');
INSERT INTO `shop_item` VALUES ('1006', '7090', '1');
INSERT INTO `shop_item` VALUES ('1006', '7100', '1');
INSERT INTO `shop_item` VALUES ('1006', '7110', '1');
INSERT INTO `shop_item` VALUES ('1006', '7120', '1');
INSERT INTO `shop_item` VALUES ('1007', '11200', '1');
INSERT INTO `shop_item` VALUES ('1007', '11210', '1');
INSERT INTO `shop_item` VALUES ('1007', '11220', '1');
INSERT INTO `shop_item` VALUES ('1007', '11230', '1');
INSERT INTO `shop_item` VALUES ('1007', '11240', '1');
INSERT INTO `shop_item` VALUES ('1007', '11250', '1');
INSERT INTO `shop_item` VALUES ('1007', '11260', '1');
INSERT INTO `shop_item` VALUES ('1008', '11400', '1');
INSERT INTO `shop_item` VALUES ('1008', '11410', '1');
INSERT INTO `shop_item` VALUES ('1008', '11420', '1');
INSERT INTO `shop_item` VALUES ('1008', '11430', '1');
INSERT INTO `shop_item` VALUES ('1008', '11440', '1');
INSERT INTO `shop_item` VALUES ('1008', '11450', '1');
INSERT INTO `shop_item` VALUES ('1008', '11460', '1');
INSERT INTO `shop_item` VALUES ('1009', '11600', '1');
INSERT INTO `shop_item` VALUES ('1009', '11610', '1');
INSERT INTO `shop_item` VALUES ('1009', '11620', '1');
INSERT INTO `shop_item` VALUES ('1009', '11630', '1');
INSERT INTO `shop_item` VALUES ('1009', '11640', '1');
INSERT INTO `shop_item` VALUES ('1009', '11650', '1');
INSERT INTO `shop_item` VALUES ('1009', '11660', '1');
INSERT INTO `shop_item` VALUES ('1010', '11800', '1');
INSERT INTO `shop_item` VALUES ('1010', '11810', '1');
INSERT INTO `shop_item` VALUES ('1010', '11820', '1');
INSERT INTO `shop_item` VALUES ('1010', '11830', '1');
INSERT INTO `shop_item` VALUES ('1010', '11840', '1');
INSERT INTO `shop_item` VALUES ('1010', '11850', '1');
INSERT INTO `shop_item` VALUES ('1010', '11860', '1');
INSERT INTO `shop_item` VALUES ('1011', '12200', '1');
INSERT INTO `shop_item` VALUES ('1011', '12220', '1');
INSERT INTO `shop_item` VALUES ('1011', '12240', '1');
INSERT INTO `shop_item` VALUES ('1012', '12340', '1');
INSERT INTO `shop_item` VALUES ('1012', '12360', '1');
INSERT INTO `shop_item` VALUES ('1012', '12380', '1');
INSERT INTO `shop_item` VALUES ('1013', '12480', '1');
INSERT INTO `shop_item` VALUES ('1013', '12500', '1');
INSERT INTO `shop_item` VALUES ('1013', '12520', '1');
INSERT INTO `shop_item` VALUES ('1014', '12620', '1');
INSERT INTO `shop_item` VALUES ('1014', '12640', '1');
INSERT INTO `shop_item` VALUES ('1014', '12660', '1');
INSERT INTO `shop_item` VALUES ('1015', '13000', '1');
INSERT INTO `shop_item` VALUES ('1015', '13040', '1');
INSERT INTO `shop_item` VALUES ('1016', '14000', '1');
INSERT INTO `shop_item` VALUES ('1016', '14020', '1');
INSERT INTO `shop_item` VALUES ('1016', '14040', '1');
INSERT INTO `shop_item` VALUES ('1016', '14060', '1');
INSERT INTO `shop_item` VALUES ('1016', '14080', '1');
INSERT INTO `shop_item` VALUES ('1016', '14100', '1');
INSERT INTO `shop_item` VALUES ('1016', '14120', '1');
INSERT INTO `shop_item` VALUES ('1016', '14140', '1');
INSERT INTO `shop_item` VALUES ('1016', '14160', '1');
INSERT INTO `shop_item` VALUES ('1016', '14180', '1');
INSERT INTO `shop_item` VALUES ('1016', '14200', '1');
INSERT INTO `shop_item` VALUES ('1017', '15000', '1');
INSERT INTO `shop_item` VALUES ('1017', '15020', '1');
INSERT INTO `shop_item` VALUES ('1017', '15040', '1');
INSERT INTO `shop_item` VALUES ('1017', '15060', '1');
INSERT INTO `shop_item` VALUES ('1017', '15080', '1');
INSERT INTO `shop_item` VALUES ('1017', '15100', '1');
INSERT INTO `shop_item` VALUES ('1017', '15120', '1');
INSERT INTO `shop_item` VALUES ('1017', '15140', '1');
INSERT INTO `shop_item` VALUES ('1017', '15160', '1');
INSERT INTO `shop_item` VALUES ('1017', '15180', '1');
INSERT INTO `shop_item` VALUES ('1017', '15200', '1');
INSERT INTO `shop_item` VALUES ('1017', '15220', '1');
INSERT INTO `shop_item` VALUES ('1018', '16000', '1');
INSERT INTO `shop_item` VALUES ('1018', '16020', '1');
INSERT INTO `shop_item` VALUES ('1018', '16040', '1');
INSERT INTO `shop_item` VALUES ('1018', '16060', '1');
INSERT INTO `shop_item` VALUES ('1018', '16080', '1');
INSERT INTO `shop_item` VALUES ('1018', '16100', '1');
INSERT INTO `shop_item` VALUES ('1018', '16120', '1');
INSERT INTO `shop_item` VALUES ('1018', '16140', '1');
INSERT INTO `shop_item` VALUES ('1018', '16160', '1');
INSERT INTO `shop_item` VALUES ('1018', '16180', '1');
INSERT INTO `shop_item` VALUES ('1018', '16200', '1');
INSERT INTO `shop_item` VALUES ('1019', '17000', '1');
INSERT INTO `shop_item` VALUES ('1019', '17020', '1');
INSERT INTO `shop_item` VALUES ('1019', '17040', '1');
INSERT INTO `shop_item` VALUES ('1019', '17060', '1');
INSERT INTO `shop_item` VALUES ('1019', '17080', '1');
INSERT INTO `shop_item` VALUES ('1019', '17100', '1');
INSERT INTO `shop_item` VALUES ('1019', '17120', '1');
INSERT INTO `shop_item` VALUES ('1019', '17140', '1');
INSERT INTO `shop_item` VALUES ('1019', '17160', '1');
INSERT INTO `shop_item` VALUES ('1019', '17180', '1');
INSERT INTO `shop_item` VALUES ('1019', '17200', '1');
  • Metin2 Dev 17
  • Love 47
  • Love 4
  • Good 10
  • Think 2
  • Smile Tear 1
  • Angry 1
  • Dislove 1

Currently working on my FreeBSD blog:

FreeBSD is Fun, practical tutorials and articles

⚠️                Are you under attack?               ⚠️

Link to comment
Share on other sites

  • Premium

It should work with 40k, but I have no idea if 40k has new tables.

 

This is just the structure, I will add the basic tables necessary to run a server pre filled with official values such as skill_proto, object etc. when I have time.

Currently working on my FreeBSD blog:

FreeBSD is Fun, practical tutorials and articles

⚠️                Are you under attack?               ⚠️

Link to comment
Share on other sites

 

Since many people may need it, here's my complete official db structure for game 34k, including:

 

- All Indexes and Options included

- All auto increment values are set to 1 (except player that is set to 100 to avoid some issues)

- Some non-fatal errors caused by original YMIR table structure are fixed

 

When not busy please dump with standart INSERT.

Link to comment
Share on other sites

I have edited the query. Please try again.

 

Again same error.  I now see, error is :

 

NOT NULL DEFAULT 'BLABLA'

need make NULL then work.

 

 

*Edit*

 

I edit some line and Query work now without make NULL : 


DROP TABLE IF EXISTS `skill_proto`;
CREATE TABLE `skill_proto` (
`dwVnum` int(11) NOT NULL DEFAULT '0',
`szName` varchar(32) NOT NULL DEFAULT '',
`bType` tinyint(4) NOT NULL DEFAULT '0',
`bLevelStep` tinyint(4) NOT NULL DEFAULT '0',
`bMaxLevel` tinyint(4) NOT NULL DEFAULT '0',
`bLevelLimit` tinyint(3) unsigned NOT NULL DEFAULT '0',
`szPointOn` varchar(100) NOT NULL DEFAULT '0',
`szPointPoly` varchar(100) NOT NULL DEFAULT '',
`szSPCostPoly` varchar(100) NOT NULL DEFAULT '',
`szDurationPoly` varchar(100) NOT NULL DEFAULT '',
`szDurationSPCostPoly` varchar(100) NOT NULL DEFAULT '',
`szCooldownPoly` varchar(100) NOT NULL DEFAULT '',
`szMasterBonusPoly` varchar(100) NOT NULL DEFAULT '',
`szAttackGradePoly` varchar(100) NOT NULL DEFAULT '',
`setFlag` set('ATTACK','USE_MELEE_DAMAGE','COMPUTE_ATTGRADE','SELFONLY','USE_MAGIC_DAMAGE','USE_HP_AS_COST','COMPUTE_MAGIC_DAMAGE','SPLASH','GIVE_PENALTY','USE_ARROW_DAMAGE','PENETRATE','IGNORE_TARGET_RATING','ATTACK_SLOW','ATTACK_STUN','HP_ABSORB','SP_ABSORB','ATTACK_FIRE_CONT','REMOVE_BAD_AFFECT','REMOVE_GOOD_AFFECT','CRUSH','ATTACK_POISON','TOGGLE','DISABLE_BY_POINT_UP','CRUSH_LONG') DEFAULT NULL,
`setAffectFlag` enum('YMIR','INVISIBILITY','SPAWN','POISON','SLOW','STUN','DUNGEON_READY','FORCE_VISIBLE','BUILDING_CONSTRUCTION_SMALL','BUILDING_CONSTRUCTION_LARGE','BUILDING_UPGRADE','MOV_SPEED_POTION','ATT_SPEED_POTION','FISH_MIDE','JEONGWIHON','GEOMGYEONG','CHEONGEUN','GYEONGGONG','EUNHYUNG','GWIGUM','TERROR','JUMAGAP','HOSIN','BOHO','KWAESOK','MANASHIELD','MUYEONG','REVIVE_INVISIBLE','FIRE','GICHEON','JEUNGRYEOK','') DEFAULT NULL,
`szPointOn2` varchar(100) NOT NULL DEFAULT 'NONE',
`szPointPoly2` varchar(100) NOT NULL DEFAULT '',
`szDurationPoly2` varchar(100) NOT NULL DEFAULT '',
`setAffectFlag2` enum('YMIR','INVISIBILITY','SPAWN','POISON','SLOW','STUN','DUNGEON_READY','FORCE_VISIBLE','BUILDING_CONSTRUCTION_SMALL','BUILDING_CONSTRUCTION_LARGE','BUILDING_UPGRADE','MOV_SPEED_POTION','ATT_SPEED_POTION','FISH_MIDE','JEONGWIHON','GEOMGYEONG','CHEONGEUN','GYEONGGONG','EUNHYUNG','GWIGUM','TERROR','JUMAGAP','HOSIN','BOHO','KWAESOK','MANASHIELD','') NOT NULL DEFAULT 'YMIR',
`szPointOn3` varchar(100) NOT NULL DEFAULT 'NONE',
`szPointPoly3` varchar(100) NOT NULL DEFAULT '',
`szDurationPoly3` varchar(100) NOT NULL DEFAULT '',
`szGrandMasterAddSPCostPoly` varchar(100) NOT NULL DEFAULT '',
`prerequisiteSkillVnum` int(11) NOT NULL DEFAULT '0',
`prerequisiteSkillLevel` int(11) NOT NULL DEFAULT '0',
`eSkillType` enum('NORMAL','MELEE','RANGE','MAGIC','') NOT NULL DEFAULT 'NORMAL',
`iMaxHit` tinyint(4) NOT NULL DEFAULT '0',
`szSplashAroundDamageAdjustPoly` varchar(100) NOT NULL DEFAULT '1',
`dwTargetRange` int(11) NOT NULL DEFAULT '1000',
`dwSplashRange` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`dwVnum`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of skill_proto
-- ----------------------------
INSERT INTO `skill_proto` VALUES ('1', '»ï¿¬Âü', '1', '1', '1', '0', 'HP', '-( 1.1*atk + (0.5*atk +  1.5 * str)*k)', '40+100*k', '', '', '12', '-( 1.1*atk + (0.5*atk +  1.5 * str)*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '40+100*k', '0', '0', 'MELEE', '5', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('2', 'Æȹædz¿ì', '1', '1', '1', '0', 'HP', '-(3*atk + (0.8*atk + str*5 + dex*3 +con)*k)', '50+130*k', '', '', '15', '-(3*atk + (0.8*atk + str*5 + dex*3 +con)*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '50+130*k', '0', '0', 'MELEE', '12', '1', '0', '200');
INSERT INTO `skill_proto` VALUES ('3', 'Àü±ÍÈ¥', '1', '1', '1', '0', 'ATT_SPEED', '50*k', '50+140*k', '60+90*k', '', '63+10*k', '50*k', '', 'SELFONLY', 'JEONGWIHON', 'MOV_SPEED', '20*k', '60+90*k', '', '', '', '', '50+140*k', '0', '0', 'NORMAL', '1', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('4', '°Ë°æ', '1', '1', '1', '0', 'ATT_GRADE', '(100 + str + lv * 3)*k', '100+200*k', '30+50*k', '', '30+10*k', '(100 + str + lv * 3)*k', '', 'SELFONLY', 'GEOMGYEONG', 'NONE', '', '', '', '', '', '', '100+200*k', '0', '0', 'NORMAL', '1', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('5', 'źȯ°Ý', '1', '1', '1', '0', 'HP', '-(2*atk + (atk + dex*3 + str*7 + con)*k)', '60+120*k', '', '', '12', '-(2*atk + (atk + dex*3 + str*7 + con)*k)', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH', '', 'MOV_SPEED', '150', '3', '', '', '', '', '60+120*k', '0', '0', 'MELEE', '4', '1', '0', '200');
INSERT INTO `skill_proto` VALUES ('16', '±â°øÂü', '1', '1', '1', '0', 'HP', '-(2.3*atk + (4*atk  + str*4 + con)*k)', '60+120*k', '', '', '15', '-(2.3*atk + (4*atk  + str*4 + con)*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '60+120*k', '0', '0', 'MELEE', '4', '1', '0', '100');
INSERT INTO `skill_proto` VALUES ('17', '°Ý»êŸ¿ì', '1', '1', '1', '0', 'HP', '-(2.3*atk + (3*atk + str*4 + con*3)*k)', '60+150*k', '', '', '15', '-(2.3*atk + (3*atk + str*4 + con*3)*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '60+150*k', '0', '0', 'MELEE', '8', '1', '0', '200');
INSERT INTO `skill_proto` VALUES ('18', '´ëÁø°¢', '1', '1', '1', '0', 'HP', '-(2*atk + (2*atk + 2*dex + 2*con + str*4)*k)', '50+140*k', '', '', '25', '-(2*atk + (2*atk + 2*dex + 2*con + str*4)*k)', '', 'ATTACK,USE_MELEE_DAMAGE,SELFONLY,SPLASH,ATTACK_STUN', '', 'NONE', '100+k*1000/6', '2', '', '', '', '', '50+140*k', '0', '0', 'MELEE', '10', '1', '0', '400');
INSERT INTO `skill_proto` VALUES ('19', 'õ±ÙÃß', '1', '1', '1', '0', 'DEF_GRADE', '(200 + str*0.2 + con*0.5 ) *k', '80+220*k', '60+90*k', '', '63+10*k', '(200 + str*0.2 + con*0.5 ) *k', '', 'SELFONLY', 'CHEONGEUN', 'MOV_SPEED', '-(1+9*k)', '60+90*k', '', '', '', '', '80+220*k', '0', '0', 'NORMAL', '1', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('20', '°Ëdz', '1', '1', '1', '0', 'HP', '-(2*atk + (atk + dex*3 + str*5 + con)*k)', '40+120*k', '', '', '20', '-(2*atk + (atk + dex*3 + str*5 + con)*k)', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH', '', 'NONE', '', '', '', '', '', '', '40+120*k', '0', '0', 'MELEE', '10', '0.5', '1200', '200');
INSERT INTO `skill_proto` VALUES ('31', '¾Ï½À', '2', '1', '1', '0', 'HP', '-(atk + (1.2 * atk + number(500, 700) + dex*4+ str*4 )*k)', '40+160*k', '', '', '15', '-(atk + (1.2 * atk + number(500, 700) + dex*4+ str*4 )*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '40+160*k', '0', '0', 'MELEE', '6', '0.8', '0', '0');
INSERT INTO `skill_proto` VALUES ('32', '±Ã½Åź¿µ', '2', '1', '1', '0', 'HP', '-(atk + (1.6* atk + number(200,300) + dex*7 + str*7)*k)', '40+160*k', '', '', '20', '-(atk + (1.6* atk + number(200,300) + dex*7 + str*7)*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '40+160*k', '0', '0', 'MELEE', '6', '0.8', '800', '0');
INSERT INTO `skill_proto` VALUES ('33', 'Â÷·û»ì', '2', '1', '1', '0', 'HP', '-(2*atk + (0.5*atk + dex*9 + str*7)*k)', '50+140*k', '', '', '25', '-(2*atk + (0.5*atk + dex*9 + str*7)*k)', '', 'ATTACK,USE_MELEE_DAMAGE,ATTACK_POISON', '', 'NONE', '40*k', '', '', '', '', '', '50+140*k', '0', '0', 'MELEE', '12', '0.8', '0', '0');
INSERT INTO `skill_proto` VALUES ('34', 'ÀºÇü¹ý', '2', '1', '1', '0', 'NONE', '', '30+60*k', '15+30*k', '', '60', '', '', 'SELFONLY', 'EUNHYUNG', 'NONE', '', '', '', '', '', '', '30+60*k', '0', '0', 'NORMAL', '1', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('35', '»ê°øºÐ', '2', '1', '1', '0', 'HP', '-(lv*2+(atk + str*3 + dex*18)*k)', '40+130*k', '', '', '25', '-(lv*2+(atk + str*3 + dex*18)*k)', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,ATTACK_POISON', '', 'NONE', '60*k', '5+25*k', '', '', '', '', '40+130*k', '0', '0', 'MAGIC', '0', '0.5', '800', '200');
INSERT INTO `skill_proto` VALUES ('46', '¿¬»ç', '2', '1', '1', '0', 'HP', '-(atk + 0.3*atk*floor(2+k*6)+ (0.8*atk+dex*8*ar) *k)', '40+130*k', '', '', '15', '-(atk + 0.2*atk*floor(2+k*6)+ (0.8*atk+dex*8*ar) *k)', '', 'ATTACK,USE_ARROW_DAMAGE', '', 'NONE', '', '', '', '', '', '', '40+130*k', '0', '0', 'RANGE', '1', '1', '2500', '0');
INSERT INTO `skill_proto` VALUES ('47', '°ü°Ý¼ú', '2', '1', '1', '0', 'HP', '-(atk + (1.9*atk + dex*2+ str*2)*k)', '30+130*k', '', '', '12', '-(atk + (1.7*atk + dex*2+ str*2)*k)', '', 'ATTACK,USE_ARROW_DAMAGE', '', 'NONE', '', '', '', '', '', '', '30+130*k', '0', '0', 'RANGE', '8', '1', '2500', '0');
INSERT INTO `skill_proto` VALUES ('48', 'È­Á¶ÆÄ', '2', '1', '1', '0', 'HP', '-(1.5*atk + (2.8*atk + number(100, 300))*k)', '50+130*k', '', '', '25', '-(1.5*atk + (2.6*atk + number(100, 300))*k)', '', 'ATTACK,SPLASH,USE_ARROW_DAMAGE', '', 'NONE', '', '', '', '', '', '', '50+130*k', '0', '0', 'RANGE', '12', '0.6', '2500', '300');
INSERT INTO `skill_proto` VALUES ('49', '°æ°ø¼ú', '2', '1', '1', '0', 'MOV_SPEED', '60*k', '30+40*k', '15+30*k', '', '30+30*k', '60*k', '', 'SELFONLY', 'GYEONGGONG', 'NONE', '', '', '', '', '', '', '30+40*k', '0', '0', 'NORMAL', '1', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('50', 'µ¶±â±Ã', '2', '1', '1', '0', 'HP', '-(atk + (1.5*atk + number(100, 200)+dex*6+str*2)*k)', '40+160*k', '', '', '25', '-(atk + (1.2*atk + number(100, 200)+dex*6+str*2)*k)', '', 'ATTACK,SPLASH,USE_ARROW_DAMAGE,CRUSH,ATTACK_POISON', '', 'NONE', '80*k', '15+30*k', '', '', '', '', '40+160*k', '0', '0', 'RANGE', '12', '0.5', '2500', '300');
INSERT INTO `skill_proto` VALUES ('61', '¼â·ÉÁö', '3', '1', '1', '0', 'HP', '-(atk + 2*lv + iq*2 + ( 2*atk + str*4 + iq*14) * k)', '30+140*k', '', '', '10', '-(atk + 2*lv + iq*2 + ( 2*atk + str*4 + iq*14) * k)', '', 'ATTACK,USE_MELEE_DAMAGE,PENETRATE', '', 'NONE', '1+k*9', '', '', '', '', '', '30+140*k', '0', '0', 'MELEE', '4', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('62', '¿ë±ÇÆÄ', '3', '1', '1', '0', 'HP', '-(1.1 * atk + 2*lv + iq*2+(1.5*atk + str + iq*12) * k)', '50+150*k', '', '', '15', '-(1.1 * atk + 2*lv + iq*2+(1.5*atk + str + iq*12) * k)', '', 'ATTACK,USE_MELEE_DAMAGE,SELFONLY,SPLASH,IGNORE_TARGET_RATING', '', 'NONE', '1+k*9', '', '', '', '', '', '50+150*k', '0', '0', 'MELEE', '12', '1', '0', '500');
INSERT INTO `skill_proto` VALUES ('63', '±Í°Ë', '3', '1', '1', '0', 'ATT_GRADE', '(3 * iq + 2 * lv)*k', '20+240*k', '50+100*k', '2+23*k', '0', '(3 * iq + 2 * lv)*k', '', 'SELFONLY,TOGGLE', 'GWIGUM', 'HIT_HP_RECOVER', '10*k', '50+80*k', '', '', '', '', '20+240*k', '0', '0', 'NORMAL', '1', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('64', '°øÆ÷', '3', '1', '1', '0', 'DODGE', '1 + 29 * k', '60+120*k', '60+100*k', '', '100', '1 + 29 * k', '', 'SELFONLY', 'TERROR', 'NONE', '', '', '', '', '', '', '60+120*k', '0', '0', 'NORMAL', '1', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('65', 'ÁÖ¸¶°©', '3', '1', '1', '0', 'DEF_GRADE', '(iq+30)*k', '70+170*k', '30+120*k', '', '33+140*k', '(iq+30)*k', '', 'SELFONLY', 'JUMAGAP', 'REFLECT_MELEE', '(iq/4+10)*k', '30+120*k', '', '', '', '', '70+170*k', '0', '0', 'NORMAL', '1', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('66', 'ÆĹý¼ú', '3', '1', '1', '0', 'HP', '-(40 +5*lv + 2*iq+(10*iq + 7*mwep + number(50,100) )*ar*k)', '30+120*k', '', '', '12', '-(40 +5*lv + 2*iq+(10*iq + 7*mwep + number(50,100) )*ar*k)', '', 'ATTACK,COMPUTE_MAGIC_DAMAGE,SPLASH,REMOVE_GOOD_AFFECT', '', 'NONE', '10+40*k', '7+23*k', '', '', '', '', '30+120*k', '0', '0', 'NORMAL', '5', '0.6', '1800', '200');
INSERT INTO `skill_proto` VALUES ('76', '¸¶·É', '3', '1', '1', '0', 'HP', '-(40 +5*lv + 2*iq +(13*iq + 6*mwep + number(50,100) )*ar*k)', '30+140*k', '', '', '7', '-(40 +5*lv + 2*iq +(13*iq + 6*mwep + number(50,100) )*ar*k)', '', 'ATTACK,COMPUTE_MAGIC_DAMAGE,SPLASH', '', 'NONE', '', '', '', '', '', '', '30+140*k', '0', '0', 'MAGIC', '5', '0.6', '1500', '200');
INSERT INTO `skill_proto` VALUES ('77', 'È­¿°Æø', '3', '1', '1', '0', 'HP', '-(5*lv + 2*iq+(10*iq + 6*mwep + str*4 + con*2 + number(180,200) )*k)', '60+140*k', '', '', '12', '-(5*lv + 2*iq+(10*iq + 6*mwep + str*4 + con*2 + number(180,200) )*k)', '', 'ATTACK,SELFONLY,COMPUTE_MAGIC_DAMAGE,SPLASH', '', 'NONE', '', '', '', '', '', '', '60+140*k', '0', '0', 'MAGIC', '15', '0.8', '0', '500');
INSERT INTO `skill_proto` VALUES ('78', '¹«¿µÁø', '3', '1', '1', '0', 'HP', '-(30+ 2*lv + 2*iq+(7*iq + 6*mwep + number(200,500))*ar*k)', '20+30*k', '40+30*k', '5+40*k', '43+30*k', '-(30+ 2*lv + 2*iq+(7*iq + 6*mwep + number(200,500))*ar*k)', '', 'ATTACK,COMPUTE_MAGIC_DAMAGE,SPLASH,TOGGLE', '', 'NONE', '', '', '', '', '', '', '20+30*k', '0', '0', 'MAGIC', '1', '1', '800', '0');
INSERT INTO `skill_proto` VALUES ('79', 'Èæ½Å¼öÈ£', '3', '1', '1', '0', 'DEF_GRADE', '(0.5*iq+15)*k', '20+30*k', '60+120*k', '5+10*k', '63+10*k', '(0.5*iq+15)*k', '', 'SELFONLY,TOGGLE', 'MANASHIELD', 'MANASHIELD', '100-((iq*0.84)*k)', '60+10*k', '', '', '', '', '20+30*k', '0', '0', 'MAGIC', '1', '0.8', '0', '0');
INSERT INTO `skill_proto` VALUES ('80', 'Åõ¼Ó¸¶·É', '3', '1', '1', '0', 'HP', '-(40 + 2* lv + 2*iq +(2 * con + 2 * dex + 13*iq + 6*mwep + number(180, 200))*ar*k)', '40+120*k', '', '', '12', '-(40 + 2* lv + 2*iq +(2 * con + 2 * dex + 13*iq + 6*mwep + number(180, 200))*ar*k)', '', 'ATTACK,COMPUTE_MAGIC_DAMAGE,SPLASH,ATTACK_SLOW', '', 'NONE', '333+300*k', '10+10*k', '', '', '', '', '40+120*k', '0', '0', 'MAGIC', '9', '0.8', '1200', '400');
INSERT INTO `skill_proto` VALUES ('81', '¸¶È¯°Ý', '3', '1', '1', '0', 'HP', '-(120 + 6*lv + (5 * con + 5 * dex + 29*iq + 9*mwep)*ar*k)', '80+220*k', '', '', '24', '-(120 + 6*lv + (5 * con + 5 * dex + 29*iq + 9*mwep)*ar*k)', '', 'ATTACK,COMPUTE_MAGIC_DAMAGE,SPLASH', '', 'NONE', '', '', '', '', '', '', '80+220*k', '0', '0', 'MAGIC', '9', '0.4', '1500', '200');
INSERT INTO `skill_proto` VALUES ('91', 'ºñÆĺÎ', '4', '1', '1', '0', 'HP', '-(70 + 4*lv + (20*iq+5*mwep+50)*ar*k)', '30+160*k', '', '', '7', '-(70 + 4*lv + (20*iq+5*mwep+50)*ar*k)', '', 'ATTACK,COMPUTE_MAGIC_DAMAGE,SPLASH', '', 'NONE', '', '', '', '', '', '', '30+160*k', '0', '0', 'MAGIC', '5', '0.5', '1800', '201');
INSERT INTO `skill_proto` VALUES ('92', '¿ëÆÄ»ê', '4', '1', '1', '0', 'HP', '-(60 + 5*lv + (18*iq + 6*mwep + 120)*ar*k)', '50+160*k', '', '', '8', '-(60 + 5*lv + (18*iq + 6*mwep + 120)*ar*k)', '', 'ATTACK,ATTACK_FIRE_CONT', '', 'NONE', 'lv+5*iq *k', 'iq*0.2*k', '', '', '', '', '50+160*k', '0', '0', 'MAGIC', '10', '0.8', '0', '0');
INSERT INTO `skill_proto` VALUES ('93', 'ÆзæÆø', '4', '1', '1', '0', 'HP', '-(80 + 6*lv + (20*iq+14*mwep+120)*ar*k)', '50+160*k', '', '', '20', '-(80 + 6*lv + (20*iq+14*mwep+120)*ar*k)', '', 'ATTACK,SELFONLY,SPLASH,ATTACK_FIRE_CONT', '', 'NONE', 'lv+5*iq *k', 'iq*0.2*k', '', '', '', '', '50+160*k', '0', '0', 'MAGIC', '15', '0.8', '0', '500');
INSERT INTO `skill_proto` VALUES ('94', 'È£½Å', '4', '1', '1', '0', 'RESIST_NORMAL', '(iq*0.3+5)*(2*k+0.5)/(k+1.5)', '40+160*k', '60+200*k', '', '10', '(iq*0.3+5)*(2*k+0.5)/(k+1.5)', '', '', 'HOSIN', 'NONE', '', '', '', '', '', '', '40+160*k', '0', '0', 'NORMAL', '1', '1', '800', '0');
INSERT INTO `skill_proto` VALUES ('95', '¹Ý»ç', '4', '1', '1', '0', 'REFLECT_MELEE', '5+(iq*0.3 + 5)*k', '40+160*k', '60+200*k', '', '10', '5+(iq*0.3 + 5)*k', '', '', 'BOHO', 'NONE', '', '', '', '', '', '', '40+160*k', '0', '0', 'NORMAL', '1', '1', '1000', '0');
INSERT INTO `skill_proto` VALUES ('96', '±âõ´ë°ø', '4', '1', '1', '0', 'CRITICAL', '(iq*0.3+5)*(2*k+0.5)/(k+1.5)', '40+160*k', '60+100*k', '', '10', '(iq*0.3+5)*(2*k+0.5)/(k+1.5)', '', '', 'GICHEON', 'NONE', '', '', '', '', '', '', '40+160*k', '0', '0', 'NORMAL', '1', '1', '1000', '0');
INSERT INTO `skill_proto` VALUES ('106', '³úÀü·É', '4', '1', '1', '0', 'HP', '-(60 + 4*lv + (7*iq+8*mwep+number(iq*5,iq*15))*ar*k)', '30+150*k', '', '', '7', '-(60 + 4*lv + (7*iq+8*mwep+number(iq*5,iq*15))*ar*k)', '', 'ATTACK,SPLASH', '', 'NONE', '', '', '', '', '', '', '30+150*k', '0', '0', 'MAGIC', '5', '0.6', '1800', '200');
INSERT INTO `skill_proto` VALUES ('107', 'º­¶ô', '4', '1', '1', '0', 'HP', '-(40 + 4*lv + (13*iq+7*mwep+number(iq*5,iq*16))*ar*k)', '50+150*k', '', '', '15', '-(40 + 4*lv + (13*iq+7*mwep+number(iq*5,iq*16))*ar*k)', '', 'ATTACK,SPLASH,ATTACK_STUN', '', 'NONE', '50+1000*k/6', '5', '', '', '', '', '50+150*k', '0', '0', 'MAGIC', '15', '0.8', '1500', '400');
INSERT INTO `skill_proto` VALUES ('108', 'Æø·Ú°Ý', '4', '1', '1', '0', 'HP', '-(50 + 5*lv + (6*iq+6*mwep+number(1,800))*ar*k) * (1-chain*0.13)', '40+180*k', '', '', '10', '-(50 + 5*lv + (6*iq+6*mwep+number(1,800))*ar*k) * (1-chain*0.13)', '', 'ATTACK', '', 'NONE', '', '', '', '', '', '', '40+180*k', '0', '0', 'MAGIC', '7', '0.8', '2500', '0');
INSERT INTO `skill_proto` VALUES ('109', 'Á¤¾÷ÀÎ', '4', '1', '1', '0', 'HP', '200+7*lv+(30*iq+6*mwep+600)*k', '40+200*k', '', '', '10', '200+7*lv+(30*iq+6*mwep+600)*k', '', 'REMOVE_BAD_AFFECT', '', 'NONE', '20+80*k', '0', '', '', '', '', '40+200*k', '0', '0', 'NORMAL', '1', '1', '1000', '0');
INSERT INTO `skill_proto` VALUES ('110', 'Äè¼Ó', '4', '1', '1', '0', 'MOV_SPEED', '5 + 35*k', '60+120*k', '60+100*k', '', '10', '5 + 35*k', '', '', 'KWAESOK', 'CASTING_SPEED', '3+33*k', '60+100*k', '', '', '', '', '60+120*k', '0', '0', 'NORMAL', '1', '1', '1000', '0');
INSERT INTO `skill_proto` VALUES ('111', 'Áõ·Â¼ú', '4', '1', '1', '0', 'ATT_GRADE', '10+(iq*0.4 +20)*k', '60+120*k', '60+100*k', '', '10', '10+(iq*0.4 +30)*k', '', '', 'JEUNGRYEOK', 'NONE', '', '', '', '', '', '', '60+120*k', '0', '0', 'NORMAL', '1', '1', '1000', '0');
INSERT INTO `skill_proto` VALUES ('121', 'Åë¼Ö·Â', '0', '1', '40', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('122', '¿¬°è±â', '0', '1', '2', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('124', '䱤¼ú', '0', '1', '40', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('125', 'º¯½Å', '0', '1', '40', '0', 'NONE', '', '', '10+1000*k', '', '', '', '', 'DISABLE_BY_POINT_UP', 'YMIR', 'NONE', '', '', 'YMIR', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '1000', '0');
INSERT INTO `skill_proto` VALUES ('126', '½Å¼ö¾î', '0', '1', '20', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('127', 'õÁ¶¾î', '0', '1', '20', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('128', 'Áø³ë¾î', '0', '1', '20', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('129', 'µÐ°©¼ú', '0', '1', '40', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', 'NONE', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('130', '½Â¸¶', '0', '1', '1', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('131', '¸»¼Òȯ', '0', '1', '10', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('137', '³­¹«', '5', '1', '1', '50', 'HP', '-(atk+(2*atk*k))', '60+80*k', '', '', '5-(4*k)', '', '', 'ATTACK,USE_MELEE_DAMAGE,CRUSH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'MELEE', '10', '1', '300', '0');
INSERT INTO `skill_proto` VALUES ('138', 'µ¹°Ý', '5', '1', '1', '52', 'HP', '-(2.4*(200+1.5*lv)+(3*200*k))', '60+120*k', '', '', '15', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH_LONG', '', 'MOV_SPEED', '50', '5', '', '', '', '', '', '0', '0', 'MELEE', '6', '1', '400', '100');
INSERT INTO `skill_proto` VALUES ('139', 'Å»Ãâ', '5', '1', '1', '55', 'HP', '-(2*(200+1.5*lv)+(3*200*k))', '60+160*k', '', '', '20', '', '', 'ATTACK,USE_MELEE_DAMAGE,SELFONLY,SPLASH,CRUSH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'MELEE', '12', '1', '400', '250');
INSERT INTO `skill_proto` VALUES ('140', '³­¹«(È°)', '5', '1', '1', '50', 'HP', '-(atk+(2*atk*k))', '60+80*k', '', '', '10', '', '', 'ATTACK,USE_ARROW_DAMAGE,CRUSH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', '', '5', '1', '2500', '0');
INSERT INTO `skill_proto` VALUES ('151', '¿ë¾È', '0', '1', '7', '0', 'NONE', '', '', '', '', '', '', '', '', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('152', '¿ë½ÅÀÇÇÇ', '0', '1', '7', '0', 'MAX_HP', 'maxhp*0.2*k', '150+150*k', '300', '', '600', '', '', '', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('153', '¿ë½ÅÀÇÃູ', '0', '1', '7', '0', 'MAX_SP', 'maxsp*0.2*k', '150+150*k', '300', '', '600', '', '', '', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('154', '¼ºÈÖ°©', '0', '1', '7', '0', 'DEF_GRADE', 'odef*0.1*k', '150+150*k', '180', '', '480', '', '', '', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('155', '°¡¼ÓÈ­', '0', '1', '7', '0', 'MOV_SPEED', '15*k', '150+150*k', '180', '', '480', '', '', '', '', 'ATT_SPEED', '15*k', '180', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('156', '¿ë½ÅÀǺгë', '0', '1', '7', '0', 'CRITICAL', '50*k', '150+150*k', '180', '', '480', '', '', 'SELFONLY', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('157', 'ÁÖ¹®¼ú', '0', '1', '7', '0', 'CASTING_SPEED', '50*k', '150+150*k', '180', '', '480', '', '', 'SELFONLY', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('158', '±æµåÀ̵¿', '0', '1', '3', '0', 'NONE', '', '', '', '', '', '', '', 'SELFONLY', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('159', '°ø°£Àǹ®', '0', '1', '5', '0', 'NONE', '', '', '', '', '', '', '', 'SELFONLY', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('160', '°¡¼ÓÈ­', '0', '1', '5', '0', 'NONE', '3*k', '80-12*k', '300', '', '', '', '', 'SELFONLY', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('161', '°ø°£Àǹ®', '0', '1', '2', '0', 'NONE', '', '50', '', '', '', '', '', '', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('162', '°ø°£À̵¿', '0', '1', '2', '0', 'NONE', '', '20', '', '', '', '', '', '', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0');
INSERT INTO `skill_proto` VALUES ('256', 'CRUSH200½ºÅ³', '0', '1', '1', '0', 'HP', '-5*k*atk', '', '', '', '4', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'MELEE', '0', '1', '0', '300');
INSERT INTO `skill_proto` VALUES ('257', 'ÀϹݹüÀ§350½ºÅ³', '0', '1', '1', '0', 'HP', '-5*k*atk', '', '', '', '6', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'MELEE', '0', '1', '0', '525');
INSERT INTO `skill_proto` VALUES ('258', 'CRUSH300½ºÅ³', '0', '1', '1', '0', 'HP', '-5*k*atk', '', '', '', '8', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'MELEE', '0', '1', '0', '450');
INSERT INTO `skill_proto` VALUES ('259', 'ÀϹݹüÀ§200½ºÅ³', '0', '1', '1', '0', 'HP', '-5*k*atk', '', '', '', '10', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'MELEE', '0', '1', '0', '300');
INSERT INTO `skill_proto` VALUES ('260', 'CURSH400½ºÅ³', '0', '1', '1', '0', 'HP', '-5*k*atk', '', '', '', '12', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'MELEE', '0', '1', '0', '600');
INSERT INTO `skill_proto` VALUES ('261', 'µ¶250½ºÅ³', '0', '1', '1', '0', 'HP', '-5*k*atk', '', '', '', '10', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,ATTACK_POISON', '', 'NONE', '80', '', '', '', '', '', '', '0', '0', 'MELEE', '0', '1', '0', '375');
INSERT INTO `skill_proto` VALUES ('262', 'SLOW300½ºÅ³', '0', '1', '1', '0', 'HP', '-5*k*atk', '', '', '', '14', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH', '', 'MOV_SPEED', '-20', '10', '', '', '', '', '', '0', '0', 'MELEE', '0', '1', '0', '450');

Edited by Mehti
Link to comment
Share on other sites

  • 1 month later...
  • 3 months later...
  • 2 weeks later...
  • 4 weeks later...

Thank you, Shogun :)

Can someone tell me what are the differences between this skill proto and the official one? Because I also made many modifications in the skill proto and it would be a bit hard work for me to check every row.

Link to comment
Share on other sites

  • Recently Browsing   0 members

    • No registered users viewing this page.


  • Metin2 Dev Github
  • Activity

    1. 6

      Owsap Productions

    2. 11

      BUG SAFEBOX disappear stacks ..

    3. 2

      Error no member named SetcCreateTime in Citem

    4. 2

      Need some help with effect slot on pickup system

    5. 1

      GF Pet system "x" level / percent

    6. 1

      disable quest esc

    7. 2

      Navicat Premium 16.1.3 x64

    8. 2

      Join the Metin2 Dev team

    9. 2

      Error no member named SetcCreateTime in Citem

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.