$m=mysqli_query($link, "SELECT * FROM reports WHERE MATCH_GUID = '".$row[MATCH_GUID]."'");
$map = mysqli_fetch_array($m);
$elo = $row[new_elo] - $row[old_elo];
if ($elo < 0){
$elo = "<span style='color:red'>$elo</span>";
}
else{
$elo = "<span style='color:green'>+$elo</span>";
}
?>
<tr>
<td><? echo date("d.m.Y", strtotime($row[date])); ?></td>
<td class="player"><a href="player.php?sid=<? echo $winner[STEAM_ID]; ?>"><? echo quakename($winner[NAME]); ?></a><br><? echo $winner[old_elo]; ?></td>
<td><span class="score"><? echo $winner[SCORE]; ?></span></td>
<td><span class="score"><? echo $loser[SCORE]; ?></span></td>
<td class="player"><a href="player.php?sid=<? echo $loser[STEAM_ID]; ?>"><? echo quakename($loser[NAME]); ?></a><br><? echo $loser[old_elo]; ?></td>
<td><a href="match?guid=<? echo $row[MATCH_GUID]; ?>"><img src="images/levelshots/<? echo $map[MAP]; ?>.jpg" style="height:42px;width:56px;border-width:0px;"></a></td>
<td><? echo $elo; ?></td>
</tr>
<?
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<script type="text/javascript">
$(document).ready(function () {var mapData = [
<td style="text-align: center;"><img src="images/medals/medal_excellent.png" width="28px"></td>
<td colspan="2" style="text-align: left;"><?php echo $damage->TAKEN;?></td>
<td></td>
</tr>
<tr>
<td></td>
<td colspan="2" style="text-align: right;"><? echo $winner[old_elo];?></td>
<td style="text-align: center;">ELO</td>
<td colspan="2" style="text-align: left;"><? echo $loser[old_elo];?></td>
<td></td>
</tr>
</table>
</div>
<div class="right-sixth" style="text-align:center;">
<h2><? echo quakename($loser[NAME]);?></h2>
<div id="avatar">
<img id="ctl00_ContentPlaceHolder1_imgModel" src="images/models/<? echo $loser[MODEL];?>.png" style="border-width:0px; transform: scale(-1, 1)">
</div>
<div id="medals">
<?php
$medexc=0;
$medimp=0;
$medhum=0;
$m = mysqli_query($link, "SELECT *,COUNT(*) as summed FROM medals WHERE WARMUP!='1' AND STEAM_ID='".$loser[STEAM_ID]."' AND MATCH_GUID = '".$mm[MATCH_GUID]."' GROUP BY MEDAL");
while($medal = mysqli_fetch_array($m)){
if ($medal[MEDAL] == "EXCELLENT"){
$medexc=$medal[summed];
}
if ($medal[MEDAL] == "IMPRESSIVE"){
<td><img src="images/medals/medal_excellent.png"></td>
<?
$m6=mysqli_query($link, "SELECT COUNT(*), NAME, STEAM_ID FROM medals WHERE MEDAL = 'EXCELLENT' GROUP BY STEAM_ID ORDER BY COUNT(*) DESC LIMIT 1");
$med6 = mysqli_fetch_array($m6);
?>
<td><? echo $med6[0]; ?></td>
<td class="player"><a href="player.php?sid=<? echo $med6[2]; ?>"><? echo quakename($med6[1]); ?></a></td>
</tr>
<tr>
<td><img src="images/medals/medal_firstfrag.png"></td>
<?
$m7=mysqli_query($link, "SELECT COUNT(*), NAME, STEAM_ID FROM medals WHERE MEDAL = 'FIRSTFRAG' GROUP BY STEAM_ID ORDER BY COUNT(*) DESC LIMIT 1");
$med7 = mysqli_fetch_array($m7);
?>
<td><? echo $med7[0]; ?></td>
<td class="player"><a href="player.php?sid=<? echo $med7[2]; ?>"><? echo quakename($med7[1]); ?></a></td>
</tr>
</tbody>
</table>
</div>
</div>
<script type="text/javascript">
$(document).ready(function () {var mapData = [
<?
$m=mysqli_query($link, "SELECT COUNT(*), MAP FROM matches GROUP BY MAP");
while($map = mysqli_fetch_array($m)){
if ($map[0] > 5) {
echo "{label: \"$map[1]\", data: $map[0]},";
}
}