public static void LoadFromSystemDB(MieSystemDB systemDB, MieCharacterAttributeFile charAttr)
{
SQLiteCommand command = systemDB.Connection.CreateCommand();
command.CommandText = @"SELECT * FROM CharacterAttributes;";
using (SQLiteDataReader sdr = command.ExecuteReader())
{
while (sdr.Read() == true)
{
var byteID = (byte[])sdr["ID"];
var name = (string)sdr["Name"];
var intGender = (long)sdr["Gender"];
var byteSpeakerID = (byte[])sdr["SpeakerID"];
var byteRaceID = (byte[])sdr["RaceID"];
Guid id = new Guid(byteID);
Guid speakerID = new Guid(byteSpeakerID);
Guid raceID = new Guid(byteRaceID);
MieCharacterAttributeFile.NGender gender =
(MieCharacterAttributeFile.NGender)Enum.ToObject(typeof(MieCharacterAttributeFile.NGender), intGender);
MieCharacterAttributeEntry charEntry = new MieCharacterAttributeEntry(id, name, gender, speakerID, raceID);
charAttr.AddCharacterAttributeEntry(charEntry);
}
}
}
public MieCharacterAttributeEntry(Guid id, string name, MieCharacterAttributeFile.NGender gender, Guid speakerID, Guid race)
{
this.ID = id;
this.Name = name;
this.Gender = gender;
this.SpeakerID = speakerID;
this.RaceID = race;
}
public MieSpeakerAttributeEntry(Guid id, string name, MieCharacterAttributeFile.NGender gender)
{
this.ID = id;
this.Name = name;
this.Gender = gender;
}
