скажите плиз я там кароче все изменил а вот в навикат файл залить не могу....
выдает вот что
[Err] 1136 - Column count doesn't match value count at row 1
[Err] REPLACE INTO `npc` VALUES ('955', '18544', 'Molder', '1', 'Services Manager', '1', 'LineageNpcEV.trap_ironcastle', '8.00', '24.00', '85', 'etc', 'L2Npc', '40', '20000', '164', '1.15', '1.21', '40', '1', '30', '21', '20', '25', '0', '0', '40000', '50000', '50000', '50000', '999', '0', '333', '0', '0', '0', '0', '60', '125', 'NULL', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'balanced', 'false');
[Msg] Finished - Unsuccessfully
-------------------------------------------------- это пишет навикат....
а вот сам файл
REPLACE INTO `npc` VALUES ('955', '18544', 'Molder', '1', 'Services Manager', '1', 'LineageNpcEV.trap_ironcastle', '8.00', '24.00', '85', 'etc', 'L2Npc', '40', '20000', '164', '1.15', '1.21', '40', '1', '30', '21', '20', '25', '0', '0', '40000', '50000', '50000', '50000', '999', '0', '333', '0', '0', '0', '0', '60', '125', 'NULL', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'balanced', 'false');
DROP TABLE IF EXISTS `aionpc_buff_list`;
DROP TABLE IF EXISTS `aionpc_scheme_contents`;
DROP TABLE IF EXISTS `aionpc_scheme_list`;
DROP TABLE IF EXISTS `aionpc_pet_list`;
CREATE TABLE `aionpc_buff_list` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`buffType` varchar(10) DEFAULT NULL,
`buffId` int(5) DEFAULT '0',
`buffLevel` int(5) DEFAULT NULL,
`forClass` tinyint(1) DEFAULT NULL,
`canUse` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`)
) AUTO_INCREMENT=136;
CREATE TABLE `aionpc_scheme_contents` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`scheme_id` int(11) DEFAULT NULL,
`skill_id` int(8) DEFAULT NULL,
`skill_level` int(4) DEFAULT NULL,
`buff_class` int(2) DEFAULT NULL,
PRIMARY KEY (`id`)
) AUTO_INCREMENT=30;
CREATE TABLE `aionpc_scheme_list` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`player_id` varchar(40) DEFAULT NULL,
`scheme_name` varchar(36) DEFAULT NULL,
`mod_accepted` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`)
) AUTO_INCREMENT=7;
CREATE TABLE `aionpc_pet_list` (
`player_id` varchar(40) NOT NULL DEFAULT '',
`scheme_name` varchar(36) DEFAULT NULL,
PRIMARY KEY (`player_id`)
) AUTO_INCREMENT=7;
INSERT INTO `aionpc_buff_list` VALUES ('1', 'buff', '1036', '2', '2', '1');
INSERT INTO `aionpc_buff_list` VALUES ('2', 'buff', '1040', '3', '2', '1');
INSERT INTO `aionpc_buff_list` VALUES ('3', 'buff', '1043', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('4', 'buff', '1044', '3', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('5', 'buff', '1045', '6', '2', '1');
INSERT INTO `aionpc_buff_list` VALUES ('6', 'buff', '1047', '4', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('7', 'buff', '1048', '6', '2', '1');
INSERT INTO `aionpc_buff_list` VALUES ('8', 'buff', '1059', '3', '1', '1');
INSERT INTO `aionpc_buff_list` VALUES ('9', 'buff', '1062', '2', '2', '1');
INSERT INTO `aionpc_buff_list` VALUES ('10', 'buff', '1068', '3', '0', '1');
INSERT INTO `aionpc_buff_list` VALUES ('11', 'buff', '1077', '3', '0', '1');
INSERT INTO `aionpc_buff_list` VALUES ('12', 'buff', '1085', '3', '1', '1');
INSERT INTO `aionpc_buff_list` VALUES ('13', 'buff', '1086', '2', '0', '1');
INSERT INTO `aionpc_buff_list` VALUES ('14', 'buff', '1087', '3', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('15', 'buff', '1204', '2', '2', '1');
INSERT INTO `aionpc_buff_list` VALUES ('16', 'buff', '1240', '3', '0', '1');
INSERT INTO `aionpc_buff_list` VALUES ('17', 'buff', '1242', '3', '0', '1');
INSERT INTO `aionpc_buff_list` VALUES ('18', 'buff', '1243', '6', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('19', 'buff', '1257', '3', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('20', 'buff', '1268', '4', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('21', 'buff', '1303', '2', '1', '1');
INSERT INTO `aionpc_buff_list` VALUES ('22', 'buff', '1304', '3', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('23', 'buff', '1307', '3', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('24', 'buff', '1311', '6', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('25', 'buff', '1397', '3', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('26', 'buff', '1460', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('27', 'buff', '1232', '3', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('28', 'buff', '1238', '3', '3', '0');
INSERT INTO `aionpc_buff_list` VALUES ('29', 'resist', '1032', '3', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('30', 'resist', '1033', '3', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('31', 'resist', '1035', '4', '2', '1');
INSERT INTO `aionpc_buff_list` VALUES ('32', 'resist', '1078', '6', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('33', 'resist', '1182', '3', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('34', 'resist', '1189', '3', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('35', 'resist', '1191', '3', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('36', 'resist', '1259', '4', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('37', 'resist', '1352', '1', '2', '1');
INSERT INTO `aionpc_buff_list` VALUES ('38', 'resist', '1353', '1', '2', '1');
INSERT INTO `aionpc_buff_list` VALUES ('39', 'resist', '1354', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('40', 'resist', '1392', '3', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('41', 'resist', '1393', '3', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('42', 'resist', '1461', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('43', 'dance', '271', '1', '0', '1');
INSERT INTO `aionpc_buff_list` VALUES ('44', 'dance', '272', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('45', 'dance', '273', '1', '1', '1');
INSERT INTO `aionpc_buff_list` VALUES ('46', 'dance', '274', '1', '0', '1');
INSERT INTO `aionpc_buff_list` VALUES ('47', 'dance', '275', '1', '0', '1');
INSERT INTO `aionpc_buff_list` VALUES ('48', 'dance', '276', '1', '1', '1');
INSERT INTO `aionpc_buff_list` VALUES ('49', 'dance', '277', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('50', 'dance', '307', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('51', 'dance', '309', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('52', 'dance', '310', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('53', 'dance', '311', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('54', 'dance', '365', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('55', 'dance', '366', '1', '3', '0');
INSERT INTO `aionpc_buff_list` VALUES ('56', 'dance', '530', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('57', 'dance', '765', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('58', 'dance', '915', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('59', 'song', '264', '1', '2', '1');
INSERT INTO `aionpc_buff_list` VALUES ('60', 'song', '265', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('61', 'song', '266', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('62', 'song', '267', '1', '2', '1');
INSERT INTO `aionpc_buff_list` VALUES ('63', 'song', '268', '1', '2', '1');
INSERT INTO `aionpc_buff_list` VALUES ('64', 'song', '269', '1', '0', '1');
INSERT INTO `aionpc_buff_list` VALUES ('65', 'song', '270', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('66', 'song', '304', '1', '2', '1');
INSERT INTO `aionpc_buff_list` VALUES ('67', 'song', '305', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('68', 'song', '306', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('69', 'song', '308', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('70', 'song', '349', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('71', 'song', '363', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('72', 'song', '364', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('73', 'song', '529', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('74', 'song', '764', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('75', 'song', '914', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('76', 'chant', '1002', '3', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('77', 'chant', '1006', '3', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('78', 'chant', '1007', '3', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('79', 'chant', '1009', '3', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('80', 'chant', '1251', '2', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('81', 'chant', '1252', '3', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('82', 'chant', '1253', '3', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('83', 'chant', '1284', '3', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('84', 'chant', '1308', '3', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('85', 'chant', '1309', '3', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('86', 'chant', '1310', '4', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('87', 'chant', '1362', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('88', 'others', '834', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('89', 'others', '1442', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('90', 'others', '1443', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('91', 'others', '1444', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('92', 'others', '825', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('93', 'others', '826', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('94', 'others', '827', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('95', 'others', '828', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('96', 'others', '829', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('97', 'others', '830', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('98', 'cubic', '67', '7', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('99', 'cubic', '10', '8', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('100', 'cubic', '22', '7', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('101', 'cubic', '33', '8', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('102', 'cubic', '278', '6', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('103', 'cubic', '449', '4', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('104', 'cubic', '1279', '9', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('105', 'cubic', '1280', '9', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('106', 'cubic', '1281', '9', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('107', 'cubic', '1328', '8', '3', '0');
INSERT INTO `aionpc_buff_list` VALUES ('108', 'cubic', '1329', '9', '3', '0');
INSERT INTO `aionpc_buff_list` VALUES ('109', 'cubic', '1330', '8', '3', '0');
INSERT INTO `aionpc_buff_list` VALUES ('110', 'cubic', '779', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('111', 'special', '1323', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('112', 'special', '1355', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('113', 'special', '1356', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('114', 'special', '1357', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('115', 'special', '1363', '1', '0', '1');
INSERT INTO `aionpc_buff_list` VALUES ('116', 'special', '1388', '3', '0', '1');
INSERT INTO `aionpc_buff_list` VALUES ('117', 'special', '1389', '3', '1', '1');
INSERT INTO `aionpc_buff_list` VALUES ('118', 'special', '1413', '1', '1', '1');
INSERT INTO `aionpc_buff_list` VALUES ('119', 'special', '1416', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('120', 'special', '1457', '1', '3', '0');
INSERT INTO `aionpc_buff_list` VALUES ('121', 'special', '4699', '13', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('122', 'special', '4700', '13', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('123', 'special', '4702', '13', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('124', 'special', '4703', '13', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('125', 'special', '1499', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('126', 'special', '1500', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('127', 'special', '1501', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('128', 'special', '1502', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('129', 'special', '1503', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('130', 'special', '1504', '1', '3', '1');
INSERT INTO `aionpc_buff_list` VALUES ('131', 'special', '1519', '1', '3', '1');
REPLACE INTO `skill_learn` (`npc_id`, `class_id`) VALUES
(955, 0),
(955, 1),
(955, 2),
(955, 3),
(955, 4),
(955, 5),
(955, 6),
(955, 7),
(955, 8),
(955, 9),
(955, 10),
(955, 11),
(955, 12),
(955, 13),
(955, 14),
(955, 15),
(955, 16),
(955, 17),
(955, 18),
(955, 19),
(955, 20),
(955, 21),
(955, 22),
(955, 23),
(955, 24),
(955, 25),
(955, 26),
(955, 27),
(955, 28),
(955, 29),
(955, 30),
(955, 31),
(955, 32),
(955, 33),
(955, 34),
(955, 35),
(955, 36),
(955, 37),
(955, 38),
(955, 39),
(955, 40),
(955, 41),
(955, 42),
(955, 43),
(955, 44),
(955, 45),
(955, 46),
(955, 47),
(955, 48),
(955, 49),
(955, 50),
(955, 51),
(955, 52),
(955, 53),
(955, 54),
(955, 55),
(955, 56),
(955, 57),
(955, 58),
(955, 59),
(955, 60),
(955, 61),
(955, 62),
(955, 63),
(955, 64),
(955, 65),
(955, 66),
(955, 67),
(955, 68),
(955, 69),
(955, 70),
(955, 71),
(955, 72),
(955, 73),
(955, 74),
(955, 75),
(955, 76),
(955, 77),
(955, 78),
(955, 79),
(955, 80),
(955, 81),
(955, 82),
(955, 83),
(955, 84),
(955, 85),
(955, 86),
(955, 87),
(955, 88),
(955, 89),
(955, 90),
(955, 91),
(955, 92),
(955, 93),
(955, 94),
(955, 95),
(955, 96),
(955, 97),
(955, 98),
(955, 99),
(955, 100),
(955, 101),
(955, 102),
(955, 103),
(955, 104),
(955, 105),
(955, 106),
(955, 107),
(955, 108),
(955, 109),
(955, 110),
(955, 111),
(955, 112),
(955, 113),
(955, 114),
(955, 115),
(955, 116),
(955, 117),
(955, 118),
(955, 119),
(955, 120),
(955, 121),
(955, 122),
(955, 123),
(955, 124),
(955, 125),
(955, 126),
(955, 127),
(955, 128),
(955, 129),
(955, 130),
(955, 131),
(955, 132),
(955, 133),
(955, 134),
(955, 135),
(955, 136);
подскажите че делать.....