I'm pretty sure the article declares the game was programmed in exactly the way you are suggesting it should be, where you only get the information required at the time it's needed, and you only send actions for yourself.

The exploit was that one was able to set up a second client and connect to the currently ongoing game but in the opponents seat, once this was done they could sene actions as the opponent including the forfeit action.

Just incase you didn’t know, cs:go is still available and a lot of surf/kz servers are still active.

If you want to know how to access cs:go you can check out this vid https://youtu.be/A8cWDxqOG2k?si=w4xdxmRntqKLtYg0

It’s really simple and I would have wrote the steps here but I’m not at my computer atm.

You don’t happen to have a link to the home exercises or know anything similar I could follow?

Nope, sorry mate. It was a long time ago. I did find [1] which seems similar-ish (I have no idea what "w3resource" is) but I think our schema back then had a lot more tables and the questions were a bit more diverse.

[1] https://www.w3resource.com/sql-exercises/employee-database-e...

A bunch of the leetcode like interviewing sites have SQL sections, like hacker rank