Smr\Pages\Account\HistoryGames\Summary

Complexity

Total Complexity

11

Size/Duplication

Total Lines	90
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

1 Method

Rating	Name	Duplication	Size	Complexity
D	buildHistory()	0	86	11

<?php declare(strict_types=1);

namespace Smr\Pages\Account\HistoryGames;

use Smr\Database;
use Smr\Template;
use SmrAccount;

class Summary extends HistoryPage {

	public string $file = 'history_games.php';

	protected function buildHistory(SmrAccount $account, Template $template): void {
		//topic
		$game_name = $this->historyGameName;
		$game_id = $this->historyGameID;
		$template->assign('PageTopic', 'Old SMR Game : ' . $game_name);
		$this->addMenu($template);

		$db = Database::getInstance();
		$dbResult = $db->read('SELECT start_date, type, end_date, game_name, speed, game_id ' .
			'FROM game WHERE game_id = ' . $db->escapeNumber($game_id));
		$dbRecord = $dbResult->record();
		$template->assign('GameName', $game_name);
		$template->assign('Start', date($account->getDateFormat(), $dbRecord->getInt('start_date')));
		$template->assign('End', date($account->getDateFormat(), $dbRecord->getInt('end_date')));
		$template->assign('Type', $dbRecord->getString('type'));
		$template->assign('Speed', $dbRecord->getFloat('speed'));

		$dbResult = $db->read('SELECT count(*), max(experience), max(alignment), min(alignment), max(kills) FROM player WHERE game_id = ' . $db->escapeNumber($game_id));
		if ($dbResult->hasRecord()) {
			$dbRecord = $dbResult->record();
			$template->assign('NumPlayers', $dbRecord->getInt('count(*)'));
			$template->assign('MaxExp', $dbRecord->getInt('max(experience)'));
			$template->assign('MaxAlign', $dbRecord->getInt('max(alignment)'));
			$template->assign('MinAlign', $dbRecord->getInt('min(alignment)'));
			$template->assign('MaxKills', $dbRecord->getInt('max(kills)'));
		}
		$dbResult = $db->read('SELECT count(*) FROM alliance WHERE game_id = ' . $db->escapeNumber($game_id));
		$template->assign('NumAlliances', $dbResult->record()->getInt('count(*)'));

		// Get linked player information, if available
		$oldAccountID = $account->getOldAccountID($this->historyDatabase);
		$dbResult = $db->read('SELECT alliance_id FROM player WHERE game_id = ' . $db->escapeNumber($game_id) . ' AND account_id = ' . $db->escapeNumber($oldAccountID));
		$oldAllianceID = $dbResult->hasRecord() ? $dbResult->record()->getInt('alliance_id') : 0;

		$playerExp = [];
		$dbResult = $db->read('SELECT * FROM player WHERE game_id = ' . $db->escapeNumber($game_id) . ' ORDER BY experience DESC LIMIT 10');
		foreach ($dbResult->records() as $dbRecord) {
			$playerExp[] = [
				'bold' => $dbRecord->getInt('account_id') == $oldAccountID ? 'class="bold"' : '',
				'exp' => $dbRecord->getInt('experience'),
				'name' => $dbRecord->getString('player_name'),
			];
		}
		$template->assign('PlayerExp', $playerExp);

		$playerKills = [];
		$dbResult = $db->read('SELECT * FROM player WHERE game_id = ' . $db->escapeNumber($game_id) . ' ORDER BY kills DESC LIMIT 10');
		foreach ($dbResult->records() as $dbRecord) {
			$playerKills[] = [
				'bold' => $dbRecord->getInt('account_id') == $oldAccountID ? 'class="bold"' : '',
				'kills' => $dbRecord->getInt('kills'),
				'name' => $dbRecord->getString('player_name'),
			];
		}
		$template->assign('PlayerKills', $playerKills);

		//now for the alliance stuff
		$allianceExp = [];
		$dbResult = $db->read('SELECT SUM(experience) as exp, alliance_name, alliance_id
					FROM player JOIN alliance USING (game_id, alliance_id)
					WHERE game_id = ' . $db->escapeNumber($game_id) . ' GROUP BY alliance_id ORDER BY exp DESC LIMIT 10');
		foreach ($dbResult->records() as $dbRecord) {
			$alliance = htmlentities($dbRecord->getString('alliance_name'));
			$id = $dbRecord->getInt('alliance_id');
			$container = new AllianceDetail($this->historyDatabase, $this->historyGameID, $this->historyGameName, $id, $this);
			$allianceExp[] = [
				'bold' => $dbRecord->getInt('alliance_id') == $oldAllianceID ? 'class="bold"' : '',
				'exp' => $dbRecord->getInt('exp'),
				'link' => create_link($container, $alliance),
			];
		}
		$template->assign('AllianceExp', $allianceExp);

		$allianceKills = [];
		$dbResult = $db->read('SELECT kills, alliance_name, alliance_id FROM alliance WHERE game_id = ' . $db->escapeNumber($game_id) . ' ORDER BY kills DESC LIMIT 10');
		foreach ($dbResult->records() as $dbRecord) {
			$alliance = htmlentities($dbRecord->getString('alliance_name'));
			$id = $dbRecord->getInt('alliance_id');
			$container = new AllianceDetail($this->historyDatabase, $this->historyGameID, $this->historyGameName, $id, $this);
			$allianceKills[] = [
				'bold' => $dbRecord->getInt('alliance_id') == $oldAllianceID ? 'class="bold"' : '',
				'kills' => $dbRecord->getInt('kills'),
				'link' => create_link($container, $alliance),
			];
		}
		$template->assign('AllianceKills', $allianceKills);
	}

}