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
Honestly, I can't remember the 'bulk tradables' area, I never use it since I manage my collection here, and then manually export to BVG.

As for banners, it'd have to be stored in the database, but I forgot the format for that, and most importantly, where in the code I should update stuff. (I would post it on github, if only I were convinced that some users would be tempted to help with development. As of now, I have 99% confidence it won't change anything, so why bother.)

I'm aware it'd be a good thing to do, though. The banners, I mean. As it is, most of the website is customized to my taste. Not to say I think I have the best tastes, but I'm not paid for this pet project, so I guess it matters that I'm comfortable with it. ;-)
2
The Noble Talk / Re: What's up at Lestrade's?
« on December 25th, 2021, 06:17 PM »
That'd probably require writing a stand-alone search page for all of the features to be properly exposed, and I can't be arsed to do it... :-/

Merry Christmas, though ;)
3
The Noble Talk / Re: What's up at Lestrade's?
« on December 21st, 2021, 01:10 PM »
Ad usual, I added a feature for myself, might as well mention it... ;)
In the game search engine (at the top right of the page), you can now specify " -intro" to prevent game descriptions from being searched. Useful when the game's name is very commonly used in game intros.
Also, " +all" is used to include all database entries in the search, so you'll get all of the junk, demos and other things the engine usually doesn't even bother to look through... (That one was implemented years ago, I just didn't remember I had that.)
4
The Fatal Problem / Re: Issue(s)
« on December 20th, 2021, 11:26 PM »
Replying in private ;)
5
The Noble Talk / Re: What's up at Lestrade's?
« on December 2nd, 2021, 12:28 PM »
Note: I (finally) fixed icons here at LT's on Firefox, at least on Windows systems.
It's not _that_ important, but it always bugged me that I could control icon colors in most browsers, but not in Firefox. Turns out they implement emojis differently.
It's still not fixed on my mobile browser, though. I'm not sure those even ship with a monochrome unicode implementation though, so it'll probably be forever, unless I replace their text icons with SVG graphics (meh).
6
The Fatal Problem / Re: Issue(s)
« on November 4th, 2021, 12:49 AM »
Aaaand... Bundles fixed!

The problem wasn't in the ITAD connection, it was due to a change Devotee made to the SSL configuration that I have no idea about, but his fix from above didn't work. I had to work around this for the second time in 10 days, but this time it worked for ITAD. I'm not super happy with the fix, but it'll do for now.
I'll have to see if I can re-import some of the missing bundles. (I think the site only imports non-expired bundles, so anything that was both created and expired in August/September would be missing.)
Posted: November 3rd, 2021, 11:33 PM

All of the missing bundles should now be back! :cool:
7
The Fatal Problem / Re: Issue(s)
« on November 3rd, 2021, 11:08 PM »
Fixed an issue where it had become impossible to log into Lestrade's.

(I'm officially angry at this server.)
8
The Fatal Problem / Re: Do tradables expire?
« on October 29th, 2021, 06:27 PM »
Yeah, it's not normal... My code specifically checks for tradables that were marked as being imported automatically from BVG. It will never remove anything that was entered manually here. BTW, I'm seeing 380 tradables in your list... Are you sure you're talking about tradables?

Either way... I usually wouldn't shoot myself in the foot willingly, but still, I would suggest you export your tradables to BVG format (there's a tutorial for that because there's a learning curve), then import them over there, and you'll probably have more potential trades. Lestrade's never reached the number of users needed to make it sustainable as a trading site (I was really hopeful for that back in 2017, but I've moved on from that), so I simply use it myself as a clearer, cleaner way to manage my tradables (which were all entered here and never deleted automatically), since BVG is targeted towards trading and not maintaining lists in a friendly way. Then I occasionally export them to BVG to get offers.
9
The Fatal Problem / Re: Issue(s)
« on October 25th, 2021, 09:40 PM »
How many of you are directly affected by the lack of bundles being added to the site..? Is it even worth finding a fix? (If it can be found... I mean it's now established that I'd probably have to contact the admin at ITAD to ask him to allow me to scrape his bundle page twice hourly, like I always do...)
I really don't feel like rewriting the entire bundle section just to be a duplicate of batter's. Sure, they've steadily improved it since when I write my ITAD scraper (they've now caught up with older bundles, and are arguably a better source for bundle contents), but there's no API for it, and I'm already scraping so much data from bvg for the game and tradable databases, it's a bit much to me...
10
The Fatal Problem / Re: Issue(s)
« on October 20th, 2021, 01:38 PM »
@devotee Thanks for the URL to the full certificate. I didn't have it, meaning the SSL code was never working well.
I finally managed to enable SSL communication between Lestrade's and Barter.vg or SteamTrades :)
Unfortunately, this doesn't seem to work on ITAD...
So, my guess is that the webmaster decided he wanted to forbid requests from external websites, even though I'm really, really kind with his server (I only hit it 48 times per day...)

