By using this site, you agree to our Privacy Policy and our Terms of Use. Close
mZuzek said:
Mnementh said:

All these posts were made by mZuzek. A lot of work he put in.

And you're putting in the work now. I appreciate it.

Ryuu96 said:

Compared to 2022.

  1. Introduction.
  2. 1133 to 682.
  3. 381 to 101.
  4. Top 100.
  5. Winner.
  6. Platform Breakdown: Nintendo
  7. Platform Breakdown: PlayStation
  8. Platform Breakdown: Xbox
  9. Other Platforms
  10. By Decades

Would it be safe to assume that all threads follow that exact same pattern/order and post number?

Yes. The only difference is in the number of games that make it onto posts 2 and 3, and in the platform breakdowns. But the pattern's been the same every year.

Ryuu96 said:

@Mnementh @mZuzek 

Fuuuuck that was a lot.

First, I have to apologise, I messed up a little and completely forgot that in order for Bandorr to restore posts, they need to have been edited at least once, that is entirely on me, he told me that once before already but I completely forgot, essentially VGC has two tables databases, the Message table being the one deleted but it also has an Edit Message table which can recover comments if we know the ID.

Due to that, we could only restore one post in the 2018 thread though that method.

So instead we came up with another idea to insert 10 empty posts into the thread at the start, all under Mzuzek still, a bit tricky because there are valid post IDs to navigate but since we have the post IDs above and we knew those ones were definitely Mzuzek's we just assigned those post IDs to the newly created comments then I went into Wayback Machine and copied everything over.

If I've made any mistakes in the copy/pasting then I apologise, I'll let you look it over and see if everything is okay before moving onto 2019. Likely won't do it all in one day though, it was a decent amount of effort just for one thread But I think we should be able to restore 2019 with the same method and most of 2020/2021.

Thanks a lot to @Bandorr 

Hopefully I've explained that well.


gamrConnect Presents: Their 979 Greatest Games, as of 2018

Hang on, aren't all of the posts in these threads edited? I always post something random at first just to get the 10 posts before anyone else, then edit them afterward. It certainly seems like less work than what you did, but anyway, that's much appreciated too. I skimmed through it really fast but everything seemed fine except for the alignment of some things (to be fair it's a pain to center-align those long columns).

Also, hate to add more work into this, but there's also the thread I made celebrating 10 years of the event, I really hope we could get that one back too. Here

Either way it's nice to get back home and see all this, thanks a lot. I'll try to help from here on.

I didn't create the edit system. So I can't speak to it 100%. 

When you make a post - it isn't added to the edit table.  We will call the original post A)

When you edit that post (We will call this B)  A gets added to table. B is your main post, A is in the edit.

So if you make a blank post (That's A). Then edit it (With B). A gets added to the "edit table". B does not.  You'd have to have edited B for it to be added to the table.

You are bound to love Earthbound.