diff options
Diffstat (limited to 'html/includes/renderer-general-import.php')
| -rw-r--r-- | html/includes/renderer-general-import.php | 168 |
1 files changed, 168 insertions, 0 deletions
diff --git a/html/includes/renderer-general-import.php b/html/includes/renderer-general-import.php new file mode 100644 index 0000000..fbe62fc --- /dev/null +++ b/html/includes/renderer-general-import.php @@ -0,0 +1,168 @@ +<?php + +/* +Retrieve player names & player teams +Pretty much utstats code re-used +@return $playernames, $playerteams (arrays based on pid) +*/ +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; + } + + $r_team = small_query("SELECT COUNT(DISTINCT team) FROM uts_player WHERE matchid=$matchid"); + $teams = $r_team[0]; + + return array($playernames,$playerteams,$teams); + +} + +/* +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()); + + $time_gamestart = mysql_result($q_logdom,0); + $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 +*/ +function renderDataPickups($uid,$team=true,$playerRedWins=true,$topFraggers) { + global $matchid; + global $renderer_color; + global $renderer_folder; + global $renderer_width; + 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()); + + 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; + } else { + $teamOneId = 1; + $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++) { + + 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]; + + } else if($preData[1][$i]>0) { + $data[$teamOneId][] = 0; + $data[$teamTwoId][] = 100; + $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_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) { + $labels[] = substr($playernames[$fragger],0,18); + } + + return $labels; +} + +/* +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; + } + } + + asort($sortable_array); + + foreach ($sortable_array as $k => $v) { + $new_array[$k] = $array[$k]; + } + } + + return $new_array; +} + +?> |