<?php
session_start();
$email=$_SESSION["email"];
require("dbconnect.php");
$clr=array('AFD8F8','F6BD0F','8BBA00', 'FF8E46', '008E8E', 'D64646', '8E468E', '588526', 'B3AA00', '008ED6', '9D080D', 'A186BE');
$sql="select * From users where email='$email'";
$result=mysql_query($sql);
if(mysql_num_rows($result)!=0)
{
while($row = mysql_fetch_array($result))
{
$uid=$row['uid'];
}
}
$sql1="select os,count(os) as share From stat where uid='$uid' group by os;";
$result1=mysql_query($sql1);
echo "<graph caption='Browser Share' xAxisName='Browser' yAxisName='Share' showNames='1' animation='1' lableDisplay=' STAGGER' showLabels='1' rotateLabels='0' showShadow='1' showAlternateVGridColor='1' alternateVGridAlpha='10' alternateVGridColor='AFD8F8' numDivLines='4' decimalPrecision='0' canvasBorderThickness='1' canvasBorderColor='114B78' baseFontColor='114B78' hoverCapBorderColor='114B78' hoverCapBgColor='E7EFF6' decimalPrecision='0' formatNumberScale='0'>";
$i=0;
if(mysql_num_rows($result1)!=0)
{
//echo "uiiiiii===>>>$uid";
while($col=mysql_fetch_array($result1)){
$i++;
echo "<set name='".$col['os'] ."' value='".$col['share']."' color='".$clr[$i%12]."' />";
}
}
else echo "error";
echo "</graph>";
?>