<?php
    include("graphs/src/jpgraph.php");
    include("graphs/src/jpgraph_bar.php");
    include_once('config.php');

    $aid  = $_REQUEST["aid"];
    $test = $_REQUEST["test"];

    function manuf_partnum_label($partnumid)
    {
        $db = new db_mysql();
        $db->select_db('mobot');
        $sql = "SELECT mm.name AS 'Mobo', mm1.name AS 'Manufacturer'
                FROM mobos AS mm
                LEFT JOIN manuf AS mm1 ON mm.manuf_id = mm1.manuf_id
                WHERE mobos_id = $partnumid";
        $db->set_sql($sql);
        $db->query();
        if ($row = $db->fetch_array())	{
            $text  = $row["Manufacturer"] . ": ";
            $text .= ' ';
            $text .= $row["Mobo"];
        }
        $db->close();
        return $text;
    }

    $field = $test;
	$datay = array();
	$lbl = array();
	
	if($aid==15610001)
	{
		$cpu="amd939pcix";
		$partnumid=9232;
	}
	else
	{
		$db1 = new db_mysql();
		$sql_1 = "SELECT partnum_id, cpu FROM mb_ranking_main WHERE a_id = '$aid'";
	
		$db1->set_sql($sql_1);
		$db1->query();
	
		if ($row = $db1->fetch_array()) {
			$cpu       = $row["cpu"];
			$partnumid = $row["partnum_id"];
		}
		$db1->close();
	}

    $lcpu = strtolower($cpu);
    $cpu_table = 'mb_ranking_' . $lcpu;

    // Get the score for the reviewed board
    $db2 = new db_mysql();
    $sql_2 = "SELECT $test, partnum_id FROM $cpu_table WHERE a_id = '$aid'";

    $field = $test;

    $db2->set_sql($sql_2);
    $db2->query();
    $datay = array();
    $lbl = array();

	if ($row = $db2->fetch_array()) {
		array_push($datay, $row[$field]);
        $cpu             = $row["cpu"];
        $partnumid       = $row["partnum_id"];
        $subtitle        = manuf_partnum_label($partnumid);
		//$wrappedSubtitle = wordwrap($subtitle, 20, "\n");
		array_push($lbl, $subtitle);
	}
    $db2->close();
    
    // get 3 highest scores from other boards.
    $db3 = new db_mysql();
    $sql_3 = "SELECT $test, partnum_id FROM $cpu_table WHERE a_id != '$aid' and $test > 0 ORDER BY $test DESC LIMIT 5";

    $field = $test;

    $db3->set_sql($sql_3);
    $db3->query();
	if ($row = $db3->fetch_array())	{
		do {
			array_push($datay, $row[$field]);
			$partnumid    = $row["partnum_id"];
            $label        = manuf_partnum_label($partnumid);
            //$wrappedlabel = wordwrap($subtitle, 15, "\n");
            array_push($lbl, $label);
		} while ($row = $db3->fetch_array());
	}
    $db3->close();
    
    switch ($test) {
    	case '3dmark2001':
    		$title = '3DMark 2001';
    		$ytitle = '3DMarks - Higher score is better.';
    		$format = '%.0f  ';
       		break;
    	case '3dmark2001se':
		    $title = '3DMark 2001SE';
        	$ytitle = '3DMarks - Higher score is better.';
        	$format = '%.0f  ';
        	break;
        case '3dmark03':
		    $title = '3DMark 2003';
        	$ytitle = '3DMarks - Higher score is better.';
        	$format = '%.0f  ';
        	break;
        case '3dmark05':
    		$title = '3DMark 2005';
        	$ytitle = '3DMarks - Higher score is better.';
        	$format = '%.0f  ';
        	break;  
		case '3dmark06':
    		$title = '3DMark 2006';
        	$ytitle = '3DMarks - Higher score is better.';
        	$format = '%.0f  ';
        	break;    	
    	case 'sysmark2001':
		    $title = 'SYSMark 2001';
        	$ytitle = 'SYSMark - Higher score is better.';
        	$format = '%.0f  ';
   		    break;
    	case 'sysmark2002':
    		$title = 'SYSMark 2002';
        	$ytitle = 'SYSMark - Higher score is better.';
        	$format = '%.0f  ';
   		    break;
       	case 'sysmark2004':
    		$title = 'SYSMark 2004';
        	$ytitle = 'SYSMark - Higher score is better.';
        	$format = '%.0f  ';
   		    break;
       	case 'pcmark2004':
    		$title = 'PCMark 2004';
        	$ytitle = 'PCMark - Higher score is better.';
        	$format = '%.0f  ';
   		    break;
		case 'pcmark2005':
    		$title = 'PCMark 2005';
        	$ytitle = 'PCMark - Higher score is better.';
        	$format = '%.0f  ';
   		    break;
   		case 'pcmark2004mem':
    		$title = 'PCMark 2004 Memory';
        	$ytitle = 'PCMark - Higher score is better.';
        	$format = '%.0f  ';
   		    break;
   		case 'sandra2005int':
    		$title = 'Sisoft Sandra Integer';
        	$ytitle = 'PCMark - Higher score is better.';
        	$format = '%.0f  ';
   		    break;
   		case 'sandra2005float':
    		$title = 'Sisoft Sandra Float';
        	$ytitle = 'PCMark - Higher score is better.';
        	$format = '%.0f  ';
   		    break;            
       	case 'quake3':
    		$title = 'Quake 3';
        	$ytitle = 'FPS - Higher score is better.';
        	$format = '%.1f  ';
   		    break;
       	case 'doom3':
    		$title = 'Doom 3';
        	$ytitle = 'FPS - Higher score is better.';
        	$format = '%.1f  ';
   		    break;
       	case 'hl2':
    		$title = 'Half-Life 2';
        	$ytitle = 'FPS - Higher score is better.';
        	$format = '%.1f  ';
       		break;
       	case 'aquamark':
    		$title = 'Aquamark';
        	$ytitle = 'FPS - Higher score is better.';
        	$format = '%.0f  ';
       		break;	
		case 'aquamark3':
    		$title = 'Aquamark 3';
        	$ytitle = 'FPS - Higher score is better.';
        	$format = '%.0f  ';
       		break;	
       	case 'sp6_AWadvs04':
    		$title = 'SPECviewperf 6 AWadvs04';
        	$ytitle = 'FPS - Higher score is better.';
        	$format = '%.3f  ';
       		break;
       	case 'sp6_drv08':
    		$title = 'SPECviewperf 6 DRV-07';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.3f  ';
            break;
       	case 'sp6_dx07':
    		$title = 'SPECviewperf 6 DX-06';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.3f  ';
       		break;
       	case 'sp6_light05':
    		$title = 'SPECviewperf 6 Light-04';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.3f  ';
       		break;
       	case 'sp6_proe01':
    		$title = 'SPECviewperf 6 MedMCAD-01';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.3f  ';
       		break;
       	case 'sp6_ugs01':
    		$title = 'SPECviewperf 6 ProCDRS-03';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.3f  ';
       		break;
       	case 'sp7_3dsmax01':
    		$title = 'SPECviewperf 7 3dsmax01';
           	$ytitle = 'FPS - Higher score is better.';
            $format = '%.3f  ';
       		break;
       	case 'sp7_drv08':
    		$title = 'SPECviewperf 7 drv-08';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.3f  ';
       		break;
       	case 'sp7_dx07':
    		$title = 'SPECviewperf 7 dx-07';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.3f  ';
       		break;
       	case 'sp7_light05':
    	    $title = 'SPECviewperf 7 light-05';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.3f  ';
       		break;
       	case 'sp7_proe01':
    		$title = 'SPECviewperf 7 proe-01';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.3f  ';
       		break;
       	case 'sp7_ugs01':
    		$title = 'SPECviewperf 7 ugs-01';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.3f  ';
       		break;
       	case 'sp7_3dsmax02':
    		$title = 'SPECviewperf 7 3dsmax02';
           	$ytitle = 'FPS - Higher score is better.';
            $format = '%.3f  ';
       		break;
       	case 'sp7_drv09':
    		$title = 'SPECviewperf 7 drv-09';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.3f  ';
       		break;
       	case 'sp7_dx08':
    		$title = 'SPECviewperf 7 dx-08';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.3f  ';
       		break;
       	case 'sp7_light06':
    		$title = 'SPECviewperf 7 light-06';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.3f  ';
       		break;
       	case 'sp7_proe02':
    		$title = 'SPECviewperf 7 proe-02';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.3f  ';
       		break;
       	case 'sp7_ugs03':
    		$title = 'SPECviewperf 7 ugs-03';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.3f  ';
       		break;
       	case '3dsmax03':
    		$title = 'SPECviewperf  3dsmax-03';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.3f  ';
       	    break;
       	case 'catia01':
    		$title = 'SPECviewperf  catia-01';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.3f  ';
       	    break;
       	case 'ensight01':
    		$title = 'SPECviewperf  ensight-01';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.3f  ';
       	    break;
       	case 'light07':
    		$title = 'SPECviewperf  light-07';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.3f  ';
       	    break;
       	case 'maya01':
    		$title = 'SPECviewperf  maya-01';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.3f  ';
       	    break;
       	case 'proe03':
    		$title = 'SPECviewperf  proe-03';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.3f  ';
       	    break;    
       	case 'sw01':
    		$title = 'SPECviewperf  sw-01';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.3f  ';
       	    break;
       	case 'ugs04':
    		$title = 'SPECviewperf  ugs-04';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.3f  ';
       	    break;                        
       	case 'ut2003fb':
    		$title = 'Unreal 2003 - Flyby';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.1f  ';
       		break;
       	case 'ut2003bm':
    		$title = 'Unreal 2003 - Bot Match';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.1f  ';
       		break;
       	case 'divx':
    		$title = 'DIVX';
            $ytitle = '';
            $ytitle = 'Lower score is better.';
            $format = '%.1f  ';
       		break;
		case 'fearmobo':
    		$title = 'F.E.A.R. Maximum settings 1024x768 32-bit';
            $ytitle = '(Higher score is better.)';
            $format = '%.1f  ';
       		break;
		case 'superpi':
    		$title = 'SuperPi (1 Million Digits)';
            $ytitle = '(Higher score is better.)';
            $format = '%.3f  ';
       		break;
		case 'fear':
    		$title = 'F.E.A.R. Maximum settings 1024x768 32-bit';
            $ytitle = '(Higher score is better.)';
            $format = '%.0f  ';
       		break;
		case 'pcmark2005':
    		$title = 'PCmark 2005';
            $ytitle = '(Higher score is better.)';
            $format = '%.0f  ';
       		break;
		case 'sysmark07':
    		$title = 'SYSmark2007';
            $ytitle = '(Higher score is better.)';
            $format = '%.0f  ';
       		break;
		case 'sys07':
    		$title = 'SYSmark 2007';
            $ytitle = '(Higher score is better.)';
            $format = '%.0f  ';
       		break;
		case 'cpu':
    		$title = 'CPU Bench 2003';
            $ytitle = 'CPU Marks (Higher score is better.)';
            $format = '%.0f  ';
       		break;
		case 'pcmark05':
    		$title = 'PCmark 2005';
            $ytitle = '(Higher score is better.)';
            $format = '%.0f  ';
       		break;
		case 'crystal':
    		$title = 'CrystalMark';
            $ytitle = '(Higher score is better.)';
            $format = '%.0f  ';
       		break;
		case 'sandry':
    		$title = 'Sandra Drystone';
            $ytitle = '(Higher score is better.)';
            $format = '%.0f  ';
       		break;
		case 'sanwet':
    		$title = 'Sandra Wetstone';
            $ytitle = '(Higher score is better.)';
            $format = '%.0f  ';
       		break;
		case 'pifast':
    		$title = 'PiFast';
            $ytitle = '';
            $format = '%.2f  ';
       		break;			
       	case 'spc3d':
    		$title = 'SPECviewperf  3DSMax-04';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.2f  ';
       	    break;
       	case 'spccat':
    		$title = 'SPECviewperf  Catia-02';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.2f  ';
       	    break;
       	case 'spcens':
    		$title = 'SPECviewperf  Ensight-03';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.2f  ';
       	    break;
       	case 'spcmay':
    		$title = 'SPECviewperf  Maya-02';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.2f  ';
       	    break;
       	case 'spcpro':
    		$title = 'SPECviewperf  Proe-04';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.2f  ';
       	    break;    
       	case 'spcsw':
    		$title = 'SPECviewperf  SW-01';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.2f  ';
       	    break;
       	case 'spctcv':
    		$title = 'SPECviewperf  Tcvis-04';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.2f  ';
       	    break; 
		case 'spcugn':
    		$title = 'SPECviewperf  Ugnx-01';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.2f  ';
       	    break;  	
	case 'vantage4':
    		$title = 'PCmark Vantage';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.0f  ';
       	    break; 		
	case 'saxi1':
    		$title = 'Sisoft Sandra XI - MIPS';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.0f  ';
       	    break; 
	case 'saxi2':
    		$title = 'Sisoft Sandra XI - MFLOPS';
            $ytitle = 'FPS - Higher score is better.';
            $format = '%.0f  ';
       	    break; 
	  case '3dmark57':
	$title = '3DMark 2005';
	$ytitle = '3DMarks - Higher score is better.';
	$format = '%.0f  ';
	break;  
	case '3dmark67':
	$title = '3DMark 2006';
	$ytitle = '3DMarks - Higher score is better.';
	$format = '%.0f  ';
	break;    
    }


