Jump to content
×
×
  • Create New...
  • 0

Erreur navicat

Wiizko

Asked by Wiizko,

 Share

Question

Wiizko Collaborator

Wiizko 23

Posted
Posted

Bonjour,

 

En voulant implanter des mobs, j'ai rencontré un petit soucis au niveau de navicat.

 

En me servant de cette query, (trouver sur un site allemand) :

 

INSERT INTO `mob_proto` VALUES ('20120', 'FeuerPhoenix', 0x466575657250686F656E6978, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '10', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('20121', 'FeuerPhoenix', 0x466575657250686F656E6978, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '10', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('20122', 'FeuerPhoenix', 0x466575657250686F656E6978, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '10', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('20123', 'EisPhoenix', 0x45697350686F656E6978, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '10', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('20124', 'EisPhoenix', 0x45697350686F656E6978, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '10', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('20125', 'EisPhoenix', 0x45697350686F656E6978, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '10', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('20126', 'RentierJunges', 0x52656E746965724A756E676573, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '10', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('20127', 'RentierJunges', 0x52656E746965724A756E676573, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '10', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('20128', 'RentierJunges', 0x52656E746965724A756E676573, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '10', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('20129', 'BabyAzrael', 0x42616279417A7261656C, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '10', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('20130', 'BabyAzrael', 0x42616279417A7261656C, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '10', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('20131', 'BabyAzrael', 0x42616279417A7261656C, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '10', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('20132', 'BabyHund', 0x6261627948756E64, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '10', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('20133', 'BabyHund', 0x6261627948756E64, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '10', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('20134', 'BabyHund', 0x6261627948756E64, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '10', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('20135', 'BabyLoewe', 0x426162794C6F657765, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '10', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('20136', 'BabyLoewe', 0x426162794C6F657765, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '10', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('20137', 'BabyLoewe', 0x426162794C6F657765, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '10', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('20138', 'BabyKeiler', 0x426162794B65696C6572, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '10', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('20139', 'BabyKeiler', 0x426162794B65696C6572, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '10', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('20140', 'BabyKeiler', 0x426162794B65696C6572, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '10', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('20141', 'BabyTiger', 0x426162795469676572, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '10', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('20142', 'BabyTiger', 0x426162795469676572, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '10', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('20143', 'BabyTiger', 0x426162795469676572, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '10', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

 

Donc c'est partie :

 

1.Ouverture de navicat :wink:

2.Direction table player

3.Query /new query

4.Collage de la query allemande

5.Cliquage sur run et la c'est le drame ^^

 

Voici ce qu'il me dit :

 

[sql] INSERT INTO `mob_proto` VALUES ('20120', 'FeuerPhoenix', 0x466575657250686F656E6978, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '10', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
[Err] 1136 - Column count doesn't match value count at row 1

 

Je vous met un screen si sa peut vous aidez :

 

navicatv.jpg

Link to comment
Share on other sites
  • Answers 14
  • Created
  • Last Reply

Top Posters For This Question

Popular Days

Top Posters For This Question

Popular Days

14 answers to this question

Recommended Posts

  • 0
Wiizko Collaborator

Wiizko 23

Posted
  • Author
Posted

Ouais il doit surement me manqué des colonnes dans mon mob_proto car quand je traduit le message d'erreur ( sur reverso ) sa me donne sa :

 

"Le compte de colonne ne correspond pas au compte de valeur à la rangée(dispute) 1"

 

Mais alors comment savoir quelle colonne me manque? et comment en créer de nouvelle?

 

PS: Je précise que ce ne sont pas des mobs normaux, ce sont des "pets" ou "familier".

Bien sur si le problème est résolue je vous partagerais tout les fichiers et la quete qui va avec ( je dois encore la traduire ).

Enfin si vous les voulez bien sur ^^

Link to comment
Share on other sites
  • 0
Gagil Community Regular

Gagil 14

Posted
Posted

Tien ces querys : 

INSERT INTO mob_proto VALUES ('2601', 'Troll_Combattant', 0x476E6F6D2048756E64, '2', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '100', '9', '77', '0', '300', '700', '50000', '4', '6', '5000000', '5000000', '500000', '60', '100', '100', '100', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2602', 'Troll_maudit', 0x476E6F6D204B726965676572, '3', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '100', '9', '65', '0', '300', '700', '50000', '4', '6', '5000000', '5000000', '500000', '60', '100', '100', '0', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2603', 'Troll_Alpha', 0x476E6F6D204D6167696572, '3', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '100', '9', '86', '0', '300', '700', '50000', '4', '6', '5000000', '5000000', '500000', '60', '100', '100', '0', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2604', 'Troll_Guerrier', 0x476E6F6D204D696E6F746175727573, '4', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '100', '9', '78', '0', '300', '700', '50000', '4', '6', '5000000', '5000000', '500000', '60', '100', '100', '0', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2605', 'Troll_Assassin', 0x476E6F6D204B6F6D616E64616E74, '5', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '200', '70', '120', '0', '300', '700', '50000', '7', '8', '5000000', '5000000', '500000', '100', '100', '100', '100', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.4', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2606', 'Troll_des_plaines', 0x54726F6C6C204B726965676572, '2', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '100', '9', '56', '0', '300', '700', '75000', '4', '6', '5000000', '5000000', '500000', '60', '100', '100', '0', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2607', 'Troll_des_montagnes', 0x54726F6C6C204D6167696572, '3', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '100', '9', '72', '0', '300', '700', '75000', '4', '6', '5000000', '10000000', '500000', '60', '100', '100', '0', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2608', 'Troll_Enragé', 0x4665747465722054726F6C6C, '4', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '100', '9', '99', '0', '300', '700', '75000', '4', '6', '5000000', '10000000', '500000', '60', '100', '100', '100', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2609', 'Roi_des_Trolls', 0x54726F6C6C204B6F6D616E64616E74, '5', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '200', '70', '130', '0', '300', '700', '75000', '7', '8', '5000000', '10000000', '500000', '120', '100', '100', '100', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2610', 'Troll_Affreux', 0x5761737365727363686C616E67656E736F6C646174, '2', '0', '0', '115', '', 'AGGR', '0', 'ANIMAL', '', '0', '', '0', '150', '9', '67', '0', '300', '700', '100000', '4', '6', '5000000', '10000000', '500000', '60', '100', '100', '0', '2000', '120', '27992', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2612', 'Troll_Tueur', 0x5761737365727363686C616E67656E6D6167696572, '4', '0', '0', '117', '', 'AGGR', '0', 'ANIMAL', '', '0', '', '0', '150', '9', '80', '0', '300', '700', '100000', '4', '6', '5000000', '10000000', '500000', '60', '100', '100', '0', '2000', '120', '27994', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2613', 'Troll_De_la Mort', 0x5761737365727363686C616E67656E6B6F6D616E64616E74, '5', '0', '0', '118', '', 'AGGR', '0', 'ANIMAL', '', '0', '', '0', '250', '100', '150', '0', '300', '700', '100000', '7', '8', '5000000', '10000000', '500000', '150', '100', '100', '100', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2501', 'Zombie_Combattant', 0x476E6F6D2048756E64, '2', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '100', '9', '77', '0', '300', '700', '50000', '4', '6', '5000000', '5000000', '500000', '60', '100', '100', '100', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2502', 'Zombie_maudit', 0x476E6F6D204B726965676572, '3', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '100', '9', '65', '0', '300', '700', '50000', '4', '6', '5000000', '5000000', '500000', '60', '100', '100', '0', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2503', 'Zombie_Alpha', 0x476E6F6D204D6167696572, '3', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '100', '9', '86', '0', '300', '700', '50000', '4', '6', '5000000', '5000000', '500000', '60', '100', '100', '0', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2504', 'Zombie_Guerrier', 0x476E6F6D204D696E6F746175727573, '4', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '100', '9', '78', '0', '300', '700', '50000', '4', '6', '5000000', '5000000', '500000', '60', '100', '100', '0', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2505', 'Zombie_Assassin', 0x476E6F6D204B6F6D616E64616E74, '5', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '200', '70', '120', '0', '300', '700', '50000', '7', '8', '5000000', '5000000', '500000', '100', '100', '100', '100', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.4', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2506', 'Zombie_des_plaines', 0x54726F6C6C204B726965676572, '2', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '100', '9', '56', '0', '300', '700', '75000', '4', '6', '5000000', '5000000', '500000', '60', '100', '100', '0', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2507', 'Zombie_des_montagnes', 0x54726F6C6C204D6167696572, '3', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '100', '9', '72', '0', '300', '700', '75000', '4', '6', '5000000', '10000000', '500000', '60', '100', '100', '0', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2508', 'Zombie_Enragé', 0x4665747465722054726F6C6C, '4', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '100', '9', '99', '0', '300', '700', '75000', '4', '6', '5000000', '10000000', '500000', '60', '100', '100', '100', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2509', 'Zombie_Caché', 0x54726F6C6C204B6F6D616E64616E74, '5', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '200', '70', '130', '0', '300', '700', '75000', '7', '8', '5000000', '10000000', '500000', '120', '100', '100', '100', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2510', 'Zombie_Affreux', 0x5761737365727363686C616E67656E736F6C646174, '2', '0', '0', '115', '', 'AGGR', '0', 'ANIMAL', '', '0', '', '0', '150', '9', '67', '0', '300', '700', '100000', '4', '6', '5000000', '10000000', '500000', '60', '100', '100', '0', '2000', '120', '27992', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2512', 'Zombie_Tueur', 0x5761737365727363686C616E67656E6D6167696572, '4', '0', '0', '117', '', 'AGGR', '0', 'ANIMAL', '', '0', '', '0', '150', '9', '80', '0', '300', '700', '100000', '4', '6', '5000000', '10000000', '500000', '60', '100', '100', '0', '2000', '120', '27994', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2513', 'Zombie_De_la_Mort', 0x5761737365727363686C616E67656E6B6F6D616E64616E74, '5', '0', '0', '118', '', 'AGGR', '0', 'ANIMAL', '', '0', '', '0', '250', '100', '150', '0', '300', '700', '100000', '7', '8', '5000000', '10000000', '500000', '150', '100', '100', '100', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');INSERT INTO mob_proto VALUES ('2601', 'Troll_Combattant', 0x476E6F6D2048756E64, '2', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '100', '9', '77', '0', '300', '700', '50000', '4', '6', '5000000', '5000000', '500000', '60', '100', '100', '100', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2602', 'Troll_maudit', 0x476E6F6D204B726965676572, '3', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '100', '9', '65', '0', '300', '700', '50000', '4', '6', '5000000', '5000000', '500000', '60', '100', '100', '0', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2603', 'Troll_Alpha', 0x476E6F6D204D6167696572, '3', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '100', '9', '86', '0', '300', '700', '50000', '4', '6', '5000000', '5000000', '500000', '60', '100', '100', '0', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2604', 'Troll_Guerrier', 0x476E6F6D204D696E6F746175727573, '4', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '100', '9', '78', '0', '300', '700', '50000', '4', '6', '5000000', '5000000', '500000', '60', '100', '100', '0', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2605', 'Troll_Assassin', 0x476E6F6D204B6F6D616E64616E74, '5', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '200', '70', '120', '0', '300', '700', '50000', '7', '8', '5000000', '5000000', '500000', '100', '100', '100', '100', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.4', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2606', 'Troll_des_plaines', 0x54726F6C6C204B726965676572, '2', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '100', '9', '56', '0', '300', '700', '75000', '4', '6', '5000000', '5000000', '500000', '60', '100', '100', '0', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2607', 'Troll_des_montagnes', 0x54726F6C6C204D6167696572, '3', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '100', '9', '72', '0', '300', '700', '75000', '4', '6', '5000000', '10000000', '500000', '60', '100', '100', '0', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2608', 'Troll_Enragé', 0x4665747465722054726F6C6C, '4', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '100', '9', '99', '0', '300', '700', '75000', '4', '6', '5000000', '10000000', '500000', '60', '100', '100', '100', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2609', 'Roi_des_Trolls', 0x54726F6C6C204B6F6D616E64616E74, '5', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '200', '70', '130', '0', '300', '700', '75000', '7', '8', '5000000', '10000000', '500000', '120', '100', '100', '100', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2610', 'Troll_Affreux', 0x5761737365727363686C616E67656E736F6C646174, '2', '0', '0', '115', '', 'AGGR', '0', 'ANIMAL', '', '0', '', '0', '150', '9', '67', '0', '300', '700', '100000', '4', '6', '5000000', '10000000', '500000', '60', '100', '100', '0', '2000', '120', '27992', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2612', 'Troll_Tueur', 0x5761737365727363686C616E67656E6D6167696572, '4', '0', '0', '117', '', 'AGGR', '0', 'ANIMAL', '', '0', '', '0', '150', '9', '80', '0', '300', '700', '100000', '4', '6', '5000000', '10000000', '500000', '60', '100', '100', '0', '2000', '120', '27994', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2613', 'Troll_De_la Mort', 0x5761737365727363686C616E67656E6B6F6D616E64616E74, '5', '0', '0', '118', '', 'AGGR', '0', 'ANIMAL', '', '0', '', '0', '250', '100', '150', '0', '300', '700', '100000', '7', '8', '5000000', '10000000', '500000', '150', '100', '100', '100', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2501', 'Zombie_Combattant', 0x476E6F6D2048756E64, '2', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '100', '9', '77', '0', '300', '700', '50000', '4', '6', '5000000', '5000000', '500000', '60', '100', '100', '100', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2502', 'Zombie_maudit', 0x476E6F6D204B726965676572, '3', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '100', '9', '65', '0', '300', '700', '50000', '4', '6', '5000000', '5000000', '500000', '60', '100', '100', '0', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2503', 'Zombie_Alpha', 0x476E6F6D204D6167696572, '3', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '100', '9', '86', '0', '300', '700', '50000', '4', '6', '5000000', '5000000', '500000', '60', '100', '100', '0', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2504', 'Zombie_Guerrier', 0x476E6F6D204D696E6F746175727573, '4', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '100', '9', '78', '0', '300', '700', '50000', '4', '6', '5000000', '5000000', '500000', '60', '100', '100', '0', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2505', 'Zombie_Assassin', 0x476E6F6D204B6F6D616E64616E74, '5', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '200', '70', '120', '0', '300', '700', '50000', '7', '8', '5000000', '5000000', '500000', '100', '100', '100', '100', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.4', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2506', 'Zombie_des_plaines', 0x54726F6C6C204B726965676572, '2', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '100', '9', '56', '0', '300', '700', '75000', '4', '6', '5000000', '5000000', '500000', '60', '100', '100', '0', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2507', 'Zombie_des_montagnes', 0x54726F6C6C204D6167696572, '3', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '100', '9', '72', '0', '300', '700', '75000', '4', '6', '5000000', '10000000', '500000', '60', '100', '100', '0', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2508', 'Zombie_Enragé', 0x4665747465722054726F6C6C, '4', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '100', '9', '99', '0', '300', '700', '75000', '4', '6', '5000000', '10000000', '500000', '60', '100', '100', '100', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2509', 'Zombie_Caché', 0x54726F6C6C204B6F6D616E64616E74, '5', '0', '0', '110', '', 'AGGR', '0', 'ORC', '', '0', '', '0', '200', '70', '130', '0', '300', '700', '75000', '7', '8', '5000000', '10000000', '500000', '120', '100', '100', '100', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2510', 'Zombie_Affreux', 0x5761737365727363686C616E67656E736F6C646174, '2', '0', '0', '115', '', 'AGGR', '0', 'ANIMAL', '', '0', '', '0', '150', '9', '67', '0', '300', '700', '100000', '4', '6', '5000000', '10000000', '500000', '60', '100', '100', '0', '2000', '120', '27992', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2512', 'Zombie_Tueur', 0x5761737365727363686C616E67656E6D6167696572, '4', '0', '0', '117', '', 'AGGR', '0', 'ANIMAL', '', '0', '', '0', '150', '9', '80', '0', '300', '700', '100000', '4', '6', '5000000', '10000000', '500000', '60', '100', '100', '0', '2000', '120', '27994', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO mob_proto VALUES ('2513', 'Zombie_De_la_Mort', 0x5761737365727363686C616E67656E6B6F6D616E64616E74, '5', '0', '0', '118', '', 'AGGR', '0', 'ANIMAL', '', '0', '', '0', '250', '100', '150', '0', '300', '700', '100000', '7', '8', '5000000', '10000000', '500000', '150', '100', '100', '100', '2000', '120', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

Link to comment
Share on other sites
  • 0
antok Grand Master

antok 52

Posted
Posted

Les querys que tu as utilisées sont sûrement pour les files 2010 ou +.

 

Sur ces files, il y a plus de colonnes dans le mob_proto : skill_level2, skill_vnum2, skill_level3, skill_vnum3, skill_level4, skill_vnum4.

 

Ça fait donc 6 colonnes à enlever pour ta query.

Link to comment
Share on other sites
  • 0
Wiizko Collaborator

Wiizko 23

Posted
  • Author
Posted

Ok Ant0k je comprend mais le soucis c'est que si je fais sa, le "pet" risque de plus remplir ses fonctions non?

 

le mieux serait que je change carrément de files...

Link to comment
Share on other sites
  • 0
Destro08 Explorer

Destro08 8

Posted
Posted

Rien a voir avec les colone ou quoi que ce soit ce sont juste les tabulation.

 

Tu la pris sur un forum, les forum n'accepte pas les tabulation, donc c'est juste que quand tu la pris tout les tabulation sont devenu des espace donc tu doit modifier tout les espace QUI SONT DANS LES PARENTHÈSE par des tabulation après chaque virgule.

 

INSERT INTO `mob_proto` VALUES ('20120',[TAB]'FeuerPhoenix',[TAB]0x466575657250686F656E6978,[TAB]'5',[TAB]'1',[TAB]'0',[TAB]'1',[TAB]'',[TAB]'',[TAB]'0',[TAB]'',[TAB]'STUN,SLOW,CURSE,TERROR',[TAB]'0',[TAB]'',[TAB]'2',[TAB]'0',[TAB]'0',[TAB]'0',[TAB]'0',[TAB]'0',[TAB]'0',[TAB]'120',...,[TAB]'0');

et quand tu a 2 espace tu met 2 tabulation ainsi de suite

Link to comment
Share on other sites
  • 0
antok Grand Master

antok 52

Posted
Posted

Rien a voir avec les colone ou quoi que ce soit ce sont juste les tabulation.

 

Tu la pris sur un forum, les forum n'accepte pas les tabulation, donc c'est juste que quand tu la pris tout les tabulation sont devenu des espace donc tu doit modifier tout les espace QUI SONT DANS LES PARENTHÈSE par des tabulation après chaque virgule.

 

INSERT INTO `mob_proto` VALUES ('20120',[TAB]'FeuerPhoenix',[TAB]0x466575657250686F656E6978,[TAB]'5',[TAB]'1',[TAB]'0',[TAB]'1',[TAB]'',[TAB]'',[TAB]'0',[TAB]'',[TAB]'STUN,SLOW,CURSE,TERROR',[TAB]'0',[TAB]'',[TAB]'2',[TAB]'0',[TAB]'0',[TAB]'0',[TAB]'0',[TAB]'0',[TAB]'0',[TAB]'120',...,[TAB]'0');

et quand tu a 2 espace tu met 2 tabulation ainsi de suite

 

[sql] INSERT INTO `mob_proto` VALUES ('20120', 'FeuerPhoenix', 0x466575657250686F656E6978, '5', '1', '0', '1', '', '', '0', '', 'STUN,SLOW,CURSE,TERROR', '0', '', '2', '0', '0', '0', '0', '0', '0', '120', '3', '1', '0', '0', '10', '4', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
[Err] 1136 - Column count doesn't match value count at row 1

 

En français :

 

"Le nombre de colonnes ne correspond pas au nombre de valeurs dans la première ligne"

 

La "première ligne" signifie la query...

 

Donc ça n'a rien à voir avec les tabulations

Link to comment
Share on other sites
  • 0
Destro08 Explorer

Destro08 8

Posted
Posted

Suit mes conseils, il dit qu'il y a un problème avec la 1ere colone car il met '20120' et comme c'est un espace il veux mettre 'FeuerPhoenix' dans la même case ce qui est impossible donc l'erreur est bien dans la 1ere colonne car elle supporte que des nombre et nom des mot met des Tabulation au lieux des espace et je te garanti que ça va fonctionner.

Link to comment
Share on other sites
  • 0
  • Developer
Kameyu Mentor

Kameyu 149

Posted
  • Developer
Posted

Suit mes conseils, il dit qu'il y a un problème avec la 1ere colone car il met '20120' et comme c'est un espace il veux mettre 'FeuerPhoenix' dans la même case ce qui est impossible donc l'erreur est bien dans la 1ere colonne car elle supporte que des nombre et nom des mot met des Tabulation au lieux des espace et je te garanti que ça va fonctionner.

 

Bonne blague, si on suivait tes conseils, on irait pas loin !

 

Ce que tu dis n'a rien à voir. Sa table mob_proto est différente des files 2010+ qui elle possède plus de colonnes que celles de 2006 donc logiquement il y a des valeurs en trop dans ses queries.

 

On te dit que tu te trompes et tu insistes ^^'

Link to comment
Share on other sites
Guest
This topic is now closed to further replies.
 Share
Go to question listing


Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.

  I accept