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

Forums - Website Topics - Website Development / Feedback / Suggestions / Bug Reporting Thread

Okay lets run down what I found through 2018 via Wayback Machine.

2018

  1. https://gamrconnect.vgchartz.com/post.php?id=8956005 = Introduction.
  2. https://gamrconnect.vgchartz.com/post.php?id=8956006 = 979 to 368.
  3. https://gamrconnect.vgchartz.com/post.php?id=8956007 = 367 to 101.
  4. https://gamrconnect.vgchartz.com/post.php?id=8956010 = Top 100.
  5. https://gamrconnect.vgchartz.com/post.php?id=8956011 = Winner.
  6. https://gamrconnect.vgchartz.com/post.php?id=8956012 = Platform Breakdown: Nintendo.
  7. https://gamrconnect.vgchartz.com/post.php?id=8956013 = Platform Breakdown: Sony.
  8. https://gamrconnect.vgchartz.com/post.php?id=8956016 = Platform Breakdown: Microsoft.
  9. https://gamrconnect.vgchartz.com/post.php?id=8956017 = Other Platforms.
  10. https://gamrconnect.vgchartz.com/post.php?id=8956018 = By Decades.

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?



Around the Network
Ryuu96 said:

Okay lets run down what I found through 2018 via Wayback Machine.

2018

  1. https://gamrconnect.vgchartz.com/post.php?id=8956005 = Introduction.
  2. https://gamrconnect.vgchartz.com/post.php?id=8956006 = 979 to 368.
  3. https://gamrconnect.vgchartz.com/post.php?id=8956007 = 367 to 101.
  4. https://gamrconnect.vgchartz.com/post.php?id=8956010 = Top 100.
  5. https://gamrconnect.vgchartz.com/post.php?id=8956011 = Winner.
  6. https://gamrconnect.vgchartz.com/post.php?id=8956012 = Platform Breakdown: Nintendo.
  7. https://gamrconnect.vgchartz.com/post.php?id=8956013 = Platform Breakdown: Sony.
  8. https://gamrconnect.vgchartz.com/post.php?id=8956016 = Platform Breakdown: Microsoft.
  9. https://gamrconnect.vgchartz.com/post.php?id=8956017 = Other Platforms.
  10. https://gamrconnect.vgchartz.com/post.php?id=8956018 = By Decades.

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?

Yeah, as far as I can see @mZuzek used the same breakdown each year since he took over. Maybe he can say a bit more about it? Otherwise, I listed the Post-IDs as far as I could get them for these four years: https://gamrconnect.vgchartz.com/post.php?id=9430892



3DS-FC: 4511-1768-7903 (Mii-Name: Mnementh), Nintendo-Network-ID: Mnementh, Switch: SW-7706-3819-9381 (Mnementh)

my greatest games: 2017, 2018, 2019, 2020, 2021, 2022, 2023

10 years greatest game event!

bets: [peak year] [+], [1], [2], [3], [4]

Mnementh said:

OK, archive.org takes forever to load, but I have 2021 https://gamrconnect.vgchartz.com/thread.php?id=245741">here, and archive.org shows the 'View post' buttons, so I can extract the post-IDs.

https://gamrconnect.vgchartz.com/thread.php?id=245741">2021: 9352811, 9352812, 9352814, 9352815, 9352816, 9352818, 9352819, 9352821, 9352822 - the last post with decade overview and the yearly games, but it probably got the id ending on 23, 24 or 25.

https://gamrconnect.vgchartz.com/thread.php?id=244193">2020: 9267198, 9267199, 9267200, 9267201, 9267203, 9267204, 9267205 - here are sadly three posts not displayed by archive.org, the MS platforms, the other platforms and again decades and years. Again the following IDs should contain them, so 206-210 at the end.

https://gamrconnect.vgchartz.com/thread.php?id=241748">2019: 9100432, 9100433, 9100435, 9100436, 9100437, 9100438, 9100439, 9100441, 9100442, 9100443

https://gamrconnect.vgchartz.com/thread.php?id=239013">2018: 8956005, 8956006, 8956007, 8956010, 8956011, 8956012, 8956013, 8956016, 8956017, 8956018

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

Nice.

I'll start with 2018 and see if Bandorr can restore them when he has some free time.

Worse case scenario and he can't...Least a lot of data is available to copy/paste over into a new thread.



In the time it took me to get all the Post IDs for 2018. You found them all for 2019 and most for 2020/2021, Lol.

You're right that Wayback Machine is incredibly slow Thank you for doing that @Mnementh 



@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.

1/4.

gamrConnect Presents: Their 979 Greatest Games, as of 2018

Last edited by Ryuu96 - on 19 February 2023

Around the Network
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.

1/4.

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 https://gamrconnect.vgchartz.com/thread.php?id=243705

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



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.

1/4.

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 https://gamrconnect.vgchartz.com/thread.php?id=243705

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.

What makes it hard to restore?

Wouldn't you just load up the backup to say a fresh forum somewhere else? search via sql topic names or usernames to find the post IDs, then surely you just copy the record and do an inset statement on the existing site?

Also did another attack happen recently? Last one was what about 3 months ago or so? or a more recent one caused more drama?



 

 

Ryuu96 said:

Fair, I was sure the idea would be disliked, I know I can be weird about this stuff, Lol.

Would anyone be opposed to be going through the Hot Topics and locking some of the dead threads in favour of promoting more active ones?

As an example, do we need the Mafia threads open still? Do we need the OTs which haven't been posted in for 10 years? I can recreate my Community Thread and store them there as a handy look but I don't know if anyone needs to be able to comment in them anymore?

I'll need to go through anyway to see what is still broken and what isn't so I can see if anyone is willing to recreate.

Oxymoron, no? Hot topics is just a list of the threads by most recent post. If they're dead threads they shouldn't be on that list.

Although considering locking threads hides them from the Buddy etc. I'm generally against locking them unless there's an actual need. No recent posts doesn't really justify locking to me.

Last edited by Ka-pi96 - on 19 February 2023

Bandorr said:
mZuzek said:

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.

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 https://gamrconnect.vgchartz.com/thread.php?id=243705

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.

So it would be safer to say that we'll likely need multiple edits? Because a lot of people would begin their post with "Reserved"

Cobretti2 said:

What makes it hard to restore?

Wouldn't you just load up the backup to say a fresh forum somewhere else? search via sql topic names or usernames to find the post IDs, then surely you just copy the record and do an inset statement on the existing site?

Also did another attack happen recently? Last one was what about 3 months ago or so? or a more recent one caused more drama?

Way above my knowledge so I unfortunately don't know, I'll just copy & paste what Talon told me.

-

Ryuu09/01/2023 14:54

Did you ever make any progress on restoring at least a portion of our old comments?

TalonMan10/01/2023 19:08

Unfortunately, no - the link that I was hoping to use to attempt to link comments back, doesn't exist. So, I have a shit load of comments - but no idea what thread or user they belong to. 🙁

-

No recent attack, I just made this thread because the last had its OP contents deleted and I have some free time right now, so I figured I'd create this thread and at least inform everyone what is happening since it has been months now, then Mnementh mentioned Mzuzek's threads which yeah, in some cases, we may be able to restore specific comments but it's a one at a time thing.