'; } return($ret); } // Retrieve the killmatrix $sql_km = " SELECT killer, victim, kills FROM uts_killsmatrix WHERE matchid = $mid;"; $q_km = mysql_query($sql_km) or die(mysql_error()); while ($r_km = mysql_fetch_array($q_km)) { $km[intval($r_km['killer'])][intval($r_km['victim'])] = $r_km['kills']; } // No matrix: bye if (!isset($km)) return; // Are we processing a teamgame? $qm_teamgame = small_query("SELECT teamgame FROM uts_match WHERE id = '$mid';"); $teamgame = $qm_teamgame['teamgame']; $teamgame = ($teamgame == 'False') ? false : true; // Get the players of this match $sql_players = " SELECT p.pid, p.playerid, pi.name, pi.country, pi.banned, p.team, p.suicides FROM uts_player p, uts_pinfo pi WHERE (p.pid = pi.id) AND matchid = '$mid' ORDER BY team ASC, gamescore DESC;"; $q_players = mysql_query($sql_players) or die(mysql_error()); while ($r_players = mysql_fetch_array($q_players)) { $players[intval($r_players['playerid'])] = array( 'pid' => $r_players['pid'], 'name' => $r_players['name'], 'country' => $r_players['country'], 'banned' => $r_players['banned'], 'suicides' => intval($r_players['suicides']), 'team' => intval($r_players['team'])); } // Table header $extra = $teamgame ? 3 : 2; echo ''; // Victims foreach($players as $player) { echo ''; } echo ''; // Team colors victims if ($teamgame) { foreach($players as $player) { switch($player['team']) { case 0: $teamcolor = 'redteam'; break; case 1: $teamcolor = 'blueteam'; break; case 2: $teamcolor = 'greenteam'; break; case 3: $teamcolor = 'goldteam'; break; } echo ''; } echo ''; } // Killer rows $first = true; $i = 0; foreach($players as $kid => $killer) { if ($killer['banned'] == 'Y') continue; $i++; echo ''; if ($first) echo''; echo ''; if ($teamgame) { switch($killer['team']) { case 0: $teamcolor = 'redteam'; break; case 1: $teamcolor = 'blueteam'; break; case 2: $teamcolor = 'greenteam'; break; case 3: $teamcolor = 'goldteam'; break; } echo ''; } foreach($players as $vid => $victim) { $class = ($kid == $vid) ? 'darkgrey' : 'grey'; //if ($i % 2) $class .= '2'; echo ''; } $first = false; } echo '

Kills Match Up
	Victim
'. PrintVertical($player['name']) . '
K i l l e r	'; echo ''. FormatPlayerName($killer['country'], $killer['pid'], $killer['name'], $gid, $gamename) .'		'; if ($kid == $vid) { $val = ($killer['suicides'] != 0) ? $killer['suicides'] : ' '; } else { $val = (isset($km[$kid][$vid])) ? $km[$kid][$vid] : ' '; } echo $val .'

'; ?>