Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - [Lestrades.com] Nao 尚
1
The Noble Talk / Re: What's up at Lestrade's?
« Today at 01:13 AM »
Yes, I see what you mean.
Barter data isn't always up to date. It's curated by humans (admin, theemu and Lilly, as far as I know), and sometimes they do things differently than I like. Sometimes they do things properly and I do it 'my way' (e.g. look at the Stanley Parable's demo, it's the only demo on the entire site you can actually add to your library, because I consider it a game on its own, rather than a demo of the base game), there is no "perfect" database for Steam, but I do my best to have one that's worthy of the tools I built around it.
2
The Noble Talk / Re: What's up at Lestrade's?
« on May 21st, 08:10 PM »
Source of truth? What do you mean?
- game list is taken from barter (so that IDs can match easily when importing and exporting)
- tags, publishers and prices are taken from steamspy API iirc
- descriptions come from the steam API
- most of the remaining fields are either taken from barter or from steam, or figured out by Lestrade's (for instance there are many errors that barter won't fix in game relationships, so I fix them myself and Mark these games as 'do not bother with barter Satan). I'm currently moving some of my barter imports to use steam imports instead, but I'll keep taking barter data for the foreseeable future because I appreciate how the site is progressing and without scraping its data I can't cooperate with them. (I get hundreds of weekly logs from my scraper that I carefully analyze by hand, lol.)
3
The Noble Talk / Re: What's up at Lestrade's?
« on May 21st, 10:34 AM »
Again, many changes these last few days, but I just can't bother to detail them all. It's mostly about game pages-- I'm fine-tuning them, trying to make them look better than before (and frankly, they already looked good enough, but...), also store icon CSS was rewritten for simplicity and fine-tuned, I hopefully didn't forget anything (if you see a store icon out of place, even by a pixel, please tell me.)

FIX(ES): the search engine had become slightly slower (returning its first results in a couple of seconds, instead of less than a second), not because I'm a lazy coder, but because I insisted on searching intros right after you started typing. There is, really, no point in returning all games that include the word, I don't know, "you", in your search results. I'm currently starting to search for intros with a minimum longest word of 4 characters, but I may increase that amount later. (Or also take total search term length, not just the longest word length.)

This is now much faster (pretty much as it used to be), and additionally I removed the limit of items retrieved internally when the word is long enough. This is to make sure you get results on very generic search terms that should exactly match a game, but it's not retrieved because Lestrade's found too many games using the same search word before even reaching it. For instance, I couldn't find "Project One", even when typing its name entirely. Again, that 'no limit' trigger should be when you type of 4-letter word or more. Please don't try that 4-letter word. Actually, do try it. It returns the game 'brainf*ck', with the star, and shows that the word 'fuck' is used in the description. It also returns 'Journey of Life', because it's has an alternative name of 'Journey of Fucker'. Don't ask me why! But it's shown as such, clearly pointing out it's in the alternative name.

Lestrade's is slowly but surely becoming the best search engine for video games, lol. (Kudos to BVG for letting me use their database; although I could switch at any time to my alternative work-only Steam database, it's important to keep connections with that database, if only because I keep sending fixes to it. Also kudos to Lilly for patiently listening to my fix suggestions for the past couple of years, and continuing.)

