<?php
$con = new mysqli("localhost", "epicrpg_watcher","C5i8op123kraV","epicrpg_stats");
if($con->connect_error){
	die("Connection failed: " . $conn->connect_error);
}
if (isset($_GET['nick'])){
	$query = $con->query("SELECT players.UUID from players WHERE nick=\"".$_GET['nick']."\";");
	while($tmp = mysqli_fetch_row($query)){
		$id = $tmp[0];
		$uuid = $id;
	}
} else {
	header("Location: index.php");
}
session_unset();

$content = file_get_contents("https://api.mojang.com/users/profiles/minecraft/".$_GET['nick']);
$json = json_decode($content);
if($json != null) $uuid = $json->id;

require("functions.php");

/*function getRzemioslo($id){
	switch($id){
		case 0:
			return "Alchemia";
		case 1:
			return "Kowalstwo";
		case 2:
			return "Płatnerstwo";
		case 3:
			return "Łuczarstwo";
		default:
			return "BŁĄD";
	}
}

function getSkill($id){
	switch($id){
		case 0:
			return "Regeneracja many";
		case 1:
			return "Bezdenny kołczan";
		case 2:
			return "Wiecznie najedzony";
		case 3:
			return "Sługa Beliara";
		case 4:
			return "Mag krwi";
		case 5:
			return "Cios krytyczny";
		default:
			return "BŁĄD";
	}
}

function getWaluta($id){
	switch($id){
		case 0:
			return "Stygia";
		case 1:
			return "Smocze monety";
		default:
			return "BŁĄD";
	}
}*/

?>
<html lang="pl">

<head>

	<title>Statystyki gracza</title>
	<meta charset="utf-8">
	<link rel="stylesheet" href="stylesheet.css">
	<link href='https://fonts.googleapis.com/css?family=New Rocker' rel='stylesheet'>
	

