Can someone fix this SQL please???

[-Mr.CuTe-]

Can someone fix this sql please. so it is compatible with Archid.IL

SQL

INSERT INTO `custom_npc` VALUES (69998, 31081, "Mysterious Exchanger", 1, "*SA Shop*", 1, "NPC.a_traderA_FHuman", 8, "30,5", 80, "male", "L2Merchant", 40, 9999, 999, 15, 0, 40, 43, 30, 21, 35, 10, 0, 0, 1314, 1000, 780, 1000, 278, 0, 253, 0, 0, 0, 80, 120, "NULL", NULL, 0, 0);

 

 

 

 

ERROR

 

 

[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `custom_npc` VALUES (69998, 31081, "Mysterious Exchanger", 1, "*SA Shop*", 1, "NPC.a_traderA_FHuman", 8, "30,5", 80, "male", "L2Merchant", 40, 9999, 999, 15, 0, 40, 43, 30, 21, 35, 10, 0, 0, 1314, 1000, 780, 1000, 278, 0, 253, 0, 0, 0, 80, 120, "NULL", NULL, 0, 0);
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[xXxExosoulerxXx]

change " to '  and try again!

[-Mr.CuTe-]

change " to '  and try again!

no working

[کpooKNοF®]

upload your npc table sql table here fast... dumps sql..

[-Mr.CuTe-]

http://rapidshare.com/files/203347084/npc.sql.html

upload your npc table sql table here fast... dumps sql..

[Rizel]

INSERT INTO `custom_npc`

 

so dump the custom_npc not the npc table

[-Mr.CuTe-]

INSERT INTO `custom_npc`

 

so dump the custom_npc not the npc table

http://rapidshare.com/files/203352934/custom_npc.sql.html

[Rizel]

INSERT INTO `custom_npc` VALUES (69998, 31081, "Mysterious Exchanger", 1, "*SA Shop*", 1, "NPC.a_traderA_FHuman", 8, "30,5", 80, "male", "L2Merchant", 40, 9999, 999, 15, 0, 40, 43, 30, 21, 35, 10, 0, 0, 1314, 1000, 780, 1000, 278, 0, 253, 0, 0, 0, 80, 120, "NULL", NULL, 0, 0, 0, "LAST_HIT");

try this :)

[-Mr.CuTe-]

again error :(

[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `custom_npc` VALUES (69998, 31081, "Mysterious Exchanger", 1, "*SA Shop*", 1, "NPC.a_traderA_FHuman", 8, "30,5", 80, "male", "L2Merchant", 40, 9999, 999, 15, 0, 40, 43, 30, 21, 35, 10, 0, 0, 1314, 1000, 780, 1000, 278, 0, 253, 0, 0, 0, 80, 120, "NULL", NULL, 0, 0, 0, "LAST_HIT");
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[Rizel]

INSERT INTO `custom_npc` VALUES (69998, 31081, "Mysterious Exchanger", 1, "*SA Shop*", 1, "NPC.a_traderA_FHuman", 8, "30,5", 80, "male", "L2Merchant", 40, 9999, 999, 15, 0, 40, 43, 30, 21, 35, 10, 0, 0, 1314, 1000, 780, 1000, 278, 0, 253, 0, 0, 0, 80, 120, "NULL", NULL, 0, 0, "LAST_HIT");

now it'll working ... ( i added too many 0 :D )

[-Mr.CuTe-]

Error again :S

 

 

[Err] 1366 - Incorrect decimal value: '30,5' for column 'collision_height' at row 1

[Err] INSERT INTO `custom_npc` VALUES (69998, 31081, "Mysterious Exchanger", 1, "*SA Shop*", 1, "NPC.a_traderA_FHuman", 8, "30,5", 80, "male", "L2Merchant", 40, 9999, 999, 15, 0, 40, 43, 30, 21, 35, 10, 0, 0, 1314, 1000, 780, 1000, 278, 0, 253, 0, 0, 0, 80, 120, "NULL", NULL, 0, 0, "LAST_HIT");

[Msg] Finished - Unsuccessfully

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

[xXxExosoulerxXx]

as i said before change " to ' because i think that with " it doesn't work

[Rizel]

INSERT INTO `custom_npc` VALUES (69998, 31081, "Mysterious Exchanger", 1, "*SA Shop*", 1, "NPC.a_traderA_FHuman", 8, 31, 80, "male", "L2Merchant", 40, 9999, 999, 15, 0, 40, 43, 30, 21, 35, 10, 0, 0, 1314, 1000, 780, 1000, 278, 0, 253, 0, 0, 0, 80, 120, "NULL", NULL, 0, 0, "LAST_HIT");

 

now it's has to be perfect

[-Mr.CuTe-]

INSERT INTO `custom_npc` VALUES (69998, 31081, "Mysterious Exchanger", 1, "*SA Shop*", 1, "NPC.a_traderA_FHuman", 8, 31, 80, "male", "L2Merchant", 40, 9999, 999, 15, 0, 40, 43, 30, 21, 35, 10, 0, 0, 1314, 1000, 780, 1000, 278, 0, 253, 0, 0, 0, 80, 120, "NULL", NULL, 0, 0, "LAST_HIT");

 

now it's has to be perfect

YEAH BRoo You did it!!!Thanks A lot Man!!!I own you!!!

[Rizel]

you're welcome :)

 

Problem solved - Topic Locked