<?php

// Convert a SteamID to SteamID64 format.
function toCommunityID($id) {
	if (preg_match('/^STEAM_/', $id)) {
		$parts = explode(':', $id);
		return bcadd(bcadd(bcmul($parts[2], '2'), '76561197960265728'), $parts[1]);
	} else if (is_numeric($id) && strlen($id) < 16) {
		return bcadd($id, '76561197960265728');
	} else {
		return $id; // We have no idea what this is, so just return it.
	}
}

// Show the active guard bans in the database.
function showActiveBans() {
	include 'includes/config.php';

	$conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname);

	if ($conn->connect_error) {
		die("Connection failed: " . $conn->connect_error);
	}
	$query = "SELECT * FROM `guardbans` WHERE `status` = '1';";
	$results = $conn->query($query);

	if ($results->num_rows > 0) {
		while ($row = $results->fetch_assoc()) {
			$name     			= $row['name'];
			$steamid  			= $row['steamid'];
			$time	  			= $row['time'];
			$timeleft 			= $row['timeleft'];
			$ban_admin_name 	= $row['ban_admin_name'];
			$ban_admin_steamid 	= $row['ban_admin_steamid'];
			$ban_reason			= $row['ban_reason'];
			$ban_date 			= $row['ban_date'];
			if ($ban_date === '0000-00-00 00:00:00') {
				$ban_date = 'Unavailable';
			} else {
				$ban_date = date('l, F jS (g:i A)', strtotime($ban_date));
			}

			$name = str_replace("[F2P]", "", $name);
			$steamid64 = toCommunityID($steamid);

			echo "<tr>";
			echo "<td><a href='http://steamcommunity.com/profiles/" . $steamid64 . "' target='_blank'> " . $name . "</a></td>";
			echo "<td>" . $time . " minutes</td>";
			echo "<td>" . $timeleft . " minutes</td>";
			echo "<td>";
			if ($ban_admin_steamid !== 'CONSOLE') {
				echo "<a href='http://steamcommunity.com/profiles/" . toCommunityID($ban_admin_steamid) . "' target='_blank'>" . $ban_admin_name . "</a>";
			} else {
				echo 'CONSOLE';
			}
			echo "</td>";
			echo "<td>" . $ban_reason . "</td>";
			echo "<td>" . $ban_date . "</td>";
			echo "</tr>";
		}
	} else {
		echo "No results found.";
	}

	$conn->close();
}

// Show the expired guard bans in the database.
function showExpiredBans() {
	include 'includes/config.php';

	$conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname);

	if ($conn->connect_error) {
		die("Connection failed: " . $conn->connect_error);
	}
	$query = "SELECT * FROM `guardbans` WHERE `status` = '0';";
	$results = $conn->query($query);

	if ($results->num_rows > 0) {
		while ($row = $results->fetch_assoc()) {
			$name     			= $row['name'];
			$steamid  			= $row['steamid'];
			$time	  			= $row['time'];
			$ban_admin_name 	= $row['ban_admin_name'];
			$ban_admin_steamid 	= $row['ban_admin_steamid'];
			$ban_reason			= $row['ban_reason'];
			$ban_date 			= $row['ban_date'];
			$expire_date 		= $row['expire_date'];
			if ($ban_date === '0000-00-00 00:00:00') {
				$ban_date = 'Unavailable';
			} else {
				$ban_date = date('l, F jS (g:i A)', strtotime($ban_date));
			}

			if ($expire_date === '0000-00-00 00:00:00') {
				$expire_date = 'Unavailable';
			} else {
				$expire_date = date('l, F jS (g:i A)', strtotime($expire_date));
			}

			$name = str_replace("[F2P]", "", $name);

			echo "<tr>";
			echo "<td><a href='http://steamcommunity.com/profiles/" . toCommunityID($steamid) . "' target='_blank'>" . $name . "</a></td>";
			echo "<td>" . $time . " minutes</td>";
			echo "<td>";
			if ($ban_admin_steamid !== 'CONSOLE') {
				echo "<a href='http://steamcommunity.com/profiles/" . toCommunityID($ban_admin_steamid) . "' target='_blank'>" . $ban_admin_name . "</a>";
			} else {
				echo 'CONSOLE';
			}
			echo "</td>";
			echo "<td>" . $ban_reason . "</td>";
			echo "<td>" . $ban_date . "</td>";
			echo "<td>" . $expire_date . "</td>";
			echo "</tr>";
		}
	} else {
		echo "No results found.";
	}

	$conn->close();
}

// Show the unbanned guard bans in the database.
function showUnbannedBans() {
	include 'includes/config.php';

	$conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname);

	if ($conn->connect_error) {
		die("Connection failed: " . $conn->connect_error);
	}
	$query = "SELECT * FROM `guardbans` WHERE `status` = '-1';";
	$results = $conn->query($query);

	if ($results->num_rows > 0) {
		while ($row = $results->fetch_assoc()) {
			$name     			 = $row['name'];
			$steamid  			 = $row['steamid'];
			$time	  			 = $row['time'];
			$ban_admin_name 	 = $row['ban_admin_name'];
			$ban_admin_steamid 	 = $row['ban_admin_steamid'];
			$ban_reason			 = $row['ban_reason'];
			$ban_date 			 = $row['ban_date'];
			$unban_admin_name	 = $row['unban_admin_name'];
			$unban_admin_steamid = $row['unban_admin_steamid'];
			$unban_reason 		 = $row['unban_reason'];
			$unban_date 		 = $row['unban_date'];
			if ($ban_date === '0000-00-00 00:00:00') {
				$ban_date = 'Unavailable';
			} else {
				$ban_date = date('l, F jS (g:i A)', strtotime($ban_date));
			}

			if ($unban_date === '0000-00-00 00:00:00') {
				$unban_date = 'Unavailable';
			} else {
				$unban_date = date('l, F jS (g:i A)', strtotime($unban_date));
			}

			$name = str_replace("[F2P]", "", $name);

			echo "<tr>";
			echo "<td><a href='http://steamcommunity.com/profiles/" . toCommunityID($steamid) . "' target='_blank'>" . $name . "</a></td>";
			echo "<td>" . $time . " minutes</td>";
			echo "<td>";
			if ($ban_admin_steamid !== 'CONSOLE') {
				echo "<a href='http://steamcommunity.com/profiles/" . toCommunityID($ban_admin_steamid) . "' target='_blank'>" . $ban_admin_name . "</a>";
			} else {
				echo 'CONSOLE';
			}
			echo "</td>";
			echo "<td>" . $ban_reason . "</td>";
			echo "<td>" . $ban_date . "</td>";
			echo "<td>";
			if ($unban_admin_steamid !== 'CONSOLE') {
				echo "<a href='http://steamcommunity.com/profiles/" . toCommunityID($unban_admin_steamid) . "' target='_blank'>" . $unban_admin_name . "</a>";
			} else {
				echo 'CONSOLE';
			}
			echo "</td>";
			echo "<td>" . $unban_reason . "</td>";
			echo "<td>" . $unban_date . "</td>";
			echo "</tr>";
		}
	} else {
		echo "No results found.";
	}

	$conn->close();
}