[Help] SQL Error

[MrPerfect20]

Hello guys i try to adapt one item from a cronicle to another and i get this error when i try to execute batch ...

 

[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 '28001, 'GM Gaiters', 'legs', 'true', 'light', 1570, 'leather', 's80', 0, -1, -1,' at line 1

[Err] (28001, 'GM Gaiters', 'legs', 'true', 'light', 1570, 'leather', 's80', 0, -1, -1, 46, 0, 0, 73200, 135, 'true', 'true', 'true', 'true', 'true', '0-0', '0-0;');

[Msg] Finished - Unsuccessfully

 

Can you guys tell me what im doing wrong ?

[Devangell™]

show me the line from the gm armor

and what chronicle want?

[MrPerfect20]

This are the lines ...

(28000, 'GM Shirt', 'chest', 'true', 'light', 4570, 'leather', 's80', 0, -1, -1, 73, 0, 0, 117000, 216, 'true', 'true', 'true', 'true', 'true', '0-0', '0-0;');

(28001, 'GM Gaiters', 'legs', 'true', 'light', 1570, 'leather', 's80', 0, -1, -1, 46, 0, 0, 73200, 135, 'true', 'true', 'true', 'true', 'true', '0-0', '0-0;');

(28002, 'GM Gloves', 'gloves', 'true', 'none', 640, 'leather', 's80', 0, -1, -1, 24, 0, 0, 39100, 72, 'true', 'true', 'true', 'true', 'true', '0-0', '0-0;');

(28003, 'GM Boots', 'feet', 'true', 'none', 1280, 'leather', 's80', 0, -1, -1, 24, 0, 0, 39100, 72, 'true', 'true', 'true', 'true', 'true', '0-0', '0-0;');

(28004, 'GM Helm', 'hairall', 'false', 'none', 10, 'wood', 's80', 0, -1, -1, 0, 0, 0, 0, 0, 'true', 'true', 'true', 'true', 'true', '0-0', '0-0;');

(28005, 'GM Helmet', 'hairall', 'false', 'none', 10, 'wood', 's80', 0, -1, -1, 0, 0, 0, 0, 0, 'true', 'true', 'true', 'true', 'true', '0-0', '0-0;');

 

L2j C2.3

[Devangell™]

This are the lines ...

(28000, 'GM Shirt', 'chest', 'true', 'light', 4570, 'leather', 's80', 0, -1, -1, 73, 0, 0, 117000, 216, 'true', 'true', 'true', 'true', 'true', '0-0', '0-0;');

(28001, 'GM Gaiters', 'legs', 'true', 'light', 1570, 'leather', 's80', 0, -1, -1, 46, 0, 0, 73200, 135, 'true', 'true', 'true', 'true', 'true', '0-0', '0-0;');

(28002, 'GM Gloves', 'gloves', 'true', 'none', 640, 'leather', 's80', 0, -1, -1, 24, 0, 0, 39100, 72, 'true', 'true', 'true', 'true', 'true', '0-0', '0-0;');

(28003, 'GM Boots', 'feet', 'true', 'none', 1280, 'leather', 's80', 0, -1, -1, 24, 0, 0, 39100, 72, 'true', 'true', 'true', 'true', 'true', '0-0', '0-0;');

(28004, 'GM Helm', 'hairall', 'false', 'none', 10, 'wood', 's80', 0, -1, -1, 0, 0, 0, 0, 0, 'true', 'true', 'true', 'true', 'true', '0-0', '0-0;');

(28005, 'GM Helmet', 'hairall', 'false', 'none', 10, 'wood', 's80', 0, -1, -1, 0, 0, 0, 0, 0, 'true', 'true', 'true', 'true', 'true', '0-0', '0-0;');

 

L2j C2.3

pff i don't have the files ok then look what you see you make one copy of the sql who is in server/sql

you take from there the armor.sql

and you change from there 6 lines one for one part of the armor if i see good it four and 2 heml

so do it and tell me!!

[Devangell™]

This are the lines ...

(28000, 'GM Shirt', 'chest', 'true', 'light', 4570, 'leather', 's80', 0, -1, -1, 73, 0, 0, 117000, 216, 'true', 'true', 'true', 'true', 'true', '0-0', '0-0;');

(28001, 'GM Gaiters', 'legs', 'true', 'light', 1570, 'leather', 's80', 0, -1, -1, 46, 0, 0, 73200, 135, 'true', 'true', 'true', 'true', 'true', '0-0', '0-0;');

(28002, 'GM Gloves', 'gloves', 'true', 'none', 640, 'leather', 's80', 0, -1, -1, 24, 0, 0, 39100, 72, 'true', 'true', 'true', 'true', 'true', '0-0', '0-0;');

(28003, 'GM Boots', 'feet', 'true', 'none', 1280, 'leather', 's80', 0, -1, -1, 24, 0, 0, 39100, 72, 'true', 'true', 'true', 'true', 'true', '0-0', '0-0;');

(28004, 'GM Helm', 'hairall', 'false', 'none', 10, 'wood', 's80', 0, -1, -1, 0, 0, 0, 0, 0, 'true', 'true', 'true', 'true', 'true', '0-0', '0-0;');

(28005, 'GM Helmet', 'hairall', 'false', 'none', 10, 'wood', 's80', 0, -1, -1, 0, 0, 0, 0, 0, 'true', 'true', 'true', 'true', 'true', '0-0', '0-0;');

 

L2j C2.3

pff i don't have the files ok then look what you see you make one copy of the sql who is in server/sql

you take from there the armor.sql

and you change from there 6 lines one for one part of the armor if i see good it four and 2 heml

so do it and tell me!!