web-api/roots-generator.php

<?php
if( !preg_match( "/206\.191\.52\.40|209\.217\.126\.101|63\.227\.217\.22|71\.237\.213\.109/", $_SERVER['REMOTE_ADDR'] ) ) { 
	/* dash.eclipse.org, ?, ?, Bjorn's home office */
   $log = fopen( $logfile, "a" );
   fwrite( $log, date('Y-m-d.H:i:s') . " " . $_SERVER['REMOTE_ADDR'] . " is an invalid caller\n" );
   fclose( $log );
   echo $_SERVER['REMOTE_ADDR'] . " is an invalid caller<br>\n";
   exit;
}
header("Content-type: text/plain");
require_once ("/home/data/httpd/eclipse-php-classes/system/dbconnection.class.php");
require_once ("/home/data/httpd/eclipse-php-classes/system/dbconnection_foundation_ro.class.php");

switch($_REQUEST['type']) {
	default:
	case 'cvs': $type = 'LIKE "%cvsroot%"'; break;
	case 'svn': $type = 'NOT LIKE "%cvsroot%"'; break;
}

$_dbcf = new DBConnectionFoundation();
$_dbhf = $_dbcf->connect();

$resultf = mysql_query("SELECT ProjectID FROM Projects
		WHERE IsActive = TRUE", $_dbhf);
$active_projects = array();
while( $rowf = mysql_fetch_assoc($resultf) ) {
	$active_projects[$rowf['ProjectID']] = 1;
}

$dbc = new DBConnection();
$dbh = $dbc->connect();

$result = mysql_query("SELECT ProjectID, Value FROM v_projectinfo_merged
		WHERE MainKey = 'sourcerepository' AND Value $type AND Value != ''", $dbh);

while($row = mysql_fetch_assoc($result)) {
	if( $active_projects[$row['ProjectID']] ) {
		echo $row['ProjectID'] . "\t" . $row['Value'] . "\n";
	}
}
?>