[ShopDB] Updates / Changelog

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

  1. Videowiz92

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

    Joined:
    Jan 30, 2012
    Messages:
    3,036
    Trophy Points:
    77,660
    Gender:
    Male
    Ratings:
    +1,202
    As with how the table defaults now to sort the "Buy/Sell Price (each)" columns first, it would put the items column in alphabetical order as a secondary priority. Can't really test this right now with the current setup as selecting the item column to sort doesn't change since there's only 1 item type.

    Perhaps as an alternative, the table doesn't list the item name - rather keep it as setting the "Buy/Sell Price (each)" as a default sorting method, and the item name is listed under the dropdown menu. After a player has chosen what items they are looking for and finding the price, by hitting the dropdown box to reveal who is selling and at what coords it will also list the item they are after. Besides the checklist that the player had filled out should list what items are being filtered, so the item being displayed in the table seems like a waste of space, in my opinion. Just a thought though and may need some testing to see how it looks in the end.
     
  2. Kozz

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

    Joined:
    Jan 11, 2017
    Messages:
    272
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    I am working on revamping the tables to make them more interactive and fun.

    As it currently stands it is practical, but a bit dull. So I'm fixing that:


    [​IMG]


    I've removed non-essential columns.
    • Item name was redundant, it's what you searched for!
    • I feel the overall price is not needed, I'm afraid you may have to do simple maths on price (each) * quantity. If anyone thinks it is needed, please give me feedback!
    • Each column has a unique image!

    Icons / Colum
    ns
    Shop

    • Image chosen randomly.

    Seller
    • Yes, that's you. Yes, that's your Minecraft head!
    • Could be shown in the 'additional info' modal, but I think it looks pretty cool right there.

    Quantity
    • Quantity between 1 and 15: One box
    • Quantity between 16 and 31: More boxes
    • Quantity between 32 and 63: Even more boxes
    • Quantity 64+: Overflowing cart

    Price
    • One coin - good job! Your stuff is cheap. (80% or less of average price)
    • Two coins - fair! (80% to 110% of average price)
    • Pile of coins - oof! (110% or more of average price)
    These calculations may change. I'm still feeling it out.

    Info
    • Clicking this will bring up a 'profile' of the item/shop, displaying all of the above information as well as the coordinates, total buy price, item name, etc.
    • (Still working on this, I will show a demo once it's done)


    Drawbacks
    • No more pagination on tables.
    • No more sortable columns.
    Hopefully the dynamic icons make up for these drawbacks by making it visually easier to find what you're looking for.

    Feedback
    I'm always searching for feedback! My goal is to make the website practical and providing a good user experience. The server runs on it's economy, and I really want this to be a centerpiece to it!

    I think these changes will add some life to the application!

    If you have suggestions, please do post them! If there's anything you think could make this better I'm always glad to hear it.

    This is still in development, so now is the best time to make suggestions!


    Implementing that, in a way, by the dynamic coin images. I think 99% of people wouldn't use/care for the actual numbers. Icons are more fun!

    I am listening! It was your suggestion that inspired me to rework the table. So thanks :)
    I can add multiple select as a toggle-able option, sort them exactly how you said, and add a 'item' column which shows the item name and it's icon. This will take some time and work, but it will be pretty cool.

    I'm going to go with Videowiz92 suggestion above :)
     
    #42 Kozz, Feb 15, 2020
    Last edited: Feb 15, 2020
  3. Cas_with_a_K

    Cas_with_a_K President
    President ⛰️⛰️ Ex-President ⚒️⚒️

    Joined:
    Feb 16, 2019
    Messages:
    172
    Trophy Points:
    6,460
    Gender:
    Female
    Ratings:
    +107
    I'm a noob so idk but is it possible to see which shops are out of stock? cause frail's is out of stock but it shows up and you have to go from shop to shop to find the item that you need, which can get tedious
     
  4. Fon_

    Fon_ Kindhearted Shade
    Resident ⛰️ Ex-EcoLeader ⚜️⚜️⚜️ Premium Upgrade

    Joined:
    May 26, 2014
    Messages:
    818
    Trophy Points:
    54,910
    Gender:
    Male
    Ratings:
    +411
    Would be nice if you could copy the warp into the clipboard when clicking on the shop's icon.
     
    • Agree Agree x 2
    • Winner Winner x 2
    • List
  5. Kozz

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

    Joined:
    Jan 11, 2017
    Messages:
    272
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    Unfortunately since this runs independently of the server I have not found a way to achieve this.
    e.g, there is no way to read contents of a locked chest on the client-side.

    I'm thinking about on 'additional info' a way to report a shop for being out of stock.
    I could then remove the shop if the majority of their items are out of stock.
     
    #45 Kozz, Feb 15, 2020
    Last edited: Feb 15, 2020
  6. Kozz

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

    Joined:
    Jan 11, 2017
    Messages:
    272
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    Great idea! I'll add this.
     
  7. TM_iBeast

    TM_iBeast Not Staff Member
    ECC Sponsor EcoLegend ⛰️⛰️⛰️⛰️ Ex-Tycoon ⚜️⚜️⚜️ Prestige ⭐ II ⭐ Premium Upgrade

    Joined:
    Jul 5, 2013
    Messages:
    960
    Trophy Points:
    67,910
    Gender:
    Male
    Ratings:
    +484
    All these changes look amazing. I liked the total price, but it's definitely not needed.
     
  8. SUBYT

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

    Joined:
    Feb 21, 2019
    Messages:
    460
    Trophy Points:
    10,510
    Gender:
    Male
    Ratings:
    +298
    +1 for the total price I think it is necessary. Great work @Kozz! <3
     
  9. Videowiz92

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

    Joined:
    Jan 30, 2012
    Messages:
    3,036
    Trophy Points:
    77,660
    Gender:
    Male
    Ratings:
    +1,202
    Are you saying you still want total price listed on the table? If so, it's listed under Additional Info
    The table is sorted in order of price, so you'll be getting the best deal by starting at the beginning of the table anyways.
     
    #49 Videowiz92, Feb 15, 2020
    Last edited: Feb 15, 2020
  10. SUBYT

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

    Joined:
    Feb 21, 2019
    Messages:
    460
    Trophy Points:
    10,510
    Gender:
    Male
    Ratings:
    +298
    Yes I was, <3 <3 I didn't know it was there.
     
  11. Videowiz92

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

    Joined:
    Jan 30, 2012
    Messages:
    3,036
    Trophy Points:
    77,660
    Gender:
    Male
    Ratings:
    +1,202
    I believe I may have a solution to out of stock shops, but it may require more coding on the mod's end as well will require more user input from the mod.

    Right now a shop will display that it's out of stock only if a player has enough money to make the purchase (I tested to see if putting all my money away on forums would still display that it was out of stock but it shows that you don't have enough money.) What could be changed is if a player finds an out of stock shop, they could use the stick to right click the sign. On the mod's end, the client would need to detect in chat if the [​IMG] appears and then unlist the shop on the site. The mod is already pulling the needed info from the client such as coordinates and shop owner. If a shop owner wants to relist their shop after restocking, they can just right click anywhere in the shop. This will make it so only shop owners are the ones that can relist a hidden chest shop, and any player can unlist a shop if it's out of stock.

    Perhaps a suggestion can be made for the chest shop plugin to take priority of stock so the chat message appears regardless and a player can go around updating out of stock shops with their balance transferred to the forums, but the above is still a plausible solution.
     
    • Agree Agree x 1
    • Winner Winner x 1
    • List
    #51 Videowiz92, Feb 15, 2020
    Last edited: Feb 15, 2020
  12. Cas_with_a_K

    Cas_with_a_K President
    President ⛰️⛰️ Ex-President ⚒️⚒️

    Joined:
    Feb 16, 2019
    Messages:
    172
    Trophy Points:
    6,460
    Gender:
    Female
    Ratings:
    +107
    +1 love the new layout btw, i look very cute in that xD
     
    #52 Cas_with_a_K, Feb 15, 2020
    Last edited: Feb 16, 2020
  13. Karin_88

    Karin_88 The Rainbow Ex-GA
    ECC Sponsor President ⛰️⛰️ Ex-EcoLegend ⚜️⚜️⚜️⚜️ Prestige ⭐ III ⭐ Premium Upgrade

    Joined:
    Sep 12, 2019
    Messages:
    1,106
    Trophy Points:
    51,160
    Gender:
    Female
    Ratings:
    +1,197
    +1 This would be amazing! Love the new layout and all the little icons make it look very contemporary and adorable! Can't wait to see if this gets implemented!
     
    #53 Karin_88, Feb 15, 2020
    Last edited: Feb 15, 2020
  14. Kozz

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

    Joined:
    Jan 11, 2017
    Messages:
    272
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    Additional Info model:

    [​IMG]
     
    • Like Like x 1
    • Friendly Friendly x 1
    • List
    #54 Kozz, Feb 15, 2020
    Last edited: Feb 15, 2020
  15. Karin_88

    Karin_88 The Rainbow Ex-GA
    ECC Sponsor President ⛰️⛰️ Ex-EcoLegend ⚜️⚜️⚜️⚜️ Prestige ⭐ III ⭐ Premium Upgrade

    Joined:
    Sep 12, 2019
    Messages:
    1,106
    Trophy Points:
    51,160
    Gender:
    Female
    Ratings:
    +1,197
    Love the Additional Info model! All the information you'd need to know, especially important being when it was updated last. :)
     
  16. Kozz

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

    Joined:
    Jan 11, 2017
    Messages:
    272
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    It seems only a very small percentage of players actually use the mod. This solution would work, but the effort may not be worth it because I imagine the players who do use the mod would only account for ~5% of items purchased, meaning only ~5% of out of stock items would be detected.

    It's a lot of effort for what would likely be a very small subset of out of stock items being detected.
    If a significant amount of people used the mod I would definitely do this, but I just don't see the potential as the majority of people do not.

    It's a great solution, but due to the lack of users who have the mod installed I do not think it would make any noticable difference.

    The most practical solution would be to make this a server-side plugin.. which would enable real-time updates without the need to update shops or having a mod in the first place. Perhaps that can be a thing in the (quite distant) future.
     
    • Informative Informative x 1
    • List
  17. Jdawger

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

    Joined:
    Dec 15, 2013
    Messages:
    4,309
    Trophy Points:
    88,160
    Gender:
    Male
    Ratings:
    +3,376
    This might’ve been suggested, but can the site state if the shop is empty or not?
     
  18. Kozz

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

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



    Done.
     
    • Like Like x 2
    • Winner Winner x 2
    • List
    #58 Kozz, Feb 15, 2020
    Last edited: Feb 15, 2020
  19. Kozz

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

    Joined:
    Jan 11, 2017
    Messages:
    272
    Trophy Points:
    28,460
    EcoDollars:
    $0
    Ratings:
    +430
    Read post above yours :p
     
    • Informative Informative x 1
    • List
  20. 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
    oof xD
     
    #60 LaggyTryHard, Feb 15, 2020
    Last edited: Feb 15, 2020