$data[$i] = 0;
$labels[$i] = date("M", mktime(0, 0, 0, $i));
$colors[$i] = array('r' => 0xcc, 'g' => 0x33, 'b' => 0x33);
}
// retrieve total hits
$query = sprintf('
SELECT
MONTH(ACCESS_TIME) AS ATIME, COUNT(IP_ADDRESS) AS TOTAL
FROM
%sSITE_ACCESS
WHERE
DATE(ACCESS_TIME) BETWEEN
"%d-01-01" AND
"%d-12-31"
GROUP
BY ATIME
ORDER BY
ATIME ASC', DB_TBL_PREFIX, $year, $year);
$result = mysql_query($query, $GLOBALS['DB']);
while ($row = mysql_fetch_assoc($result)) {
$data[$row['ATIME']] = $row['TOTAL'];
}
mysql_free_result($result);
} else {
die;
}
}
// present bar chart
$chart = new BarChart(500, 200);
$chart->graphData($data, $colors, $labels);
$chart->flushImage();
