connect_errno)
{ die('Failed to connect to database.'); }
$conn->set_charset("utf8");
$scriptname = "player.php?" . $_SERVER['QUERY_STRING'];
$nav_id = "home";
$prefdata = $conn->query("SELECT * FROM tplss_preferences WHERE ID = '0'");
if($prefdata->num_rows)
{
$pdata = $prefdata->fetch_assoc();
}
mysqli_free_result($prefdata);
if(isset($_SESSION['defaultseasonid_tplss']) || isset($_SESSION['defaultmatchtypeid_tplss']))
{
$seasonid = $_SESSION['defaultseasonid_tplss'];
$compid = $_SESSION['defaultmatchtypeid_tplss'];
}
else
{
$_SESSION['defaultseasonid_tplss'] = $pdata['DefaultSeasonID'];
$_SESSION['defaultmatchtypeid_tplss'] = $pdata['DefaultMatchTypeID'];
$seasonid = $_SESSION['defaultseasonid_tplss'];
$compid = $_SESSION['defaultmatchtypeid_tplss'];
}
if(isset($_REQUEST['id']))
$id = $_REQUEST['id'];
$manager_stmt = $conn->prepare("
SELECT
CONCAT(M.ManagerFirstName, ' ', M.ManagerSurname),
M.ManagerName,
LEFT(M.ManagerDescription, 200),
DATE_FORMAT(C.ContractStartDate, '%M %D, %Y'),
DATE_FORMAT(C.ContractStartDate, '%Y-%m-%d'),
DATE_FORMAT(C.ContractEndDate, '%M %D, %Y'),
DATE_FORMAT(C.ContractEndDate, '%Y-%m-%d'),
DATE_FORMAT(M.ManagerDOB, '%M %D, %Y'),
DATE_FORMAT(M.ManagerDOB, '%Y-%m-%d'),
DATE_FORMAT(M.ManagerDOB, '%Y'),
DATE_FORMAT(M.ManagerDOB, '%m-%d'),
M.ManagerBirthplace,
DATE_FORMAT(M.ManagerDied, '%M %D, %Y'),
DATE_FORMAT(M.ManagerDied, '%Y-%m-%d'),
DATE_FORMAT(M.ManagerDied, '%Y'),
DATE_FORMAT(M.ManagerDied, '%m-%d'),
M.ManagerDead,
M.ManagerDeathplace,
M.ManagerPlayerID,
M.ManagerNationID,
M.ManagerDescription,
M.ManagerCaretaker,
M.ManagerCurrent
FROM
tplss_managers M, tplss_manager_contracts C
WHERE
M.ManagerID = ? AND M.ManagerID = C.ContractManagerID
ORDER BY C.ContractStartDate ASC
LIMIT 1
");
$manager_stmt->bind_param( "i", $id);
$manager_stmt->execute();
$manager_stmt->bind_result($name, $fullname, $shortbio, $startdate, $rawstartdate, $enddate, $rawenddate, $dob, $dob2, $dob3, $dob4, $birthplace, $died, $died2, $died3, $died4, $dead, $deathplace, $playerid, $nation, $bio, $caretaker, $current);
$manager_stmt->fetch();
$shortbio = str_replace("
", "\n", $shortbio);
$nation_url = "images/flags/flag_" . $nation . ".jpg";
$head_url_1 = "images/managers_thumbs/" . $id . ".jpg";
$head_url_2 = "images/managers_thumbs/" . $id . "_2.jpg";
$head_url_3 = "images/managers_thumbs/" . $id . "_3.jpg";
$manager_stmt->free_result();
$get_all_seasons = $conn->query("SELECT * FROM tplss_seasonnames ORDER BY SeasonName DESC");
$get_all_comps = $conn->query("SELECT * FROM tplss_matchtypes WHERE MatchGrade != 0 ORDER BY MatchTypeName");
?>
| Manager Statistics | ()