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....

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.

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);

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.

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

 

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

 

 

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

Ok

 

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

Here it is

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.

sTill is the same error

[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

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

 

[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

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

 

I think something wrong is with my DB

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]