[ShopDB] Updates / Changelog

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

  1. Kozz

    Kozz Builder
    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.
     
  2. Kozz

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

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

    Kozz Builder
    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.
     
  4. Videowiz92

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

    Joined:
    Jan 30, 2012
    Messages:
    3,018
    Trophy Points:
    81,660
    Gender:
    Male
    Ratings:
    +1,203
    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
    #124 Videowiz92, May 12, 2020
    Last edited: May 12, 2020
  5. Kozz

    Kozz Builder
    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.
     
  6. kimi2QT

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

    Joined:
    Aug 30, 2014
    Messages:
    176
    Trophy Points:
    59,610
    Ratings:
    +80
    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.
     
  7. Kozz

    Kozz Builder
    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.
     
  8. Videowiz92

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

    Joined:
    Jan 30, 2012
    Messages:
    3,018
    Trophy Points:
    81,660
    Gender:
    Male
    Ratings:
    +1,203
    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]
     
    #128 Videowiz92, May 25, 2020
    Last edited: May 25, 2020
  9. Kozz

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

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

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

    Joined:
    May 23, 2015
    Messages:
    1,041
    Trophy Points:
    56,660
    Gender:
    Male
    EcoDollars:
    $1
    Ratings:
    +1,262
    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.
     
  11. Kozz

    Kozz Builder
    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
    #131 Kozz, Aug 2, 2020
    Last edited: Aug 2, 2020
  12. SupremelyEquipd

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

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

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

    Joined:
    Jul 14, 2012
    Messages:
    3,487
    Trophy Points:
    81,660
    Gender:
    Male
    Ratings:
    +1,260
    POG!!!!
     
  14. 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:
    7,560
    Trophy Points:
    106,870
    Gender:
    Female
    Ratings:
    +5,633
    Loving the per player search.
    Awesome looking update once again Kozz :)
     
    #134 ClarinetPhoenix, Aug 2, 2020
    Last edited: Aug 2, 2020
  15. FuriuosGeorge

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

    Joined:
    Jun 27, 2016
    Messages:
    842
    Trophy Points:
    52,510
    Gender:
    Male
    Ratings:
    +367
    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?
     
  16. 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:
    217
    Trophy Points:
    68,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!
     
  17. Kozz

    Kozz Builder
    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!
     
  18. 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:
    217
    Trophy Points:
    68,910
    Gender:
    Male
    Ratings:
    +107
    Giddy up - thanks Kozz! Looks great so far!
     
  19. 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:
    7,560
    Trophy Points:
    106,870
    Gender:
    Female
    Ratings:
    +5,633
    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. :)
     
  20. Kozz

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

    Joined:
    Jan 11, 2017
    Messages:
    272
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    Thanks! Appreciate it!

    I've looked extensively into adding a stock counter, but it is just infeasible. Even if I were to have full access to the server-side code, it appears to me as the trade shop plugin does not actually keep track of which chests are in/out of stock, this data is fetched real-time when the sign is clicked. Overall this is technically possible to achieve, but would require overhauling multiple plugins and running custom code on the server... Might as well just create an entirely new tradeshop plugin at that point - just not realistic / I do not have the time to do that. :(.

    That being said, I am currently working on the inactive player list,
    which will add the functionality of effectively 'hiding' items from players
    which have been inactive for 20 or more days.

    This is a significant undertaking as it requires rewriting the vast majority of queries that are used.
    It also requires writing a bot which runs everyday and iterates through the players to determine if they are active or inactive (this part is nearly done already ;))

    I've determined that this is worth it, as a brief analysis revealed that a significant percentage of the player-base is inactive.
    Numerous lookups return a 'player not found', which I believe indicates they have been banned and/or inactive for an extended period of time.

    I hope this will help to greatly reduce the number of shops/players which have items out of stock. :)
     
    #140 Kozz, Aug 22, 2020
    Last edited: Aug 22, 2020