Editing command permission levels

[Forsight]

I've been looking around on the forums to find a solution, yet couldn't really find anything to help me. The problem is that I'm currently running an RP server and since we're starting to get a proper playerbase me and the shared owner decided to allow only a few commands to be used by normal players. The point where I get stuck is that the accounts I've assigned to be normal members (permissions equal to '0') don't have access to a single command I've assigned to their security level. I go into commands.sql, change the security values to 0 so that only said rank and higher can use the regarding command, yet nobody with lower than administrative status, except for moderators, are able to use a single command.

For example, I'd like to allow the use of '.character additem' to everyone, even though only Mods+ can use them atm. The message it'd display ingame is not more than the command in the chatbox. In this case it shows up <insertplayername> says: .char additem.

Would be grateful if anyone came up with a solution. Thanks in advance.

[The-Eradicator]

I don't know anything about ArcEmu, but unless i'm misunderstanding, you're editing an SQL file.

This does not actually change the database. You will have to edit the relevant table in the database using Navicat or SQLyog.

[Forsight]

That's what I'm doing, ofcourse, using SQLyog.

[Zymus]

It sounds like the SQL information isn't the problem, but rather where it reads the character's permissions from the SQL and saves that variable. For example, something like:

Pseudo-code:

if(cmdArgs[0].equals(".char")) {
    if(cmdArgs[1].equals("additem")) {
        player.addItem(args[2], args[3]);//add id, amoutn
    }
}

And seeing this, you do something like:

if(cmdArgs[0].equals(".char") && player.getPermissions() == 0) {//Normal Player
    if(cmdArgs[1].equals("additem")) {
        player.addItem(args[2], args[3]);//add id, amoutn
    }
}

And that might cause the problem:

if(player.getPermissions() == 1) {
//250 lines of previous commands here
    if(cmdArgs[0].equals(".char") && player.getPermissions() >= 0) {//Normal Player
        if(cmdArgs[1].equals("additem")) {
            player.addItem(args[2], args[3]);//add id, amoutn
        }
    }
//More commands after this...
}

So that the program is never executing that particular command because it's seeing "Oh, you typed in .char, so that's fine but, UH OH you don't have the required permissions as stated before at the beginning of the block, so let's ignore this command."



Or another possible explanation is that you might have done > instead of >=. The first would make sense for your problem, because you might be doing:

if(cmdArgs[0].equals(".char") && player.getPermissions() > 0) {//Allow anyone with permissions GREATER THAN 0 to execute this command

Whereas you want to be doing:

if(cmdArgs[0].equals(".char") && player.getPermissions() >= 0) {//Allow anyone with 0 or higher to execute this command

The only way we could tell for sure is if you posted your edit to the commands.

[Forsight]

I feel like this might be the solution, even though I'm not very sure where I can locate these codes you're speaking off. So if you could tell me the location or type of one such file, that'd be great. Thanks for the effort by the way.

[Forsight]

Sadly, I'll have to bump.

[Zymus]

What base are you using?

EDIT: Nevermind, lol.

I'll download the ArcEmu source and see where it might be.

[Forsight]

Problem was not yet solved. I tried some things without succes and I wouldn't like mutiny.