[ShopDB] Updates / Changelog

Discussion in 'General Discussion' started by Kozz, Dec 20, 2019.

  1. Kozz

    Developer Builder ⛰️ Ex-President ⚒️⚒️ Gameplay Architect

    Joined:
    Jan 11, 2017
    Messages:
    272
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    Update on status as of 05/08/2020

    COMPLETED:
    • Dropdown row on shop table.
    • Shop analytics
      • View all the items a shop sells/buys, and see how they compare to the median prices!
    • Form to submit a new shop request
    • Helpers panel - created tabs for recent shop updates, shop modifications, and shop requests!
    • Shop requests section - for moderators to see recent "add a shop" requests, and to mark them as completed!

    Dropdown on shop table + shop analytics
    [​IMG]

    Form to submit new shop request
    [​IMG]

    Helpers panel tabs + shop requests section

    [​IMG]

    This is coming along very nicely, only a few more things to do now!
    This should be ready to go as soon as next week! (or even this weekend, depending on how much time I get).
     
  2. Kozz

    Developer Builder ⛰️ Ex-President ⚒️⚒️ Gameplay Architect

    Joined:
    Jan 11, 2017
    Messages:
    272
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    ECCShopDB v2 is going live.

    Expect down-times up to a few hours while I get things sorted out.
     
  3. Kozz

    Developer Builder ⛰️ Ex-President ⚒️⚒️ Gameplay Architect

    Joined:
    Jan 11, 2017
    Messages:
    272
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
  4. Kozz

    Developer Builder ⛰️ Ex-President ⚒️⚒️ Gameplay Architect

    Joined:
    Jan 11, 2017
    Messages:
    272
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    Made a few minor changes:
    • Fixed bug in helpers section when marking a 'add shop request' as complete.
    • Removed dead 'about' link from the footer.
    • Fixed bug when after registering the page would crash.
    • Uploaded the mod onto the website.
    Will be deploying these changes now.
     
  5. Videowiz92

    Mythic ⚔️ I ⚔️ ECC Benefactor President ⛰️⛰️ Ex-EcoLegend ⚜️⚜️⚜️⚜️ Prestige ⭐⭐ X ⭐⭐ Gameplay Architect Premium Upgrade

    Joined:
    Jan 30, 2012
    Messages:
    3,021
    Trophy Points:
    77,660
    Gender:
    Male
    Ratings:
    +1,183
    I'd like to make a suggestion to change submission reports listed under the Contact section. Currently with there only being one report type called "Submit new shop request" it gives the perception that everything else is automated once a user adds a shop. In reality, the mod is user regulated thus you have ShopDB Helpers/Moderators to help keep shops up to date.

    Keep "Submit new shop request" but rename it "Report: Add a shop." Then create other reports for updating, modifying a shop's boundaries, and requesting a shop be removed.

    For "Report: Update a shop" it will mention that it's for shops that have new signs and just need to be updated through using the stick with the mod.

    For "Report: Modify a shop" it will be for if shop boundaries that need to be modified, and the person making the report can submit the modified coordinates.

    For "Report: Request a shop removal" it can be for multiple reasons; for example, a user could simply request their shop be removed, or if a user is inactive somebody else could request the shop be removed or the region be modified to exclude that inactive user while keeping other ChestShops in range of the shop boundary.

    By adding multiple report types you can add a new column under the Shop Requests on the Helpers Panel page that tells Helpers/Moderators what type of report was made. In my opinion, it would help to differentiate the work needed and also help regular users communicate with the Helpers/Moderators to keep their shops up to date.
     
    • Like Like x 1
    • Winner Winner x 1
    • List
    #125 Videowiz92, May 12, 2020
    Last edited: May 12, 2020
  6. Kozz

    Developer Builder ⛰️ Ex-President ⚒️⚒️ Gameplay Architect

    Joined:
    Jan 11, 2017
    Messages:
    272
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    ECCShopDB v2.0.0a released.
    • Fixed a bug - you can now search for items which have '#' or ':' in the item name (e.g, Diamond Sword#ZY). Before this would result in an endless loading screen.
    • Updated current list of moderators & helpers on the homepage.


    Good idea. I'll work on it.
     
  7. kimi2QT

    kimi2QT Ultra kawaii weeb
    Builder ⛰️ Ex-Tycoon ⚜️⚜️⚜️ Premium Upgrade

    Joined:
    Aug 30, 2014
    Messages:
    157
    Trophy Points:
    49,610
    Ratings:
    +72
    Hi, I want to suggest a section for the shop entries that allows you to copy coords ( without x y z, for teleport feature) either click to copy to clipboard or something to parse out the letters.

    Not sure if this has been suggested just thought I'd put that out there.
     
  8. Kozz

    Developer Builder ⛰️ Ex-President ⚒️⚒️ Gameplay Architect

    Joined:
    Jan 11, 2017
    Messages:
    272
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    ECCShopDB v2.1.0 is being released.
    • You can press 'enter' to select an item now - no more having to click on an item in the drop-down menu.
    • Search results are now shown on the same page - no more having to go back/forth pages to search for multiple items.
    • Click to copy shops - '/warp shopname'
    • Click to copy coordinates - '/tpc 100 100'
    • Added Contact: Update Shop
    • Added Contact: Remove Shop
    • Updated helpers panel to include an indicator of if requests are for adding/updating/removing shops.

    Refactored Search Page
    Same page results + click to copy shop warp / coordinates.



    Contact: Update Shop, Contact: Remove Shop
    [​IMG]

    Helpers Panel: Indicator of shop request type.
    [​IMG]

    All of these were highly requested changes. I am always open to suggestions!
    If you have an idea that may make ECCShopDB better, or easier to use, please do let me know!



    Done.


    Done.
     
  9. Videowiz92

    Mythic ⚔️ I ⚔️ ECC Benefactor President ⛰️⛰️ Ex-EcoLegend ⚜️⚜️⚜️⚜️ Prestige ⭐⭐ X ⭐⭐ Gameplay Architect Premium Upgrade

    Joined:
    Jan 30, 2012
    Messages:
    3,021
    Trophy Points:
    77,660
    Gender:
    Male
    Ratings:
    +1,183
    One more suggestion; add a search parameter that uses an asterisk to include the base item as well as all custom code items. For example, searching for "tripwire hook*" with the asterisk (*) included will search for all tripwire hooks whether there is a custom code (#) or not.

    This could also be a checkbox option under the search to include base items, custom items, or both.

    [​IMG]
     
    #129 Videowiz92, May 25, 2020
    Last edited: May 25, 2020
  10. Kozz

    Developer Builder ⛰️ Ex-President ⚒️⚒️ Gameplay Architect

    Joined:
    Jan 11, 2017
    Messages:
    272
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
  11. xboyfernz

    xboyfernz Builder
    Builder ⛰️ Ex-EcoLeader ⚜️⚜️⚜️ Ex-President ⚒️⚒️ Prestige ⭐ II ⭐ Premium Upgrade

    Joined:
    May 23, 2015
    Messages:
    1,043
    Trophy Points:
    41,660
    Gender:
    Male
    EcoDollars:
    $1
    Ratings:
    +1,263
    Is there any way that the shopdb could show you items people are buying and selling the most or the least as a whole? Not just for your own shop, but rather within the whole database what goods are being bought and sold the most.
     
  12. Kozz

    Developer Builder ⛰️ Ex-President ⚒️⚒️ Gameplay Architect

    Joined:
    Jan 11, 2017
    Messages:
    272
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    ShopDB is being redesigned, I'm making big improvements!

    Improved search
    • Press 'enter' to search
    • No need to select from the menu
    • No need to press the 'search' button
    • Change servers / trade type easily
    [​IMG]



    Click to copy warp / bot teleport command


    [​IMG]


    Wildcard search

    e.g, 'diamond*' will return all items that start with 'diamond'

    [​IMG]


    View shop information

    [​IMG]



    View player information

    [​IMG]


    Easily navigate to view information on shops/players

    [​IMG]


    An improved statistics page

    [​IMG]


    Navigate / Search by URL
    [​IMG]



    Various bug fixes
    • Removing invalid trade signs.
    • Case-insensitive items.

    Player filter

    • If a player is offline for >1 month (time TBD) their items will automatically be removed and they will be blacklisted (this will not affect other players in that same shop). As soon as they log in again, this blacklist will be removed as if nothing happened. This will all be handled automagically.

    This is still a work in progress, just dropping in to let you know I'm still here!
    ETA, 1-2 weeks. Still much to do.
    As always, I'm open to suggestions. Now's a good time to ask :)
     
    • Winner Winner x 5
    • Like Like x 1
    • Friendly Friendly x 1
    • List
    #132 Kozz, Aug 2, 2020
    Last edited: Aug 2, 2020
  13. SupremelyEquipd

    SupremelyEquipd Builder
    Builder ⛰️ Ex-EcoLegend ⚜️⚜️⚜️⚜️ Prestige ⭐ I ⭐

    Joined:
    Jul 5, 2020
    Messages:
    78
    Trophy Points:
    31,695
    Gender:
    Male
    Ratings:
    +7
  14. iSneaky

    iSneaky This is a local server for local people
    Resident ⛰️ Ex-EcoLegend ⚜️⚜️⚜️⚜️ Prestige ⭐ VI ⭐ Premium Upgrade

    Joined:
    Jul 14, 2012
    Messages:
    3,499
    Trophy Points:
    77,660
    Gender:
    Male
    Ratings:
    +1,256
    POG!!!!
     
  15. ClarinetPhoenix

    ClarinetPhoenix She does what she wants.
    Owner Events Manager ECC Sponsor Mayor ⛰️⛰️ Ex-EcoLegend ⚜️⚜️⚜️⚜️ Prestige ⭐ IX ⭐ Gameplay Architect Premium Upgrade Wiki Leader

    Joined:
    Jun 23, 2014
    Messages:
    6,982
    Trophy Points:
    96,870
    Gender:
    Female
    Ratings:
    +5,380
    Loving the per player search.
    Awesome looking update once again Kozz :)
     
    #135 ClarinetPhoenix, Aug 2, 2020
    Last edited: Aug 2, 2020
  16. FuriuosGeorge

    FuriuosGeorge I got answers and am no longer curiuos
    ECC Sponsor President ⛰️⛰️ Ex-President ⚒️⚒️ Prestige ⭐ III ⭐ Premium Upgrade

    Joined:
    Jun 27, 2016
    Messages:
    796
    Trophy Points:
    43,010
    Gender:
    Male
    Ratings:
    +355
    This is getting more fantastic! Saw a sugg to think about. When you do shop updates poll the chest state and note if it was out of stock maybe?
     
  17. icbomber38

    icbomber38 I can't complain but sometimes I still do
    ECC Sponsor Builder ⛰️ Ex-EcoLegend ⚜️⚜️⚜️⚜️ Prestige ⭐ III ⭐ Premium Upgrade

    Joined:
    May 25, 2015
    Messages:
    218
    Trophy Points:
    53,910
    Gender:
    Male
    Ratings:
    +107
    When is update coming? I've moved my shop but can't seem to get it listed any more?

    Sweet update Kozz!
     
  18. Kozz

    Developer Builder ⛰️ Ex-President ⚒️⚒️ Gameplay Architect

    Joined:
    Jan 11, 2017
    Messages:
    272
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    I wish I could do this but I haven't found a way with client-side limitations.
    Chest information is stored by the server, and is not available on the client side until the chest is opened.
    Opening every chest would take ages to update shops, so not feasible :(

    I am working on having a list of inactive players that is updated automatically, and if a player has been offline for a certain period of time then their items would be automatically removed.

    The update is now! Check it out -
    https://shopdb.ecocitycraft.com/

    Too many updates too mention, really, just go check it out for yourself!
    Wildcard search is now available, just add a * to the end of your search - e.g, 'player head*'
    Statistics page has some new features, like being able to see all shop additions and shop updates!
    ...and a bunch of other things! Glad to have this done!
     
  19. icbomber38

    icbomber38 I can't complain but sometimes I still do
    ECC Sponsor Builder ⛰️ Ex-EcoLegend ⚜️⚜️⚜️⚜️ Prestige ⭐ III ⭐ Premium Upgrade

    Joined:
    May 25, 2015
    Messages:
    218
    Trophy Points:
    53,910
    Gender:
    Male
    Ratings:
    +107
    Giddy up - thanks Kozz! Looks great so far!
     
  20. ClarinetPhoenix

    ClarinetPhoenix She does what she wants.
    Owner Events Manager ECC Sponsor Mayor ⛰️⛰️ Ex-EcoLegend ⚜️⚜️⚜️⚜️ Prestige ⭐ IX ⭐ Gameplay Architect Premium Upgrade Wiki Leader

    Joined:
    Jun 23, 2014
    Messages:
    6,982
    Trophy Points:
    96,870
    Gender:
    Female
    Ratings:
    +5,380
    I've just had a chance to poke around and take a look at your updates.
    It looks absolutely fabulous, its pretty, its sleek, smooth and definitely interesting to go through, especially the statistics. I love that!

    Nice work as always. :)