public void Load()
{
_zones = new Dictionary <uint, Zone>();
_groups = new Dictionary <ushort, ZoneGroup>();
_conflicts = new Dictionary <ushort, ZoneConflict>();
_groupBannedTags = new Dictionary <uint, ZoneGroupBannedTag>();
_climateElem = new Dictionary <uint, ZoneClimateElem>();
_log.Info("Loading ZoneManager...");
using (var connection = SQLite.CreateConnection())
{
using (var command = connection.CreateCommand())
{
command.CommandText = "SELECT * FROM zones";
command.Prepare();
using (var reader = new SQLiteWrapperReader(command.ExecuteReader()))
{
while (reader.Read())
{
var template = new Zone();
template.Id = reader.GetUInt32("id");
template.Name = (string)reader.GetValue("name");
template.ZoneKey = reader.GetUInt32("zone_key");
template.GroupId = reader.GetUInt32("group_id", 0);
template.Closed = reader.GetBoolean("closed", true);
template.FactionId = reader.GetUInt32("faction_id", 0);
template.ZoneClimateId = reader.GetUInt32("zone_climate_id", 0);
_zones.Add(template.ZoneKey, template);
}
}
}
_log.Info("Loaded {0} zones", _zones.Count);
using (var command = connection.CreateCommand())
{
command.CommandText = "SELECT * FROM zone_groups";
command.Prepare();
using (var reader = new SQLiteWrapperReader(command.ExecuteReader()))
{
while (reader.Read())
{
var template = new ZoneGroup();
template.Id = reader.GetUInt16("id");
template.Name = (string)reader.GetValue("name");
template.X = reader.GetFloat("x");
template.Y = reader.GetFloat("y");
template.Width = reader.GetFloat("w");
template.Hight = reader.GetFloat("h");
template.TargetId = reader.GetUInt32("target_id");
template.FactionChatRegionId = reader.GetUInt32("faction_chat_region_id");
template.PirateDesperado = reader.GetBoolean("pirate_desperado", true);
template.FishingSeaLootPackId = reader.GetUInt32("fishing_sea_loot_pack_id", 0);
template.FishingLandLootPackId = reader.GetUInt32("fishing_land_loot_pack_id", 0);
// TODO 1.2 // template.BuffId = reader.GetUInt32("buff_id", 0);
_groups.Add(template.Id, template);
}
}
}
_log.Info("Loaded {0} groups", _groups.Count);
using (var command = connection.CreateCommand())
{
command.CommandText = "SELECT * FROM conflict_zones";
command.Prepare();
using (var reader = new SQLiteWrapperReader(command.ExecuteReader()))
{
while (reader.Read())
{
var zoneGroupId = reader.GetUInt16("zone_group_id");
if (_groups.ContainsKey(zoneGroupId))
{
var template = new ZoneConflict(_groups[zoneGroupId]);
template.ZoneGroupId = zoneGroupId;
for (var i = 0; i < 5; i++)
{
template.NumKills[i] = reader.GetInt32($"num_kills_{i}");
template.NoKillMin[i] = reader.GetInt32($"no_kill_min_{i}");
}
template.ConflictMin = reader.GetInt32("conflict_min");
template.WarMin = reader.GetInt32("war_min");
template.PeaceMin = reader.GetInt32("peace_min");
template.PeaceProtectedFactionId = reader.GetUInt32("peace_protected_faction_id", 0);
template.NuiaReturnPointId = reader.GetUInt32("nuia_return_point_id", 0);
template.HariharaReturnPointId = reader.GetUInt32("harihara_return_point_id", 0);
template.WarTowerDefId = reader.GetUInt32("war_tower_def_id", 0);
// TODO 1.2 // template.PeaceTowerDefId = reader.GetUInt32("peace_tower_def_id", 0);
_groups[zoneGroupId].Conflict = template;
_conflicts.Add(zoneGroupId, template);
}
else
{
_log.Warn("ZoneGroupId: {1} doesn't exist for conflict", zoneGroupId);
}
}
}
}
using (var command = connection.CreateCommand())
{
command.CommandText = "SELECT * FROM zone_group_banned_tags";
command.Prepare();
using (var reader = new SQLiteWrapperReader(command.ExecuteReader()))
{
while (reader.Read())
{
var template = new ZoneGroupBannedTag();
template.Id = reader.GetUInt32("id");
template.ZoneGroupId = reader.GetUInt32("zone_group_id");
template.TagId = reader.GetUInt32("tag_id");
// TODO 1.2 // template.BannedPeriodsId = reader.GetUInt32("banned_periods_id");
_groupBannedTags.Add(template.Id, template);
}
}
}
_log.Info("Loaded {0} group banned tags", _groupBannedTags.Count);
using (var command = connection.CreateCommand())
{
command.CommandText = "SELECT * FROM zone_climate_elems";
command.Prepare();
using (var reader = new SQLiteWrapperReader(command.ExecuteReader()))
{
while (reader.Read())
{
var template = new ZoneClimateElem();
template.Id = reader.GetUInt32("id");
template.ZoneClimateId = reader.GetUInt32("zone_climate_id");
template.ClimateId = reader.GetUInt32("climate_id");
_climateElem.Add(template.Id, template);
}
}
}
_log.Info("Loaded {0} climate elems", _climateElem.Count);
}
}