<?php

if (isset($_POST['update'])) {
    $email = mysqli_real_escape_string($dbconD, $_POST['email']);
    $tname = mysqli_real_escape_string($dbconD, $_POST['tname']);
    $dname = mysqli_real_escape_string($dbconD, $_POST['dname']);
    $joindate = mysqli_real_escape_string($dbconD, $_POST['hidden']);
    $id = mysqli_real_escape_string($dbconD, $_POST['steamid']);
    $tactivity = mysqli_real_escape_string($dbconD, $_POST['tactivity']);
    $experience = mysqli_real_escape_string($dbconD, $_POST['experience']);
    $explainexp = mysqli_real_escape_string($dbconD, $_POST['explainexp']);
    $offer = mysqli_real_escape_string($dbconD, $_POST['offer']);
    $qes1 = mysqli_real_escape_string($dbconD, $_POST['qes1']);
    $qes2 = mysqli_real_escape_string($dbconD, $_POST['qes2']);
    $qes3 = mysqli_real_escape_string($dbconD, $_POST['qes3']);
    $qes4 = mysqli_real_escape_string($dbconD, $_POST['qes4']);
    $qes5 = mysqli_real_escape_string($dbconD, $_POST['qes5']);

    #Question 1 checks
    if($_POST['q1/1'] == 'Yes')
    {
        $q1 = 'Send them the welcome page url and get them to read it whilst you finish the game off';
    }
    elseif($_POST['q1/2'] == 'Yes')
    {
        $q1 = 'Reply saying after I finish this game';
    }
    elseif($_POST['q1/3'] == 'Yes')
    {
        $q1 = 'Ignore the message';
    }
    elseif($_POST['q1/4'] == 'Yes')
    {
        $q1 = 'Leave it for another examiner to sort out';
    }
    else{
        $q1 = 'None was selected';
    }

    #Question 2 checks
    if($_POST['q2/1'] == 'Yes')
    {
        $q2 = "'Modify' the results so they did better then they actually did";
    }
    elseif($_POST['q2/2'] == 'Yes')
    {
        $q2 = 'Record the poor results but tell him/her they did well';
    }
    elseif($_POST['q2/3'] == 'Yes')
    {
        $q2 = 'Be truthful and tell him/her how they did';
    }
    elseif($_POST['q2/4'] == 'Yes')
    {
        $q2 = 'Skip the results';
    }
    else{
        $q2 = 'None was selected';
    }

    #Question 3 checks
    if($_POST['q3/1'] == 'Yes')
    {
        $q3 = 'Tell the applicants you havent got the time';
    }
    elseif($_POST['q3/2'] == 'Yes')
    {
        $q3 = 'Try and deal with both';
    }
    elseif($_POST['q3/3'] == 'Yes')
    {
        $q3 = 'Come off TeamSpeak';
    }
    elseif($_POST['q3/4'] == 'Yes')
    {
        $q3 = 'Type in the examiner lounge on discord if anyone else is available';
    }
    else{
        $q3 = 'None was selected';
    }

    #Question 4 checks
    if($_POST['q4/1'] == 'Yes')
    {
        $q4 = 'Message the VTC Commissioner';
    }
    elseif($_POST['q4/2'] == 'Yes')
    {
        $q4 = 'Message the applicant';
    }
    elseif($_POST['q4/3'] == 'Yes')
    {
        $q4 = 'Enter the test room';
    }
    elseif($_POST['q4/4'] == 'Yes')
    {
        $q4 = 'Do nothing';
    }
    else{
        $q4 = 'None was selected';
    }

    #Question 5 checks
    if($_POST['q5/1'] == 'Yes')
    {
        $q5 = 'Change your mind and pass them';
    }
    elseif($_POST['q5/2'] == 'Yes')
    {
        $q5 = 'Call the management team in the room';
    }
    elseif($_POST['q5/3'] == 'Yes')
    {
        $q5 = 'Kick them from the server';
    }
    elseif($_POST['q5/4'] == 'Yes')
    {
        $q5 = 'Argue back';
    }
    else{
        $q5 = 'None was selected';
    }



		$area = "Examiner-Team";

        $UpdateQ = "INSERT INTO applications (area, steamid, email, tname, dname, joindate, tactivity, experience, explainexp, offer, qes1, qes2, qes3, qes4, qes5) VALUES ('$area', '$id', '$email', '$tname', '$dname', '$joindate', '$tactivity', '$experience', '$explainexp', '$offer', '$q1' , '$q2', '$q3', '$q4', '$q5')";
        mysqli_query($dbconD, $UpdateQ);

        echo '<div class="alert alert-success" role="alert"><a href="#" class="alert-link">Initial Driving Record successfully added!</a></div>';
		header("Location: http://www.tsrvtc.com/");
}
?>