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