public static void AddSpouse(Entities.GameClient client1, Entities.GameClient client2)
{
client1.SpouseDatabaseUID = client2.DatabaseUID;
client2.SpouseDatabaseUID = client1.DatabaseUID;
using (var sql = new SqlHandler(Program.Config.ReadString("GameConnectionString")))
{
using (var cmd = new SqlCommandBuilder(sql, SqlCommandType.UPDATE, true))
{
cmd.AddWhereValue("PlayerID", client1.DatabaseUID);
cmd.AddUpdateValue("PlayerSpouseID", client2.DatabaseUID);
cmd.Finish("DB_Players");
}
sql.Execute();
sql.Forward(Program.Config.ReadString("GameConnectionString"), "");
using (var cmd = new SqlCommandBuilder(sql, SqlCommandType.UPDATE, true))
{
cmd.AddWhereValue("PlayerID", client2.DatabaseUID);
cmd.AddUpdateValue("PlayerSpouseID", client1.DatabaseUID);
cmd.Finish("DB_Players");
}
sql.Execute();
}
}
