[Question] How to AUTOMATICALLY make accounts GM?

[knif3r2]

So I'm creating a GM server on my own accord. I just want to figure out how I can set the "account_access\gm_level" to 3 when the accounts are created.. Is there a way I can do this through setting a default value in the colum of the DB?


Using [Trinity] Trees Repack 3.3.5

[DoxramosPS]

Easiest way would be to make your account creation page insert 1,2 or 3 into gmlevel during the SQL Query. Theoretically you could set all the permissions of everything to a lower level, but that just seems like more of a hassle; also. Be careful on what you let everyone do on an all GM server :P. Last thing. If you want to start running publicly I would look into compiling and not so much using a repack.

[knif3r2]

Easiest way would be to make your account creation page insert 1,2 or 3 into gmlevel during the SQL Query. Theoretically you could set all the permissions of everything to a lower level, but that just seems like more of a hassle; also. Be careful on what you let everyone do on an all GM server :P. Last thing. If you want to start running publicly I would look into compiling and not so much using a repack.

If anyone can, I have the file for the website. Can you make it so it can change the account_access -> gmlevel = 3 on account creation?

Download: Functions.php
Filebeam - Beam up that File Scottie!

If I would to add it myself, would this be correct?

$sql = $query("INSERT INTO $db_a.account_access (gmlevel, RealmID) VALUES ('3', '-1')")or die(mysql_error());

[myran2]

Add these two lines after both registration queries:

$accId = $query("SELECT id FROM $db_a.account WHERE username='$username'")or die(mysql_error());
$sql1 = $query("INSERT INTO $db_a.account_access (id, gmlevel) VALUES ($accId, 3)") or die(mysql_error());

[Harambeqt]

Add these two lines after both registration queries:

$accId = $query("SELECT id FROM $db_a.account WHERE username='$username'")or die(mysql_error());
$sql1 = $query("INSERT INTO $db_a.account_access (id, gmlevel) VALUES ($accId, 3)") or die(mysql_error());

Can't you just make the flag "AZ" or "3" Auto-set on all new accs in the sql table ?

[DoxramosPS]

Can't you just make the flag "AZ" or "3" Auto-set on all new accs in the sql table ?

Not that I know of off the top of my head; He's using a repack. I'm sure you could do it on a self compile, but as far as the repack goes he should be able to just set the query.

[myran2]

You can't do that because gmlevels are stored in a different table.
Even if you compile your own core, it still takes a bit of hacking around to make it read the gmlevel from a different location.