"warning", "Loading" => "warning", "Ready" => "success", "Closed" => "primary", "Crashed" => "danger"];
$View = $_GET["View"] ?? "Gameservers";
$Page = $_GET["Page"] ?? 1;
if ($View == "Gameservers")
{
$GameserverCount = Database::singleton()->run("SELECT COUNT(*) FROM GameServers")->fetchColumn();
$Pagination = Pagination($Page, $GameserverCount, 15);
$Gameservers = Database::singleton()->run(
"SELECT * FROM GameServers ORDER BY ServerID DESC LIMIT 15 OFFSET :Offset",
[":Offset" => $Pagination->Offset]
);
}
else if ($View == "GameJobs")
{
$GameJobCount = Database::singleton()->run("SELECT COUNT(*) FROM GameJobs")->fetchColumn();
$Pagination = Pagination($Page, $GameJobCount, 15);
$GameJobs = Database::singleton()->run(
"SELECT GameJobs.*, GameServers.Name FROM GameJobs
INNER JOIN GameServers ON GameServers.ServerID = GameJobs.ServerID
ORDER BY TimeCreated DESC LIMIT 15 OFFSET :Offset",
[":Offset" => $Pagination->Offset]
);
}
else if ($View == "GameSessions")
{
$GameSessionCount = Database::singleton()->run("SELECT COUNT(*) FROM GameJobSessions")->fetchColumn();
$Pagination = Pagination($Page, $GameSessionCount, 15);
$GameSessions = Database::singleton()->run(
"SELECT * FROM GameJobSessions ORDER BY TimeCreated DESC LIMIT 15 OFFSET :Offset",
[":Offset" => $Pagination->Offset]
);
}
$pageBuilder = new PageBuilder(["title" => "Manage Games"]);
$pageBuilder->buildHeader();
?>
Manage Games
| ID |
Name |
Status |
Active Jobs |
CPU Usage |
Available Memory |
Service Port |
Updated |
fetch(\PDO::FETCH_OBJ)) { ?>
| =$Gameserver->ServerID?> |
=$Gameserver->Name?> |
=$Gameserver->Online && ($Gameserver->LastUpdated + 65) > time() ? "Online" : "Offline"?> |
=$Gameserver->ActiveJobs?>/=$Gameserver->MaximumJobs?> |
=$Gameserver->CpuUsage?>% |
=$Gameserver->AvailableMemory?> MB |
=$Gameserver->ServicePort?> |
=GetReadableTime($Gameserver->LastUpdated)?> |
| Job ID |
Gameserver |
Status |
Version |
Place ID |
Players |
Address |
Port |
Created |
Updated |
fetch(\PDO::FETCH_OBJ)) { ?>
| =$GameJob->JobID?> |
=$GameJob->Name?> |
=$GameJob->Status?> |
=$GameJob->Version?> |
=$GameJob->PlaceID?> |
=$GameJob->PlayerCount?> |
=$GameJob->MachineAddress?> |
=$GameJob->ServerPort?> |
=GetReadableTime($GameJob->TimeCreated)?> |
=GetReadableTime($GameJob->LastUpdated)?> |
| Ticket |
Job ID |
User ID |
Status |
Verified |
Created |
fetch(\PDO::FETCH_OBJ)) { ?>
| =$GameSession->Ticket?> |
=$GameSession->JobID?> |
=$GameSession->UserID?> |
=$GameSession->Active ? "Online" : "Offline"?> |
=$GameSession->Verified ? "Yes" : "No"?> |
=GetReadableTime($GameSession->TimeCreated)?> |
Pages > 1) { ?>
buildFooter(); ?>