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_other2.php | 143 +++++++++++++++++++++++++++++++++++++++ 1 file changed, 143 insertions(+) create mode 100755 html/pages/match_info_other2.php (limited to 'html/pages/match_info_other2.php') diff --git a/html/pages/match_info_other2.php b/html/pages/match_info_other2.php new file mode 100755 index 0000000..1f72fdd --- /dev/null +++ b/html/pages/match_info_other2.php @@ -0,0 +1,143 @@ +'; + weaponstats($mid2, 0, 'Weapons Summary - '.$ass_att2.' Attacking'); +} + +echo' +
+ + + + + + + + + + + + + '; + +$sql_pickups = "SELECT p.pid, pi.name, p.country, SUM(p.pu_pads) AS pu_pads, SUM(p.pu_armour) AS pu_armour, SUM(p.pu_keg) AS pu_keg, +SUM(p.pu_invis) AS pu_invis, SUM(p.pu_belt) AS pu_belt, SUM(p.pu_amp) AS pu_amp +FROM uts_player as p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND matchid = $mid GROUP BY pid ORDER BY name ASC"; +$q_pickups = mysql_query($sql_pickups) or die(mysql_error()); +$i = 0; +while ($r_pickups = zero_out(mysql_fetch_array($q_pickups))) { + $i++; + $class = ($i % 2) ? 'grey' : 'grey2'; + + $r_pname = $r_pickups[name]; + $myurl = urlencode($r_pname); + + echo' + + + + + + + + + '; +} + +IF($mid2 == NULL) { +} else { + echo'
Pickups Summary - '.$ass_att.' Attacking
PlayerPadsArmourKegInvisibilityShield BeltDamage Amp
'.FormatPlayerName($r_pickups[country], $r_pickups[pid], $r_pname, $gid, $gamename).''.$r_pickups[pu_pads].''.$r_pickups[pu_armour].''.$r_pickups[pu_keg].''.$r_pickups[pu_invis].''.$r_pickups[pu_belt].''.$r_pickups[pu_amp].'
+
+ + + + + + + + + + + + + '; + + $sql_pickups = "SELECT p.pid, pi.name, p.country, SUM(p.pu_pads) AS pu_pads, SUM(p.pu_armour) AS pu_armour, SUM(p.pu_keg) AS pu_keg, + SUM(p.pu_invis) AS pu_invis, SUM(p.pu_belt) AS pu_belt, SUM(p.pu_amp) AS pu_amp + FROM uts_player as p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND matchid = $mid2 GROUP BY pid ORDER BY name ASC"; + $q_pickups = mysql_query($sql_pickups) or die(mysql_error()); + $i = 0; + while ($r_pickups = zero_out(mysql_fetch_array($q_pickups))) { + $i++; + $class = ($i % 2) ? 'grey' : 'grey2'; + + $r_pname = $r_pickups[name]; + $myurl = urlencode($r_pname); + + echo' + + + + + + + + + '; + } +} + +$sql_firstblood = small_query("SELECT pi.name, pi.country, m.firstblood FROM uts_match AS m, uts_pinfo AS pi WHERE m.firstblood = pi.id AND m.id = $mid"); +if (!$sql_firstblood) $sql_firstblood = array('country' => '', 'name' => '(unknown)', 'firstblood' => NULL); +$sql_multis = small_query("SELECT SUM(spree_double) AS spree_double, SUM(spree_multi) AS spree_multi, SUM(spree_ultra) AS spree_ultra, SUM(spree_monster) AS spree_monster FROM uts_player WHERE matchid = $mid"); + +IF($mid2 == NULL) { +} else { +$sql_firstblood2 = small_query("SELECT pi.name, pi.country, m.firstblood FROM uts_match AS m, uts_pinfo AS pi WHERE m.firstblood = pi.id AND m.id = $mid2"); +if (!$sql_firstblood2) $sql_firstblood2 = array('country' => '', 'name' => '(unknown)', 'firstblood' => NULL); +$sql_multis2 = small_query("SELECT SUM(spree_double) AS spree_double, SUM(spree_multi) AS spree_multi, SUM(spree_ultra) AS spree_ultra, SUM(spree_monster) AS spree_monster FROM uts_player WHERE matchid = $mid2"); +} +echo'
Pickups Summary - '.$ass_att2.' Attacking
PlayerPadsArmourKegInvisibilityShield BeltDamage Amp
'.FormatPlayerName($r_pickups[country], $r_pickups[pid], $r_pname, $gid, $gamename).''.$r_pickups[pu_pads].''.$r_pickups[pu_armour].''.$r_pickups[pu_keg].''.$r_pickups[pu_invis].''.$r_pickups[pu_belt].''.$r_pickups[pu_amp].'
+
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Special Events - '.$ass_att.' AttackingSpecial Events - '.$ass_att2.' Attacking
First Blood'.FormatPlayerName($sql_firstblood[country], $sql_firstblood[firstblood], $sql_firstblood[name], $gid, $gamename).'First Blood'.FormatPlayerName($sql_firstblood2[country], $sql_firstblood[firstblood], $sql_firstblood2[name], $gid, $gamename).'
Double Kills'.$sql_multis[spree_double].'Double Kills'.$sql_multis2[spree_double].'
Multi Kills'.$sql_multis[spree_multi].'Multi Kills'.$sql_multis2[spree_multi].'
Ultra Kills'.$sql_multis[spree_ultra].'Ultra Kills'.$sql_multis2[spree_ultra].'
Monster Kills'.$sql_multis[spree_monster].'Monster Kills'.$sql_multis2[spree_monster].'
'; +?> -- cgit