Virtual Licences

event onLoad(){
    database.execute("CREATE TABLE playerlicences(
    id VARCHAR(17) PRIMARY KEY,
    Armas INT NOT NULL DEFAULT 0,
    Conducir INT NOT NULL DEFAULT 0
    );");
}

event onPlayerJoined(player){
    x = database.execute("SELECT * FROM playerlicences WHERE id = '" + player.id + "';");
    if(x.count == 0){
        database.execute("INSERT INTO playerlicences (id, Armas, Conducir) VALUES ('" + player.id + "', 0, 0);");
    }
}

command LicenciaVehiculo() {
	permission = "licencia";
	execute() {
		if(player.experience > 5000){
			database.execute(str.format("UPDATE playerlicences SET Conducir = Conducir + 1 WHERE id = '{0}';", player.id));
			player.experience = player.experience - 5000;
			player.message("Has comprado la licencia de conducir correctamente.", "blue");
		} else {
			player.message("No tienes el dinero suficiente", "red");
		}
	}
}

command LicenciaArma() {
	permission = "licencia";
	execute() {
		if(player.experience > 5000){
			database.execute(str.format("UPDATE playerlicences SET Armas = Armas + 1 WHERE id = '{0}';", player.id));
			player.experience = player.experience - 5000;
			player.message("Has comprado la licencia de armas correctamente.", "blue");
		} else {
			player.message("No tienes el dinero suficiente", "red");
		}
	}
}

event onPlayerRespawned(player, position){
	database.execute(str.format("UPDATE playerlicences SET Armas = 0 WHERE id = '{0}';", player.id));
	player.message("Has perdido la licencia de armas", "red");
	database.execute(str.format("UPDATE playerlicences SET Conducir = 0 WHERE id = '{0}';", player.id));
	player.message("Has perdido la licencia de conducir", "red");
}


command check(myArgument){
	permission = "licencia.check";
	execute() {
		if(isSet(myArgument)){
			argPlayer = toPlayer(myArgument);
			if(arguments.count < 2){
				y = database.execute(str.format("Select * FROM playerlicences WHERE id = '{0}';", argPlayer.id));
				y = y[0];
				Armas = y[1];
				Conducir = y[2];
				player.message("El jugador tiene " + Armas + " licencias de armas y " + Conducir + " de conducir");
			}
			else {
				player.message("Error", "red");
			}
		}
	}
}

command licencias(){
    permission = "licencia";
    execute(){
        y = database.execute(str.format("Select * FROM playerlicences WHERE id = '{0}';", player.id));
        y = y[0];
        Armas = y[1];
        Conducir = y[2];
        player.message("Licencias de conducir: " + Conducir);
        player.message("Licencias de armas: " + Armas);
    }
}