Problem neue Monster :(

'-SkyLiiNe-' · 07/18/2011, 17:59

Ich habe folgende Query ausgeführt, da in der DB von Daroo's Files die neuen Mobs fehlen.

Code:

INSERT INTO `mob_proto` VALUES ('2502', 'zombie_diseased_dog', 0x5A6F6D6269652048756E64, '1', '0', '0', '100', '', 'AGGR,BERSERK,DEATHBLOW,REVIVE', '0', 'UNDEAD', '', '0', '', '0', '33', '40', '200', '10', '100', '500', '2000', '3', '3', '500000', '600000', '50000', '70', '100', '100', '100', '2000', '100', '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_diseased_infector', 0x5A6F6D626965626573657373656E6572, '2', '0', '0', '100', '', 'AGGR,BERSERK,DEATHBLOW,REVIVE', '0', 'UNDEAD', '', '0', '', '0', '34', '40', '200', '10', '140', '500', '2000', '3', '3', '500000', '1500000', '30000', '70', '100', '100', '100', '2000', '100', '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_diseased_sword', 0x5A6F6D626965736368776572746BE46D70666572, '2', '0', '0', '100', '', 'AGGR,BERSERK,DEATHBLOW,REVIVE', '0', 'UNDEAD', '', '0', '', '0', '40', '40', '200', '10', '140', '500', '2000', '3', '3', '500000', '1500000', '30000', '70', '100', '100', '100', '2000', '100', '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 ('2506', 'zombie_diseased_bow', 0x5A6F6D626965626F67656E736368FC747A65, '2', '0', '0', '100', '', 'AGGR,BERSERK,DEATHBLOW,REVIVE', '0', 'UNDEAD', '', '0', '', '0', '43', '40', '200', '10', '243', '500', '2000', '3', '3', '500000', '1500000', '30000', '70', '100', '100', '100', '2000', '100', '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_diseased_boss', 0x5A6F6D626965616E66FC68726572, '4', '0', '0', '100', '', 'AGGR,BERSERK,DEATHBLOW,REVIVE', '0', 'UNDEAD', '', '0', '', '0', '47', '40', '200', '10', '199', '500', '2000', '3', '3', '500000', '1500000', '30000', '70', '100', '100', '100', '2000', '100', '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_soldier_scythe', 0x53656E73656E6D616E6E7A6F6D626965, '3', '0', '0', '100', '', 'AGGR,BERSERK,DEATHBLOW,REVIVE', '0', 'UNDEAD', '', '0', '', '0', '65', '40', '200', '10', '254', '500', '2000', '3', '3', '500000', '1500000', '30000', '70', '100', '100', '100', '2000', '100', '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_soldier_bow', 0x5A6F6D626965626F67656E736368FC747A65, '3', '0', '0', '100', '', 'AGGR,BERSERK,DEATHBLOW,REVIVE', '0', 'UNDEAD', '', '0', '', '0', '59', '40', '200', '10', '277', '500', '5000', '3', '3', '500000', '1500000', '30000', '70', '100', '100', '100', '2000', '100', '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 ('2510', 'zombie_soldier_spear', 0x5A6F6D62696573706565726BE46D70666572, '3', '0', '0', '100', '', 'AGGR,BERSERK,DEATHBLOW,REVIVE', '0', 'UNDEAD', '', '0', '', '0', '70', '40', '200', '10', '243', '500', '500', '3', '3', '500000', '1500000', '30000', '70', '100', '100', '100', '2000', '100', '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 ('2511', 'zombie_magician', 0x5A6F6D6269657A61756265726572, '3', '0', '0', '100', '', 'AGGR,BERSERK,DEATHBLOW,REVIVE', '0', 'UNDEAD', '', '0', '', '0', '80', '40', '200', '10', '249', '500', '5000', '3', '3', '500000', '1500000', '30000', '70', '100', '100', '100', '2000', '100', '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 ('2512', 'zombie_bigboss', 0x5A6F6D626965616E66FC68726572, '4', '0', '0', '100', '', 'AGGR,BERSERK,DEATHBLOW,REVIVE', '0', 'UNDEAD', '', '0', '', '0', '80', '40', '200', '10', '249', '500', '5000', '3', '3', '500000', '1500000', '30000', '70', '100', '100', '100', '2000', '100', '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 ('2513', 'zombie_ghost', 0x5A6F6D6269656765697374, '2', '0', '0', '100', '', 'AGGR,BERSERK,DEATHBLOW,REVIVE', '0', 'UNDEAD', '', '0', '', '0', '67', '40', '200', '10', '249', '500', '5000', '3', '3', '500000', '1500000', '30000', '70', '100', '100', '100', '2000', '100', '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 ('2514', 'zombie_general', 0x5A6F6D62696567656E6572616C, '4', '0', '0', '100', '', 'AGGR,BERSERK,DEATHBLOW,REVIVE', '0', 'UNDEAD', '', '0', '', '0', '86', '40', '200', '10', '243', '500', '5000', '3', '3', '500000', '1500000', '30000', '70', '100', '100', '100', '2000', '100', '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 ('2541', 'Nonamezombie_soldier_scy', 0x53656E73656E6D616E6E7A6F6D626965, '4', '0', '0', '100', '', 'AGGR,BERSERK,DEATHBLOW,REVIVE', '0', 'UNDEAD', '', '0', '', '0', '81', '40', '200', '10', '249', '500', '2000', '3', '3', '500000', '1500000', '30000', '70', '100', '100', '100', '2000', '100', '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 ('2542', 'zombie_soldier_bow', 0x5A6F6D626965626F67656E736368FC747A65, '2', '0', '0', '100', '', 'AGGR,BERSERK,DEATHBLOW,REVIVE', '0', 'UNDEAD', '', '0', '', '0', '66', '40', '200', '10', '243', '500', '2000', '3', '3', '500000', '1500000', '30000', '70', '100', '100', '100', '2000', '100', '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 ('2543', 'zombie_soldier_spear', 0x5A6F6D62696573706565726BE46D70666572, '2', '0', '0', '100', '', 'AGGR,BERSERK,DEATHBLOW,REVIVE', '0', 'UNDEAD', '', '0', '', '0', '70', '40', '200', '10', '249', '500', '2000', '3', '3', '500000', '1500000', '30000', '70', '100', '100', '100', '2000', '100', '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 ('2544', 'zombie_magician', 0x5A6F6D6269657A61756265726572, '2', '0', '0', '100', '', 'AGGR,BERSERK,DEATHBLOW,REVIVE', '0', 'UNDEAD', '', '0', '', '0', '59', '40', '200', '10', '179', '500', '2000', '3', '3', '500000', '1500000', '30000', '70', '100', '100', '100', '2000', '100', '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 ('2545', 'zombie_bigboss', 0x5A6F6D626965616E66FC68726572, '4', '0', '0', '100', '', 'AGGR,BERSERK,DEATHBLOW,REVIVE', '0', 'UNDEAD', '', '0', '', '0', '76', '40', '200', '10', '243', '500', '2000', '3', '3', '500000', '1500000', '30000', '70', '100', '100', '100', '2000', '100', '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 ('2546', 'zombie_ghost', 0x5A6F6D6269656765697374, '3', '0', '0', '100', '', 'AGGR,BERSERK,DEATHBLOW,REVIVE', '0', 'UNDEAD', '', '0', '', '0', '80', '40', '200', '10', '179', '500', '2000', '3', '3', '500000', '1500000', '30000', '70', '100', '100', '100', '2000', '100', '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 ('2547', 'zombie_general', 0x5A6F6D62696567656E6572616C, '5', '0', '0', '100', '', 'AGGR,BERSERK,DEATHBLOW,REVIVE', '0', 'UNDEAD', '', '0', '', '0', '90', '40', '200', '10', '249', '500', '2000', '3', '3', '500000', '1500000', '30000', '70', '100', '100', '100', '2000', '100', '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 ('2591', 'zombie_king', 0x5A6F6D6269656BF66E6967, '6', '0', '0', '100', '', 'AGGR,BERSERK,DEATHBLOW,REVIVE', '0', 'UNDEAD', 'SLOW,FALL,CURSE,POISON,TERROR', '0', '', '0', '90', '40', '200', '10', '300', '500', '25000', '3', '3', '500000', '1500000', '30000', '70', '100', '100', '100', '2000', '100', '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 ('2592', 'zombie_king', 0x5A6F6D6269656BF66E6967, '6', '0', '0', '100', '', 'AGGR,BERSERK,DEATHBLOW,REVIVE', '0', 'UNDEAD', 'SLOW,FALL,CURSE,POISON,TERROR', '0', '', '0', '90', '40', '200', '10', '400', '500', '25000', '3', '3', '500000', '1500000', '30000', '70', '100', '100', '100', '2000', '100', '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 ('2593', 'zombie_king', 0x5A6F6D6269656BF66E6967, '6', '0', '0', '100', '', 'AGGR,BERSERK,DEATHBLOW,REVIVE', '0', 'UNDEAD', 'SLOW,FALL,CURSE,POISON,TERROR', '0', '', '0', '90', '40', '200', '10', '400', '500', '25000', '3', '3', '500000', '1500000', '30000', '70', '100', '100', '100', '2000', '100', '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 ('2594', 'zombie_king', 0x5A6F6D6269656BF66E6967, '5', '0', '0', '100', '', 'AGGR,BERSERK,DEATHBLOW,REVIVE', '0', 'UNDEAD', 'SLOW,FALL,CURSE,POISON,TERROR', '0', '', '0', '90', '40', '200', '10', '400', '500', '25000', '3', '3', '500000', '1500000', '30000', '70', '100', '100', '100', '2000', '100', '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 ('2595', 'zombie_king', 0x5A6F6D6269656BF66E6967, '5', '0', '0', '100', '', 'AGGR,BERSERK,DEATHBLOW,REVIVE', '0', 'UNDEAD', 'SLOW,FALL,CURSE,POISON,TERROR', '0', '', '0', '90', '40', '200', '10', '400', '500', '25000', '3', '3', '500000', '1500000', '30000', '70', '100', '100', '100', '2000', '100', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('2596', 'zombie_king', 0x5A6F6D6269656BF66E6967, '5', '0', '0', '100', '', 'AGGR,BERSERK,DEATHBLOW,REVIVE', '0', 'UNDEAD', 'SLOW,FALL,CURSE,POISON,TERROR', '0', '', '0', '90', '40', '200', '10', '400', '500', '25000', '3', '3', '500000', '1500000', '30000', '70', '100', '100', '100', '2000', '100', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('2597', 'zombie_god', 0x5A6F6D626965676F7474, '5', '0', '0', '100', '', 'AGGR,BERSERK,DEATHBLOW,REVIVE', '0', 'UNDEAD', 'SLOW,FALL,CURSE,POISON,TERROR', '0', '', '0', '90', '40', '200', '10', '400', '500', '25000', '3', '3', '500000', '1500000', '30000', '70', '100', '100', '100', '2000', '100', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('2598', 'zombie_god', 0x5A6F6D626965676F7474, '5', '0', '0', '100', '', 'AGGR,BERSERK,DEATHBLOW,REVIVE', '0', 'UNDEAD', 'SLOW,FALL,CURSE,POISON,TERROR', '0', '', '0', '120', '40', '150', '10', '600', '1000', '25000', '3', '3', '500000', '1500000', '30000', '70', '100', '100', '100', '5000', '100', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('2505', 'zombie_diseased_spear', 0x5A6F6D62696573706565726BE46D70666572, '2', '0', '0', '100', '', 'AGGR,BERSERK,DEATHBLOW,REVIVE', '0', 'UNDEAD', 'SLOW,FALL,CURSE,POISON,TERROR', '0', '', '0', '120', '40', '150', '10', '600', '1000', '25000', '3', '3', '500000', '1500000', '30000', '70', '100', '100', '100', '5000', '100', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

Der Fehler:[Err] 1136 - Column count doesn't match value count at row 1
Was kann ich machen??

Papa Kobe · 07/18/2011, 18:43

Also es ist ein Errorfehler in Reihe 1 ID, 1136 und er kann nicht die Value zuordnen? So etwa übersetzt ;D Fällt dir darüber was ein? Vlt. was du davor mit der Reihe gemacht hast, bevor du dies eingefügt hast?

LG
KS

'-SkyLiiNe-' · 07/18/2011, 19:03

#Frage geklärt
musste einfach 6x '0', einfügen, da es ja 2010 DB ist, die Query aber für 2007er DB war.
#MOD closen bitte