gobrien | ad11d89 | 2007-12-19 08:33:25 +0000 | [diff] [blame] | 1 | <?php |
| 2 | /******************************************************************************* |
| 3 | * Copyright (c) 2007 Eclipse Foundation and others. |
| 4 | * All rights reserved. This program and the accompanying materials |
| 5 | * are made available under the terms of the Eclipse Public License v1.0 |
| 6 | * which accompanies this distribution, and is available at |
| 7 | * http://www.eclipse.org/legal/epl-v10.html |
| 8 | * |
| 9 | * Contributors: |
| 10 | * Paul Colton (Aptana)- initial API and implementation |
| 11 | |
| 12 | *******************************************************************************/ |
| 13 | require_once("cb_global.php"); |
| 14 | |
| 15 | |
gobrien | da3a450 | 2008-01-28 23:43:26 +0000 | [diff] [blame^] | 16 | |
| 17 | if(!isset($_SESSION['project'])){ |
| 18 | return array(); |
| 19 | } |
| 20 | |
gobrien | 1c01c75 | 2008-01-10 18:34:31 +0000 | [diff] [blame] | 21 | $query = "select |
gobrien | 38c0255 | 2008-01-23 22:52:02 +0000 | [diff] [blame] | 22 | DISTINCT files.version,files.project_id |
gobrien | 1c01c75 | 2008-01-10 18:34:31 +0000 | [diff] [blame] | 23 | from |
| 24 | project_versions, |
| 25 | files |
| 26 | where |
| 27 | files.project_id = project_versions.project_id |
| 28 | and |
| 29 | files.version = project_versions.version |
| 30 | and |
| 31 | project_versions.is_active = 1 |
| 32 | and |
| 33 | project_versions.project_id = '".addslashes($_SESSION['project'])."'"; |
gobrien | ad11d89 | 2007-12-19 08:33:25 +0000 | [diff] [blame] | 34 | |
| 35 | //print $query."\n"; |
| 36 | |
| 37 | $res = mysql_query($query,$dbh); |
| 38 | |
| 39 | while($line = mysql_fetch_array($res, MYSQL_ASSOC)){ |
| 40 | $ret = Array(); |
| 41 | $ret['version'] = $line['version']; |
gobrien | da3a450 | 2008-01-28 23:43:26 +0000 | [diff] [blame^] | 42 | if(isset($_SESSION['version']) and $line['version'] == $_SESSION['version']){ |
gobrien | e4a39c8 | 2008-01-11 00:06:14 +0000 | [diff] [blame] | 43 | $ret['current'] = true; |
| 44 | } |
gobrien | ad11d89 | 2007-12-19 08:33:25 +0000 | [diff] [blame] | 45 | $return[] = $ret; |
| 46 | } |
| 47 | |
| 48 | print json_encode($return); |
| 49 | |
| 50 | ?> |