navicat mob proto ekliyemedim

[yakamoz454545]

Türkiye'de ilk Mobil & PC Aynı Anda Metin2 Oyna. Triarchonline kalıcı ve uzun ömürlü yapısı ile 24 Temmuz'da açılıyor. | 1-99 Mobil Metin2 Triarch HEMEN TIKLA!

yeni npc paketi yükliyecem fakat aşşağıdaki kodları ekliyince hata veriyor


(serverime yeni npc ler eklicem packı hazır root npclist de tamam fakat navicatta mob proto ya yeni npclerin kodlarını ekliyince o hatayı alıyorum.
ilk kodlar eklediğim npclerin kodları
ikinci kodlar da navicattan aldığım hata)

eklediğim npc kodları :

INSERT INTO mob_proto VALUES ('20200', 'Disi Elf', 0x4469736920456C66, '5', '1', '0', '0', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '100', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '16764159', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
INSERT INTO mob_proto VALUES ('20201', 'Erkek Elf', 0x45726B656B20456C66, '5', '1', '0', '0', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '100', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '16764159', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
INSERT INTO mob_proto VALUES ('20516', 'Karanlik NPC 1', 0x4B6172616E6C696B204E50432031, '5', '1', '0', '0', '', 'NOMOVE', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '3954', '3', '1', '0', '0', '5620', '79', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
INSERT INTO mob_proto VALUES ('20517', 'Maximum Görevler', 0x4D6178696D756D2047F67265766C6572, '5', '1', '0', '0', '', 'NOMOVE', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '3954', '3', '1', '0', '0', '5620', '79', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
INSERT INTO mob_proto VALUES ('20518', 'Elf Buyucusu', 0x456C66204275797563757375, '5', '1', '0', '0', '', 'NOMOVE', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '3954', '3', '1', '0', '0', '5620', '79', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
INSERT INTO mob_proto VALUES ('20519', 'Degerli Tabut', 0x44656765726C69205461627574, '5', '1', '0', '0', '', 'NOMOVE', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '3954', '3', '1', '0', '0', '5620', '79', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
INSERT INTO mob_proto VALUES ('20520', 'Olumcul Kabak Kafa', 0x4F6C756D63756C204B6162616B204B616661, '5', '1', '0', '0', '', 'NOMOVE', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '3954', '3', '1', '0', '0', '5620', '79', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
INSERT INTO mob_proto VALUES ('20521', 'Grup Halay', 0x477275702048616C6179, '5', '1', '0', '0', '', 'NOMOVE', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '3954', '3', '1', '0', '0', '5620', '79', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
INSERT INTO mob_proto VALUES ('20522', 'Bassiz Suvari', 0x42617373697A20537576617269, '5', '1', '0', '0', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '100', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '16764159', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
INSERT INTO mob_proto VALUES ('20524', 'Katil Demirci', 0x4B6174696C2044656D69726369, '5', '1', '0', '0', '', 'NOMOVE', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', 'blacksmith', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '100', '4', '100', '100', '0', '2000', '175', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
INSERT INTO mob_proto VALUES ('20525', 'Ozel NPC 1', 0x4F7A656C204E50432031, '5', '1', '0', '0', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '100', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '16764159', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
INSERT INTO mob_proto VALUES ('20526', 'Ozel NPC 2', 0x4F7A656C204E50432032, '5', '1', '0', '0', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '100', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '16764159', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
INSERT INTO mob_proto VALUES ('20528', 'Pet Mühürleri', 0x506574204DFC68FC726C657269, '5', '1', '0', '0', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '100', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '16764159', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
INSERT INTO mob_proto VALUES ('20529', 'Karanlik Adam', 0x4B6172616E6C696B204164616D, '5', '1', '0', '0', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '100', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '16764159', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
INSERT INTO mob_proto VALUES ('20531', 'Fayton', 0x466179746F6E, '5', '1', '0', '0', '', 'NOMOVE', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '3954', '3', '1', '0', '0', '5620', '79', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
INSERT INTO mob_proto VALUES ('20532', 'Gozlemci', 0x476F7A6C656D6369, '5', '1', '0', '0', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '100', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '16764159', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);



verdiği hata :



[Err] 1048 - Column 'sp_berserk' cannot be null
[Err] INSERT INTO mob_proto VALUES ('20200', 'Disi Elf', 0x4469736920456C66, '5', '1', '0', '0', '', 'NOMOVE', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', 'beggar', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '100', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '16764159', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
[Msg] Finished - Unsuccessfully
--------------------------------------------------

 

[baksenya39]

yeni npc paketi yükliyecem fakat aşşağıdaki kodları ekliyince hata veriyor

eklediğim npc kodları :

insert into mob_proto values ('20200', 'disi elf', 0x4469736920456c66, '5', '1', '0', '0', '', '', '0', '', 'stun,slow,curse,terror', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '100', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '16764159', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
insert into mob_proto values ('20201', 'erkek elf', 0x45726b656b20456c66, '5', '1', '0', '0', '', '', '0', '', 'stun,slow,curse,terror', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '100', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '16764159', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
insert into mob_proto values ('20516', 'karanlik npc 1', 0x4b6172616e6c696b204e50432031, '5', '1', '0', '0', '', 'nomove', '0', '', 'stun,slow,curse,terror', '0', '', '2', '0', '0', '0', '0', '0', '0', '3954', '3', '1', '0', '0', '5620', '79', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
insert into mob_proto values ('20517', 'maximum görevler', 0x4d6178696d756d2047f67265766c6572, '5', '1', '0', '0', '', 'nomove', '0', '', 'stun,slow,curse,terror', '0', '', '2', '0', '0', '0', '0', '0', '0', '3954', '3', '1', '0', '0', '5620', '79', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
insert into mob_proto values ('20518', 'elf buyucusu', 0x456c66204275797563757375, '5', '1', '0', '0', '', 'nomove', '0', '', 'stun,slow,curse,terror', '0', '', '2', '0', '0', '0', '0', '0', '0', '3954', '3', '1', '0', '0', '5620', '79', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
insert into mob_proto values ('20519', 'degerli tabut', 0x44656765726c69205461627574, '5', '1', '0', '0', '', 'nomove', '0', '', 'stun,slow,curse,terror', '0', '', '2', '0', '0', '0', '0', '0', '0', '3954', '3', '1', '0', '0', '5620', '79', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
insert into mob_proto values ('20520', 'olumcul kabak kafa', 0x4f6c756d63756c204b6162616b204b616661, '5', '1', '0', '0', '', 'nomove', '0', '', 'stun,slow,curse,terror', '0', '', '2', '0', '0', '0', '0', '0', '0', '3954', '3', '1', '0', '0', '5620', '79', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
insert into mob_proto values ('20521', 'grup halay', 0x477275702048616c6179, '5', '1', '0', '0', '', 'nomove', '0', '', 'stun,slow,curse,terror', '0', '', '2', '0', '0', '0', '0', '0', '0', '3954', '3', '1', '0', '0', '5620', '79', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
insert into mob_proto values ('20522', 'bassiz suvari', 0x42617373697a20537576617269, '5', '1', '0', '0', '', '', '0', '', 'stun,slow,curse,terror', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '100', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '16764159', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
insert into mob_proto values ('20524', 'katil demirci', 0x4b6174696c2044656d69726369, '5', '1', '0', '0', '', 'nomove', '0', '', 'stun,slow,curse,terror', '0', 'blacksmith', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '100', '4', '100', '100', '0', '2000', '175', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
insert into mob_proto values ('20525', 'ozel npc 1', 0x4f7a656c204e50432031, '5', '1', '0', '0', '', '', '0', '', 'stun,slow,curse,terror', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '100', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '16764159', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
insert into mob_proto values ('20526', 'ozel npc 2', 0x4f7a656c204e50432032, '5', '1', '0', '0', '', '', '0', '', 'stun,slow,curse,terror', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '100', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '16764159', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
insert into mob_proto values ('20528', 'pet mühürleri', 0x506574204dfc68fc726c657269, '5', '1', '0', '0', '', '', '0', '', 'stun,slow,curse,terror', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '100', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '16764159', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
insert into mob_proto values ('20529', 'karanlik adam', 0x4b6172616e6c696b204164616d, '5', '1', '0', '0', '', '', '0', '', 'stun,slow,curse,terror', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '100', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '16764159', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
insert into mob_proto values ('20531', 'fayton', 0x466179746f6e, '5', '1', '0', '0', '', 'nomove', '0', '', 'stun,slow,curse,terror', '0', '', '2', '0', '0', '0', '0', '0', '0', '3954', '3', '1', '0', '0', '5620', '79', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
insert into mob_proto values ('20532', 'gozlemci', 0x476f7a6c656d6369, '5', '1', '0', '0', '', '', '0', '', 'stun,slow,curse,terror', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '100', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '16764159', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);



verdiği hata :



[err] 1048 - column 'sp_berserk' cannot be null
[err] insert into mob_proto values ('20200', 'disi elf', 0x4469736920456c66, '5', '1', '0', '0', '', 'nomove', '0', '', 'stun,slow,curse,terror', '0', 'beggar', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '100', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '16764159', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, null);
[msg] finished - unsuccessfully
--------------------------------------------------

arkadaŞim daha aÇiklayarak anlatirmisin napmaya ÇaliŞiyorsun ?

 

[yakamoz454545]

arkadaŞim daha aÇiklayarak anlatirmisin napmaya ÇaliŞiyorsun ?

serverime yeni npc ler eklicem packı hazır root npclist de tamam fakat navicatta mob proto ya yeni npclerin kodlarını ekliyince o hatayı alıyorum.
ilk kodlar eklediğim npclerin kodları
ikinci kodlar da navicattan aldığım hata

açıklayıcı olmadıysa daha derin de anlatabiilirim yeterki yardımcı olun.

 

[yakamoz454545]

sorun güncel

 

[grayder16]

güncell