/// <summary>
/// Attempts to find a telehub in the region; if one is not found, returns false.
/// </summary>
/// <param name="regionID">Region ID</param>
/// <param name="position">The position of the telehub</param>
/// <returns></returns>
public Telehub FindTelehub(UUID regionID, ulong regionHandle)
{
Telehub telehub = new Telehub();
List <string> telehubposition = GD.Query("RegionID", regionID, "telehubs", "RegionLocX,RegionLocY,TelehubLocX,TelehubLocY,TelehubLocZ,TelehubRotX,TelehubRotY,TelehubRotZ,Spawns,ObjectUUID,Name");
//Not the right number of values, so its not there.
if (telehubposition.Count != 11)
{
return(null);
}
telehub.RegionID = regionID;
telehub.RegionLocX = float.Parse(telehubposition[0]);
telehub.RegionLocY = float.Parse(telehubposition[1]);
telehub.TelehubLocX = float.Parse(telehubposition[2]);
telehub.TelehubLocY = float.Parse(telehubposition[3]);
telehub.TelehubLocZ = float.Parse(telehubposition[4]);
telehub.TelehubRotX = float.Parse(telehubposition[5]);
telehub.TelehubRotY = float.Parse(telehubposition[6]);
telehub.TelehubRotZ = float.Parse(telehubposition[7]);
telehub.SpawnPos = telehub.BuildToList(telehubposition[8]);
telehub.ObjectUUID = UUID.Parse(telehubposition[9]);
telehub.Name = telehubposition[10];
return(telehub);
}
/// <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);
}
}
}
}
public Telehub FindTelehub(UUID regionID, ulong regionHandle)
{
object remoteValue = DoRemote(regionID, regionHandle);
if (remoteValue != null || m_doRemoteOnly)
{
return((Telehub)remoteValue);
}
QueryFilter filter = new QueryFilter();
filter.andFilters["RegionID"] = regionID;
List <string> telehubposition = GD.Query(new[]
{
"RegionLocX",
"RegionLocY",
"TelehubLocX",
"TelehubLocY",
"TelehubLocZ",
"TelehubRotX",
"TelehubRotY",
"TelehubRotZ",
"Spawns",
"ObjectUUID",
"Name"
}, "telehubs", filter, null, null, null);
//Not the right number of values, so its not there.
return((telehubposition == null || telehubposition.Count != 11)
? null
: new Telehub
{
RegionID = regionID,
RegionLocX = float.Parse(telehubposition[0]),
RegionLocY = float.Parse(telehubposition[1]),
TelehubLocX = float.Parse(telehubposition[2]),
TelehubLocY = float.Parse(telehubposition[3]),
TelehubLocZ = float.Parse(telehubposition[4]),
TelehubRotX = float.Parse(telehubposition[5]),
TelehubRotY = float.Parse(telehubposition[6]),
TelehubRotZ = float.Parse(telehubposition[7]),
SpawnPos = Telehub.BuildToList(telehubposition[8]),
ObjectUUID = UUID.Parse(telehubposition[9]),
Name = telehubposition[10]
});
}
/// <summary>
/// Attempts to find a telehub in the region; if one is not found, returns false.
/// </summary>
/// <param name="regionID">Region ID</param>
/// <param name="position">The position of the telehub</param>
/// <returns></returns>
public Telehub FindTelehub(UUID regionID, ulong regionHandle)
{
Telehub telehub = new Telehub();
List<string> telehubposition = GD.Query("RegionID", regionID, "telehubs", "RegionLocX,RegionLocY,TelehubLocX,TelehubLocY,TelehubLocZ,TelehubRotX,TelehubRotY,TelehubRotZ,Spawns,ObjectUUID,Name");
//Not the right number of values, so its not there.
if (telehubposition.Count != 11)
return null;
telehub.RegionID = regionID;
telehub.RegionLocX = float.Parse(telehubposition[0]);
telehub.RegionLocY = float.Parse(telehubposition[1]);
telehub.TelehubLocX = float.Parse(telehubposition[2]);
telehub.TelehubLocY = float.Parse(telehubposition[3]);
telehub.TelehubLocZ = float.Parse(telehubposition[4]);
telehub.TelehubRotX = float.Parse(telehubposition[5]);
telehub.TelehubRotY = float.Parse(telehubposition[6]);
telehub.TelehubRotZ = float.Parse(telehubposition[7]);
telehub.SpawnPos = telehub.BuildToList(telehubposition[8]);
telehub.ObjectUUID = UUID.Parse(telehubposition[9]);
telehub.Name = telehubposition[10];
return telehub;
}
