Remove old jpgraph implementation

79 files changed, 0 insertions, 40516 deletions

diff --git a/html/import/import_domscreens.php b/html/import/import_domscreens.php
deleted file mode 100644
index de8a379..0000000
--- a/html/import/import_domscreens.php
+++ /dev/null
@@ -1,26 +0,0 @@
-
-<?php	
-	include_once('includes/domstats.php');
-
-	$safe_uid = mysql_real_escape_string($uid);
-
-	// Get relevant info
-	$playerinfo = getPlayerTeam($uid);
-	$playernames = $playerinfo[0];
-	$playerteams = $playerinfo[1];
-
-	$gameinfo = getGameStartEndRatio($uid);
-	$time_gamestart = $gameinfo[0];
-	$time_gameend = $gameinfo[1];
-	$time_ratio_correction = $gameinfo[2];
-	
-	$tableTempIdom = generateTempTable($safe_uid);
-	$ampTimes = generateAmpTimes($safe_uid);
-	renderDataTotal($safe_uid,$tableTempIdom);
-	renderDataCPs($safe_uid,$tableTempIdom);
-	renderDataPickups($safe_uid);
-	renderAmpBars($safe_uid,$tableTempIdom);
-	
-	// drop table
-	mysql_query("DROP TABLE $tableTempIdom") or die(mysql_error());
-?>
\ No newline at end of file
diff --git a/html/includes/domstats.php b/html/includes/domstats.php
deleted file mode 100644
index dbdd3f7..0000000
--- a/html/includes/domstats.php
+++ /dev/null
@@ -1,719 +0,0 @@
-<?php
-require_once 'jpgraph/jpgraph.php';
-require_once 'jpgraph/jpgraph_scatter.php'; 
-require_once 'jpgraph/jpgraph_mgraph.php'; 
-require_once 'jpgraph/jpgraph_bar.php';
-require_once 'jpgraph/jpgraph_line.php';
-require_once 'jpgraph/jpgraph_radar.php';
-
-/*
-Retrieve player names & player teams
-Pretty much utstats code re-used
-@return $playernames, $playerteams (arrays based on pid)
-*/
-function getPlayerTeam($uid) {
-	
-	$playernames = array();
-	$playerteams = array();
-	
-	// Get List of Player IDs and Process What They Have Done
-	$sql_player = "SELECT DISTINCT col4 FROM uts_temp_$uid WHERE col1 = 'player' AND col2 = 'rename' AND col4 <> ''";
-	$q_player = mysql_query($sql_player) or die(mysql_error());
-	
-	while ($r_player = mysql_fetch_array($q_player)) {
-		$playerid = $r_player[col4];
-
-		// Get players last name used
-		$r_player2 = small_query("SELECT col3 FROM uts_temp_$uid WHERE col1 = 'player' AND col2 = 'rename' AND col4 = $playerid ORDER BY id DESC LIMIT 0,1");
-		$playername = addslashes($r_player2[col3]);
-
-		// Get players last team
-		$r_player3 = small_query("SELECT col4 FROM uts_temp_$uid WHERE col1 = 'player' AND col2 = 'TeamChange' AND col3 = $playerid AND col4 != 255 ORDER BY id DESC LIMIT 0,1");
-		$playerteam = $r_player3[col4];
-
-		$playernames[$playerid] = $playername;
-		$playerteams[$playerid] = $playerteam;		
-	}
-	
-	return array($playernames,$playerteams);
-
-}
-
-/*
-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;
-			
-	return array($time_gamestart, $time_gameend, $time_ratio_correction);
-}
-
-/*
-Helper function to create the temporary table used for dom stats
-*/
-function createEmptyTempTable($table_name) {
-		
-	$sqlCreateTable = "
-		CREATE TEMPORARY TABLE `$table_name` (
-	 `id` int(11) NOT NULL AUTO_INCREMENT,
-	 `cp` varchar(254) NOT NULL,
-	 `teamid` int(11) NOT NULL,
-	 `playerid` int(11) NOT NULL,
-	 `playername` varchar(254) NOT NULL,
-	 `start` float NOT NULL,
-	 `end` float NOT NULL,
-	 `time` float NOT NULL,
-	 `scoret0` float NOT NULL,
-	 `scoret1` float NOT NULL,
-	 `realTimeEnd` float NOT NULL,
-	 PRIMARY KEY (`id`) 
-	 ) ENGINE=MyISAM 
-	";
-	mysql_query($sqlCreateTable) or die(mysql_error());
-}
-	
-/*
-Create & populate the dom stats table
-@return name of temporary table
-*/
-function generateTempTable($uid) {
-	global $playernames;
-	global $playerteams;
-	global $time_gamestart;
-	global $time_gameend;
-	global $time_ratio_correction;
-
-	$tempTableName = "uts_tempidom_".$uid;
-	
-	createEmptyTempTable($tempTableName);
-			
-	// iterate over cp's. also capture game-end event as a quick hack to also do final iteration over final cp
-	$q_logdom = mysql_query("SELECT * FROM uts_temp_$uid WHERE col1='controlpoint_capture' OR col1='game_end' ORDER BY col1, col2, id ASC")or die(mysql_error());
-		
-	$prev_time = 0;		
-	
-	// dynamicly create insert query to populate the table in 1 go, instead of multiple database calls
-	$insertQuery = "INSERT INTO $tempTableName (cp, teamid, playerid, playername, start, end, time,scoret0,scoret1,realTimeEnd) VALUES";
-	
-	// basically loop over all capture events per CP. Each time calculate how long the previous owner had the point and translate this to dom points
-	while($r_logdom = mysql_fetch_array($q_logdom)) {
-		$points[0] = 0;
-		$points[1] = 0;
-		$ticks[0] = 0;
-		$ticks[1] = 0;
-			
-		$start_time = $prev_time;
-		
-		$r_cp = $r_logdom['col2'];	
-		$r_time = $r_logdom['col0'];
-		
-		// skip first capture event - no dom points given at start of map since no-one has cp		
-		if($prev_time > 0) {
-		
-			// if switching to other cp
-			if($prev_cp != $r_cp) {	
-				$end_time = $time_gameend; // take game end time to calculate time cp was taken, since it's the last time it's taken + extra tick for end time
-				
-			} else {			
-				$end_time = $r_time;		
-			}	
-
-			$time_diff = ($end_time - $start_time);
-			
-			// point has to be yours for at least a second before it starts to add points
-			if($time_diff >= 1) {
-			
-				// after this second, it will start to add points during each time the timer runs (= each second)
-				// thus, first run of timer is ceil of start time
-				// also, floor of end time since having the point after the timer ran, but not until the next tick = no points
-				// timing in log does not account for gamespeed, typically 1.1 ratio, which is corrected in these times
-				// test was done to save the actual tick times based upon the dom_points stats event (happens each 5 ticks), but this doesn't result in significant better results to be worth the effort
-							
-				// save amount of timer 'ticks' that generate a score of 0.2
-				$ticks[$r_teamid] = (floor($end_time/$time_ratio_correction)-ceil($start_time/$time_ratio_correction));
-				
-			}
-					
-			// if no tick happened, insert the event with 0  points		
-			if($ticks[$r_teamid]==0) {
-				
-				$realTimeEnd=($start_time-$time_gamestart)/$time_ratio_correction/60;	
-				$insertQuery .= " ('$prev_cp', '$r_teamid', '$r_pid', '$r_pname', '$start_time', '$end_time', '$time_diff', '".$points[0]."', '".$points[1]."', '$realTimeEnd'),";
-			
-			// if ticks happened, insert each seperate tick as an event
-			} else {
-					
-				for($i=1;($ticks[$r_teamid]+1-$i) > 0;$i++) {
-				
-					$realTimeEnd=($start_time+$time_diff/$ticks[$r_teamid]*$i-$time_gamestart)/$time_ratio_correction/60;		
-					$points[$r_teamid] = 0.2;
-					
-					$insertQuery .= " ('$prev_cp', '$r_teamid', '$r_pid', '$r_pname', '$start_time', '$end_time', '$time_diff', '".$points[0]."', '".$points[1]."', '$realTimeEnd'),";
-					
-				}
-			}
-			
-		} 	
-		
-		// save data for current capture event
-		$prev_time = $r_time;
-		$prev_cp = $r_cp;
-		
-		$r_event = $r_logdom['col1'];
-		$r_pid = $r_logdom['col3'];
-		$r_teamid = mysql_real_escape_string($playerteams[$r_pid]);
-		$r_pname = mysql_real_escape_string($playernames[$r_pid]);
-		
-	} 
-	
-	// populate table
-	$insertQuery = rtrim($insertQuery,",");
-	mysql_query($insertQuery) or die(mysql_error());
-	
-	return $tempTableName;
-	
-}
-
-/*
-Generate times when amp was taken
-@return $amps[$team][$start_time,$end_time, $pid]
-*/
-function generateAmpTimes($uid) {
-	global $playernames;
-	global $playerteams;
-	global $time_gamestart;
-	global $time_gameend;
-	global $time_ratio_correction;
-	
-	$amps = array();
-	$prev_time = array();
-	
-	// Get activate & deactivate times & players
-	$q_amps = mysql_query("SELECT col0,col1,col3 FROM uts_temp_$uid WHERE col2='Damage Amplifier' AND (col1='item_activate' OR col1='item_deactivate') ORDER BY id ASC");
-	while($r_amps = mysql_fetch_array($q_amps)) {
-		$time = ($r_amps[0]-$time_gamestart)/$time_ratio_correction/60;
-		$event = $r_amps[1];
-		$pid = $r_amps[2];
-		
-		// If amp is deactivated, calculate the time it was used
-		if($event == "item_deactivate") {			
-			$amps[$playerteams[$pid]][] = array($prev_time[$pid], $time,$pid);
-			$prev_time[$pid] = 0;
-			
-		// If amp is activated & none yet acquired, save the time of the start of this amp run
-		} else if($prev_time[$pid] == 0) {
-			$prev_time[$pid] = $time;
-		}
-	}
-	
-	return $amps;
-}
-
-/*
-Function to render the chart with amp runs
-*/
-function renderAmpBars($uid,$tempTableName) {
-	global $playernames;
-	global $ampTimes;
-	global $matchid;
-	global $domimage_color;
-	global $domimages_folder;
-	global $domimage_width;
-	global $domimage_heigth;
-	
-	// Iterate over amp runs
-	for($i=0;$i<2;$i++) {
-		foreach ($ampTimes[$i] as $ampTaken) {
-			$ampStart = $ampTaken[0];
-			$ampEnd = $ampTaken[1];
-			$pid = $ampTaken[2];
-			
-			// Only save amp runs longer than 20seconds
-			if($ampEnd > ($ampStart+.33)) {
-			
-				// Get scores during amprun
-				$q_scoresDuringAmp = mysql_query("SELECT SUM(scoret0),SUM(scoret1) FROM $tempTableName WHERE realTimeEnd > $ampStart AND realTimeEnd < $ampEnd");
-				$r_scoresDuringAmps = mysql_fetch_array($q_scoresDuringAmp);
-												
-				$netPoints = $r_scoresDuringAmps[$i] - $r_scoresDuringAmps[1-$i];
-				
-				// Process time for readable label
-				$totalTime = $ampEnd-$ampStart;
-				$totalTimeMinutes = floor($totalTime);
-				$totalTimeSeconds = round(($totalTime-$totalTimeMinutes)*60,0);
-				
-				$timeLabel = "";
-				if($totalTimeMinutes>0) { $timeLabel .= $totalTimeMinutes."m"; }
-				if($totalTimeSeconds>0) { $timeLabel .= $totalTimeSeconds."s"; }
-				
-				$playerName = $playernames[$pid];
-								
-				$ampRun['start'] = $ampStart;
-				$ampRun['label'] = substr($playerName,0,15)." (".$timeLabel.")";
-				$ampRun['points'] = $netPoints;
-				$ampRun['team'] = $i;
-				
-				$data[] = $ampRun;
-			}
-		}
-	}
-	
-	if(count($data)>0) {
-		
-		// Sort ampruns not on teams, but on start time, to make sure they are plotted chronocologicstic
-		$data = array_sort($data,'start');
-		
-		$maxValue=0;
-		// Process the ampruns to map it to 2 differnt bar plots per team
-		foreach ($data as $ampRun) {
-			$labels[] = $ampRun['label'];
-			$values[$ampRun['team']][] = $ampRun['points'];
-			
-			$posValue = $ampRun['points']>0? $ampRun['points'] : $ampRun['points']*-1;
-			
-			if($posValue>$maxValue)
-				$maxValue = $posValue;
-			
-			// Add 0 value for other team to ensure only 1 bar is plotted each time (either team 0 or team 1)
-			$values[1-$ampRun['team']][] = 0;
-		}
-		
-		$tickInterval = $maxValue>15?10:5;
-		$maxValue = $tickInterval*ceil($maxValue/$tickInterval);
-				
-		// Create the graph
-		// Some commands to enable horizontal bars & moved axis for proper formatting
-		$graph = new Graph($domimage_width+8,$domimage_heigth+8);
-		$graph->SetScale('textlin',$maxValue*-1,$maxValue);	  
-		$graph->SetTickDensity(TICKD_SPARSE);
-		$graph->Set90AndMargin('20','15','30','30');
-		$graph->SetMarginColor($domimage_color['background']); 
-		$graph->SetColor($domimage_color['background']); 
-		$graph->SetFrame(true,$domimage_color['background'],0);
-		$graph->ygrid->SetFill(true,$domimage_color['band'][0],$domimage_color['band'][1]); 
-		$graph->ygrid->SetColor($domimage_color['background']); 
-		
-		$graph->title->Set('Net Score Amp Runs');
-		$graph->title->SetFont(FF_VERDANA,FS_BOLD);
-		$graph->title->SetColor($domimage_color['heading']);
-		
-		$graph->xaxis->SetPos('min');
-		$graph->xaxis->SetTickLabels($labels);
-		$graph->xaxis->SetFont(FF_VERDANA,FS_NORMAL,7);
-		$graph->xaxis->SetColor($domimage_color['font']);
-		$graph->xaxis->SetLabelAlign('left','center');
-		$graph->xaxis->SetColor($domimage_color['background'],$domimage_color['font']);
-		
-		$graph->yaxis->SetPos('max');
-		$graph->yaxis->SetLabelAlign('center','top');
-		$graph->yaxis->SetLabelSide(SIDE_RIGHT);
-		$graph->yaxis->SetTickSide(SIDE_LEFT);
-		$graph->yaxis->scale->ticks->set($tickInterval);
-		$graph->yaxis->SetColor($domimage_color['background'],$domimage_color['font']);
-				
-		if(count($values[0])>0) { 
-			$b1plot = new BarPlot($values[0]); 
-			$graph->Add($b1plot);
-			$b1plot->SetFillGradient($domimage_color['team'][0][0],$domimage_color['team'][0][1],GRAD_HOR);
-			$b1plot->SetColor($domimage_color['team'][0][0]);
-			
-		} if(count($values[1])>0) { 
-			$b2plot = new BarPlot($values[1]); 
-			$graph->Add($b2plot);		
-			$b2plot->SetFillGradient($domimage_color['team'][1][0],$domimage_color['team'][1][1],GRAD_HOR);
-			$b2plot->SetColor($domimage_color['team'][1][0]);	
-		}		
-		
-		$graph->Stroke($domimages_folder."/".$matchid."-ampruns.png");		
-	}
-}
-
-/*
-Generate the chart with pickups
-*/
-function renderDataPickups($uid) {
-	global $matchid;
-	global $domimage_color;
-	global $domimages_folder;
-	global $domimage_width;
-	global $domimage_heigth;
-
-	$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 = $matchid GROUP BY team") or die(mysql_error());
-	
-	while($r_pickups = mysql_fetch_row($q_pickups)) {
-		$preData[] = $r_pickups;
-	}
-	
-	$anyPickupDone = false;
-	
-	// 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<5;$i++) {
-		if($preData[0][$i]>0) {
-			$data[0][$i] = round($preData[0][$i]/($preData[0][$i]+$preData[1][$i])*100,0);
-			$data[1][$i] = 100-$data[0][$i];
-			$anyPickupDone = true;			
-		} else if($preData[1][$i]>0) {
-			$data[0][$i] = 0;
-			$data[1][$i] = 100;
-			$anyPickupDone = true;
-		} else {
-			$data[0][$i] = 0;
-			$data[1][$i] = 0;		
-		}
-	}
-	
-	if($anyPickupDone) {
-		// Plot radargraph
-		$titles = array('belt','keg','pads','armour','amp');
-		$graph = new RadarGraph ($domimage_width+8,$domimage_heigth+8);
-		$graph->SetScale('lin',0,100);
-		$graph->yscale->ticks->Set(25,5);
-		$graph->setMargin(30,30,30,30);
-		$graph->SetMarginColor($domimage_color['background']); 
-		$graph->SetColor($domimage_color['background']); 
-		$graph->SetFrame(true,$domimage_color['background'],0);
-		$graph->title->Set('Pickups %');
-		$graph->title->SetFont(FF_VERDANA,FS_BOLD);
-		$graph->title->SetColor($domimage_color['heading']);
-		$graph->HideTickMarks();
-		$graph->axis->HideLabels();
-		
-		$graph->SetTitles($titles);
-		$graph->axis->title->SetFont(FF_VERDANA,FS_NORMAL,8);
-		$graph->axis->title->SetColor($domimage_color['font']);
-		$graph->grid->Show(true,true);
-		$graph->grid->SetLineStyle('dashed');	 	 
-		
-		// Seperate plot within radar per team
-		$plot1 = new RadarPlot($data[0]);	 
-		$plot2 = new RadarPlot($data[1]);	 
-		$graph->Add($plot1);
-		$graph->Add($plot2);
-		
-		$plot1->SetFillColor($domimage_color['team'][0][0].'@0.5');
-		$plot1->SetColor($domimage_color['team'][0][0]);
-		$plot1->SetLineWeight(2);
-		$plot2->SetFillColor($domimage_color['team'][1][0].'@0.5');
-		$plot2->SetColor($domimage_color['team'][1][0]);
-		$plot2->SetLineWeight(2);
-		
-		$graph->Stroke($domimages_folder."/".$matchid."-pickups.png");
-	}
-}
-
-/*
-Render dom points over time & net rate of change per minute over all cp's
-*/
-function renderDataTotal($uid,$tempTableName) {
-	$query = "SELECT t.realTimeEnd,@t0sum := @t0sum + t.scoret0 AS cumulScoret0,@t1sum := @t1sum + t.scoret1 AS cumulScoret1 FROM $tempTableName t JOIN (SELECT @t0sum := 0) r JOIN (SELECT @t1sum := 0) s ORDER BY realTimeEnd ASC";
-	$appex = "total";
-	
-	renderData($uid,$tempTableName,$query,$appex,"Total score","");
-}
-
-/*
-Render dom points over time & net rate of change per minute per cp
-*/
-function renderDataCPs($uid,$tempTableName) {
-	$q_cps = mysql_query("SELECT DISTINCT(cp) FROM $tempTableName");
-	
-	$i=0;
-	while