/html/pages/match_info_killsmatrix.php
https://github.com/graywh/utstats · PHP · 131 lines · 108 code · 14 blank · 9 comment · 15 complexity · 9631e71493757655225d90a7f1734dff MD5 · raw file
- <?php
- function PrintVertical($text) {
- $len = strlen($text);
- $ret = '';
- for ($i = 0; $i < $len; $i++) {
- $ret .= substr($text, $i, 1) .'<br>';
- }
- 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 '<table border="0" cellpadding="1" cellspacing="2">
- <tbody><tr>
- <td class="heading" colspan="'. (count($players) + $extra) .'" align="center">Kills Match Up</td>
- </tr>
- <tr>
- <td class="dark" colspan="'.$extra.'" rowspan="'.$extra.'" align="center"> </td>
- <td class="dark" colspan="'. count($players).'" align="center"><strong>Victim</strong></td>
- </tr>
- <tr>';
-
- // Victims
- foreach($players as $player) {
-
-
- echo '<td class="darkhuman" align="center" onmouseover="overlib(\''.
- str_replace('"', '\\\'', QuoteHintText(FormatPlayerName($player['country'], $player['pid'], $player['name'], $gid, $gamename))) .'\');" onmouseout="nd();">
- <a class="darkhuman" href="?p=matchp&mid='. $mid .'&pid='. urlencode($player['pid']). '">'.
- PrintVertical($player['name']) .
- '</a></td>';
- }
- echo '</tr><tr>';
-
- // 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 '<td class="'. $teamcolor .'" align="center" width="20">
- </td>';
- }
- echo '</tr>';
- }
-
- // Killer rows
- $first = true;
- $i = 0;
- foreach($players as $kid => $killer) {
- if ($killer['banned'] == 'Y') continue;
- $i++;
- echo '<tr>';
- if ($first) echo'<td class="dark" rowspan="'. count($players) .'" align="center" width="20"><strong>K<br>i<br>l<br>l<br>e<br>r</strong></td>';
- echo '<td nowrap class="darkhuman" align="left" style="width: 150px;">';
- echo '<a class="darkhuman" href="?p=matchp&mid='. $mid .'&pid='. urlencode($killer['pid']). '">'.
- FormatPlayerName($killer['country'], $killer['pid'], $killer['name'], $gid, $gamename) .' </a></td>';
- 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 '<td class="'. $teamcolor .'" align="center" width="20"> </td>';
- }
- foreach($players as $vid => $victim) {
- $class = ($kid == $vid) ? 'darkgrey' : 'grey';
- //if ($i % 2) $class .= '2';
- echo '<td class="'. $class .'" align="center" width="20">';
- if ($kid == $vid) {
- $val = ($killer['suicides'] != 0) ? $killer['suicides'] : ' ';
- } else {
- $val = (isset($km[$kid][$vid])) ? $km[$kid][$vid] : ' ';
- }
- echo $val .'</td>';
- }
-
- $first = false;
- }
-
- echo '</tbody></table><br>';
- ?>