[HELP] how to delete custom buffer from sql ??!

[omega87]

hello! im trying to delete a custom npc from SQL with navicat

but i cant find the custom buffer!

 

i looked in NPC and Custom_npc!

 

basicly i want to update the buffer, and it wont let me it gives me error

 

[Err] 1062 - Duplicate entry '40000' for key 'PRIMARY'
[Err] INSERT INTO `npc` (`id`, `idTemplate`, `name`, `serverSideName`, `title`, `serverSideTitle`, `class`, `collision_radius`, `collision_height`, `level`, `sex`, `type`, `attackrange`, `hp`, `mp`, `hpreg`, `mpreg`, `str`, `con`, `dex`, `int`, `wit`, `men`, `exp`, `sp`, `patk`, `pdef`, `matk`, `mdef`, `atkspd`, `aggro`, `matkspd`, `rhand`, `lhand`, `armor`, `walkspd`, `runspd`, `faction_id`, `faction_range`, `isUndead`, `absorb_level`) values('40000','31581','Buff Master','1','NPC Buffer','1','NPC.a_clergyman_FDarkElf','8.00','24.50','70','female','L2Npc','40','3862','1493','13.43','3.09','40','43','30','21','35','10','0','0','1314','470','780','382','278','0','253','0','0','0','80','120','','0','0','0');
[Msg] Finished - Unsuccessfully

 

im new with making servers and im trying to learn.

 

thank you for your understanding.

 

 

[Coolis®]

Read error omg :S

[Err] 1062 - Duplicate entry '40000' for key 'PRIMARY'
[Err] INSERT INTO `npc` (`id`, `idTemplate`, `name`, `serverSideName`, `title`, `serverSideTitle`, `class`, `collision_radius`, `collision_height`, `level`, `sex`, `type`, `attackrange`, `hp`, `mp`, `hpreg`, `mpreg`, `str`, `con`, `dex`, `int`, `wit`, `men`, `exp`, `sp`, `patk`, `pdef`, `matk`, `mdef`, `atkspd`, `aggro`, `matkspd`, `rhand`, `lhand`, `armor`, `walkspd`, `runspd`, `faction_id`, `faction_range`, `isUndead`, `absorb_level`) values('40000','31581','Buff Master','1','NPC Buffer','1','NPC.a_clergyman_FDarkElf','8.00','24.50','70','female','L2Npc','40','3862','1493','13.43','3.09','40','43','30','21','35','10','0','0','1314','470','780','382','278','0','253','0','0','0','80','120','','0','0','0');
[Msg] Finished - Unsuccessfully

 

you try to Duplicate your buffer, navicat doesnt allow it... So what to do?

 

Select your NPC, (inside custom_npc) and delete it... Save d Close it...

Go to your DB (l2jdb etc.) and Execute SQL files... Select your updated SQL archive and add it...

The other way it to edit it inside custom_npc

[Onix]

CoŏŁΐŠ you wrong say. Omega87 if you want fix this problem change npc id for your number example 563743 when change and install go your buffer html and change html on 563743.htm :)

[omega87]

thanks ALOT onix! i had my grandfathers revolder hanging on the wall "psst, its fully functional" and i almost killed my self.!!!

 

Because ididnt find the npc id in NPC tablet.

 

once again thank you! onix would u mind if i added u on msn?

 

[Onix]

no problem bro :) i dont have msn :(

[CrazyDeagle]

Export your npc table from mysql.

And make a seach. ID 40000, and you will find the NPC ^^

[Onix]

omg CrazyDeagle problem fix .... i help him he not need more help ...