<?php


$host = "160.20.145.65";
$user = "root";
$pass = "BRp98THGsFfN4KUQ";
$data = "account";

$con = new mysqli($host, $user, $pass, $data);

if($con->connect_errno)
{
	printf("Es konnte keine verbindung zur datenbank Hergestellt werden %s\n", $con->connect_error);
}


$id = $con->real_escape_string($_GET['id']);


		if($query = $con->query("INSERT INTO vote4coins (user,time) VALUES ('$id',now())"))
		{
			echo "1";
			$query = $con->query("UPDATE account SET coins = coins + 5 WHERE login = '$id'");
		}
		else
		{
			echo "0";
		}
$loeschen = "DELETE FROM vote4coins WHERE time < TIMESTAMP(DATE_SUB(NOW(), INTERVAL 1440 minute));";
$loesch = mysqli_query($con, $loeschen);

?>