//Begin Conversion ::EO::
$errors=array();
if(isset($_GET['sel'])){$insel = $_GET['sel'];}else{$insel = 1;}
$intitle = $title;
if(isset($_GET['legA'])){$inlegA = $_GET['legA'];}else{$inlegA = "";}
if(isset($_GET['legB'])){$inlegB = $_GET['legB'];}else{$inlegB = "";}
if(isset($_GET['sub'])){$insub = $_GET['sub'];}else{$insub = $ytitle;}
if(isset($_GET['ymax'])){$inymax = $_GET['ymax'];}else{$inymax = 0;}
if(isset($_GET['rot'])){$rot = $_GET['rot'];}else{$rot = NULL;}
if(isset($_GET['dec'])){$dec = $_GET['dec'];}else{$dec = $format;}

$ymin = min($datay) * 0;

array_multisort($datay, SORT_DESC, $lbl);

if($count>8)
{
	$height=370;
}
$namear=$lbl;
$valA=$datay;
$valB=array();


/*
$namear=array();
$valA=array();
$valB=array();
foreach($_GET as $key => $val)
{
	$subst = substr($key, 0, 4);
	if($subst !="name" && !is_numeric($val))
	{

		$val=0;
	}
	switch($subst)
	{
		case "name":
			array_push($namear, $val);
		break;
		case "scrA":
			array_push($valA, $val);
		break;
		case "scrB":
			array_push($valB, $val);
		break;
	}
}
if(empty($namear) && empty($valA))
{
	array_push($errors, 'Missing: All graphing data!');
}
else
{
	if(empty($namear))
	{
		array_push($errors, 'Missing: Data names');
	}
	if(empty($valA))
	{
		array_push($errors, 'Missing: Data values');
	}
}
if(count($namear) != count($valA))
{
	array_push($errors, 'Names + Values do not match.');
}

if($sel==2)
{
	if(empty($valB))
	{
		array_push($errors, 'Missing: 2nd Values');
	}
	if(count($namear) != count($valB))
	{
		array_push($errors, 'Names + 2nd Values do not match.');
	}
}
*/


