private DbTerrainObjectDefinitions GetTerrainDefinition(int todId)
{
DbTerrainObjectDefinitions result = null;
foreach (DbTerrainObjectDefinitions definition in _terrainObjectDefinitionList)
{
if (definition.TodId == todId)
{
result = definition;
break;
}
}
return(result);
}
public PlaceInstanceTerrainDetails
(
int toId,
int wmId,
int localPosX,
int localPosY,
int localPosZ,
int parentId,
bool isParentalTeleport,
bool isExit,
DbTerrainObjectDefinitions terrainDefinition
)
{
this.ToId = toId;
this.WmId = wmId;
this.LocalPosX = localPosX;
this.LocalPosY = localPosY;
this.LocalPosZ = localPosZ;
this.ParentId = parentId;
this.IsParentalTeleport = isParentalTeleport;
this.IsExit = isExit;
this.TerrainDefinition = terrainDefinition;
}
public void Dispose()
{
this.TerrainDefinition = null;
}
/// <summary>
/// Gets data from table 'terrain_object_definitions'
/// </summary>
public BoxedData GetTerrainObjectDefinitionsData(string sqlFilter = "")
{
BoxedData data = new BoxedData();
List <DbTerrainObjectDefinitions> resultList = new List <DbTerrainObjectDefinitions>();
string msg = "";
try
{
int todId = -1;
string code = "";
int collisionX = 0;
int collisionY = 0;
int collisionZ = 0;
bool isTerrain = false;
bool isPlatform = false;
bool isObstacle = false;
string query = @"
SELECT
`tod_id`,
`tod_code`,
`tod_collision_x`,
`tod_collision_y`,
`tod_collision_z`,
`tod_is_terrain`,
`tod_is_platform`,
`tod_is_obstacle`
FROM
`terrain_object_definitions`
";
if (!String.IsNullOrWhiteSpace(sqlFilter))
{
query += $" {(!sqlFilter.ToUpper().Contains("WHERE") ? "WHERE" : "")} {sqlFilter}";
}
lock (_connectionLock)
{
using (MySqlCommand command = new MySqlCommand(query, _connection))
{
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
todId = reader.GetInt32("tod_id");
code = reader["tod_code"].ToString();
collisionX = reader.GetInt32("tod_collision_x");
collisionY = reader.GetInt32("tod_collision_y");
collisionZ = reader.GetInt32("tod_collision_z");
isTerrain = (reader.GetInt32("tod_is_terrain") == 1);
isPlatform = (reader.GetInt32("tod_is_platform") == 1);
isObstacle = (reader.GetInt32("tod_is_obstacle") == 1);
DbTerrainObjectDefinitions result = new DbTerrainObjectDefinitions
(
todId,
code,
collisionX,
collisionY,
collisionZ,
isTerrain,
isPlatform,
isObstacle
);
resultList.Add(result);
}
}
}
}
}
catch (Exception exception)
{
msg = $"Cannot get data from 'terrain_object_definitions' table, SQL filter [{sqlFilter}]: {exception.Message}";
}
data.Data = resultList;
data.Msg = msg;
return(data);
}
