html/callback/getProjects.php

<?php
/*******************************************************************************
 * Copyright (c) 2007 Eclipse Foundation and others.
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the Eclipse Public License v1.0
 * which accompanies this distribution, and is available at
 * http://www.eclipse.org/legal/epl-v10.html
 *
 * Contributors:
 *    Paul Colton (Aptana)- initial API and implementation

*******************************************************************************/
require_once("cb_global.php");

$return = "";

if(isset($_SESSION['language'])) {
	$query = "select 
			DISTINCT projects.*  
		  from 
		  	projects,
		  	files,
		  	strings
		  where 
		  	projects.project_id =files.project_id
		  and
		  	files.file_id = strings.file_id
		  and
		  	projects.is_active = 1
		  ";


	$res = mysql_query($query,$dbh);

//	$return = '<ul id="project-choices">';

	while($line = mysql_fetch_array($res, MYSQL_ASSOC)){
		$ret = Array();
		$ret['project'] = $line['project_id'];
		//	$ret['version'] = $line['version'];
		if(isset($_SESSION['project']) and $line['project_id'] == $_SESSION['project']){
			$ret['current'] = true;
		}
		$return[] = $ret;
	}
	//	$return .= '<li><a href="project_id='.$line['project_id'].'">'.$line['project_id'].'</a>';

	//$return .= "</ul>";
}
print json_encode($return);

?>