Help me ! add NPC Buffer and GM SHOP for my server Freya !

[danilo10]

So my problem " I add my NPC buffer free but Navicat error SQL " my server source :Server:4422 Datapack:7669

NPC Buffer : link source :http://www.megaupload.com/?d=VGK1POYO

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

[Err] INSERT INTO `npc` VALUES(555, 18544, 'Buffer', 1, 'Edited by Z!T!oN', 1, 'LineageNpcEV.trap_ironcastle', '8', '24', 85, 'male', 'L2Npc', 40, '680', '1820', '0.00', '0.00', 40, 43, 30, 21, 20, 20, 0, 0, 14, 101400, 6, 307525, 230, 0, 333, 0, 0, 0, 0, 27, 120, 0, 0, 1);

[Msg] Finished - Unsuccessfully

--------------------------------------------------

GM Shop : link Source :http://www.mediafire.com/?t5t15v3g2285t54

[Err] 1054 - Unknown column 'armor' in 'field list'

[Err] INSERT INTO custom_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`, `enchant`, `walkspd`, `runspd`, `isUndead`, `dropHerbGroup`, `basestats`)

VALUES

  (10002, 10, 'NPC GM Shop', 1, 'NPC GM Shop', 1, 'LineageMonster.wererat_01te', 14.00, 25.00, 35, 'male', 'L2Merchant', 40, 773, 366, 7.11, 1.84, 40, 43, 30, 21, 20, 20, 2470, 145, 159, 170, 111, 113, 230, 500, 333, 0, 0, 0, 0, 80, 120, 0, 1, 1);

[Msg] Finished - Unsuccessfully

--------------------------------------------------

 

I don't know it where is wrong ? Everybody help me plz ! :(

[CarmineAngelo]

So add it with ur hand meng .... :S

[Bleadd]

I haven't freya tables, but maybe your SQL isn't adapted for tables in Freya??!!

I see

Column count doesn't match value count at row 1

so the SQL isn't adapted, i think..

 

An exemple to adapt a sql :

 

INSERT INTO `npc` VALUES(555, 18544, 'Buffer', 1, 'Edited by Z!T!oN', 1, 'LineageNpcEV.trap_ironcastle', '8', '24', 85, 'male', 'L2Npc', 40, '680', '1820', '0.00', '0.00', 40, 43, 30, 21, 20, 20, 0, 0, 14, 101400, 6, 307525, 230, 0, 333, 0, 0, 0, 0, 27, 120, 0, 0, 1);

 

Select this :

18544 (second value => Template_id)

 

Go to table npc and select npc with template_id = 18544

Export the SQL with this template

 

And modify Npc id (the first value) and L2type (The value that start with L2....)

 

 

[danilo10]

Thanks everyone ! I add with my hands ! :( !it's work .

[Bleadd]

;) good if it's work ^^

 

Moderator for lock plz ^^'