hi,

i downloaded  a gmshop npc  in this forum  that sells all and icarus weapon

it's for l2j and i use l2j but when i open navicat and i do execute batch file it gives an error like:

 

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

[Msg] Finished - Unsuccessfully

 

 

code is:

 

DELETE FROM `custom_npc` WHERE `id` = '90000';

INSERT INTO `custom_npc` VALUES ('90000', '25532', 'GM Shop', '1', 'GM Shop', '1', 'NPC.a_traderA_MHuman', '10.00', '27.00', '70', 'male', 'L2Merchant', '40', '3862', '1493', '11.85', '2.78', '40', '43', '30', '21', '20', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '333', '0', '0', '0', '55', '132', null, '0', '1', '0', 'LAST_HIT', '0', '0', '0', 'fighter');

 

thanks for help

 

bye bye

Just add the attributes manually m8.

Press the (+) button in table custom_npc (check down and left) and change only these values :

 

ID
template ID
name 
title
ServerSideTitle (set it to 1, just to display your custom title) 
class 
collision_height
type

 

P.S : Next time please post in [Request] Section.