public void UpdateRecviveCoper()
{
MasterMember Master = this.MasterList.Find(m => m.IsMaster == true);
if (Master != null)
{
Program.DatabaseManager.GetClient().ExecuteQuery("UPDATE character SET ReviveCoper=" + RecviveCoperMaster + " WHERE CharID =" + Master.CharID + "");
}
}
public static MasterMember LoadFromDatabase(DataRow row)
{
MasterMember Member = new MasterMember
{
pMemberName = row["MemberName"].ToString(),
CharID = GetDataTypes.GetInt(row["CharID"]),
Level = GetDataTypes.GetByte(row["Level"]),
IsMaster = GetDataTypes.GetBool(row["isMaster"]),
MasterID = GetDataTypes.GetInt(row["MasterID"]),
RegisterDate = DateTime.ParseExact(row["RegisterDate"].ToString(), "dd.MM.yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture),
};
Member.pMember = ClientManager.Instance.GetClientByCharname(Member.pMemberName);
Member.IsOnline = ClientManager.Instance.IsOnline(Member.pMemberName);
return(Member);
}
public void LoadMasterList()
{
DataTable Masterdata = null;
using (DatabaseClient dbClient = Program.DatabaseManager.GetClient())
{
Masterdata = dbClient.ReadDataTable("SELECT * FROM Masters WHERE CharID='" + this.ID + "'");
}
if (Masterdata != null)
{
foreach (DataRow row in Masterdata.Rows)
{
MasterMember DBMember = MasterMember.LoadFromDatabase(row);
this.MasterList.Add(DBMember);
if (DBMember.IsOnline)
{
DBMember.SetMemberStatus(true, this.Client.Character.Character.Name);
}
}
}
}