Vote System

<?php
session_start();
include('../config/db_conf.php');
$conn = mysqli_connect($host, $dbuser, $dbpass, $dbname);
$site = $_POST['site'];

$selectsite = "SELECT points, id FROM vote_sites WHERE id = '$site'";
$result = $conn->query($selectsite);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
    $vp = $row['points'];
    $siteid = $row['id'];
    }
}else{

}

$userip = $_SERVER['REMOTE_ADDR'];

if(isset($_SESSION['username'])) {
$select = "SELECT vote_time FROM vote_cooldown WHERE user_ip = '$userip' AND siteid='$siteid'";
$result = mysqli_query($conn, $select);
if (mysqli_num_rows($result) > 0) {
    while($row = mysqli_fetch_assoc($result)) {

        $votetime = $row['vote_time'];
        $time = time();

        if($time >= $votetime+43200) {
            $update = "UPDATE vote_cooldown SET vote_time='$time' WHERE user_ip = '$userip'";
            if (mysqli_query($conn, $update)) {
                echo "successfully added new time<br>";
            }else{
                echo "Failed to add new time" . mysqli_error($conn);
            }
            $updatevp = "UPDATE auth.account SET vp=vp+$vp WHERE username='" . $_SESSION['username'] . "'";
            if (mysqli_query($conn, $updatevp)) {
                echo "Successfully added vp to account " . $_SESSION['username'] . "";
            }else{
                echo "Failed to add vp to account " . $_SESSION['username'] . "";
            }
        }else{
            echo "You have already voted !";
        }

    }

}else{
    $inserttime = time();
    $insert = "INSERT INTO vote_cooldown (voted, account, user_ip, siteid, vote_time)
    VALUES('1', '" . $_SESSION['username'] . "', '$userip', '$siteid', '$inserttime')";
    if (mysqli_query($conn, $insert)) {}else{}
    $newupdate = "UPDATE auth.account SET vp=vp+$vp WHERE username='" . $_SESSION['username'] . "'";
    if (mysqli_query($conn, $newupdate)) {
        echo "successfully added new time<br>";
    }else{
        echo "Failed to add new time" . mysqli_error($conn);
    }
}
}else{
    echo "You need to login to be able to vote !";
}