private void AddStructures(DbGame game, DbTurn turn, JArray structures, DbRegion region, Dictionary <string, string> structuresMemory, Dictionary <int, string> unitMemory, Dictionary <int, string> orders)
{
int structureOrder = 0;
foreach (JObject structure in structures)
{
var str = structure["structure"] as JObject;
var s = new DbStructure {
GameId = game.Id,
TurnId = turn.Id,
Sequence = structureOrder,
Number = str.Value <int>("number"),
Type = str.Value <string>("type"),
Name = str.Value <string>("name"),
Units = new List <DbUnit>(),
Json = str.ToString()
};
var emphId = DbStructure.GetEmpheralId(region.X, region.Y, region.Z, s.Number, s.Type);
s.Memory = structuresMemory.TryGetValue(emphId, out var structMem)
? structMem
: null;
var units = structure["units"] as JArray;
if (units != null)
{
AddUnits(game, turn, units, region, s, unitMemory, orders);
}
region.Structures.Add(s);
turn.Structures.Add(s);
structureOrder++;
}
}
public void TestPKRename()
{
SqlConnection conn = new SqlConnection("Data Source=(local);Initial Catalog=Door_Production;" + "Integrated Security=true");
DbStructure structure = new DbStructure();
structure.FillStructure(conn);
Table t = structure.Tables.FirstOrDefault(x => x.Name == "Door");
t.RenameColumnPK("Door_ID", conn);
}
public TableUserControl(DbStructure _structure)
{
InitializeComponent();
structure = _structure;
for (int i = 0; i < structure.Tables.Count; i++)
{
ListTables.Items.Add(structure.Tables[i].Name);
}
textBoxChangedDB.Text = structure.DataBaseName;
}
public void TestStructureInitialization()
{
SqlConnection conn = new SqlConnection("Data Source=(local);Initial Catalog=Door_Production;" + "Integrated Security=true");
DbStructure structure = new DbStructure();
structure.FillStructure(conn);
Console.WriteLine(structure.DataBaseName + "\n");
foreach (var tab in structure.Tables)
{
Console.WriteLine(tab.Name);
}
}
private static void CopyInvisibleRegions(long gameId, DbTurn turn, DbTurn lastTurn, DbGame game)
{
var visibleRegions = turn.Regions.ToDictionary(k => k.EmpheralId);
var allRegions = lastTurn.Regions.ToDictionary(k => k.EmpheralId);
foreach (var key in allRegions.Keys.Except(visibleRegions.Keys))
{
var invisibleRegion = allRegions[key];
var regCopy = new DbRegion
{
GameId = gameId,
TurnId = turn.Id,
UpdatedAtTurn = invisibleRegion.UpdatedAtTurn,
X = invisibleRegion.X,
Y = invisibleRegion.Y,
Z = invisibleRegion.Z,
Label = invisibleRegion.Label,
Province = invisibleRegion.Province,
Terrain = invisibleRegion.Terrain,
Structures = new List <DbStructure>(),
Units = new List <DbUnit>(),
Json = invisibleRegion.Json,
Memory = invisibleRegion.Memory
};
if (invisibleRegion.Structures != null)
{
foreach (var str in invisibleRegion.Structures)
{
var strCopy = new DbStructure
{
GameId = game.Id,
TurnId = turn.Id,
Sequence = str.Sequence,
Number = str.Number,
Type = str.Type,
Name = str.Name,
Units = new List <DbUnit>(),
Json = str.Json
};
regCopy.Structures.Add(strCopy);
turn.Structures.Add(strCopy);
}
}
turn.Regions.Add(regCopy);
}
}
public void Update(DbStructure _structure)
{
if (structure.Tables.Count != 0)
{
structure = _structure;
ListTables.UnselectAll();
ListTables.Items.Clear();
for (int i = 0; i < structure.Tables.Count; i++)
{
ListTables.Items.Add(structure.Tables[i].Name);
}
textBoxChangedDB.Text = structure.DataBaseName;
ListColums.Items.Clear();
}
}
public async Task DeleteServer(DeltaConnection conn)
{
//Delete this
var filter = Builders <DbServer> .Filter.Eq("_id", this._id);
await conn.system_servers.DeleteOneAsync(filter);
//Delete content
await DbTribe.DeleteServerContent(conn, this._id);
await DbStructure.DeleteServerContent(conn, this._id);
await DbInventory.DeleteServerContent(conn, this._id);
await DbDino.DeleteServerContent(conn, this._id);
await DbPlayerProfile.DeleteServerContent(conn, this._id);
//Send Events
conn.events.OnServerDeleted(this);
//It's unimportant to notify user groups changed, as no further events will ever be sent from this server
}
/// <summary>
/// To /v1/structures
/// </summary>
/// <param name="e"></param>
/// <returns></returns>
public static async Task OnHttpRequest(Microsoft.AspNetCore.Http.HttpContext e)
{
//Authenticate
DbServer server = await Program.ForceAuthServer(e);
if (server == null)
{
return;
}
//Read structures data
RevisionMappedDataPutRequest <StructureData> payload = Program.DecodeStreamAsJson <RevisionMappedDataPutRequest <StructureData> >(e.Request.Body);
//Convert all structures
List <WriteModel <DbStructure> > structureActions = new List <WriteModel <DbStructure> >();
List <WriteModel <DbItem> > itemActions = new List <WriteModel <DbItem> >();
foreach (var s in payload.data)
{
//Ignore if no tribe ID is set
if (s.tribe == 0)
{
continue;
}
//Convert
DbStructure structure = new DbStructure
{
classname = Program.TrimArkClassname(s.classname),
current_health = s.health,
current_item_count = 0,
has_inventory = false,
location = s.location,
max_health = s.max_health,
max_item_count = 0,
server_id = server._id,
structure_id = s.id,
tribe_id = s.tribe,
revision_id = payload.revision_id,
revision_type = payload.revision_index,
custom_name = null
};
//Set inventory flags
structure.has_inventory = s.max_items > 0;
structure.custom_name = s.name;
structure.max_item_count = s.max_items;
structure.current_item_count = s.item_count;
//Create filter for updating this structure
var filterBuilder = Builders <DbStructure> .Filter;
var filter = filterBuilder.Eq("structure_id", s.id) & filterBuilder.Eq("server_id", server.id);
//Now, update (or insert) this into the database
var a = new ReplaceOneModel <DbStructure>(filter, structure);
a.IsUpsert = true;
structureActions.Add(a);
}
//Apply actions
if (structureActions.Count > 0)
{
await Program.conn.content_structures.BulkWriteAsync(structureActions);
structureActions.Clear();
}
await Tools.InventoryManager.UpdateInventoryItems(itemActions, Program.conn);
//Write finished
e.Response.StatusCode = 200;
await Program.WriteStringToStream(e.Response.Body, "OK");
}
private static void AddUnits(DbGame game, DbTurn turn, JArray units, DbRegion region, DbStructure structure, Dictionary <int, string> unitMemory, Dictionary <int, string> orders)
{
int unitOrder = 0;
foreach (JObject unit in units)
{
var unitFaction = unit["faction"] as JObject;
var u = new DbUnit
{
GameId = game.Id,
TurnId = turn.Id,
Number = unit.Value <int>("number"),
Name = unit.Value <string>("name"),
FactionNumber = unitFaction != null
? unitFaction.Value <int>("number")
: (int?)null,
Sequence = unitOrder
};
u.Own = game.PlayerFactionNumber == u.FactionNumber;
u.Memory = u.Own && unitMemory.TryGetValue(u.Number, out var unitMem)
? unitMem
: null;
u.Orders = orders.TryGetValue(u.Number, out var unitOrders)
? unitOrders
: null;
unit["own"] = u.Own; // because could be loaded several reports from different factions
u.Json = unit.ToString();
region.Units.Add(u);
turn.Units.Add(u);
if (structure != null)
{
structure.Units.Add(u);
}
unitOrder++;
}
}
public async Task UploadReport([Required, FromRoute] long gameId)
{
using var bodyReader = new StreamReader(Request.Body);
using var converter = new AtlantisReportJsonConverter(bodyReader);
using var buffer = new MemoryStream();
using var bufferWriter = new StreamWriter(buffer);
using JsonWriter writer = new JsonTextWriter(bufferWriter);
await converter.ConvertAsync(writer);
buffer.Seek(0, SeekOrigin.Begin);
using var bufferReader = new StreamReader(buffer);
using JsonReader reader = new JsonTextReader(bufferReader);
JObject report = await JObject.LoadAsync(reader);
var faction = report["faction"] as JObject;
var date = report["date"] as JObject;
var engine = report["engine"] as JObject;
var factionStatus = report["factionStatus"] as JArray;
var errors = report["errors"] as JArray;
var events = report["events"] as JArray;
var skillReports = report["skillReports"] as JArray;
var objectReports = report["objectReports"] as JArray;
var itemReports = report["itemReports"] as JArray;
var attitudes = report["attitudes"] as JObject;
var unclaimedSilver = report["unclaimedSilver"];
var regions = report["regions"] as JArray;
var ordersTemplate = report["ordersTemplate"] as JObject;
var turn = new DbTurn
{
GameId = gameId,
Year = date.Value <int>("year"),
Month = MonthToNumber(date.Value <string>("month")),
Factions = new List <DbFaction>(),
Regions = new List <DbRegion>(),
Structures = new List <DbStructure>(),
Events = new List <DbEvent>(),
Units = new List <DbUnit>()
};
turn.Number = (turn.Year - 1) * 12 + turn.Month;
// ensure that there are no turn with the same number
await RemoveTurn(gameId, turn.Number);
db.ChangeTracker.AutoDetectChangesEnabled = false;
var lastTurn = await db.Turns
.OrderByDescending(x => x.Id)
.Include(x => x.Factions)
.Include(x => x.Units)
.Include(x => x.Structures)
.Include(x => x.Regions)
.ThenInclude(x => x.Structures)
.FirstOrDefaultAsync(x => x.GameId == gameId);
Dictionary <string, string> regionMemory = lastTurn != null
? lastTurn.Regions
.ToDictionary(k => k.EmpheralId, v => v.Memory)
: new Dictionary <string, string>();
Dictionary <int, string> unitMemory = lastTurn != null
? lastTurn.Units
.Where(x => x.Own)
.ToDictionary(k => k.Number, v => v.Memory)
: new Dictionary <int, string>();
Dictionary <string, string> structuresMemory = lastTurn != null
? lastTurn.Structures
.ToDictionary(k => DbStructure.GetEmpheralId(k.Region.X, k.Region.Y, k.Region.Z, k.Number, k.Type), v => v.Memory)
: new Dictionary <string, string>();
db.ChangeTracker.AutoDetectChangesEnabled = true;
var game = await db.Games.FindAsync(gameId);
turn.Memory = lastTurn?.Memory;
await db.Turns.AddAsync(turn);
await db.SaveChangesAsync();
var f = new DbFaction
{
GameId = gameId,
TurnId = turn.Id,
Name = faction.Value <string>("name"),
Number = faction.Value <int>("number"),
Json = new JObject(
new JProperty("faction", faction),
new JProperty("factionStatus", factionStatus),
new JProperty("skillReports", skillReports),
new JProperty("objectReports", objectReports),
new JProperty("itemReports", itemReports),
new JProperty("attitudes", attitudes),
new JProperty("unclaimedSilver", unclaimedSilver)
).ToString(),
};
if (!game.PlayerFactionNumber.HasValue)
{
game.PlayerFactionNumber = f.Number;
game.EngineVersion = engine.Value <string>("version");
var ruleset = engine["ruleset"] as JObject;
game.RulesetName = ruleset.Value <string>("name");
game.RulesetVersion = ruleset.Value <string>("version");
}
f.Own = f.Number == game.PlayerFactionNumber;
f.Events = (events ?? Enumerable.Empty <JToken>())
.Select(x => new DbEvent {
GameId = gameId, TurnId = turn.Id, Type = "event", Json = x.ToString()
})
.Concat(
(errors ?? Enumerable.Empty <JToken>())
.Select(x => new DbEvent {
GameId = gameId, TurnId = turn.Id, Type = "error", Json = x.ToString()
})
)
.ToList();
turn.Factions.Add(f);
turn.Events.AddRange(f.Events);
var orders = (ordersTemplate["units"] as JArray)
.ToDictionary(k => k.Value <int>("unit"), v => v.Value <string>("orders"));
foreach (JObject region in regions)
{
var coords = region["coords"] as JObject;
var r = new DbRegion
{
GameId = gameId,
TurnId = turn.Id,
UpdatedAtTurn = turn.Number,
X = coords.Value <int>("x"),
Y = coords.Value <int>("y"),
Z = coords.TryGetValue("z", StringComparison.OrdinalIgnoreCase, out var zCoord)
? zCoord.Value <int>()
: 1,
Label = coords.TryGetValue("label", StringComparison.OrdinalIgnoreCase, out var label)
? label.Value <string>()
: "surface",
Province = region.Value <string>("province"),
Terrain = region.Value <string>("terrain"),
Structures = new List <DbStructure>(),
Units = new List <DbUnit>()
};
r.Memory = regionMemory.TryGetValue(r.EmpheralId, out var regMem) ? regMem : null;
var units = region["units"] as JArray;
if (units != null)
{
AddUnits(game, turn, units, r, null, unitMemory, orders);
}
var structures = region["structures"] as JArray;
if (structures != null)
{
AddStructures(game, turn, structures, r, structuresMemory, unitMemory, orders);
}
region.Remove("units");
region.Remove("structures");
r.Json = region.ToString();
turn.Regions.Add(r);
}
if (game.PlayerFactionNumber == ordersTemplate.Value <int>("faction"))
{
game.Password = ordersTemplate.Value <string>("password");
}
// copy missing regions from previous turn
if (lastTurn != null)
{
CopyInvisibleRegions(gameId, turn, lastTurn, game);
}
await db.SaveChangesAsync();
}