</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 class="info">

	<?php

		echo '<div class="player"><img class="player" src="https://visage.surgeplay.com/full/350/'.$uuid.'"></div>';

	?>
	<div id="staty_p">
		<table id="staty">
			<tr>
				<td colspan="2" id="header">Informacje</td>
			</tr>
			
			<?php
						
				$query = $con->query("SELECT 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 ".
					"WHERE players.UUID='".$id."';");
				while($tmp = mysqli_fetch_row($query)){
					
					echo "<tr id='staty'><td class='info'>Gracz</td><td class='info'>".$tmp[0]."</td></tr>";
					echo "<tr id='staty'><td class='info'>Klasa</td>";
					klasa($tmp[1]);
					echo " ".$tmp[1];
					echo "</tr>";
					echo "<tr id='staty'><td class='info'>Poziom</td><td class='info'>".$tmp[2]." ".($tmp[2]==70?"(MAX)":"")."</td></tr>";
					if($tmp[2]<70){
						echo "<tr id='staty'><td class='info'>Doświadczenie</td><td class='info'>".$tmp[3]."/".$tmp[4]."</td></tr>";
					}
					
					/*echo '<tr id="staty">';
					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>";*/
				}
						
					?>
			
		</table>
	</div>
	<div class="statystyki">
		<table id="staty">
			<tr>
				<td colspan="2" id="header">Statystyki</td>
			</tr>
			<?php
				$query = $con->query("SELECT player_stats.p_str, player_stats.p_wytrz, player_stats.p_zr, player_stats.p_zd, player_stats.p_int, player_stats.p_mana, player_stats.p_walka, player_stats.p_krag ".
					"FROM players ".
					"INNER JOIN player_stats ON players.id = player_stats.player_id ".
					"WHERE players.UUID='".$id."';");
				while($tmp = mysqli_fetch_row($query)){
					echo '<tr id="staty"><td class="info" style="width: 75%;">Siła</td><td class="info" style="width: 25%;">'.$tmp[0]."</td></tr>";
					echo '<tr id="staty"><td class="info" style="width: 75%;">Wytrzymałość</td><td class="info" style="width: 25%;">'.$tmp[1]."</td></tr>";
					echo '<tr id="staty"><td class="info" style="width: 75%;">Zręczność</td><td class="info" style="width: 25%;">'.$tmp[2]."</td></tr>";
					echo '<tr id="staty"><td class="info" style="width: 75%;">Zdolności myśliwskie</td><td class="info" style="width: 25%;">'.$tmp[3]."</td></tr>";
					echo '<tr id="staty"><td class="info" style="width: 75%;">Inteligencja</td><td class="info" style="width: 25%;">'.$tmp[4]."</td></tr>";
					echo '<tr id="staty"><td class="info" style="width: 75%;">Mana</td><td class="info" style="width: 25%;">'.$tmp[5]."</td></tr>";
					echo '<tr id="staty"><td class="info" style="width: 75%;">Walka</td><td class="info" style="width: 25%;">'.$tmp[6]."</td></tr>";
					echo '<tr id="staty"><td class="info" style="width: 75%;">Krąg magii</td><td class="info" style="width: 25%;">'.$tmp[7]."</td></tr>";
				}
					
				?>
		</table>
	</div>

	<div class="stopka">

		<div class="kolekcja">
			<table id="staty">
				<tr>
					<td colspan="2" id="header">Kolekcja</td>
				</tr>
				<?php
				
					$query = $con->query("SELECT player_stats.p_stygia, player_stats.p_coins ".
						"FROM players ".
						"INNER JOIN player_stats ON players.id = player_stats.player_id ".
						"WHERE players.UUID='".$id."';");
					while($tmp = mysqli_fetch_row($query)){
						for($i=0; $i<count($tmp); ++$i){
							echo "<tr id='staty'><td class='info'>".getWaluta($i)."</td>";
							echo "<td class='info'>".$tmp[$i]."</td></tr>";
						}
					}
				
				?>
			</table>
		</div>

		<div class="rzemioslo">
			<table id="staty">
				<tr>
					<td id="header">Nauczone rzemiosła</td>
				</tr>
				<?php
				
					$query = $con->query("SELECT player_rzemioslo.alchemia, player_rzemioslo.kowalstwo, player_rzemioslo.platnerstwo, player_rzemioslo.luczarstwo ".
						"FROM players ".
						"INNER JOIN player_rzemioslo ON players.id = player_rzemioslo.player_id ".
						"WHERE players.UUID='".$id."';");
					while($tmp = mysqli_fetch_row($query)){
						$hasRzemioslo = false;
						for($i=0; $i<count($tmp); ++$i){
							if($tmp[$i]==true) {
								$hasRzemioslo = true;
								echo "<tr id='staty'><td class='info'>".getRzemioslo($i)."</td></tr>";
							}
						}
						if(!$hasRzemioslo){
							echo "<tr id='staty'><td class='info'>BRAK</td></tr>";
						}
					}
				
				?>
			</table>
		</div>
		
		<div class="skills">
			<table id="staty">
				<tr>
					<td id="header">Umiejętności</td>
				</tr>
				
				<?php
				
					$query = $con->query("SELECT player_skills.manaReg, player_skills.unlimitArr, player_skills.foodless, player_skills.slugaBeliara, player_skills.magKrwi, player_skills.ciosKrytyczny ".
						"FROM players ".
						"INNER JOIN player_skills ON players.id = player_skills.player_id ".
						"WHERE players.UUID='".$id."';");
					while($tmp = mysqli_fetch_row($query)){
						$hasSkills = false;
						for($i=0; $i<count($tmp); ++$i){
							if($tmp[$i]==true) {
								$hasSkills = true;
								echo "<tr id='staty'><td class='info'>".getSkill($i)."</td></tr>";
							}
						}
						if(!$hasSkills){
							echo "<tr id='staty'><td class='info'>BRAK</td></tr>";
						}
					}
				
				?>

			</table>
		</div>
		
	</div>
</div>


</body>

</html>