<?php
/*******************************************************************************
* Copyright (c) 2011 Eclipse Foundation and others.
* All rights reserved. This program and the accompanying materials
* are made available under the terms of the Eclipse Public License v1.0
* which accompanies this distribution, and is available at
* http://www.eclipse.org/legal/epl-v10.html
*
* Contributors:
*    Wayne Beaton (Eclipse Foundation)- initial API and implementation
*******************************************************************************/

header("Content-type: text/plain");

$user="dashboard";
require_once( "dbpassword.php" );
$database="dashboard";
$_dbh = mysql_connect('dashdbhost',$user,$password);
mysql_select_db( $database, $_dbh );

$sql = "select yearmonth as period, count(distinct login) as count from commits group by yearmonth";

$result = mysql_query($sql,$_dbh);
while($row = mysql_fetch_assoc($result)) {
	$period = $row['period'];
	$count = $row['count'];

	echo "$period, $count\n";
}

?>