blob: 90bfe8a8f077bbae2f553d17d98dc68dbeeb4dc1 [file] [log] [blame]
<?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);
?>