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

 

[xpleas14]

1234

 

[yakamoz454545]

güncel arkadaşlar

 

[yakamoz454545]

güncel

 

[muttalip87]

kardeş npcnin 1i hatalı bak şimdi

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)

verdiği hatadaki kodu kopyala mob protoyu aç sonra arattır ve o npcmi bos mu neyse onu sil sorun düzelicektir iyi forumlar .

 

[yakamoz454545]

kardeş npcnin 1i hatalı bak şimdi

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)

verdiği hatadaki kodu kopyala mob protoyu aç sonra arattır ve o npcmi bos mu neyse onu sil sorun düzelicektir iyi forumlar .

yapıyorum fakat hepsine tek tek hata veriyor. ordaki eklediğim tüm npc kodlarına