Problema item proto mysql

hamasoul · 13 Iun 2016, 18:37

Salut, am o problema cu niste coduri mysql.Imi da eroarea asta :
[Err] 1136 - Column count doesn't match value count at row 1

Codurile ce am vrut sa le inserez sunt :

SELECT * FROM `item_proto`;
INSERT INTO `item_proto` VALUES('55550','','Armura Zeului Arion+0','2','0','0','2','56','1','1','0','555500000','555500000','55551','181','15','1','66','0','0','73','1','74','1','69','1','0','250','0','55550','0','0','-1','-1','-1','-1','-1','-1','0','3','0');
INSERT INTO `item_proto` VALUES('55551','','Armura Zeului Arion+1','2','0','0','2','56','1','1','0','555500000','130000','55552','182','15','1','66','0','0','73','2','74','2','69','2','0','260','0','55550','0','3','-1','-1','-1','-1','-1','-1','0','3','0');
INSERT INTO `item_proto` VALUES('55552','','Armura Zeului Arion+2','2','0','0','2','56','1','1','0','555500000','145000','55553','183','15','1','66','0','0','73','3','74','3','69','3','0','270','0','55550','0','6','-1','-1','-1','-1','-1','-1','0','3','0');
INSERT INTO `item_proto` VALUES('55553','','Armura Zeului Arion+3','2','0','0','2','56','1','1','0','555500000','165000','55554','184','15','1','67','0','0','73','4','74','4','69','4','0','280','0','55550','0','9','-1','-1','-1','-1','-1','-1','0','3','0');
INSERT INTO `item_proto` VALUES('55554','','Armura Zeului Arion+4','2','0','0','2','56','1','1','0','555500000','190000','55555','185','15','1','67','0','0','73','5','74','5','69','5','0','290','0','55550','0','55550','-1','-1','-1','-1','-1','-1','30','3','0');
INSERT INTO `item_proto` VALUES('55555','','Armura Zeului Arion+5','2','0','0','2','56','1','1','0','555500000','220000','55556','186','15','1','68','0','0','73','6','74','6','69','6','0','300','0','55550','0','15','-1','-1','-1','-1','-1','-1','40','3','0');
INSERT INTO `item_proto` VALUES('55556','','Armura Zeului Arion+6','2','0','0','2','56','1','1','0','555500000','265000','55557','187','15','1','68','0','0','73','7','74','7','69','7','0','310','0','55550','0','18','-1','-1','-1','-1','-1','-1','50','3','0');
INSERT INTO `item_proto` VALUES('55557','','Armura Zeului Arion+7','2','0','0','2','56','1','1','0','555500000','325000','55558','188','15','1','69','0','0','73','8','74','8','69','8','0','320','0','55550','0','21','-1','-1','-1','-1','-1','-1','65','3','0');
INSERT INTO `item_proto` VALUES('55558','','Armura Zeului Arion+8','2','0','0','2','56','1','1','0','555500000','405000','55559','189','15','1','69','0','0','73','9','74','9','69','9','0','330','0','55550','0','24','-1','-1','-1','-1','-1','-1','80','3','0');
INSERT INTO `item_proto` VALUES('55559','','Armura Zeului Arion+9','2','0','0','2','56','1','1','0','555500000','515000','0','530','15','1','70','0','0','73','10','74','10','69','10','0','340','0','55550','0','27','-1','-1','-1','-1','-1','-1','100','3','0');
INSERT INTO `item_proto` VALUES('55560','','Costumul Zeului Arion+0','2','0','0','2','52','1','1','0','555500000','555500000','55561','181','15','1','66','0','0','73','1','74','1','69','1','0','250','0','55550','0','0','-1','-1','-1','-1','-1','-1','0','3','0');
INSERT INTO `item_proto` VALUES('55561','','Costumul Zeului Arion+1','2','0','0','2','52','1','1','0','555500000','130000','55562','182','15','1','66','0','0','73','2','74','2','69','2','0','260','0','55550','0','3','-1','-1','-1','-1','-1','-1','0','3','0');
INSERT INTO `item_proto` VALUES('55562','','Costumul Zeului Arion+2','2','0','0','2','52','1','1','0','555500000','145000','55563','183','15','1','66','0','0','73','3','74','3','69','3','0','270','0','55550','0','6','-1','-1','-1','-1','-1','-1','0','3','0');
INSERT INTO `item_proto` VALUES('55563','','Costumul Zeului Arion+3','2','0','0','2','52','1','1','0','555500000','165000','55564','184','15','1','67','0','0','73','4','74','4','69','4','0','280','0','55550','0','9','-1','-1','-1','-1','-1','-1','0','3','0');
INSERT INTO `item_proto` VALUES('55564','','Costumul Zeului Arion+4','2','0','0','2','53','1','1','0','555500000','190000','55565','185','15','1','67','0','0','73','5','74','5','69','5','0','290','0','55550','0','55550','-1','-1','-1','-1','-1','-1','30','3','0');
INSERT INTO `item_proto` VALUES('55565','','Costumul Zeului Arion+5','2','0','0','2','52','1','1','0','555500000','220000','55566','186','15','1','68','0','0','73','6','74','6','69','6','0','300','0','55550','0','15','-1','-1','-1','-1','-1','-1','40','3','0');
INSERT INTO `item_proto` VALUES('55566','','Costumul Zeului Arion+6','2','0','0','2','52','1','1','0','555500000','265000','55567','187','15','1','68','0','0','73','7','74','7','69','7','0','310','0','55550','0','18','-1','-1','-1','-1','-1','-1','50','3','0');
INSERT INTO `item_proto` VALUES('55567','','Costumul Zeului Arion+7','2','0','0','2','52','1','1','0','555500000','325000','55568','188','15','1','69','0','0','73','8','74','8','69','8','0','320','0','55550','0','21','-1','-1','-1','-1','-1','-1','65','3','0');
INSERT INTO `item_proto` VALUES('55568','','Costumul Zeului Arion+8','2','0','0','2','52','1','1','0','555500000','405000','55569','189','15','1','69','0','0','73','9','74','9','69','9','0','330','0','55550','0','24','-1','-1','-1','-1','-1','-1','80','3','0');
INSERT INTO `item_proto` VALUES('55569','','Costumul Zeului Arion+9','2','0','0','2','52','1','1','0','555500000','515000','0','530','15','1','70','0','0','73','10','74','10','69','10','0','340','0','55550','0','27','-1','-1','-1','-1','-1','-1','100','3','0');
INSERT INTO `item_proto` VALUES('55570','','Vesmantul Zeului Arion+0','2','0','0','2','28','1','1','0','555500000','555500000','55571','181','15','1','66','0','0','73','1','74','1','69','1','0','250','0','55550','0','0','-1','-1','-1','-1','-1','-1','0','3','0');
INSERT INTO `item_proto` VALUES('55571','','Vesmantul Zeului Arion+1','2','0','0','2','28','1','1','0','555500000','130000','55572','182','15','1','66','0','0','73','2','74','2','69','2','0','260','0','55550','0','3','-1','-1','-1','-1','-1','-1','0','3','0');
INSERT INTO `item_proto` VALUES('55572','','Vesmantul Zeului Arion+2','2','0','0','2','28','1','1','0','555500000','145000','55573','183','15','1','66','0','0','73','3','74','3','69','3','0','270','0','55550','0','6','-1','-1','-1','-1','-1','-1','0','3','0');
INSERT INTO `item_proto` VALUES('55573','','Vesmantul Zeului Arion+3','2','0','0','2','28','1','1','0','555500000','165000','55574','184','15','1','67','0','0','73','4','74','4','69','4','0','280','0','55550','0','9','-1','-1','-1','-1','-1','-1','0','3','0');
INSERT INTO `item_proto` VALUES('55574','','Vesmantul Zeului Arion+4','2','0','0','2','53','1','1','0','555500000','190000','55575','185','15','1','67','0','0','73','5','74','5','69','5','0','290','0','55550','0','55550','-1','-1','-1','-1','-1','-1','30','3','0');
INSERT INTO `item_proto` VALUES('55575','','Vesmantul Zeului Arion+5','2','0','0','2','28','1','1','0','555500000','220000','55576','186','15','1','68','0','0','73','6','74','6','69','6','0','300','0','55550','0','15','-1','-1','-1','-1','-1','-1','40','3','0');
INSERT INTO `item_proto` VALUES('55576','','Vesmantul Zeului Arion+6','2','0','0','2','28','1','1','0','555500000','265000','55577','187','15','1','68','0','0','73','7','74','7','69','7','0','310','0','55550','0','18','-1','-1','-1','-1','-1','-1','50','3','0');
INSERT INTO `item_proto` VALUES('55577','','Vesmantul Zeului Arion+7','2','0','0','2','28','1','1','0','555500000','325000','55578','188','15','1','69','0','0','73','8','74','8','69','8','0','320','0','55550','0','21','-1','-1','-1','-1','-1','-1','65','3','0');
INSERT INTO `item_proto` VALUES('55578','','Vesmantul Zeului Arion+8','2','0','0','2','28','1','1','0','555500000','405000','55579','189','15','1','69','0','0','73','9','74','9','69','9','0','330','0','55550','0','24','-1','-1','-1','-1','-1','-1','80','3','0');
INSERT INTO `item_proto` VALUES('55579','','Vesmantul Zeului Arion+9','2','0','0','2','28','1','1','0','555500000','515000','0','530','15','1','70','0','0','73','10','74','10','69','10','0','340','0','55550','0','27','-1','-1','-1','-1','-1','-1','100','3','0');
INSERT INTO `item_proto` VALUES('55580','','Platosa Zeului Arion+0','2','0','0','2','44','1','1','0','555500000','555500000','55571','181','15','1','66','0','0','73','1','74','1','69','1','0','250','0','55550','0','0','-1','-1','-1','-1','-1','-1','0','3','0');
INSERT INTO `item_proto` VALUES('55581','','Platosa Zeului Arion+1','2','0','0','2','44','1','1','0','555500000','130000','55572','182','15','1','66','0','0','73','2','74','2','69','2','0','260','0','55550','0','3','-1','-1','-1','-1','-1','-1','0','3','0');
INSERT INTO `item_proto` VALUES('55582','','Platosa Zeului Arion+2','2','0','0','2','44','1','1','0','555500000','145000','55573','183','15','1','66','0','0','73','3','74','3','69','3','0','270','0','55550','0','6','-1','-1','-1','-1','-1','-1','0','3','0');
INSERT INTO `item_proto` VALUES('55583','','Platosa Zeului Arion+3','2','0','0','2','44','1','1','0','555500000','165000','55574','184','15','1','67','0','0','73','4','74','4','69','4','0','280','0','55550','0','9','-1','-1','-1','-1','-1','-1','0','3','0');
INSERT INTO `item_proto` VALUES('55584','','Platosa Zeului Arion+4','2','0','0','2','53','1','1','0','555500000','190000','55575','185','15','1','67','0','0','73','5','74','5','69','5','0','290','0','55550','0','55550','-1','-1','-1','-1','-1','-1','30','3','0');
INSERT INTO `item_proto` VALUES('55585','','Platosa Zeului Arion+5','2','0','0','2','44','1','1','0','555500000','220000','55576','186','15','1','68','0','0','73','6','74','6','69','6','0','300','0','55550','0','15','-1','-1','-1','-1','-1','-1','40','3','0');
INSERT INTO `item_proto` VALUES('55586','','Platosa Zeului Arion+6','2','0','0','2','44','1','1','0','555500000','265000','55577','187','15','1','68','0','0','73','7','74','7','69','7','0','310','0','55550','0','18','-1','-1','-1','-1','-1','-1','50','3','0');
INSERT INTO `item_proto` VALUES('55587','','Platosa Zeului Arion+7','2','0','0','2','44','1','1','0','555500000','325000','55578','188','15','1','69','0','0','73','8','74','8','69','8','0','320','0','55550','0','21','-1','-1','-1','-1','-1','-1','65','3','0');
INSERT INTO `item_proto` VALUES('55588','','Platosa Zeului Arion+8','2','0','0','2','44','1','1','0','555500000','405000','55579','189','15','1','69','0','0','73','9','74','9','69','9','0','330','0','55550','0','24','-1','-1','-1','-1','-1','-1','80','3','0');
INSERT INTO `item_proto` VALUES('55589','','Platosa Zeului Arion+9','2','0','0','2','44','1','1','0','555500000','515000','0','530','15','1','70','0','0','73','10','74','10','69','10','0','340','0','55550','0','27','-1','-1','-1','-1','-1','-1','100','3','0');

Bgd · 13 Iun 2016, 19:19

codul pare ok, ce nu merge?

mrspeak · 13 Iun 2016, 20:39

1. Te loghezi navicat.
2. Selectezi tabelul player.
3. Apoi foloseşti tastatura şi:
Apeşi ctrl şi Q
Apoi ctrl şi N
4. Bagi asta acolo:

5. Apeşi RUN şi done.

GameruBandit · 14 Iun 2016, 16:05

Cel mai simplu ai item_proto.txt si nu iti citeste .sql ! Intri in /usr/home/game/db si ai acolo item.proto.txt si acolo adaugi ! un thx daca se poate!

hamasoul · 14 Iun 2016, 18:41

Rezolvat, nu a fost nici una din cele de mai sus. Am folosit un item_proto converotr care era un big shit,cer T/C.

23 Iun 2016, 14:08

Problemă rezolvată.

Problema item proto mysql

intrebare cum pot face item proto in item proto pt mysql

Cum fac Item Proto client si mysql

Problema item proto si mob proto

Item proto server -> item proto client

Cine este conectat