<?php
/* Copyright (c) 2006 Eclipse Foundation, made available under EPL v1.0
 * Contributors Ward Cunningham, Bjorn Freeman-Benson
 *
 * The REST web-api for retrieving active committer summaries from the database.
 *
 */
header("Content-type: text/plain");

error_reporting(E_ALL ^ E_NOTICE);

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

$d = getdate(time());
$d3 = mktime(0, 0, 0, $d[mon]-3, $d[mday], $d[year]);
$d3q = strftime( "%Y%m%d", $d3 );

$_query0 = "select COUNT(DISTINCT LOGIN) AS COUNT FROM commits WHERE YEARMONTHDAY >= $d3q";

echo( "# " . $_query0 . "\n" );
$result = mysql_query($_query0,$_dbh);
if (!$result) {
  echo("MySQL Error: ".mysql_error());
} else {
  while($row = mysql_fetch_assoc($result)){
    echo $row['COUNT'] . "\n";
  }
}

?>