[ShopDB] Updates / Changelog

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

  1. kukelekuuk

    kukelekuuk C͕̹̲̽ͪ͐ͩ̔L̜̦̝͈ͦ̿̾̿ḘA̻̗̤̳̐ͭ̆̿̃̑ͭN̊̓͑̇ͯ
    Builder ⛰️ Ex-EcoLeader ⚜️⚜️⚜️ Premium Upgrade

    Joined:
    May 25, 2011
    Messages:
    10,061
    Trophy Points:
    80,160
    Ratings:
    +6,925
    Look into per-user token-based authentication, not a single password for everyone hardcoded into the mod.
     
  2. Kozz

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

    Joined:
    Jan 11, 2017
    Messages:
    272
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    What would prevent a player from modifying the client code?
    One could easily unpackage the jar, modify the code, and accomplish the same thing.

    At the end of the day, user authentication is the only way.
    I could accomplish this in a myriad of ways, including as you suggested with generated tokens.

    This was a hotfix that needed to be implemented immediately, so I did implement a hard-coded token for the time-being.
     
    #82 Kozz, Feb 22, 2020
    Last edited: Feb 22, 2020
  3. BobbyBlack

    BobbyBlack Community Spokesperson
    Mythic ⚔️ I ⚔️ ECC Sponsor President ⛰️⛰️ Ex-EcoLegend ⚜️⚜️⚜️⚜️ Prestige ⭐⭐ XI ⭐⭐ Gameplay Architect Premium Upgrade

    Joined:
    Jun 14, 2012
    Messages:
    1,826
    Trophy Points:
    74,160
    Gender:
    Male
    Ratings:
    +1,518
    Can i get verified sir
     
    • Informative Informative x 1
    • Friendly Friendly x 1
    • List
  4. Kozz

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

    Joined:
    Jan 11, 2017
    Messages:
    272
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    LOL No.
    Go build something instead. ;)
     
    • Winner Winner x 1
    • Potato Potato x 1
    • List
    #84 Kozz, Feb 22, 2020
    Last edited: Feb 22, 2020
  5. Kozz

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

    Joined:
    Jan 11, 2017
    Messages:
    272
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    Working on awesome new features:

    Shop Tables - now support pagination & search:
    [​IMG]


    Shop Analytics - see how a shops prices compare with the median prices!
    [​IMG]
    (@Bsqt, @Endy_Enderwoman good job!)

    How shop analytics are determined:
    Prices between 0% and 80% of median price --> GOOD
    Prices between 80% and 120% of median price --> FAIR
    Prices 120% and above median price --> EXPENSIVE

    P.S:
    @TomKFC You may want to raise your prices. Half of them are actually considered 'fair' ;)
    [​IMG]


     
    • Agree Agree x 1
    • Winner Winner x 1
    • List
    #85 Kozz, Feb 23, 2020
    Last edited: Feb 23, 2020
  6. Kozz

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

    Joined:
    Jan 11, 2017
    Messages:
    272
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    2/24/2020 8:20 PM (CST): Updating to v1.0.4
    Expect downtime up-to thirty minutes. Awesome features coming! :)
     
  7. Kozz

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

    Joined:
    Jan 11, 2017
    Messages:
    272
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    2/24/2020 8:22 PM (CST): Updated to v1.0.4
    New features (view post above for screenshots):
    • Pagination and ability to search on item tables
    • Pagination and ability to search on shop tables
    • Shop analytics!
      • On the shops tab, click 'Get shop analytics' for the shop you want.
      • This will show total items traded, total items bold, and total items bought.
      • Click on 'items sold' or 'items bought' to get an item-by-item breakdown of a shop!
        • Analysis of total items considered to be cheap
        • Analysis of total items considered to be fair
        • Analysis of total items considered to be expensive
        • A breakdown of each individual item and how it compares to the median price!
    This update took quite a bit of work, and it's pretty awesome! :)

    EDIT:
    Just noticed the logic for analyzing items sold is the same as that for analyzing items being purchased.
    It should be the opposite, e.g, if the median buying price is $20 but you're buying for $30, it should be analyzed as good. I will fix this tomorrow. :)
     
    #87 Kozz, Feb 24, 2020
    Last edited: Feb 24, 2020
  8. Kozz

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

    Joined:
    Jan 11, 2017
    Messages:
    272
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    Fixed, deploying these changes.
    • Categories are now 'priced good', 'priced fair', 'priced poorly' to make things more clear.
    • For analysis on items a shop is purchasing, the logic is now correct.
    Edit: Changes are deployed!
     
    #88 Kozz, Feb 25, 2020
    Last edited: Feb 25, 2020
  9. SplayTick

    Mythic ⚔️ I ⚔️ ECC Sponsor EcoLegend ⛰️⛰️⛰️⛰️ Ex-EcoMaster ⚜️⚜️⚜️⚜️ Prestige ⭐ V ⭐ Premium Upgrade

    Joined:
    Jan 17, 2020
    Messages:
    196
    Trophy Points:
    43,110
    Gender:
    Male
    Ratings:
    +75
    Is there a way to have a chest excluded from the database? Like if a chest is set up for a payment plan with another user not have that counted as a chest shop chest?
     
  10. Kozz

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

    Joined:
    Jan 11, 2017
    Messages:
    272
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    Hmm... Since the format of trade signs are strictly enforced, there's no reliable way to detect a payment sign.
    I could add a rule to ignore dirt blocks that cost above $100 each, perhaps.
     
    #90 Kozz, Feb 25, 2020
    Last edited: Feb 25, 2020
  11. SplayTick

    Mythic ⚔️ I ⚔️ ECC Sponsor EcoLegend ⛰️⛰️⛰️⛰️ Ex-EcoMaster ⚜️⚜️⚜️⚜️ Prestige ⭐ V ⭐ Premium Upgrade

    Joined:
    Jan 17, 2020
    Messages:
    196
    Trophy Points:
    43,110
    Gender:
    Male
    Ratings:
    +75
    Yeah, I have a chest set up for someone right now and if you search buy paper on main it shows up.
     
  12. Kozz

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

    Joined:
    Jan 11, 2017
    Messages:
    272
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    That's a pretty expensive piece of paper.
    Is it a college degree?

    Jokes aside, I can add the rule I said above. You would have to modify your trade to be for a dirt block.
    Alternatively, you could place the trade sign outside of your shop boundaries.
     
  13. SplayTick

    Mythic ⚔️ I ⚔️ ECC Sponsor EcoLegend ⛰️⛰️⛰️⛰️ Ex-EcoMaster ⚜️⚜️⚜️⚜️ Prestige ⭐ V ⭐ Premium Upgrade

    Joined:
    Jan 17, 2020
    Messages:
    196
    Trophy Points:
    43,110
    Gender:
    Male
    Ratings:
    +75
    Ok. I will change it to that. I'll set up any future ones outside the shop boundaries if possible though to help with this. Thanks for the fast replies!
     
  14. Kozz

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

    Joined:
    Jan 11, 2017
    Messages:
    272
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    Alright, I can have the change in-place tomorrow. It's time for bed for me :)
     
  15. SUBYT

    SUBYT Mayor
    Mayor ⛰️⛰️ Ex-Tycoon ⚜️⚜️⚜️

    Joined:
    Feb 21, 2019
    Messages:
    460
    Trophy Points:
    10,510
    Gender:
    Male
    Ratings:
    +298
    The link to download the mod isn't working. @Kozz
     
  16. 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
    Any chance that you can prevent duplicate signs showing up in the listing OR somehow making them look more cohesive.

    For example, Tom has 4 dirt chests in station 4 and they all show up bloating the list a bit. I also am currently setting up a shop that will have multiple signs for one type of item and was wondering if this could somehow be more concise per shop area perhaps?
     
  17. LaggyTryHard

    LaggyTryHard ♛Exalted Builder♛
    EcoLeader ⛰️⛰️⛰️ Ex-EcoLegend ⚜️⚜️⚜️⚜️ Prestige ⭐ I ⭐ Premium Upgrade

    Joined:
    Jun 15, 2017
    Messages:
    1,361
    Trophy Points:
    55,160
    Gender:
    Male
    Ratings:
    +964
    A decent way to implement this is to combine all identical signs from the same person to fuse into a single entry on the website. That single entry could display to total number of things they are buying/selling (so if tom is buying dirt from 3 chests all for the same price, then it appears as a single entry with the number: 10368 as the quantity). And then if the user clicks on the more information, they would get the coords for each chest
     
  18. Kozz

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

    Joined:
    Jan 11, 2017
    Messages:
    272
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    Duplicate signs are prevented.

    Duplicates are determined by:
    1. The person selling the item
    2. The quantity being sold
    3. The price per item being purchased/sold

    TomKFC shops up three times in ShopDB because:
    1. Quantity of one sign is 3456
    2. Quantity of another sign is 64
    3. One sign is buying and selling 3456 dirt, and the other sign is exclusively buying 3456 dirt.

    I feel a quantity difference is not a duplicate. E.G, if I'm looking to buy dirt - it is relevant if I'm looking to buy a stack or an inventory full.
    If I were to (falsely) only display TomKFC as selling an inventory full, people may look elsewhere because they only need a stack.

    I will work on resolving this. This is not intended and should not be shown twice as it is the same exact item, quantity, and price.
     
  19. SUBYT

    SUBYT Mayor
    Mayor ⛰️⛰️ Ex-Tycoon ⚜️⚜️⚜️

    Joined:
    Feb 21, 2019
    Messages:
    460
    Trophy Points:
    10,510
    Gender:
    Male
    Ratings:
    +298
    @Kozz! The link is still broken, the mod can't be downloaded
     
  20. 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
    @ArthurAquaman thats Intended because the public can no longer update ships because of an exploit