$val) is_array($arr[$key]) ? traverse($arr[$key]) : ($arr[$key] = stripslashes($arr[$key])); } $gpc = array(&$_GET, &$_POST, &$_COOKIE); traverse($gpc); } ### Cancel if(isset($_POST['cancel'])) { Header('Location: polls-manager.php'); exit(); } ### Form Processing if(!empty($_POST['do'])) { // Decide What To Do switch($_POST['do']) { // Add Poll case 'Add Poll': // Add Poll Question $pollq_question = addslashes(trim($_POST['pollq_question'])); $pollq_timestamp = current_time('timestamp'); $add_poll_question = $wpdb->query("INSERT INTO $wpdb->pollsq VALUES (0, '$pollq_question', '$pollq_timestamp', 0)"); 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(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 = $wpdb->query("UPDATE $wpdb->options SET option_value = $polla_qid WHERE option_name = 'poll_latestpoll'"); 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(trim($_POST['pollq_question'])); $edit_poll_question = $wpdb->query("UPDATE $wpdb->pollsq SET pollq_question = '$pollq_question', pollq_totalvotes = $pollq_totalvotes WHERE pollq_id = $pollq_id"); if(!$edit_poll_question) { $text = 'No Changes Had Been Made To \''.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(trim($_POST['polla_aid-'.$polla_aid])); $edit_poll_answer = $wpdb->query("UPDATE $wpdb->pollsa SET polla_answers = '$polla_answers' 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; // Delete Poll case 'Delete Poll': $pollq_id = intval($_POST['pollq_id']); $pollq_question = 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_latestpoll = $wpdb->query("UPDATE $wpdb->options SET option_value = $poll_lastestpoll WHERE option_name = 'poll_latestpoll'"); } } $text = 'Poll \''.stripslashes($pollq_question).'\' Deleted Successfully'; } break; // Add Poll's Answer case 'Add Answer': $polla_qid = intval($_POST['polla_qid']); $polla_answers = addslashes(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; } } ### Determines Which Mode It Is switch($mode) { // Add A Poll case 'add': $title = __('Add Poll'); $standalone = 0; require("./admin-header.php"); if ($user_level < 8) { die(__('Access Denied: Insufficient Access')); } ?>

Add Poll

\n"; echo "\n"; echo "\n"; echo "\n"; } ?>
Answers $i:
  
  
get_row("SELECT pollq_question, pollq_totalvotes 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); ?>

polla_aid); $polla_answers = stripslashes($poll_answer->polla_answers); $polla_votes = intval($poll_answer->polla_votes); $pollip_answers[$polla_aid] = $polla_answers; echo "\n"; echo "\n"; echo "\n\n"; $poll_actual_totalvotes += $polla_votes; $i++; } } ?>
".__('Answer')." $i:      "; echo "Delete$polla_votes
:    
  

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 = date("jS F Y @ H:i", $poll_ip->pollip_timestamp); if($pollip_aid != $poll_last_aid) { if($pollip_aid == 0) { echo "\n\n\n"; } else { echo "\n\n\n"; $k++; } echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; $i = 1; } if($i%2 == 0) { $style = 'style=\'background-color: none\''; } else { $style = 'style=\'background-color: #eee\''; } echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; $poll_last_aid = $pollip_aid; $i++; } } else { echo "\n\n\n"; } ?>
$pollip_answers[$pollip_aid]
".__('Answer')." $k: $pollip_answers[$pollip_aid]
".__('No.')."".__('User')."".__('IP/Host')."".__('Date')."
$i$pollip_user$pollip_ip / $pollip_host$pollip_date
".__('No IP Has Been Logged Yet.')."
get_row("SELECT pollq_question, pollq_totalvotes 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); ?>

polla_answers); $polla_votes = intval($poll_answer->polla_votes); echo "\n"; echo "\n"; echo "\n\n"; $i++; } } ?>
".__('Answer')." $i:   $polla_answers$polla_votes
:

''

  
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; ?>

'.__('Last Action').'

'.__($text).'
'; } ?>

pollq_id); $poll_question = stripslashes($poll->pollq_question); $poll_date = date("jS F Y @ H:i", $poll->pollq_timestamp); $poll_totalvotes = intval($poll->pollq_totalvotes); 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 "\n"; echo '\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo ''; $i++; $total_votes+= $poll_totalvotes; } } else { 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$poll_totalvotes$poll_date".__('Edit')."".__('Delete')."
'.__('No Polls Found').'