From 11dbc16efd459aeca1c19290f41924d2cc9eae0b Mon Sep 17 00:00:00 2001 From: randommonk Date: Tue, 6 Feb 2018 21:02:29 +0000 Subject: Add win percentage to career summary --- html/pages/players_info.php | 75 ++++++++++++++++++++++++++++++++++++++------- 1 file changed, 64 insertions(+), 11 deletions(-) (limited to 'html/pages/players_info.php') diff --git a/html/pages/players_info.php b/html/pages/players_info.php index 1ddb631..746bac1 100755 --- a/html/pages/players_info.php +++ b/html/pages/players_info.php @@ -84,7 +84,7 @@ echo ' - + + '; -$sql_plist = "SELECT g.name AS gamename, SUM(p.gamescore) AS gamescore, SUM(p.frags) AS frags, SUM(p.kills) AS kills, SUM(p.deaths) AS deaths, - SUM(p.suicides) AS suicides, SUM(p.teamkills) AS teamkills, SUM(kills+deaths+suicides+teamkills) AS sumeff, AVG(p.accuracy) AS accuracy, AVG(p.ttl) AS ttl, - COUNT(p.id) AS games, SUM(p.gametime) as gametime - FROM uts_player AS p, uts_games AS g WHERE p.gid = g.id AND p.pid = '$pid' GROUP BY p.gid"; - +$sql_plist = "SELECT + g.name AS gamename, + SUM(p.gamescore) AS gamescore, + COUNT(p.gamescore) as played, + SUM(p.frags) AS frags, + SUM(p.kills) AS kills, + SUM(p.deaths) AS deaths, + SUM(p.suicides) AS suicides, + SUM(p.teamkills) AS teamkills, + SUM(p.kills+p.deaths+p.suicides+p.teamkills) AS sumeff, + AVG(p.accuracy) AS accuracy, + AVG(p.ttl) AS ttl, + SUM(IF( + p.team = 0, + IF((m.t0score > m.t1score AND m.t0score > m.t2score AND m.t0score > m.t3score), 1, 0), + IF( + p.team = 1, + IF((m.t1score > m.t0score AND m.t1score > m.t2score AND m.t1score > m.t3score), 1, 0), + IF( + p.team = 2, + IF((m.t2score > m.t0score AND m.t2score > m.t1score AND m.t2score > m.t3score), 1, 0), + IF((m.t3score > m.t0score AND m.t3score > m.t1score AND m.t3score > m.t2score), 1, 0) + ) + ) +)) as wins, + COUNT(p.id) AS games, + SUM(p.gametime) as gametime + FROM + uts_player AS p, + uts_games AS g, + uts_match as m + WHERE + p.gid = g.id AND m.id = p.matchid + AND + p.pid = '$pid' + GROUP BY + p.gid"; + $q_plist = mysql_query($sql_plist) or die(mysql_error()); while ($r_plist = mysql_fetch_array($q_plist)) { @@ -121,6 +156,7 @@ while ($r_plist = mysql_fetch_array($q_plist)) { $eff = get_dp($r_plist[kills]/$r_plist[sumeff]*100); $acc = get_dp($r_plist[accuracy]); $ttl = GetMinutes($r_plist[ttl]); + $winpercent = round($r_plist[wins]/$r_plist[games]*100, 2); echo' @@ -134,20 +170,35 @@ while ($r_plist = mysql_fetch_array($q_plist)) { - + + + '; } -$r_sumplist = small_query("SELECT SUM(gamescore) AS gamescore, SUM(frags) AS frags, SUM(kills) AS kills, SUM(deaths) AS deaths, - SUM(suicides) AS suicides, SUM(teamkills) AS teamkills, SUM(kills+deaths+suicides+teamkills) AS sumeff, - AVG(accuracy) AS accuracy, AVG(ttl) AS ttl, COUNT(id) AS games, SUM(gametime) as gametime - FROM uts_player WHERE pid = '$pid'"); +$r_sumplist = small_query("SELECT SUM(p.gamescore) AS gamescore, SUM(p.frags) AS frags, SUM(p.kills) AS kills, SUM(p.deaths) AS deaths, +SUM(p.suicides) AS suicides, SUM(p.teamkills) AS teamkills, SUM(p.kills+p.deaths+p.suicides+p.teamkills) AS sumeff, +AVG(p.accuracy) AS accuracy, AVG(p.ttl) AS ttl, COUNT(p.id) AS games, SUM(IF( + p.team = 0, + IF((m.t0score > m.t1score AND m.t0score > m.t2score AND m.t0score > m.t3score), 1, 0), + IF( + p.team = 1, + IF((m.t1score > m.t0score AND m.t1score > m.t2score AND m.t1score > m.t3score), 1, 0), + IF( + p.team = 2, + IF((m.t2score > m.t0score AND m.t2score > m.t1score AND m.t2score > m.t3score), 1, 0), + IF((m.t3score > m.t0score AND m.t3score > m.t1score AND m.t3score > m.t2score), 1, 0) + ) + ) +)) as wins, SUM(p.gametime) as gametime +FROM uts_player p, uts_match m WHERE p.matchid = m.id AND pid = '$pid'"); $gametime = sec2hour($r_sumplist[gametime]); $eff = get_dp($r_sumplist[kills]/$r_sumplist[sumeff]*100); $acc = get_dp($r_sumplist[accuracy]); $ttl = GetMinutes($r_sumplist[ttl]); +$winpercent = round($r_sumplist[wins]/$r_sumplist[games]*100, 2); echo' @@ -162,6 +213,8 @@ echo' + +
Career Summary for '.htmlentities($playername).' '; + Career Summary for '.htmlentities($playername).' '; if (PlayerOnWatchlist($pid)) { echo ''; @@ -106,14 +106,49 @@ echo ' Acc. Avg TTL MatchesWinsWin Percentage Hours
'.$eff.' '.$acc.' '.$ttl.''.$r_plist[games].''.$r_plist[games].''.$r_plist[wins].''.$winpercent.'% '.$gametime.'
'.$acc.' '.$ttl.' '.$r_sumplist[games].''.$r_sumplist[wins].''.$winpercent.'% '.$gametime.'
-- cgit