Jump to content
Shogun

Metin2 db tables

Recommended Posts

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)

-- ----------------------------
-- 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)
 

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)
 

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)

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)

-- ----------------------------
-- 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');

  • Love 32

Share this post


Link to post

Does this work with 40k, too?

I've heard they have some new bonuses in 40k

Gesendet von meinem Nexus 5 mit Tapatalk

Share this post


Link to post

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.

Share this post


Link to post

Does this work with 40k, too?

I've heard they have some new bonuses in 40k

Gesendet von meinem Nexus 5 mit Tapatalk

Yes, it does.

Share this post


Link to post

 

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.

Share this post


Link to post

When not busy please dump with standart INSERT.

 

Working on that :)

  • Love 1

Share this post


Link to post

to use the player.sql you need to change InnoDB to MyISAM in the .sql file.

Share this post


Link to post

to use the player.sql you need to change InnoDB to MyISAM in the .sql file.

 

I fixed that now.

  • Love 1

Share this post


Link to post

whats up on INSERT ? :)

 

Need to find the official ones on my disk, WoM's db is too modified for this release.

Share this post


Link to post

Sorry for the delay guys, been really busy at Wom. I will add the 40k item_attr and object proto (all versions) today.

  • Love 1

Share this post


Link to post

Sorry for the delay guys, been really busy at Wom. I will add the 40k item_attr and object proto (all versions) today.

Can you dump database ? with all colums, tables, databases.. Thanks again

Share this post


Link to post

Shogun you will publish 40k item_attr and object_proto ?

 

Regards

Share this post


Link to post

I can't just dump the database, I want to give you the official version not wom's.

Share this post


Link to post

@Shogun I try to excute skill_proto query but give this error ; 

Share this post


Link to post

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 (see edit history)

Share this post


Link to post

Does anyone have the player.shop table? Just the shop_item table is not enough  ;)

Share this post


Link to post

skill_proto is not compatible with r40250 

you can upp the original skill_proto for 40k please?

 

EDIT.

Methi skill_proto is work on 40250r nice ;)

Share this post


Link to post

Anyone has land.sql with the new land coordinates from new maps guild_villages ?

Share this post


Link to post

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.

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...

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.