Erreur navicat

Wiizko · le 3 juillet 2012

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 :

Hidden Content

Give reaction to this post to see the hidden content.

Modifié le 17 septembre 2022 par Funky Emulation
Core X - External 2 Internal

Gagil · le 3 juillet 2012

te manque surement des ligne dans tes querys ( genre value2 ou autres, c'est un exemple).

Wiizko · le 3 juillet 2012

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 ^^

Gagil · le 3 juillet 2012

T'es sous quel files ?

Wiizko · le 3 juillet 2012

Files 2006...

Gagil · le 3 juillet 2012

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');

Wiizko · le 3 juillet 2012

Merci mais cela ne fonctionne pas

antok · le 3 juillet 2012

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.

Wiizko · le 3 juillet 2012

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...

antok · le 3 juillet 2012

Non, ces colonnes servent à rien ^^

Galet · le 5 juillet 2012

Oui, elles sont inutiles donc supprime 6 zéro je croit (je ne me rappelle plus de l'emplacement exact.

Destro08 · le 7 juillet 2012

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

antok · le 7 juillet 2012

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

Destro08 · le 8 juillet 2012

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.

Kameyu · le 8 juillet 2012

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 ^^'

Connexion

Erreur navicat

Question

Wiizko 28

Lien vers le commentaire

Partager sur d’autres sites

Meilleurs contributeurs dans cette question

Jours populaires

Meilleurs contributeurs dans cette question

Jours populaires

14 réponses à cette question

Messages recommandés

Gagil 16

Lien vers le commentaire

Partager sur d’autres sites

Wiizko 28

Lien vers le commentaire

Partager sur d’autres sites

Gagil 16

Lien vers le commentaire

Partager sur d’autres sites

Wiizko 28

Lien vers le commentaire

Partager sur d’autres sites

Gagil 16

Lien vers le commentaire

Partager sur d’autres sites

Wiizko 28

Lien vers le commentaire

Partager sur d’autres sites

antok 62

Lien vers le commentaire

Partager sur d’autres sites

Wiizko 28

Lien vers le commentaire

Partager sur d’autres sites

antok 62

Lien vers le commentaire

Partager sur d’autres sites

Galet 463

Lien vers le commentaire

Partager sur d’autres sites

Destro08 13

Lien vers le commentaire

Partager sur d’autres sites

antok 62

Lien vers le commentaire

Partager sur d’autres sites

Destro08 13

Lien vers le commentaire

Partager sur d’autres sites

Kameyu 171

Lien vers le commentaire

Partager sur d’autres sites

Flux d'Activité

En ligne récemment

Information importante