Problemas al implementar BICHOS¬¬
-
Hola amigos de Uj! Les traigo el siguiente problema:
QUIERO PONER ESTAS QUERYS DE LOS BICHOS :
INSERT INTO `mob_proto` VALUES ('2501', 'zombie_diseased_kid', 'Cadavere Zombie', '1', '0', '0', '74', '', 'AGGR', '0', 'UNDEAD', '', '0', 'zombie_diseased_kid', '0', '60', '50', '55', '25', '100', '150', '100000', '5', '10', '15000', '25000', '120000', '300', '100', '100', '100', '2000', '100', '0', '0', '0', '0', '4', '3', '10', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '25', '0', '0', '0', '0'); INSERT INTO `mob_proto` VALUES ('2502', 'zombie_diseased_dog', 'Cane Zombie', '1', '0', '0', '73', '', 'AGGR', '0', 'UNDEAD', '', '0', 'zombie_diseased_dog', '0', '60', '50', '55', '25', '100', '150', '100000', '5', '10', '15000', '25000', '120000', '300', '100', '100', '100', '2000', '100', '0', '0', '0', '0', '4', '3', '10', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '25', '0', '0', '0', '0'); INSERT INTO `mob_proto` VALUES ('2503', 'zombie_diseased_infector', 'Zombie Infettato', '2', '0', '0', '75', '', 'AGGR', '0', 'UNDEAD', '', '0', 'zombie_diseased_infector', '0', '60', '50', '55', '25', '100', '150', '100000', '5', '10', '15000', '25000', '120000', '300', '100', '100', '100', '2000', '100', '0', '0', '0', '0', '4', '3', '10', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '25', '0', '0', '0', '0'); INSERT INTO `mob_proto` VALUES ('2504', 'zombie_diseased_sword', 'Zombie Guerriero', '2', '0', '0', '77', '', 'AGGR', '0', 'UNDEAD', '', '0', 'zombie_diseased_sword', '0', '60', '50', '55', '25', '100', '150', '100000', '5', '10', '15000', '25000', '120000', '300', '100', '100', '100', '2000', '100', '0', '0', '0', '0', '4', '3', '10', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '25', '0', '0', '0', '0'); INSERT INTO `mob_proto` VALUES ('2505', 'zombie_diseased_spear', 'Zombie Lanciere', '2', '0', '0', '76', '', 'AGGR', '0', 'UNDEAD', '', '0', 'zombie_diseased_spear', '0', '60', '50', '55', '25', '100', '150', '100000', '5', '10', '15000', '25000', '120000', '300', '100', '100', '100', '2000', '100', '0', '0', '0', '0', '4', '3', '10', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '25', '0', '0', '0', '0'); INSERT INTO `mob_proto` VALUES ('2506', 'zombie_diseased_bow', 'Zombie Arcere', '2', '0', '0', '73', '', 'AGGR', '0', 'UNDEAD', '', '0', 'zombie_diseased_bow', '0', '60', '50', '55', '25', '100', '150', '100000', '5', '10', '15000', '25000', '120000', '300', '100', '100', '100', '2000', '100', '0', '0', '0', '0', '4', '3', '10', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '25', '0', '0', '0', '0'); INSERT INTO `mob_proto` VALUES ('2507', 'zombie_diseased_boss', 'Boss Zombie', '4', '0', '0', '79', '', 'AGGR', '0', 'UNDEAD', '', '0', 'zombie_diseased_boss', '0', '60', '50', '55', '25', '100', '150', '100000', '5', '10', '15000', '25000', '120000', '300', '100', '100', '100', '2000', '100', '0', '0', '0', '0', '4', '3', '10', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '25', '0', '0', '0', '0'); INSERT INTO `mob_proto` VALUES ('2508', 'zombie_soldier_scythe', 'Demone Zombie', '3', '0', '0', '81', '', 'AGGR', '0', 'UNDEAD', '', '0', 'zombie_soldier_scythe', '0', '70', '65', '55', '25', '125', '180', '100000', '5', '10', '15000', '25000', '120000', '300', '100', '100', '100', '2000', '100', '0', '0', '0', '0', '4', '3', '10', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '25', '0', '0', '0', '0'); INSERT INTO `mob_proto` VALUES ('2509', 'zombie_soldier_bow', 'Arcere Zombie', '2', '0', '0', '77', '', 'AGGR', '0', 'UNDEAD', '', '0', 'zombie_soldier_bow', '0', '70', '65', '55', '25', '125', '180', '100000', '5', '10', '15000', '25000', '120000', '300', '100', '100', '100', '2000', '100', '0', '0', '0', '0', '4', '3', '10', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '25', '0', '0', '0', '0'); INSERT INTO `mob_proto` VALUES ('2510', 'zombie_soldier_spear', 'Lanciere Zombie', '2', '0', '0', '80', '', 'AGGR', '0', 'UNDEAD', '', '0', 'zombie_soldier_spear', '0', '70', '65', '55', '25', '125', '180', '100000', '5', '10', '15000', '25000', '120000', '300', '100', '100', '100', '2000', '100', '0', '0', '0', '0', '4', '3', '10', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '25', '0', '0', '0', '0'); INSERT INTO `mob_proto` VALUES ('2511', 'zombie_magician', 'Zombie Mago', '3', '0', '0', '73', '', 'AGGR', '0', 'UNDEAD', '', '0', 'zombie_magician', '0', '70', '65', '55', '25', '75', '150', '100000', '5', '10', '15000', '25000', '120000', '300', '100', '100', '100', '2000', '100', '0', '0', '0', '0', '4', '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '25', '0', '0', '0', '0'); INSERT INTO `mob_proto` VALUES ('2512', 'zombie_bigboss', 'Zombie Big Boss', '4', '0', '0', '85', '', 'AGGR', '0', 'UNDEAD', '', '0', 'zombie_bigboss', '0', '70', '65', '55', '25', '75', '150', '60000', '5', '10', '15000', '25000', '120000', '88', '100', '100', '100', '2000', '100', '0', '0', '0', '0', '4', '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '25', '0', '0', '0', '0'); INSERT INTO `mob_proto` VALUES ('2513', 'zombie_ghost', 'Zombie Fantasma', '3', '0', '0', '82', '', 'AGGR', '0', 'UNDEAD', '', '0', 'zombie_ghost', '0', '70', '65', '55', '25', '75', '150', '60000', '5', '10', '15000', '25000', '120000', '88', '100', '100', '100', '2000', '100', '0', '0', '0', '0', '4', '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0', '0', '0', '0', '25', '0', '0', '0', '0'); INSERT INTO `mob_proto` VALUES ('2514', 'zombie_general', 'Generale Zombie', '4', '0', '0', '85', '', 'AGGR', '0', 'UNDEAD', '', '0', 'zombie_general', '0', '70', '65', '55', '25', '75', '150', '60000', '5', '10', '15000', '25000', '120000', '88', '100', '100', '100', '2000', '100', '0', '0', '0', '0', '4', '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0', '0', '0', '0', '25', '0', '0', '0', '0'); INSERT INTO `mob_proto` VALUES ('2541', 'zombie_soldier_scythe', 'Zombie Scy', '4', '0', '0', '79', '', 'AGGR', '0', 'UNDEAD', '', '0', 'zombie_soldier_scythe', '0', '80', '65', '55', '25', '100', '200', '60000', '5', '10', '15000', '25000', '120000', '88', '100', '100', '100', '2000', '100', '0', '0', '0', '0', '4', '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0', '0', '0', '0', '25', '0', '0', '0', '0'); INSERT INTO `mob_proto` VALUES ('2542', 'zombie_soldier_bow', 'Zombie Bow', '2', '0', '0', '77', '', 'AGGR', '0', 'UNDEAD', '', '0', 'zombie_soldier_bow', '0', '80', '65', '55', '25', '100', '200', '60000', '5', '10', '15000', '25000', '120000', '88', '100', '100', '100', '2000', '100', '0', '0', '0', '0', '4', '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0', '0', '0', '0', '25', '0', '0', '0', '0'); INSERT INTO `mob_proto` VALUES ('2543', 'zombie_soldier_spear', 'Zombie Speer', '2', '0', '0', '74', '', 'AGGR', '0', 'UNDEAD', '', '0', 'zombie_soldier_spear', '0', '80', '75', '55', '25', '100', '200', '60000', '5', '10', '15000', '25000', '120000', '88', '100', '100', '100', '2000', '100', '0', '0', '0', '0', '4', '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0', '0', '0', '0', '25', '0', '0', '0', '0'); INSERT INTO `mob_proto` VALUES ('2544', 'zombie_magician', 'Zombie Magico', '2', '0', '0', '78', '', 'AGGR', '0', 'UNDEAD', '', '0', 'zombie_magician', '0', '80', '75', '55', '25', '100', '200', '60000', '5', '10', '15000', '25000', '120000', '88', '100', '100', '100', '2000', '100', '0', '0', '0', '0', '4', '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0', '0', '0', '0', '25', '0', '0', '0', '0'); INSERT INTO `mob_proto` VALUES ('2545', 'zombie_bigboss', 'Il Boss Zombie', '4', '0', '0', '87', '', 'AGGR', '0', 'UNDEAD', '', '0', 'zombie_bigboss', '0', '80', '75', '55', '25', '100', '200', '60000', '5', '10', '15000', '25000', '120000', '88', '100', '100', '100', '2000', '100', '0', '0', '0', '0', '4', '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0', '0', '0', '0', '25', '0', '0', '0', '0'); INSERT INTO `mob_proto` VALUES ('2546', 'zombie_ghost', 'Fantasma Zombie', '3', '0', '0', '86', '', 'AGGR', '0', 'UNDEAD', '', '0', 'zombie_ghost', '0', '80', '75', '55', '25', '100', '200', '60000', '5', '10', '15000', '25000', '120000', '88', '100', '100', '100', '2000', '100', '0', '0', '0', '0', '4', '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0', '0', '0', '0', '25', '0', '0', '0', '0'); INSERT INTO `mob_proto` VALUES ('2547', 'zombie_general', 'Generale Zombie', '5', '0', '0', '87', '', 'AGGR', '0', 'UNDEAD', '', '0', 'zombie_general', '0', '80', '75', '55', '25', '100', '200', '60000', '5', '10', '15000', '25000', '120000', '88', '100', '100', '100', '2000', '100', '0', '0', '0', '0', '4', '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0', '0', '0', '0', '25', '0', '0', '0', '0'); INSERT INTO `mob_proto` VALUES ('2594', 'zombie_king', 'Re Zombie', '5', '0', '0', '97', '', 'AGGR', '0', 'UNDEAD', 'STUN,SLOW,FALL,CURSE,POISON,TERROR', '0', 'zombie_king', '0', '120', '85', '55', '25', '130', '260', '300000', '5', '10', '100000', '150000', '500000', '88', '100', '100', '100', '2000', '100', '0', '0', '0', '0', '4', '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0', '0', '0', '0', '25', '0', '0', '0', '0'); INSERT INTO `mob_proto` VALUES ('2595', 'zombie_king', 'Re Zombie 1', '5', '0', '0', '97', '', 'AGGR', '0', 'UNDEAD', 'STUN,SLOW,FALL,CURSE,POISON,TERROR', '0', 'zombie_king', '0', '120', '85', '55', '25', '130', '260', '300000', '5', '10', '100000', '150000', '500000', '88', '100', '100', '100', '2000', '100', '0', '0', '0', '0', '4', '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0', '0', '0', '0', '25', '0', '0', '0', '0'); INSERT INTO `mob_proto` VALUES ('2596', 'zombie_king', 'Re Zombie 2', '5', '0', '0', '97', '', 'AGGR', '0', 'UNDEAD', 'STUN,SLOW,FALL,CURSE,POISON,TERROR', '0', 'zombie_king', '0', '120', '85', '55', '25', '130', '260', '300000', '5', '10', '100000', '150000', '500000', '88', '100', '100', '100', '2000', '100', '0', '0', '0', '0', '4', '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0', '0', '0', '0', '25', '0', '0', '0', '0'); INSERT INTO `mob_proto` VALUES ('2597', 'zombie_god', 'Zombie della Morte', '5', '0', '0', '98', '', 'AGGR', '0', 'UNDEAD', 'STUN,SLOW,FALL,CURSE,POISON,TERROR', '0', 'zombie_god', '0', '130', '90', '55', '25', '150', '300', '450000', '5', '10', '100000', '150000', '500000', '88', '100', '100', '100', '2000', '100', '0', '0', '0', '0', '4', '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5', '0', '0', '0', '0', '0', '0', '0', '0', '25', '0', '0', '0', '0');
Pero cuando los pongo me dice esto:
[SQL] INSERT INTO `mob_proto` VALUES ('2504', 'zombie_diseased_sword', 'Zombie Guerriero', '2', '0', '0', '77', '', 'AGGR', '0', 'UNDEAD', '', '0', 'zombie_diseased_sword', '0', '60', '50', '55', '25', '100', '150', '100000', '5', '10', '15000', '25000', '120000', '300', '100', '100', '100', '2000', '100', '0', '0', '0', '0', '4', '3', '10', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '25', '0', '0', '0', '0'); [Err] 1136 - Column count doesn't match value count at row 1
Y solo dentro del server me puedo poner ej: /poly 2597 y me transformo , pero uando los imvoco me dice que no existen¬¬
Ayudaaa plizzz , se los agradecere :happy:Desde ya grax de antemano , 1 saludo :wiii:
-
Puede ser que estes metiendo una query mas antigua que el server o viceversa, comprueba que las querys y el server son del mismo año, o sino crea tu una query que se ajuste al server.
-
Comprueba que van con los files, que están bien metidas, que pones bien el comando y demás detalles.
-
Sip tendras que solucionarlo con la guia que hay por aqui referente a files 2010 ,el fallo es que los files 2010 usan 4 columnas mas que los files 2008 y por eso no te funciona ,es sencillo el cambiar el mobproto temporalmente a files 2010 y viceversa pero ya hay una guia en UJ solo has de entrar aqui: [http://foro.universojuegos.es/viewtopic.php?f=19&t=21824][0]">viewtopic.php?f=19&t=21824
[0]: <a href=
-
Puede ser que la query no este adaptado a lo tipos de files k usa,o q ubo un error o lago dale muxos click en run como yo ^^