.

//Eventos
event onLoad(){
    database.execute("CREATE TABLE IF NOT EXISTS Niveis(
        Steamid VARCHAR(17) PRIMARY KEY,
        Nome VARCHAR(255),
        Tempo INT NOT NULL DEFAULT 0,
        Level TINYINT NOT NULL DEFAULT 0,
        Progresso INT NOT NULL DEFAULT 0
    );");
}

event onPlayerJoined(player){
    DB = database.execute("SELECT * FROM Niveis WHERE Steamid = '" + player.id + "'");
    if(DB.count == 0){
        database.execute("INSERT INTO Niveis (Steamid, Nome) VALUES ('" + player.id + "', '" + player.name + "')");
    }
}

event onInterval(60){
    foreach(player in server.players){
        DB = database.execute("SELECT * FROM Niveis WHERE Steamid = '" + player.id + "'");
        if(DB.count != 0 ){
            DB = DB[0];
            database.execute("UPDATE Niveis SET Tempo = Tempo + 1 WHERE Steamid = '" + player.id + "'");
            if(toInt(DB[3]) < 120){
                database.execute("UPDATE Niveis SET Progresso = Progresso + 1 WHERE Steamid = '" + player.id + "'");
            }
        }
    }
}

event onInterval(30){
    foreach(player in server.players){
        DB = database.execute("SELECT * FROM Niveis WHERE Steamid = '" + player.id + "'");
        DB = DB[0];
        pProgresso = DB[4];
        pLevel = DB[3];
        pProgresso = toNumber(pProgresso);
        if(pProgresso == 60 or pProgresso > 60){
            database.execute("UPDATE Niveis SET Progresso = Progresso - 60 WHERE Steamid = '" + player.id + "'");
            database.execute("UPDATE Niveis SET Level = Level + 1 WHERE Steamid = '" + player.id + "'");
            player.message("<color=#00fbff>[Nível] </color><color=#ffffff>Você upou</color><color=#00e85d> 1 nível</color><color=#ffffff> e recebeu seu salário!</color>");
            if(player.hasPermission("vip")){
                player.experience = player.experience + 800;
                player.message("<color=#00fbff>[Nível] </color><color=#ffffff>Você recebeu o seu </color><color=#f0e113>salário VIP</color><color=ffffff>.</color>");
            }
            player.message("<color=#00fbff>[Nível] </color><color=#ffffff>Você antes era nível </color><color=#f0e113>" + pLevel + "</color><color=#ffffff>.</color>");
            if(player.hasPermission("mendigo")){
                player.experience = player.experience + 150;
            }
            if(player.hasPermission("entregadordejornal")){
                player.experience = player.experience + 150;
            }
            if(player.hasPermission("entregadordepizza")){
                player.experience = player.experience + 150;
            }
            if(player.hasPermission("taxista")){
                player.experience = player.experience + 150;
            }
            if(player.hasPermission("gari")){
                player.experience = player.experience + 150;
            }
            if(player.hasPermission("coveiro")){
                player.experience = player.experience + 150;
            }
            if(player.hasPermission("fotografo")){
                player.experience = player.experience + 150;
            }
            if(player.hasPermission("carteiro")){
                player.experience = player.experience + 150;
            }
            if(player.hasPermission("lixeiro")){
                player.experience = player.experience + 150;
            }
            if(player.hasPermission("eletricista")){
                player.experience = player.experience + 150;
            }
            if(player.hasPermission("padre")){
                player.experience = player.experience + 150;
            }
            if(player.hasPermission("pescador")){
                player.experience = player.experience + 150;
            }
            if(player.hasPermission("motoristadeonibus")){
                player.experience = player.experience + 150;
            }
            if(player.hasPermission("fazendeiro")){
                player.experience = player.experience + 150;
            }
            if(player.hasPermission("minerador")){
                player.experience = player.experience + 150;
            }
            if(player.hasPermission("caçador")){
                player.experience = player.experience + 150;
            }
            if(player.hasPermission("reparadorderadares")){
                player.experience = player.experience + 150;
            }
            if(player.hasPermission("reparadordeturbinas")){
                player.experience = player.experience + 150;
            }
            if(player.hasPermission("caminhoneiro")){
                player.experience = player.experience + 150;
            }
            if(player.hasPermission("transportadordeconcreto")){
                player.experience = player.experience + 150;
            }
            if(player.hasPermission("leitero")){
                player.experience = player.experience + 150;
            }
            if(player.hasPermission("lenhador")){
                player.experience = player.experience + 150;
            }
            if(player.hasPermission("transportadordeminérios")){
                player.experience = player.experience + 150;
            }
            if(player.hasPermission("cientista")){
                player.experience = player.experience + 150;
            }
            if(player.hasPermission("piloto")){
                player.experience = player.experience + 150;
            }
            if(player.hasPermission("segurançadecarroforte")){
                player.experience = player.experience + 150;
            }
            if(player.hasPermission("motoristadecarroforte")){
                player.experience = player.experience + 150;
            }
            if(player.hasPermission("transportadordecombustíveis")){
                player.experience = player.experience + 150;
            }
            if(player.hasPermission("maquinista")){
                player.experience = player.experience + 150;
            }
            if(player.hasPermission("capitaonautico")){
                player.experience = player.experience + 150;
            }
            player.addGroup(toInt(pLevel) + 1);
        }
    }
}

// Comandos
command nivel(){
    permission = "nivel";
    execute(){
        DB = database.execute("SELECT * FROM Niveis WHERE Steamid = '" + player.id + "'");
        DB = DB[0];
        pLevel = DB[3];
        pTempo = DB[2];
        pProgresso = DB[4];
        player.message("Nível: " + pLevel + ".");
    }
}

command playtime(){
    permission = "playtime";
    execute(){
        DB = database.execute("SELECT * FROM Niveis WHERE Steamid = '" + player.id + "'");
        DB = DB[0];
        pTempo = DB[2];
        player.message("Você tem " + pTempo + " minutos de jogo em nosso servidor.");
    }
}

command up(){
    permission = "up";
    execute(){
        DB = database.execute("SELECT * FROM Niveis WHERE Steamid = '" + player.id + "'");
        DB = DB[0];
        pTempo = DB[2];
        pProgresso = DB[4];
        player.message("Você está a " + pProgresso + "% de upar.");
    }
}