diff options
Diffstat (limited to 'html/includes/renderer-general-import.php')
| -rw-r--r-- | html/includes/renderer-general-import.php | 110 |
1 files changed, 52 insertions, 58 deletions
diff --git a/html/includes/renderer-general-import.php b/html/includes/renderer-general-import.php index fbe62fc..6b642f1 100644 --- a/html/includes/renderer-general-import.php +++ b/html/includes/renderer-general-import.php @@ -5,32 +5,31 @@ Retrieve player names & player teams Pretty much utstats code re-used @return $playernames, $playerteams (arrays based on pid) */ -function getPlayerTeam() { +function getPlayerTeam() { global $matchid; - + $playernames = array(); $playerteams = array(); - + $uid = mysql_real_escape_string($uid); - + // Get List of Player IDs and Process What They Have Done $sql_player = "SELECT p.playerid,p.team,i.name FROM uts_player p JOIN uts_pinfo i ON p.pid = i.id WHERE p.matchid=$matchid"; $q_player = mysql_query($sql_player) or die(mysql_error()); - + while ($r_player = mysql_fetch_array($q_player)) { $playerid = $r_player['playerid']; $playername = $r_player['name']; $playerteam = $r_player['team']; $playernames[$playerid] = $playername; - $playerteams[$playerid] = $playerteam; + $playerteams[$playerid] = $playerteam; } - + $r_team = small_query("SELECT COUNT(DISTINCT team) FROM uts_player WHERE matchid=$matchid"); $teams = $r_team[0]; - - return array($playernames,$playerteams,$teams); + return array($playernames,$playerteams,$teams); } /* @@ -38,7 +37,6 @@ Get time game starts, game ends, and ratio compared to real time @return $time_gamestart, $time_gameend, $time_ratio_correction (difference in ut time & real time, typically 110%) */ function getGameStartEndRatio($uid) { - // gather game start & end time $q_logdom = mysql_query("SELECT col0 FROM uts_temp_$uid WHERE col1='game_start' OR col1='game_end' ORDER BY id ASC")or die(mysql_error()); @@ -46,16 +44,14 @@ function getGameStartEndRatio($uid) { $time_gameend = mysql_result($q_logdom,1); //$time_ratio_correction = ($time_gameend-$time_gamestart)/1200; $time_ratio_correction = TIMERATIO; // based on hardcore mode - + return array($time_gamestart, $time_gameend, $time_ratio_correction); } function generateTeamLabels() { - return array('Red Team', 'Blue Team', 'Green Team', 'Gold Team'); } - /* Generate the chart with pickups */ @@ -67,71 +63,69 @@ function renderDataPickups($uid,$team=true,$playerRedWins=true,$topFraggers) { global $renderer_heigth; $uid = mysql_real_escape_string($uid); - - $q_pickups = mysql_query("SELECT SUM(pu_belt), SUM(pu_keg), SUM(pu_pads), SUM(pu_armour), SUM(pu_amp) FROM uts_player as p WHERE matchid = ".mysql_real_escape_string($matchid)." GROUP BY team") or die(mysql_error()); - + + $q_pickups = mysql_query("SELECT SUM(pu_belt), SUM(pu_keg), SUM(pu_pads), SUM(pu_armour), SUM(pu_amp) FROM uts_player as p WHERE matchid = ".mysql_real_escape_string($matchid)." GROUP BY team") or die(mysql_error()); + while($r_pickups = mysql_fetch_row($q_pickups)) { $preData[] = $r_pickups; } - + $pickupitems = array('belt','keg','pads','armour','amp'); $itemsPickedUp = array(); - + if($team || $playerRedWins) { $teamOneId = 0; - $teamTwoId = 1; + $teamTwoId = 1; } else { $teamOneId = 1; - $teamTwoId = 0; + $teamTwoId = 0; } - + // Process data to convert these to percentages // Normal numbers don't plot nicely (fe. pads getting much higher pickups due to lower spawn time - for($i=0;$i<count($pickupitems);$i++) { - + for($i=0;$i<count($pickupitems);$i++) { if($preData[0][$i]>0) { $percValue = round($preData[0][$i]/($preData[0][$i]+$preData[1][$i])*100,0); - + $data[$teamOneId][] = $percValue; $data[$teamTwoId][] = 100-$percValue; - $itemsPickedUp[] = $pickupitems[$i]; - + $itemsPickedUp[] = $pickupitems[$i]; + } else if($preData[1][$i]>0) { $data[$teamOneId][] = 0; $data[$teamTwoId][] = 100; - $itemsPickedUp[] = $pickupitems[$i]; + $itemsPickedUp[] = $pickupitems[$i]; } - } - + if(count($itemsPickedUp)>2) { if($team) $labels = generateTeamLabels(); else $labels = generateLabelsFraggers($topFraggers); - + $charttype = $team?RENDERER_CHART_ITEMS_TEAMPICKUPS:RENDERER_CHART_ITEMS_PLAYERPICKUPS; - + // Save team score over team for teams - mysql_query("INSERT INTO uts_chartdata (mid,chartid,data,labels,categories) VALUES (".$matchid.", ".$charttype.", - '".mysql_real_escape_string(gzencode(serialize($data)))."', - '".mysql_real_escape_string(gzencode(serialize($labels)))."', + mysql_query("INSERT INTO uts_chartdata (mid,chartid,data,labels,categories) VALUES (".$matchid.", ".$charttype.", + '".mysql_real_escape_string(gzencode(serialize($data)))."', + '".mysql_real_escape_string(gzencode(serialize($labels)))."', '".mysql_real_escape_string(gzencode(serialize($itemsPickedUp)))."')") or die(mysql_error()); } } -/** +/* Generate labels for the fraggers */ function generateLabelsFraggers($topFraggers) { global $playernames; - + $labels = array(); - - foreach($topFraggers as $fragger) { + + foreach($topFraggers as $fragger) { $labels[] = substr($playernames[$fragger],0,18); } - + return $labels; } @@ -139,30 +133,30 @@ function generateLabelsFraggers($topFraggers) { Helper function to sort array on key, based on solution from the interwebs */ function array_sort($array, $on) { - $new_array = array(); - $sortable_array = array(); - - if (count($array) > 0) { - foreach ($array as $k => $v) { - if (is_array($v)) { - foreach ($v as $k2 => $v2) { - if ($k2 == $on) { - $sortable_array[$k] = $v2; - } - } - } else { - $sortable_array[$k] = $v; - } + $new_array = array(); + $sortable_array = array(); + + if (count($array) > 0) { + foreach ($array as $k => $v) { + if (is_array($v)) { + foreach ($v as $k2 => $v2) { + if ($k2 == $on) { + $sortable_array[$k] = $v2; + } } + } else { + $sortable_array[$k] = $v; + } + } - asort($sortable_array); + asort($sortable_array); - foreach ($sortable_array as $k => $v) { - $new_array[$k] = $array[$k]; - } + foreach ($sortable_array as $k => $v) { + $new_array[$k] = $array[$k]; } + } - return $new_array; + return $new_array; } ?> |