public static function getById($lab_config_id)
{
$saved_db = DbUtil::switchToGlobal();
global $con;
//$lab_config_id = mysql_real_escape_string($lab_config_id, $con);
$query_config = "SELECT * FROM lab_config WHERE lab_config_id = {$lab_config_id} LIMIT 1";
$record = query_associative_one($query_config);
DbUtil::switchRestore($saved_db);
return LabConfig::getObject($record);
}
public function listOwnedLabs($admin_user_id)
{
# Returns list of lab configurations / sites owned by the admin user
$query_string =
"SELECT * FROM lab_config WHERE admin_user_id=$admin_user_id";
$resultset = query_associative_all($query_string, $row_count);
$retval = "";
if(count($resultset) == 0)
{
$retval = "-";
return $retval;
}
foreach($resultset as $record)
{
$lab_config = LabConfig::getObject($record);
$retval .= $lab_config->getSiteName()."<br>";
}
return $retval;
}
