[SUGGESTION] MySQL Support? #1227


  • Enhancement
Open
  • 綠豆啦 created this issue Aug 17, 2017

    Plugin Version

    ChestShop v3.8.13-SNAPSHOT (build #28)

     

    i think can have MySQL Support :D

     

  • Phoenix616 posted a comment Aug 17, 2017

    What exactly would you want the plugin to store in a MySQL database? The users/items?

  • Forge_User_96860217 posted a comment Dec 5, 2017

    MYSQL support would be awesome! The database should store the price, the item name, the worldguard region a chest is located in, the stock/Items left in the chest and who bought/selled when how much.

    Why one should want this information and why in a MYSQL database? Well there is alays one main problem with the shopping malls based on ChestShops the player will complain about again and again: The clarity and joy of shopping experience. Player want to know where to get an item and for what price, they want to access this information quickly, but unfortunalty often they run looking forever and turn frustrated. Over the years I tried everything restructured the shoppingmail, warppoint at every shop, serveral options to advertise shops, deleted inactive shops etc., it didnt solved the problem.

    The solution for the problem is to connect the shop information to a website. I think about a item search that list all shops that sell/buy a item. Shop owner should be able to see how sucessfull his or her shop is, what to stock up and where marcetprice lies.

    Integrating that information into a website is not the problem it has been done with other plugin information for other porpuses. But one need the MYSQL database for easy query and good performance to accomplish this.

    Unfortunatly there is no sign-based plugin out there that offer this feature. Of course some authors like SnowGear promised but never accomplished it. There are some GUI-based shop plugins that offer MYSQL Support with all needed information, but GUIs habe other problems.

    So what I am trying to say? A MYSQL database storing the information mentioned above it not just a nice feature but a feature that would make all the difference - it offer a fantastic shopping experience for the player and a unique selling point for your plugin.

  • Phoenix616 posted a comment Dec 6, 2017

    @TheoRetisch1: These features should be implemented in a separate plugin (e.g. like ChestShopLogger did it) that listens on ChestShops events instead of in the main plugin as most people probably wont need that. (And it would bloat ChestShop as one of the goals is to not require a database for shops)

     

    Using MySQL for special item and player data storage is on my ToDo list though.


    Edited Dec 6, 2017
  • Phoenix616 added a tag Enhancement Dec 13, 2017

To post a comment, please login or register a new account.