Tutorial: Custom GM Ranks for Ascent/ArcEmu

Excerpt for another forum....not attempted yet...will change when completed.



Custom GM ranks can be extremely useful for all GM private servers (so people don't continuously spawn NPCs and GOs), donation rewards, and all other private servers (to ensure that the GMs you recruit don't go spawning random stuff, teleporting randomly, and being overall noobs).

First up we'll create a GM rank for a Blizz-like private server. Lets say that you're starting to recruit new GMs and you don't want noobs, so we'll create a custom GM rank.

Firstly, open up your database editor, open up your connection, then the database 'world'. Now, head into the table called 'command_overrides'. In the left hand column type the first command you want your GM rank to have. To do this just type the full command without the dot. I will use 'recall'. Now in the right hand column type a letter (NOT A or Z). I will use the letter 'g'. That means that so far your GM rank has one command, however, it has no subcommands. To add subcommands make a new entry, in the left hand column type the subcommand. The subcommand I would like to add is 'recall port'. Then in the right hand column I will put 'g'.

So far mine looks like this:

Code:
recall g
recall port g
Continue adding commands like that until you think you've added all you need.

In the end, mine looked like this:

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('recall', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('recall port', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('recall list', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('gmticket getID', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('gmticket delID', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('gmticket remove', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('gmticket toggle', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('gmticket getID', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('gmticket', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('gmticket get', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('summon', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('commands', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('ban char', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('unban char', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('kick', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('revive', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('reviveplr', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('server saveall', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('help', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('appear', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('gm list', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('gm on', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('gm off', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('invisible', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('char learn', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('char unlearn', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('char learnskill', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('char additem', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('char removeitem', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('playerinfo', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('paralyze', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('unparalyze', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('gm blockwhispers, 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('gm allowwhispers', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('kick byplayer', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('kick byaccount', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('ban ip', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('unban ip', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('lookup item', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('lookup skill', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('lookup spell', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('char forcerename', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('gmannounce', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('announce', 'g');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('ban account', 'g');





Execute that code into your database and voila! A custom GM rank which will reduce noob GMs mucking around by a lot!

On all GM servers, usually you can donate for more GM commands. I have made a custom rank that would be good for players to start with on an all GM server. Here it is:


INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('commands', 'p');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('gps', 'p');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('worldport', 'p');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('cheat', 'p');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('cheat god', 'p');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('cheat fly', 'p');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('character', 'p');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('character additem', 'p');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('character removeitem', 'p');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('character repair', 'p');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('lookup', 'p');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('lookup item', 'p');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('lookup spell', 'p');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('modify', 'p');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('modify level', 'p');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('modify displayid', 'p');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('recall', 'p');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('recall port', 'p');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('recall list', 'p');


And then a suggestion for a donor rank is the following (you probably should modify it if you want a .gobject donation pack and .npc and so on...):

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('recall add', 'd');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('gobject', 'd');
INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('gobject spawn', 'd');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('gobject select', 'd');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('gobject delete', 'd');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('npc', 'd');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('npc spawn', 'd');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('npc select', 'd');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('npc select', 'd');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('lookup object', 'd');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('lookup creature', 'd');

INSERT INTO command_overrides
(`command_name`, `access_level`)
VALUES
('modify speed', 'd');


Execute that into your DB and you have a donor GM rank.

To make an account a certain rank go into the database 'characters' then go into the table 'account_names'. Find the account name and scroll sideways until you find the column that says 'gm'. In that column type the letter that your custom GM rank is...

Note: If you want to make a player a donor rank, using my example you would set their 'gm' to 'pd' or 'dp'. That means that the account has the player and the donor commands!