Refactored/rewrote the front-end code to be much more tidy than it previously was. Here's some of the changes. (If these don't show up for you, press ctrl+shift+R to do a hard refresh, or clear your browser cache). - Search dropdown is more 'lean', swapped components for better performance/easier usability - You can now 'type over' your previous searches, no need to clear to search for something else. - Autocomplete is a thing - just hit 'enter' when you've narrowed down the selection enough. - Coordinates are now always shown: copying/pasting coordinates just to see what they are was pretty annoying. - New loading bar - Some minor color/texture changes. It was really confusing to tell whether a shop was 'activated' or not. I don't want to show *all* shops on ECC for privacy reasons, so players must fill out applications for their towns. This was not really obvious. I've tried to make this more clear when viewing a region: Who enjoys staring at an endless loading screen when things are broken? Oh, nobody does. So now error messages will actually be shown, any time one is encountered: I've also re-done the home page as well. To avoid me pasting an image of the entire homepage in, you can just visit: https://shopdb.ecocitycraft.com/home Now that I've cleaned up the code it will be a *lot* easier to add new features. Also, ShopDB is over 100,000 total searches now Glad to see people are using it so much!
Made two significant quality of life improvements to the search features: 'Hide Identical Shops' is back, and is selected by default. This means: Filters out items that are sold by the same player, in the same shop (UNLESS the quantity is different). Example: Lots of players have identical signs for prestige shops. Instead of showing 200+ results, now results will only be shown based on if that sign is unique. Uniqueness is determined by: the player, the shop, the item, and the quantity sold. Will select the shop with the highest availability (storage/stock left): Example: If you're running a prestige store with 10 iron ore signs, the one with the LEAST amount in the chest will be shown. Example: If you're selling quartz in bulk with 10 separate signs, the one with the MOST amount in the chest will be shown. This has rid of the dozens of duplicate results you see when searching for things such as selling iron ore. Previously, this search resulted in 272 shops, most of which were identical. Now, you will see 31 unique results. Of course, you can toggle this off at any time, just uncheck 'Hide Identical Shops'. The ordering of shops with the same prices is now random. Many prestige shops sell at the same prices (cough cough BobbyBlack, Ness). Now, you will have a 50/50 chance of seeing BobbyBlack listed first, vs Ness being listed first. Those two are just examples, this applies for all shops which have the same prices. Bug Fix: Hide Full Shops This actually works now. Yay! NOTE: If these changes don't show up for you, press CTRL+SHIFT+R if on chrome. (or delete browser history/open incognito). This is just a shortcut, changes will show up on their own eventually either way.
Thanks for the continuous improvements Kozz - this is a great tool. I noticed that the latest sales through my shop show up as buyer "unknown". Is that a temporary thing?
Thanks . Hm, I don't see "unknown" for your shops - Are you talking about, in the game they show up as "unknown" ? This would be a separate issue with the ChestShop-3 plugin. Let me know if you continue seeing this.
Thanks for the shameless plug for my great Iron Ore prices. No, I meant when you type /csn history in-game. All my sales showed up as "unknown bought..." yesterday morning. I also noted @OlympiansAreGods mentioned it in the chat yesterday as well. It seems to have corrected itself. I'll let you know if it happens again.
ShopDB Update 02.26.2021: Performance Tuning Warning: If the site isn't working for you: You need to clear cached content: Press CTRL+F5 on the ShopDB webpage to clear cache. This works on all browsers. If this does not work, try CTRL+SHIFT+R on Chrome. If that still does not work, clear browser history for ShopDB through browser settings, or open an incognito window. This also applies to mobile devices. Changes: After various updates to ShopDB, the performance decreased dramatically. Primarily due to server-side batch updates, the application struggled to keep up and was crashing at times due to lack of heap space. To resolve these issues, I have: Rewrote the entire back-end application using a new framework (Quarkus) which allows for native compilation. This means: ShopDB uses less resources. That also means: ShopDB is faster! That also means (x2): ShopDB should stop crashing. During refactoring, I made various optimizations along the way with performance in mind. This means: ShopDB is faster! How much faster? Before it was taking between 1.5 seconds per search, now it takes 230 milliseconds. TLDR: ShopDB is ~650% faster, and should stop crashing now. Also, read the red text above if the site is no longer working for you. If you notice any bugs, please let me know!
Yeah, down for now. Some things broke, and I had to fix them. I believe it's good now, but unfortunately existing chest shop data had to be wiped for this. I'll work on updating the chest shop data today, and they'll continue to be added/updated once the shops are used or open/closed.
ShopDB Update 02.28.2021: Bots save the day! Warning: If the site isn't working for you: You need to clear cached content: Press CTRL+F5 on the ShopDB webpage to clear cache. This works on all browsers. If this does not work, try CTRL+SHIFT+R on Chrome. If that still does not work, clear browser history for ShopDB through browser settings, or open an incognito window. This also applies to mobile devices. Changes: The previous refactoring of ShopDB (read two posts above) introduced some new bugs, which I believe I have now worked out. I used Dugly/ShopDB Bot to help reload updated data based on backups I had from 3-4 days prior. Nearly all chest shops have been restored, and they should all be up to date and accurate. Within the next two to three hours (provided nothing breaks again) regions should be updated to show the appropriate list of mayors. Currently, no towns are linked to players - this should be fixed soon. TLDR: Chest shops are now fixed, and the data is back on ShopDB. Regions/Player data should be fixed within the next two hours. I believe I've fixed all bugs, but if any more arise let me know and I will resolve them.
ShopDB Update 03.02.2021: Region/Player Sorting Warning: If these changes do not appear for you: You need to clear cached content: Press CTRL+F5 on the ShopDB webpage to clear cache. This works on all browsers. If this does not work, try CTRL+SHIFT+R on Chrome. If that still does not work, clear browser history for ShopDB through browser settings, or open an incognito window. This also applies to mobile devices. Changes: You can now sort regions by: Name Number of chest shops Number of mayors Spoiler You can now sort players by: Name Number of chest shops Number of towns Spoiler Also: Fixed a bug where player town count was not being displayed. We can now clearly see that Ness and BobbyBlack own half the market. Just kidding! (kind of) We can also clearly see Ness actually purchased 200+ towns. (not kidding) More features coming soon.
