Greetings, I am here with another guide!
Some people are having trouble with making everyone a Game Master on the signup page, well I am here to show you how you can enable it so when a character signs up they are Game Master!
Firstly, you need to go to your WAMP directory or your website directory wherever it is being hosted and open up " account.php " in notepad.
Find this line:
INSERT INTO `accounts` (`login`,`password`,`lastip`, `email`, `flags`) VALUES ('".mysql_real_escape_string($_POST['login'])."', '".mysql_real_escape_string($_POST['password'][0])."', '".$_SERVER['REMOTE_ADDR']."', '".mysql_real_escape_string($_POST['email'])."', '8')";
Then change it to this:
INSERT INTO `accounts` (`login`,`password`,`gm`,`lastip`, `email`, `flags`) VALUES ('".mysql_real_escape_string($_POST['login'])."', '".mysql_real_escape_string($_POST['password'][0])."','az', '".$_SERVER['REMOTE_ADDR']."', '".mysql_real_escape_string($_POST['email'])."', '8')";
I have highlighted the parts in green to show you what they mean and tell you they are changeable, please read this!
" az " : Is to make the person Game Master with all commands instead of just administrator commands.
" 8 " : This makes their account burning crusade enabled.
If you want to change them do this:
" az " : This not only makes them a Game Master but gives them admin commands on the server too, if you do not want them to have admin commands, take away the " a " which stands for game master commands!
" 8 " : This makes their account burning crusade enabled. If you do not want it burning crusade enabled change this to " 0 " or " " - which is nothing.
Thanks to: ArrakisOr you simply trigger it at the source .. so no matter from what website or tool you create an account, it will always be GM.
Create trigger bir_accounts
before insert on logon.accounts
For each row
begin
set new.gm='az';
end;
Hope that helps!
Note, I am not here to answer questions, this will work if you have done it correctly!