Secret Experience - Ver um Único Post

demari · 31-05-2009, 01:28 AM

primeira vez que eu tento fazer um npc, e ta dando erro na hora de executa o sql pra dentro do navicat , fiz conforme uma tutorial do seto mas nao da dando nessa parte do sql

minha sql ta assim :

INSERT INTO merchant_shopids VALUES (40007, 53);

INSERT INTO merchant_buylists VALUES (9300, 1,40007, 0);
INSERT INTO merchant_buylists VALUES (9301, 1,40007, 1);
INSERT INTO merchant_buylists VALUES (9302, 1,40007, 2);
INSERT INTO merchant_buylists VALUES (9303, 1,40007, 3);
INSERT INTO merchant_buylists VALUES (9304, 1,40007, 4);
INSERT INTO merchant_buylists VALUES (9305, 1,40007, 5);
INSERT INTO merchant_buylists VALUES (9306, 1,40007, 6);
INSERT INTO merchant_buylists VALUES (9307, 1,40007, 7);
INSERT INTO merchant_buylists VALUES (9308, 1,40007, 8);
INSERT INTO merchant_buylists VALUES (9309, 1,40007, 9);
INSERT INTO merchant_buylists VALUES (9310, 1,40007, 10);
INSERT INTO merchant_buylists VALUES (9311, 1,40007, 11);
INSERT INTO merchant_buylists VALUES (9312, 1,40007, 12);
INSERT INTO merchant_buylists VALUES (9313, 1,40007, 13);
INSERT INTO merchant_buylists VALUES (9314, 1,40007, 14);
INSERT INTO merchant_buylists VALUES (9315, 1,40007, 15);
INSERT INTO merchant_buylists VALUES (9316, 1,40007, 16);
INSERT INTO merchant_buylists VALUES (9317, 1,40007, 17);
INSERT INTO merchant_buylists VALUES (9318, 1,40007, 18);
INSERT INTO merchant_buylists VALUES (9319, 1,40007, 19);
INSERT INTO merchant_buylists VALUES (9320, 1,40007, 20);
INSERT INTO merchant_buylists VALUES (9321, 1,40007, 21);
INSERT INTO merchant_buylists VALUES (9322, 1,40007, 22);
INSERT INTO merchant_buylists VALUES (9324, 1,40007, 23);
INSERT INTO merchant_buylists VALUES (9325, 1,40007, 24);
INSERT INTO merchant_buylists VALUES (9326, 1,40007, 25);
INSERT INTO merchant_buylists VALUES (9327, 1,40007, 26);
INSERT INTO merchant_buylists VALUES (9328, 1,40007, 27);
INSERT INTO merchant_buylists VALUES (9329, 1,40007, 28);

e na hora de executar no navicat da esse erro aqui

[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO merchant_buylists VALUES (9300, 1,40007, 0);
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Consegui passa dessa parte ,
soo que quando entro no jogo pra dar spawn (//spawn 40007 )no npc ele nao vem
diz assim :
Your target Cannot be found.

por queee ?

31-05-2009, 01:28 AM	#1 (permalink)
demari Membro - Sargento Registrado em: Apr 2009 Posts: 38 Agradeceu: 55 Agradecido 15 Vezes em 12 Posts Achei Ruim: Acharam ruim Vezes em Posts Inventório de demari	erro no sql para executar no navicat primeira vez que eu tento fazer um npc, e ta dando erro na hora de executa o sql pra dentro do navicat , fiz conforme uma tutorial do seto mas nao da dando nessa parte do sql minha sql ta assim : INSERT INTO merchant_shopids VALUES (40007, 53); INSERT INTO merchant_buylists VALUES (9300, 1,40007, 0); INSERT INTO merchant_buylists VALUES (9301, 1,40007, 1); INSERT INTO merchant_buylists VALUES (9302, 1,40007, 2); INSERT INTO merchant_buylists VALUES (9303, 1,40007, 3); INSERT INTO merchant_buylists VALUES (9304, 1,40007, 4); INSERT INTO merchant_buylists VALUES (9305, 1,40007, 5); INSERT INTO merchant_buylists VALUES (9306, 1,40007, 6); INSERT INTO merchant_buylists VALUES (9307, 1,40007, 7); INSERT INTO merchant_buylists VALUES (9308, 1,40007, 8); INSERT INTO merchant_buylists VALUES (9309, 1,40007, 9); INSERT INTO merchant_buylists VALUES (9310, 1,40007, 10); INSERT INTO merchant_buylists VALUES (9311, 1,40007, 11); INSERT INTO merchant_buylists VALUES (9312, 1,40007, 12); INSERT INTO merchant_buylists VALUES (9313, 1,40007, 13); INSERT INTO merchant_buylists VALUES (9314, 1,40007, 14); INSERT INTO merchant_buylists VALUES (9315, 1,40007, 15); INSERT INTO merchant_buylists VALUES (9316, 1,40007, 16); INSERT INTO merchant_buylists VALUES (9317, 1,40007, 17); INSERT INTO merchant_buylists VALUES (9318, 1,40007, 18); INSERT INTO merchant_buylists VALUES (9319, 1,40007, 19); INSERT INTO merchant_buylists VALUES (9320, 1,40007, 20); INSERT INTO merchant_buylists VALUES (9321, 1,40007, 21); INSERT INTO merchant_buylists VALUES (9322, 1,40007, 22); INSERT INTO merchant_buylists VALUES (9324, 1,40007, 23); INSERT INTO merchant_buylists VALUES (9325, 1,40007, 24); INSERT INTO merchant_buylists VALUES (9326, 1,40007, 25); INSERT INTO merchant_buylists VALUES (9327, 1,40007, 26); INSERT INTO merchant_buylists VALUES (9328, 1,40007, 27); INSERT INTO merchant_buylists VALUES (9329, 1,40007, 28); e na hora de executar no navicat da esse erro aqui [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO merchant_buylists VALUES (9300, 1,40007, 0); [Msg] Finished - Unsuccessfully -------------------------------------------------- Consegui passa dessa parte , soo que quando entro no jogo pra dar spawn (//spawn 40007 )no npc ele nao vem diz assim : Your target Cannot be found. por queee ?