I don't know what to do, then. Either contact the webmaster and ask for help/understanding, or give up on ITAD (I really haven't used it in years) as a bundle source, and focus on BVG for them, exclusively. It's not great either, because if BVG ends up dying, well... It's back to ITAD.
Also, I certainly do NOT have the time to write some extra scraping code for BVG. Plus I'm already hitting it a lot (compared to ITAD, I mean.) There's a limit to what I can expect of the admin to understand.
11
The Fatal Problem / Re: Issue(s)
« on October 15th, 2021, 01:56 PM »
@devotee
Quote from devotee on October 8th, 2021, 03:50 PM
The auto-renewal script is working but Let’s Encrypt migrated from ACME v1 to v2 and dropped all support to v1. Unfortunately I can't upgrade certbot on the server to use the new ACME v2 protocol.
Unfortunately, SSL communication between servers still isn't established. I looked at my code and it just says error 0 when I try to get a file through curl.
When I use file_get_contents over SSL, it gives me this:

error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed

Apparently meaning there's a problem with the cacert.pem file location or related configuration.
This has been going on since October 7, one day before your message, so I'm guessing it's related to your intervention.

Because of that, bundles have yet to be updated. Nothing since September 30. Quite annoying.
Do you have somewhere I can contact you in priority? Last time I tried e-mail and Steam, and no replies for weeks... :-/
WhatsApp, Discord, anything? Something modern? You know I'm only going to write to mention these issues... And it also helps with your own websites...
12
The Fatal Problem / Re: Issue(s)
« on October 13th, 2021, 07:17 PM »
Thank you!! :-)
13
The Fatal Problem / Re: Issue(s)
« on October 7th, 2021, 02:55 PM »
So, still no answer from Devotee... It's like he doesn't care, or isn't online anymore.

My PC died on me last week, and I'm still in the process of restoring everything on the new one. It's taking time. I haven't got access to the FTP yet. But it made me think, I really should move the website to another server. Especially since the online services are starting to die out mostly because of the SSL failure -- for instance, SteamTrades ratings are no longer updated. Also, it looks like there are missing bundles in the bundle page. The latest Humble Choice isn't showing up, despite trying to update it manually. I don't know if it's related to SSL or maybe they changed their code, but right now I can't test, because I don't have my usual tools installed.

So, in the meantime, has anyone got some space somewhere..? Lestrade's isn't that big of a website, it doesn't take gigabytes of data, it just needs a robust MySQL setup and at most a Gb of folder space (possibly less.)
Unfortunately, on my other host, I don't have the space for that.

I don't want to let LT's die. There are still hundreds of users who would like to keep it online. I'm sure one of you guys is in IT and has a server available..?
Even a slower one is fine. LT's code is optimized enough that it doesn't need a fast CPU.
14
The Fatal Problem / Re: Do tradables expire?
« on September 10th, 2021, 05:32 PM »
Yes, they expire after something like 6 months. This is to keep the database lean & clean, and avoid having outdated ratios coming from users who left long ago.

However, don't fret -- the only tradables that actually expire are those that you imported from BVG, if you used the import tool. Any tradables added manually here are safe from being removed. If you want to recover your tradables, you can simply re-import them from BVG. It'll also have the added benefit of being up to date.
15
The Fatal Problem / Re: Issue(s)
« on August 29th, 2021, 12:22 PM »
I've sent Devotee an e-mail, which he's more likely to notice than his Steam messages.
Hopefully, it'll be fixed quickly...

Super annoying. :-/