<?php
//
// DB Connect
//
$servername = "localhost";
$username = "server";
$password = "GeoFortDatabase123@";
$dbname = "wg";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

//
// Functions
//
function getServer($x, $z) {
    return exec('java -jar '.$x.' '.$z);
}

function getServerNumber($x, $z) {
    $server = exec('java -jar RunnableRaster.jar '.$x.' '.$z);
    switch ($server) {
        case 1:
            $serverName = 4;
            break;
        case 2:
            $serverName = 5;
            break;
        case 3:
            $serverName = 6;
            break;
        case 0:
            $serverName = 6;
            break;
        default:
            $serverName = 6;
            break;
    }
    return $serverName;
}

//
// Main
//
$sql = "SELECT * FROM `region`";
$result = $conn->query($sql);
while($row = $result->fetch_assoc()){
    switch($row['type']) {
        case 'cuboid':
            $id = $row['id'];
            $sql2 = "SELECT * FROM `region_cuboid` WHERE region_id='$id'";
            $result2 = $conn->query($sql);
            while($row2 = $result2->fetch_assoc()){
                $number = getServerNumber($row2['min_x'], $row2['min_z']);
                $sql3 = "UPDATE `region` SET world_id=$number WHERE id='$id'";
            }
            break;
        case 'poly2d':
            $id = $row['id'];
            $sql2 = "SELECT * FROM `region_poly2d_point` WHERE region_id='$id' LIMIT 1";
            $result2 = $conn->query($sql);
            while($row2 = $result2->fetch_assoc()){
                $number = getServerNumber($row2['x'], $row2['z']);
                $sql3 = "UPDATE `region` SET world_id=$number WHERE id='$id'";
            }
            break;
    }
}

?>