| <?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"; |
| } |
| } |
| |
| ?> |
