➡️ Added a Winning Bid Filter as suggested by @_scooba
➡️ Added an extra check that prevents accounts from being registered twice. (caused active premium not being detected)
➡️ Allow dashed and not dashed item uuids in the /api/auctions/active/uuid endpoint. (actually only the last 12 chars matter, everything else is ignored)
➡️ Added filters for Music, End, Tidal and Enchant Runes.
➡️ Made the flip finders account for these runes
➡️ Extended the item icon retrieval to load icons from hypixel if skycrypt doesn’t have them
➡️ Limit the time a flip can be slowed down by the name retrieval process to 12 seconds
➡️ Stabilised the flipper by tuning the gemstone price loading
➡️ Made an attempt to fix missing highest bids
➡️ Added /api/item/price/{Tag}/history/week and /api/item/price/{Tag}/history/month endpoints for @mattthecuber
➡️ Optimise loading of Profitable Crafts
➡️ started working on a best kat flip calculator
➡️ Fixed /profit returning incorrect profit amounts
➡️ Finished UI rebuild with next.js. Everything seems to work like before. TODO: 1. Add SSR to the rest of the pages (where it makes sense). 2. Add nice embed previews
➡️ Fixed the Enchantment filter for None (items without enchants)
➡️ Limit user creation to one at a time to hopefully fix the bug where users would exist multiple times
➡️ Moved stuff around to speed up settings changes and mod authorisations
➡️ Started rolling out this fix for the in game /cofl profit command as well
➡️ Rolling out an update that fixes the Profit Percentage filter.
➡️ Adjusted the countdown by 2-3 seconds to account for recent speed improvements
➡️ <@&869943787277926470> Added the Volume, Median price and slayer requirements to Profitable Crafts (on the website)
➡️ investigated reports of flips being sent out slowly
➡️ Found an issue for people that enabled this checkbox (turn it off for a quick fix, it makes no difference if you only use the sniper flip finder)
started rolling out a fix
➡️ now including server informations such as other connected users and their settings with reports to hopefully find why the mod sometimes doesn’t show flips.
➡️ Fixed account connecting via bids thanks @maitregeek for reporting that
➡️ Fixed a bug with that and continued the search for potential slowdowns
➡️ After breaking flip tracking 3 times it tracks the time correctly now 🙂 (previously the db would set the find time of a flip which could be seconds off)
➡️ Added kat profit calculations to the api
➡️ shared some timings with tfm users who were worried that cofl was faster, invalidating their concerns by showing they still have a 0.5second+ speed advantage
➡️ started adding commands for the new payment system to the mod to test it
➡️ Finished porting the entire UI to next.js.
➡️ Made the first test purchase successfully with stripe
➡️ Started tracking the bazaar exactly 2 years ago
➡️ Added configured volume and Min Profit Percentage to be displayed as hover affect on the message you receive after starting the mod. Requested by @phenixhd
➡️ Started migrating bazaar data from end of may 2020-now to new database
➡️ Also started uploading data from 12. March 2020 till end of may. It used the first version of the hypixel bazaar API only allowing for it to be updated every 3 minutes
➡️ Fixed a bug, which prevented the UI to update the settings dialog correctly
➡️ Added capability to find items not on ah to the item service
➡️ added skin resolution to the item service (for items represented as player heads)
➡️ Investigated migration stop while processing October 2021. So far it moved over a billion lines of data
➡️ Patched migration to restart at the time it stopped
➡️ Tested the next.js port and reported a bunch of bugs to <@&869943787277926470>
➡️ Fixed multiple bugs with the new next.js implementation.
➡️ Added a embed to the /item and /auction page
➡️ Categorising all items to allow you to filter for multiple items at once. Please let me know if you are missing one, currently there are
UNKNOWN (everything not in another category), PET_ITEM, SWORD, CHESTPLATE, HELMET, REFORGE_STONE, COSMETIC(Pet Skins, Book of Stats and 6 more), AXE, LEGGINGS, ACCESSORY, BOW, TRAVEL_SCROLL, BOOTS, HOE, BAIT, FISHING_ROD, DUNGEON_PASS, ARROW, SPADE, SHEARS, PICKAXE, ARROW_POISON, WAND, DRILL, FISHING_WEAPON, GAUNTLET, FURNITURE, GENERATOR, MINION_SKIN, PRIVATE_ISLAND, ISLAND_CRYSTAL, FRAGMENT, SLAYER, DUNGEON, DUNGEON_ITEM, SACK, PORTAL, DEEP_CAVERNS, BACKPACK, TALISMAN_ENRICHMENT, THE_FISH
➡️ Fixed a bug in the backend that would keep mod-connections running after the mod was stopped
➡️ moving of data is done now, started aggregating the ten second based data into groups to better make sense of it (takes an estimated 7-8 days)
➡️ Fixed multiple errors in the new next.js UI-Version found by @ekwav
➡️ Improved the lighthouse scores
➡️ Added embeds for all pages
➡️ Reduced bundle size by replacing big npm packages
➡️ Deployed the new website version from @ragult to https://sky-commands.coflnet.com feel free to take a look (everything should function the same but is loaded differently)
➡️ More next fixes/optimizations
➡️ Added /api/auctions/uid/{uid}/sold allowing anyone to search for all past sells of an item with a specific uuid (meant for dupe checking) as requested by @tgww
➡️ Added /api/bazaar/{itemTag}/history/hour exposing the bazaar price data of the last hour in intervals of 10 seconds
➡️ Added /api/bazaar/{itemTag}/history/day exposing the bazaar price data of the last day in intervals of 5 minutes
Note that this endpoint is currently building and does only return data for a few items like ENCHANTED_BLAZE_ROD
➡️ Added /api/bazaar/{itemTag}/history/week exposing the bazaar price data of the last week in intervals of 2 hours. Same limitation as above applies
➡️ Added /api/bazaar/{itemTag}/history giving access to “all time” data usually segmented in days.
Endpoint allows the specification of a start and end time to get a specific time frame. Aggregates get smaller the smaller the difference between start and end is.
➡️ Added /api/bazaar/{itemTag}/snapshot it allows you to retrieve the orderbook for the bazaar at any time since March 12th 2020. Apparently I have a large hole in my data covering almost all of May 2020 sorry if you wanted to check prices there.
Different to the other endpoints added today this is fully functional for every timestamp that I recorded (there are some other smaller holes as well when the tracking went down)
➡️ Caped the max xp sniper and sniper median take into account at Lvl 100 previously they could go above that which messed with references. Thanks for reporting that @dakachips
➡️ Speed up the bazaar endpoints ~4 fold (averages ~500ms now instead of 1.9s )
➡️ Added /api/auctions/uids/sold to make lookups for full inventories of items for @tgww
➡️ Switched the bazaar history endpoints to use the best sell/buy offer price if available. Thanks @csjh for pointing out that its wrong
➡️ Fixed the on the fly generation for /api/bazaar/{itemTag}/history/week (it returns data now)
➡️ Built a new mod version with some minor improvements that bugged me for a while.
https://github.com/Coflnet/SkyblockMod/commit/b5a680e8fcea1bd0e491ae5725fbacaf372f748e
➡️ Added /cofl help command
➡️ Started writing update notices to users still using 1.2-alpha
➡️ Fixed the auto reconnect in the mod and put out another <#890682907889373257>
➡️ Added range filter to stars for @snatty (will take a bit until its rolled out to everywhere)
➡️ Reworked flip menu to be just one button giving you more options
➡️ Sniper median and sniper flip-references now display a sample of auctions used to get the median
➡️ Added the /cofl time to every flip (via the new flip menu)
➡️ Fixed the validation of the Stars filter (only 0,1 or any range could be entered)
➡️ This is now live
➡️ Wrote some code to detect autobuyers automatically
➡️ Fixed a bug preventing you to retrieve some references
➡️ Added a ReferenceAge filter allowing you to filter flips which are found using old references.
It’s specified in days. Thanks for the suggestion @vytal
➡️ just been enjoying commonly out speeding tfm today, could get used to that
➡️ Returning a properly formatted error message when an invalid uuid is passed to the API as suggested by @tgww
➡️ Fixed that, the level wasn’t actually capped until now 😅
➡️ set up a new replicated mariadb instance
➡️ Reduced required reference auctions count in an attempt to mitigate price drops like mayor changes
➡️ Tinkered a bit more on the bot detection
➡️ Started rolling out bot detection/nerving (flips are delayed for suspected bots, feel free to create a report if you feel like you were flagged as a bot while you aren’t)
➡️ Monitored and updated the system a few times. So far it slowed down someone a total of 9 times one of them being ahbot which has currently a slowdown of a bit more than half a second
➡️ changed flips below 1M to only use 1% ah tax instead of two as suggested by @therealjams and @vytal
➡️ The hypixel api just went down for about two minutes and is now back
➡️ Added /cofl logout to logout all authorised mods as suggested by @ulvetime
➡️ Added something for tomorrow 👀



