- makegm.png (90.96 KiB) Viewed 3588 times
The line
.explain on is not required. it is just for seeing the column name headers in the output of select statements.
The select statements are not required either. I just used them to show the change made by the update command by requesting a list of all accounts and their access levels before and after the update.
I got only one account right now on my test server, but on a live server you would have - depending on how popular you are - a few hundred to several thousand accounts. So it is useful to get the access level of an individual account:
Code: Select all
SELECT level FROM mana_characters WHERE username="Adrian";
or a list of everyone you gave special privileges through an SQL command or through the @givepermission command ingame.
Code: Select all
SELECT username, level FROM mana_characters WHERE level > 1;
There is a lot more you can find out or do on Manaserv through SQL commands. When you are interested in learning some more advanced SQL wizardry I can recommend the website
http://sqlzoo.net