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

Erreur navicat


Wiizko
 Share

Question

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

Top Posters For This Question

14 answers to this question

Recommended Posts

  • 0

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

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

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

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

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

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

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

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

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.