/// <summary>
/// Attempts to find a telehub in the region; if one is not found, returns false.
/// </summary>
/// <param name="regionID">Region ID</param>
/// <returns></returns>
public Telehub FindTelehub(UUID regionID)
{
string sql = "SELECT * FROM telehubs where RegionID=?RegionID";
using (MySqlConnection conn = GetConnection())
{
using (MySqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
cmd.Parameters.Add("?RegionID", regionID.ToString());
using (IDataReader r = cmd.ExecuteReader())
{
if (r.Read())
{
if (r.FieldCount == 0)
{
return(null);
}
return(new Telehub()
{
RegionID = UUID.Parse(r["RegionID"].ToString()),
TelehubLoc = Vector3.Parse(r["TelehubLoc"].ToString()),
TelehubRot = Quaternion.Parse(r["TelehubRot"].ToString()),
Name = r["Name"].ToString(),
ObjectUUID = UUID.Parse(r["ObjectUUID"].ToString()),
SpawnPos = Telehub.BuildToList(r["Spawns"].ToString())
});
}
return(null);
}
}
}
}