<?php
$con = new mysqli("localhost", "epicrpg_watcher","C5i8op123kraV","epicrpg_stats");
if($con->connect_error){
	die("Connection failed: " . $conn->connect_error);
}
session_start();
if(isset($_GET['page'])) {
    $page = $_GET['page'];
}else{
	$page = 1;
}

require("functions.php");

/*function klasa($klasa){
	$klasa = substr($klasa,2,strlen($klasa)-2);
	switch($klasa){
		case "Wojownik":
			echo '<td id="klasa_wojownik">Wojownik</td>';
			break;
		case "Mag":
			echo '<td id="klasa_mag">Mag</td>';
			break;
		case "Mysliwy":
			echo '<td id="klasa_mysliwy">Myśliwy</td>';
			break;
		case "obywatel":
			echo '<td id="klasa_obywatel">Obywatel</td>';
			break;
		default:
			echo '<td id="klasa_blad">Nieznana klasa</td>';
	}
}*/

?>
<html lang="pl">

<head>

	<title>Statystyki graczy EpicRPG</title>
	<meta charset="utf-8">
	<link rel="stylesheet" href="stylesheet.css">
	<link href='https://fonts.googleapis.com/css?family=New Rocker' rel='stylesheet'>
	<script>
		function epicSearch(){
			var input, filter, ul, li, a, i, txtValue;
			input = document.getElementById();
		}
	</script>

</head>

<body>

<div class="menu">
	<div class="el">
		<a href="http://epic-rpg.pl">Strona główna</a>
	</div>
	<div class="el">
		<a href="http://epic-rpg.pl/forum">Forum</a>
	</div>
	<div class="el">
		<a href="http://epic-rpg.pl/staty">Statystyki</a>
	</div>

	<div id="search">
		<form action="info.php" method="get">
			<input type="text" name="nick" value="" size="16" placeholder="Szukaj postać..."></input>
		</form>
	</div>
</div>

<div id="staty">
	<table id="staty">
		<tr>
			<td id="header">Nick</td>
			<td id="header">Klasa</td>
			<td id="header">Poziom</td>
			<td id="header">Doświadczenie</td>
			<td id="header">Awans</td>
			<?php
				
				$query = $con->query("SELECT * FROM players;");
				$maxPage = ceil(mysqli_num_rows($query)/25.0);
				
				$query = $con->query("SELECT players.UUID, players.nick, player_stats.klasa, player_stats.level, player_stats.exp, player_stats.nextLevel ".
					"FROM players ".
					"INNER JOIN player_stats ON players.id = player_stats.player_id ".
					"ORDER BY player_stats.exp DESC ".
					"LIMIT 25 ".
					"OFFSET ".(25*($page-1)).";");
				while($tmp = mysqli_fetch_row($query)){
					/*$uuid = $tmp[0];
					$content = file_get_contents("https://api.mojang.com/users/profiles/minecraft/".$tmp[1]);
					$json = json_decode($content);
					if($json != null) $uuid = $json->id;*/
					echo '<tr id="staty">';
					//echo '<td style="width: 5%;" class="info"><img src="https://visage.surgeplay.com/face/50/'.$uuid.'" id="head"></td>';
					echo '<td style="width: 15%;" class="info"><a href="info.php?nick='.$tmp[1].'" >'.$tmp[1].'</a></td>';
					klasa($tmp[2]);
					for($i=3; $i<count($tmp); ++$i){
						echo '<td style="width: 20%;" class="info">'.$tmp[$i]."</td>";
					}
					echo "</tr>";
				}
				
			?>
			</td>
		</tr>
	</table>
</div>

<div class="pages">

	<?php

	if($page>1){
		echo '<div class="back"><a href="index.php?page='.($page-1).'"> Poprzednia strona </a></div>';
	}
	if($page<$maxPage){
		echo '<div class="next"><a href="index.php?page='.($page+1).'"> Następna strona </a></div>';
	}

	?>
</div>

</body>

</html>