Buffer SQL error

[Noizee]

Hi MXC , I have some probleme with sql of buffer

INSERT INTO `npc` VALUES (555, 36562, 'Buffer', 1, 'Buffer', 1, 'LineageNPC2.garrison_of_insurgents', '10.00', '23.75', 86, 'male', 'L2Npc', 40, '32490', '1712', '56.86', '3.09', 40, 43, 30, 21, 20, 20, 145669, 15182, 10203, 1024, 7022, 1022, 230, 0, 253, 0, 0, 0, 73, 191, 0, 1);

I need to update this sql for latest l2jsrver rev 7672

Can someone help me?

[®ৠ♪Ŋαķαмοūŗα♪ৠ®]

This error its because the NPC Sql Is Older That The Revision Of Your Pack...Try To Add It Manualy....

[Trance]

Hi MXC , I have some probleme with sql of buffer

INSERT INTO `npc` VALUES (555, 36562, 'Buffer', 1, 'Buffer', 1, 'LineageNPC2.garrison_of_insurgents', '10.00', '23.75', 86, 'male', 'L2Npc', 40, '32490', '1712', '56.86', '3.09', 40, 43, 30, 21, 20, 20, 145669, 15182, 10203, 1024, 7022, 1022, 230, 0, 253, 0, 0, 0, 73, 191, 0, 1);

I need to update this sql for latest l2jsrver rev 7672

Can someone help me?

 

Post here your Npc.Sql, and i will add it without errors.

[Noizee]

this is the Npc Sql    INSERT INTO `npc` VALUES (555, 36562, 'Buffer', 1, 'Buffer', 1, 'LineageNPC2.garrison_of_insurgents', '10.00', '23.75', 86, 'male', 'L2Npc', 40, '32490', '1712', '56.86', '3.09', 40, 43, 30, 21, 20, 20, 145669, 15182, 10203, 1024, 7022, 1022, 230, 0, 253, 0, 0, 0, 73, 191, 0, 1);

[Trance]

this is the Npc Sql    INSERT INTO `npc` VALUES (555, 36562, 'Buffer', 1, 'Buffer', 1, 'LineageNPC2.garrison_of_insurgents', '10.00', '23.75', 86, 'male', 'L2Npc', 40, '32490', '1712', '56.86', '3.09', 40, 43, 30, 21, 20, 20, 145669, 15182, 10203, 1024, 7022, 1022, 230, 0, 253, 0, 0, 0, 73, 191, 0, 1);

 

Mm-hmm u don't understand me, i mean Npc.sql full.

[Noizee]

Here is the link for Sql  http://www.4shared.com/document/6wnq7rvy/SQL.html

 

[Trance]

Here is the link for Sql  http://www.4shared.com/document/6wnq7rvy/SQL.html

 

 

This is not Npc.sql from database. Doh...

[Noizee]

Ok

 

[Noizee]

http://www.4shared.com/document/JGxE33y3/npc.html

Here it is

[Trance]

Ok, try now if work.

 

INSERT INTO `npc` VALUES (555,36562,'Buffer',1,'Buffer',1,'LineageNPC2.garrison_of_insurgents','10.00','23.75',80,'male','L2Npc',40,'3290.00000','1524.00000','8.50000','3.00000',40,43,30,21,20,20,0,0,'1627.00000','577.00000','1117.00000','384.00000',230,4,0,333,0,0,0,80,1,1,1,0,1);

 

---

 

Or download full Npc.sql, already added this npc.

 

http://rapidshare.com/files/436664140/npc.sql

 

PS: Don't forgot delete Npc.sql from database before add this.

[Noizee]

sTill is the same error

[Noizee]

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '555,36562,'Buffer',1,'Buffer',1,'LineageNPC2.garrison_of_insurgents','10.00','23' at line 1

[Err] (555,36562,'Buffer',1,'Buffer',1,'LineageNPC2.garrison_of_insurgents','10.00','23.75',80,'male','L2Npc',40,'3290.00000','1524.00000','8.50000','3.00000',40,43,30,21,20,20,0,0,'1627.00000','577.00000','1117.00000','384.00000',230,4,0,333,0,0,0,80,1,1,1,0,1);

[Msg] Finished - Unsuccessfully

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

 

[Noizee]

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '555,36562,'Buffer',1,'Buffer',1,'LineageNPC2.garrison_of_insurgents','10.00','23' at line 1

[Err] (555,36562,'Buffer',1,'Buffer',1,'LineageNPC2.garrison_of_insurgents','10.00','23.75',80,'male','L2Npc',40,'3290.00000','1524.00000','8.50000','3.00000',40,43,30,21,20,20,0,0,'1627.00000','577.00000','1117.00000','384.00000',230,4,0,333,0,0,0,80,1,1,1,0,1);

[Msg] Finished - Unsuccessfully

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

 

[Noizee]

I think something wrong is with my DB

[Trance]

Try:

 

Or download full Npc.sql, already added this npc.

http://rapidshare.com/files/436664140/npc.sql

PS: Don't forgot delete Npc.sql from database before add this.
[/quote]

[Noizee]

I tryed this But sTILL THE ERROR

I've deleted npc table and then executed new but there is still error whit buffer