Quarry codes

08/05/2011 18:12 .Stefan#1

hey com ,

habe heute versucht die zombie mobs einzuf�gen , doch bei mir kommt immer der gleiche fehler :

1136 - Column count doesn't match value count at row 1

Hier sind die Querry Codes . Ich benutze die nw3 files ( .kaay331 files v.6 )

Spoiler

08/05/2011 18:32 .NighT�#2

Das sind 2010er Files.
Probiers mal so:

Spoiler

Code:

INSERT INTO `mob_proto` VALUES ('2501', 'zombie_diseased_kid', 0x5A6F6D626965204B696E64, '1', '0', '0', '100', '', 'AGGR,BERSERK,DEATHBLOW,REVIVE', '0', 'UNDEAD', '', '0', '', '0', '30', '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', '0', '0', '0', '0', '0', '0');
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', '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', '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', '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', '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', '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', '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', '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', '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', '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', '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', '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', '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', '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', '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', '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', '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', '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', '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', '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', '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', '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', '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', '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', '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', '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', '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', '0', '0', '0', '0', '0', '0');

Sollte gehen.

Greetz
.NighT™

08/05/2011 18:39 .Stefan#3

perfekt , l�uft.
was hast du da genau ge�ndert ?

08/05/2011 18:42 .NighT�#4

An die Querry hinten einfach 6x

Code:

, '0'

angeh�ngt, da es eine 2007er Querry war und bei der 2010er mob_proto 6 spalten mehr sind. Deshalb 6x mal die 0 dran^^

Greetz
.NighT™

08/05/2011 19:26 .Stefan#5

Quote:
Originally Posted by .NighT�
An die Querry hinten einfach 6x
Code:
, '0'
angeh�ngt, da es eine 2007er Querry war und bei der 2010er mob_proto 6 spalten mehr sind. Deshalb 6x mal die 0 dran^^

Greetz
.NighT�

und ich habs immer 7x gemacht :rolleyes:

aber jetzt geht es wenigstens , danke ^^