blob: e4aac0321969e7fcb5fd3aa627385ecf7a21dfb9 [file] [log] [blame]
<?php
/* Copyright (c) 2006, 2007 Eclipse Foundation, made available under EPL v1.0
* Contributors Ward Cunningham, Bjorn Freeman-Benson, Nick Boldt
*
* The REST web-api for retrieving records from the database.
*
* top=name
* project=name
* year=yyyy
* month=yyyymm
* day=yyyymmdd
* email=name
* replytoid=name
* newsgroup=name
* messageid=name
*
* fields=field1,field2,field3,...
* where fields can be any of: ID,
* DATE, YEAR, YEARMONTH, YEARMONTHDAY,
* TOPPROJECT, PROJECT,
* MESSAGEID, NEWSGROUP,
* EMAIL, REPLYTOID,
* REPLYDAYS
*
* If fields is not set the default fields are DISTINCT PROJECT, NEWSGROUP, MIN(DATE), MAX(DATE), COUNT(MESSAGEID)
*
* Examples:
* http://dash.eclipse.org/dash/commits/web-api/news.php?email=codeslave%25&project=modeling%25
* http://dash.eclipse.org/dash/commits/web-api/news-activity.php?email=merks%25&day=20060529
*
*/
header("Content-type: text/plain");
require_once "news-common.inc.php";
$allFields = "PROJECT, NEWSGROUP, MIN(DATE), MAX(DATE), COUNT(MESSAGEID)";
$fields = getFields("PROJECT, NEWSGROUP");
$where = getWHERE();
displayQuery("SELECT " . (!isset($_SERVER["QUERY_STRING"]) || !$_SERVER["QUERY_STRING"] ? $allFields : $fields) . " FROM news" . ($where ? " WHERE " . $where : "") . " GROUP BY $fields ORDER BY $fields");
?>