Не Могу Залить Нпц В Бд

[MeteorlAl 1]

Скрытый текст

[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `npc` VALUES (700,700, "Osama Bin Laden", 0, "", 0, "LineageMonster.death_lord", 10, 89, 15, "male", "L2Npc", 40, 1200000, 164, 3.95, 1.21, 40, 43, 30, 21, 20, 25, 0, 0, 9, 19, 3, 17, 304, 0, 333, 3907, 0, 0, 24, 125, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "fighter", "false");
[Msg] Finished - Unsuccessfully

Что не так?

Вот сам файл SQL

Скрытый текст

INSERT INTO `npc` VALUES (700,700, "Osama Bin Laden", 0, "", 0, "LineageMonster.death_lord", 10, 89, 15, "male", "L2Npc", 40, 1200000, 164, 3.95, 1.21, 40, 43, 30, 21, 20, 25, 0, 0, 9, 19, 3, 17, 304, 0, 333, 3907, 0, 0, 24, 125, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "fighter", "false");
INSERT INTO `npc` VALUES (701,701, "Osama Bin Laden", 0, "", 0, "LineageMonster.death_lord", 10, 89, 15, "male", "L2Npc", 40, 1200000, 164, 3.95, 1.21, 40, 43, 30, 21, 20, 25, 0, 0, 9, 19, 3, 17, 304, 0, 333, 3907, 0, 0, 24, 125, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "fighter", "false");
INSERT INTO `npc` VALUES (702,702, "Osama Bin Laden", 0, "", 0, "LineageMonster.death_lord", 10, 89, 15, "male", "L2Npc", 40, 1200000, 164, 3.95, 1.21, 40, 43, 30, 21, 20, 25, 0, 0, 9, 19, 3, 17, 304, 0, 333, 3907, 0, 0, 24, 125, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "fighter", "false");

[Artur_xD 403]

Количество столбцов не совпадает с теми что в базе.

[MeteorlAl 1]

Как это исправить?)

[Teams 30]

пиши что за сборка

так попробуй

INSERT INTO `npc` VALUES (700,700, "Osama Bin Laden", 0, "", 0, "LineageMonster.death_lord", 10, 89, 15, "male", "L2Npc", 40, 1200000, 164, 3.95, 1.21, 40, 43, 30, 21, 20, 25, 0, 0, 9, 19, 3, 17, 304, 0, 333, 3907, 0, 0, 24, 125, "NULL", 0, 0, 0, "LAST_HIT");

INSERT INTO `npc` VALUES (701,701, "Osama Bin Laden", 0, "", 0, "LineageMonster.death_lord", 10, 89, 15, "male", "L2Npc", 40, 1200000, 164, 3.95, 1.21, 40, 43, 30, 21, 20, 25, 0, 0, 9, 19, 3, 17, 304, 0, 333, 3907, 0, 0, 24, 125, "NULL", 0, 0, 0, "LAST_HIT");

INSERT INTO `npc` VALUES (702,702, "Osama Bin Laden", 0, "", 0, "LineageMonster.death_lord", 10, 89, 15, "male", "L2Npc", 40, 1200000, 164, 3.95, 1.21, 40, 43, 30, 21, 20, 25, 0, 0, 9, 19, 3, 17, 304, 0, 333, 3907, 0, 0, 24, 125, "NULL", 0, 0, 0, "LAST_HIT");

[MeteorlAl 1]

Сборка l2jx

[MeteorlAl 1]

пиши что за сборка

так попробуй

INSERT INTO `npc` VALUES (700,700, "Osama Bin Laden", 0, "", 0, "LineageMonster.death_lord", 10, 89, 15, "male", "L2Npc", 40, 1200000, 164, 3.95, 1.21, 40, 43, 30, 21, 20, 25, 0, 0, 9, 19, 3, 17, 304, 0, 333, 3907, 0, 0, 24, 125, "NULL", 0, 0, 0, "LAST_HIT");

