xd

event onLoad(){
    database.execute("CREATE TABLE IF NOT EXISTS yRegions(
        Id VARCHAR(5) PRIMARY KEY,
        Name VARCHAR(255) NOT NULL,
        Node1 VARCHAR(255),
        Node2 VARCHAR(255)
    );");
}

event onInterval(0.5){
    foreach(player in server.players){
        if(regionPlayerEnter(player, "region") == true){
            player.message("You entered in 'region' region!");
        }
        else if(regionPlayerLeave(player, "region") == true){
            player.message("You leaved the 'region' region!", "red");
        }
    }
}

command cregion(arg){
    permission = "regions.create";
    execute(){
        if(isSet(arg)){
            x = database.execute("SELECT * FROM yRegions WHERE Name = '" + arg + "'");
            if(x.count == 0){
                database.execute("INSERT INTO yRegions (Id, Name) VALUES ('480" + random.int(1, 99) + "', '" + arg + "')");
                player.message("You have been created '" + arg + "' region!");
            }
            else{
                player.message("That region already exists!", "red");
            }
        }
        else{
            player.message("You need to say an region name!", "red");
        }
    }
}

command node(arg, arg1){
    permission = "region.nodes";
    execute(){
        if(isSet(arg) and isSet(arg1)){
            x = database.execute("SELECT * FROM yRegions WHERE Name = '" + arg + "'");
            if(x.count > 0){
                region = arg;
                nodeNumber = toNumber(arg1);
                if(nodeNumber == 1){
                    database.execute("UPDATE yRegions SET Node1 = '" + player.position.x + ", " + player.position.y + ", " + player.position.z + "' WHERE Name = '" + region + "'");
                    player.message("You have been seted Node1 in '" + region + "' region!");
                }
                if(nodeNumber == 2){
                    database.execute("UPDATE yRegions SET Node2 = '" + player.position.x + ", " + player.position.y + ", " + player.position.z + "' WHERE Name = '" + region + "'");
                    player.message("You have been seted Node2 in '" + region + "' region!");
                }
                else{
                    player.message("You need to say a Node Number (1-2)", "red");
                }
            }
            else{
                player.message("Can't find that region!", "red");
            }
        }
        else{
            player.message("You need to say an region and node number", "red");
        }
    }
}

function regionPlayerEnter(player, region){
    if(inRegion(player, region) == true){
        if(player.getData("region") == null){
            player.setData("region", region);
            return true;
        }
    }
}

function regionPlayerLeave(player, region){
    if(inRegion(player, region) == false){
        if(player.getData("region") == region){
            player.setData("region", null);
            return true;
        }
    }
}

//Put that function in your script
function inRegion(player, region){
    x = database.execute("SELECT * FROM yRegions WHERE Name = '" + region + "'");
    if(x.count > 0){
        x = x[0];
        node1 = x[2];
        node1 = node1.split(",");
        node2 = x[3];
        node2 = node2.split(",");

        nX = toNumber(node1[0]);
        nY = toNumber(node1[1]);
        nZ = toNumber(node1[2]);
        n2X = toNumber(node2[0]);
        n2Y = toNumber(node2[1]);
        n2Z = toNumber(node2[2]);

        x1 = null;
        x2 = null;
        z1 = null;
        z2 = null;
        y1 = null;
        y2 = null;

        if(nX < n2X){
            x1 = nX;
            x2 = n2X;
        }
        if(nX > n2X){
            x1 = n2X;
            x2 = nX;
        }
        if(nY < n2Y){
            y1 = nY;
            y2 = n2Y;
        }
        if(nY > n2Y){
            y1 = n2Y;
            y2 = nY;
        }
        if(nZ < n2Z){
            z1 = nZ;
            z2 = n2Z;
        }
        if(nZ > n2Z){
            z1 = n2Z;
            z2 = nZ;
        }

        pos = player.position;
        if(pos.x > x1 and pos.x < x2 and pos.y > y1 and pos.y < y2 and pos.z > z1 and pos.z < z2){
            return true;
        }
        else{
            return false;
        }
    }
    else{
        return false;
    }
}