<?php
				$server = "localhost";
				$dbuser = "login";
				$dbpass = "haslo";
				$dbname = "sbany";

				mysql_connect($server, $dbuser, $dbpass);
				mysql_select_db($dbname);?>
				<?php
					$result1 = mysql_query("SELECT * FROM `hardcore_bans` ORDER BY `time` DESC LIMIT 10");
					$result1_nolimit = mysql_query("SELECT * FROM `hardcore_bans`");
					$result1_count = mysql_num_rows($result1_nolimit);
				?>
<center><div style="text-align:center;" class="search-title">Ostatnie bany</div></center><br />
					<div id="allHead"><?php
							if($result1_count > 0) {
								while($res1 = mysql_fetch_row($result1)) {
									$nazwa = $res1[1];
									$guild = mysql_query("SELECT * FROM `hardcore_bans` WHERE `nick` LIKE '%,$nazwa,%' OR `nick` LIKE '$nazwa,%' OR `nick` LIKE '%,$nazwa' OR `nick` = '$nazwa'");

									if(mysql_num_rows($guild) > 0) {
										$gres = mysql_fetch_row($guild);
										$gildia = strtoupper($gres[2]);
									} else {
										$gildia = 'Nie ma banów';
									}
							?>
						<a href="gracz.php?gracz=<?php echo $nazwa; ?>" class="hint--top" data-hint="<?php echo $nazwa; ?>">
						<img class="headLastDied" src="https://minotar.net/avatar/<?php echo $nazwa; ?>/48" alt="<?php echo $nazwa; ?>"></a>
							<?php
								}
							} else {
							echo '';
							}
							?>