Experienced Elementalist
- Joined
- Jul 19, 2011
- Messages
- 288
- Reaction score
- 32
Here is a mysql command to find out who is a GM on your server.
You probably already know the command though. xD
You can obviously change it around to suit your needs
That would make it so it selects all characters with the GM Level of 1. (Change characters to accounts if you want.)
This would make it find all the level 200's along with the stats of them.
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)
You probably already know the command though. xD
PHP:
SELECT name
FROM `characters`
WHERE gm > 0
You can obviously change it around to suit your needs
PHP:
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:
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:
SELECT `name`, `banned`
FROM `accounts`
WHERE banned = 1
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)
Last edited: