<?
//Connect To Database
$hostname="localhost";
$username="jt6mm0c_db19116";
$password="pn@IUO?hh8kbHj5A";
$dbname="jt6mm0c_db19116_emocapsule";

mysql_connect($hostname,$username, $password) OR DIE ("Unable to connect to database! Please try again later.");
mysql_select_db($dbname);

//getting emotion
	$emotion = $_POST['emotion'];
	
	$loc = $_REQUEST['loc'];

	//setting the time zone
	date_default_timezone_set('EST5EDT');
 
 	//getting the time/date
	$now = time();
	$date = strftime('%H_%M_%S_%b%d%y',$now);

    if(isset($_COOKIE['city']) && isset($_COOKIE['country'])){
		$localCity = $_COOKIE['city'];
		$localCountry = $_COOKIE['country'];
	}
	
	//is calculating how many bar to display in the graph
	if (!isset($_REQUEST['display'])){
		$display = 5;
		
	}else{
		$display = $_REQUEST['display'];
		
	}
	$location = $_REQUEST['location'];
		
	$allCities = @mysql_query("SELECT DISTINCT city FROM webEmotion GROUP BY city ORDER BY `city` DESC"); 
	$numCities=mysql_numrows($allCities);

//Gets the total of all cities an emotion was submitted, than orders on where the most emotions were submitted.
$totalCity = @mysql_query("SELECT city, count( city ) AS num_times FROM webEmotion GROUP BY city ORDER BY `num_times` DESC"); 
	$totalCityNum=mysql_numrows($totalCity);

//gets unique citys 
$emotionCityOrdered = @mysql_query("SELECT city FROM webEmotion"); 

$numCity=mysql_numrows($emotionCityOrdered);
   
    $i=0;
while($i<$totalCityNum){
  $city_[$i] = mysql_result($totalCity, $i, 'city');
  $num_loc_[$i] = mysql_result($totalCity, $i, 'num_times');
  
  //calculates the percentage of each city compared to all cities an emotion was submitted 
  $percentage[$i] = ceil((($num_loc_[$i]/$numCity)*100));

  //calculates the pixels for drawing the bar graphs -------> subtracts 500 caouse it draws from the top
  //----------> this is for the google api
  $num_loc_[$i] = ceil((($num_loc_[$i]/$numCity)*500));
  
  $i++;
  }

$string = '';

foreach($city_ as $key => $value){
		
	$string .="$value|";
}

$string = str_replace(' ', '', $string);


// *********** THE $num_loc_ VARIABLE DOES NOT TO BE JOINED INTO AN ARRAY!
$test_data = $num_loc_;

// Here's where we call the chart, and return the encoded chart data

//dynamic graph witdh
$graphWidth = ((50*$totalCityNum)+100);


echo "<img src=http://chart.apis.google.com/chart?chtt=".urlencode("Emotion Input vs. City")."&amp;chs=".$graphWidth."x300&amp;chd=".chart_data($test_data)."&amp;cht=bvg&amp;chbh=40&amp;chco=ff33cc&amp;chxt=x,y&amp;chxl=0:|".$string."1:|0%|25%|50%|75%|100%&amp;chg=5,25>";

//inserting into the database to keep track of the charts
$chartInsert="INSERT INTO `emoChart` (`chartType`, `url`,`date`) VALUES ('inputCity','$url','$now')";
$resultInsert=mysql_query($chartInsert);


// And here's the function that incodes the graph values into a Google Chart API readable format.
function chart_data($values) {

// Port of JavaScript from http://code.google.com/apis/chart/
// http://james.cridland.net/code

// First, find the maximum value from the values given
$maxValue = 500;

// A list of encoding characters to help later, as per Google's example
$simpleEncoding = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789';

$chartData = "s:";
  for ($i = 0; $i < count($values); $i++) {
    $currentValue = $values[$i];

    if ($currentValue > -1) {
    $chartData.=substr($simpleEncoding,61*($currentValue/$maxValue),1);
    }
      else {
      $chartData.='_';
      }
  }

// Return the chart data - and let the Y axis to show the maximum value
return $chartData;

}
?>