devotee

  • Newbie
  • Posts: 26
  • Trades: 14

[Lestrades.com] Nao 尚

  • I'm Share-Locked
  • Administrator
  • Posts: 1,340
  • Trades: 215
Re: Issue(s)
« Reply #226,  »
Ah! At last :)
Were you on a Christmas break? ;)
Re: Issue(s)
« Reply #227,  »
Apologies about the downtime today... I wrote a faulty SQL statement that was missing a safeguard, and ended up running it a million times (!) more than needed. Oops! Had to wait until the query finished, reset the database, and then run the fix query which just took a second or so... Silly me.

Akylen

  • Full Member
  • Posts: 209
  • Trades: 56
Re: Issue(s)
« Reply #228,  »
I noticed a few exclusive steam bundles that include a GOG game or two:
https://lestrades.com/bundle/7800/ - Space Robinson: Hardcore Roguelike Action

This messes up the stats not only mine, but site's too.

[Lestrades.com] Nao 尚

  • I'm Share-Locked
  • Administrator
  • Posts: 1,340
  • Trades: 215
Re: Issue(s)
« Reply #229,  »
Fixed. The issue comes from the fact that ITAD bundle imports are forced to work with game names, and sometimes bundle reporters will enter a name that's not on Steam, but it'll find an equivalent in another store, so this'll be used. Meh.

I could add some kind of failsafe to prevent non-Steam games being added without my manual approval, but I like mostly having the thing working without human intervention.

/u/humpaaa

  • Full Member
  • ▶ ¦ Yep
  • Posts: 188
  • Trades: 10

[Lestrades.com] Nao 尚

  • I'm Share-Locked
  • Administrator
  • Posts: 1,340
  • Trades: 215
Re: Issue(s)
« Reply #231,  »
Yeah and Devotee is nowhere to be found, again ;)

I always convince myself he's finally automated the renewal, lol... It's just a matter of adding a script.

Annoyer13

  • Newbie
  • Posts: 7
  • Trades: 0
Re: Issue(s)
« Reply #232,  »
I'd recommend cloudflare, adds ssl with no hassle.

[Lestrades.com] Nao 尚

  • I'm Share-Locked
  • Administrator
  • Posts: 1,340
  • Trades: 215
Re: Issue(s)
« Reply #233,  »
Meh, LetsEncrypt does the job just fine and you don't have to go through another server for that.
The only problem is that I can never get to wake devotee up in time for fixing SSL...
Other than that, I could possibly move the server to another place, but I don't want to pay for it, etc.
It's not a project that earns me anything (either glory or fortune), and I added the server to my 'exception list' long ago (so that I wouldn't get SSL error notifications), so I don't know what else to say... Add to your exceptions? Or try & find a way to get in touch with devotee because I can't ;)

Banny

  • Newbie
  • Posts: 2
  • Trades: 5
Re: Issue(s)
« Reply #234,  »
Error 302An error occurred while trying to retrieve your Barter blacklist. Please try again!

[Lestrades.com] Nao 尚

  • I'm Share-Locked
  • Administrator
  • Posts: 1,340
  • Trades: 215
Re: Issue(s)
« Reply #235,  »
Yeah, as I mentioned in the other topic, it looks like Barter is currently preventing other websites (or just Lestrade's?) from getting data from it.
Someone would have to ask the BVG webmaster to look into it and re-enable outside scraping.
We had this discussion years ago, and settled on a scraping system that was soft on his servers, I can look into making the updates less frequent (it's better than nothing), but if there's no way to get data from BVG, I will no longer be able to connect users between the websites, and make it possible to transfer tradables with tags, etc. Which would be... bad, for both websites (in my opinion).

Akylen

  • Full Member
  • Posts: 209
  • Trades: 56
Re: Issue(s)
« Reply #236,  »
I've created a discussion here. Hope it gets his attention :)

[Lestrades.com] Nao 尚

  • I'm Share-Locked
  • Administrator
  • Posts: 1,340
  • Trades: 215
Re: Issue(s)
« Reply #237,  »
You know, you don't have to convince him, we already had this discussion in the past. ;-)
Our main issue wasn't that I was scraping his database, but rather the fact that he wanted me to use his JSON API instead (which I'm thinking he wrote with me in mind). Which I'd be fine with, but there were always things missing compared to what was being shown on the website. And now in 2020 I don't really see an incentive to start rewriting my codebase anyway. Lestrade's is in maintenance mode, meaning I'm always there to fix it, but I don't even bother to document new features anymore... :-/ (For instance, this week I added a 'release date' field on studio pages, lol. Figured it could help if you're looking through a game series and want to know which one came out first.)

Akylen

  • Full Member
  • Posts: 209
  • Trades: 56
Re: Issue(s)
« Reply #238,  »
Just wanted to add in there that I think both platforms are useful for different purposes. As I said, I hope this is just some bug in the system

[Lestrades.com] Nao 尚

  • I'm Share-Locked
  • Administrator
  • Posts: 1,340
  • Trades: 215
Re: Issue(s)
« Reply #239,  »
Yeah, although I still think Lestrade's is the most 'usable' trading system because it's more open (for instance you can send multiple offers to a single person), faster (AJAX everywhere, especially when adding and removing games to an offer), and clearer (the 'lock' icon to make a game mandatory in a multiple-choice offer), Barter clearly won with its number of users (which ultimately is the only thing that matters, isn't it? That the majority is making their life harder is irrelevant), so I'm doing most of my trades at Barter now, and enjoying the fact that its webmaster has been backporting Lestrade's features over there over the years. I believe recently he added the lock system, too, although I haven't used it yet. It's just a shame that when you do something at barter, it always takes 3 more clicks and 10 more seconds than the same operation at Lestrade's... Editing tradable tags? It has gotten better at BVG (you can now do it from a game page, thankfully), but it requires unnecessary clicking (why do I have to check a box next to a tradable before I can edit it? Why do I have to confirm tags one by one when he could add a multi-checkbox list instead?).
Anyway, at this point, I use Barter for trading mostly, and Lestrade's for the rest:
- maintaining my tradable list (then exporting it to Barter, excluding my 'may keeps' which I'm reserving for Lestrade's),
- maintaining my library (including fixing playtimes so that card farming time isn't taken into account),
- searching for games (it's so easy, and I can't tell you the number of games I found just because the search engine also looked inside game descriptions! Which as far as I know, is the only Steam search engine to do so!),
- looking at ITAD bundles (I'm aware that Barter now has much better support for bundles, but I'm not planning to scrape them for now, and since this is the only feature I still have to 'fix' manually from time to time, it's also the only feature that keeps me maintaining the website on a regular basis),
- discussions (the BVG Steam community isn't exactly practical to use...)
- commenting on games and bundles (rarely, but it's still something BVG doesn't have),
- just enjoying the slick layout and fast performance overall...

I couldn't live without Lestrade's, even without trading.
That's why I don't understand why Google is actively preventing search results from showing Lestrade's pages (just like it's pretty impossible to find pages for many of my websites -- for instance ency.cyna.fr has a valuable database of artists for the Saint Seiya show, but typing an artist's name followed by 'ency.cyna.fr' into Google NEVER shows a relevant result!), I find it really sad. (Maybe Google has banned me for using Bing for about 5 minutes back in 2007 or so..?)