[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:
    273
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    Welcome to EcoCityCraft ShopDB!

    Website:
    https://shopdb.ecocitycraft.com/


    ShopDB is an interactive search tool you can use to find exactly where you can buy or sell items for the best prices. More information such as how it works can be found by reading the home page.

    This thread is for changelogs only, all suggestions, new shop requests, and bug reports should be submitted on this thread.

    This post has been updated as ShopDB has been evolving for over a year now.
     
    • Winner Winner x 13
    • Like Like x 1
    • Friendly Friendly x 1
    • List
    #1 Kozz, Dec 20, 2019
    Last edited: Jan 21, 2021
  2. Nicit6

    Nicit6 N6
    Mayor ⛰️⛰️ Ex-EcoLegend ⚜️⚜️⚜️⚜️ Prestige ⭐ II ⭐ Gameplay Architect Premium Upgrade

    Joined:
    Jul 13, 2013
    Messages:
    9,914
    Trophy Points:
    102,160
    Ratings:
    +8,058
    You link is incorrect fyi, it's just shopdb.ecocitycraft.com (no www.)
     
  3. WeirdBuilder

    WeirdBuilder Former StrangeAdmin
    Mayor ⛰️⛰️ Ex-EcoLegend ⚜️⚜️⚜️⚜️ Prestige ⭐ VII ⭐ Premium Upgrade

    Joined:
    Jan 22, 2012
    Messages:
    1,922
    Trophy Points:
    72,660
    Ratings:
    +1,055
    Maybe this isn't the appropriate time to be suggesting things given that it's in a beta stage, but would it be possible to also provide the IGN of the user's store in the search results? It would help differentiate between multiple store owners in a single region and would be a nice addition overall. (Shouldn't be too difficult given that IGNs are also provided on chest shop signs)!
     
  4. Kozz

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

    Joined:
    Jan 11, 2017
    Messages:
    273
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    Already doing it, just not displaying it.
    I can add that in on a future update :)

    My bad. Thanks for the heads up.
     
    #4 Kozz, Dec 20, 2019
    Last edited: Dec 20, 2019
  5. oxwood2

    oxwood2 Builder
    ECC Sponsor Resident ⛰️ Ex-EcoLegend ⚜️⚜️⚜️⚜️ Prestige ⭐ II ⭐ Premium Upgrade

    Joined:
    Jul 1, 2013
    Messages:
    2,893
    Trophy Points:
    76,160
    Gender:
    Female
    Ratings:
    +1,684
    it would also be cool to see mean/standard deviation of each item across the entire server for pricing etc... and how many standard deviations each shop is from the mean. I don't think this would be too difficult to code
     
  6. Kozz

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

    Joined:
    Jan 11, 2017
    Messages:
    273
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    Thanks for the suggestion.

    With such a small dataset, I would question the accuracy of these analytics.
    It could be a potential update in the future, with a larger dataset (more shops)
     
  7. oxwood2

    oxwood2 Builder
    ECC Sponsor Resident ⛰️ Ex-EcoLegend ⚜️⚜️⚜️⚜️ Prestige ⭐ II ⭐ Premium Upgrade

    Joined:
    Jul 1, 2013
    Messages:
    2,893
    Trophy Points:
    76,160
    Gender:
    Female
    Ratings:
    +1,684
    the accuracy isn't too important as it would just be for judging which shops are overpriced (so to avoid them)
     
  8. 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
    Can it show you how much "diamonds" they actually have in the shop because we might want to buy in bulk and they don't have a large amount of goods in the chest.
     
  9. Fr0zenTiger

    Fr0zenTiger Mayor
    Mayor ⛰️⛰️ Ex-Tycoon ⚜️⚜️⚜️ Premium Upgrade

    Joined:
    Jan 2, 2019
    Messages:
    697
    Trophy Points:
    38,660
    Gender:
    Male
    EcoDollars:
    $3,800,000
    Ratings:
    +684
    Yes a stock indicator would be really nice if that’s possible

    If it isn’t possible it’s still a awesome program
     
    #9 Fr0zenTiger, Dec 21, 2019
    Last edited: Dec 21, 2019
  10. kenny0011

    kenny0011 Resident
    Resident ⛰️ Ex-EcoLegend ⚜️⚜️⚜️⚜️ Prestige ⭐ III ⭐

    Joined:
    Aug 12, 2019
    Messages:
    1,272
    Trophy Points:
    38,660
    Gender:
    Male
    Ratings:
    +816
    This is fecking cool af, some quality work here! I'll admit I spent some time last night looking up the prices of random items!

    Just a few things:
    1) My price on my nstars (station5) apperes flipped, with the buy price shown as the sell price and vice versa. After some testing, I believe that this has something to do with the buy / sell line; when I buy at 800.01, there are no spaces between the colon, whereas when I take off the cent, a space is automatically put in and the correct prices are shown.

    2) Would there be a way to view just the price list for 1 shop?

    Apart from that, it all looks cool, and buzzing to see what happene next!
     
  11. Kozz

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

    Joined:
    Jan 11, 2017
    Messages:
    273
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    I tried to do this, but unfortunately there’s no way of reading chest contents from the client-side. Just not possible. This would have to be a server plugin to implement that functionality.
     
  12. Kozz

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

    Joined:
    Jan 11, 2017
    Messages:
    273
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    That’s exactly right, nice catch. I assumed there would always be a space there. This will be the first thing fixed in the next update, thanks for reporting this.

    Searching by shops is also a great suggestion. You can filter the table by the search field above, but I think you meant to see all items in just one shop. That can be added.

    People have also requested coordinates / player name of the item sign, which I can add, but need to think of a good way to fit them into the table without it being overcrowded with unnecessary info.
     
  13. 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
    That's a shame.
     
  14. samiwarbler

    samiwarbler Sheep Queen
    Mayor ⛰️⛰️ Ex-EcoLegend ⚜️⚜️⚜️⚜️ Prestige ⭐ I ⭐ Premium Upgrade

    Joined:
    Oct 25, 2014
    Messages:
    1,023
    Trophy Points:
    49,410
    Gender:
    Female
    Ratings:
    +552
    Can you make this so that table has an option where you can hide certain columns? This might help with those that care about cords or player name to condense the table?
     
  15. Jdawger

    Jdawger Goes by Brass Scribe everwhere except MC & ECC
    ECC Sponsor President ⛰️⛰️ Ex-EcoLegend ⚜️⚜️⚜️⚜️ Prestige ⭐ III ⭐ Gameplay Architect Premium Upgrade

    Joined:
    Dec 15, 2013
    Messages:
    4,096
    Trophy Points:
    88,160
    Gender:
    Male
    Ratings:
    +3,269
    This might be a minor thing, but is it possible for this to list the coords of the chest as well? Some shops don’t organize well or have the shop so far from the warp
     
  16. Kozz

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

    Joined:
    Jan 11, 2017
    Messages:
    273
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    Prepare for version 1.0.1 release
    Downtime expected: ~15 minutes.
    The database will be recreated, meaning I'll have to add shops back and update them again.
    The whole process should take ~30 minutes.

    You will have to update your mod in order to update again.
    The link will be updated on the website. Make sure it is version 1.0.1


    Changes:
    • Coordinates of the item signs are now being sent and stored by the server.
      • These coordinates are not yet visible on the table, but will be soon.
    • Player names will now be visible when searching for items
    • Fixed a bug where regular signs were being mistaken for trade signs
    • Fixed a bug that caused the sell and buy prices to be swapped
    • Fixed a bug where negative coordinates would potentially cause problems when updating shop boundaries
    • Performance improvements when updating shops
    • Improved logging so I can correct any potential errors on my end
    • Table is now horizontally scrollable when width of the screen is smaller (phones, tablets)

    Done.
    I have something else in mind (expandable rows)
    This is being implemented. After this update, the data will be there.
    I now just need a clean way to show it.
    Fixed.
    Adding in the next update.




    EDIT: Update Successful.
    Time taken: 30 minutes.

    Had some unexpected bugs after update, quick-fix and done.
    Site should be back stable now. :)
     
    #16 Kozz, Dec 21, 2019
    Last edited: Dec 21, 2019
  17. Kozz

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

    Joined:
    Jan 11, 2017
    Messages:
    273
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    1.0.1a released!
    * no update required, this was all front-end work

    Changes:

    • Revamped the table to look better.
    • Expandable rows now show the item sign coordinates
    • Time format is now in AM/PM
    • When you're buying items are now sorted by item price/each lowest to highest
    • When you're selling items are now sorted by item price/each highest to lowest
    Done.
     
    #17 Kozz, Dec 22, 2019
    Last edited: Dec 22, 2019
  18. xHarambae

    xHarambae President
    President ⛰️⛰️ Ex-EcoLegend ⚜️⚜️⚜️⚜️ Prestige ⭐ I ⭐ Premium Upgrade

    Joined:
    Mar 4, 2012
    Messages:
    1,465
    Trophy Points:
    70,810
    Gender:
    Male
    Ratings:
    +549
    Are you aware of a forge download link for Mac?
     
  19. Revanrose6

    Revanrose6 Sith Lord
    ECC Sponsor Resident ⛰️ Ex-EcoLegend ⚜️⚜️⚜️⚜️ Prestige ⭐ I ⭐ Gameplay Architect Premium Upgrade

    Joined:
    Dec 18, 2012
    Messages:
    8,391
    Trophy Points:
    93,160
    Gender:
    Female
    Ratings:
    +3,306
  20. andrewkm

    Founder Premium Upgrade

    Joined:
    Apr 5, 2011
    Messages:
    20,349
    Trophy Points:
    102,160
    Ratings:
    +15,056
    Please let me know once you consider it out of BETA @Kozz via forum PM and I will make an announcement and add an official link to the forum. :)
     
    #20 andrewkm, Dec 25, 2019
    Last edited: Dec 25, 2019