xml/releasetrain.php

<?php
require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/app.class.php");
//require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/nav.class.php");
//require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/menu.class.php");

// ----------------------------------------------------------------------------
// PHOENIX STUFF

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

$release = 'Helios';

echo "<release-train name=\"$release\">\n";

$App 	= new App();
include($App->getProjectCommon());

$result = $App->eclipse_sql("
	SELECT distinct ProjectID FROM ProjectInfo, ProjectInfoValues
		WHERE ProjectInfo.ProjectInfoID = ProjectInfoValues.ProjectInfoID
			AND MainKey = 'simultaneousrelease'
			AND SubKey = LOWER('$release')
			AND Value = 1
		ORDER BY ProjectID
");

while($row = mysql_fetch_object($result)) {
	echo "\t<project id=\"$row->ProjectID\"/>\n";
}
echo "</release-train>";
?>