<?php

// get the posted data
$ProfessionalID = 0;
$ProfessionalAlias = "";
$ProfessionalPronouns = "";
$ProfessionalAge = 0;
$ProfessionalRole = "";
$ProfessionalPlayedHero = "";

if(isset($_POST['ProfessionalID']))
    $ProfessionalID = $_POST['ProfessionalID'];

if(isset($_POST['Alias']))
    $ProfessionalAlias = $_POST['Alias'];

if(isset($_POST['pnouns']))
    $ProfessionalPronouns = $_POST['pnouns'];

if(isset($_POST['Age']))
    $ProfessionalAge = $_POST['Age']; 

if(isset($_POST['Role']))
    $ProfessionalRole = $_POST['Role'];

if(isset($_POST['hero']))
    $ProfessionalPlayedHero = $_POST['hero'];



// check and see if this is a new player with no description - if so return to list or give error ???
if ($ProfessionalID == 0 && empty($ProfessionalAlias) && empty($ProfessionalPronouns) && empty($ProfessionalAge) && empty($ProfessionalRole) && empty($ProfessionalPlayedHero) )
{
    $redirect = "location: index.php";
    header($redirect);
    exit();
    
}

// attempt to connect to the DB
$dbconn = mysqli_connect("localhost", "root", "", "overwatchprofessionals");
if ($dbconn->connect_error > 0) {
    die('Could not connect: ' . $dbconn->connect_error);
    exit(); // you should redirect to some form of error page !!!!
}

// determines if new pro player or not
if ($ProfessionalID == 0)
{
    // new player - creates the row
    $sql = $dbconn->prepare("INSERT INTO playerinfo (ProfessionalAlias, ProfessionalPronouns, ProfessionalAge, ProfessionalRole, ProfessionalPlayedHero ) values (?, ?, ?, ?, ?)");
    $sql->bind_param('ssiss', $ProfessionalAlias, $ProfessionalPronouns, $ProfessionalAge, $ProfessionalRole, $ProfessionalPlayedHero);	
    // execute the query 
    $sql->execute();    
}
else
{
   // existing player
    $sql = $dbconn->prepare("update playerinfo 
                                    set ProfessionalAlias = ?, ProfessionalPronouns = ?, ProfessionalAge = ?, ProfessionalRole = ?, ProfessionalPlayedHero = ?
                                    where ProfessionalID = ?");
    $sql->bind_param('ssissi', $ProfessionalAlias, $ProfessionalPronouns, $ProfessionalAge, $ProfessionalRole, $ProfessionalPlayedHero, $ProfessionalID);	
    // execute the query 
    $sql->execute();      
}


// close the DB and connection
$sql->close();
$dbconn->close(); 

header('Location: index.php');
 ?>