<?php
$servername = "localhost";
$username = "id3513529_admin";
$password = "abc123";
$dbname = "id3513529_data1";
$worldpass = "testpass1";

$conn = new mysqli($servername, $username, $password, $dbname);

$found = 0;
$out = "error";

if(base64_decode($_GET["arg"]) == $worldpass)
{
    $requestuuid = $_GET["key"];
    $sql = "SELECT uuid FROM VoxValues";
    $result = $conn->query($sql);
    while($dump = $result->fetch_assoc())
    {
        if($dump["uuid"] == $requestuuid)
        {
            $found = 1;
        }
    }

    if($found == 1)
    {
        $sql = "SELECT 'denarii', 'honor' FROM 'VoxValues' WHERE uuid='".$requestuuid."'";
        $result = $conn->query($sql);
        while($dump = $result->fetch_assoc())
        {
            $out = "0:denarii:".$dump["denarii"].":".$dump["honor"];
        }
    }

    if($found == 0)
    {
        $sql = "INSERT INTO `VoxValues` (`uuid`, `denarii`, `honor`, `url`, `joined`) VALUES ('".$requestuuid."', '0', '0', '".$_GET["end"]."', CURRENT_TIMESTAMP)";
        $result = mysqli_query($conn,$sql);
        if($result == TRUE)
        {
            $out = "1:denarii:0:honor:0";
        }

        else $out = "error99";
    }
}

else $out = "error2";

echo $out;
if($conn)$conn->close();