//Vyplň údaje
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

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


    $username = $_SESSION["nick"]; //Uprav session/var
    $data = hex2bin(md5("OfflinePlayer:" . $username));
    $data[6] = chr(ord($data[6]) & 0x0f | 0x30);
    $data[8] = chr(ord($data[8]) & 0x3f | 0x80);
    $striped = bin2hex($data);
    $components = array(
        substr($striped, 0, 8),
        substr($striped, 8, 4),
        substr($striped, 12, 4),
        substr($striped, 16, 4),
        substr($striped, 20),
    );
    $uuid = implode('-', $components);

$resultpex = $conn->query('SELECT * FROM permissions_inheritance WHERE child = "'.$uuid.'"');
$rowpex = $resultpex->fetch_assoc();
echo "Rank: ";


//Přidej groupky do array
$pexarray = array(
  "owner" => "Správce",
  "vedeni" => "Vedení",
  "vip" => "VIP",
  "vip+" => "VIP+",
  "mvip" => "MegaVIP",
  "yt" => "Youtuber",
  "default" => "Hráč",
  NULL => "Hráč"
);

foreach ($pexarray as $pexdata => $pexgroup) {
  if ($pexdata == $rowpex["parent"]) {
    echo "$pexgroup";
  }
}
$conn->close();