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

// 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 getServerName($x, $z) {
    $server = exec('java -jar RunnableRaster.jar '.$x.' '.$z);
    switch ($server) {
        case 1:
            $serverName = "noord";
            break;
        case 2:
            $serverName = "midden";
            break;
        case 3:
            $serverName = "zuid";
            break;
        case 0:
            $serverName = "buitenNL";
            break;
        default:
            $serverName = "buitenNL";
            break;
    }
    return $serverName;
}

//
// Main
//
$files = scandir('.',1);
foreach($files as $value){
    if(strpos($value, '.yml') !== false){
        $file = yaml_parse_file($value);
        //var_dump($file);
        $warpname = substr($value, 0, -4);
        $x = $file['x'];
        $y = $file[1];
        $z = $file['z'];
        $yaw = $file['yaw'];
        $pitch = $file['pitch'];
        $servername = getServerName($x, $z);

        echo "Warp: ".$warpname." | x:".$x." y:".$y." z:".$z." | is in server: ".$servername."\n";

        $sql = "INSERT INTO BungeeWarps (warpname, server, world, x, y, z, yaw, pitch, hidden, global) VALUES ('$warpname', '$servername', 'world', '$x', '$y', '$z', '$yaw', '$pitch', 0, 1)";
        if ($conn->query($sql) === TRUE) {
            echo "New record created successfully \n";
        } else {
            echo "Error: " . $sql . "\n" . $conn->error . "\n";
        }
    }
}
?>