STHS-DynamicWebsite-Production/EntryDraftHistory.php at master · SimonT-STHS/STHS-DynamicWebsite-Production · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
<?php include "Header.php";
If ($lang == "fr"){include 'LanguageFR-League.php';}else{include 'LanguageEN-League.php';}
$Title = (string)"";
If (file_exists($DatabaseFile) == false){
	Goto STHSErrorEntryDraftHistory;
}else{try{
	$LeagueName = (string)"";

	$db = new SQLite3($DatabaseFile);

	$Query = "Select Name, NumbersOfTeam from LeagueGeneral";
	$LeagueGeneral = $db->querySingle($Query,true);
	$LeagueName = $LeagueGeneral['Name'];

	$Year = (integer)0;
	if(isset($_GET['Year'])){$Year = filter_var($_GET['Year'], FILTER_SANITIZE_NUMBER_INT);}

	If ($Year > 0){
		$Query = "SELECT MainTable.* FROM (SELECT PlayerInfo.Number, PlayerInfo.Name, 'False' AS PosG, DraftYear, DraftOverallPick, DraftOriginalTeam FROM PlayerInfo WHERE DraftYear = " . $Year . " UNION ALL SELECT GoalerInfo.Number, GoalerInfo.Name, 'True' AS PosG, DraftYear, DraftOverallPick, DraftOriginalTeam FROM GoalerInfo WHERE DraftYear = " . $Year . ") AS MainTable UNION ALL SELECT 0 AS Number, Prospects.Name, 'False' AS PosG, Prospects.Year As DraftYear, Prospects.OverallPick As DraftOverallPick, TeamProInfo.Name AsDraftOriginalTeam FROM Prospects LEFT JOIN TeamProInfo ON Prospects.TeamNumber = TeamProInfo.Number Where DraftYear = " . $Year . " ORDER BY DraftYear, DraftOverallPick";
		$EntryDraftHistory = $db->query($Query);
		echo "<title>" . $LeagueName . " - " . $EntryDraftLang['HistoryDraftYear'] . $Year . "</title>";
	}else{
		$EntryDraftHistory = Null;
		echo "<title>" . $LeagueName . " - " . $EntryDraftLang['HistoryDraftYear'] . "</title>";
		echo "<style>.STHSEntryDraftHistory_MainDiv{display:none}</style>";
	}

} catch (Exception $e) {
STHSErrorEntryDraftHistory:
	$LeagueName = $DatabaseNotFound;
	$EntryDraftHistory = Null;
	echo "<title>" . $DatabaseNotFound ."</title>";
	echo "<style>.STHSEntryDraftHistory_MainDiv{display:none}</style>";
}}?>
</head><body>
<?php include "Menu.php";?>

<div class="STHSEntryDraftHistory_MainDiv" style="width:99%;margin:auto;">
<?php echo "<br /><div class=\"STHSDivInformationMessage\">" . $EntryDraftLang['HistoryDraftYearNote'] .  "</div><br>";
echo "<h1>" . $EntryDraftLang['HistoryDraftYear'] . $Year . "</h1>"; ?>
<table class="STHSEntryDraft_MainTable">
<thead><tr>
<th class="STHSEntryDraf_Rank"><?php echo $EntryDraftLang['Rank'];?></th>
<th class="STHSEntryDraft_Pick"><?php echo $EntryDraftLang['Pick'];?></th>
<th class="STHSEntryDraft_Team"><?php echo $EntryDraftLang['OriginalTeam'];?></th>
</tr></thead><tbody>
<?php
if (empty($EntryDraftHistory) == false){while ($row = $EntryDraftHistory ->fetchArray()) {
	echo "<tr><td>" . $row['DraftOverallPick'] . "</td>";
	if ($row['Number'] > 0){
		if ($row['PosG']== "True"){echo "<td><a href=\"GoalieReport.php?Goalie=";}else{echo "<td><a href=\"PlayerReport.php?Player=";}
		echo $row['Number'] . "\">" . $row['Name'] . "</a></td>";
	}else{
		echo "<td>" . $row['Name'] . "</td>";
	}
	echo "<td>" . $row['DraftOriginalTeam'] . "</td></tr>\n";
}}
?>
</tbody></table>

<br>
</div>

<?php include "Footer.php";?>