[GUIDE] Installing An NPC Buffer On L2J Packs.

[prisoneer]

Im trying to install the oneo buffer

 

I get this error

 

[Err] 1136 - Column count doesn't match value count at row 1

[Err] -- Oneo Dev Team Npc Buffer special thx to Panic

INSERT INTO `npc` VALUES ('40006', '30003', 'Buffer', '1', 'L2JOneo', '1', 'NPC.a_traderA_FHuman', '20.00', '25.00', '70', 'male', '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', null, '0', '0', '0', 'LAST_HIT');

[Msg] Finished - Unsuccessfully

 

What should I do ?

[Stefoulis15]

Im trying to install the oneo buffer

 

I get this error

 

[Err] 1136 - Column count doesn't match value count at row 1

[Err] -- Oneo Dev Team Npc Buffer special thx to Panic

INSERT INTO `npc` VALUES ('40006', '30003', 'Buffer', '1', 'L2JOneo', '1', 'NPC.a_traderA_FHuman', '20.00', '25.00', '70', 'male', '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', null, '0', '0', '0', 'LAST_HIT');

[Msg] Finished - Unsuccessfully

 

What should I do ?

 

the sql doesnt fit in ur pack.

 

try Adding the sql manually..

[prisoneer]

You mean adding every file in the folders they must be staying?

[Stefoulis15]

You mean adding every file in the folders they must be staying?

 

No .. I Mean

 

Go To Your Database Open It And Find The Table `npc`

 

Open It And Press The Cross Button * + *

 

And Add The Information of Your Npc. Instead of Executing The .sql File.

[prisoneer]

No .. I Mean

 

Go To Your Database Open It And Find The Table `npc`

 

Open It And Press The Cross Button * + *

 

And Add The Information of Your Npc. Instead of Executing The .sql File.

 

 

Sorry for my very newbish question but how can i see the info about the oneo's buffer?

 

('40006', '30003', 'Buffer', '1', 'L2JOneo', '1', 'NPC.a_traderA_FHuman', '20.00', '25.00', '70', 'male', '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', null, '0', '0', '0', 'LAST_HIT');

 

ID = 40006 right ?

what are the other things?

 

Or i add em in the order they are in the new row i just created when pressing + ?

id , idtemplate,name,serversidename ... and blah blah blah ?

 

[Stefoulis15]

ID = 40006

TEMPLATE ID = 30003

NAME = Buffer

TITLE = L2JOneo

 

 

etc... for all others add whatever the previous npc has.

 

it won't be a problem..

[prisoneer]

Ok thanks

 

BTW in the tables I have a sql file npc_buffer.. and I was wondering if I have to add these codes to the table npc or to table custom_npc ?

[Stefoulis15]

add it to the npc table. its better. and u dont need to heavy ur database with activating the custom tables.

[prisoneer]

i get error

 

1062 - Duplicate entry '40006' for key 1

 

and I dont have other npc with this id

[Stefoulis15]

trust me u got. u just can see it.

 

anyway if as it says u got one then u dont have a problem. u already have the npc in ur database . go In game and //spawn 40006

 

and check it urself :)

[prisoneer]

Nope.. not working.. I created new npc with id 40007.. and it didnt find it aswell.. what can be the problem..

 

 

P.S. why I cant see a npc when I create in the list with npc

[prisoneer]

ok i solved the problem i spawned the npc. but when i click on buff me

 

its saying about some quest.. that i dont meet the requirements... !?

[l2link]

Great Guide.... simple and to the point

[v4l3r1]

i have a problem :(

[v4l3r1]

when i execute the .sql says unsucsesflu :S what can i do??