AYUDA CON NPC ITEMS DE MEJORAS!!
-
Buenas ... Sera que alguien me pasa algún NPC q traiga todos los items de mejoras.. porfaa lo necesito para mi server
Espero rspstas :charm:
-
mmmm..
Eso lo tienes q poner tu ..
En la tabla Shop_item de navicat...
Creo q no hay otra manera :que?: -
mirate x guias :charm:
-
para que files la queres ? i te paso las queri
-
Hay NPCS que dan los items, pero no logro encontrarlo :S
-
mm perame yo tengo unos files 2007 tienes eso en tiendas en el segundo vendedor de armas i armaduras los monto en mi local i ago dump sql de la tabla shop_item
-
INSERT INTO
shop_itemVALUES ('', '27987', '1');
INSERT INTOshop_itemVALUES ('', '30081', '1');
INSERT INTOshop_itemVALUES ('', '30082', '1');
INSERT INTOshop_itemVALUES ('', '30083', '1');
INSERT INTOshop_itemVALUES ('', '30084', '1');
INSERT INTOshop_itemVALUES ('', '30080', '1');
INSERT INTOshop_itemVALUES ('', '30085', '1');
INSERT INTOshop_itemVALUES ('', '30086', '1');
INSERT INTOshop_itemVALUES ('', '30087', '1');
INSERT INTOshop_itemVALUES ('', '30088', '1');
INSERT INTOshop_itemVALUES ('', '30090', '1');
INSERT INTOshop_itemVALUES ('', '30091', '1');
INSERT INTOshop_itemVALUES ('', '30079', '1');
INSERT INTOshop_itemVALUES ('', '30078', '1');
INSERT INTOshop_itemVALUES ('', '30077', '1');
INSERT INTOshop_itemVALUES ('', '30076', '1');
INSERT INTOshop_itemVALUES ('', '30075', '1');
INSERT INTOshop_itemVALUES ('', '30074', '1');
INSERT INTOshop_itemVALUES ('', '30073', '1');
INSERT INTOshop_itemVALUES ('', '30072', '1');
INSERT INTOshop_itemVALUES ('', '30071', '1');
INSERT INTOshop_itemVALUES ('', '30070', '1');
INSERT INTOshop_itemVALUES ('', '30030', '1');
INSERT INTOshop_itemVALUES ('', '30031', '1');
INSERT INTOshop_itemVALUES ('', '30032', '1');
INSERT INTOshop_itemVALUES ('', '30033', '1');
INSERT INTOshop_itemVALUES ('', '30034', '1');
INSERT INTOshop_itemVALUES ('', '30035', '1');
INSERT INTOshop_itemVALUES ('', '30036', '1');
INSERT INTOshop_itemVALUES ('', '30037', '1');
INSERT INTOshop_itemVALUES ('', '30038', '1');
INSERT INTOshop_itemVALUES ('', '30039', '1');
INSERT INTOshop_itemVALUES ('', '30040', '1');
INSERT INTOshop_itemVALUES ('', '30041', '1');
INSERT INTOshop_itemVALUES ('', '30042', '1');
INSERT INTOshop_itemVALUES ('', '30043', '1');
INSERT INTOshop_itemVALUES ('', '30044', '1');
INSERT INTOshop_itemVALUES ('', '30045', '1');
INSERT INTOshop_itemVALUES ('', '30046', '1');
INSERT INTOshop_itemVALUES ('', '30047', '1');
INSERT INTOshop_itemVALUES ('', '30048', '1');
INSERT INTOshop_itemVALUES ('', '30049', '1');
INSERT INTOshop_itemVALUES ('', '30050', '1');
INSERT INTOshop_itemVALUES ('', '30051', '1');
INSERT INTOshop_itemVALUES ('', '30052', '1');
INSERT INTOshop_itemVALUES ('', '30053', '1');
INSERT INTOshop_itemVALUES ('', '30054', '1');
INSERT INTOshop_itemVALUES ('', '30055', '1');
INSERT INTOshop_itemVALUES ('', '30056', '1');
INSERT INTOshop_itemVALUES ('', '30057', '1');
INSERT INTOshop_itemVALUES ('', '30058', '1');
INSERT INTOshop_itemVALUES ('', '30059', '1');
INSERT INTOshop_itemVALUES ('', '30060', '1');
INSERT INTOshop_itemVALUES ('', '30061', '1');dentro de las primeras dos comillas colocas el id del npc que queres esten esos item saludos espero te sirva alfina lo ice a mano xddd
-
@mt2arcangel said:
INSERT INTO `shop_item` VALUES ('', '27987', '1'); INSERT INTO `shop_item` VALUES ('', '30081', '1'); INSERT INTO `shop_item` VALUES ('', '30082', '1'); INSERT INTO `shop_item` VALUES ('', '30083', '1'); INSERT INTO `shop_item` VALUES ('', '30084', '1'); INSERT INTO `shop_item` VALUES ('', '30080', '1'); INSERT INTO `shop_item` VALUES ('', '30085', '1'); INSERT INTO `shop_item` VALUES ('', '30086', '1'); INSERT INTO `shop_item` VALUES ('', '30087', '1'); INSERT INTO `shop_item` VALUES ('', '30088', '1'); INSERT INTO `shop_item` VALUES ('', '30090', '1'); INSERT INTO `shop_item` VALUES ('', '30091', '1'); INSERT INTO `shop_item` VALUES ('', '30079', '1'); INSERT INTO `shop_item` VALUES ('', '30078', '1'); INSERT INTO `shop_item` VALUES ('', '30077', '1'); INSERT INTO `shop_item` VALUES ('', '30076', '1'); INSERT INTO `shop_item` VALUES ('', '30075', '1'); INSERT INTO `shop_item` VALUES ('', '30074', '1'); INSERT INTO `shop_item` VALUES ('', '30073', '1'); INSERT INTO `shop_item` VALUES ('', '30072', '1'); INSERT INTO `shop_item` VALUES ('', '30071', '1'); INSERT INTO `shop_item` VALUES ('', '30070', '1'); INSERT INTO `shop_item` VALUES ('', '30030', '1'); INSERT INTO `shop_item` VALUES ('', '30031', '1'); INSERT INTO `shop_item` VALUES ('', '30032', '1'); INSERT INTO `shop_item` VALUES ('', '30033', '1'); INSERT INTO `shop_item` VALUES ('', '30034', '1'); INSERT INTO `shop_item` VALUES ('', '30035', '1'); INSERT INTO `shop_item` VALUES ('', '30036', '1'); INSERT INTO `shop_item` VALUES ('', '30037', '1'); INSERT INTO `shop_item` VALUES ('', '30038', '1'); INSERT INTO `shop_item` VALUES ('', '30039', '1'); INSERT INTO `shop_item` VALUES ('', '30040', '1'); INSERT INTO `shop_item` VALUES ('', '30041', '1'); INSERT INTO `shop_item` VALUES ('', '30042', '1'); INSERT INTO `shop_item` VALUES ('', '30043', '1'); INSERT INTO `shop_item` VALUES ('', '30044', '1'); INSERT INTO `shop_item` VALUES ('', '30045', '1'); INSERT INTO `shop_item` VALUES ('', '30046', '1'); INSERT INTO `shop_item` VALUES ('', '30047', '1'); INSERT INTO `shop_item` VALUES ('', '30048', '1'); INSERT INTO `shop_item` VALUES ('', '30049', '1'); INSERT INTO `shop_item` VALUES ('', '30050', '1'); INSERT INTO `shop_item` VALUES ('', '30051', '1'); INSERT INTO `shop_item` VALUES ('', '30052', '1'); INSERT INTO `shop_item` VALUES ('', '30053', '1'); INSERT INTO `shop_item` VALUES ('', '30054', '1'); INSERT INTO `shop_item` VALUES ('', '30055', '1'); INSERT INTO `shop_item` VALUES ('', '30056', '1'); INSERT INTO `shop_item` VALUES ('', '30057', '1'); INSERT INTO `shop_item` VALUES ('', '30058', '1'); INSERT INTO `shop_item` VALUES ('', '30059', '1'); INSERT INTO `shop_item` VALUES ('', '30060', '1'); INSERT INTO `shop_item` VALUES ('', '30061', '1');dentro de las primeras dos comillas colocas el id del npc que queres esten esos item saludos espero te sirva alfina lo ice a mano xddd
Oe amigo yo uso los files 2010 de arthur.. pero hago una pequeña prueba cn esta query.. aver si funka hay te dejo tu thanks :charm:
