HERAKLES Otomatik Avlı kalıcı sunucu. 19 Haziran'da açılıyor. Atius & Wizard güvencesiyle hemen kayıt ol, ön kayıt ödülleri aktif. 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
--------------------------------------------------
(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
--------------------------------------------------
Son düzenleme:
