query("INSERT INTO $wpdb->pollsq VALUES (0, '$pollq_question', '$pollq_timestamp', 0, 1)");
if(!$add_poll_question) {
$text .= 'Error In Adding Poll \''.stripslashes($pollq_question).'\' ';
}
// Add Poll Answers
$polla_answers = $_POST['polla_answers'];
$polla_qid = intval($wpdb->insert_id);
foreach($polla_answers as $polla_answer) {
$polla_answer = addslashes(unhtmlentities(trim($polla_answer)));
$add_poll_answers = $wpdb->query("INSERT INTO $wpdb->pollsa VALUES (0, $polla_qid, '$polla_answer', 0)");
if(!$add_poll_answers) {
$text .= 'Error In Adding Poll\'s Answer \''.stripslashes($polla_answer).'\' ';
}
}
// Update Lastest Poll ID To Poll Options
$update_latestpoll = update_option('poll_latestpoll', $polla_qid);
if(!$update_latestpoll) {
$text .= "There Is An Error Updating The Lastest Poll ID ($polla_qid) To The Poll Option ";
}
if(empty($text)) {
$text = 'Poll \''.stripslashes($pollq_question).'\' Added Successfully ';
}
break;
// Edit Poll
case 'Edit Poll':
// Update Poll's Question
$pollq_id = intval($_POST['pollq_id']);
$pollq_totalvotes = intval($_POST['pollq_totalvotes']);
$pollq_question = addslashes(unhtmlentities(trim($_POST['pollq_question'])));
$edit_polltimestamp = intval($_POST['edit_polltimestamp']);
$timestamp_sql = '';
if($edit_polltimestamp == 1) {
$pollq_timestamp_day = intval($_POST['pollq_timestamp_day']);
$pollq_timestamp_month = intval($_POST['pollq_timestamp_month']);
$pollq_timestamp_year = intval($_POST['pollq_timestamp_year']);
$pollq_timestamp_hour = intval($_POST['pollq_timestamp_hour']);
$pollq_timestamp_minute = intval($_POST['pollq_timestamp_minute']);
$pollq_timestamp_second = intval($_POST['pollq_timestamp_second']);
$timestamp_sql = ", pollq_timestamp = '".gmmktime($pollq_timestamp_hour, $pollq_timestamp_minute, $pollq_timestamp_second, $pollq_timestamp_month, $pollq_timestamp_day, $pollq_timestamp_year)."'";
}
$edit_poll_question = $wpdb->query("UPDATE $wpdb->pollsq SET pollq_question = '$pollq_question', pollq_totalvotes = $pollq_totalvotes $timestamp_sql WHERE pollq_id = $pollq_id");
if(!$edit_poll_question) {
$text = 'No Changes Had Been Made To Poll\'s Title \''.stripslashes($pollq_question).'\' ';
}
// Update Polls' Answers
$polla_aids = array();
$get_polla_aids = $wpdb->get_results("SELECT polla_aid FROM $wpdb->pollsa WHERE polla_qid = $pollq_id ORDER BY polla_aid ASC");
if($get_polla_aids) {
foreach($get_polla_aids as $get_polla_aid) {
$polla_aids[] = intval($get_polla_aid->polla_aid);
}
foreach($polla_aids as $polla_aid) {
$polla_answers = addslashes(unhtmlentities(trim($_POST['polla_aid-'.$polla_aid])));
$polla_votes = intval($_POST['polla_votes-'.$polla_aid]);
$edit_poll_answer = $wpdb->query("UPDATE $wpdb->pollsa SET polla_answers = '$polla_answers', polla_votes = $polla_votes WHERE polla_qid = $pollq_id AND polla_aid = $polla_aid");
if(!$edit_poll_answer) {
$text .= 'No Changes Had Been Made To Poll\'s Answer \''.stripslashes($polla_answers).'\' ';
}
}
} else {
$text .= 'Invalid Poll \''.stripslashes($pollq_question).'\' ';
}
if(empty($text)) {
$text = 'Poll \''.stripslashes($pollq_question).'\' Edited Successfully ';
}
break;
// Open Poll
case 'Open Poll':
$pollq_id = intval($_POST['pollq_id']);
$pollq_question = addslashes(unhtmlentities(trim($_POST['pollq_question'])));
$close_poll = $wpdb->query("UPDATE $wpdb->pollsq SET pollq_active = 1 WHERE pollq_id = $pollq_id;");
if($close_poll) {
$text = 'Poll \''.stripslashes($pollq_question).'\' Is Now Opened ';
} else {
$text = 'Error Opening Poll \''.stripslashes($pollq_question).'\' ';
}
break;
// Close Poll
case 'Close Poll':
$pollq_id = intval($_POST['pollq_id']);
$pollq_question = addslashes(unhtmlentities(trim($_POST['pollq_question'])));
$close_poll = $wpdb->query("UPDATE $wpdb->pollsq SET pollq_active = 0 WHERE pollq_id = $pollq_id;");
if($close_poll) {
$text = 'Poll \''.stripslashes($pollq_question).'\' Is Now Closed ';
} else {
$text = 'Error Closing Poll \''.stripslashes($pollq_question).'\' ';
}
break;
// Delete Poll
case 'Delete Poll':
$pollq_id = intval($_POST['pollq_id']);
$pollq_question = unhtmlentities(trim($_POST['pollq_question']));
$delete_poll_question = $wpdb->query("DELETE FROM $wpdb->pollsq WHERE pollq_id = $pollq_id");
$delete_poll_answers = $wpdb->query("DELETE FROM $wpdb->pollsa WHERE polla_qid = $pollq_id");
$delete_poll_ip = $wpdb->query("DELETE FROM $wpdb->pollsip WHERE pollip_qid = $pollq_id");
$poll_option_lastestpoll = $wpdb->get_var("SELECT option_value FROM $wpdb->options WHERE option_name = 'poll_latestpoll'");
if(!$delete_poll_question) {
$text = 'Error In Deleting Poll \''.stripslashes($pollq_question).'\' Question ';
}
if(!$delete_poll_answers) {
$text .= 'Error In Deleting Poll Answers For \''.stripslashes($pollq_question).'\' ';
}
if(!$delete_poll_ip) {
$text .= 'Error In Deleting Voted IPs For \''.stripslashes($pollq_question).'\' ';
}
if(empty($text)) {
if($poll_option_lastestpoll == $pollq_id) {
$poll_lastestpoll = $wpdb->get_var("SELECT pollq_id FROM $wpdb->pollsq ORDER BY pollq_id DESC LIMIT 1");
if($poll_lastestpoll) {
$poll_lastestpoll = intval($poll_lastestpoll);
update_option('poll_latestpoll', $poll_lastestpoll);
}
}
$text = 'Poll \''.stripslashes($pollq_question).'\' Deleted Successfully ';
}
break;
// Add Poll's Answer
case 'Add Answer':
$polla_qid = intval($_POST['polla_qid']);
$polla_answers = addslashes(unhtmlentities(trim($_POST['polla_answers'])));
$add_poll_question = $wpdb->query("INSERT INTO $wpdb->pollsa VALUES (0, $polla_qid, '$polla_answers', 0)");
if(!$add_poll_question) {
$text = 'Error In Adding Poll Answer \''.stripslashes($polla_answers).'\' ';
} else {
$text = 'Poll Answer \''.stripslashes($polla_answers).'\' Added Successfully ';
}
break;
// Delete Polls Logs
case 'Delete All Logs':
if(trim($_POST['delete_logs_yes']) == 'yes') {
$delete_logs = $wpdb->query("DELETE FROM $wpdb->pollsip");
if($delete_logs) {
$text = 'All Polls Logs Have Been Deleted. ';
} else {
$text = 'An Error Has Occured While Deleting All Polls Logs. ';
}
}
break;
// Delete Poll Logs For Individual Poll
case 'Delete Logs For This Poll Only':
$pollq_id = intval($_POST['pollq_id']);
if(trim($_POST['delete_logs_yes']) == 'yes') {
$delete_logs = $wpdb->query("DELETE FROM $wpdb->pollsip WHERE pollip_qid = $pollq_id");
if($delete_logs) {
$text = 'All Logs For This Poll Has Been Deleted. ';
} else {
$text = 'An Error Has Occured While Deleting All Logs For This Poll. ';
}
}
break;
}
}
### Determines Which Mode It Is
switch($mode) {
// Add A Poll
case 'add':
?>
get_row("SELECT pollq_question, pollq_timestamp, pollq_totalvotes, pollq_active FROM $wpdb->pollsq WHERE pollq_id = $poll_id");
$poll_answers = $wpdb->get_results("SELECT polla_aid, polla_answers, polla_votes FROM $wpdb->pollsa WHERE polla_qid = $poll_id ORDER BY polla_aid ASC");
$poll_question_text = stripslashes($poll_question->pollq_question);
$poll_totalvotes = intval($poll_question->pollq_totalvote);
$poll_timestamp = $poll_question->pollq_timestamp;
$poll_active = intval($poll_question->pollq_active);
// Edit Timestamp Options
function poll_timestamp($poll_timestamp) {
global $month;
$day = gmdate('j', $poll_timestamp);
echo ''."\n";
for($i = 1; $i <=31; $i++) {
if($day == $i) {
echo "$i \n";
} else {
echo "$i \n";
}
}
echo ' '."\n";
$month2 = gmdate('n', $poll_timestamp);
echo ''."\n";
for($i = 1; $i <= 12; $i++) {
if ($i < 10) {
$ii = '0'.$i;
} else {
$ii = $i;
}
if($month2 == $i) {
echo "$month[$ii] \n";
} else {
echo "$month[$ii] \n";
}
}
echo ' '."\n";
$year = gmdate('Y', $poll_timestamp);
echo ''."\n";
for($i = 2000; $i <= gmdate('Y'); $i++) {
if($year == $i) {
echo "$i \n";
} else {
echo "$i \n";
}
}
echo ' @'."\n";
$hour = gmdate('H', $poll_timestamp);
echo ''."\n";
for($i = 0; $i < 24; $i++) {
if($hour == $i) {
echo "$i \n";
} else {
echo "$i \n";
}
}
echo ' :'."\n";
$minute = gmdate('i', $poll_timestamp);
echo ''."\n";
for($i = 0; $i < 60; $i++) {
if($minute == $i) {
echo "$i \n";
} else {
echo "$i \n";
}
}
echo ' :'."\n";
$second = gmdate('s', $poll_timestamp);
echo ''."\n";
for($i = 0; $i <= 60; $i++) {
if($second == $i) {
echo "$i \n";
} else {
echo "$i \n";
}
}
echo ' '."\n";
}
?>
'; } ?>
get_results("SELECT pollip_aid, pollip_ip, pollip_host, pollip_timestamp, pollip_user FROM $wpdb->pollsip WHERE pollip_qid = $poll_id ORDER BY pollip_aid ASC, pollip_user ASC");
?>
pollip_aid);
$pollip_user = stripslashes($poll_ip->pollip_user);
$pollip_ip = $poll_ip->pollip_ip;
$pollip_host = $poll_ip->pollip_host;
$pollip_date = gmdate("jS F Y @ H:i", $poll_ip->pollip_timestamp);
if($pollip_aid != $poll_last_aid) {
if($pollip_aid == 0) {
echo "\n$pollip_answers[$pollip_aid] \n";
} else {
echo "\n".__('Answer')." $k: $pollip_answers[$pollip_aid] \n";
$k++;
}
echo "\n";
echo "".__('No.')." \n";
echo "".__('User')." \n";
echo "".__('IP/Host')." \n";
echo "".__('Date')." \n";
echo " \n";
$i = 1;
}
if($i%2 == 0) {
$style = 'style=\'background-color: none\'';
} else {
$style = 'style=\'background-color: #eee\'';
}
echo "\n";
echo "$i \n";
echo "$pollip_user \n";
echo "$pollip_ip / $pollip_host \n";
echo "$pollip_date \n";
echo " \n";
$poll_last_aid = $pollip_aid;
$i++;
}
} else {
echo "\n".__('No IP Has Been Logged Yet.')." \n \n";
}
?>
Note: If your logging method is by IP and Cookie or by Cookie, users may still be unable to vote if they have voted before as the cookie is still stored in their computer.
get_row("SELECT pollq_question, pollq_totalvotes, pollq_active FROM $wpdb->pollsq WHERE pollq_id = $poll_id");
$poll_answers = $wpdb->get_results("SELECT polla_aid, polla_answers, polla_votes FROM $wpdb->pollsa WHERE polla_qid = $poll_id ORDER BY polla_answers");
$poll_question_text = stripslashes($poll_question->pollq_question);
$poll_totalvotes = intval($poll_question->pollq_totalvotes);
$poll_active = intval($poll_question->pollq_active);
?>
get_row("SELECT polla_votes, polla_answers FROM $wpdb->pollsa WHERE polla_aid = $poll_aid AND polla_qid = $poll_id");
$polla_votes = intval($poll_answers->polla_votes);
$polla_answers = stripslashes(trim($poll_answers->polla_answers));
$delete_polla_answers = $wpdb->query("DELETE FROM $wpdb->pollsa WHERE polla_aid = $poll_aid AND polla_qid = $poll_id");
$update_pollq_totalvotes = $wpdb->query("UPDATE $wpdb->pollsq SET pollq_totalvotes = (pollq_totalvotes-$polla_votes) WHERE pollq_id=$poll_id");
?>
Poll Answer '$polla_answers' Deleted Successfully";
} else {
$text = "
Error In Deleting Poll Answer '$polla_answers' ";
}
if($update_pollq_totalvotes) {
$text .= "
Poll Question's Total Votes Updated Successfully ";
} else {
$text .= "
No Changes Had Been Made To The Poll's Total Votes ";
}
_e($text);
?>
get_results("SELECT * FROM $wpdb->pollsq ORDER BY pollq_id DESC");
$total_ans = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->pollsa");
$total_votes = 0;
?>
'; } ?>
pollq_id);
$poll_question = stripslashes($poll->pollq_question);
$poll_date = gmdate("jS F Y @ H:i", $poll->pollq_timestamp);
$poll_totalvotes = intval($poll->pollq_totalvotes);
$poll_active = intval($poll->pollq_active);
if($i%2 == 0) {
$style = 'style=\'background-color: #eee\'';
} else {
$style = 'style=\'background-color: none\'';
}
if($current_poll > 0) {
if($current_poll == $poll_id) {
$style = 'style=\'background-color: #b8d4ff\'';
}
} else {
if($i == 0) {
$style = 'style=\'background-color: #b8d4ff\'';
}
}
echo "\n";
echo "$poll_id ';
if($current_poll > 0) {
if($current_poll == $poll_id) {
echo ''.__('Displayed:').' ';
}
} elseif($current_poll != -1) {
if($i == 0) {
echo ''.__('Displayed:').' ';
}
}
echo "$poll_question \n";
echo "$poll_totalvotes \n";
echo "$poll_date \n";
echo '';
if($poll_active == 1) {
_e('Open');
} else {
_e('Closed');
}
echo " \n";
echo "".__('Edit')." ".__('Delete')." ';
$i++;
$total_votes+= $poll_totalvotes;
}
} else {
echo ''.__('No Polls Found').'
Note: If your logging method is by IP and Cookie or by Cookie, users may still be unable to vote if they have voted before as the cookie is still stored in their computer.