$polla_answer_new_vote = intval($polla_answers_new_votes[$i]);
$add_poll_answers = $wpdb->query("INSERT INTO {$wpdb->pollsa} VALUES (0, {$pollq_id}, '{$polla_answer_new}', {$polla_answer_new_vote})");
if (!$add_poll_answers) {
$text .= '<p style="color: red;">' . sprintf(__('Error In Adding Poll\'s Answer \'%s\'.', 'wp-polls'), stripslashes($polla_answer_new)) . '</p>';
} else {
$text .= '<p style="color: green;">' . sprintf(__('Poll\'s Answer \'%s\' Added Successfully.', 'wp-polls'), stripslashes($polla_answer_new)) . '</p>';
}
}
$i++;
}
}
if (empty($text)) {
$text = '<p style="color: green">' . sprintf(__('Poll \'%s\' Edited Successfully.', 'wp-polls'), stripslashes($pollq_question)) . '</p>';
}
// Update Lastest Poll ID To Poll Options
$latest_pollid = polls_latest_id();
$update_latestpoll = update_option('poll_latestpoll', $latest_pollid);
cron_polls_place();
break;
}
}
### Determines Which Mode It Is
switch ($mode) {
// Poll Logging
case 'logs':
require 'polls-logs.php';
break;
?>
<?php
break;
// Edit A Poll
function manage_poll()
{
global $wpdb;
### Form Processing
if (isset($_POST['action']) && $_POST['action'] == 'polls-admin') {
if (!empty($_POST['do'])) {
// Set Header
header('Content-Type: text/html; charset=' . get_option('blog_charset') . '');
// Decide What To Do
switch ($_POST['do']) {
// Delete Polls Logs
case __('Delete All Logs', 'wp-polls'):
check_ajax_referer('wp-polls_delete-polls-logs');
if (trim($_POST['delete_logs_yes']) == 'yes') {
$delete_logs = $wpdb->query("DELETE FROM {$wpdb->pollsip}");
if ($delete_logs) {
echo '<p style="color: green;">' . __('All Polls Logs Have Been Deleted.', 'wp-polls') . '</p>';
} else {
echo '<p style="color: red;">' . __('An Error Has Occurred While Deleting All Polls Logs.', 'wp-polls') . '</p>';
}
}
break;
// Delete Poll Logs For Individual Poll
// Delete Poll Logs For Individual Poll
case __('Delete Logs For This Poll Only', 'wp-polls'):
check_ajax_referer('wp-polls_delete-poll-logs');
$pollq_id = intval($_POST['pollq_id']);
$pollq_question = $wpdb->get_var("SELECT pollq_question FROM {$wpdb->pollsq} WHERE pollq_id = {$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) {
echo '<p style="color: green;">' . sprintf(__('All Logs For \'%s\' Has Been Deleted.', 'wp-polls'), stripslashes($pollq_question)) . '</p>';
} else {
echo '<p style="color: red;">' . sprintf(__('An Error Has Occurred While Deleting All Logs For \'%s\'', 'wp-polls'), stripslashes($pollq_question)) . '</p>';
}
}
break;
// Delete Poll's Answer
// Delete Poll's Answer
case __('Delete Poll Answer', 'wp-polls'):
check_ajax_referer('wp-polls_delete-poll-answer');
$pollq_id = intval($_POST['pollq_id']);
$polla_aid = intval($_POST['polla_aid']);
$poll_answers = $wpdb->get_row("SELECT polla_votes, polla_answers FROM {$wpdb->pollsa} WHERE polla_aid = {$polla_aid} AND polla_qid = {$pollq_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 = {$polla_aid} AND polla_qid = {$pollq_id}");
$delete_pollip = $wpdb->query("DELETE FROM {$wpdb->pollsip} WHERE pollip_qid = {$pollq_id} AND pollip_aid = {$polla_aid}");
$update_pollq_totalvotes = $wpdb->query("UPDATE {$wpdb->pollsq} SET pollq_totalvotes = (pollq_totalvotes-{$polla_votes}) WHERE pollq_id = {$pollq_id}");
if ($delete_polla_answers) {
echo '<p style="color: green;">' . sprintf(__('Poll Answer \'%s\' Deleted Successfully.', 'wp-polls'), $polla_answers) . '</p>';
} else {
echo '<p style="color: red;">' . sprintf(__('Error In Deleting Poll Answer \'%s\'.', 'wp-polls'), $polla_answers) . '</p>';
}
break;
// Open Poll
// Open Poll
case __('Open Poll', 'wp-polls'):
check_ajax_referer('wp-polls_open-poll');
$pollq_id = intval($_POST['pollq_id']);
$pollq_question = $wpdb->get_var("SELECT pollq_question FROM {$wpdb->pollsq} WHERE pollq_id = {$pollq_id}");
$open_poll = $wpdb->query("UPDATE {$wpdb->pollsq} SET pollq_active = 1 WHERE pollq_id = {$pollq_id};");
if ($open_poll) {
echo '<p style="color: green;">' . sprintf(__('Poll \'%s\' Is Now Opened', 'wp-polls'), stripslashes($pollq_question)) . '</p>';
} else {
echo '<p style="color: red;">' . sprintf(__('Error Opening Poll \'%s\'', 'wp-polls'), stripslashes($pollq_question)) . '</p>';
}
break;
// Close Poll
// Close Poll
case __('Close Poll', 'wp-polls'):
check_ajax_referer('wp-polls_close-poll');
$pollq_id = intval($_POST['pollq_id']);
$pollq_question = $wpdb->get_var("SELECT pollq_question FROM {$wpdb->pollsq} WHERE pollq_id = {$pollq_id}");
$close_poll = $wpdb->query("UPDATE {$wpdb->pollsq} SET pollq_active = 0 WHERE pollq_id = {$pollq_id};");
if ($close_poll) {
echo '<p style="color: green;">' . sprintf(__('Poll \'%s\' Is Now Closed', 'wp-polls'), stripslashes($pollq_question)) . '</p>';
} else {
echo '<p style="color: red;">' . sprintf(__('Error Closing Poll \'%s\'', 'wp-polls'), stripslashes($pollq_question)) . '</p>';
}
break;
// Delete Poll
// Delete Poll
case __('Delete Poll', 'wp-polls'):
check_ajax_referer('wp-polls_delete-poll');
$pollq_id = intval($_POST['pollq_id']);
$pollq_question = $wpdb->get_var("SELECT pollq_question FROM {$wpdb->pollsq} WHERE pollq_id = {$pollq_id}");
$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) {
echo '<p style="color: red;">' . sprintf(__('Error In Deleting Poll \'%s\' Question', 'wp-polls'), stripslashes($pollq_question)) . '</p>';
}
if (empty($text)) {
echo '<p style="color: green;">' . sprintf(__('Poll \'%s\' Deleted Successfully', 'wp-polls'), stripslashes($pollq_question)) . '</p>';
}
// Update Lastest Poll ID To Poll Options
$latest_pollid = polls_latest_id();
$update_latestpoll = update_option('poll_latestpoll', $latest_pollid);
break;
}
exit;
}
}
}
function cron_polls_status()
{
global $wpdb;
// Close Poll
$close_polls = $wpdb->query("UPDATE {$wpdb->pollsq} SET pollq_active = 0 WHERE pollq_expiry < '" . current_time('timestamp') . "' AND pollq_expiry != '' AND pollq_active != 0");
// Open Future Polls
$active_polls = $wpdb->query("UPDATE {$wpdb->pollsq} SET pollq_active = 1 WHERE pollq_timestamp <= '" . current_time('timestamp') . "' AND pollq_active = -1");
// Update Latest Poll If Future Poll Is Opened
if ($active_polls) {
$update_latestpoll = update_option('poll_latestpoll', polls_latest_id());
}
return;
}