new cmdlvl;

forward GetCommandPermission(cmd[]);
public GetCommandPermission(cmd[])
{
    format(Query, sizeof (Query), "SELECT Level FROM `Commands` WHERE `Name` = '%s'", cmd);
    mysql_query(Query);
    mysql_store_result();
    cmdlvl = mysql_fetch_int();
    mysql_free_result();
    return 1;
}

YCMD:test(playerid, params[], help)
{
    #pragma unused params
    GetCommandPermission("test");
    if (help) {
        // Help function
    }
    else {
        if (pStats[playerid][pAdminLevel] >= cmdlvl) {
            SendClientMessage(playerid, COL_WHITE, "Command /test works perfectly normal!");
        }
        else {
            SendClientMessage(playerid, COL_WHITE, "You do not have permissions to use this command!");
        }
    }
    return 1;
}




/* Database



CREATE TABLE IF NOT EXISTS `commands` (
  `Name` varchar(30) NOT NULL,
  `Level` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `commands` (`Name`, `Level`) VALUES
('test', 1);*/