if(count($errors)<1)
{
	$width=500;
	$height=475;
	// Set the basic parameters of the graph
	$graph = new Graph($width,$height,'auto');
	$graph->SetScale("textlin");
	//$icon = new IconPlot('logo.png',0.5,0.5,1,50); 
	//$graph->SetBackgroundImage("./images/graph_bg.png",BGIMG_FILLFRAME);
	$graph->SetColor('#555555'); 
	$graph->SetMarginColor('#555555'); 
	$graph->SetBackgroundGradient('#3F4A61','#797979',GRAD_HOR,BGRAD_PLOT);
	$graph->SetFrame(true,'#000000',1); 
	$top = 55;
	$numlen=$valA[0];
	settype($numlen,"string");
	$finlen=strlen($numlen);
	if($finlen>=4)
	{
		$bottom = 80;
		$rot=true;
	}
	else
	{
		$bottom = 65;
	}
	$left = 150;
	$right = 30;
	$titlemargin = $bottom-10;
	$graph->Set90AndMargin($left,$right,$top,$bottom);
	//$graph->SetTickDensity(TICKD_VERYSPARSE);
	// Nice shadow
	//$graph->SetShadow("#111111");
	
	// Setup labels
	foreach($namear as $key => $lbdat)
	{
		$namear[$key]=wordwrap($lbdat,15,"\n");
	}
	$graph->xaxis->SetTickLabels($namear);
	$graph->yaxis->SetPos('max');
	// Label align for X-axis
	$graph->xaxis->SetLabelAlign('right','center','right');
	$graph->yaxis->SetLabelSide(SIDE_RIGHT);
	//$graph->xaxis->SetTickSide(SIDE_TOP); 
	//$graph->yaxis->SetLabelFormat('%d');
	// Label align for Y-axis
	$graph->yaxis->SetLabelAlign('center','top');
	
	if(strlen($inlegA)>8)
		{
			$xmod = strlen($inlegA)-8;
			$xmod = $xmod *.01;
			$xmod = .82 - $xmod;
			$insub = "   ".$insub;
		}
		else
		{
			$xmod=.85;
		}
	
	// Titles
	$graph->title->Set($title);
	$graph->title->SetFont(FF_IMPACT,FS_NORMAL,18);
	$graph->title->SetMargin(8);
	$graph->yaxis->SetTitle($ytitle,'low');
	$graph->yaxis->SetTitleSide(SIDE_TOP);
	$graph->yaxis->SetTitleMargin($titlemargin);
	$graph->yaxis->title->SetFont(FF_EVROPA,FS_NORMAL,11);
	$graph->yaxis->title->SetAngle(0);
	$graph->yaxis->title->SetColor('#FFFFFF');
	$graph->yaxis->title->SetAlign('center','right');
	$graph->subtitle->SetFont(FF_EVROPA,FS_NORMAL,11);
	$graph->subtitle->SetColor('#FFFFFF');
	$graph->subtitle->Set($subtitle);
	$graph->title->SetColor('#FFFFFF');
	$graph->yaxis->SetColor('#FFFFFF');
	$graph->xaxis->SetColor('#FFFFFF');
	
	if($rot!=NULL)
	{
		$graph->yaxis->SetLabelAngle(45);
		$graph->yaxis->SetFont(FF_BANK,FS_NORMAL,10);
		$ymod=.86;
	}
	else
	{
		$graph->yaxis->SetFont(FF_BANK,FS_NORMAL,10);
		$ymod=.87;
	}
	$graph->xaxis->SetFont(FF_EVROPA,FS_NORMAL,10);
	// Create a bar pot
	/*
	if($dec!=NULL)
	{
		switch($dec)
		{
			case 2:
				$format = '%.2f  ';
			break;
			case 3:
				$format = '%.3f  ';
			break;
			default:
				$format = '%.0f  ';
			break;
		}
	}
	else
	{
		$format = '%.0f  ';
	}
	*/
	
	$bplot = new BarPlot($valA);
	$bplot->SetFillGradient("#ACC1FF",'#001757',GRAD_HOR);
	$bplot->SetColor("#FFFFFF");
	$bplot->SetWidth(.5);
	$bplot->SetShadow();
	$bplot->SetValuePos('center'); 
	$bplot->value->Show();
	$bplot->value->SetFont(FF_BANK,FS_NORMAL,10);
	$bplot->value->SetAlign('right','center');
	$bplot->value->SetColor("#FFFFFF");
	$bplot->value->SetFormat($format);
	if($inymax!=0)
	{
		$bplot->SetYMin($inymax);
	}


	if($sel==2)
	{
		$bplot->SetLegend($inlegA);
		$b2plot = new BarPlot($valB);
		$b2plot->SetFillGradient("#F15D03",'#FFA821',GRAD_HOR);
		$b2plot->SetColor("#FFFFFF");
		$b2plot->SetWidth(.5);
		$b2plot->SetShadow();
		$b2plot->SetValuePos('center'); 
		$b2plot->value->Show();
		$b2plot->value->SetFont(FF_BANK,FS_NORMAL,10);
		$b2plot->value->SetAlign('right','center');
		$b2plot->value->SetColor("#000");
		$b2plot->value->SetFormat($format);
		$b2plot->SetLegend($inlegB);
		if($inymax!=0)
		{
			$b2plot->SetYMin($inymax);
		}
		
		
		$graph->legend->Pos($xmod,$ymod);
		$graph->legend->SetShadow('#111111', 2); 
		$graph->legend->SetFont(FF_BANK,FS_NORMAL,10); 
		$graph->legend->SetColor('#FFFFFF'); 
		$graph->legend->SetFillColor('#777777'); 
		$gbplot = new GroupBarPlot(array($bplot,$b2plot));
		if($inymax!=0)
		{
			$gbplot->SetYMin($inymax);
		}
		$graph->Add($gbplot);
	}
	else
	{
		$graph->Add($bplot);
	}
	
	
	// A more real life example
	$txt = new Text("Motherboards.org");
	$txt->SetFont(FF_ARIALBLACK,FS_NORMAL,14);
	$txt->Pos(480,100,'center','bottom');
	$txt->SetColor('#FFFFFF');
	$graph->AddText($txt); 
	
	
	$graph->ygrid->SetColor('#999999'); 
	$graph->ygrid->SetLineStyle('dashed'); 
	$graph->ygrid->Show(); 
	$graph->Stroke();
}
else
{
	print_r($errors);
	$str="?ti=DOOM III 1024x768&sel=2&sub=FPS - Higher is better&legA=No AA&legB=4x AA&name1=ATI X1800XL&name2=Gigabyte 660GT SPII&name3=EVGA 7800GT SLI&name4=EVGA 7800GT&name5=XFX SLI&name6=XFX 7800GT&name7=Gigabyte 7800GT&scrA1=66&scrA2=25&scrA3=45&scrA4=56&scrA5=88&scrA6=72&scrA7=46&scrB1=55&scrB2=14&scrB3=38&scrB4=45&scrB5=72&scrB6=68&scrB7=38";	echo(urlencode($str));
}

?>