<?php
require '../wp-load.php';
if (isset($current_user) && $current_user->ID > 0) {
if (!isset($_REQUEST['comment_id']) || !isset($_REQUEST['comment_vote'])) {
echo "errorparam";
} else {
if ($_REQUEST['action_type'] != 'changehelpful') {
//Add new
$comment_id = $_REQUEST['comment_id'];
$comment_vote = $_REQUEST['comment_vote'];
$data = helpfulVote($comment_id, $comment_vote);
if ($data > 0) {
$userdat = addUserVote($current_user->ID, $comment_id, $comment_vote);
if ($userdat > 0) {
echo $comment_vote . "-success";
} else {
echo $comment_vote . "-success-none";
}
} else {
echo "error";
}
} else {
//Alter Vote
$comment_id = $_REQUEST['comment_id'];
$comment_vote = $_REQUEST['comment_vote'];
$data = helpfulVote($comment_id, $comment_vote, "change");
$changeUserVote = alterUserVote($current_user->ID, $comment_id, $comment_vote);
if ($changeUserVote > 0) {
echo $comment_vote . "-success";
} else {
function voteForCard($id, $username)
{
if (checkVotes($username)) {
try {
$con = new PDO(DB_DSN, DB_USERNAME, DB_PASSWORD);
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = "SELECT votes FROM card WHERE id =:id";
$stmt = $con->prepare($sql);
$stmt->bindValue("id", $id, PDO::PARAM_STR);
$stmt->execute();
$votes = $stmt->fetchColumn(0);
$votes = $votes + 1;
$sql = "UPDATE card SET votes = :votes WHERE id = :id";
$stmt = $con->prepare($sql);
$stmt->bindValue("id", $id, PDO::PARAM_STR);
$stmt->bindValue("votes", $votes, PDO::PARAM_STR);
$stmt->execute();
addUserVote($id, $username);
// echo "{\"error\": [{ \"type\": \"alert\", \"votes\":\"$votes\"}]}";
echo "{\"votes\":{$votes}}";
} catch (PDOException $e) {
echo json_encode($e->getMessage());
}
} else {
echo "{\"votes\":{$votes}}";
echo "{\"error\": [{ \"type\": \"alert\", \"msg\":\"You are out of votes.\"}]}";
}
}