INSERT INTO `npc` VALUES (701,701, "Osama Bin Laden", 0, "", 0, "LineageMonster.death_lord", 10, 89, 15, "male", "L2Npc", 40, 1200000, 164, 3.95, 1.21, 40, 43, 30, 21, 20, 25, 0, 0, 9, 19, 3, 17, 304, 0, 333, 3907, 0, 0, 24, 125, "NULL", 0, 0, 0, "LAST_HIT");

INSERT INTO `npc` VALUES (702,702, "Osama Bin Laden", 0, "", 0, "LineageMonster.death_lord", 10, 89, 15, "male", "L2Npc", 40, 1200000, 164, 3.95, 1.21, 40, 43, 30, 21, 20, 25, 0, 0, 9, 19, 3, 17, 304, 0, 333, 3907, 0, 0, 24, 125, "NULL", 0, 0, 0, "LAST_HIT");

Не помогло(

[KFan 7]

сборки на компе нету

 

попробуй так

 

INSERT INTO `npc` VALUES (700,700, "Osama Bin Laden", 0, "", 0, "LineageMonster.death_lord", 10, 89, 15, "male", "L2Npc", 40, 1200000, 164, 3.95, 1.21, 40, 43, 30, 21, 20, 25, 0, 0, 9, 19, 3, 17, 304, 0, 333, 3907, 0, 0, 24, 125, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "fighter");

INSERT INTO `npc` VALUES (701,701, "Osama Bin Laden", 0, "", 0, "LineageMonster.death_lord", 10, 89, 15, "male", "L2Npc", 40, 1200000, 164, 3.95, 1.21, 40, 43, 30, 21, 20, 25, 0, 0, 9, 19, 3, 17, 304, 0, 333, 3907, 0, 0, 24, 125, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "fighter");

INSERT INTO `npc` VALUES (702,702, "Osama Bin Laden", 0, "", 0, "LineageMonster.death_lord", 10, 89, 15, "male", "L2Npc", 40, 1200000, 164, 3.95, 1.21, 40, 43, 30, 21, 20, 25, 0, 0, 9, 19, 3, 17, 304, 0, 333, 3907, 0, 0, 24, 125, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "fighter");

[MeteorlAl 1]

И так не проходит

[KFan 7]

дай какой нить родной скл

[MeteorlAl 1]

Скрытый текст

12077 12077 Wolf 0 0 Monster.pet_wolf 13 11,5 15 male L2Pet 40 195 164 3,95 1,21 40 43 30 21 20 25 0 0 9 19 3 17 282 0 333 0 0 0 26 137 0 0 0 LAST_HIT 0 0 0 fighter

[KFan 7]

INSERT INTO `npc` VALUES (700,700, "Osama Bin Laden", 0, 0, "LineageMonster.death_lord", 10, 89, 15, "male", "L2Npc", 40, 1200000, 164, 3.95, 1.21, 40, 43, 30, 21, 20, 25, 0, 0, 9, 19, 3, 17, 304, 0, 333, 3907, 0, 0, 24, 125, 0, 0, 0, "LAST_HIT", 0, 0, 0, "fighter");

INSERT INTO `npc` VALUES (701,701, "Osama Bin Laden", 0, 0, "LineageMonster.death_lord", 10, 89, 15, "male", "L2Npc", 40, 1200000, 164, 3.95, 1.21, 40, 43, 30, 21, 20, 25, 0, 0, 9, 19, 3, 17, 304, 0, 333, 3907, 0, 0, 24, 125, 0, 0, 0, "LAST_HIT", 0, 0, 0, "fighter");

INSERT INTO `npc` VALUES (702,702, "Osama Bin Laden", 0, 0, "LineageMonster.death_lord", 10, 89, 15, "male", "L2Npc", 40, 1200000, 164, 3.95, 1.21, 40, 43, 30, 21, 20, 25, 0, 0, 9, 19, 3, 17, 304, 0, 333, 3907, 0, 0, 24, 125, 0, 0, 0, "LAST_HIT", 0, 0, 0, "fighter");

[MeteorlAl 1]

Не пашет(

[KFan 7]

дай мне скл родной не ctrl+v а нормально из файла NPC.SQL еще скажи что ты не умеешь

[MeteorlAl 1]

Вот кусок из Npc sql

 

Скрытый текст

-- ----------------------------

-- Table structure for `npc`

-- ----------------------------

DROP TABLE IF EXISTS `npc`;

CREATE TABLE `npc` (

`id` decimal(11,0) NOT NULL DEFAULT '0',

`idTemplate` int(11) NOT NULL DEFAULT '0',

`name` varchar(200) DEFAULT NULL,

`serverSideName` int(1) DEFAULT '0',

`title` varchar(45) DEFAULT '',

`serverSideTitle` int(1) DEFAULT '0',

`class` varchar(200) DEFAULT NULL,

`collision_radius` decimal(5,2) DEFAULT NULL,

`collision_height` decimal(5,2) DEFAULT NULL,

`level` decimal(2,0) DEFAULT NULL,

`sex` varchar(6) DEFAULT NULL,

`type` varchar(20) DEFAULT NULL,

`attackrange` int(11) DEFAULT NULL,

`hp` decimal(8,0) DEFAULT NULL,

`mp` decimal(5,0) DEFAULT NULL,

`hpreg` decimal(8,2) DEFAULT NULL,

`mpreg` decimal(5,2) DEFAULT NULL,

`str` decimal(7,0) DEFAULT NULL,

`con` decimal(7,0) DEFAULT NULL,

`dex` decimal(7,0) DEFAULT NULL,

`int` decimal(7,0) DEFAULT NULL,

`wit` decimal(7,0) DEFAULT NULL,

`men` decimal(7,0) DEFAULT NULL,

`exp` decimal(9,0) DEFAULT NULL,

`sp` decimal(8,0) DEFAULT NULL,

`patk` decimal(5,0) DEFAULT NULL,

`pdef` decimal(5,0) DEFAULT NULL,

`matk` decimal(5,0) DEFAULT NULL,

`mdef` decimal(5,0) DEFAULT NULL,

`atkspd` decimal(3,0) DEFAULT NULL,

`aggro` decimal(6,0) DEFAULT NULL,

`matkspd` decimal(4,0) DEFAULT NULL,

`rhand` decimal(4,0) DEFAULT NULL,

`lhand` decimal(4,0) DEFAULT NULL,

`armor` decimal(1,0) DEFAULT NULL,

`walkspd` decimal(3,0) DEFAULT NULL,

`runspd` decimal(3,0) DEFAULT NULL,

`faction_id` varchar(40) DEFAULT NULL,

`faction_range` decimal(4,0) DEFAULT NULL,

`isUndead` int(11) DEFAULT '0',

`absorb_level` decimal(2,0) DEFAULT '0',

`absorb_type` enum('FULL_PARTY','LAST_HIT','PARTY_ONE_RANDOM') NOT NULL DEFAULT 'LAST_HIT',

`ss` int(4) DEFAULT '0',

`bss` int(4) DEFAULT '0',

`ss_rate` int(3) DEFAULT '0',

`AI` varchar( DEFAULT 'fighter',

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

 

-- ----------------------------

-- Records of npc

-- ----------------------------

INSERT INTO npc VALUES ('12077', '12077', 'Wolf', '0', '', '0', 'Monster.pet_wolf', '13.00', '11.50', '15', 'male', 'L2Pet', '40', '195', '164', '3.95', '1.21', '40', '43', '30', '21', '20', '25', '0', '0', '9', '19', '3', '17', '282', '0', '333', '0', '0', '0', '26', '137', null, '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter'),

('12311', '12311', 'Hatchling of the Wind', '0', '', '0', 'Monster.hatchling', '9.00', '10.00', '35', 'male', 'L2Pet', '40', '610', '433', '7.11', '1.84', '40', '43', '30', '21', '20', '25', '0', '0', '48', '42', '22', '39', '282', '0', '333', '0', '0', '0', '88', '154', null, '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter'),

('12312', '12312', 'Hatchling of the Stars', '0', '', '0', 'Monster.hatchling', '9.00', '10.00', '35', 'male', 'L2Pet', '40', '610', '433', '7.11', '1.84', '40', '43', '30', '21', '20', '25', '0', '0', '48', '42', '22', '39', '282', '0', '333', '0', '0', '0', '88', '154', null, '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter'),

('12313', '12313', 'Hatchling of Twilight', '0', '', '0', 'Monster.hatchling', '9.00', '10.00', '35', 'male', 'L2Pet', '40', '610', '433', '7.11', '1.84', '40', '43', '30', '21', '20', '25', '0', '0', '48', '42', '22', '39', '282', '0', '333', '0', '0', '0', '88', '154', null, '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter'),

[KFan 7]

INSERT INTO `npc` VALUES (700,700, "Osama Bin Laden", 0,"", 0, "LineageMonster.death_lord", 10, 89, 15, "male", "L2Npc", 40, 1200000, 164, 3.95, 1.21, 40, 43, 30, 21, 20, 25, 0, 0, 9, 19, 3, 17, 304, 0, 333, 3907, 0, 0, 24, 125, null, 0, 0, 0, "LAST_HIT", 0, 0, 0, "fighter");

INSERT INTO `npc` VALUES (701,701, "Osama Bin Laden", 0,"", 0, "LineageMonster.death_lord", 10, 89, 15, "male", "L2Npc", 40, 1200000, 164, 3.95, 1.21, 40, 43, 30, 21, 20, 25, 0, 0, 9, 19, 3, 17, 304, 0, 333, 3907, 0, 0, 24, 125, null, 0, 0, 0, "LAST_HIT", 0, 0, 0, "fighter");

INSERT INTO `npc` VALUES (702,702, "Osama Bin Laden", 0, "", 0, "LineageMonster.death_lord", 10, 89, 15, "male", "L2Npc", 40, 1200000, 164, 3.95, 1.21, 40, 43, 30, 21, 20, 25, 0, 0, 9, 19, 3, 17, 304, 0, 333, 3907, 0, 0, 24, 125, null, 0, 0, 0, "LAST_HIT", 0, 0, 0, "fighter");

[KFan 7]

INSERT INTO `npc` VALUES (700,700, "Osama Bin Laden", 0, "", 0, "LineageMonster.death_lord", 10, 89, 15, "male", "L2Npc", 40, 1200000, 164, 3.95, 1.21, 40, 43, 30, 21, 20, 25, 0, 0, 9, 19, 3, 17, 304, 0, 333, 3907, 0, 0, 24, 125, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "fighter");

INSERT INTO `npc` VALUES (701,701, "Osama Bin Laden", 0, "", 0, "LineageMonster.death_lord", 10, 89, 15, "male", "L2Npc", 40, 1200000, 164, 3.95, 1.21, 40, 43, 30, 21, 20, 25, 0, 0, 9, 19, 3, 17, 304, 0, 333, 3907, 0, 0, 24, 125, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "fighter");

INSERT INTO `npc` VALUES (702,702, "Osama Bin Laden", 0, "", 0, "LineageMonster.death_lord", 10, 89, 15, "male", "L2Npc", 40, 1200000, 164, 3.95, 1.21, 40, 43, 30, 21, 20, 25, 0, 0, 9, 19, 3, 17, 304, 0, 333, 3907, 0, 0, 24, 125, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "fighter");

 

 

так должно прекрасно залится, если нет то я хз полностью совпадает с родными

[MeteorlAl 1]

Спасибо всё нарм!

[KFan 7]

Вообще-то то что я скинул выше 100% совпадает с одним из первых моих постов...

[MeteorlAl 1]

Вопрос еще один. Респлю НПЦ этого, а появляется кролик) В чем может быть ошибка? с текстурами или что

[StarryEyed 1]

Вопрос еще один. Респлю НПЦ этого, а появляется кролик) В чем может быть ошибка? с текстурами или что

Текстуру в клиент не скинул...

[MeteorlAl 1]

Скинул... но не пашет... знач всё.. увы?)

[Avelan 1]

если кролик то проблема в анимейшен и текстурах...

[MeteorlAl 1]

 

Открываю файлы npcgrp и npcname-e через fileedit чтобы вписать строки, но после вписки вылазиет эта ошибка

 

 

Подскажите что не так!?

Изменено 17 апреля, 2012 пользователем MeteorlAl