If you're referring to the fact that 0:x items are sorted randomly among themselves, it's just because they all have a ratio of zero... I can fix it by setting a fake Have value of 0.1, if you want. But then some 1:Y games will be better ranked if y>x*10... and a 0.01 multiple would get rounded to zero. That's why I didn't do it (yet).

Vesta is interesting but has bugs when using let's encrypt. (Iirc they only happen if you have a reverse proxy so you should be safe.)

Regarding brotli, I'm not asking for an Apache extension but a php extension. The difference is with php I compress the css and js files once, save them in a cache folder, and the rest is up to supported browsers (Firefox and chrome). The savings are about 10% compared to the gz version. That means about 5 to 8KB per page load (with an empty cache of course). It's not much but I like saving bytes. Those who use Wedge could confirm. I'm obsessed with low resource usage. Which is my only reason for asking for brotli and http2.

Good, good!

Yes, library data is coming from Steam exclusively, contrary to the rest. Importing wishlists & co already takes an hour per scrape, adding libraries would probably add an extra hour, all for nothing because right now the website doesn't make use of anything.

I'll keep in mind that maybe I should import Barter libraries as a basis for the new database, after which the regular Steam library import will take over on a regular basis.

Gosh, I need to have a to-do-list somewhere...

Well, I was busy with real life today, so it's not for today. :(
And tomorrow I might only have a couple hours free. Geez.
I'm so close to completion, though. I know I don't have to hurry up, as long as it doesn't take a year to implement that, but still I'm disappointed in myself for not being able to deliver sooner. Ah, if only I liked coffee... I could use a couple nights without sleep.

Reminder: trade offer system is NOT available to the public yet.

- Lestrades.com offer system status: can create offer, choose number of items per side, edit offer while creating it, submit offer, view list of pending offers from me or from others, view offers invididually, accept or decline.
- Not implemented yet: choosing individual items when there's a "4 out of 5" situation (I forgot to add a flag to my database, ahah, I'll have to rethink that because this table will be huge.....), editing offer after it's sent, cancel offer, mark as completed, countering offer.

Every time I finish something I just run to the forums to say I'm close to release. Then I look at this list and I realize "gosh, this is all gonna take another couple of days..."
So much fun!

Ah ah, a sandwich...
I used to launch a game of Spider Solitaire while waiting. I would move the window so that I can see the browser page show the matches as soon as they're up. It was ridiculous-- last year the average waiting time was 1 minute, then this year it was 5 minutes for me, and I have average sized wishlists & tradables, so... Yeah, I did well here. ;)
The secret, of course, is to do everything in a few queries, rather than a series of queries *per game you own*, like Barter probably did...

BTW, I just fixed a bug in the import queue system that broke it about 9 hours ago. Someone synced their wishlist, then apparently (I think?) stopped the process and left (or was unlucky enough to ask for a sync right when LT finished doing its automatic sync, which won't be a problem after this weekend anyway). This resulted in their queued request never being executed, and since it's a queue, well... You know what I mean.
I fixed it so that after a while it just removes any entry that's in first position, until eventually someone gets their own stuff done.
Hopefully the problem won't happen again, but it also means none of the sync requests were honored today. This'll be fixed in a couple hours automatically, of course.

Note: I've figured out why I was removing (game + store) duplicates. That's because that's how I know which item to delete when I'm updating the database with new tradables from Barter... *except* I've actually never got around to doing that: I used to say "people will have their tradables on LT and will be able to import from Barter in case they keep using it", except by now it'd be totally silly to keep using Barter once the offer system is in place, ahah... So, no reason to remove such games. So I'll be changing my code, don't bother!
I'll be doing big changes internally to accomodate for the offer system though-- 90% of my code accounts for people having Barter accounts and addresses them by Barter ID, rather than LT ID. There is a big chance that when I enable the trade system, there will be a few hours where no one will be able to make any matches at all, or the site may even be down (or crash) while I'm downloading Barter data one last time before shutting down the Barter list scraper.

It's a complicated step, so please bear with me. The offer system is 'working' (barely...... But it's fucking working and it's the first time in a week I've been able to create an offer and show it in my offer list), but I need to completely sever ties with Barter as a result. It shouldn't be a problem because there are nearly 700 users here, I think..? So I'll be importing data from these 700 users. You'll no longer be getting 'inactive' user matches, although I'll end up doing something similar based on last online date. (But it's not implemented yet.)

Real life update: we're Friday night here, my kid got back from the nanny's and I'll be off for a few hours. Once he's asleep I'll get to spend another couple hours on the site, but it's unlikely I'll setup the big import for tonight. So I'm planning it for tomorrow instead. Fingers crossed!!