Hi,
the serverlist is stored in a MySQL database on a debian root server.
Everyone can host games. But what, when the internet connection of the hosting gamer is interrupted?
The server is still in the serverlist, but in reality it doesn't exist anymore.
How to remove the "server corpses"?

- Let the server do "cronjobs" every minute to check if he can connect to the server.

But how to do that? I could code a program using winsock, that runs on the server. The problem: How to connect to an ANet game server without calling the EVENT_CONNECT events.

Any suggestions how to do this and cleanup the serverlist?

We send updates. If a server on the list isn't updated after waiting for 60 seconds, then that means the server is not running any more.

Then (if I remember correctly) every time someone attempts to download the list of servers, we run a code to check which server entries in the list have not been updated during the past 60 seconds, and those are deleted before returning the server list to the one who requested it.

May not be the best method, but it works great for us.

Yes, thats a solution without an external cleaner program. It is not the fastest, but possible. Thanks .
Other suggestions are still welcome.

I've once used the same method as Germanunkol, it worked ok.

problem was that the few servers made by players were usually unconnectable because the users didn't forward the ports the server needed. They didn't know their servers were unconnectable and they stayed in the list because regular updates were send.

Others players quickly got frustrated when they couldn't connect to any game.

A much cleaner solution would be server-side checking for the "connectablility" of the servers. You could try to connect via raw UDP with ANET and PHP (if UDP is allowed on your server), or you'd have to use an external program.

You can open an UDP socket with PHP?
Great, I will check it out.
We have root access to our, server I think this won't be the problem.

Why not use NAT-PMP and/or UPnP to open the ports? The players want to play the game, not play with their routers. (I know that this is Off-Topic)

That's a point we can think about if the game is ready.
There is also Warcraft III, a very popular game, where the host has to open the port manually, but it is still very succesfull. I hope, that won't be the problem.

The serverlist template of ANet does it exactly this way. This method is great because it can be done in PHP+SQL without a special program or setting on the server.



You could also implement the first methode and let the client (the one who is searching) check if he can connect to the servers in the list. This way you can also get informations about the ping to the server.

how would you accomplish that check? i mean, not like you can make him join all the servers and disconnect.. [srry, not a pro at mp just yet]

You could do it with sockets. Every server has an opened udp socket and the client tries to send a packet to them and waits for an acknowledge packet. ANet although only supports one udp socket opened at the same time so this would be slow. But if you access the windows socket functions from Lite-C you could open more sockets at the same time => faster
But I never tested this, so it's possible that this idea won't work good/fast enough.

Checking it through a timestamp in the sql db is also no bad methode at all. So the decision is yours if you think it's worth to try the socket based methode. I never did...