<?php
include 'dbconnect.php';
$site = $_GET['_site'];
$imgid = intval($_GET['_id']);
$input = $_GET['_choice'];


if ($site == "artwork") {
   $table = "artwork";
}
else {
   $table = "comics";
}

$result = $mysqli->query("SELECT like_szam, dislike_szam FROM $table WHERE id = $imgid");

list($likes, $dislikes) = $result->fetch_array(MYSQLI_NUM);

$sql = "INSERT INTO
            votes (ip, table_name, imgid)
        VALUES
            (\"".$_SERVER['REMOTE_ADDR']."\", \"$table\", $imgid)
        ON DUPLICATE KEY UPDATE
            ip = VALUES(ip),
            table = VALUES(table),
            imgid = VALUES(imgid)";

$mysqli->query($sql);
echo $mysqli->error;
echo "<br/>";

$sql = "SELECT ip FROM votes WHERE ip = '".$_SERVER['REMOTE_ADDR']."' AND table_name = '$table' AND imgid = $imgid";

$result = $mysqli->query($sql);
echo $mysqli->error;

if ($result->num_rows == 0) {
    if ($input == "like") {
        $sql = "UPDATE $table SET like_szam = like_szam + 1 WHERE id = $imgid";
        $mysqli->query($sql);
        $likes++;
    }
    else if ($input == "dislike") {
        $sql = "UPDATE $table SET dislike_szam = dislike_szam + 1 WHERE id = $imgid";
        $mysqli->query($sql);
        $dislikes++;
    }
echo "Szeretem: " . $likes . ", Nem szeretem: " . $dislikes;
}
else {
    echo "Te már szavaztál!";
}
mysqli_close($mysqli);

?>