?php
require_once("../../chartdir/lib/phpchartdir.php");

$extraDays = 0;

$SQLstatement = "Select UNIX_TimeStamp(Date), AAAC*32.151 From forex WHERE DATE_SUB(CURDATE(),INTERVAL 360 DAY) <= Date ORDER BY Date ASC";

mysql_connect("localhost", "he34tyn_gold", "gold65chart67s");
$result = mysql_db_query("he34tyn_markets", $SQLstatement) or die("Invalid
query: " . mysql_error());

while ($row = mysql_fetch_row($result)) 
{
   $unixTimeStamps[] = $row[0];
   $timeStamps[] = chartTime2($row[0]);
   $Bid[] = $row[1];
}

$selectDates = new ArrayMath($timeStamps);
$selectDates->selectStartOfMonth();
$labels = array_slice($selectDates->result(), $extraDays);

#==========================================================================
#    Create the top chart
#==========================================================================

$c = new XYChart(800, 600, Transparent);

$plotAreaObj = $c->setPlotArea(20, 5, 690, 423);
$plotAreaObj->setGridColor(0xE8F4FA, 0xE8F4FA);

$legendObj = $c->addLegend(20, 412, false, "arial.ttf", 7.5);
$legendObj->setBackground(Transparent);

$lineLayerObj = $c->addLineLayer(array_slice($Bid, $extraDays), 0x0000FF);

$lastIndex = count($Bid) - 1;
$myText = strftime("%b-%d", $unixTimeStamps[$lastIndex])   ;
$c->addText(22, 5, $myText, "arial.ttf", 10);

$lastIndex = count($Bid) - 1;
$myText = strftime("", $unixTimeStamps[$lastIndex])."   US Palladium = ".round($Bid[$lastIndex], 0)."kg"   ;
$c->addText(540, 5, $myText, "arial.ttf", 10);

$c->xAxis->setLabels2($labels, "{value|mmm}");
$c->xAxis->setColors(LineColor, 0x000000);
$c->yAxis->setAutoScale(0.05, 0.05, 0);
$c->setYAxisOnRight();

#==========================================================================

$m = new MultiChart(760, 475);

$m->addTitle("US DOLLAR PALLADIUM - PRICE PER KILO", "arialbi.ttf", 14, 0x0000FF);
$m->addText(298, 462, "world gold charts © www.goldchartsrus.com", "arial.ttf", 8, 0x000000);


$m->addChart(0, 17, $c);

header("Content-type: image/png");
print($m->makeChart2(PNG));
?>