function process_new_quest()
{
// Create a new quest using the post data
$quest_name = $_POST['quest_name'];
$quest_description = trim($_POST['quest_description']);
$pano_id = $_POST['pano_id'];
$domain_id = $_POST['domain_id'] == "NA" ? null : $_POST['domain_id'];
// Get the id
create_quest($quest_name, $quest_description, $pano_id, $domain_id);
wp_redirect(admin_url('admin.php?page=pano_quest_settings'));
}
function manage_surveys()
{
global $table_prefix, $wpdb;
$survey_table = $table_prefix . "surveys";
if (isset($_REQUEST["wpsurv_submit"])) {
require_once 'functions.php';
if ($_POST["wpsurv_submit"] == __('Edit', 'wp-surveys') || $_POST["wpsurv_submit"] == __('Cancel', 'wp-surveys') || $_POST["wpsurv_submit"] == __('Back to Edit Survey', 'wp-surveys')) {
edit($_POST['survey_id']);
} elseif ($_POST["wpsurv_submit"] == __('Update', 'wp-surveys')) {
update($_POST['survey_id']);
} elseif ($_POST["wpsurv_submit"] == __('Update Options', 'wp-surveys')) {
update_options($_POST['survey_id'], $_POST['question_id']);
} elseif ($_POST["wpsurv_submit"] == __('Activate', 'wp-surveys') || $_POST["wpsurv_submit"] == __('Make Active', 'wp-surveys')) {
activate($_POST['survey_id']);
} elseif ($_POST["wpsurv_submit"] == __('Retire', 'wp-surveys')) {
retire($_POST['survey_id']);
} elseif ($_POST["wpsurv_submit"] == __('Update Leaderboard', 'wp-surveys')) {
recach_utility($_POST['survey_id']);
} elseif ($_POST["wpsurv_submit"] == __('Edit Options', 'wp-surveys') || $_POST["wpsurv_submit"] == __('Add Some Options', 'wp-surveys') || $_POST["wpsurv_submit"] == __('Edit or Add more Options', 'wp-surveys')) {
edit_options($_POST['survey_id'], $_POST['question_id']);
} elseif ($_POST["wpsurv_submit"] == __('Add More Questions', 'wp-surveys') || $_POST["wpsurv_submit"] == __('Add Some Questions', 'wp-surveys')) {
add_question($_POST['survey_id']);
} elseif ($_POST["wpsurv_submit"] == __('Step 2', 'wp-surveys')) {
step2($_POST['survey_id']);
} elseif ($_POST["wpsurv_submit"] == __('Create Question', 'wp-surveys')) {
create_quest($_POST['survey_id']);
} elseif ($_POST["wpsurv_submit"] == __('Change Survey', 'wp-surveys') || $_POST["wpsurv_submit"] == __('Add Survey', 'wp-surveys')) {
survey($_POST['survey_id']);
} elseif ($_POST["wpsurv_submit"] == __('Add This Survey', 'wp-surveys')) {
add_survey($_POST['survey_id']);
} elseif ($_POST["wpsurv_submit"] == __('View Survey Results', 'wp-surveys')) {
results($_POST['survey_id']);
}
//elseif($_POST["wpsurv_submit"] == __('View Survey Results in CSV File', 'wp-surveys'))
//results_CSV($_POST['survey_id']);
//elseif($_POST["wpsurv_submit"] == __('Delete File', 'wp-surveys'))
//delete_file($_POST['survey_id']);
} else {
$current_plugins = get_option('active_plugins');
if (file_exists(ABSPATH . PLUGINDIR . '/polyglot.php') && in_array('polyglot.php', $current_plugins)) {
$polyglot = true;
}
echo '<div class="wrap">';
$open_surveys = $wpdb->get_results("SELECT * FROM `" . $survey_table . "` WHERE `survey_open`='1' LIMIT 1;", ARRAY_A);
echo '<h2>' . __('Survey Management', 'wp-surveys') . '</h2><h3><u>' . __('Active Survey', 'wp-surveys') . '</u>:</h3>';
if ($open_surveys) {
echo '<table class="widefat" width="100%" cellpadding="4" cellspacing="4">';
echo '<tr><th align="left">' . __('Title', 'wp-surveys') . '</th><th align="left">' . __('Description', 'wp-surveys') . '</th><th></th><th></th><th></th></tr>';
foreach ($open_surveys as $survey) {
echo '<tr class="alternate">';
if ($polyglot) {
echo '<td><b>' . polyglot_filter(stripcslashes($survey['survey_name'])) . '</b></td><td>' . polyglot_filter(stripcslashes($survey['survey_describe'])) . '</td>';
} elseif (!$polyglot) {
echo '<td><b>' . stripcslashes($survey['survey_name']) . '</b></td><td>' . stripcslashes($survey['survey_describe']) . '</td>';
}
echo '<td class="submit" align="center"><form method="post" action=""><input type="hidden" name="survey_id" value="' . $survey['survey_id'] . '" />';
echo '<input type="submit" name="wpsurv_submit" value="' . __('Edit', 'wp-surveys') . '" /></form></td>';
echo '<td class="submit" align="center"><form method="post" action=""><input type="hidden" name="survey_id" value="' . $survey['survey_id'] . '" />';
echo '<input type="submit" name="wpsurv_submit" value="' . __('Retire', 'wp-surveys') . '" /></form></td>';
echo '<td class="submit" align="center"><form method="post" action=""><input type="hidden" name="survey_id" value="' . $survey['survey_id'] . '" />';
echo '<input type="submit" name="wpsurv_submit" value="' . __('View Survey Results', 'wp-surveys') . '" /></form></td>';
//echo '<td align="center"><form method="post" action=""><input type="hidden" name="survey_id" value="'.$survey['survey_id'].'" />';
//echo '<input type="submit" name="wpsurv_submit" value="'.__('View Survey Results in CSV File', 'wp-surveys').'" /></form></td>';
echo '</tr>';
}
echo '</table>';
$next = ++$survey['survey_id'];
echo '<br /><form method="post" action=""><input type="hidden" name="survey_id" value="' . $next . '" /><input class="button" type="submit" name="wpsurv_submit" value="' . __('Change Survey', 'wp-surveys') . '" title="' . __('Current Survey will be saved as Retired', 'wp-surveys') . '" /></form>';
} else {
echo __('There are no open tournaments or contests.', 'wp-surveys') . '.';
//$last = $wpdb->get_var("SELECT COUNT(`survey_id`) FROM `".$survey_table."`;");
$last = $wpdb->get_var("SELECT `survey_id` FROM `" . $survey_table . "` ORDER BY `survey_id` DESC LIMIT 1;");
$next = ++$last;
echo '<br /><br /><form method="post" action=""><input type="hidden" name="survey_id" value="' . $next . '" /><input class="button" type="submit" name="wpsurv_submit" value="' . __('Add Survey', 'wp-surveys') . '" /></form>';
}
$closed_surveys = $wpdb->get_results("SELECT * FROM `" . $survey_table . "` WHERE `survey_open`='0';", ARRAY_A);
echo '<h3><u>' . __('Retired Surveys', 'wp-surveys') . '</u>:</h3>';
if ($closed_surveys) {
echo '<table class="widefat" width="100%" cellpadding="4" cellspacing="4">';
echo '<tr><th align="left">' . __('Title', 'wp-surveys') . '</th><th align="left">' . __('Description', 'wp-surveys') . '</th><th></th><th></th><th></th></tr>';
foreach ($closed_surveys as $survey) {
echo '<tr class="alternate">';
if ($polyglot) {
echo '<td><b>' . polyglot_filter(stripcslashes($survey['survey_name'])) . '</b></td><td>' . polyglot_filter(stripcslashes($survey['survey_describe'])) . '</td>';
} elseif (!$polyglot) {
echo '<td><b>' . stripcslashes($survey['survey_name']) . '</b></td><td>' . stripcslashes($survey['survey_describe']) . '</td>';
}
echo '<td class="submit" align="center"><form method="post" action=""><input type="hidden" name="survey_id" value="' . $survey['survey_id'] . '" />';
echo '<input type="submit" name="wpsurv_submit" value="' . __('Edit', 'wp-surveys') . '" /></form></td>';
echo '<td class="submit" align="center"><form method="post" action=""><input type="hidden" name="survey_id" value="' . $survey['survey_id'] . '" />';
echo '<input type="submit" name="wpsurv_submit" value="' . __('Make Active', 'wp-surveys') . '" /></form></td>';
echo '<td class="submit" align="center"><form method="post" action=""><input type="hidden" name="survey_id" value="' . $survey['survey_id'] . '" />';
echo '<input type="submit" name="wpsurv_submit" value="' . __('View Survey Results', 'wp-surveys') . '" /></form></td>';
//echo '<td align="center"><form method="post" action=""><input type="hidden" name="survey_id" value="'.$survey['survey_id'].'" />';
//echo '<input type="submit" name="wpsurv_submit" value="'.__('View Survey Results in CSV File', 'wp-surveys').'" /></form></td>';
echo '</tr>';
}
echo '</table>';
} else {
echo __('There are no retired surveys', 'wp-surveys') . '.';
}
echo '</div>';
}
}