<?php
	include "../config.php";
	include "pChart/pChart/pData.class";
	include "pChart/pChart/pChart.class";


	mysql_connect($HostDB,$UserDB,$PassDB) or die('Error connect to db');
	mysql_select_db($NameDB) or die(mysql_error());
	$query = 'SELECT '.
	'(SELECT COUNT(*) FROM '.$PrefixTable.'users WHERE share_size <= 10*1024) AS odin,'.
	'(SELECT COUNT(*) FROM '.$PrefixTable.'users WHERE share_size > 10*1024 AND share_size <= 30*1024) AS dva,'.
	'(SELECT COUNT(*) FROM '.$PrefixTable.'users WHERE share_size > 30*1024 AND share_size <= 50*1024) AS tri,'.
	'(SELECT COUNT(*) FROM '.$PrefixTable.'users WHERE share_size > 50*1024 AND share_size <= 70*1024) AS cheture,'.
	'(SELECT COUNT(*) FROM '.$PrefixTable.'users WHERE share_size > 70*1024 AND share_size <= 120*1024) AS pet,'.
	'(SELECT COUNT(*) FROM '.$PrefixTable.'users WHERE share_size > 120*1024 AND share_size <= 200*1024) AS shest,'.
	'(SELECT COUNT(*) FROM '.$PrefixTable.'users WHERE share_size > 200*1024 AND share_size <= 500*1024) AS sem,'.
	'(SELECT COUNT(*) FROM '.$PrefixTable.'users WHERE share_size > 500*1024 AND share_size <= 1000*1024) AS vosem,'.
	'(SELECT COUNT(*) FROM '.$PrefixTable.'users WHERE share_size > 1000*1024) AS devet';
	$res = mysql_query($query) or die(mysql_error());
	$row = mysql_fetch_assoc($res);
	$i = 0;$j = 0;
	$pod_no = array("< 10 Gb (".$row['odin'].")","10 - 30 Gb (".$row['dva'].")","30 - 50 Gb (".$row['tri'].")"
	,"50 - 70 Gb (".$row['cheture'].")","70 - 120 Gb (".$row['pet'].")","120 - 200 Gb (".$row['shest'].")"
	,"200 - 500 Gb (".$row['sem'].")","500 - 1000 Gb (".$row['vosem'].")","> 1 Tb (".$row['devet'].")");
	
	$DataSet = new pData;
	$DataSet->AddPoint($row,"Serie1");
	$DataSet->AddPoint($pod_no,"Serie2");
	$DataSet->AddAllSeries();
	$DataSet->SetAbsciseLabelSerie("Serie2");

	$Test = new pChart(447,200);
	$Test->loadColorPalette('palette.txt');
	$Test->drawFilledRoundedRectangle(7,7,444,193,5,160,160,160);
	$Test->setFontProperties("pChart/Fonts/tahoma.ttf",8);
	$Test->drawPieGraph($DataSet->GetData(),$DataSet->GetDataDescription(),150,90,110,PIE_PERCENTAGE,TRUE,50,20,5);
	$Test->drawPieLegend(310,15,$DataSet->GetData(),$DataSet->GetDataDescription(),200,200,200);

	$Test-> Stroke();
	
?>