How to list server status on a private server

[Maze_EQ]

/who all

/10char

[Akkadius]

There are many ways to do this.

One of which is to query the character table now that it doesn't have the blob stuck in it, it actually makes sense to query it live from an external source versus the time it would take the index when the blob was in existence.

SELECT id, name, FROM_UNIXTIME(last_login) FROM character_data WHERE (last_login > UNIX_TIMESTAMP() - 600)

This essentially gets players that have been active within the last 10 minutes. This won't reflect the same as the server list per se (all of the time) but it is still just as accurate

[provocating]

Originally Posted by Akkadius

There are many ways to do this.

One of which is to query the character table now that it doesn't have the blob stuck in it, it actually makes sense to query it live from an external source versus the time it would take the index when the blob was in existence.

SELECT id, name, FROM_UNIXTIME(last_login) FROM character_data WHERE (last_login > UNIX_TIMESTAMP() - 600)

This essentially gets players that have been active within the last 10 minutes. This won't reflect the same as the server list per se (all of the time) but it is still just as accurate

I like doing it this way better than the old way we had to

[starblight]

Originally Posted by Maze_EQ

/who all

/10char

What dose /10char do I tried it and got a error I never even thought about /who all working so used to the server being too full. thanks for these tips I will defiantly use them but I was looking for more in line what Akkadius posted so I can check without logging into a client.

Thank you Akkadius for following up with exactly what I was looking for.

[sculler]

Originally Posted by starblight

What dose /10char do I tried it and got a error

I found it extremely amusing that you typed the command /10char in Everquest. Sounds like something I would do