Here is a mysql command to find out who is a GM on your server.
You probably already know the command though. xD
PHP Code:
SELECT name
FROM `characters`
WHERE gm > 0
You can obviously change it around to suit your needs
PHP Code:
SELECT name
FROM `characters`
WHERE gm = 1
That would make it so it selects all characters with the GM Level of 1. (Change characters to accounts if you want.)
PHP Code:
SELECT `level`, `name`, `str`, `dex`, `luk`, `int`
FROM `characters`
WHERE level = 200
This would make it find all the level 200's along with the stats of them.
PHP Code:
SELECT `name`, `banned`
FROM `accounts`
WHERE banned = 1
Lists the banned people from the server.
If you need the codes for listing any others, just post here and i'll try an reply asap.
PS: Instead of making it three lined, you can merge it to one line (Ex: SELECT name FROM `characters` WHERE gm > 0)
Reply With Quote
