| 1 |
<?php |
| 2 |
if ( ! defined( 'ABSPATH' ) ) exit; // Exit if accessed directly |
| 3 |
|
| 4 |
function watu_grades() { |
| 5 |
global $wpdb; |
| 6 |
|
| 7 |
// select quiz |
| 8 |
$quiz = $wpdb->get_row($wpdb->prepare("SELECT ID, name, advanced_settings FROM ".WATU_EXAMS." WHERE ID=%d", intval($_GET['quiz_id']))); |
| 9 |
if(empty($quiz->ID)) wp_die(__('Unrecognized quiz ID', 'watu')); |
| 10 |
|
| 11 |
if(!empty($_POST['add']) or !empty($_POST['save'])) { |
| 12 |
$gtitle = sanitize_text_field($_POST['gtitle']); |
| 13 |
$gfrom = floatval($_POST['gfrom']); |
| 14 |
$gto = floatval($_POST['gto']); |
| 15 |
$redirect_url = esc_url_raw($_POST['redirect_url']); |
| 16 |
$moola = intval(@$_POST['moola']); |
| 17 |
} |
| 18 |
|
| 19 |
if(!empty($_POST['add']) and check_admin_referer('watu_grades')) { |
| 20 |
$gdesc = wp_kses_post($_POST['gdesc']); |
| 21 |
$wpdb->query($wpdb->prepare("INSERT INTO ".WATU_GRADES." SET |
| 22 |
exam_id=%d, gtitle=%s, gdescription=%s, gfrom=%f, gto=%f, redirect_url=%s, moola=%d", |
| 23 |
$quiz->ID, $gtitle, $gdesc, $gfrom, $gto, $redirect_url, $moola)); |
| 24 |
watu_redirect("admin.php?page=watu_grades&quiz_id=".$quiz->ID); |
| 25 |
} |
| 26 |
|
| 27 |
if(!empty($_POST['save']) and check_admin_referer('watu_grades')) { |
| 28 |
$gdesc = wp_kses_post($_POST['gdesc'.$_POST['id']]); |
| 29 |
$wpdb->query($wpdb->prepare("UPDATE ".WATU_GRADES." SET |
| 30 |
gtitle=%s, gdescription=%s, gfrom=%f, gto=%f, redirect_url=%s, moola=%d WHERE ID=%d", |
| 31 |
$gtitle, $gdesc, $gfrom, $gto, $redirect_url, $moola, intval($_POST['id']))); |
| 32 |
watu_redirect("admin.php?page=watu_grades&quiz_id=".$quiz->ID); |
| 33 |
} |
| 34 |
|
| 35 |
if(!empty($_POST['del']) and check_admin_referer('watu_grades')) { |
| 36 |
$wpdb->query($wpdb->prepare("DELETE FROM ".WATU_GRADES." WHERE ID=%d", intval($_POST['id']))); |
| 37 |
} |
| 38 |
|
| 39 |
// select grades |
| 40 |
$grades = $wpdb->get_results($wpdb->prepare("SELECT * FROM ".WATU_GRADES." WHERE exam_id=%d ORDER BY gto DESC", $quiz->ID)); |
| 41 |
|
| 42 |
$integrate_moolamojo = get_option('watu_integrate_moolamojo'); |
| 43 |
if($integrate_moolamojo) { |
| 44 |
$advanced_settings = unserialize(stripslashes($quiz->advanced_settings)); |
| 45 |
$integrate_moolamojo = $advanced_settings['transfer_moola']; |
| 46 |
} |
| 47 |
|
| 48 |
if(@file_exists(get_stylesheet_directory().'/watu/grades.html.php')) include get_stylesheet_directory().'/watu/grades.html.php'; |
| 49 |
else include(WATU_PATH . '/views/grades.html.php'); |
| 50 |
} // end manage grades |
| 51 |
|
