From 40dfa7d5c0dc8e4cb2c95e403b6b4b2c4bf70644 Mon Sep 17 00:00:00 2001 From: Matthijs Kuiper Date: Sat, 4 Feb 2017 16:05:45 +0100 Subject: Original UTStats beta 4.2.8 --- html/pages/match_info_killsmatrix.php | 131 ++++++++++++++++++++++++++++++++++ 1 file changed, 131 insertions(+) create mode 100755 html/pages/match_info_killsmatrix.php (limited to 'html/pages/match_info_killsmatrix.php') diff --git a/html/pages/match_info_killsmatrix.php b/html/pages/match_info_killsmatrix.php new file mode 100755 index 0000000..be16905 --- /dev/null +++ b/html/pages/match_info_killsmatrix.php @@ -0,0 +1,131 @@ +'; + } + 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 .'

'; +?> \ No newline at end of file -- cgit