get_row("SELECT id, question, total_votes FROM $wpdb->pollsq ORDER BY id DESC LIMIT 1"); $poll_answers = $wpdb->get_results("SELECT aid, answers, votes FROM $wpdb->pollsa WHERE qid = $poll_question->id ORDER BY votes DESC"); } else { $poll_question = $wpdb->get_row("SELECT id, question, total_votes FROM $wpdb->pollsq WHERE id = $poll_id LIMIT 1"); $poll_answers = $wpdb->get_results("SELECT aid, answers, votes FROM $wpdb->pollsa WHERE qid = $poll_id ORDER BY votes DESC"); } // If View Results if(intval($_GET['showresults']) == 1) { $vote_text = '

'; } // Poll Variables $poll_question_text = stripslashes($poll_question->question); // If User Click Vote if(isset($_POST['vote'])) { if(isset($_POST["poll-.$poll_question->id"])) { $voted = true; } } // Check User Cookie if(isset($_COOKIE["voted_$poll_question->id"])) { $voted = true; } // If User Has Voted if($voted || intval($_GET['showresults']) == 1) { echo ''; echo "\n\n"; foreach($poll_answers as $poll_answer) { // Make Sure Total Votes Is Not 0 if(intval($poll_question->total_votes) > 0) { $percentage = round((($poll_answer->votes/$poll_question->total_votes)*100)); $imagebar = $percentage*0.9; } else { $percentage = 0; $imagebar = 1; } $poll_answer_text = stripslashes($poll_answer->answers); echo "\n\n"; echo "\n\n"; } echo "\n\n"; echo '

$poll_question_text
$poll_answer_text $\"".htmlspecialchars($poll_answer_text)."$ $percentage% ($poll_answer->votes Votes)\" />	$percentage%
Total Votes: $poll_question->total_votes$vote_text

'; // If User Has Not Voted } else { echo ''; } } ### Vote Poll function vote_poll() { global $wpdb; if(isset($_POST['vote'])) { $poll_id = intval($_POST['poll_id']); $poll_aid = intval($_POST["poll-$poll_id"]); if(!isset($_COOKIE["voted_$poll_id"])) { $vote_a = $wpdb->query("UPDATE $wpdb->pollsa SET votes = (votes+1) WHERE qid = $poll_id AND aid = $poll_aid"); if($vote_a) { $vote_q = $wpdb->query("UPDATE $wpdb->pollsq SET total_votes = (total_votes+1) WHERE id = $poll_id"); if($vote_q) { setcookie("voted_".$poll_id, 1, time() + 30000000, COOKIEPATH); } } } } } ?>