Tienda con material de mejora

Topic created · 4 Mensajes · 953 Visitas
  • Bueno como lo prometido,

    Como me fije por aquí y por otros foros, varios pedían tienda con cosas de mejoras, pues aquí se las traigo...
    Y es tan fácil de insertar como contar hasta 10
    Abrimos el navicat vamos a la DB player y vamos a query e insertamos estas querys...

    INSERT INTO `shop_item` VALUES ('13', '30005', '2');
    INSERT INTO `shop_item` VALUES ('13', '30006', '2');
    INSERT INTO `shop_item` VALUES ('13', '30007', '2');
    INSERT INTO `shop_item` VALUES ('13', '30008', '2');
    INSERT INTO `shop_item` VALUES ('13', '30009', '2');
    INSERT INTO `shop_item` VALUES ('13', '30010', '2');
    INSERT INTO `shop_item` VALUES ('13', '30011', '2');
    INSERT INTO `shop_item` VALUES ('13', '30014', '2');
    INSERT INTO `shop_item` VALUES ('13', '30015', '2');
    INSERT INTO `shop_item` VALUES ('13', '30016', '2');
    INSERT INTO `shop_item` VALUES ('13', '30017', '2');
    INSERT INTO `shop_item` VALUES ('13', '30018', '2');
    INSERT INTO `shop_item` VALUES ('13', '30019', '2');
    INSERT INTO `shop_item` VALUES ('13', '30020', '2');
    INSERT INTO `shop_item` VALUES ('13', '30021', '2');
    INSERT INTO `shop_item` VALUES ('13', '30022', '2');
    INSERT INTO `shop_item` VALUES ('13', '30023', '2');
    INSERT INTO `shop_item` VALUES ('13', '30024', '2');
    INSERT INTO `shop_item` VALUES ('13', '30025', '2');
    INSERT INTO `shop_item` VALUES ('13', '30026', '2');
    INSERT INTO `shop_item` VALUES ('13', '30028', '2');
    INSERT INTO `shop_item` VALUES ('13', '30030', '2');
    INSERT INTO `shop_item` VALUES ('13', '30031', '2');
    INSERT INTO `shop_item` VALUES ('13', '30032', '2');
    INSERT INTO `shop_item` VALUES ('13', '30033', '2');
    INSERT INTO `shop_item` VALUES ('13', '30034', '2');
    INSERT INTO `shop_item` VALUES ('13', '30035', '2');
    INSERT INTO `shop_item` VALUES ('13', '30036', '2');
    INSERT INTO `shop_item` VALUES ('13', '30037', '2');
    INSERT INTO `shop_item` VALUES ('13', '30039', '2');
    INSERT INTO `shop_item` VALUES ('13', '30040', '2');
    INSERT INTO `shop_item` VALUES ('13', '30041', '2');
    INSERT INTO `shop_item` VALUES ('13', '30042', '2');
    INSERT INTO `shop_item` VALUES ('13', '30045', '2');
    INSERT INTO `shop_item` VALUES ('13', '30046', '2');
    INSERT INTO `shop_item` VALUES ('13', '30047', '2');
    INSERT INTO `shop_item` VALUES ('13', '30048', '2');
    INSERT INTO `shop_item` VALUES ('13', '30049', '2');
    INSERT INTO `shop_item` VALUES ('13', '30050', '2');
    INSERT INTO `shop_item` VALUES ('13', '30051', '2');
    INSERT INTO `shop_item` VALUES ('14', '30052', '2');
    INSERT INTO `shop_item` VALUES ('14', '30053', '2');
    INSERT INTO `shop_item` VALUES ('14', '30054', '2');
    INSERT INTO `shop_item` VALUES ('14', '30055', '2');
    INSERT INTO `shop_item` VALUES ('14', '30056', '2');
    INSERT INTO `shop_item` VALUES ('14', '30057', '2');
    INSERT INTO `shop_item` VALUES ('14', '30058', '2');
    INSERT INTO `shop_item` VALUES ('14', '30059', '2');
    INSERT INTO `shop_item` VALUES ('14', '30060', '2');
    INSERT INTO `shop_item` VALUES ('14', '30061', '2');
    INSERT INTO `shop_item` VALUES ('14', '30063', '2');
    INSERT INTO `shop_item` VALUES ('14', '30064', '2');
    INSERT INTO `shop_item` VALUES ('14', '30065', '2');
    INSERT INTO `shop_item` VALUES ('14', '30066', '2');
    INSERT INTO `shop_item` VALUES ('14', '30067', '2');
    INSERT INTO `shop_item` VALUES ('14', '30068', '2');
    INSERT INTO `shop_item` VALUES ('14', '30069', '2');
    INSERT INTO `shop_item` VALUES ('14', '30070', '2');
    INSERT INTO `shop_item` VALUES ('14', '30071', '2');
    INSERT INTO `shop_item` VALUES ('14', '30072', '2');
    INSERT INTO `shop_item` VALUES ('14', '30073', '2');
    INSERT INTO `shop_item` VALUES ('14', '30074', '2');
    INSERT INTO `shop_item` VALUES ('14', '30075', '2');
    INSERT INTO `shop_item` VALUES ('14', '30076', '2');
    INSERT INTO `shop_item` VALUES ('14', '30077', '2');
    INSERT INTO `shop_item` VALUES ('14', '30078', '2');
    INSERT INTO `shop_item` VALUES ('14', '30079', '2');
    INSERT INTO `shop_item` VALUES ('14', '30080', '2');
    INSERT INTO `shop_item` VALUES ('14', '30081', '2');
    INSERT INTO `shop_item` VALUES ('14', '30082', '2');
    INSERT INTO `shop_item` VALUES ('14', '30083', '2');
    INSERT INTO `shop_item` VALUES ('14', '30084', '2');
    INSERT INTO `shop_item` VALUES ('14', '30085', '2');
    INSERT INTO `shop_item` VALUES ('14', '30086', '2');
    INSERT INTO `shop_item` VALUES ('14', '30087', '2');
    INSERT INTO `shop_item` VALUES ('14', '30088', '2');
    INSERT INTO `shop_item` VALUES ('14', '30089', '2');
    INSERT INTO `shop_item` VALUES ('14', '30090', '2');
    INSERT INTO `shop_item` VALUES ('14', '30091', '2');
    INSERT INTO `shop_item` VALUES ('14', '30092', '2');
    INSERT INTO `shop` VALUES ('13', 'MATERIALES1', '20086');
    INSERT INTO `shop` VALUES ('14', 'MATEARIALES 2', '20090');
    

    Pues las insertan, rebootan el server y listo ya las tienen 😄

    Pero se preguntaran
    ¿Cual npc trae los items?
    Pues son las NPC 20090 y 20086

    Cualquier problema lo arreglo con gusto por el post o por MP

    Saludos y espero que les alla servido 😄

    Fuentes: [http://zonagamerz.net/index.php?/topic/598-tienda-con-material-de-mejora/][0]">[http://zonagamerz.net/index.php?/topic/][1] ... de-mejora/

    [0]: <a href=
    [1]: http://zonagamerz.net/index.php?/topic/

  • **Bueno, nada mal, Pero creo que da errores en files 2011 al navicat, creo. **

  • Cuando tenga tiempo lo pruebo y te digo, y si eso te dejare las gracias 😛

  • @fuuton97 said:

    **Bueno, nada mal, Pero creo que da errores en files 2011 al navicat, creo. **

    Funcionan perfectamente, son sacados de files 2011, ademas creo que la tabla shop y shop_item de files 2007 a 2011 no cambian hum!