public static ACE.Database.Models.Shard.Biota ConvertFromEntityBiota(ACE.Entity.Models.Biota biota, bool includeDatabaseRecordIds = false)
{
var result = new ACE.Database.Models.Shard.Biota();
result.Id = biota.Id;
result.WeenieClassId = biota.WeenieClassId;
result.WeenieType = (int)biota.WeenieType;
if (biota.PropertiesBool != null)
{
foreach (var kvp in biota.PropertiesBool)
{
result.SetProperty(kvp.Key, kvp.Value);
}
}
if (biota.PropertiesDID != null)
{
foreach (var kvp in biota.PropertiesDID)
{
result.SetProperty(kvp.Key, kvp.Value);
}
}
if (biota.PropertiesFloat != null)
{
foreach (var kvp in biota.PropertiesFloat)
{
result.SetProperty(kvp.Key, kvp.Value);
}
}
if (biota.PropertiesIID != null)
{
foreach (var kvp in biota.PropertiesIID)
{
result.SetProperty(kvp.Key, kvp.Value);
}
}
if (biota.PropertiesInt != null)
{
foreach (var kvp in biota.PropertiesInt)
{
result.SetProperty(kvp.Key, kvp.Value);
}
}
if (biota.PropertiesInt64 != null)
{
foreach (var kvp in biota.PropertiesInt64)
{
result.SetProperty(kvp.Key, kvp.Value);
}
}
if (biota.PropertiesString != null)
{
foreach (var kvp in biota.PropertiesString)
{
result.SetProperty(kvp.Key, kvp.Value);
}
}
if (biota.PropertiesPosition != null)
{
foreach (var kvp in biota.PropertiesPosition)
{
var entity = new BiotaPropertiesPosition {
ObjectId = biota.Id, PositionType = (ushort)kvp.Key, ObjCellId = kvp.Value.ObjCellId, OriginX = kvp.Value.PositionX, OriginY = kvp.Value.PositionY, OriginZ = kvp.Value.PositionZ, AnglesW = kvp.Value.RotationW, AnglesX = kvp.Value.RotationX, AnglesY = kvp.Value.RotationY, AnglesZ = kvp.Value.RotationZ
};
result.BiotaPropertiesPosition.Add(entity);
}
}
if (biota.PropertiesSpellBook != null)
{
foreach (var kvp in biota.PropertiesSpellBook)
{
var entity = new BiotaPropertiesSpellBook {
ObjectId = biota.Id, Spell = kvp.Key, Probability = kvp.Value
};
result.BiotaPropertiesSpellBook.Add(entity);
}
}
if (biota.PropertiesAnimPart != null)
{
for (int i = 0; i < biota.PropertiesAnimPart.Count; i++)
{
var value = biota.PropertiesAnimPart[i];
var entity = new BiotaPropertiesAnimPart {
ObjectId = biota.Id, Index = value.Index, AnimationId = value.AnimationId, Order = (byte)i
};
result.BiotaPropertiesAnimPart.Add(entity);
}
}
if (biota.PropertiesPalette != null)
{
for (int i = 0; i < biota.PropertiesPalette.Count; i++)
{
var value = biota.PropertiesPalette[i];
var entity = new BiotaPropertiesPalette {
ObjectId = biota.Id, SubPaletteId = value.SubPaletteId, Offset = value.Offset, Length = value.Length, Order = (byte)i
};
result.BiotaPropertiesPalette.Add(entity);
}
}
if (biota.PropertiesTextureMap != null)
{
for (int i = 0; i < biota.PropertiesTextureMap.Count; i++)
{
var value = biota.PropertiesTextureMap[i];
var entity = new BiotaPropertiesTextureMap {
ObjectId = biota.Id, Index = value.PartIndex, OldId = value.OldTexture, NewId = value.NewTexture, Order = (byte)i
};
result.BiotaPropertiesTextureMap.Add(entity);
}
}
// Properties for all world objects that typically aren't modified over the original weenie
if (biota.PropertiesCreateList != null)
{
foreach (var value in biota.PropertiesCreateList)
{
var entity = new BiotaPropertiesCreateList
{
ObjectId = biota.Id,
DestinationType = (sbyte)value.DestinationType,
WeenieClassId = value.WeenieClassId,
StackSize = value.StackSize,
Palette = value.Palette,
Shade = value.Shade,
TryToBond = value.TryToBond
};
if (includeDatabaseRecordIds)
{
entity.Id = value.DatabaseRecordId;
}
result.BiotaPropertiesCreateList.Add(entity);
}
}
if (biota.PropertiesEmote != null)
{
foreach (var value in biota.PropertiesEmote)
{
var entity = new BiotaPropertiesEmote
{
ObjectId = biota.Id,
Category = (uint)value.Category,
Probability = value.Probability,
WeenieClassId = value.WeenieClassId,
Style = (uint?)value.Style,
Substyle = (uint?)value.Substyle,
Quest = value.Quest,
VendorType = (int?)value.VendorType,
MinHealth = value.MinHealth,
MaxHealth = value.MaxHealth,
};
if (includeDatabaseRecordIds)
{
entity.Id = value.DatabaseRecordId;
}
foreach (var value2 in value.PropertiesEmoteAction)
{
var entity2 = new BiotaPropertiesEmoteAction
{
// EmoteId is a foreign key to Emote.Id.
// If we don't set this to a non-zero number, EF will not auto-set this for us when we add this biota to the database.
// We set it to uint.MaxValue instead of 1 because 1 is more likely to be a valid foreign key. We don't want to enter a valid foreign key.
// We just want to enter a value that forces EF to update the record with the correct foreign key. If this behavior changes in the future and we set it to 1,
// we're more likely to run into an unnoticed issue (because 1 would not throw an exception and uint.MaxValue probably would).
// We put this here instead of in ShardDatabase for efficiency.
// It's possible this might be fixable with a attribute in the Emote or EmoteAction classes.
// It's also possible we don't have the schema defined in a way that helps scaffolding identify the relationship.
// Mag-nus 2018-08-04
EmoteId = uint.MaxValue,
Order = (uint)value.PropertiesEmoteAction.IndexOf(value2),
Type = value2.Type,
Delay = value2.Delay,
Extent = value2.Extent,
Motion = (uint?)value2.Motion,
Message = value2.Message,
TestString = value2.TestString,
Min = value2.Min,
Max = value2.Max,
Min64 = value2.Min64,
Max64 = value2.Max64,
MinDbl = value2.MinDbl,
MaxDbl = value2.MaxDbl,
Stat = value2.Stat,
Display = value2.Display,
Amount = value2.Amount,
Amount64 = value2.Amount64,
HeroXP64 = value2.HeroXP64,
Percent = value2.Percent,
SpellId = value2.SpellId,
WealthRating = value2.WealthRating,
TreasureClass = value2.TreasureClass,
TreasureType = value2.TreasureType,
PScript = (int?)value2.PScript,
Sound = (int?)value2.Sound,
DestinationType = value2.DestinationType,
WeenieClassId = value2.WeenieClassId,
StackSize = value2.StackSize,
Palette = value2.Palette,
Shade = value2.Shade,
TryToBond = value2.TryToBond,
ObjCellId = value2.ObjCellId,
OriginX = value2.OriginX,
OriginY = value2.OriginY,
OriginZ = value2.OriginZ,
AnglesW = value2.AnglesW,
AnglesX = value2.AnglesX,
AnglesY = value2.AnglesY,
AnglesZ = value2.AnglesZ,
};
if (includeDatabaseRecordIds)
{
entity2.Id = value2.DatabaseRecordId;
}
entity.BiotaPropertiesEmoteAction.Add(entity2);
}
result.BiotaPropertiesEmote.Add(entity);
}
}
if (biota.PropertiesEventFilter != null)
{
foreach (var value in biota.PropertiesEventFilter)
{
var entity = new BiotaPropertiesEventFilter {
ObjectId = biota.Id, Event = value
};
result.BiotaPropertiesEventFilter.Add(entity);
}
}
if (biota.PropertiesGenerator != null)
{
foreach (var value in biota.PropertiesGenerator)
{
var entity = new BiotaPropertiesGenerator
{
ObjectId = biota.Id,
Probability = value.Probability,
WeenieClassId = value.WeenieClassId,
Delay = value.Delay,
InitCreate = value.InitCreate,
MaxCreate = value.MaxCreate,
WhenCreate = (uint)value.WhenCreate,
WhereCreate = (uint)value.WhereCreate,
StackSize = value.StackSize,
PaletteId = value.PaletteId,
Shade = value.Shade,
ObjCellId = value.ObjCellId,
OriginX = value.OriginX,
OriginY = value.OriginY,
OriginZ = value.OriginZ,
AnglesW = value.AnglesW,
AnglesX = value.AnglesX,
AnglesY = value.AnglesY,
AnglesZ = value.AnglesZ,
};
if (includeDatabaseRecordIds)
{
entity.Id = value.DatabaseRecordId;
}
result.BiotaPropertiesGenerator.Add(entity);
}
}
// Properties for creatures
if (biota.PropertiesAttribute != null)
{
foreach (var kvp in biota.PropertiesAttribute)
{
var entity = new BiotaPropertiesAttribute {
ObjectId = biota.Id, Type = (ushort)kvp.Key, InitLevel = kvp.Value.InitLevel, LevelFromCP = kvp.Value.LevelFromCP, CPSpent = kvp.Value.CPSpent
};
result.BiotaPropertiesAttribute.Add(entity);
}
}
if (biota.PropertiesAttribute2nd != null)
{
foreach (var kvp in biota.PropertiesAttribute2nd)
{
var entity = new BiotaPropertiesAttribute2nd {
ObjectId = biota.Id, Type = (ushort)kvp.Key, InitLevel = kvp.Value.InitLevel, LevelFromCP = kvp.Value.LevelFromCP, CPSpent = kvp.Value.CPSpent, CurrentLevel = kvp.Value.CurrentLevel
};
result.BiotaPropertiesAttribute2nd.Add(entity);
}
}
if (biota.PropertiesBodyPart != null)
{
foreach (var kvp in biota.PropertiesBodyPart)
{
var entity = new BiotaPropertiesBodyPart
{
ObjectId = biota.Id,
Key = (ushort)kvp.Key,
DType = (int)kvp.Value.DType,
DVal = kvp.Value.DVal,
DVar = kvp.Value.DVar,
BaseArmor = kvp.Value.BaseArmor,
ArmorVsSlash = kvp.Value.ArmorVsSlash,
ArmorVsPierce = kvp.Value.ArmorVsPierce,
ArmorVsBludgeon = kvp.Value.ArmorVsBludgeon,
ArmorVsCold = kvp.Value.ArmorVsCold,
ArmorVsFire = kvp.Value.ArmorVsFire,
ArmorVsAcid = kvp.Value.ArmorVsAcid,
ArmorVsElectric = kvp.Value.ArmorVsElectric,
ArmorVsNether = kvp.Value.ArmorVsNether,
BH = kvp.Value.BH,
HLF = kvp.Value.HLF,
MLF = kvp.Value.MLF,
LLF = kvp.Value.LLF,
HRF = kvp.Value.HRF,
MRF = kvp.Value.MRF,
LRF = kvp.Value.LRF,
HLB = kvp.Value.HLB,
MLB = kvp.Value.MLB,
LLB = kvp.Value.LLB,
HRB = kvp.Value.HRB,
MRB = kvp.Value.MRB,
LRB = kvp.Value.LRB,
};
result.BiotaPropertiesBodyPart.Add(entity);
}
}
if (biota.PropertiesSkill != null)
{
foreach (var kvp in biota.PropertiesSkill)
{
var entity = new BiotaPropertiesSkill
{
ObjectId = biota.Id,
Type = (ushort)kvp.Key,
LevelFromPP = kvp.Value.LevelFromPP,
SAC = (uint)kvp.Value.SAC,
PP = kvp.Value.PP,
InitLevel = kvp.Value.InitLevel,
ResistanceAtLastCheck = kvp.Value.ResistanceAtLastCheck,
LastUsedTime = kvp.Value.LastUsedTime,
};
result.BiotaPropertiesSkill.Add(entity);
}
}
// Properties for books
if (biota.PropertiesBook != null)
{
result.BiotaPropertiesBook = new BiotaPropertiesBook
{
ObjectId = biota.Id,
MaxNumPages = biota.PropertiesBook.MaxNumPages,
MaxNumCharsPerPage = biota.PropertiesBook.MaxNumCharsPerPage
};
}
if (biota.PropertiesBookPageData != null)
{
foreach (var value in biota.PropertiesBookPageData)
{
var entity = new BiotaPropertiesBookPageData
{
ObjectId = biota.Id,
PageId = (uint)biota.PropertiesBookPageData.IndexOf(value),
AuthorId = value.AuthorId,
AuthorName = value.AuthorName,
AuthorAccount = value.AuthorAccount,
IgnoreAuthor = value.IgnoreAuthor,
PageText = value.PageText
};
result.BiotaPropertiesBookPageData.Add(entity);
}
}
// Biota additions over Weenie
if (biota.PropertiesAllegiance != null)
{
foreach (var kvp in biota.PropertiesAllegiance)
{
var entity = new BiotaPropertiesAllegiance {
AllegianceId = biota.Id, CharacterId = kvp.Key, Banned = kvp.Value.Banned, ApprovedVassal = kvp.Value.ApprovedVassal
};
result.BiotaPropertiesAllegiance.Add(entity);
}
}
if (biota.PropertiesEnchantmentRegistry != null)
{
foreach (var value in biota.PropertiesEnchantmentRegistry)
{
var entity = new BiotaPropertiesEnchantmentRegistry
{
ObjectId = biota.Id,
EnchantmentCategory = value.EnchantmentCategory,
SpellId = value.SpellId,
LayerId = value.LayerId,
HasSpellSetId = value.HasSpellSetId,
SpellCategory = (ushort)value.SpellCategory,
PowerLevel = value.PowerLevel,
StartTime = value.StartTime,
Duration = value.Duration,
CasterObjectId = value.CasterObjectId,
DegradeModifier = value.DegradeModifier,
DegradeLimit = value.DegradeLimit,
LastTimeDegraded = value.LastTimeDegraded,
StatModType = (uint)value.StatModType,
StatModKey = value.StatModKey,
StatModValue = value.StatModValue,
SpellSetId = (uint)value.SpellSetId,
};
result.BiotaPropertiesEnchantmentRegistry.Add(entity);
}
}
if (biota.HousePermissions != null)
{
foreach (var kvp in biota.HousePermissions)
{
var entity = new ACE.Database.Models.Shard.HousePermission {
HouseId = biota.Id, PlayerGuid = kvp.Key, Storage = kvp.Value
};
result.HousePermission.Add(entity);
}
}
return(result);
}
private void UpdateBiota(ShardDbContext context, Biota existingBiota, Biota biota)
{
// This pattern is described here: https://docs.microsoft.com/en-us/ef/core/saving/disconnected-entities
// You'll notice though that we're not using the recommended: context.Entry(existingEntry).CurrentValues.SetValues(newEntry);
// It is EXTREMLY slow. 4x or more slower. I suspect because it uses reflection to find the properties that the object contains
// Manually setting the properties like we do below is the best case scenario for performance. However, it also has risks.
// If we add columns to the schema and forget to add those changes here, changes to the biota may not propegate to the database.
// Mag-nus 2018-08-18
context.Entry(existingBiota).CurrentValues.SetValues(biota);
foreach (var value in biota.BiotaPropertiesAnimPart)
{
BiotaPropertiesAnimPart existingValue = (value.Id == 0 ? null : existingBiota.BiotaPropertiesAnimPart.FirstOrDefault(r => r.Id == value.Id));
if (existingValue == null)
{
existingBiota.BiotaPropertiesAnimPart.Add(value);
}
else
{
existingValue.Index = value.Index;
existingValue.AnimationId = value.AnimationId;
existingValue.Order = value.Order;
}
}
foreach (var value in existingBiota.BiotaPropertiesAnimPart)
{
if (!biota.BiotaPropertiesAnimPart.Any(p => p.Id == value.Id))
{
context.BiotaPropertiesAnimPart.Remove(value);
}
}
foreach (var value in biota.BiotaPropertiesAttribute)
{
BiotaPropertiesAttribute existingValue = (value.Id == 0 ? null : existingBiota.BiotaPropertiesAttribute.FirstOrDefault(r => r.Id == value.Id));
if (existingValue == null)
{
existingBiota.BiotaPropertiesAttribute.Add(value);
}
else
{
existingValue.Type = value.Type;
existingValue.InitLevel = value.InitLevel;
existingValue.LevelFromCP = value.LevelFromCP;
existingValue.CPSpent = value.CPSpent;
}
}
foreach (var value in existingBiota.BiotaPropertiesAttribute)
{
if (!biota.BiotaPropertiesAttribute.Any(p => p.Id == value.Id))
{
context.BiotaPropertiesAttribute.Remove(value);
}
}
foreach (var value in biota.BiotaPropertiesAttribute2nd)
{
BiotaPropertiesAttribute2nd existingValue = (value.Id == 0 ? null : existingBiota.BiotaPropertiesAttribute2nd.FirstOrDefault(r => r.Id == value.Id));
if (existingValue == null)
{
existingBiota.BiotaPropertiesAttribute2nd.Add(value);
}
else
{
existingValue.Type = value.Type;
existingValue.InitLevel = value.InitLevel;
existingValue.LevelFromCP = value.LevelFromCP;
existingValue.CPSpent = value.CPSpent;
existingValue.CurrentLevel = value.CurrentLevel;
}
}
foreach (var value in existingBiota.BiotaPropertiesAttribute2nd)
{
if (!biota.BiotaPropertiesAttribute2nd.Any(p => p.Id == value.Id))
{
context.BiotaPropertiesAttribute2nd.Remove(value);
}
}
foreach (var value in biota.BiotaPropertiesBodyPart)
{
BiotaPropertiesBodyPart existingValue = (value.Id == 0 ? null : existingBiota.BiotaPropertiesBodyPart.FirstOrDefault(r => r.Id == value.Id));
if (existingValue == null)
{
existingBiota.BiotaPropertiesBodyPart.Add(value);
}
else
{
existingValue.Key = value.Key;
existingValue.DType = value.DType;
existingValue.DVal = value.DVal;
existingValue.DVar = value.DVar;
existingValue.BaseArmor = value.BaseArmor;
existingValue.ArmorVsSlash = value.ArmorVsSlash;
existingValue.ArmorVsPierce = value.ArmorVsPierce;
existingValue.ArmorVsBludgeon = value.ArmorVsBludgeon;
existingValue.ArmorVsCold = value.ArmorVsCold;
existingValue.ArmorVsFire = value.ArmorVsFire;
existingValue.ArmorVsAcid = value.ArmorVsAcid;
existingValue.ArmorVsElectric = value.ArmorVsElectric;
existingValue.ArmorVsNether = value.ArmorVsNether;
existingValue.BH = value.BH;
existingValue.HLF = value.HLF;
existingValue.MLF = value.MLF;
existingValue.LLF = value.LLF;
existingValue.HRF = value.HRF;
existingValue.MRF = value.MRF;
existingValue.LRF = value.LRF;
existingValue.HLB = value.HLB;
existingValue.MLB = value.MLB;
existingValue.LLB = value.LLB;
existingValue.HRB = value.HRB;
existingValue.MRB = value.MRB;
existingValue.LRB = value.LRB;
}
}
foreach (var value in existingBiota.BiotaPropertiesBodyPart)
{
if (!biota.BiotaPropertiesBodyPart.Any(p => p.Id == value.Id))
{
context.BiotaPropertiesBodyPart.Remove(value);
}
}
if (biota.BiotaPropertiesBook != null)
{
if (existingBiota.BiotaPropertiesBook == null)
{
existingBiota.BiotaPropertiesBook = biota.BiotaPropertiesBook;
}
else
{
existingBiota.BiotaPropertiesBook.MaxNumPages = biota.BiotaPropertiesBook.MaxNumPages;
existingBiota.BiotaPropertiesBook.MaxNumCharsPerPage = biota.BiotaPropertiesBook.MaxNumCharsPerPage;
}
}
else
{
if (existingBiota.BiotaPropertiesBook != null)
{
context.BiotaPropertiesBook.Remove(existingBiota.BiotaPropertiesBook);
}
}
foreach (var value in biota.BiotaPropertiesBookPageData)
{
BiotaPropertiesBookPageData existingValue = (value.Id == 0 ? null : existingBiota.BiotaPropertiesBookPageData.FirstOrDefault(r => r.Id == value.Id));
if (existingValue == null)
{
existingBiota.BiotaPropertiesBookPageData.Add(value);
}
else
{
existingValue.PageId = value.PageId;
existingValue.AuthorId = value.AuthorId;
existingValue.AuthorName = value.AuthorName;
existingValue.AuthorAccount = value.AuthorAccount;
existingValue.IgnoreAuthor = value.IgnoreAuthor;
existingValue.PageText = value.PageText;
}
}
foreach (var value in existingBiota.BiotaPropertiesBookPageData)
{
if (!biota.BiotaPropertiesBookPageData.Any(p => p.Id == value.Id))
{
context.BiotaPropertiesBookPageData.Remove(value);
}
}
foreach (var value in biota.BiotaPropertiesBool)
{
BiotaPropertiesBool existingValue = (value.Id == 0 ? null : existingBiota.BiotaPropertiesBool.FirstOrDefault(r => r.Id == value.Id));
if (existingValue == null)
{
existingBiota.BiotaPropertiesBool.Add(value);
}
else
{
existingValue.Type = value.Type;
existingValue.Value = value.Value;
}
}
foreach (var value in existingBiota.BiotaPropertiesBool)
{
if (!biota.BiotaPropertiesBool.Any(p => p.Id == value.Id))
{
context.BiotaPropertiesBool.Remove(value);
}
}
foreach (var value in biota.BiotaPropertiesCreateList)
{
BiotaPropertiesCreateList existingValue = (value.Id == 0 ? null : existingBiota.BiotaPropertiesCreateList.FirstOrDefault(r => r.Id == value.Id));
if (existingValue == null)
{
existingBiota.BiotaPropertiesCreateList.Add(value);
}
else
{
existingValue.DestinationType = value.DestinationType;
existingValue.WeenieClassId = value.WeenieClassId;
existingValue.StackSize = value.StackSize;
existingValue.Palette = value.Palette;
existingValue.Shade = value.Shade;
existingValue.TryToBond = value.TryToBond;
}
}
foreach (var value in existingBiota.BiotaPropertiesCreateList)
{
if (!biota.BiotaPropertiesCreateList.Any(p => p.Id == value.Id))
{
context.BiotaPropertiesCreateList.Remove(value);
}
}
foreach (var value in biota.BiotaPropertiesDID)
{
BiotaPropertiesDID existingValue = (value.Id == 0 ? null : existingBiota.BiotaPropertiesDID.FirstOrDefault(r => r.Id == value.Id));
if (existingValue == null)
{
existingBiota.BiotaPropertiesDID.Add(value);
}
else
{
existingValue.Type = value.Type;
existingValue.Value = value.Value;
}
}
foreach (var value in existingBiota.BiotaPropertiesDID)
{
if (!biota.BiotaPropertiesDID.Any(p => p.Id == value.Id))
{
context.BiotaPropertiesDID.Remove(value);
}
}
foreach (var value in biota.BiotaPropertiesEmote)
{
BiotaPropertiesEmote existingValue = (value.Id == 0 ? null : existingBiota.BiotaPropertiesEmote.FirstOrDefault(r => r.Id == value.Id));
if (existingValue == null)
{
existingBiota.BiotaPropertiesEmote.Add(value);
}
else
{
existingValue.Category = value.Category;
existingValue.Probability = value.Probability;
existingValue.WeenieClassId = value.WeenieClassId;
existingValue.Style = value.Style;
existingValue.Substyle = value.Substyle;
existingValue.Quest = value.Quest;
existingValue.VendorType = value.VendorType;
existingValue.MinHealth = value.MinHealth;
existingValue.MaxHealth = value.MaxHealth;
foreach (var value2 in value.BiotaPropertiesEmoteAction)
{
BiotaPropertiesEmoteAction existingValue2 = (value2.Id == 0 ? null : existingValue.BiotaPropertiesEmoteAction.FirstOrDefault(r => r.Id == value2.Id));
if (existingValue2 == null)
{
existingValue.BiotaPropertiesEmoteAction.Add(value2);
}
else
{
existingValue2.EmoteId = value2.EmoteId;
existingValue2.Order = value2.Order;
existingValue2.Type = value2.Type;
existingValue2.Delay = value2.Delay;
existingValue2.Extent = value2.Extent;
existingValue2.Motion = value2.Motion;
existingValue2.Message = value2.Message;
existingValue2.TestString = value2.TestString;
existingValue2.Min = value2.Min;
existingValue2.Max = value2.Max;
existingValue2.Min64 = value2.Min64;
existingValue2.Max64 = value2.Max64;
existingValue2.MinDbl = value2.MinDbl;
existingValue2.MaxDbl = value2.MaxDbl;
existingValue2.Stat = value2.Stat;
existingValue2.Display = value2.Display;
existingValue2.Amount = value2.Amount;
existingValue2.Amount64 = value2.Amount64;
existingValue2.HeroXP64 = value2.HeroXP64;
existingValue2.Percent = value2.Percent;
existingValue2.SpellId = value2.SpellId;
existingValue2.WealthRating = value2.WealthRating;
existingValue2.TreasureClass = value2.TreasureClass;
existingValue2.TreasureType = value2.TreasureType;
existingValue2.PScript = value2.PScript;
existingValue2.Sound = value2.Sound;
existingValue2.DestinationType = value2.DestinationType;
existingValue2.WeenieClassId = value2.WeenieClassId;
existingValue2.StackSize = value2.StackSize;
existingValue2.Palette = value2.Palette;
existingValue2.Shade = value2.Shade;
existingValue2.TryToBond = value2.TryToBond;
existingValue2.ObjCellId = value2.ObjCellId;
existingValue2.OriginX = value2.OriginX;
existingValue2.OriginY = value2.OriginY;
existingValue2.OriginZ = value2.OriginZ;
existingValue2.AnglesW = value2.AnglesW;
existingValue2.AnglesX = value2.AnglesX;
existingValue2.AnglesY = value2.AnglesY;
existingValue2.AnglesZ = value2.AnglesZ;
}
}
foreach (var value2 in value.BiotaPropertiesEmoteAction)
{
if (!existingValue.BiotaPropertiesEmoteAction.Any(p => p.Id == value2.Id))
{
context.BiotaPropertiesEmoteAction.Remove(value2);
}
}
}
}
foreach (var value in existingBiota.BiotaPropertiesEmote)
{
if (!biota.BiotaPropertiesEmote.Any(p => p.Id == value.Id))
{
context.BiotaPropertiesEmote.Remove(value);
}
}
foreach (var value in biota.BiotaPropertiesEnchantmentRegistry)
{
BiotaPropertiesEnchantmentRegistry existingValue = (value.ObjectId == 0 ? null : existingBiota.BiotaPropertiesEnchantmentRegistry.FirstOrDefault(r => r.ObjectId == value.ObjectId && r.SpellId == value.SpellId && r.LayerId == value.LayerId && r.CasterObjectId == value.CasterObjectId));
if (existingValue == null)
{
existingBiota.BiotaPropertiesEnchantmentRegistry.Add(value);
}
else
{
existingValue.EnchantmentCategory = value.EnchantmentCategory;
existingValue.SpellId = value.SpellId;
existingValue.LayerId = value.LayerId;
existingValue.HasSpellSetId = value.HasSpellSetId;
existingValue.SpellCategory = value.SpellCategory;
existingValue.PowerLevel = value.PowerLevel;
existingValue.StartTime = value.StartTime;
existingValue.Duration = value.Duration;
existingValue.CasterObjectId = value.CasterObjectId;
existingValue.DegradeModifier = value.DegradeModifier;
existingValue.DegradeLimit = value.DegradeLimit;
existingValue.LastTimeDegraded = value.LastTimeDegraded;
existingValue.StatModType = value.StatModType;
existingValue.StatModKey = value.StatModKey;
existingValue.StatModValue = value.StatModValue;
existingValue.SpellSetId = value.SpellSetId;
}
}
foreach (var value in existingBiota.BiotaPropertiesEnchantmentRegistry)
{
if (!biota.BiotaPropertiesEnchantmentRegistry.Any(p => p.ObjectId == value.ObjectId && p.SpellId == value.SpellId && p.LayerId == value.LayerId && p.CasterObjectId == value.CasterObjectId))
{
context.BiotaPropertiesEnchantmentRegistry.Remove(value);
}
}
foreach (var value in biota.BiotaPropertiesEventFilter)
{
BiotaPropertiesEventFilter existingValue = (value.Id == 0 ? null : existingBiota.BiotaPropertiesEventFilter.FirstOrDefault(r => r.Id == value.Id));
if (existingValue == null)
{
existingBiota.BiotaPropertiesEventFilter.Add(value);
}
else
{
existingValue.Event = value.Event;
}
}
foreach (var value in existingBiota.BiotaPropertiesEventFilter)
{
if (!biota.BiotaPropertiesEventFilter.Any(p => p.Id == value.Id))
{
context.BiotaPropertiesEventFilter.Remove(value);
}
}
foreach (var value in biota.BiotaPropertiesFloat)
{
BiotaPropertiesFloat existingValue = (value.Id == 0 ? null : existingBiota.BiotaPropertiesFloat.FirstOrDefault(r => r.Id == value.Id));
if (existingValue == null)
{
existingBiota.BiotaPropertiesFloat.Add(value);
}
else
{
existingValue.Type = value.Type;
existingValue.Value = value.Value;
}
}
foreach (var value in existingBiota.BiotaPropertiesFloat)
{
if (!biota.BiotaPropertiesFloat.Any(p => p.Id == value.Id))
{
context.BiotaPropertiesFloat.Remove(value);
}
}
foreach (var value in biota.BiotaPropertiesGenerator)
{
BiotaPropertiesGenerator existingValue = (value.Id == 0 ? null : existingBiota.BiotaPropertiesGenerator.FirstOrDefault(r => r.Id == value.Id));
if (existingValue == null)
{
existingBiota.BiotaPropertiesGenerator.Add(value);
}
else
{
existingValue.Probability = value.Probability;
existingValue.WeenieClassId = value.WeenieClassId;
existingValue.Delay = value.Delay;
existingValue.InitCreate = value.InitCreate;
existingValue.MaxCreate = value.MaxCreate;
existingValue.WhenCreate = value.WhenCreate;
existingValue.WhereCreate = value.WhereCreate;
existingValue.StackSize = value.StackSize;
existingValue.PaletteId = value.PaletteId;
existingValue.Shade = value.Shade;
existingValue.ObjCellId = value.ObjCellId;
existingValue.OriginX = value.OriginX;
existingValue.OriginY = value.OriginY;
existingValue.OriginZ = value.OriginZ;
existingValue.AnglesW = value.AnglesW;
existingValue.AnglesX = value.AnglesX;
existingValue.AnglesY = value.AnglesY;
existingValue.AnglesZ = value.AnglesZ;
}
}
foreach (var value in existingBiota.BiotaPropertiesGenerator)
{
if (!biota.BiotaPropertiesGenerator.Any(p => p.Id == value.Id))
{
context.BiotaPropertiesGenerator.Remove(value);
}
}
foreach (var value in biota.BiotaPropertiesIID)
{
BiotaPropertiesIID existingValue = (value.Id == 0 ? null : existingBiota.BiotaPropertiesIID.FirstOrDefault(r => r.Id == value.Id));
if (existingValue == null)
{
existingBiota.BiotaPropertiesIID.Add(value);
}
else
{
existingValue.Type = value.Type;
existingValue.Value = value.Value;
}
}
foreach (var value in existingBiota.BiotaPropertiesIID)
{
if (!biota.BiotaPropertiesIID.Any(p => p.Id == value.Id))
{
context.BiotaPropertiesIID.Remove(value);
}
}
foreach (var value in biota.BiotaPropertiesInt)
{
BiotaPropertiesInt existingValue = (value.Id == 0 ? null : existingBiota.BiotaPropertiesInt.FirstOrDefault(r => r.Id == value.Id));
if (existingValue == null)
{
existingBiota.BiotaPropertiesInt.Add(value);
}
else
{
existingValue.Type = value.Type;
existingValue.Value = value.Value;
}
}
foreach (var value in existingBiota.BiotaPropertiesInt)
{
if (!biota.BiotaPropertiesInt.Any(p => p.Id == value.Id))
{
context.BiotaPropertiesInt.Remove(value);
}
}
foreach (var value in biota.BiotaPropertiesInt64)
{
BiotaPropertiesInt64 existingValue = (value.Id == 0 ? null : existingBiota.BiotaPropertiesInt64.FirstOrDefault(r => r.Id == value.Id));
if (existingValue == null)
{
existingBiota.BiotaPropertiesInt64.Add(value);
}
else
{
existingValue.Type = value.Type;
existingValue.Value = value.Value;
}
}
foreach (var value in existingBiota.BiotaPropertiesInt64)
{
if (!biota.BiotaPropertiesInt64.Any(p => p.Id == value.Id))
{
context.BiotaPropertiesInt64.Remove(value);
}
}
foreach (var value in biota.BiotaPropertiesPalette)
{
BiotaPropertiesPalette existingValue = (value.Id == 0 ? null : existingBiota.BiotaPropertiesPalette.FirstOrDefault(r => r.Id == value.Id));
if (existingValue == null)
{
existingBiota.BiotaPropertiesPalette.Add(value);
}
else
{
existingValue.SubPaletteId = value.SubPaletteId;
existingValue.Offset = value.Offset;
existingValue.Length = value.Length;
}
}
foreach (var value in existingBiota.BiotaPropertiesPalette)
{
if (!biota.BiotaPropertiesPalette.Any(p => p.Id == value.Id))
{
context.BiotaPropertiesPalette.Remove(value);
}
}
foreach (var value in biota.BiotaPropertiesPosition)
{
BiotaPropertiesPosition existingValue = (value.Id == 0 ? null : existingBiota.BiotaPropertiesPosition.FirstOrDefault(r => r.Id == value.Id));
if (existingValue == null)
{
existingBiota.BiotaPropertiesPosition.Add(value);
}
else
{
existingValue.PositionType = value.PositionType;
existingValue.ObjCellId = value.ObjCellId;
existingValue.OriginX = value.OriginX;
existingValue.OriginY = value.OriginY;
existingValue.OriginZ = value.OriginZ;
existingValue.AnglesW = value.AnglesW;
existingValue.AnglesX = value.AnglesX;
existingValue.AnglesY = value.AnglesY;
existingValue.AnglesZ = value.AnglesZ;
}
}
foreach (var value in existingBiota.BiotaPropertiesPosition)
{
if (!biota.BiotaPropertiesPosition.Any(p => p.Id == value.Id))
{
context.BiotaPropertiesPosition.Remove(value);
}
}
foreach (var value in biota.BiotaPropertiesSkill)
{
BiotaPropertiesSkill existingValue = (value.Id == 0 ? null : existingBiota.BiotaPropertiesSkill.FirstOrDefault(r => r.Id == value.Id));
if (existingValue == null)
{
existingBiota.BiotaPropertiesSkill.Add(value);
}
else
{
existingValue.Type = value.Type;
existingValue.LevelFromPP = value.LevelFromPP;
existingValue.SAC = value.SAC;
existingValue.PP = value.PP;
existingValue.InitLevel = value.InitLevel;
existingValue.ResistanceAtLastCheck = value.ResistanceAtLastCheck;
existingValue.LastUsedTime = value.LastUsedTime;
}
}
foreach (var value in existingBiota.BiotaPropertiesSkill)
{
if (!biota.BiotaPropertiesSkill.Any(p => p.Id == value.Id))
{
context.BiotaPropertiesSkill.Remove(value);
}
}
foreach (var value in biota.BiotaPropertiesSpellBook)
{
BiotaPropertiesSpellBook existingValue = (value.Id == 0 ? null : existingBiota.BiotaPropertiesSpellBook.FirstOrDefault(r => r.Id == value.Id));
if (existingValue == null)
{
existingBiota.BiotaPropertiesSpellBook.Add(value);
}
else
{
existingValue.Spell = value.Spell;
existingValue.Probability = value.Probability;
}
}
foreach (var value in existingBiota.BiotaPropertiesSpellBook)
{
if (!biota.BiotaPropertiesSpellBook.Any(p => p.Id == value.Id))
{
context.BiotaPropertiesSpellBook.Remove(value);
}
}
foreach (var value in biota.BiotaPropertiesString)
{
BiotaPropertiesString existingValue = (value.Id == 0 ? null : existingBiota.BiotaPropertiesString.FirstOrDefault(r => r.Id == value.Id));
if (existingValue == null)
{
existingBiota.BiotaPropertiesString.Add(value);
}
else
{
existingValue.Type = value.Type;
existingValue.Value = value.Value;
}
}
foreach (var value in existingBiota.BiotaPropertiesString)
{
if (!biota.BiotaPropertiesString.Any(p => p.Id == value.Id))
{
context.BiotaPropertiesString.Remove(value);
}
}
foreach (var value in biota.BiotaPropertiesTextureMap)
{
BiotaPropertiesTextureMap existingValue = (value.Id == 0 ? null : existingBiota.BiotaPropertiesTextureMap.FirstOrDefault(r => r.Id == value.Id));
if (existingValue == null)
{
existingBiota.BiotaPropertiesTextureMap.Add(value);
}
else
{
existingValue.Index = value.Index;
existingValue.OldId = value.OldId;
existingValue.NewId = value.NewId;
existingValue.Order = value.Order;
}
}
foreach (var value in existingBiota.BiotaPropertiesTextureMap)
{
if (!biota.BiotaPropertiesTextureMap.Any(p => p.Id == value.Id))
{
context.BiotaPropertiesTextureMap.Remove(value);
}
}
foreach (var value in biota.HousePermission)
{
HousePermission existingValue = (value.Id == 0 ? null : existingBiota.HousePermission.FirstOrDefault(r => r.Id == value.Id));
if (existingValue == null)
{
existingBiota.HousePermission.Add(value);
}
else
{
existingValue.PlayerGuid = value.PlayerGuid;
existingValue.Storage = value.Storage;
}
}
foreach (var value in existingBiota.HousePermission)
{
if (!biota.HousePermission.Any(p => p.Id == value.Id))
{
context.HousePermission.Remove(value);
}
}
}
public static void UpdateDatabaseBiota(ShardDbContext context, ACE.Entity.Models.Biota sourceBiota, ACE.Database.Models.Shard.Biota targetBiota)
{
targetBiota.WeenieClassId = sourceBiota.WeenieClassId;
targetBiota.WeenieType = (int)sourceBiota.WeenieType;
if (sourceBiota.PropertiesBool != null)
{
foreach (var kvp in sourceBiota.PropertiesBool)
{
targetBiota.SetProperty(kvp.Key, kvp.Value);
}
}
foreach (var value in targetBiota.BiotaPropertiesBool)
{
if (sourceBiota.PropertiesBool == null || !sourceBiota.PropertiesBool.ContainsKey((PropertyBool)value.Type))
{
context.BiotaPropertiesBool.Remove(value);
}
}
if (sourceBiota.PropertiesDID != null)
{
foreach (var kvp in sourceBiota.PropertiesDID)
{
targetBiota.SetProperty(kvp.Key, kvp.Value);
}
}
foreach (var value in targetBiota.BiotaPropertiesDID)
{
if (sourceBiota.PropertiesDID == null || !sourceBiota.PropertiesDID.ContainsKey((PropertyDataId)value.Type))
{
context.BiotaPropertiesDID.Remove(value);
}
}
if (sourceBiota.PropertiesFloat != null)
{
foreach (var kvp in sourceBiota.PropertiesFloat)
{
targetBiota.SetProperty(kvp.Key, kvp.Value);
}
}
foreach (var value in targetBiota.BiotaPropertiesFloat)
{
if (sourceBiota.PropertiesFloat == null || !sourceBiota.PropertiesFloat.ContainsKey((PropertyFloat)value.Type))
{
context.BiotaPropertiesFloat.Remove(value);
}
}
if (sourceBiota.PropertiesIID != null)
{
foreach (var kvp in sourceBiota.PropertiesIID)
{
targetBiota.SetProperty(kvp.Key, kvp.Value);
}
}
foreach (var value in targetBiota.BiotaPropertiesIID)
{
if (sourceBiota.PropertiesIID == null || !sourceBiota.PropertiesIID.ContainsKey((PropertyInstanceId)value.Type))
{
context.BiotaPropertiesIID.Remove(value);
}
}
if (sourceBiota.PropertiesInt != null)
{
foreach (var kvp in sourceBiota.PropertiesInt)
{
targetBiota.SetProperty(kvp.Key, kvp.Value);
}
}
foreach (var value in targetBiota.BiotaPropertiesInt)
{
if (sourceBiota.PropertiesInt == null || !sourceBiota.PropertiesInt.ContainsKey((PropertyInt)value.Type))
{
context.BiotaPropertiesInt.Remove(value);
}
}
if (sourceBiota.PropertiesInt64 != null)
{
foreach (var kvp in sourceBiota.PropertiesInt64)
{
targetBiota.SetProperty(kvp.Key, kvp.Value);
}
}
foreach (var value in targetBiota.BiotaPropertiesInt64)
{
if (sourceBiota.PropertiesInt64 == null || !sourceBiota.PropertiesInt64.ContainsKey((PropertyInt64)value.Type))
{
context.BiotaPropertiesInt64.Remove(value);
}
}
if (sourceBiota.PropertiesString != null)
{
foreach (var kvp in sourceBiota.PropertiesString)
{
targetBiota.SetProperty(kvp.Key, kvp.Value);
}
}
foreach (var value in targetBiota.BiotaPropertiesString)
{
if (sourceBiota.PropertiesString == null || !sourceBiota.PropertiesString.ContainsKey((PropertyString)value.Type))
{
context.BiotaPropertiesString.Remove(value);
}
}
if (sourceBiota.PropertiesPosition != null)
{
foreach (var kvp in sourceBiota.PropertiesPosition)
{
BiotaPropertiesPosition existingValue = targetBiota.BiotaPropertiesPosition.FirstOrDefault(r => r.PositionType == (ushort)kvp.Key);
if (existingValue == null)
{
existingValue = new BiotaPropertiesPosition {
ObjectId = sourceBiota.Id
};
targetBiota.BiotaPropertiesPosition.Add(existingValue);
}
existingValue.PositionType = (ushort)kvp.Key;
existingValue.ObjCellId = kvp.Value.ObjCellId;
existingValue.OriginX = kvp.Value.PositionX;
existingValue.OriginY = kvp.Value.PositionY;
existingValue.OriginZ = kvp.Value.PositionZ;
existingValue.AnglesW = kvp.Value.RotationW;
existingValue.AnglesX = kvp.Value.RotationX;
existingValue.AnglesY = kvp.Value.RotationY;
existingValue.AnglesZ = kvp.Value.RotationZ;
}
}
foreach (var value in targetBiota.BiotaPropertiesPosition)
{
if (sourceBiota.PropertiesPosition == null || !sourceBiota.PropertiesPosition.ContainsKey((PositionType)value.PositionType))
{
context.BiotaPropertiesPosition.Remove(value);
}
}
if (sourceBiota.PropertiesSpellBook != null)
{
foreach (var kvp in sourceBiota.PropertiesSpellBook)
{
BiotaPropertiesSpellBook existingValue = targetBiota.BiotaPropertiesSpellBook.FirstOrDefault(r => r.Spell == (ushort)kvp.Key);
if (existingValue == null)
{
existingValue = new BiotaPropertiesSpellBook {
ObjectId = sourceBiota.Id
};
targetBiota.BiotaPropertiesSpellBook.Add(existingValue);
}
existingValue.Spell = kvp.Key;
existingValue.Probability = kvp.Value;
}
}
foreach (var value in targetBiota.BiotaPropertiesSpellBook)
{
if (sourceBiota.PropertiesSpellBook == null || !sourceBiota.PropertiesSpellBook.ContainsKey(value.Spell))
{
context.BiotaPropertiesSpellBook.Remove(value);
}
}
if (sourceBiota.PropertiesAnimPart != null)
{
for (int i = 0; i < sourceBiota.PropertiesAnimPart.Count; i++)
{
var value = sourceBiota.PropertiesAnimPart[i];
BiotaPropertiesAnimPart existingValue = targetBiota.BiotaPropertiesAnimPart.FirstOrDefault(r => r.Order == i);
if (existingValue == null)
{
existingValue = new BiotaPropertiesAnimPart {
ObjectId = sourceBiota.Id
};
targetBiota.BiotaPropertiesAnimPart.Add(existingValue);
}
existingValue.Index = value.Index;
existingValue.AnimationId = value.AnimationId;
existingValue.Order = (byte)i;
}
}
foreach (var value in targetBiota.BiotaPropertiesAnimPart)
{
if (sourceBiota.PropertiesAnimPart == null || value.Order == null || value.Order >= sourceBiota.PropertiesAnimPart.Count)
{
context.BiotaPropertiesAnimPart.Remove(value);
}
}
if (sourceBiota.PropertiesPalette != null)
{
foreach (var value in sourceBiota.PropertiesPalette)
{
BiotaPropertiesPalette existingValue = targetBiota.BiotaPropertiesPalette.FirstOrDefault(r => r.SubPaletteId == value.SubPaletteId && r.Offset == value.Offset && r.Length == value.Length);
if (existingValue == null)
{
existingValue = new BiotaPropertiesPalette {
ObjectId = sourceBiota.Id, SubPaletteId = value.SubPaletteId, Offset = value.Offset, Length = value.Length
};
targetBiota.BiotaPropertiesPalette.Add(existingValue);
}
}
}
foreach (var value in targetBiota.BiotaPropertiesPalette)
{
if (sourceBiota.PropertiesPalette == null || !sourceBiota.PropertiesPalette.Any(p => p.SubPaletteId == value.SubPaletteId && p.Offset == value.Offset && p.Length == value.Length))
{
context.BiotaPropertiesPalette.Remove(value);
}
}
if (sourceBiota.PropertiesTextureMap != null)
{
for (int i = 0; i < sourceBiota.PropertiesTextureMap.Count; i++)
{
var value = sourceBiota.PropertiesTextureMap[i];
BiotaPropertiesTextureMap existingValue = targetBiota.BiotaPropertiesTextureMap.FirstOrDefault(r => r.Order == i);
if (existingValue == null)
{
existingValue = new BiotaPropertiesTextureMap {
ObjectId = sourceBiota.Id
};
targetBiota.BiotaPropertiesTextureMap.Add(existingValue);
}
existingValue.Index = value.PartIndex;
existingValue.OldId = value.OldTexture;
existingValue.NewId = value.NewTexture;
existingValue.Order = (byte)i;
}
}
foreach (var value in targetBiota.BiotaPropertiesTextureMap)
{
if (sourceBiota.PropertiesTextureMap == null || value.Order == null || value.Order >= sourceBiota.PropertiesTextureMap.Count)
{
context.BiotaPropertiesTextureMap.Remove(value);
}
}
// Properties for all world objects that typically aren't modified over the original Biota
// This is a cluster... because there is no key per record, just the record id.
// That poses a problem because when we add a new record to be saved, we don't know what the record id is yet.
// It's not until we try to save the record a second time that we will then have the database persisted record (with a valid id), and the entity record (that still has a DatabaseRecordId of 0)
// We then need to match up the record that was saved with it's entity counterpart
var processedSourceCreateList = new HashSet <ACE.Entity.Models.PropertiesCreateList>();
var usedTargetCreateList = new HashSet <BiotaPropertiesCreateList>();
if (sourceBiota.PropertiesCreateList != null)
{
// Process matched up records first
foreach (var value in sourceBiota.PropertiesCreateList)
{
if (value.DatabaseRecordId == 0)
{
continue;
}
// Source record should already exist in the target
BiotaPropertiesCreateList existingValue = targetBiota.BiotaPropertiesCreateList.FirstOrDefault(r => r.Id == value.DatabaseRecordId);
// If the existingValue was not found, the database was likely modified outside of ACE after our last save
if (existingValue == null)
{
continue;
}
CopyValueInto(value, existingValue);
processedSourceCreateList.Add(value);
usedTargetCreateList.Add(existingValue);
}
foreach (var value in sourceBiota.PropertiesCreateList)
{
if (processedSourceCreateList.Contains(value))
{
continue;
}
// For simplicity, just find the first unused target
BiotaPropertiesCreateList existingValue = targetBiota.BiotaPropertiesCreateList.FirstOrDefault(r => !usedTargetCreateList.Contains(r));
if (existingValue == null)
{
existingValue = new BiotaPropertiesCreateList {
ObjectId = sourceBiota.Id
};
targetBiota.BiotaPropertiesCreateList.Add(existingValue);
}
value.DatabaseRecordId = existingValue.Id;
CopyValueInto(value, existingValue);
//processedSourceCreateList.Add(value);
usedTargetCreateList.Add(existingValue);
}
}
foreach (var value in targetBiota.BiotaPropertiesCreateList)
{
if (!usedTargetCreateList.Contains(value))
{
context.BiotaPropertiesCreateList.Remove(value);
}
}
// This is a cluster... because there is no key per record, just the record id.
// That poses a problem because when we add a new record to be saved, we don't know what the record id is yet.
// It's not until we try to save the record a second time that we will then have the database persisted record (with a valid id), and the entity record (that still has a DatabaseRecordId of 0)
// We then need to match up the record that was saved with it's entity counterpart
var emoteMap = new Dictionary <ACE.Entity.Models.PropertiesEmote, BiotaPropertiesEmote>();
if (sourceBiota.PropertiesEmote != null)
{
// Process matched up records first
foreach (var value in sourceBiota.PropertiesEmote)
{
if (value.DatabaseRecordId == 0)
{
continue;
}
// Source record should already exist in the target
BiotaPropertiesEmote existingValue = targetBiota.BiotaPropertiesEmote.FirstOrDefault(r => r.Id == value.DatabaseRecordId);
// If the existingValue was not found, the database was likely modified outside of ACE after our last save
if (existingValue == null)
{
continue;
}
CopyValueInto(value, existingValue);
emoteMap[value] = existingValue;
}
foreach (var value in sourceBiota.PropertiesEmote)
{
if (emoteMap.Keys.Contains(value))
{
continue;
}
// For simplicity, just find the first unused target
BiotaPropertiesEmote existingValue = targetBiota.BiotaPropertiesEmote.FirstOrDefault(r => !emoteMap.Values.Contains(r));
if (existingValue == null)
{
existingValue = new BiotaPropertiesEmote {
ObjectId = sourceBiota.Id
};
targetBiota.BiotaPropertiesEmote.Add(existingValue);
}
value.DatabaseRecordId = existingValue.Id;
CopyValueInto(value, existingValue);
emoteMap[value] = existingValue;
}
}
foreach (var value in targetBiota.BiotaPropertiesEmote)
{
if (!emoteMap.Values.Contains(value))
{
context.BiotaPropertiesEmote.Remove(value);
}
}
// Now process the emote actions
foreach (var kvp in emoteMap)
{
for (int i = 0; i < kvp.Key.PropertiesEmoteAction.Count; i++)
{
BiotaPropertiesEmoteAction existingValue = kvp.Value.BiotaPropertiesEmoteAction.FirstOrDefault(r => r.Order == i);
if (existingValue == null)
{
existingValue = new BiotaPropertiesEmoteAction {
EmoteId = kvp.Value.Id
};
kvp.Value.BiotaPropertiesEmoteAction.Add(existingValue);
}
CopyValueInto(kvp.Key.PropertiesEmoteAction[i], existingValue, (uint)i);
}
foreach (var value in kvp.Value.BiotaPropertiesEmoteAction)
{
if (value.Order >= kvp.Key.PropertiesEmoteAction.Count)
{
context.BiotaPropertiesEmoteAction.Remove(value);
}
}
}
if (sourceBiota.PropertiesEventFilter != null)
{
foreach (var value in sourceBiota.PropertiesEventFilter)
{
BiotaPropertiesEventFilter existingValue = targetBiota.BiotaPropertiesEventFilter.FirstOrDefault(r => r.Event == value);
if (existingValue == null)
{
var entity = new BiotaPropertiesEventFilter {
ObjectId = sourceBiota.Id, Event = value
};
targetBiota.BiotaPropertiesEventFilter.Add(entity);
}
}
}
foreach (var value in targetBiota.BiotaPropertiesEventFilter)
{
if (sourceBiota.PropertiesEventFilter == null || !sourceBiota.PropertiesEventFilter.Any(p => p == value.Event))
{
context.BiotaPropertiesEventFilter.Remove(value);
}
}
// This is a cluster... because there is no key per record, just the record id.
// That poses a problem because when we add a new record to be saved, we don't know what the record id is yet.
// It's not until we try to save the record a second time that we will then have the database persisted record (with a valid id), and the entity record (that still has a DatabaseRecordId of 0)
// We then need to match up the record that was saved with it's entity counterpart
var processedSourceGenerators = new HashSet <ACE.Entity.Models.PropertiesGenerator>();
var usedTargetGenerators = new HashSet <BiotaPropertiesGenerator>();
if (sourceBiota.PropertiesGenerator != null)
{
// Process matched up records first
foreach (var value in sourceBiota.PropertiesGenerator)
{
if (value.DatabaseRecordId == 0)
{
continue;
}
// Source record should already exist in the target
BiotaPropertiesGenerator existingValue = targetBiota.BiotaPropertiesGenerator.FirstOrDefault(r => r.Id == value.DatabaseRecordId);
// If the existingValue was not found, the database was likely modified outside of ACE after our last save
if (existingValue == null)
{
continue;
}
CopyValueInto(value, existingValue);
processedSourceGenerators.Add(value);
usedTargetGenerators.Add(existingValue);
}
foreach (var value in sourceBiota.PropertiesGenerator)
{
if (processedSourceGenerators.Contains(value))
{
continue;
}
// For simplicity, just find the first unused target
BiotaPropertiesGenerator existingValue = targetBiota.BiotaPropertiesGenerator.FirstOrDefault(r => !usedTargetGenerators.Contains(r));
if (existingValue == null)
{
existingValue = new BiotaPropertiesGenerator {
ObjectId = sourceBiota.Id
};
targetBiota.BiotaPropertiesGenerator.Add(existingValue);
}
value.DatabaseRecordId = existingValue.Id;
CopyValueInto(value, existingValue);
//processedSourceGenerators.Add(value);
usedTargetGenerators.Add(existingValue);
}
}
foreach (var value in targetBiota.BiotaPropertiesGenerator)
{
if (!usedTargetGenerators.Contains(value))
{
context.BiotaPropertiesGenerator.Remove(value);
}
}
// Properties for creatures
if (sourceBiota.PropertiesAttribute != null)
{
foreach (var kvp in sourceBiota.PropertiesAttribute)
{
BiotaPropertiesAttribute existingValue = targetBiota.BiotaPropertiesAttribute.FirstOrDefault(r => r.Type == (ushort)kvp.Key);
if (existingValue == null)
{
existingValue = new BiotaPropertiesAttribute {
ObjectId = sourceBiota.Id
};
targetBiota.BiotaPropertiesAttribute.Add(existingValue);
}
existingValue.Type = (ushort)kvp.Key;
existingValue.InitLevel = kvp.Value.InitLevel;
existingValue.LevelFromCP = kvp.Value.LevelFromCP;
existingValue.CPSpent = kvp.Value.CPSpent;
}
}
foreach (var value in targetBiota.BiotaPropertiesAttribute)
{
if (sourceBiota.PropertiesAttribute == null || !sourceBiota.PropertiesAttribute.ContainsKey((PropertyAttribute)value.Type))
{
context.BiotaPropertiesAttribute.Remove(value);
}
}
if (sourceBiota.PropertiesAttribute2nd != null)
{
foreach (var kvp in sourceBiota.PropertiesAttribute2nd)
{
BiotaPropertiesAttribute2nd existingValue = targetBiota.BiotaPropertiesAttribute2nd.FirstOrDefault(r => r.Type == (ushort)kvp.Key);
if (existingValue == null)
{
existingValue = new BiotaPropertiesAttribute2nd {
ObjectId = sourceBiota.Id
};
targetBiota.BiotaPropertiesAttribute2nd.Add(existingValue);
}
existingValue.Type = (ushort)kvp.Key;
existingValue.InitLevel = kvp.Value.InitLevel;
existingValue.LevelFromCP = kvp.Value.LevelFromCP;
existingValue.CPSpent = kvp.Value.CPSpent;
existingValue.CurrentLevel = kvp.Value.CurrentLevel;
}
}
foreach (var value in targetBiota.BiotaPropertiesAttribute2nd)
{
if (sourceBiota.PropertiesAttribute2nd == null || !sourceBiota.PropertiesAttribute2nd.ContainsKey((PropertyAttribute2nd)value.Type))
{
context.BiotaPropertiesAttribute2nd.Remove(value);
}
}
if (sourceBiota.PropertiesBodyPart != null)
{
foreach (var kvp in sourceBiota.PropertiesBodyPart)
{
BiotaPropertiesBodyPart existingValue = targetBiota.BiotaPropertiesBodyPart.FirstOrDefault(r => r.Key == (uint)kvp.Key);
if (existingValue == null)
{
existingValue = new BiotaPropertiesBodyPart {
ObjectId = sourceBiota.Id
};
targetBiota.BiotaPropertiesBodyPart.Add(existingValue);
}
existingValue.Key = (ushort)kvp.Key;
existingValue.DType = (int)kvp.Value.DType;
existingValue.DVal = kvp.Value.DVal;
existingValue.DVar = kvp.Value.DVar;
existingValue.BaseArmor = kvp.Value.BaseArmor;
existingValue.ArmorVsSlash = kvp.Value.ArmorVsSlash;
existingValue.ArmorVsPierce = kvp.Value.ArmorVsPierce;
existingValue.ArmorVsBludgeon = kvp.Value.ArmorVsBludgeon;
existingValue.ArmorVsCold = kvp.Value.ArmorVsCold;
existingValue.ArmorVsFire = kvp.Value.ArmorVsFire;
existingValue.ArmorVsAcid = kvp.Value.ArmorVsAcid;
existingValue.ArmorVsElectric = kvp.Value.ArmorVsElectric;
existingValue.ArmorVsNether = kvp.Value.ArmorVsNether;
existingValue.BH = kvp.Value.BH;
existingValue.HLF = kvp.Value.HLF;
existingValue.MLF = kvp.Value.MLF;
existingValue.LLF = kvp.Value.LLF;
existingValue.HRF = kvp.Value.HRF;
existingValue.MRF = kvp.Value.MRF;
existingValue.LRF = kvp.Value.LRF;
existingValue.HLB = kvp.Value.HLB;
existingValue.MLB = kvp.Value.MLB;
existingValue.LLB = kvp.Value.LLB;
existingValue.HRB = kvp.Value.HRB;
existingValue.MRB = kvp.Value.MRB;
existingValue.LRB = kvp.Value.LRB;
}
}
foreach (var value in targetBiota.BiotaPropertiesBodyPart)
{
if (sourceBiota.PropertiesBodyPart == null || !sourceBiota.PropertiesBodyPart.ContainsKey((CombatBodyPart)value.Key))
{
context.BiotaPropertiesBodyPart.Remove(value);
}
}
if (sourceBiota.PropertiesSkill != null)
{
foreach (var kvp in sourceBiota.PropertiesSkill)
{
BiotaPropertiesSkill existingValue = targetBiota.BiotaPropertiesSkill.FirstOrDefault(r => r.Type == (ushort)kvp.Key);
if (existingValue == null)
{
existingValue = new BiotaPropertiesSkill {
ObjectId = sourceBiota.Id
};
targetBiota.BiotaPropertiesSkill.Add(existingValue);
}
existingValue.Type = (ushort)kvp.Key;
existingValue.LevelFromPP = kvp.Value.LevelFromPP;
existingValue.SAC = (uint)kvp.Value.SAC;
existingValue.PP = kvp.Value.PP;
existingValue.InitLevel = kvp.Value.InitLevel;
existingValue.ResistanceAtLastCheck = kvp.Value.ResistanceAtLastCheck;
existingValue.LastUsedTime = kvp.Value.LastUsedTime;
}
}
foreach (var value in targetBiota.BiotaPropertiesSkill)
{
if (sourceBiota.PropertiesSkill == null || !sourceBiota.PropertiesSkill.ContainsKey((Skill)value.Type))
{
context.BiotaPropertiesSkill.Remove(value);
}
}
// Properties for books
if (sourceBiota.PropertiesBook != null)
{
if (targetBiota.BiotaPropertiesBook == null)
{
targetBiota.BiotaPropertiesBook = new BiotaPropertiesBook {
ObjectId = sourceBiota.Id,
}
}
;
targetBiota.BiotaPropertiesBook.MaxNumPages = sourceBiota.PropertiesBook.MaxNumPages;
targetBiota.BiotaPropertiesBook.MaxNumCharsPerPage = sourceBiota.PropertiesBook.MaxNumCharsPerPage;
}
else
{
if (targetBiota.BiotaPropertiesBook != null)
{
context.BiotaPropertiesBook.Remove(targetBiota.BiotaPropertiesBook);
}
}
if (sourceBiota.PropertiesBookPageData != null)
{
for (int i = 0; i < sourceBiota.PropertiesBookPageData.Count; i++)
{
var value = sourceBiota.PropertiesBookPageData[i];
BiotaPropertiesBookPageData existingValue = targetBiota.BiotaPropertiesBookPageData.FirstOrDefault(r => r.PageId == i);
if (existingValue == null)
{
existingValue = new BiotaPropertiesBookPageData {
ObjectId = sourceBiota.Id
};
targetBiota.BiotaPropertiesBookPageData.Add(existingValue);
}
existingValue.PageId = (uint)i;
existingValue.AuthorId = value.AuthorId;
existingValue.AuthorName = value.AuthorName;
existingValue.AuthorAccount = value.AuthorAccount;
existingValue.IgnoreAuthor = value.IgnoreAuthor;
existingValue.PageText = value.PageText;
}
}
foreach (var value in targetBiota.BiotaPropertiesBookPageData)
{
if (sourceBiota.PropertiesBookPageData == null || value.PageId >= sourceBiota.PropertiesBookPageData.Count)
{
context.BiotaPropertiesBookPageData.Remove(value);
}
}
// Biota additions over Weenie
if (sourceBiota.PropertiesAllegiance != null)
{
foreach (var kvp in sourceBiota.PropertiesAllegiance)
{
BiotaPropertiesAllegiance existingValue = targetBiota.BiotaPropertiesAllegiance.FirstOrDefault(r => r.CharacterId == kvp.Key);
if (existingValue == null)
{
existingValue = new BiotaPropertiesAllegiance {
AllegianceId = sourceBiota.Id
};
targetBiota.BiotaPropertiesAllegiance.Add(existingValue);
}
existingValue.CharacterId = kvp.Key;
existingValue.Banned = kvp.Value.Banned;
existingValue.ApprovedVassal = kvp.Value.ApprovedVassal;
}
}
foreach (var value in targetBiota.BiotaPropertiesAllegiance)
{
if (sourceBiota.PropertiesAllegiance == null || !sourceBiota.PropertiesAllegiance.ContainsKey(value.CharacterId))
{
context.BiotaPropertiesAllegiance.Remove(value);
}
}
if (sourceBiota.PropertiesEnchantmentRegistry != null)
{
foreach (var value in sourceBiota.PropertiesEnchantmentRegistry)
{
BiotaPropertiesEnchantmentRegistry existingValue = targetBiota.BiotaPropertiesEnchantmentRegistry.FirstOrDefault(r => r.SpellId == value.SpellId && r.LayerId == value.LayerId && r.CasterObjectId == value.CasterObjectId);
if (existingValue == null)
{
existingValue = new BiotaPropertiesEnchantmentRegistry {
ObjectId = sourceBiota.Id
};
targetBiota.BiotaPropertiesEnchantmentRegistry.Add(existingValue);
}
existingValue.EnchantmentCategory = value.EnchantmentCategory;
existingValue.SpellId = value.SpellId;
existingValue.LayerId = value.LayerId;
existingValue.HasSpellSetId = value.HasSpellSetId;
existingValue.SpellCategory = (ushort)value.SpellCategory;
existingValue.PowerLevel = value.PowerLevel;
existingValue.StartTime = value.StartTime;
existingValue.Duration = value.Duration;
existingValue.CasterObjectId = value.CasterObjectId;
existingValue.DegradeModifier = value.DegradeModifier;
existingValue.DegradeLimit = value.DegradeLimit;
existingValue.LastTimeDegraded = value.LastTimeDegraded;
existingValue.StatModType = (uint)value.StatModType;
existingValue.StatModKey = value.StatModKey;
existingValue.StatModValue = value.StatModValue;
existingValue.SpellSetId = (uint)value.SpellSetId;
}
}
foreach (var value in targetBiota.BiotaPropertiesEnchantmentRegistry)
{
if (sourceBiota.PropertiesEnchantmentRegistry == null || !sourceBiota.PropertiesEnchantmentRegistry.Any(p => p.SpellId == value.SpellId && p.LayerId == value.LayerId && p.CasterObjectId == value.CasterObjectId))
{
context.BiotaPropertiesEnchantmentRegistry.Remove(value);
}
}
if (sourceBiota.HousePermissions != null)
{
foreach (var kvp in sourceBiota.HousePermissions)
{
HousePermission existingValue = targetBiota.HousePermission.FirstOrDefault(r => r.PlayerGuid == kvp.Key);
if (existingValue == null)
{
existingValue = new HousePermission {
HouseId = sourceBiota.Id
};
targetBiota.HousePermission.Add(existingValue);
}
existingValue.PlayerGuid = kvp.Key;
existingValue.Storage = kvp.Value;
}
}
foreach (var value in targetBiota.HousePermission)
{
if (sourceBiota.HousePermissions == null || !sourceBiota.HousePermissions.ContainsKey(value.PlayerGuid))
{
context.HousePermission.Remove(value);
}
}
}
public static void UpdateDatabaseBiota(ShardDbContext context, ACE.Entity.Models.Biota sourceBiota, ACE.Database.Models.Shard.Biota targetBiota)
{
targetBiota.WeenieClassId = sourceBiota.WeenieClassId;
targetBiota.WeenieType = (int)sourceBiota.WeenieType;
throw new NotImplementedException();
/* Uncomment this when new biota model is used
* if (sourceBiota.PropertiesBool != null)
* {
* foreach (var kvp in sourceBiota.PropertiesBool)
* targetBiota.SetProperty(kvp.Key, kvp.Value);
* }
* foreach (var value in targetBiota.BiotaPropertiesBool)
* {
* if (sourceBiota.PropertiesBool == null || !sourceBiota.PropertiesBool.ContainsKey((PropertyBool)value.Type))
* context.BiotaPropertiesBool.Remove(value);
* }
*
* if (sourceBiota.PropertiesDID != null)
* {
* foreach (var kvp in sourceBiota.PropertiesDID)
* targetBiota.SetProperty(kvp.Key, kvp.Value);
* }
* foreach (var value in targetBiota.BiotaPropertiesDID)
* {
* if (sourceBiota.PropertiesDID == null || !sourceBiota.PropertiesDID.ContainsKey((PropertyDataId)value.Type))
* context.BiotaPropertiesDID.Remove(value);
* }
*
* if (sourceBiota.PropertiesFloat != null)
* {
* foreach (var kvp in sourceBiota.PropertiesFloat)
* targetBiota.SetProperty(kvp.Key, kvp.Value);
* }
* foreach (var value in targetBiota.BiotaPropertiesFloat)
* {
* if (sourceBiota.PropertiesFloat == null || !sourceBiota.PropertiesFloat.ContainsKey((PropertyFloat)value.Type))
* context.BiotaPropertiesFloat.Remove(value);
* }
*
* if (sourceBiota.PropertiesIID != null)
* {
* foreach (var kvp in sourceBiota.PropertiesIID)
* targetBiota.SetProperty(kvp.Key, kvp.Value);
* }
* foreach (var value in targetBiota.BiotaPropertiesIID)
* {
* if (sourceBiota.PropertiesIID == null || !sourceBiota.PropertiesIID.ContainsKey((PropertyInstanceId)value.Type))
* context.BiotaPropertiesIID.Remove(value);
* }
*
* if (sourceBiota.PropertiesInt != null)
* {
* foreach (var kvp in sourceBiota.PropertiesInt)
* targetBiota.SetProperty(kvp.Key, kvp.Value);
* }
* foreach (var value in targetBiota.BiotaPropertiesInt)
* {
* if (sourceBiota.PropertiesInt == null || !sourceBiota.PropertiesInt.ContainsKey((PropertyInt)value.Type))
* context.BiotaPropertiesInt.Remove(value);
* }
*
* if (sourceBiota.PropertiesInt64 != null)
* {
* foreach (var kvp in sourceBiota.PropertiesInt64)
* targetBiota.SetProperty(kvp.Key, kvp.Value);
* }
* foreach (var value in targetBiota.BiotaPropertiesInt64)
* {
* if (sourceBiota.PropertiesInt64 == null || !sourceBiota.PropertiesInt64.ContainsKey((PropertyInt64)value.Type))
* context.BiotaPropertiesInt64.Remove(value);
* }
*
* if (sourceBiota.PropertiesString != null)
* {
* foreach (var kvp in sourceBiota.PropertiesString)
* targetBiota.SetProperty(kvp.Key, kvp.Value);
* }
* foreach (var value in targetBiota.BiotaPropertiesString)
* {
* if (sourceBiota.PropertiesString == null || !sourceBiota.PropertiesString.ContainsKey((PropertyString)value.Type))
* context.BiotaPropertiesString.Remove(value);
* }*/
if (sourceBiota.PropertiesPosition != null)
{
foreach (var kvp in sourceBiota.PropertiesPosition)
{
BiotaPropertiesPosition existingValue = targetBiota.BiotaPropertiesPosition.FirstOrDefault(r => r.PositionType == (ushort)kvp.Key);
if (existingValue == null)
{
existingValue = new BiotaPropertiesPosition {
ObjectId = sourceBiota.Id
};
targetBiota.BiotaPropertiesPosition.Add(existingValue);
}
existingValue.PositionType = (ushort)kvp.Key;
existingValue.ObjCellId = kvp.Value.ObjCellId;
existingValue.OriginX = kvp.Value.PositionX;
existingValue.OriginY = kvp.Value.PositionY;
existingValue.OriginZ = kvp.Value.PositionZ;
existingValue.AnglesW = kvp.Value.RotationW;
existingValue.AnglesX = kvp.Value.RotationX;
existingValue.AnglesY = kvp.Value.RotationY;
existingValue.AnglesZ = kvp.Value.RotationZ;
}
}
foreach (var value in targetBiota.BiotaPropertiesPosition)
{
if (sourceBiota.PropertiesPosition == null || !sourceBiota.PropertiesPosition.ContainsKey((PositionType)value.PositionType))
{
context.BiotaPropertiesPosition.Remove(value);
}
}
if (sourceBiota.PropertiesSpellBook != null)
{
foreach (var kvp in sourceBiota.PropertiesSpellBook)
{
BiotaPropertiesSpellBook existingValue = targetBiota.BiotaPropertiesSpellBook.FirstOrDefault(r => r.Spell == (ushort)kvp.Key);
if (existingValue == null)
{
existingValue = new BiotaPropertiesSpellBook {
ObjectId = sourceBiota.Id
};
targetBiota.BiotaPropertiesSpellBook.Add(existingValue);
}
existingValue.Spell = kvp.Key;
existingValue.Probability = kvp.Value;
}
}
foreach (var value in targetBiota.BiotaPropertiesSpellBook)
{
if (sourceBiota.PropertiesSpellBook == null || !sourceBiota.PropertiesSpellBook.ContainsKey(value.Spell))
{
context.BiotaPropertiesSpellBook.Remove(value);
}
}
if (sourceBiota.PropertiesAnimPart != null)
{
for (int i = 0; i < sourceBiota.PropertiesAnimPart.Count; i++)
{
var value = sourceBiota.PropertiesAnimPart[i];
BiotaPropertiesAnimPart existingValue = targetBiota.BiotaPropertiesAnimPart.FirstOrDefault(r => r.Order == i);
if (existingValue == null)
{
existingValue = new BiotaPropertiesAnimPart {
ObjectId = sourceBiota.Id
};
targetBiota.BiotaPropertiesAnimPart.Add(existingValue);
}
existingValue.Index = value.Index;
existingValue.AnimationId = value.AnimationId;
existingValue.Order = (byte)i;
}
}
foreach (var value in targetBiota.BiotaPropertiesAnimPart)
{
if (sourceBiota.PropertiesAnimPart == null || value.Order >= sourceBiota.PropertiesAnimPart.Count)
{
context.BiotaPropertiesAnimPart.Remove(value);
}
}
if (sourceBiota.PropertiesPalette != null)
{
foreach (var value in sourceBiota.PropertiesPalette)
{
BiotaPropertiesPalette existingValue = targetBiota.BiotaPropertiesPalette.FirstOrDefault(r => r.SubPaletteId == value.SubPaletteId && r.Offset == value.Offset && r.Length == value.Length);
if (existingValue == null)
{
existingValue = new BiotaPropertiesPalette {
ObjectId = sourceBiota.Id, SubPaletteId = value.SubPaletteId, Offset = value.Offset, Length = value.Length
};
targetBiota.BiotaPropertiesPalette.Add(existingValue);
}
}
}
foreach (var value in targetBiota.BiotaPropertiesPalette)
{
if (sourceBiota.PropertiesPalette == null || !sourceBiota.PropertiesPalette.Any(p => p.SubPaletteId == value.SubPaletteId && p.Offset == value.Offset && p.Length == value.Length))
{
context.BiotaPropertiesPalette.Remove(value);
}
}
if (sourceBiota.PropertiesTextureMap != null)
{
for (int i = 0; i < sourceBiota.PropertiesTextureMap.Count; i++)
{
var value = sourceBiota.PropertiesTextureMap[i];
BiotaPropertiesTextureMap existingValue = targetBiota.BiotaPropertiesTextureMap.FirstOrDefault(r => r.Order == i);
if (existingValue == null)
{
existingValue = new BiotaPropertiesTextureMap {
ObjectId = sourceBiota.Id
};
targetBiota.BiotaPropertiesTextureMap.Add(existingValue);
}
existingValue.Index = value.PartIndex;
existingValue.OldId = value.OldTexture;
existingValue.NewId = value.NewTexture;
existingValue.Order = (byte)i;
}
}
foreach (var value in targetBiota.BiotaPropertiesTextureMap)
{
if (sourceBiota.PropertiesTextureMap == null || value.Order >= sourceBiota.PropertiesTextureMap.Count)
{
context.BiotaPropertiesTextureMap.Remove(value);
}
}
// Properties for all world objects that typically aren't modified over the original Biota
/*if (biota.PropertiesCreateList != null)
* {
* foreach (var value in biota.PropertiesCreateList)
* {
* BiotaPropertiesCreateList existingValue = existingBiota.BiotaPropertiesCreateList.FirstOrDefault(r => r.Id == value.Id);
*
* if (existingValue == null)
* existingBiota.BiotaPropertiesCreateList.Add(value);
* else
* {
* existingValue.DestinationType = value.DestinationType;
* existingValue.WeenieClassId = value.WeenieClassId;
* existingValue.StackSize = value.StackSize;
* existingValue.Palette = value.Palette;
* existingValue.Shade = value.Shade;
* existingValue.TryToBond = value.TryToBond;
* }
* }
* }
* foreach (var value in existingBiota.BiotaPropertiesCreateList)
* {
* if (biota.PropertiesCreateList == null || !biota.PropertiesCreateList.Any(p => p.Id == value.Id))
* context.BiotaPropertiesCreateList.Remove(value);
* }*/
/*if (biota.PropertiesEmote != null)
* {
* foreach (var value in biota.PropertiesEmote)
* {
* BiotaPropertiesEmote existingValue = existingBiota.BiotaPropertiesEmote.FirstOrDefault(r => r.Id == value.Id);
*
* if (existingValue == null)
* existingBiota.BiotaPropertiesEmote.Add(value);
* else
* {
* existingValue.Category = value.Category;
* existingValue.Probability = value.Probability;
* existingValue.WeenieClassId = value.WeenieClassId;
* existingValue.Style = value.Style;
* existingValue.Substyle = value.Substyle;
* existingValue.Quest = value.Quest;
* existingValue.VendorType = value.VendorType;
* existingValue.MinHealth = value.MinHealth;
* existingValue.MaxHealth = value.MaxHealth;
*
* foreach (var value2 in value.PropertiesEmoteAction)
* {
* BiotaPropertiesEmoteAction existingValue2 = existingValue.BiotaPropertiesEmoteAction.FirstOrDefault(r => r.Id == value2.Id);
*
* if (existingValue2 == null)
* existingValue.BiotaPropertiesEmoteAction.Add(value2);
* else
* {
* //existingValue2.EmoteId = value2.EmoteId;
* existingValue2.Order = (uint)value.PropertiesEmoteAction.IndexOf(value2);
* existingValue2.Type = value2.Type;
* existingValue2.Delay = value2.Delay;
* existingValue2.Extent = value2.Extent;
* existingValue2.Motion = value2.Motion;
* existingValue2.Message = value2.Message;
* existingValue2.TestString = value2.TestString;
* existingValue2.Min = value2.Min;
* existingValue2.Max = value2.Max;
* existingValue2.Min64 = value2.Min64;
* existingValue2.Max64 = value2.Max64;
* existingValue2.MinDbl = value2.MinDbl;
* existingValue2.MaxDbl = value2.MaxDbl;
* existingValue2.Stat = value2.Stat;
* existingValue2.Display = value2.Display;
* existingValue2.Amount = value2.Amount;
* existingValue2.Amount64 = value2.Amount64;
* existingValue2.HeroXP64 = value2.HeroXP64;
* existingValue2.Percent = value2.Percent;
* existingValue2.SpellId = value2.SpellId;
* existingValue2.WealthRating = value2.WealthRating;
* existingValue2.TreasureClass = value2.TreasureClass;
* existingValue2.TreasureType = value2.TreasureType;
* existingValue2.PScript = value2.PScript;
* existingValue2.Sound = value2.Sound;
* existingValue2.DestinationType = value2.DestinationType;
* existingValue2.WeenieClassId = value2.WeenieClassId;
* existingValue2.StackSize = value2.StackSize;
* existingValue2.Palette = value2.Palette;
* existingValue2.Shade = value2.Shade;
* existingValue2.TryToBond = value2.TryToBond;
* existingValue2.ObjCellId = value2.ObjCellId;
* existingValue2.OriginX = value2.OriginX;
* existingValue2.OriginY = value2.OriginY;
* existingValue2.OriginZ = value2.OriginZ;
* existingValue2.AnglesW = value2.AnglesW;
* existingValue2.AnglesX = value2.AnglesX;
* existingValue2.AnglesY = value2.AnglesY;
* existingValue2.AnglesZ = value2.AnglesZ;
* }
* }
* foreach (var value2 in value.PropertiesEmoteAction)
* {
* if (!existingValue.BiotaPropertiesEmoteAction.Any(p => p.Id == value2.Id))
* context.BiotaPropertiesEmoteAction.Remove(value2);
* }
* }
* }
* }
* foreach (var value in existingBiota.BiotaPropertiesEmote)
* {
* if (biota.PropertiesEmote == null || !biota.PropertiesEmote.Any(p => p.Id == value.Id))
* context.BiotaPropertiesEmote.Remove(value);
* }*/
if (sourceBiota.PropertiesEventFilter != null)
{
foreach (var value in sourceBiota.PropertiesEventFilter)
{
BiotaPropertiesEventFilter existingValue = targetBiota.BiotaPropertiesEventFilter.FirstOrDefault(r => r.Event == value);
if (existingValue == null)
{
var entity = new BiotaPropertiesEventFilter {
ObjectId = sourceBiota.Id, Event = value
};
targetBiota.BiotaPropertiesEventFilter.Add(entity);
}
}
}
foreach (var value in targetBiota.BiotaPropertiesEventFilter)
{
if (sourceBiota.PropertiesEventFilter == null || !sourceBiota.PropertiesEventFilter.Any(p => p == value.Event))
{
context.BiotaPropertiesEventFilter.Remove(value);
}
}
/*if (biota.PropertiesGenerator != null)
* {
* foreach (var value in biota.PropertiesGenerator)
* {
* BiotaPropertiesGenerator existingValue = existingBiota.BiotaPropertiesGenerator.FirstOrDefault(r => r.Id == value.Id);
*
* if (existingValue == null)
* existingBiota.BiotaPropertiesGenerator.Add(value);
* else
* {
* existingValue.Probability = value.Probability;
* existingValue.WeenieClassId = value.WeenieClassId;
* existingValue.Delay = value.Delay;
* existingValue.InitCreate = value.InitCreate;
* existingValue.MaxCreate = value.MaxCreate;
* existingValue.WhenCreate = value.WhenCreate;
* existingValue.WhereCreate = value.WhereCreate;
* existingValue.StackSize = value.StackSize;
* existingValue.PaletteId = value.PaletteId;
* existingValue.Shade = value.Shade;
* existingValue.ObjCellId = value.ObjCellId;
* existingValue.OriginX = value.OriginX;
* existingValue.OriginY = value.OriginY;
* existingValue.OriginZ = value.OriginZ;
* existingValue.AnglesW = value.AnglesW;
* existingValue.AnglesX = value.AnglesX;
* existingValue.AnglesY = value.AnglesY;
* existingValue.AnglesZ = value.AnglesZ;
* }
* }
* }
* foreach (var value in existingBiota.BiotaPropertiesGenerator)
* {
* if (biota.PropertiesGenerator == null || !biota.PropertiesGenerator.Any(p => p.Id == value.Id))
* context.BiotaPropertiesGenerator.Remove(value);
* }*/
// Properties for creatures
if (sourceBiota.PropertiesAttribute != null)
{
foreach (var kvp in sourceBiota.PropertiesAttribute)
{
BiotaPropertiesAttribute existingValue = targetBiota.BiotaPropertiesAttribute.FirstOrDefault(r => r.Type == (ushort)kvp.Key);
if (existingValue == null)
{
existingValue = new BiotaPropertiesAttribute {
ObjectId = sourceBiota.Id
};
targetBiota.BiotaPropertiesAttribute.Add(existingValue);
}
existingValue.Type = (ushort)kvp.Key;
existingValue.InitLevel = kvp.Value.InitLevel;
existingValue.LevelFromCP = kvp.Value.LevelFromCP;
existingValue.CPSpent = kvp.Value.CPSpent;
}
}
foreach (var value in targetBiota.BiotaPropertiesAttribute)
{
if (sourceBiota.PropertiesAttribute == null || !sourceBiota.PropertiesAttribute.ContainsKey((PropertyAttribute)value.Type))
{
context.BiotaPropertiesAttribute.Remove(value);
}
}
if (sourceBiota.PropertiesAttribute2nd != null)
{
foreach (var kvp in sourceBiota.PropertiesAttribute2nd)
{
BiotaPropertiesAttribute2nd existingValue = targetBiota.BiotaPropertiesAttribute2nd.FirstOrDefault(r => r.Type == (ushort)kvp.Key);
if (existingValue == null)
{
existingValue = new BiotaPropertiesAttribute2nd {
ObjectId = sourceBiota.Id
};
targetBiota.BiotaPropertiesAttribute2nd.Add(existingValue);
}
existingValue.Type = (ushort)kvp.Key;
existingValue.InitLevel = kvp.Value.InitLevel;
existingValue.LevelFromCP = kvp.Value.LevelFromCP;
existingValue.CPSpent = kvp.Value.CPSpent;
existingValue.CurrentLevel = kvp.Value.CurrentLevel;
}
}
foreach (var value in targetBiota.BiotaPropertiesAttribute2nd)
{
if (sourceBiota.PropertiesAttribute2nd == null || !sourceBiota.PropertiesAttribute2nd.ContainsKey((PropertyAttribute2nd)value.Type))
{
context.BiotaPropertiesAttribute2nd.Remove(value);
}
}
if (sourceBiota.PropertiesBodyPart != null)
{
foreach (var kvp in sourceBiota.PropertiesBodyPart)
{
BiotaPropertiesBodyPart existingValue = targetBiota.BiotaPropertiesBodyPart.FirstOrDefault(r => r.Key == (uint)kvp.Key);
if (existingValue == null)
{
existingValue = new BiotaPropertiesBodyPart {
ObjectId = sourceBiota.Id
};
targetBiota.BiotaPropertiesBodyPart.Add(existingValue);
}
existingValue.Key = (ushort)kvp.Key;
existingValue.DType = (int)kvp.Value.DType;
existingValue.DVal = kvp.Value.DVal;
existingValue.DVar = kvp.Value.DVar;
existingValue.BaseArmor = kvp.Value.BaseArmor;
existingValue.ArmorVsSlash = kvp.Value.ArmorVsSlash;
existingValue.ArmorVsPierce = kvp.Value.ArmorVsPierce;
existingValue.ArmorVsBludgeon = kvp.Value.ArmorVsBludgeon;
existingValue.ArmorVsCold = kvp.Value.ArmorVsCold;
existingValue.ArmorVsFire = kvp.Value.ArmorVsFire;
existingValue.ArmorVsAcid = kvp.Value.ArmorVsAcid;
existingValue.ArmorVsElectric = kvp.Value.ArmorVsElectric;
existingValue.ArmorVsNether = kvp.Value.ArmorVsNether;
existingValue.BH = kvp.Value.BH;
existingValue.HLF = kvp.Value.HLF;
existingValue.MLF = kvp.Value.MLF;
existingValue.LLF = kvp.Value.LLF;
existingValue.HRF = kvp.Value.HRF;
existingValue.MRF = kvp.Value.MRF;
existingValue.LRF = kvp.Value.LRF;
existingValue.HLB = kvp.Value.HLB;
existingValue.MLB = kvp.Value.MLB;
existingValue.LLB = kvp.Value.LLB;
existingValue.HRB = kvp.Value.HRB;
existingValue.MRB = kvp.Value.MRB;
existingValue.LRB = kvp.Value.LRB;
}
}
foreach (var value in targetBiota.BiotaPropertiesBodyPart)
{
if (sourceBiota.PropertiesBodyPart == null || !sourceBiota.PropertiesBodyPart.ContainsKey((CombatBodyPart)value.Key))
{
context.BiotaPropertiesBodyPart.Remove(value);
}
}
if (sourceBiota.PropertiesSkill != null)
{
foreach (var kvp in sourceBiota.PropertiesSkill)
{
BiotaPropertiesSkill existingValue = targetBiota.BiotaPropertiesSkill.FirstOrDefault(r => r.Type == (ushort)kvp.Key);
if (existingValue == null)
{
existingValue = new BiotaPropertiesSkill {
ObjectId = sourceBiota.Id
};
targetBiota.BiotaPropertiesSkill.Add(existingValue);
}
existingValue.Type = (ushort)kvp.Key;
existingValue.LevelFromPP = kvp.Value.LevelFromPP;
existingValue.SAC = (uint)kvp.Value.SAC;
existingValue.PP = kvp.Value.PP;
existingValue.InitLevel = kvp.Value.InitLevel;
existingValue.ResistanceAtLastCheck = kvp.Value.ResistanceAtLastCheck;
existingValue.LastUsedTime = kvp.Value.LastUsedTime;
}
}
foreach (var value in targetBiota.BiotaPropertiesSkill)
{
if (sourceBiota.PropertiesSkill == null || !sourceBiota.PropertiesSkill.ContainsKey((Skill)value.Type))
{
context.BiotaPropertiesSkill.Remove(value);
}
}
// Properties for books
if (sourceBiota.PropertiesBook != null)
{
if (targetBiota.BiotaPropertiesBook == null)
{
targetBiota.BiotaPropertiesBook = new BiotaPropertiesBook {
ObjectId = sourceBiota.Id,
}
}
;
targetBiota.BiotaPropertiesBook.MaxNumPages = sourceBiota.PropertiesBook.MaxNumPages;
targetBiota.BiotaPropertiesBook.MaxNumCharsPerPage = sourceBiota.PropertiesBook.MaxNumCharsPerPage;
}
else
{
if (targetBiota.BiotaPropertiesBook != null)
{
context.BiotaPropertiesBook.Remove(targetBiota.BiotaPropertiesBook);
}
}
if (sourceBiota.PropertiesBookPageData != null)
{
for (int i = 0; i < sourceBiota.PropertiesBookPageData.Count; i++)
{
var value = sourceBiota.PropertiesBookPageData[i];
BiotaPropertiesBookPageData existingValue = targetBiota.BiotaPropertiesBookPageData.FirstOrDefault(r => r.PageId == i);
if (existingValue == null)
{
existingValue = new BiotaPropertiesBookPageData {
ObjectId = sourceBiota.Id
};
targetBiota.BiotaPropertiesBookPageData.Add(existingValue);
}
existingValue.PageId = (uint)i;
existingValue.AuthorId = value.AuthorId;
existingValue.AuthorName = value.AuthorName;
existingValue.AuthorAccount = value.AuthorAccount;
existingValue.IgnoreAuthor = value.IgnoreAuthor;
existingValue.PageText = value.PageText;
}
}
foreach (var value in targetBiota.BiotaPropertiesBookPageData)
{
if (sourceBiota.PropertiesBookPageData == null || value.PageId >= sourceBiota.PropertiesBookPageData.Count)
{
context.BiotaPropertiesBookPageData.Remove(value);
}
}
// Biota additions over Weenie
if (sourceBiota.PropertiesAllegiance != null)
{
foreach (var kvp in sourceBiota.PropertiesAllegiance)
{
BiotaPropertiesAllegiance existingValue = targetBiota.BiotaPropertiesAllegiance.FirstOrDefault(r => r.CharacterId == kvp.Key);
if (existingValue == null)
{
existingValue = new BiotaPropertiesAllegiance {
AllegianceId = sourceBiota.Id
};
targetBiota.BiotaPropertiesAllegiance.Add(existingValue);
}
existingValue.CharacterId = kvp.Key;
existingValue.Banned = kvp.Value.Banned;
existingValue.ApprovedVassal = kvp.Value.ApprovedVassal;
}
}
foreach (var value in targetBiota.BiotaPropertiesAllegiance)
{
if (sourceBiota.PropertiesAllegiance == null || !sourceBiota.PropertiesAllegiance.ContainsKey(value.CharacterId))
{
context.BiotaPropertiesAllegiance.Remove(value);
}
}
if (sourceBiota.PropertiesEnchantmentRegistry != null)
{
foreach (var value in sourceBiota.PropertiesEnchantmentRegistry)
{
BiotaPropertiesEnchantmentRegistry existingValue = targetBiota.BiotaPropertiesEnchantmentRegistry.FirstOrDefault(r => r.SpellId == value.SpellId && r.LayerId == value.LayerId && r.CasterObjectId == value.CasterObjectId);
if (existingValue == null)
{
existingValue = new BiotaPropertiesEnchantmentRegistry {
ObjectId = sourceBiota.Id
};
targetBiota.BiotaPropertiesEnchantmentRegistry.Add(existingValue);
}
existingValue.EnchantmentCategory = value.EnchantmentCategory;
existingValue.SpellId = value.SpellId;
existingValue.LayerId = value.LayerId;
existingValue.HasSpellSetId = value.HasSpellSetId;
existingValue.SpellCategory = (ushort)value.SpellCategory;
existingValue.PowerLevel = value.PowerLevel;
existingValue.StartTime = value.StartTime;
existingValue.Duration = value.Duration;
existingValue.CasterObjectId = value.CasterObjectId;
existingValue.DegradeModifier = value.DegradeModifier;
existingValue.DegradeLimit = value.DegradeLimit;
existingValue.LastTimeDegraded = value.LastTimeDegraded;
existingValue.StatModType = (uint)value.StatModType;
existingValue.StatModKey = value.StatModKey;
existingValue.StatModValue = value.StatModValue;
existingValue.SpellSetId = (uint)value.SpellSetId;
}
}
foreach (var value in targetBiota.BiotaPropertiesEnchantmentRegistry)
{
if (sourceBiota.PropertiesEnchantmentRegistry == null || !sourceBiota.PropertiesEnchantmentRegistry.Any(p => p.SpellId == value.SpellId && p.LayerId == value.LayerId && p.CasterObjectId == value.CasterObjectId))
{
context.BiotaPropertiesEnchantmentRegistry.Remove(value);
}
}
if (sourceBiota.HousePermissions != null)
{
foreach (var kvp in sourceBiota.HousePermissions)
{
HousePermission existingValue = targetBiota.HousePermission.FirstOrDefault(r => r.PlayerGuid == kvp.Key);
if (existingValue == null)
{
existingValue = new HousePermission {
HouseId = sourceBiota.Id
};
targetBiota.HousePermission.Add(existingValue);
}
existingValue.PlayerGuid = kvp.Key;
existingValue.Storage = kvp.Value;
}
}
foreach (var value in targetBiota.HousePermission)
{
if (sourceBiota.HousePermissions == null || !sourceBiota.HousePermissions.ContainsKey(value.PlayerGuid))
{
context.HousePermission.Remove(value);
}
}
}
}