/******************************************************************************
 JN_getMonthlyUniques()
 Created 02.10.05 v0.4b
 ******************************************************************************/
function JN_getMonthlyUniques() {
	global $SI_tables,$tz_offset;
	$count = 0;
	$month = array();
	$tmp = '';
	
	$sql = "SELECT FROM_UNIXTIME(dt, '%Y') as year, FROM_UNIXTIME(dt, '%M') as month,  FROM_UNIXTIME(dt, '%m') as monthnum, COUNT(DISTINCT remote_ip) as total FROM $SI_tables[stats] GROUP BY 1, 3 ORDER BY 1 DESC, 3 DESC";
	$result = mysql_query($sql);
	
	$tmp  = "<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\n";
	$tmp .= "\t<tr><th colspan=\"2\">Uniques by Month</th></tr>\n";
	$tmp .= "\t<tr><td class=\"accent\">Month Year</td><td class=\"accent last\">Uniques</td></tr>\n";
	while ($row = mysql_fetch_array($result)) {
		$tmp .= '<tr><td>' . $row['month'] . ' ' . $row['year'] . '</td><td class="last">' . $row['total'] . '</td></tr>';
	}
	$tmp .= '</table>';
	
	return $tmp;
}