(HELP)Npc

[underground]

When i execute batch file in my navicat i have this error

 

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

[Err] INSERT INTO `npc` VALUES ('90009', '22428', 'Slave of Envy', '1', 'Teleporter', '1', 'NPC.a_traderA_MHuman', '15.00', '32.00', '80', 'female', 'L2Teleporter', '80', '15000', '2000', '80', '80', '80', '80', '80', '80', '80', '80', '80', '80', '15000', '5000', '15000', '5000', '250', '0', '690', '0', '0', '0', '55', '132', null, '0', '1', '0', 'LAST_HIT', '0', '0', '0', 'fighter');

[Msg] Finished - Unsuccessfully

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

 

Whatever npc it is..

Pls help me..I would appreciate it..

Only one npc i have installed without error..

I use l2jfree gracia part2 pack..

[xMaylox]

well, it seems that you are using a different type of sql file. maybe you are trying to insert a SQL from a different pack. ok try this:

 

INSERT INTO `npc` VALUES
('90009', '22428', 'Slave of Envy', '1', 'Teleporter', '1', 'NPC.a_traderA_MHuman', '15.00', '32.00', '80', 'female', 'L2Teleporter', 40, 2444, 2444, 0.00, 0.00, 10, 10, 10, 10, 10, 10, 0, 0, 500, 500, 500, 500, 253, 0, 253, 0, 0, NULL, 80, 120, 'NULL', 0, 0, 0, 'LAST_HIT', 0, 0, 0, 'balanced', 'false');

[underground]

i ll try and i ll tell you man...

[underground]

no..dn pianei rr..

ti na kanw..

 

[Kràtos]

[gr] Pou einai i diksolia se ayto to pragma?? Des pos ta alla sql einai ftiagmena ta " kai ta , pou mpenoune kai pos ... prosarmoseto opos ta alla ... kai den tha exeis errors....!

 

I valto apo to navicat kateythian xwreis kan ayth tin diadikasia!

[underground]

(Gr) ti enoeis me ayta " , klp klp???

ti na t kanw???opws mou to dose o maylo to ekana alla dn mpike..pali error vrike :/

[Kràtos]

Try This ..... O.O!

 

INSERT INTO `npc` VALUES
(90009, 22428, 'Slave of Envy', 1, 'Teleporter', 1, 'NPC.a_traderA_MHuman', 15.00, 32.00, 80, 'female', 'L2Teleporter', 40, 400000, 9999, 13.43, 3.09, 40, 43, 30, 21, 20, 10, 0, 0, 9000, 5000, 6000, 6000, 300, 0, 333, 0, 0, 0, 88, 132, 0, 0, 0, 0, "LAST_HIT", 0, 0, 0, 0, "fighter");

 

[blademagic]

[gr] Pou einai i diksolia se ayto to pragma?? Des pos ta alla sql einai ftiagmena ta " kai ta , pou mpenoune kai pos ... prosarmoseto opos ta alla ... kai den tha exeis errors....!

 

I valto apo to navicat kateythian xwreis kan ayth tin diadikasia!

 

man... is english forum...

[Kràtos]

man... is english forum...

 

"Man" Look better what i put ... before i'm write on Greek... If i Put Tags [Gr] before i write the rules allow it!

 

Also Stay On Topic!

 

1Waring!

 

@underground: Did you try my sql what i give?

 

p.s: A mod remove it pliz at Help section Thanks.

[xMaylox]

(Gr) ti enoeis me ayta " , klp klp???

ti na t kanw???opws mou to dose o maylo to ekana alla dn mpike..pali error vrike :/

 

are u sure that you have the correct database? for l2jfree? if yes try this one:

 

INSERT IGNORE `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`,`walkspd`,`runspd`,`faction_id`,`faction_range`,`isUndead`,`absorb_level`,`absorb_type`) VALUES
(90009, 22428, 'Slave of Envy', 1, 'Teleporter', 1, 'NPC.a_traderA_MHuman', 15.00, 32.00, 80, 'female', 'L2Teleporter', 40, 3862, 1493, NULL, NULL, 40, 43, 30, 21, 20, 10, 0, 0, 1314, 470, 780, 382, 278, 0, 253, 0, 0, 0, 80, 120, NULL, 0, 0, 0,'LAST_HIT');

[underground]

(GR)COBRA TA PROSPA8ISA KAI TA DIKA SOU KAI TOU MAYLO..

ALLA TPT..

GAMA TO (SOZ KAI GIA TN EKFRASH)

DN PEIRAZEI ..

EKTIMW TO HELP SAS..