0) {
//Function to add if a row exist
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 account='" . $_SESSION['username'] . "'";
if (mysqli_query($conn, $update)) {
echo "successfully added new time
";
}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, vote_time)
VALUES('1', '" . $_SESSION['username'] . "', '$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
";
}else{
echo "Failed to add new time" . mysqli_error($conn);
}
}
}else{
echo "You need to login to be able to vote !";
}