<?php

function getProjectList()
{
	global $db;


	$sql = "SELECT * FROM ".$db->prefix('devtracker_projects');
	if($result = $db->query($sql))
	{
	  while ($row = $db->fetch_object($result))
	  {
		$arrRet[$row->proj_id] = $row->proj_name;
	  }
	}
	return $arrRet;
}

function projID2Name($proj_id)
{
	global $db;


	$sql = "SELECT * FROM ".$db->prefix('devtracker_projects')." WHERE proj_id=$proj_id";
	if($result = $db->query($sql))
	{
	  if ($row = $db->fetch_object($result))
	  {
		return $row->proj_name;
	  }
	}
	return '';
}

function getCurrentVersion($proj_id)
{
	global $db;

	$sql = "SELECT * FROM ".$db->prefix('devtracker_projects')." WHERE proj_id=$proj_id";
	if($result = $db->query($sql))
	{
	  if ($row = $db->fetch_object($result))
	  {
		return $row->current_version;
	  }
	}
	return '';
}

?>