Premium Shogun 4606 Posted February 14, 2014 Premium Share Posted February 14, 2014 M2 Download Center This is the hidden content, please Sign In or Sign Up ( Internal ) Since many people may need it, here's my complete official db structure for game 34k, including: - All Indexes and Options included - All auto increment values are set to 1 (except player that is set to 100 to avoid some issues) - Some non-fatal errors caused by original YMIR table structure are fixed 34k_official_db_structure.zip 69 KB https://mega.co.nz/#!SB1CzYyI!T8c_wILefEJBpYjNJXKW2BVaPzp2SRMjNuVDh2WEXkU Tables refine_proto (official, valid for all game revisions) Spoiler -- ---------------------------- -- Table structure for `refine_proto` -- ---------------------------- DROP TABLE IF EXISTS `refine_proto`; CREATE TABLE `refine_proto` ( `id` int(11) NOT NULL AUTO_INCREMENT, `vnum0` int(10) unsigned NOT NULL DEFAULT '0', `count0` smallint(6) NOT NULL DEFAULT '0', `vnum1` int(10) unsigned NOT NULL DEFAULT '0', `count1` smallint(6) NOT NULL DEFAULT '0', `vnum2` int(10) unsigned NOT NULL DEFAULT '0', `count2` smallint(6) NOT NULL DEFAULT '0', `vnum3` int(10) unsigned NOT NULL DEFAULT '0', `count3` smallint(6) NOT NULL DEFAULT '0', `vnum4` int(10) unsigned NOT NULL DEFAULT '0', `count4` smallint(6) NOT NULL DEFAULT '0', `cost` int(11) NOT NULL DEFAULT '0', `src_vnum` int(10) unsigned NOT NULL DEFAULT '0', `result_vnum` int(10) unsigned NOT NULL DEFAULT '0', `prob` smallint(6) NOT NULL DEFAULT '100', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=760 DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of refine_proto -- ---------------------------- INSERT INTO `refine_proto` VALUES ('1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '600', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('4', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('6', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('7', '30053', '1', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('8', '30073', '2', '0', '0', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('9', '30033', '2', '0', '0', '0', '0', '0', '0', '0', '0', '75000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('10', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('11', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('12', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('13', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8000', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('14', '30030', '2', '0', '0', '0', '0', '0', '0', '0', '0', '13000', '0', '0', '70'); INSERT INTO `refine_proto` VALUES ('15', '30075', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('16', '30056', '2', '27799', '1', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('17', '30022', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '70000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('18', '30067', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('19', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('21', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '70'); INSERT INTO `refine_proto` VALUES ('22', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('23', '30079', '1', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('24', '30015', '1', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('25', '30016', '2', '27992', '1', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('26', '30089', '2', '27993', '1', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '20'); INSERT INTO `refine_proto` VALUES ('27', '30091', '2', '27994', '1', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '10'); INSERT INTO `refine_proto` VALUES ('28', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '600', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('29', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('30', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('31', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('32', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('33', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('34', '30034', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('35', '30011', '2', '0', '0', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('36', '30035', '2', '0', '0', '0', '0', '0', '0', '0', '0', '75000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('37', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('38', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('39', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('40', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8000', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('41', '30052', '2', '0', '0', '0', '0', '0', '0', '0', '0', '13000', '0', '0', '70'); INSERT INTO `refine_proto` VALUES ('42', '30046', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('43', '30045', '2', '27799', '1', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('44', '30025', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '70000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('45', '30058', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('46', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('47', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('48', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '70'); INSERT INTO `refine_proto` VALUES ('49', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('50', '30083', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('51', '30060', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('52', '30061', '2', '27992', '1', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('53', '30088', '2', '27993', '1', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '20'); INSERT INTO `refine_proto` VALUES ('54', '30019', '2', '27994', '1', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '10'); INSERT INTO `refine_proto` VALUES ('55', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '600', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('56', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('57', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('58', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('59', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('60', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('61', '30070', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('62', '30072', '2', '0', '0', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('63', '30017', '2', '0', '0', '0', '0', '0', '0', '0', '0', '75000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('64', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('65', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('66', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('67', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8000', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('68', '30041', '1', '0', '0', '0', '0', '0', '0', '0', '0', '13000', '0', '0', '70'); INSERT INTO `refine_proto` VALUES ('69', '30008', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('70', '30057', '1', '27799', '1', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('71', '30081', '1', '27987', '1', '0', '0', '0', '0', '0', '0', '70000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('72', '30077', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('73', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('74', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('75', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '70'); INSERT INTO `refine_proto` VALUES ('76', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('77', '30009', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('78', '30039', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('79', '30040', '2', '27992', '1', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('80', '30048', '2', '27993', '1', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '20'); INSERT INTO `refine_proto` VALUES ('81', '30090', '2', '27994', '1', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '10'); INSERT INTO `refine_proto` VALUES ('82', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '600', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('83', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('84', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('85', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('86', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('87', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('88', '30031', '1', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('89', '30032', '2', '0', '0', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('90', '30033', '2', '0', '0', '0', '0', '0', '0', '0', '0', '75000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('91', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('92', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('93', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('94', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8000', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('95', '30008', '2', '0', '0', '0', '0', '0', '0', '0', '0', '13000', '0', '0', '70'); INSERT INTO `refine_proto` VALUES ('96', '30075', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('97', '30006', '2', '27799', '1', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('98', '30022', '1', '27987', '1', '0', '0', '0', '0', '0', '0', '70000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('99', '30067', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('100', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('101', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('102', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '70'); INSERT INTO `refine_proto` VALUES ('103', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('104', '30079', '1', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('105', '30015', '1', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('106', '30086', '2', '27992', '1', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('107', '30050', '2', '27993', '1', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '20'); INSERT INTO `refine_proto` VALUES ('108', '30091', '2', '27994', '1', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '10'); INSERT INTO `refine_proto` VALUES ('109', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '600', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('110', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('111', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('112', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('113', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('114', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('115', '30071', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('116', '30018', '2', '0', '0', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('117', '30017', '2', '0', '0', '0', '0', '0', '0', '0', '0', '75000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('118', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('119', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('121', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8000', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('122', '30005', '2', '0', '0', '0', '0', '0', '0', '0', '0', '13000', '0', '0', '70'); INSERT INTO `refine_proto` VALUES ('123', '30076', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('124', '30051', '1', '27799', '1', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('125', '30081', '1', '27987', '1', '0', '0', '0', '0', '0', '0', '70000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('126', '30047', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('127', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('128', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('129', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '70'); INSERT INTO `refine_proto` VALUES ('130', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('131', '30009', '1', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('132', '30080', '1', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('133', '30040', '2', '27992', '1', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('134', '30049', '2', '27993', '1', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '20'); INSERT INTO `refine_proto` VALUES ('135', '30090', '2', '27994', '1', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '10'); INSERT INTO `refine_proto` VALUES ('136', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '600', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('137', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('138', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('139', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('140', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('141', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('142', '30038', '1', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('143', '30023', '2', '0', '0', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('144', '30074', '2', '0', '0', '0', '0', '0', '0', '0', '0', '75000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('145', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('146', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('147', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('148', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8000', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('149', '30007', '2', '0', '0', '0', '0', '0', '0', '0', '0', '13000', '0', '0', '70'); INSERT INTO `refine_proto` VALUES ('150', '30078', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('151', '30045', '2', '27799', '1', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('152', '30055', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '70000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('153', '30047', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('154', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('155', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('156', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '70'); INSERT INTO `refine_proto` VALUES ('157', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('158', '30059', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('159', '30080', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('160', '30085', '2', '27992', '1', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('161', '30014', '2', '27993', '1', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '20'); INSERT INTO `refine_proto` VALUES ('162', '30042', '2', '27994', '1', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '10'); INSERT INTO `refine_proto` VALUES ('163', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '600', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('164', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('165', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('166', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('167', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('168', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('169', '30010', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('170', '30031', '1', '0', '0', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('171', '30032', '2', '0', '0', '0', '0', '0', '0', '0', '0', '75000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('172', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('173', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('174', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('175', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8000', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('176', '30021', '2', '0', '0', '0', '0', '0', '0', '0', '0', '13000', '0', '0', '70'); INSERT INTO `refine_proto` VALUES ('177', '30008', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('178', '30057', '2', '27799', '1', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('179', '30006', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '70000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('180', '30022', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('181', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('182', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('183', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '70'); INSERT INTO `refine_proto` VALUES ('184', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('185', '30082', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('186', '30079', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('187', '30087', '2', '27992', '1', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('188', '30086', '2', '27993', '1', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '20'); INSERT INTO `refine_proto` VALUES ('189', '30050', '2', '27994', '1', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '10'); INSERT INTO `refine_proto` VALUES ('190', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '600', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('191', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('192', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('193', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('194', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('195', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('196', '30038', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('197', '30011', '2', '0', '0', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('198', '30074', '1', '0', '0', '0', '0', '0', '0', '0', '0', '75000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('199', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('200', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('201', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('202', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8000', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('203', '30007', '2', '0', '0', '0', '0', '0', '0', '0', '0', '13000', '0', '0', '70'); INSERT INTO `refine_proto` VALUES ('204', '30046', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('205', '30045', '2', '27799', '1', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('206', '30055', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '70000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('207', '30058', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('208', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('209', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('210', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '70'); INSERT INTO `refine_proto` VALUES ('211', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('212', '30059', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('213', '30060', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('214', '30061', '2', '27992', '1', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('215', '30014', '2', '27993', '1', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '20'); INSERT INTO `refine_proto` VALUES ('216', '30042', '2', '27994', '1', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '10'); INSERT INTO `refine_proto` VALUES ('217', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '600', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('218', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('219', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('220', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('221', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('222', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('223', '30071', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('224', '30023', '1', '0', '0', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('225', '30074', '2', '0', '0', '0', '0', '0', '0', '0', '0', '75000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('226', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('227', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('228', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('229', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8000', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('230', '30005', '1', '0', '0', '0', '0', '0', '0', '0', '0', '13000', '0', '0', '70'); INSERT INTO `refine_proto` VALUES ('231', '30078', '1', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('232', '30051', '1', '27799', '1', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('233', '30055', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '70000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('234', '30047', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('235', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('236', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('237', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '70'); INSERT INTO `refine_proto` VALUES ('238', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('239', '30059', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('240', '30080', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('241', '30085', '2', '27992', '1', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('242', '30049', '2', '27993', '1', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '20'); INSERT INTO `refine_proto` VALUES ('243', '30042', '2', '27994', '1', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '10'); INSERT INTO `refine_proto` VALUES ('244', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '600', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('245', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('246', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('247', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('248', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('249', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('250', '30070', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('251', '30018', '2', '0', '0', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('252', '30017', '2', '0', '0', '0', '0', '0', '0', '0', '0', '75000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('253', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('254', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('255', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('256', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8000', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('257', '30041', '2', '0', '0', '0', '0', '0', '0', '0', '0', '13000', '0', '0', '70'); INSERT INTO `refine_proto` VALUES ('258', '30076', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('259', '30051', '2', '27799', '1', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('260', '30081', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '70000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('261', '30077', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('262', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('263', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('264', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '70'); INSERT INTO `refine_proto` VALUES ('265', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('266', '30009', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('267', '30039', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('268', '30040', '2', '27992', '1', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('269', '30048', '2', '27993', '1', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '20'); INSERT INTO `refine_proto` VALUES ('270', '30090', '2', '27994', '1', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '10'); INSERT INTO `refine_proto` VALUES ('271', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '600', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('272', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('273', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('274', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('275', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('276', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('277', '30010', '1', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('278', '30072', '2', '0', '0', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('279', '30032', '1', '0', '0', '0', '0', '0', '0', '0', '0', '75000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('280', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('281', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('282', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('283', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8000', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('284', '30021', '1', '0', '0', '0', '0', '0', '0', '0', '0', '13000', '0', '0', '70'); INSERT INTO `refine_proto` VALUES ('285', '30008', '1', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('286', '30057', '1', '27799', '1', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('287', '30006', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '70000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('288', '30077', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('289', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('290', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('291', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '70'); INSERT INTO `refine_proto` VALUES ('292', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('293', '30082', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('294', '30039', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('295', '30087', '2', '27992', '1', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('296', '30086', '2', '27993', '1', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '20'); INSERT INTO `refine_proto` VALUES ('297', '30050', '2', '27994', '1', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '10'); INSERT INTO `refine_proto` VALUES ('298', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '600', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('299', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('300', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('301', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('302', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('303', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('304', '30053', '1', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('305', '30073', '1', '0', '0', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('306', '30035', '2', '0', '0', '0', '0', '0', '0', '0', '0', '75000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('307', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('308', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('309', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('310', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8000', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('311', '30030', '2', '0', '0', '0', '0', '0', '0', '0', '0', '13000', '0', '0', '70'); INSERT INTO `refine_proto` VALUES ('312', '30075', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('313', '30056', '2', '27799', '1', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('314', '30025', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '70000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('315', '30067', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('316', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('317', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('318', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '70'); INSERT INTO `refine_proto` VALUES ('319', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('320', '30083', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('321', '30015', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('322', '30016', '2', '27992', '1', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('323', '30089', '2', '27993', '1', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '20'); INSERT INTO `refine_proto` VALUES ('324', '30019', '2', '27994', '1', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '10'); INSERT INTO `refine_proto` VALUES ('325', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '600', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('326', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('327', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('328', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('329', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('330', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('331', '30034', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('332', '30073', '2', '0', '0', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('333', '30035', '2', '0', '0', '0', '0', '0', '0', '0', '0', '75000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('334', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('335', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('336', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('337', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8000', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('338', '30052', '2', '0', '0', '0', '0', '0', '0', '0', '0', '13000', '0', '0', '70'); INSERT INTO `refine_proto` VALUES ('339', '30046', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('340', '30056', '2', '27799', '1', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('341', '30025', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '70000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('342', '30058', '2', '27987', '1', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('343', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('344', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2500', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('345', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '70'); INSERT INTO `refine_proto` VALUES ('346', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('347', '30083', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('348', '30060', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('349', '30061', '2', '30193', '2', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('350', '30088', '2', '30193', '4', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '20'); INSERT INTO `refine_proto` VALUES ('351', '30019', '2', '30193', '6', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '10'); INSERT INTO `refine_proto` VALUES ('352', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('353', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '6000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('354', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '12000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('355', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '25000', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('356', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '70'); INSERT INTO `refine_proto` VALUES ('357', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '60000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('358', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('359', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('360', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('400', '30192', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('401', '30194', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('402', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '0', '0', '70'); INSERT INTO `refine_proto` VALUES ('403', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('404', '30083', '2', '0', '0', '0', '0', '0', '0', '0', '0', '20000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('405', '30060', '2', '0', '0', '0', '0', '0', '0', '0', '0', '30000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('406', '30061', '2', '30193', '2', '0', '0', '0', '0', '0', '0', '45000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('407', '30088', '2', '30193', '4', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '20'); INSERT INTO `refine_proto` VALUES ('408', '30019', '2', '30193', '6', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '10'); INSERT INTO `refine_proto` VALUES ('501', '25040', '2', '70031', '1', '0', '0', '0', '0', '0', '0', '100000', '0', '0', '100'); INSERT INTO `refine_proto` VALUES ('502', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('503', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '140000', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('504', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '170000', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('505', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '200000', '0', '0', '70'); INSERT INTO `refine_proto` VALUES ('506', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '240000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('507', '30050', '2', '0', '0', '0', '0', '0', '0', '0', '0', '290000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('508', '30083', '2', '27992', '1', '0', '0', '0', '0', '0', '0', '340000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('509', '30040', '2', '27993', '1', '0', '0', '0', '0', '0', '0', '410000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('510', '30089', '2', '27994', '1', '0', '0', '0', '0', '0', '0', '500000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('531', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '7500', '0', '0', '90'); INSERT INTO `refine_proto` VALUES ('532', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '15000', '0', '0', '80'); INSERT INTO `refine_proto` VALUES ('533', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '25000', '0', '0', '70'); INSERT INTO `refine_proto` VALUES ('534', '30196', '2', '0', '0', '0', '0', '0', '0', '0', '0', '40000', '0', '0', '60'); INSERT INTO `refine_proto` VALUES ('535', '30090', '3', '0', '0', '0', '0', '0', '0', '0', '0', '65000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('536', '30195', '2', '0', '0', '0', '0', '0', '0', '0', '0', '90000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('537', '30197', '4', '27992', '1', '0', '0', '0', '0', '0', '0', '120000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('538', '30198', '2', '27993', '1', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '20'); INSERT INTO `refine_proto` VALUES ('539', '30199', '2', '27994', '1', '0', '0', '0', '0', '0', '0', '200000', '0', '0', '10'); INSERT INTO `refine_proto` VALUES ('701', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '500000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('702', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2000000', '0', '0', '25'); INSERT INTO `refine_proto` VALUES ('703', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100'); INSERT INTO `refine_proto` VALUES ('751', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100000', '0', '0', '40'); INSERT INTO `refine_proto` VALUES ('752', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '500000', '0', '0', '50'); INSERT INTO `refine_proto` VALUES ('753', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2000000', '0', '0', '30'); INSERT INTO `refine_proto` VALUES ('758', '71123', '2', '71129', '3', '0', '0', '0', '0', '0', '0', '125000', '0', '0', '100'); INSERT INTO `refine_proto` VALUES ('759', '71123', '3', '71129', '4', '0', '0', '0', '0', '0', '0', '200000', '0', '0', '100'); object_proto (modified from official with smaller limits for buildings so they actually fit in your land) Spoiler CREATE TABLE `object_proto` ( `vnum` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(32) NOT NULL DEFAULT '', `price` int(10) unsigned NOT NULL DEFAULT '0', `materials` varchar(64) NOT NULL DEFAULT '', `upgrade_vnum` int(10) unsigned NOT NULL DEFAULT '0', `upgrade_limit_time` int(10) unsigned NOT NULL DEFAULT '0', `life` int(11) NOT NULL DEFAULT '0', `reg_1` int(11) NOT NULL DEFAULT '0', `reg_2` int(11) NOT NULL DEFAULT '0', `reg_3` int(11) NOT NULL DEFAULT '0', `reg_4` int(11) NOT NULL DEFAULT '0', `npc` int(10) unsigned NOT NULL DEFAULT '0', `group_vnum` int(10) unsigned NOT NULL DEFAULT '0', `dependent_group` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`vnum`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of object_proto -- ---------------------------- INSERT INTO `object_proto` VALUES ('14013', '?? ???', '20000000', '90010,20/90011,30/90012,20', '0', '0', '0', '-10', '-10', '10', '10', '20044', '2', '1'); INSERT INTO `object_proto` VALUES ('14014', '??? ???', '20000000', '90010,20/90011,30/90012,20', '0', '0', '0', '-10', '-10', '10', '10', '20045', '2', '1'); INSERT INTO `object_proto` VALUES ('14015', '???? ???', '20000000', '90010,20/90011,30/90012,20', '0', '0', '0', '-10', '-10', '10', '10', '20046', '2', '1'); INSERT INTO `object_proto` VALUES ('14043', '????? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20060', '3', '1'); INSERT INTO `object_proto` VALUES ('14045', '??? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20062', '3', '1'); INSERT INTO `object_proto` VALUES ('14046', '?? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20063', '3', '1'); INSERT INTO `object_proto` VALUES ('14047', '? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20064', '3', '1'); INSERT INTO `object_proto` VALUES ('14048', '? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20065', '3', '1'); INSERT INTO `object_proto` VALUES ('14049', '?? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20066', '3', '1'); INSERT INTO `object_proto` VALUES ('14050', '??? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20067', '3', '1'); INSERT INTO `object_proto` VALUES ('14051', '?? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20068', '3', '1'); INSERT INTO `object_proto` VALUES ('14052', '?? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20069', '3', '1'); INSERT INTO `object_proto` VALUES ('14053', '?? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20070', '3', '1'); INSERT INTO `object_proto` VALUES ('14054', '??? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20071', '3', '1'); INSERT INTO `object_proto` VALUES ('14055', '?? ???', '20000000', '90010,15/90011,20/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20072', '3', '1'); INSERT INTO `object_proto` VALUES ('14061', '?? ??', '25000000', '90010,25/90011,25/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '20077', '4', '1'); INSERT INTO `object_proto` VALUES ('14062', '?? ??', '500000000', '90010,50/90011,50/90012,50', '0', '0', '0', '-10', '-10', '10', '10', '20078', '4', '4'); INSERT INTO `object_proto` VALUES ('14063', '?? ??', '750000000', '90010,75/90011,75/90012,75', '0', '0', '0', '-10', '-10', '10', '10', '20079', '4', '4'); INSERT INTO `object_proto` VALUES ('14100', '?(1)', '20000000', '90010,20/90011,30/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '0', '1', '0'); INSERT INTO `object_proto` VALUES ('14110', '?(2)', '20000000', '90010,20/90011,30/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '0', '1', '0'); INSERT INTO `object_proto` VALUES ('14120', '?(3)', '20000000', '90010,20/90011,30/90012,25', '0', '0', '0', '-10', '-10', '10', '10', '0', '1', '0'); INSERT INTO `object_proto` VALUES ('14200', '?? ??', '3000000', '90011,5/90012,5', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '1'); INSERT INTO `object_proto` VALUES ('14300', '?1', '300000', '90010,5', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '0'); INSERT INTO `object_proto` VALUES ('14301', '?2', '300000', '90010,5', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '0'); INSERT INTO `object_proto` VALUES ('14302', '?3', '300000', '90010,7', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '0'); INSERT INTO `object_proto` VALUES ('14303', '?4', '300000', '90010,7', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '0'); INSERT INTO `object_proto` VALUES ('14304', '?5', '300000', '90010,7', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '0'); INSERT INTO `object_proto` VALUES ('14305', '?6', '300000', '90010,8', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '0'); INSERT INTO `object_proto` VALUES ('14306', '?7', '300000', '90010,8', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '0'); INSERT INTO `object_proto` VALUES ('14307', '?8', '300000', '90010,8', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '0'); INSERT INTO `object_proto` VALUES ('14308', '?9', '300000', '90010,9', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '0'); INSERT INTO `object_proto` VALUES ('14309', '?10', '300000', '90010,9', '0', '0', '0', '-10', '-10', '10', '10', '0', '0', '0'); INSERT INTO `object_proto` VALUES ('14400', '??1', '2000000', '90011,5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `object_proto` VALUES ('14401', '??2', '2000000', '90011,5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `object_proto` VALUES ('14402', '??3', '2000000', '90011,7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `object_proto` VALUES ('14403', '??4', '2000000', '90011,7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `object_proto` VALUES ('14404', '??5', '2000000', '90011,7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `object_proto` VALUES ('14405', '??6', '2000000', '90011,9', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `object_proto` VALUES ('14406', '??7', '2000000', '90011,9', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `object_proto` VALUES ('14407', '??8', '2000000', '90011,9', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `object_proto` VALUES ('14408', '??9', '2000000', '90011,9', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); [/spoiler] 40k_item_attr (New bonuses: resist to earth, ice and dark) Spoiler SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `item_attr` -- ---------------------------- DROP TABLE IF EXISTS `item_attr`; CREATE TABLE `item_attr` ( `apply` enum('MAX_HP','MAX_SP','CON','INT','STR','DEX','ATT_SPEED','MOV_SPEED','CAST_SPEED','HP_REGEN','SP_REGEN','POISON_PCT','STUN_PCT','SLOW_PCT','CRITICAL_PCT','PENETRATE_PCT','ATTBONUS_HUMAN','ATTBONUS_ANIMAL','ATTBONUS_ORC','ATTBONUS_MILGYO','ATTBONUS_UNDEAD','ATTBONUS_DEVIL','STEAL_HP','STEAL_SP','MANA_BURN_PCT','DAMAGE_SP_RECOVER','BLOCK','DODGE','RESIST_SWORD','RESIST_TWOHAND','RESIST_DAGGER','RESIST_BELL','RESIST_FAN','RESIST_BOW','RESIST_FIRE','RESIST_ELEC','RESIST_MAGIC','RESIST_WIND','REFLECT_MELEE','REFLECT_CURSE','POISON_REDUCE','KILL_SP_RECOVER','EXP_DOUBLE_BONUS','GOLD_DOUBLE_BONUS','ITEM_DROP_BONUS','POTION_BONUS','KILL_HP_RECOVER','IMMUNE_STUN','IMMUNE_SLOW','IMMUNE_FALL','SKILL','BOW_DISTANCE','ATT_GRADE_BONUS','DEF_GRADE_BONUS','MAGIC_ATT_GRADE','MAGIC_DEF_GRADE','CURSE_PCT','MAX_STAMINA','ATT_BONUS_TO_WARRIOR','ATT_BONUS_TO_ASSASSIN','ATT_BONUS_TO_SURA','ATT_BONUS_TO_SHAMAN','NORMAL_HIT_DEFEND_BONUS','SKILL_DEFEND_BONUS','NOUSE1','RESIST_ICE','RESIST_EARTH','RESIST_DARK','NOUSE6','NOUSE7','NOUSE8','NOUSE9','NOUSE10','NOUSE11','NOUSE12','NOUSE13','NOUSE14','RESIST_WARRIOR','RESIST_ASSASSIN','RESIST_SURA','RESIST_SHAMAN') NOT NULL DEFAULT 'MAX_HP', `prob` varchar(100) NOT NULL DEFAULT '', `lv1` varchar(100) NOT NULL DEFAULT '', `lv2` varchar(100) NOT NULL DEFAULT '', `lv3` varchar(100) NOT NULL DEFAULT '', `lv4` varchar(100) NOT NULL DEFAULT '', `lv5` varchar(100) NOT NULL DEFAULT '', `weapon` varchar(100) NOT NULL DEFAULT '', `body` varchar(100) NOT NULL DEFAULT '', `wrist` varchar(100) NOT NULL DEFAULT '', `foots` varchar(100) NOT NULL DEFAULT '', `neck` varchar(100) NOT NULL DEFAULT '', `head` varchar(100) NOT NULL DEFAULT '', `shield` varchar(100) NOT NULL DEFAULT '', `ear` varchar(100) NOT NULL DEFAULT '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of item_attr -- ---------------------------- INSERT INTO `item_attr` VALUES ('MAX_HP', '35', '500', '500', '1000', '1500', '2000', '0', '5', '5', '5', '5', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('MAX_SP', '35', '10', '20', '30', '50', '80', '0', '0', '5', '5', '5', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('CON', '11', '2', '4', '6', '8', '12', '5', '0', '0', '0', '0', '0', '5', '0'); INSERT INTO `item_attr` VALUES ('INT', '11', '2', '4', '6', '8', '12', '5', '0', '0', '0', '0', '0', '5', '0'); INSERT INTO `item_attr` VALUES ('STR', '11', '2', '4', '6', '8', '12', '5', '0', '0', '0', '0', '0', '5', '0'); INSERT INTO `item_attr` VALUES ('DEX', '11', '2', '4', '6', '8', '12', '5', '0', '0', '0', '0', '0', '5', '0'); INSERT INTO `item_attr` VALUES ('ATT_SPEED', '8', '1', '2', '3', '5', '8', '0', '0', '0', '5', '0', '5', '0', '0'); INSERT INTO `item_attr` VALUES ('MOV_SPEED', '18', '2', '4', '6', '10', '20', '0', '0', '0', '5', '0', '0', '0', '5'); INSERT INTO `item_attr` VALUES ('CAST_SPEED', '8', '2', '4', '6', '10', '20', '5', '5', '0', '0', '0', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('HP_REGEN', '60', '4', '8', '12', '20', '30', '0', '0', '0', '0', '5', '5', '0', '0'); INSERT INTO `item_attr` VALUES ('SP_REGEN', '60', '4', '8', '12', '20', '30', '0', '0', '0', '0', '5', '5', '0', '0'); INSERT INTO `item_attr` VALUES ('POISON_PCT', '8', '1', '2', '3', '5', '8', '5', '0', '0', '0', '0', '5', '0', '0'); INSERT INTO `item_attr` VALUES ('STUN_PCT', '18', '1', '2', '3', '5', '8', '5', '0', '0', '5', '5', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('SLOW_PCT', '35', '1', '2', '3', '5', '8', '5', '0', '0', '5', '0', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('CRITICAL_PCT', '18', '1', '2', '3', '5', '10', '5', '0', '0', '5', '5', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('PENETRATE_PCT', '30', '1', '2', '3', '5', '10', '5', '0', '5', '0', '5', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('ATTBONUS_HUMAN', '15', '1', '2', '3', '5', '10', '5', '0', '5', '0', '0', '5', '5', '5'); INSERT INTO `item_attr` VALUES ('ATTBONUS_ANIMAL', '35', '2', '4', '6', '10', '20', '5', '0', '5', '0', '0', '5', '5', '5'); INSERT INTO `item_attr` VALUES ('ATTBONUS_ORC', '35', '2', '4', '6', '10', '20', '5', '0', '5', '0', '0', '5', '5', '5'); INSERT INTO `item_attr` VALUES ('ATTBONUS_MILGYO', '35', '2', '4', '6', '10', '20', '5', '0', '5', '0', '0', '5', '5', '5'); INSERT INTO `item_attr` VALUES ('ATTBONUS_UNDEAD', '35', '2', '4', '6', '10', '20', '5', '0', '5', '0', '0', '5', '5', '5'); INSERT INTO `item_attr` VALUES ('ATTBONUS_DEVIL', '35', '2', '4', '6', '10', '20', '5', '0', '5', '0', '0', '5', '5', '5'); INSERT INTO `item_attr` VALUES ('STEAL_HP', '50', '1', '2', '3', '5', '10', '0', '5', '5', '0', '0', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('STEAL_SP', '50', '1', '2', '3', '5', '10', '0', '5', '0', '0', '5', '5', '0', '0'); INSERT INTO `item_attr` VALUES ('MANA_BURN_PCT', '18', '1', '2', '3', '5', '10', '0', '0', '5', '0', '0', '0', '0', '5'); INSERT INTO `item_attr` VALUES ('BLOCK', '10', '2', '4', '6', '10', '15', '0', '0', '0', '0', '0', '0', '5', '0'); INSERT INTO `item_attr` VALUES ('DODGE', '10', '2', '4', '6', '10', '15', '0', '0', '0', '5', '0', '5', '0', '0'); INSERT INTO `item_attr` VALUES ('RESIST_SWORD', '18', '2', '4', '6', '10', '15', '0', '5', '0', '5', '5', '0', '0', '5'); INSERT INTO `item_attr` VALUES ('RESIST_TWOHAND', '18', '2', '4', '6', '10', '15', '0', '5', '0', '5', '5', '0', '0', '5'); INSERT INTO `item_attr` VALUES ('RESIST_DAGGER', '18', '2', '4', '6', '10', '15', '0', '5', '0', '5', '5', '0', '0', '5'); INSERT INTO `item_attr` VALUES ('RESIST_BELL', '18', '2', '4', '6', '10', '15', '0', '5', '0', '5', '5', '0', '0', '5'); INSERT INTO `item_attr` VALUES ('RESIST_FAN', '18', '2', '4', '6', '10', '15', '0', '5', '0', '5', '5', '0', '0', '5'); INSERT INTO `item_attr` VALUES ('RESIST_BOW', '18', '2', '4', '6', '10', '15', '0', '5', '0', '5', '5', '0', '0', '5'); INSERT INTO `item_attr` VALUES ('RESIST_FIRE', '18', '2', '4', '6', '10', '15', '0', '5', '5', '0', '0', '5', '0', '0'); INSERT INTO `item_attr` VALUES ('RESIST_ELEC', '18', '2', '4', '6', '10', '15', '0', '5', '5', '0', '0', '5', '0', '0'); INSERT INTO `item_attr` VALUES ('RESIST_MAGIC', '25', '2', '4', '6', '10', '15', '0', '5', '5', '0', '0', '5', '0', '0'); INSERT INTO `item_attr` VALUES ('RESIST_WIND', '18', '2', '4', '6', '10', '15', '0', '5', '5', '0', '0', '5', '0', '0'); INSERT INTO `item_attr` VALUES ('REFLECT_MELEE', '18', '1', '2', '3', '6', '10', '0', '5', '0', '0', '0', '0', '5', '0'); INSERT INTO `item_attr` VALUES ('POISON_REDUCE', '18', '1', '2', '3', '4', '5', '0', '0', '0', '0', '0', '0', '0', '5'); INSERT INTO `item_attr` VALUES ('EXP_DOUBLE_BONUS', '10', '2', '4', '6', '8', '20', '0', '0', '0', '5', '5', '0', '5', '0'); INSERT INTO `item_attr` VALUES ('GOLD_DOUBLE_BONUS', '10', '2', '4', '6', '8', '20', '0', '0', '0', '5', '5', '0', '5', '0'); INSERT INTO `item_attr` VALUES ('ITEM_DROP_BONUS', '7', '2', '4', '6', '8', '20', '0', '0', '5', '0', '0', '0', '0', '5'); INSERT INTO `item_attr` VALUES ('IMMUNE_STUN', '3', '1', '1', '1', '1', '1', '0', '0', '0', '0', '0', '0', '1', '0'); INSERT INTO `item_attr` VALUES ('IMMUNE_SLOW', '3', '1', '1', '1', '1', '1', '0', '0', '0', '0', '0', '0', '1', '0'); INSERT INTO `item_attr` VALUES ('ATT_GRADE_BONUS', '9', '5', '10', '15', '30', '50', '0', '5', '0', '0', '0', '0', '0', '0'); INSERT INTO `item_attr` VALUES ('RESIST_DARK', '18', '2', '4', '6', '10', '15', '0', '5', '5', '0', '0', '5', '0', '0'); INSERT INTO `item_attr` VALUES ('RESIST_ICE', '18', '2', '4', '6', '10', '15', '0', '5', '5', '0', '0', '5', '0', '0'); INSERT INTO `item_attr` VALUES ('RESIST_EARTH', '18', '2', '4', '6', '10', '15', '0', '5', '5', '0', '0', '5', '0', '0'); skill_proto (SG, has a couple of small differences in regards to GF) Spoiler DROP TABLE IF EXISTS `skill_proto`; CREATE TABLE `skill_proto` ( `dwVnum` int(11) NOT NULL DEFAULT '0', `szName` varchar(32) NOT NULL DEFAULT '', `bType` tinyint(4) NOT NULL DEFAULT '0', `bLevelStep` tinyint(4) NOT NULL DEFAULT '0', `bMaxLevel` tinyint(4) NOT NULL DEFAULT '0', `bLevelLimit` tinyint(3) unsigned NOT NULL DEFAULT '0', `szPointOn` varchar(100) NOT NULL DEFAULT '0', `szPointPoly` varchar(100) NOT NULL DEFAULT '', `szSPCostPoly` varchar(100) NOT NULL DEFAULT '', `szDurationPoly` varchar(100) NOT NULL DEFAULT '', `szDurationSPCostPoly` varchar(100) NOT NULL DEFAULT '', `szCooldownPoly` varchar(100) NOT NULL DEFAULT '', `szMasterBonusPoly` varchar(100) NOT NULL DEFAULT '', `szAttackGradePoly` varchar(100) NOT NULL DEFAULT '', `setFlag` set('ATTACK','USE_MELEE_DAMAGE','COMPUTE_ATTGRADE','SELFONLY','USE_MAGIC_DAMAGE','USE_HP_AS_COST','COMPUTE_MAGIC_DAMAGE','SPLASH','GIVE_PENALTY','USE_ARROW_DAMAGE','PENETRATE','IGNORE_TARGET_RATING','ATTACK_SLOW','ATTACK_STUN','HP_ABSORB','SP_ABSORB','ATTACK_FIRE_CONT','REMOVE_BAD_AFFECT','REMOVE_GOOD_AFFECT','CRUSH','ATTACK_POISON','TOGGLE','DISABLE_BY_POINT_UP','CRUSH_LONG') DEFAULT NULL, `setAffectFlag` enum('YMIR','INVISIBILITY','SPAWN','POISON','SLOW','STUN','DUNGEON_READY','FORCE_VISIBLE','BUILDING_CONSTRUCTION_SMALL','BUILDING_CONSTRUCTION_LARGE','BUILDING_UPGRADE','MOV_SPEED_POTION','ATT_SPEED_POTION','FISH_MIDE','JEONGWIHON','GEOMGYEONG','CHEONGEUN','GYEONGGONG','EUNHYUNG','GWIGUM','TERROR','JUMAGAP','HOSIN','BOHO','KWAESOK','MANASHIELD','MUYEONG','REVIVE_INVISIBLE','FIRE','GICHEON','JEUNGRYEOK','') DEFAULT NULL, `szPointOn2` varchar(100) NOT NULL DEFAULT 'NONE', `szPointPoly2` varchar(100) NOT NULL DEFAULT '', `szDurationPoly2` varchar(100) NOT NULL DEFAULT '', `setAffectFlag2` enum('YMIR','INVISIBILITY','SPAWN','POISON','SLOW','STUN','DUNGEON_READY','FORCE_VISIBLE','BUILDING_CONSTRUCTION_SMALL','BUILDING_CONSTRUCTION_LARGE','BUILDING_UPGRADE','MOV_SPEED_POTION','ATT_SPEED_POTION','FISH_MIDE','JEONGWIHON','GEOMGYEONG','CHEONGEUN','GYEONGGONG','EUNHYUNG','GWIGUM','TERROR','JUMAGAP','HOSIN','BOHO','KWAESOK','MANASHIELD') NOT NULL DEFAULT 'YMIR', `szPointOn3` varchar(100) NOT NULL DEFAULT 'NONE', `szPointPoly3` varchar(100) NOT NULL DEFAULT '', `szDurationPoly3` varchar(100) NOT NULL DEFAULT '', `szGrandMasterAddSPCostPoly` varchar(100) NOT NULL DEFAULT '', `prerequisiteSkillVnum` int(11) NOT NULL DEFAULT '0', `prerequisiteSkillLevel` int(11) NOT NULL DEFAULT '0', `eSkillType` enum('NORMAL','MELEE','RANGE','MAGIC') NOT NULL DEFAULT 'NORMAL', `iMaxHit` tinyint(4) NOT NULL DEFAULT '0', `szSplashAroundDamageAdjustPoly` varchar(100) NOT NULL DEFAULT '1', `dwTargetRange` int(11) NOT NULL DEFAULT '1000', `dwSplashRange` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`dwVnum`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of skill_proto -- ---------------------------- INSERT INTO `skill_proto` VALUES ('1', '»ï¿¬Âü', '1', '1', '1', '0', 'HP', '-( 1.1*atk + (0.5*atk + 1.5 * str)*k)', '40+100*k', '', '', '12', '-( 1.1*atk + (0.5*atk + 1.5 * str)*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '40+100*k', '0', '0', 'MELEE', '5', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('2', 'Æȹædz¿ì', '1', '1', '1', '0', 'HP', '-(3*atk + (0.8*atk + str*5 + dex*3 +con)*k)', '50+130*k', '', '', '15', '-(3*atk + (0.8*atk + str*5 + dex*3 +con)*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '50+130*k', '0', '0', 'MELEE', '12', '1', '0', '200'); INSERT INTO `skill_proto` VALUES ('3', 'Àü±ÍÈ¥', '1', '1', '1', '0', 'ATT_SPEED', '50*k', '50+140*k', '60+90*k', '', '63+10*k', '50*k', '', 'SELFONLY', 'JEONGWIHON', 'MOV_SPEED', '20*k', '60+90*k', '', '', '', '', '50+140*k', '0', '0', 'NORMAL', '1', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('4', '°Ë°æ', '1', '1', '1', '0', 'ATT_GRADE', '(100 + str + lv * 3)*k', '100+200*k', '30+50*k', '', '30+10*k', '(100 + str + lv * 3)*k', '', 'SELFONLY', 'GEOMGYEONG', 'NONE', '', '', '', '', '', '', '100+200*k', '0', '0', 'NORMAL', '1', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('5', 'źȯ°Ý', '1', '1', '1', '0', 'HP', '-(2*atk + (atk + dex*3 + str*7 + con)*k)', '60+120*k', '', '', '12', '-(2*atk + (atk + dex*3 + str*7 + con)*k)', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH', '', 'MOV_SPEED', '150', '3', '', '', '', '', '60+120*k', '0', '0', 'MELEE', '4', '1', '0', '200'); INSERT INTO `skill_proto` VALUES ('16', '±â°øÂü', '1', '1', '1', '0', 'HP', '-(2.3*atk + (4*atk + str*4 + con)*k)', '60+120*k', '', '', '15', '-(2.3*atk + (4*atk + str*4 + con)*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '60+120*k', '0', '0', 'MELEE', '4', '1', '0', '100'); INSERT INTO `skill_proto` VALUES ('17', '°Ý»êŸ¿ì', '1', '1', '1', '0', 'HP', '-(2.3*atk + (3*atk + str*4 + con*3)*k)', '60+150*k', '', '', '15', '-(2.3*atk + (3*atk + str*4 + con*3)*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '60+150*k', '0', '0', 'MELEE', '8', '1', '0', '200'); INSERT INTO `skill_proto` VALUES ('18', '´ëÁø°¢', '1', '1', '1', '0', 'HP', '-(2*atk + (2*atk + 2*dex + 2*con + str*4)*k)', '50+140*k', '', '', '25', '-(2*atk + (2*atk + 2*dex + 2*con + str*4)*k)', '', 'ATTACK,USE_MELEE_DAMAGE,SELFONLY,SPLASH,ATTACK_STUN', '', 'NONE', '100+k*1000/6', '2', '', '', '', '', '50+140*k', '0', '0', 'MELEE', '10', '1', '0', '400'); INSERT INTO `skill_proto` VALUES ('19', 'õ±ÙÃß', '1', '1', '1', '0', 'DEF_GRADE', '(200 + str*0.2 + con*0.5 ) *k', '80+220*k', '60+90*k', '', '63+10*k', '(200 + str*0.2 + con*0.5 ) *k', '', 'SELFONLY', 'CHEONGEUN', 'MOV_SPEED', '-(1+9*k)', '60+90*k', '', '', '', '', '80+220*k', '0', '0', 'NORMAL', '1', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('20', '°Ëdz', '1', '1', '1', '0', 'HP', '-(2*atk + (atk + dex*3 + str*5 + con)*k)', '40+120*k', '', '', '20', '-(2*atk + (atk + dex*3 + str*5 + con)*k)', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH', '', 'NONE', '', '', '', '', '', '', '40+120*k', '0', '0', 'MELEE', '10', '0.5', '1200', '200'); INSERT INTO `skill_proto` VALUES ('31', '¾Ï½À', '2', '1', '1', '0', 'HP', '-(atk + (1.2 * atk + number(500, 700) + dex*4+ str*4 )*k)', '40+160*k', '', '', '15', '-(atk + (1.2 * atk + number(500, 700) + dex*4+ str*4 )*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '40+160*k', '0', '0', 'MELEE', '6', '0.8', '0', '0'); INSERT INTO `skill_proto` VALUES ('32', '±Ã½Åź¿µ', '2', '1', '1', '0', 'HP', '-(atk + (1.6* atk + number(200,300) + dex*7 + str*7)*k)', '40+160*k', '', '', '20', '-(atk + (1.6* atk + number(200,300) + dex*7 + str*7)*k)', '', 'ATTACK,USE_MELEE_DAMAGE', '', 'NONE', '', '', '', '', '', '', '40+160*k', '0', '0', 'MELEE', '6', '0.8', '800', '0'); INSERT INTO `skill_proto` VALUES ('33', 'Â÷·û»ì', '2', '1', '1', '0', 'HP', '-(2*atk + (0.5*atk + dex*9 + str*7)*k)', '50+140*k', '', '', '25', '-(2*atk + (0.5*atk + dex*9 + str*7)*k)', '', 'ATTACK,USE_MELEE_DAMAGE,ATTACK_POISON', '', 'NONE', '40*k', '', '', '', '', '', '50+140*k', '0', '0', 'MELEE', '12', '0.8', '0', '0'); INSERT INTO `skill_proto` VALUES ('34', 'ÀºÇü¹ý', '2', '1', '1', '0', 'NONE', '', '30+60*k', '15+30*k', '', '60', '', '', 'SELFONLY', 'EUNHYUNG', 'NONE', '', '', '', '', '', '', '30+60*k', '0', '0', 'NORMAL', '1', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('35', '»ê°øºÐ', '2', '1', '1', '0', 'HP', '-(lv*2+(atk + str*3 + dex*18)*k)', '40+130*k', '', '', '25', '-(lv*2+(atk + str*3 + dex*18)*k)', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,ATTACK_POISON', '', 'NONE', '60*k', '5+25*k', '', '', '', '', '40+130*k', '0', '0', 'MAGIC', '0', '0.5', '800', '200'); INSERT INTO `skill_proto` VALUES ('46', '¿¬»ç', '2', '1', '1', '0', 'HP', '-(atk + 0.3*atk*floor(2+k*6)+ (0.8*atk+dex*8*ar) *k)', '40+130*k', '', '', '15', '-(atk + 0.2*atk*floor(2+k*6)+ (0.8*atk+dex*8*ar) *k)', '', 'ATTACK,USE_ARROW_DAMAGE', '', 'NONE', '', '', '', '', '', '', '40+130*k', '0', '0', 'RANGE', '1', '1', '2500', '0'); INSERT INTO `skill_proto` VALUES ('47', '°ü°Ý¼ú', '2', '1', '1', '0', 'HP', '-(atk + (1.9*atk + dex*2+ str*2)*k)', '30+130*k', '', '', '12', '-(atk + (1.7*atk + dex*2+ str*2)*k)', '', 'ATTACK,USE_ARROW_DAMAGE', '', 'NONE', '', '', '', '', '', '', '30+130*k', '0', '0', 'RANGE', '8', '1', '2500', '0'); INSERT INTO `skill_proto` VALUES ('48', 'ÈÁ¶ÆÄ', '2', '1', '1', '0', 'HP', '-(1.5*atk + (2.8*atk + number(100, 300))*k)', '50+130*k', '', '', '25', '-(1.5*atk + (2.6*atk + number(100, 300))*k)', '', 'ATTACK,SPLASH,USE_ARROW_DAMAGE', '', 'NONE', '', '', '', '', '', '', '50+130*k', '0', '0', 'RANGE', '12', '0.6', '2500', '300'); INSERT INTO `skill_proto` VALUES ('49', '°æ°ø¼ú', '2', '1', '1', '0', 'MOV_SPEED', '60*k', '30+40*k', '15+30*k', '', '30+30*k', '60*k', '', 'SELFONLY', 'GYEONGGONG', 'NONE', '', '', '', '', '', '', '30+40*k', '0', '0', 'NORMAL', '1', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('50', 'µ¶±â±Ã', '2', '1', '1', '0', 'HP', '-(atk + (1.5*atk + number(100, 200)+dex*6+str*2)*k)', '40+160*k', '', '', '25', '-(atk + (1.2*atk + number(100, 200)+dex*6+str*2)*k)', '', 'ATTACK,SPLASH,USE_ARROW_DAMAGE,CRUSH,ATTACK_POISON', '', 'NONE', '80*k', '15+30*k', '', '', '', '', '40+160*k', '0', '0', 'RANGE', '12', '0.5', '2500', '300'); INSERT INTO `skill_proto` VALUES ('61', '¼â·ÉÁö', '3', '1', '1', '0', 'HP', '-(atk + 2*lv + iq*2 + ( 2*atk + str*4 + iq*14) * k)', '30+140*k', '', '', '10', '-(atk + 2*lv + iq*2 + ( 2*atk + str*4 + iq*14) * k)', '', 'ATTACK,USE_MELEE_DAMAGE,PENETRATE', '', 'NONE', '1+k*9', '', '', '', '', '', '30+140*k', '0', '0', 'MELEE', '4', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('62', '¿ë±ÇÆÄ', '3', '1', '1', '0', 'HP', '-(1.1 * atk + 2*lv + iq*2+(1.5*atk + str + iq*12) * k)', '50+150*k', '', '', '15', '-(1.1 * atk + 2*lv + iq*2+(1.5*atk + str + iq*12) * k)', '', 'ATTACK,USE_MELEE_DAMAGE,SELFONLY,SPLASH,IGNORE_TARGET_RATING', '', 'NONE', '1+k*9', '', '', '', '', '', '50+150*k', '0', '0', 'MELEE', '12', '1', '0', '500'); INSERT INTO `skill_proto` VALUES ('63', '±Í°Ë', '3', '1', '1', '0', 'ATT_GRADE', '(3 * iq + 2 * lv)*k', '20+240*k', '50+100*k', '2+23*k', '0', '(3 * iq + 2 * lv)*k', '', 'SELFONLY,TOGGLE', 'GWIGUM', 'HIT_HP_RECOVER', '10*k', '50+80*k', '', '', '', '', '20+240*k', '0', '0', 'NORMAL', '1', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('64', '°øÆ÷', '3', '1', '1', '0', 'DODGE', '1 + 29 * k', '60+120*k', '60+100*k', '', '100', '1 + 29 * k', '', 'SELFONLY', 'TERROR', 'NONE', '', '', '', '', '', '', '60+120*k', '0', '0', 'NORMAL', '1', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('65', 'ÁÖ¸¶°©', '3', '1', '1', '0', 'DEF_GRADE', '(iq+30)*k', '70+170*k', '30+120*k', '', '33+140*k', '(iq+30)*k', '', 'SELFONLY', 'JUMAGAP', 'REFLECT_MELEE', '(iq/4+10)*k', '30+120*k', '', '', '', '', '70+170*k', '0', '0', 'NORMAL', '1', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('66', 'ÆĹý¼ú', '3', '1', '1', '0', 'HP', '-(40 +5*lv + 2*iq+(10*iq + 7*mwep + number(50,100) )*ar*k)', '30+120*k', '', '', '12', '-(40 +5*lv + 2*iq+(10*iq + 7*mwep + number(50,100) )*ar*k)', '', 'ATTACK,COMPUTE_MAGIC_DAMAGE,SPLASH,REMOVE_GOOD_AFFECT', '', 'NONE', '10+40*k', '7+23*k', '', '', '', '', '30+120*k', '0', '0', 'NORMAL', '5', '0.6', '1800', '200'); INSERT INTO `skill_proto` VALUES ('76', '¸¶·É', '3', '1', '1', '0', 'HP', '-(40 +5*lv + 2*iq +(13*iq + 6*mwep + number(50,100) )*ar*k)', '30+140*k', '', '', '7', '-(40 +5*lv + 2*iq +(13*iq + 6*mwep + number(50,100) )*ar*k)', '', 'ATTACK,COMPUTE_MAGIC_DAMAGE,SPLASH', '', 'NONE', '', '', '', '', '', '', '30+140*k', '0', '0', 'MAGIC', '5', '0.6', '1500', '200'); INSERT INTO `skill_proto` VALUES ('77', 'È¿°Æø', '3', '1', '1', '0', 'HP', '-(5*lv + 2*iq+(10*iq + 6*mwep + str*4 + con*2 + number(180,200) )*k)', '60+140*k', '', '', '12', '-(5*lv + 2*iq+(10*iq + 6*mwep + str*4 + con*2 + number(180,200) )*k)', '', 'ATTACK,SELFONLY,COMPUTE_MAGIC_DAMAGE,SPLASH', '', 'NONE', '', '', '', '', '', '', '60+140*k', '0', '0', 'MAGIC', '15', '0.8', '0', '500'); INSERT INTO `skill_proto` VALUES ('78', '¹«¿µÁø', '3', '1', '1', '0', 'HP', '-(30+ 2*lv + 2*iq+(7*iq + 6*mwep + number(200,500))*ar*k)', '20+30*k', '40+30*k', '5+40*k', '43+30*k', '-(30+ 2*lv + 2*iq+(7*iq + 6*mwep + number(200,500))*ar*k)', '', 'ATTACK,COMPUTE_MAGIC_DAMAGE,SPLASH,TOGGLE', '', 'NONE', '', '', '', '', '', '', '20+30*k', '0', '0', 'MAGIC', '1', '1', '800', '0'); INSERT INTO `skill_proto` VALUES ('79', 'Èæ½Å¼öÈ£', '3', '1', '1', '0', 'DEF_GRADE', '(0.5*iq+15)*k', '20+30*k', '60+120*k', '5+10*k', '63+10*k', '(0.5*iq+15)*k', '', 'SELFONLY,TOGGLE', 'MANASHIELD', 'MANASHIELD', '100-((iq*0.84)*k)', '60+10*k', '', '', '', '', '20+30*k', '0', '0', 'MAGIC', '1', '0.8', '0', '0'); INSERT INTO `skill_proto` VALUES ('80', 'Åõ¼Ó¸¶·É', '3', '1', '1', '0', 'HP', '-(40 + 2* lv + 2*iq +(2 * con + 2 * dex + 13*iq + 6*mwep + number(180, 200))*ar*k)', '40+120*k', '', '', '12', '-(40 + 2* lv + 2*iq +(2 * con + 2 * dex + 13*iq + 6*mwep + number(180, 200))*ar*k)', '', 'ATTACK,COMPUTE_MAGIC_DAMAGE,SPLASH,ATTACK_SLOW', '', 'NONE', '333+300*k', '10+10*k', '', '', '', '', '40+120*k', '0', '0', 'MAGIC', '9', '0.8', '1200', '400'); INSERT INTO `skill_proto` VALUES ('81', '¸¶È¯°Ý', '3', '1', '1', '0', 'HP', '-(120 + 6*lv + (5 * con + 5 * dex + 29*iq + 9*mwep)*ar*k)', '80+220*k', '', '', '24', '-(120 + 6*lv + (5 * con + 5 * dex + 29*iq + 9*mwep)*ar*k)', '', 'ATTACK,COMPUTE_MAGIC_DAMAGE,SPLASH', '', 'NONE', '', '', '', '', '', '', '80+220*k', '0', '0', 'MAGIC', '9', '0.4', '1500', '200'); INSERT INTO `skill_proto` VALUES ('91', 'ºñÆĺÎ', '4', '1', '1', '0', 'HP', '-(70 + 4*lv + (20*iq+5*mwep+50)*ar*k)', '30+160*k', '', '', '7', '-(70 + 4*lv + (20*iq+5*mwep+50)*ar*k)', '', 'ATTACK,COMPUTE_MAGIC_DAMAGE,SPLASH', '', 'NONE', '', '', '', '', '', '', '30+160*k', '0', '0', 'MAGIC', '5', '0.5', '1800', '201'); INSERT INTO `skill_proto` VALUES ('92', '¿ëÆÄ»ê', '4', '1', '1', '0', 'HP', '-(60 + 5*lv + (18*iq + 6*mwep + 120)*ar*k)', '50+160*k', '', '', '8', '-(60 + 5*lv + (18*iq + 6*mwep + 120)*ar*k)', '', 'ATTACK,ATTACK_FIRE_CONT', '', 'NONE', 'lv+5*iq *k', 'iq*0.2*k', '', '', '', '', '50+160*k', '0', '0', 'MAGIC', '10', '0.8', '0', '0'); INSERT INTO `skill_proto` VALUES ('93', 'ÆзæÆø', '4', '1', '1', '0', 'HP', '-(80 + 6*lv + (20*iq+14*mwep+120)*ar*k)', '50+160*k', '', '', '20', '-(80 + 6*lv + (20*iq+14*mwep+120)*ar*k)', '', 'ATTACK,SELFONLY,SPLASH,ATTACK_FIRE_CONT', '', 'NONE', 'lv+5*iq *k', 'iq*0.2*k', '', '', '', '', '50+160*k', '0', '0', 'MAGIC', '15', '0.8', '0', '500'); INSERT INTO `skill_proto` VALUES ('94', 'È£½Å', '4', '1', '1', '0', 'RESIST_NORMAL', '(iq*0.3+5)*(2*k+0.5)/(k+1.5)', '40+160*k', '60+200*k', '', '10', '(iq*0.3+5)*(2*k+0.5)/(k+1.5)', '', '', 'HOSIN', 'NONE', '', '', '', '', '', '', '40+160*k', '0', '0', 'NORMAL', '1', '1', '800', '0'); INSERT INTO `skill_proto` VALUES ('95', '¹Ý»ç', '4', '1', '1', '0', 'REFLECT_MELEE', '5+(iq*0.3 + 5)*k', '40+160*k', '60+200*k', '', '10', '5+(iq*0.3 + 5)*k', '', '', 'BOHO', 'NONE', '', '', '', '', '', '', '40+160*k', '0', '0', 'NORMAL', '1', '1', '1000', '0'); INSERT INTO `skill_proto` VALUES ('96', '±âõ´ë°ø', '4', '1', '1', '0', 'CRITICAL', '(iq*0.3+5)*(2*k+0.5)/(k+1.5)', '40+160*k', '60+100*k', '', '10', '(iq*0.3+5)*(2*k+0.5)/(k+1.5)', '', '', 'GICHEON', 'NONE', '', '', '', '', '', '', '40+160*k', '0', '0', 'NORMAL', '1', '1', '1000', '0'); INSERT INTO `skill_proto` VALUES ('106', '³úÀü·É', '4', '1', '1', '0', 'HP', '-(60 + 4*lv + (7*iq+8*mwep+number(iq*5,iq*15))*ar*k)', '30+150*k', '', '', '7', '-(60 + 4*lv + (7*iq+8*mwep+number(iq*5,iq*15))*ar*k)', '', 'ATTACK,SPLASH', '', 'NONE', '', '', '', '', '', '', '30+150*k', '0', '0', 'MAGIC', '5', '0.6', '1800', '200'); INSERT INTO `skill_proto` VALUES ('107', 'º¶ô', '4', '1', '1', '0', 'HP', '-(40 + 4*lv + (13*iq+7*mwep+number(iq*5,iq*16))*ar*k)', '50+150*k', '', '', '15', '-(40 + 4*lv + (13*iq+7*mwep+number(iq*5,iq*16))*ar*k)', '', 'ATTACK,SPLASH,ATTACK_STUN', '', 'NONE', '50+1000*k/6', '5', '', '', '', '', '50+150*k', '0', '0', 'MAGIC', '15', '0.8', '1500', '400'); INSERT INTO `skill_proto` VALUES ('108', 'Æø·Ú°Ý', '4', '1', '1', '0', 'HP', '-(50 + 5*lv + (6*iq+6*mwep+number(1,800))*ar*k) * (1-chain*0.13)', '40+180*k', '', '', '10', '-(50 + 5*lv + (6*iq+6*mwep+number(1,800))*ar*k) * (1-chain*0.13)', '', 'ATTACK', '', 'NONE', '', '', '', '', '', '', '40+180*k', '0', '0', 'MAGIC', '7', '0.8', '2500', '0'); INSERT INTO `skill_proto` VALUES ('109', 'Á¤¾÷ÀÎ', '4', '1', '1', '0', 'HP', '200+7*lv+(30*iq+6*mwep+600)*k', '40+200*k', '', '', '10', '200+7*lv+(30*iq+6*mwep+600)*k', '', 'REMOVE_BAD_AFFECT', '', 'NONE', '20+80*k', '0', '', '', '', '', '40+200*k', '0', '0', 'NORMAL', '1', '1', '1000', '0'); INSERT INTO `skill_proto` VALUES ('110', 'Äè¼Ó', '4', '1', '1', '0', 'MOV_SPEED', '5 + 35*k', '60+120*k', '60+100*k', '', '10', '5 + 35*k', '', '', 'KWAESOK', 'CASTING_SPEED', '3+33*k', '60+100*k', '', '', '', '', '60+120*k', '0', '0', 'NORMAL', '1', '1', '1000', '0'); INSERT INTO `skill_proto` VALUES ('111', 'Áõ·Â¼ú', '4', '1', '1', '0', 'ATT_GRADE', '10+(iq*0.4 +20)*k', '60+120*k', '60+100*k', '', '10', '10+(iq*0.4 +30)*k', '', '', 'JEUNGRYEOK', 'NONE', '', '', '', '', '', '', '60+120*k', '0', '0', 'NORMAL', '1', '1', '1000', '0'); INSERT INTO `skill_proto` VALUES ('121', 'Åë¼Ö·Â', '0', '1', '40', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('122', '¿¬°è±â', '0', '1', '2', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('124', '䱤¼ú', '0', '1', '40', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('125', 'º¯½Å', '0', '1', '40', '0', 'NONE', '', '', '10+1000*k', '', '', '', '', 'DISABLE_BY_POINT_UP', 'YMIR', 'NONE', '', '', 'YMIR', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '1000', '0'); INSERT INTO `skill_proto` VALUES ('126', '½Å¼ö¾î', '0', '1', '20', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('127', 'õÁ¶¾î', '0', '1', '20', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('128', 'Áø³ë¾î', '0', '1', '20', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('129', 'µÐ°©¼ú', '0', '1', '40', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', 'NONE', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('130', '½Â¸¶', '0', '1', '1', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('131', '¸»¼Òȯ', '0', '1', '10', '0', 'NONE', '', '', '', '', '', '', '', 'DISABLE_BY_POINT_UP', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('137', '³¹«', '5', '1', '1', '50', 'HP', '-(atk+(2*atk*k))', '60+80*k', '', '', '5-(4*k)', '', '', 'ATTACK,USE_MELEE_DAMAGE,CRUSH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'MELEE', '10', '1', '300', '0'); INSERT INTO `skill_proto` VALUES ('138', 'µ¹°Ý', '5', '1', '1', '52', 'HP', '-(2.4*(200+1.5*lv)+(3*200*k))', '60+120*k', '', '', '15', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH_LONG', '', 'MOV_SPEED', '50', '5', '', '', '', '', '', '0', '0', 'MELEE', '6', '1', '400', '100'); INSERT INTO `skill_proto` VALUES ('139', 'Å»Ãâ', '5', '1', '1', '55', 'HP', '-(2*(200+1.5*lv)+(3*200*k))', '60+160*k', '', '', '20', '', '', 'ATTACK,USE_MELEE_DAMAGE,SELFONLY,SPLASH,CRUSH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'MELEE', '12', '1', '400', '250'); INSERT INTO `skill_proto` VALUES ('140', '³¹«(È°)', '5', '1', '1', '50', 'HP', '-(atk+(2*atk*k))', '60+80*k', '', '', '10', '', '', 'ATTACK,USE_ARROW_DAMAGE,CRUSH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', '', '5', '1', '2500', '0'); INSERT INTO `skill_proto` VALUES ('151', '¿ë¾È', '0', '1', '7', '0', 'NONE', '', '', '', '', '', '', '', '', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('152', '¿ë½ÅÀÇÇÇ', '0', '1', '7', '0', 'MAX_HP', 'maxhp*0.2*k', '150+150*k', '300', '', '600', '', '', '', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('153', '¿ë½ÅÀÇÃູ', '0', '1', '7', '0', 'MAX_SP', 'maxsp*0.2*k', '150+150*k', '300', '', '600', '', '', '', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('154', '¼ºÈÖ°©', '0', '1', '7', '0', 'DEF_GRADE', 'odef*0.1*k', '150+150*k', '180', '', '480', '', '', '', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('155', '°¡¼ÓÈ', '0', '1', '7', '0', 'MOV_SPEED', '15*k', '150+150*k', '180', '', '480', '', '', '', '', 'ATT_SPEED', '15*k', '180', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('156', '¿ë½ÅÀǺгë', '0', '1', '7', '0', 'CRITICAL', '50*k', '150+150*k', '180', '', '480', '', '', 'SELFONLY', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('157', 'ÁÖ¹®¼ú', '0', '1', '7', '0', 'CASTING_SPEED', '50*k', '150+150*k', '180', '', '480', '', '', 'SELFONLY', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('158', '±æµåÀ̵¿', '0', '1', '3', '0', 'NONE', '', '', '', '', '', '', '', 'SELFONLY', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('159', '°ø°£Àǹ®', '0', '1', '5', '0', 'NONE', '', '', '', '', '', '', '', 'SELFONLY', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('160', '°¡¼ÓÈ', '0', '1', '5', '0', 'NONE', '3*k', '80-12*k', '300', '', '', '', '', 'SELFONLY', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('161', '°ø°£Àǹ®', '0', '1', '2', '0', 'NONE', '', '50', '', '', '', '', '', '', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('162', '°ø°£À̵¿', '0', '1', '2', '0', 'NONE', '', '20', '', '', '', '', '', '', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'NORMAL', '0', '1', '0', '0'); INSERT INTO `skill_proto` VALUES ('256', 'CRUSH200½ºÅ³', '0', '1', '1', '0', 'HP', '-5*k*atk', '', '', '', '4', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'MELEE', '0', '1', '0', '300'); INSERT INTO `skill_proto` VALUES ('257', 'ÀϹݹüÀ§350½ºÅ³', '0', '1', '1', '0', 'HP', '-5*k*atk', '', '', '', '6', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'MELEE', '0', '1', '0', '525'); INSERT INTO `skill_proto` VALUES ('258', 'CRUSH300½ºÅ³', '0', '1', '1', '0', 'HP', '-5*k*atk', '', '', '', '8', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'MELEE', '0', '1', '0', '450'); INSERT INTO `skill_proto` VALUES ('259', 'ÀϹݹüÀ§200½ºÅ³', '0', '1', '1', '0', 'HP', '-5*k*atk', '', '', '', '10', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'MELEE', '0', '1', '0', '300'); INSERT INTO `skill_proto` VALUES ('260', 'CURSH400½ºÅ³', '0', '1', '1', '0', 'HP', '-5*k*atk', '', '', '', '12', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,CRUSH', '', 'NONE', '', '', '', '', '', '', '', '0', '0', 'MELEE', '0', '1', '0', '600'); INSERT INTO `skill_proto` VALUES ('261', 'µ¶250½ºÅ³', '0', '1', '1', '0', 'HP', '-5*k*atk', '', '', '', '10', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH,ATTACK_POISON', '', 'NONE', '80', '', '', '', '', '', '', '0', '0', 'MELEE', '0', '1', '0', '375'); INSERT INTO `skill_proto` VALUES ('262', 'SLOW300½ºÅ³', '0', '1', '1', '0', 'HP', '-5*k*atk', '', '', '', '14', '', '', 'ATTACK,USE_MELEE_DAMAGE,SPLASH', '', 'MOV_SPEED', '-20', '10', '', '', '', '', '', '0', '0', 'MELEE', '0', '1', '0', '450'); shop_item (SG) Spoiler -- ---------------------------- -- Table structure for `shop_item` -- ---------------------------- DROP TABLE IF EXISTS `shop_item`; CREATE TABLE `shop_item` ( `shop_vnum` int(11) NOT NULL DEFAULT '0', `item_vnum` int(11) NOT NULL DEFAULT '0', `count` tinyint(4) unsigned NOT NULL DEFAULT '1', UNIQUE KEY `vnum_unique` (`shop_vnum`,`item_vnum`,`count`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of shop_item -- ---------------------------- INSERT INTO `shop_item` VALUES ('1', '20', '1'); INSERT INTO `shop_item` VALUES ('1', '40', '1'); INSERT INTO `shop_item` VALUES ('1', '60', '1'); INSERT INTO `shop_item` VALUES ('1', '80', '1'); INSERT INTO `shop_item` VALUES ('1', '1040', '1'); INSERT INTO `shop_item` VALUES ('1', '2010', '1'); INSERT INTO `shop_item` VALUES ('1', '2030', '1'); INSERT INTO `shop_item` VALUES ('1', '2050', '1'); INSERT INTO `shop_item` VALUES ('1', '2070', '1'); INSERT INTO `shop_item` VALUES ('1', '3010', '1'); INSERT INTO `shop_item` VALUES ('1', '3030', '1'); INSERT INTO `shop_item` VALUES ('1', '3050', '1'); INSERT INTO `shop_item` VALUES ('1', '3070', '1'); INSERT INTO `shop_item` VALUES ('1', '4000', '1'); INSERT INTO `shop_item` VALUES ('1', '4010', '1'); INSERT INTO `shop_item` VALUES ('1', '4020', '1'); INSERT INTO `shop_item` VALUES ('1', '5010', '1'); INSERT INTO `shop_item` VALUES ('1', '5030', '1'); INSERT INTO `shop_item` VALUES ('1', '7010', '1'); INSERT INTO `shop_item` VALUES ('1', '7030', '1'); INSERT INTO `shop_item` VALUES ('1', '7050', '1'); INSERT INTO `shop_item` VALUES ('1', '8000', '100'); INSERT INTO `shop_item` VALUES ('1', '8000', '200'); INSERT INTO `shop_item` VALUES ('2', '27400', '1'); INSERT INTO `shop_item` VALUES ('2', '27600', '1'); INSERT INTO `shop_item` VALUES ('2', '27610', '1'); INSERT INTO `shop_item` VALUES ('2', '27800', '5'); INSERT INTO `shop_item` VALUES ('2', '27800', '50'); INSERT INTO `shop_item` VALUES ('2', '27801', '5'); INSERT INTO `shop_item` VALUES ('2', '27801', '50'); INSERT INTO `shop_item` VALUES ('3', '14000', '1'); INSERT INTO `shop_item` VALUES ('3', '15000', '1'); INSERT INTO `shop_item` VALUES ('3', '16000', '1'); INSERT INTO `shop_item` VALUES ('3', '17000', '1'); INSERT INTO `shop_item` VALUES ('3', '27001', '5'); INSERT INTO `shop_item` VALUES ('3', '27001', '20'); INSERT INTO `shop_item` VALUES ('3', '27001', '200'); INSERT INTO `shop_item` VALUES ('3', '27002', '5'); INSERT INTO `shop_item` VALUES ('3', '27002', '20'); INSERT INTO `shop_item` VALUES ('3', '27002', '200'); INSERT INTO `shop_item` VALUES ('3', '27003', '5'); INSERT INTO `shop_item` VALUES ('3', '27003', '20'); INSERT INTO `shop_item` VALUES ('3', '27003', '200'); INSERT INTO `shop_item` VALUES ('3', '27004', '5'); INSERT INTO `shop_item` VALUES ('3', '27004', '20'); INSERT INTO `shop_item` VALUES ('3', '27004', '200'); INSERT INTO `shop_item` VALUES ('3', '27005', '5'); INSERT INTO `shop_item` VALUES ('3', '27005', '20'); INSERT INTO `shop_item` VALUES ('3', '27005', '200'); INSERT INTO `shop_item` VALUES ('3', '27006', '5'); INSERT INTO `shop_item` VALUES ('3', '27006', '20'); INSERT INTO `shop_item` VALUES ('3', '27006', '200'); INSERT INTO `shop_item` VALUES ('3', '50200', '1'); INSERT INTO `shop_item` VALUES ('3', '50901', '10'); INSERT INTO `shop_item` VALUES ('3', '71113', '20'); INSERT INTO `shop_item` VALUES ('4', '11200', '1'); INSERT INTO `shop_item` VALUES ('4', '11220', '1'); INSERT INTO `shop_item` VALUES ('4', '11230', '1'); INSERT INTO `shop_item` VALUES ('4', '11400', '1'); INSERT INTO `shop_item` VALUES ('4', '11420', '1'); INSERT INTO `shop_item` VALUES ('4', '11430', '1'); INSERT INTO `shop_item` VALUES ('4', '11600', '1'); INSERT INTO `shop_item` VALUES ('4', '11620', '1'); INSERT INTO `shop_item` VALUES ('4', '11630', '1'); INSERT INTO `shop_item` VALUES ('4', '11800', '1'); INSERT INTO `shop_item` VALUES ('4', '11820', '1'); INSERT INTO `shop_item` VALUES ('4', '11830', '1'); INSERT INTO `shop_item` VALUES ('4', '12200', '1'); INSERT INTO `shop_item` VALUES ('4', '12340', '1'); INSERT INTO `shop_item` VALUES ('4', '12480', '1'); INSERT INTO `shop_item` VALUES ('4', '12620', '1'); INSERT INTO `shop_item` VALUES ('4', '13000', '1'); INSERT INTO `shop_item` VALUES ('5', '3100', '1'); INSERT INTO `shop_item` VALUES ('5', '5020', '1'); INSERT INTO `shop_item` VALUES ('5', '5030', '1'); INSERT INTO `shop_item` VALUES ('5', '5040', '1'); INSERT INTO `shop_item` VALUES ('5', '5050', '1'); INSERT INTO `shop_item` VALUES ('5', '5070', '1'); INSERT INTO `shop_item` VALUES ('5', '5080', '1'); INSERT INTO `shop_item` VALUES ('5', '7020', '1'); INSERT INTO `shop_item` VALUES ('5', '7050', '1'); INSERT INTO `shop_item` VALUES ('5', '7060', '1'); INSERT INTO `shop_item` VALUES ('5', '7090', '1'); INSERT INTO `shop_item` VALUES ('5', '7100', '1'); INSERT INTO `shop_item` VALUES ('6', '14000', '1'); INSERT INTO `shop_item` VALUES ('6', '14020', '1'); INSERT INTO `shop_item` VALUES ('6', '14040', '1'); INSERT INTO `shop_item` VALUES ('6', '14060', '1'); INSERT INTO `shop_item` VALUES ('6', '14080', '1'); INSERT INTO `shop_item` VALUES ('6', '14140', '1'); INSERT INTO `shop_item` VALUES ('6', '15000', '1'); INSERT INTO `shop_item` VALUES ('6', '15020', '1'); INSERT INTO `shop_item` VALUES ('6', '15040', '1'); INSERT INTO `shop_item` VALUES ('6', '15060', '1'); INSERT INTO `shop_item` VALUES ('6', '15080', '1'); INSERT INTO `shop_item` VALUES ('6', '15160', '1'); INSERT INTO `shop_item` VALUES ('6', '16000', '1'); INSERT INTO `shop_item` VALUES ('6', '16020', '1'); INSERT INTO `shop_item` VALUES ('6', '16040', '1'); INSERT INTO `shop_item` VALUES ('6', '16060', '1'); INSERT INTO `shop_item` VALUES ('6', '16080', '1'); INSERT INTO `shop_item` VALUES ('6', '16180', '1'); INSERT INTO `shop_item` VALUES ('6', '17000', '1'); INSERT INTO `shop_item` VALUES ('6', '17020', '1'); INSERT INTO `shop_item` VALUES ('6', '17040', '1'); INSERT INTO `shop_item` VALUES ('6', '17060', '1'); INSERT INTO `shop_item` VALUES ('6', '17080', '1'); INSERT INTO `shop_item` VALUES ('6', '17180', '1'); INSERT INTO `shop_item` VALUES ('7', '80003', '1'); INSERT INTO `shop_item` VALUES ('7', '80004', '1'); INSERT INTO `shop_item` VALUES ('7', '80005', '1'); INSERT INTO `shop_item` VALUES ('7', '80006', '1'); INSERT INTO `shop_item` VALUES ('7', '80007', '1'); INSERT INTO `shop_item` VALUES ('8', '50100', '100'); INSERT INTO `shop_item` VALUES ('8', '50101', '100'); INSERT INTO `shop_item` VALUES ('8', '50102', '100'); INSERT INTO `shop_item` VALUES ('8', '50103', '100'); INSERT INTO `shop_item` VALUES ('8', '50104', '100'); INSERT INTO `shop_item` VALUES ('8', '50105', '100'); INSERT INTO `shop_item` VALUES ('9', '11901', '1'); INSERT INTO `shop_item` VALUES ('9', '11903', '1'); INSERT INTO `shop_item` VALUES ('9', '50201', '1'); INSERT INTO `shop_item` VALUES ('10', '29101', '1'); INSERT INTO `shop_item` VALUES ('11', '50054', '1'); INSERT INTO `shop_item` VALUES ('11', '50055', '1'); INSERT INTO `shop_item` VALUES ('11', '50056', '1'); INSERT INTO `shop_item` VALUES ('1001', '10', '1'); INSERT INTO `shop_item` VALUES ('1001', '20', '1'); INSERT INTO `shop_item` VALUES ('1001', '30', '1'); INSERT INTO `shop_item` VALUES ('1001', '40', '1'); INSERT INTO `shop_item` VALUES ('1001', '50', '1'); INSERT INTO `shop_item` VALUES ('1001', '60', '1'); INSERT INTO `shop_item` VALUES ('1001', '70', '1'); INSERT INTO `shop_item` VALUES ('1001', '80', '1'); INSERT INTO `shop_item` VALUES ('1001', '90', '1'); INSERT INTO `shop_item` VALUES ('1001', '100', '1'); INSERT INTO `shop_item` VALUES ('1001', '110', '1'); INSERT INTO `shop_item` VALUES ('1001', '120', '1'); INSERT INTO `shop_item` VALUES ('1001', '130', '1'); INSERT INTO `shop_item` VALUES ('1002', '1000', '1'); INSERT INTO `shop_item` VALUES ('1002', '1010', '1'); INSERT INTO `shop_item` VALUES ('1002', '1020', '1'); INSERT INTO `shop_item` VALUES ('1002', '1030', '1'); INSERT INTO `shop_item` VALUES ('1002', '1040', '1'); INSERT INTO `shop_item` VALUES ('1002', '1050', '1'); INSERT INTO `shop_item` VALUES ('1002', '1060', '1'); INSERT INTO `shop_item` VALUES ('1002', '1070', '1'); INSERT INTO `shop_item` VALUES ('1002', '1080', '1'); INSERT INTO `shop_item` VALUES ('1002', '1090', '1'); INSERT INTO `shop_item` VALUES ('1002', '4000', '1'); INSERT INTO `shop_item` VALUES ('1002', '4010', '1'); INSERT INTO `shop_item` VALUES ('1002', '4020', '1'); INSERT INTO `shop_item` VALUES ('1003', '2000', '1'); INSERT INTO `shop_item` VALUES ('1003', '2010', '1'); INSERT INTO `shop_item` VALUES ('1003', '2020', '1'); INSERT INTO `shop_item` VALUES ('1003', '2030', '1'); INSERT INTO `shop_item` VALUES ('1003', '2040', '1'); INSERT INTO `shop_item` VALUES ('1003', '2050', '1'); INSERT INTO `shop_item` VALUES ('1003', '2060', '1'); INSERT INTO `shop_item` VALUES ('1003', '2070', '1'); INSERT INTO `shop_item` VALUES ('1003', '2080', '1'); INSERT INTO `shop_item` VALUES ('1003', '2090', '1'); INSERT INTO `shop_item` VALUES ('1003', '2100', '1'); INSERT INTO `shop_item` VALUES ('1003', '2110', '1'); INSERT INTO `shop_item` VALUES ('1003', '2120', '1'); INSERT INTO `shop_item` VALUES ('1003', '8000', '50'); INSERT INTO `shop_item` VALUES ('1003', '8000', '200'); INSERT INTO `shop_item` VALUES ('1004', '3000', '1'); INSERT INTO `shop_item` VALUES ('1004', '3010', '1'); INSERT INTO `shop_item` VALUES ('1004', '3020', '1'); INSERT INTO `shop_item` VALUES ('1004', '3030', '1'); INSERT INTO `shop_item` VALUES ('1004', '3040', '1'); INSERT INTO `shop_item` VALUES ('1004', '3050', '1'); INSERT INTO `shop_item` VALUES ('1004', '3060', '1'); INSERT INTO `shop_item` VALUES ('1004', '3070', '1'); INSERT INTO `shop_item` VALUES ('1004', '3080', '1'); INSERT INTO `shop_item` VALUES ('1004', '3090', '1'); INSERT INTO `shop_item` VALUES ('1004', '3100', '1'); INSERT INTO `shop_item` VALUES ('1004', '3110', '1'); INSERT INTO `shop_item` VALUES ('1004', '3120', '1'); INSERT INTO `shop_item` VALUES ('1005', '5000', '1'); INSERT INTO `shop_item` VALUES ('1005', '5010', '1'); INSERT INTO `shop_item` VALUES ('1005', '5020', '1'); INSERT INTO `shop_item` VALUES ('1005', '5030', '1'); INSERT INTO `shop_item` VALUES ('1005', '5040', '1'); INSERT INTO `shop_item` VALUES ('1005', '5050', '1'); INSERT INTO `shop_item` VALUES ('1005', '5060', '1'); INSERT INTO `shop_item` VALUES ('1005', '5070', '1'); INSERT INTO `shop_item` VALUES ('1005', '5080', '1'); INSERT INTO `shop_item` VALUES ('1006', '7000', '1'); INSERT INTO `shop_item` VALUES ('1006', '7010', '1'); INSERT INTO `shop_item` VALUES ('1006', '7020', '1'); INSERT INTO `shop_item` VALUES ('1006', '7030', '1'); INSERT INTO `shop_item` VALUES ('1006', '7040', '1'); INSERT INTO `shop_item` VALUES ('1006', '7050', '1'); INSERT INTO `shop_item` VALUES ('1006', '7060', '1'); INSERT INTO `shop_item` VALUES ('1006', '7070', '1'); INSERT INTO `shop_item` VALUES ('1006', '7080', '1'); INSERT INTO `shop_item` VALUES ('1006', '7090', '1'); INSERT INTO `shop_item` VALUES ('1006', '7100', '1'); INSERT INTO `shop_item` VALUES ('1006', '7110', '1'); INSERT INTO `shop_item` VALUES ('1006', '7120', '1'); INSERT INTO `shop_item` VALUES ('1007', '11200', '1'); INSERT INTO `shop_item` VALUES ('1007', '11210', '1'); INSERT INTO `shop_item` VALUES ('1007', '11220', '1'); INSERT INTO `shop_item` VALUES ('1007', '11230', '1'); INSERT INTO `shop_item` VALUES ('1007', '11240', '1'); INSERT INTO `shop_item` VALUES ('1007', '11250', '1'); INSERT INTO `shop_item` VALUES ('1007', '11260', '1'); INSERT INTO `shop_item` VALUES ('1008', '11400', '1'); INSERT INTO `shop_item` VALUES ('1008', '11410', '1'); INSERT INTO `shop_item` VALUES ('1008', '11420', '1'); INSERT INTO `shop_item` VALUES ('1008', '11430', '1'); INSERT INTO `shop_item` VALUES ('1008', '11440', '1'); INSERT INTO `shop_item` VALUES ('1008', '11450', '1'); INSERT INTO `shop_item` VALUES ('1008', '11460', '1'); INSERT INTO `shop_item` VALUES ('1009', '11600', '1'); INSERT INTO `shop_item` VALUES ('1009', '11610', '1'); INSERT INTO `shop_item` VALUES ('1009', '11620', '1'); INSERT INTO `shop_item` VALUES ('1009', '11630', '1'); INSERT INTO `shop_item` VALUES ('1009', '11640', '1'); INSERT INTO `shop_item` VALUES ('1009', '11650', '1'); INSERT INTO `shop_item` VALUES ('1009', '11660', '1'); INSERT INTO `shop_item` VALUES ('1010', '11800', '1'); INSERT INTO `shop_item` VALUES ('1010', '11810', '1'); INSERT INTO `shop_item` VALUES ('1010', '11820', '1'); INSERT INTO `shop_item` VALUES ('1010', '11830', '1'); INSERT INTO `shop_item` VALUES ('1010', '11840', '1'); INSERT INTO `shop_item` VALUES ('1010', '11850', '1'); INSERT INTO `shop_item` VALUES ('1010', '11860', '1'); INSERT INTO `shop_item` VALUES ('1011', '12200', '1'); INSERT INTO `shop_item` VALUES ('1011', '12220', '1'); INSERT INTO `shop_item` VALUES ('1011', '12240', '1'); INSERT INTO `shop_item` VALUES ('1012', '12340', '1'); INSERT INTO `shop_item` VALUES ('1012', '12360', '1'); INSERT INTO `shop_item` VALUES ('1012', '12380', '1'); INSERT INTO `shop_item` VALUES ('1013', '12480', '1'); INSERT INTO `shop_item` VALUES ('1013', '12500', '1'); INSERT INTO `shop_item` VALUES ('1013', '12520', '1'); INSERT INTO `shop_item` VALUES ('1014', '12620', '1'); INSERT INTO `shop_item` VALUES ('1014', '12640', '1'); INSERT INTO `shop_item` VALUES ('1014', '12660', '1'); INSERT INTO `shop_item` VALUES ('1015', '13000', '1'); INSERT INTO `shop_item` VALUES ('1015', '13040', '1'); INSERT INTO `shop_item` VALUES ('1016', '14000', '1'); INSERT INTO `shop_item` VALUES ('1016', '14020', '1'); INSERT INTO `shop_item` VALUES ('1016', '14040', '1'); INSERT INTO `shop_item` VALUES ('1016', '14060', '1'); INSERT INTO `shop_item` VALUES ('1016', '14080', '1'); INSERT INTO `shop_item` VALUES ('1016', '14100', '1'); INSERT INTO `shop_item` VALUES ('1016', '14120', '1'); INSERT INTO `shop_item` VALUES ('1016', '14140', '1'); INSERT INTO `shop_item` VALUES ('1016', '14160', '1'); INSERT INTO `shop_item` VALUES ('1016', '14180', '1'); INSERT INTO `shop_item` VALUES ('1016', '14200', '1'); INSERT INTO `shop_item` VALUES ('1017', '15000', '1'); INSERT INTO `shop_item` VALUES ('1017', '15020', '1'); INSERT INTO `shop_item` VALUES ('1017', '15040', '1'); INSERT INTO `shop_item` VALUES ('1017', '15060', '1'); INSERT INTO `shop_item` VALUES ('1017', '15080', '1'); INSERT INTO `shop_item` VALUES ('1017', '15100', '1'); INSERT INTO `shop_item` VALUES ('1017', '15120', '1'); INSERT INTO `shop_item` VALUES ('1017', '15140', '1'); INSERT INTO `shop_item` VALUES ('1017', '15160', '1'); INSERT INTO `shop_item` VALUES ('1017', '15180', '1'); INSERT INTO `shop_item` VALUES ('1017', '15200', '1'); INSERT INTO `shop_item` VALUES ('1017', '15220', '1'); INSERT INTO `shop_item` VALUES ('1018', '16000', '1'); INSERT INTO `shop_item` VALUES ('1018', '16020', '1'); INSERT INTO `shop_item` VALUES ('1018', '16040', '1'); INSERT INTO `shop_item` VALUES ('1018', '16060', '1'); INSERT INTO `shop_item` VALUES ('1018', '16080', '1'); INSERT INTO `shop_item` VALUES ('1018', '16100', '1'); INSERT INTO `shop_item` VALUES ('1018', '16120', '1'); INSERT INTO `shop_item` VALUES ('1018', '16140', '1'); INSERT INTO `shop_item` VALUES ('1018', '16160', '1'); INSERT INTO `shop_item` VALUES ('1018', '16180', '1'); INSERT INTO `shop_item` VALUES ('1018', '16200', '1'); INSERT INTO `shop_item` VALUES ('1019', '17000', '1'); INSERT INTO `shop_item` VALUES ('1019', '17020', '1'); INSERT INTO `shop_item` VALUES ('1019', '17040', '1'); INSERT INTO `shop_item` VALUES ('1019', '17060', '1'); INSERT INTO `shop_item` VALUES ('1019', '17080', '1'); INSERT INTO `shop_item` VALUES ('1019', '17100', '1'); INSERT INTO `shop_item` VALUES ('1019', '17120', '1'); INSERT INTO `shop_item` VALUES ('1019', '17140', '1'); INSERT INTO `shop_item` VALUES ('1019', '17160', '1'); INSERT INTO `shop_item` VALUES ('1019', '17180', '1'); INSERT INTO `shop_item` VALUES ('1019', '17200', '1'); 33 1 1 2 2 1 1 24 6 78 Link to comment Share on other sites More sharing options...
Padrio 991 Posted February 14, 2014 Share Posted February 14, 2014 Does this work with 40k, too? I've heard they have some new bonuses in 40k Gesendet von meinem Nexus 5 mit Tapatalk Link to comment Share on other sites More sharing options...
Premium Shogun 4606 Posted February 14, 2014 Author Premium Share Posted February 14, 2014 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. Link to comment Share on other sites More sharing options...
MadTiago 47 Posted February 14, 2014 Share Posted February 14, 2014 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. Link to comment Share on other sites More sharing options...
Mehti 76 Posted February 15, 2014 Share Posted February 15, 2014 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/#!SZEDGZBS!B8hEfsGO-cxYXOx_y_Oc4F_eGXaEKtq28yKuDhIRrag When not busy please dump with standart INSERT. Link to comment Share on other sites More sharing options...
Premium Shogun 4606 Posted February 15, 2014 Author Premium Share Posted February 15, 2014 When not busy please dump with standart INSERT. Working on that 2 Link to comment Share on other sites More sharing options...
Rumor 2622 Posted February 15, 2014 Share Posted February 15, 2014 to use the player.sql you need to change InnoDB to MyISAM in the .sql file. Link to comment Share on other sites More sharing options...
Premium Shogun 4606 Posted February 15, 2014 Author Premium Share Posted February 15, 2014 to use the player.sql you need to change InnoDB to MyISAM in the .sql file. I fixed that now. 1 Link to comment Share on other sites More sharing options...
Mehti 76 Posted February 16, 2014 Share Posted February 16, 2014 whats up on INSERT ? Link to comment Share on other sites More sharing options...
Premium Shogun 4606 Posted February 16, 2014 Author Premium Share Posted February 16, 2014 whats up on INSERT ? Need to find the official ones on my disk, WoM's db is too modified for this release. Link to comment Share on other sites More sharing options...
Premium Amok 28 Posted February 20, 2014 Premium Share Posted February 20, 2014 any new infos ? ..,- Link to comment Share on other sites More sharing options...
Premium Shogun 4606 Posted February 25, 2014 Author Premium Share Posted February 25, 2014 Sorry for the delay guys, been really busy at Wom. I will add the 40k item_attr and object proto (all versions) today. 1 Link to comment Share on other sites More sharing options...
Mehti 76 Posted February 25, 2014 Share Posted February 25, 2014 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 Link to comment Share on other sites More sharing options...
Saddler 684 Posted February 26, 2014 Share Posted February 26, 2014 Shogun you will publish 40k item_attr and object_proto ? Regards Link to comment Share on other sites More sharing options...
Premium Amok 28 Posted February 26, 2014 Premium Share Posted February 26, 2014 Look First Post its already there ..,- Link to comment Share on other sites More sharing options...
Premium Shogun 4606 Posted February 27, 2014 Author Premium Share Posted February 27, 2014 I can't just dump the database, I want to give you the official version not wom's. Link to comment Share on other sites More sharing options...
Mehti 76 Posted February 27, 2014 Share Posted February 27, 2014 @Shogun I try to excute skill_proto query but give this error ; Link to comment Share on other sites More sharing options...
Premium Shogun 4606 Posted February 28, 2014 Author Premium Share Posted February 28, 2014 I have edited the query. Please try again. Link to comment Share on other sites More sharing options...
Mehti 76 Posted February 28, 2014 Share Posted February 28, 2014 (edited) 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 February 28, 2014 by Mehti Link to comment Share on other sites More sharing options...
BalooUA 38 Posted April 10, 2014 Share Posted April 10, 2014 Does anyone have the player.shop table? Just the shop_item table is not enough Link to comment Share on other sites More sharing options...
mikele1923 0 Posted July 14, 2014 Share Posted July 14, 2014 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 Link to comment Share on other sites More sharing options...
mikele1923 0 Posted July 15, 2014 Share Posted July 15, 2014 (edited) With methi skill_proto i have this problem °-° How i resolv? T.T Edited August 17, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
jepcutza 5 Posted July 25, 2014 Share Posted July 25, 2014 Anyone has land.sql with the new land coordinates from new maps guild_villages ? Link to comment Share on other sites More sharing options...
astinasti 7 Posted August 21, 2014 Share Posted August 21, 2014 Help @Shogun re-upload , Mega.co.nz don't work :S Link to comment Share on other sites More sharing options...
RoxaLyssa 313 Posted August 29, 2014 Share Posted August 29, 2014 Thank you, Shogun Can someone tell me what are the differences between this skill proto and the official one? Because I also made many modifications in the skill proto and it would be a bit hard work for me to check every row. Link to comment Share on other sites More sharing options...
Recommended Posts