I can't believe it's still stuck in that upper right corner. It should have a big search box right in the middle of the page, ahah.
4
The Noble Talk / Re: What's up at Lestrade's?
« on May 15th, 10:14 AM »
NEW: Added an 'owners' field to game details. If there are less than 20k users it'll say so. Otherwise, it'll be an average of the estimates given by SteamSpy. (Which is where I'm getting the data from, obviously. I know BVG also does it but I'm not sure if it's using SS data or using their own technique which they devised at some point but somehow stopped talking about..?)

NEW: Very minor, but games with a rating lower than 50% now show it in bold red, and higher than 84% now show it in bold green. This is only on the game pages now, not on game lists. I'm not sure it's a 'great' addition, so for now this is just an experiment. I care about layout and style!
5
The Noble Talk / Re: What's up at Lestrade's?
« on May 15th, 12:01 AM »
NEW: Moved 'add to..'/'remove from..' buttons below game banners, on the left of game tags, as opposed to below all of those. This is an attempt to redesign the system as per multiple suggestions over the past, I'm not too convinced but you tell me. One of the issues (I need to work on the HTML order) is that in responsive mode (mobile), the buttons will be placed too high.

NEW: Updated all game prices to their current ones (previously, they were all 'stuck' to their 2017 prices if they were online before that), also added new entries, 'lowest price seen' (it is definitely NOT as accurate as ITAD especially since it only has the lowest Steam price in the last couple of years, but it's a fine way to estimate a game's value on the official market in case it's put on sale frequently[1]), and 'highest price seen', which is interesting for instance in cases where a game was previously commercial, but recently went free-to-play. Again, this isn't extremely accurate, so if you find any errors, you can report them anywhere you like. Or just ignore them.
These additional details are only show on game pages. Other pages (e.g. game lists) will only show the current usual price & the current price if it's on sale.
 1. Note, this is based on information I've been gathering for the last couple of years without using it. Sometimes, you just find some code and think, 'hey, what's this doing here..?' -- whole lot of fun. I could scrape lowest price dta from ITAD, but I'm not in a hurry to do it -- ITAD is also known for some weird errors. Also, I'm not positive that if the lowest price occurred in 2014, it's of any consequence on its trade value. In fact, I'm convinced it's not.
6
The Noble Talk / Re: What's up at Lestrade's?
« on May 13th, 12:29 AM »
NEW: If a Steam package was removed from Steam, it's likely you can't see its banner in bundles and offer pages. Up until now, it would attempt to show an alternative version of the banner (which likely also didn't exist), and then would fall back to a generic banner. From now on, it'll instead attempt to show the banner of the oldest game in the package, which is more likely to exist, and to be the most important game in the package. If the package only contains DLCs, it'll fall back to the generic banner instead.

Note: this is only for bundles and offers. Not that I can't do the rest... But I can't bother to write the same code everywhere. I'll need to see if I can write a more generic function to show banners.
7
Okay, I double-checked (which I forgot to do the last time), and it looks like SteamTrades now returns a gzipped page, so I'm now decoding it before parsing the data.
Fixed, then. Just give it 24 hours to update -- it'll be automatically updated every day for everyone.
8
The Noble Talk / Re: What's up at Lestrade's?
« on May 11th, 12:00 PM »
NEW: Oh yes, I forgot... Offer pages now show country flags next to trader names, so you can safely comment in the trader's language if you'd like. It was prompted by the fact that for the n-th time I received an offer from a French user, and did most of the conversation in English with them, only to realize late in the process that we were both French. Always an awkard moment, although it's fine to default to English when you're not aware of it, of course!
This is just a tentative feature; feel free to ask for improvements.
9
The Noble Talk / Re: What's up at Lestrade's?
« on May 11th, 11:51 AM »
NEW: I've done a ton of maintenance work on Lestrade's this week while I was a bit sick. (Or did that make me sick..?), and I don't want to get into all the details I changed, but I'll try to remember them and document them.

A sample page: https://lestrades.com/game/65/ now shows related items in a cleaner way. Parents, children and siblings are separated clearly now, packages are also sorted differently (see how the 'packaged child' ends up at the end of the list), and delisted items are also shown last (but before packages are handled). This should make it easier to find your way through games like Civ V or Train Sim or Paradox stuff that have a lot of DLCs and children in general.

NEW: This is more a Wedge feature than Lestrade's (and I'm planning to backport it), but when you're clicking the '...' between page numbers on paginated areas, the site will now show you the 25 previous and next entries, instead of only the 50 next entries. Which is very useful if you're trying to get from page 921 of the game database to page 905, for instance.

I'm also, for the record (nothing visible here), working on a history of changes in the game database, but it's far from perfect for now. I've been recording changes for years now but I never bothered to show them, or record a date for them, which makes it a bit hard to determine when a change occurred. I'm now recording the date, but I'll also need to record any (important) automated changes. Which is a bit annoying because right now there's so much that I'm recording for my personal logs and then deleting as soon as I finish checking everything's doing well. (I need to check automated changes so that I can submit fixes to the BVG database, which itself is automatically synced from the Steam API, SteamKit2, Steam-Tracker, stuff like that.)
10
The Noble Talk / Re: What's up at Lestrade's?
« on May 8th, 11:39 PM »
Well, technically they're supported, it's just that the search engine usually doesn't bother allowing for +/- manipulations of them. (I don't even have to properly support them to add support for that manipulation; it's just that I don't really think about it...)
Feel free to ask for anything you'd need, though.
11
The Noble Talk / Re: What's up at Lestrade's?
« on May 8th, 12:40 AM »
NEW: Search entries now include snippets from the game description if there is one. If the search term was found in the description, that part from the description will be shown instead of the beginning of the description (Google style).

I know, it looks a bit crowded now, and the colors aren't exactly great (especially since I'm now showing ratios in their usual rarity color codes instead of the default maroon I used to have), but it'll have to do for now. I still need to work on the search engine anyway.

Also, sorting is a bit better now -- games where the search term is used in the title will be shown first. Previously, the search engine would show the games with the shortest name first, even if the search term was only found in their description. Gosh, I wasted an hour just to fix that bug...
12
The Noble Talk / Re: What's up at Lestrade's?
« on May 8th, 12:38 AM »
NEW: Slightly better support for games from PSN, Groupees and Epic Games Store. They get their own (ugly) Epic Games and PSN icons in 'related' entries or game pages, also you can specify "+epic" or "-epic" to search for Epic games or search without them, same with "-groupees" and "-psn". There aren't a lot of Epic games right now, but that'll do. There are over 2,000 Groupees items though (mostly things like music albums that aren't actually used at Lestrade's but still inherited from the BVG game DB), so it can be helpful to filter those out when searching.

PS: I'm very tempted to mark all Groupees entries as 'junk', lol... But I guess some people might really be into trading Groupees items through the Groupees website.
13
The Noble Talk / Re: What's up at Lestrade's?
« on May 2nd, 12:43 AM »
I don't know, I like the current layout and don't know how I could improve it without breaking the rest. The main issue is that the tags & other game details vastly differ between games, so some will only have a couple fields, others will have plenty of fields. If I put the description next to them, it'll break many pages. If I put it before the trade buttons, it might break other things.
I don't know... Opinions?
14
The Noble Talk / Re: What's up at Lestrade's?
« on April 28th, 10:57 PM »
NEW: Game pages now have descriptions! Yay!
This is an undergoing task, as I'm pulling them from Steam. I currently have no plans to update descriptions on a regular basis, I'll probably redo it once in a blue moon, because sometimes descriptions get updated. It's not a big deal for me, as I also like the idea of having a website that stores older versions of a description, lol.

Also fixed other things in the database. Gosh, so complicated...
15
The Noble Talk / Re: What's up at Lestrade's?
« on April 27th, 07:08 PM »
FIX: Official Steam ratings were no longer updating. I have no idea when it started, but probably at least months ago... This is now fixed (well, "till next time it breaks", as always..?).

NEW: In tag pages, sorting by rating and popularity will now take potential ratings into account (i.e. for games with less than X reviews).

Please note: I'll probably need to update all those official ratings... At some point... It'll have to wait.
Posted: April 27th, 07:01 PM

Edit: I'll have the database update itself; just at a slower rate than before.