/// <summary>
///
/// </summary>
private static void SQL_ReloadAccount(ExecuteInfoNull sqlInfo)
{
s_UnitOfWork.ReloadChangedObjects();
XPQuery <Account> accounts = new XPQuery <Account>(s_UnitOfWork);
var accountList = from account in accounts
select account;
// 账号是不会删除的，人物会删除，所以只需要添加即可。
foreach (Account account in accountList)
{
WowAccount wowAccount = new WowAccount();
wowAccount.AccountGuid = account.Oid;
wowAccount.AccountName = account.AccountName.ToUpper();
wowAccount.Password = account.Password;
wowAccount.Locked = account.IsLocked;
wowAccount.Banned = account.IsBanned;
wowAccount.AccessLevel = (AccessLevel)account.GMLevel;
wowAccount.IsTBC = account.IsTBC;
s_WowAccountManager.Add(wowAccount.AccountName, wowAccount);
}
LOGs.WriteLine(LogMessageType.MSG_INFO, "Wow帐号：读取数据库内的 Wow 帐号完成");
}
/// <summary>
///
/// </summary>
private void SQL_LoadGlobalPickpocketing(ExecuteInfoNull sqlInfo)
{
//XPQuery<> mails = new XPQuery<>( OneDatabase.Session );
//var mailList = from mail in mails
// select mail;
//foreach ( mail in mailList )
//{
// //WowCreature wowPlayerInfo = new WowCreature();
// //wowPlayerInfo.Name = creature.N;
// //wowPlayerInfo.Serial = creature.AccountGuid;
// //wowPlayerInfo.Password = creature.Password;
// //wowPlayerInfo.Locked = creature.IsLocked;
// //wowPlayerInfo.Banned = creature.IsBanned;
// //m_Glob.AddPlayerInfo( wowPlayerInfo.Name, wowPlayerInfo );
//}
LOGs.WriteLine(LogMessageType.MSG_INFO, "WOW帐号：读取数据库内全部的 怪物掉落信息 完成");
}
/// <summary>
///
/// </summary>
private void SQL_LoadGlobalCorpseInfo(ExecuteInfoNull sqlInfo)
{
XPQuery <Corpse> corpses = new XPQuery <Corpse>(OneDatabase.Session);
var corpseList = from corpse in corpses
select corpse;
foreach (Corpse corpse in corpseList)
{
//WowCreature wowPlayerInfo = new WowCreature();
//wowPlayerInfo.Name = creature.N;
//wowPlayerInfo.Serial = creature.AccountGuid;
//wowPlayerInfo.Password = creature.Password;
//wowPlayerInfo.Locked = creature.IsLocked;
//wowPlayerInfo.Banned = creature.IsBanned;
//m_Glob.AddPlayerInfo( wowPlayerInfo.Name, wowPlayerInfo );
}
LOGs.WriteLine(LogMessageType.MSG_INFO, "WOW帐号：读取数据库内全部的 玩家尸体 完成");
}
/// <summary>
///
/// </summary>
private void SQL_LoadGlobalMailInfo(ExecuteInfoNull sqlInfo)
{
XPQuery <Mail> mails = new XPQuery <Mail>(OneDatabase.Session);
var mailList = from mail in mails
select mail;
foreach (Mail mail in mailList)
{
//WowCreature wowPlayerInfo = new WowCreature();
//wowPlayerInfo.Name = creature.N;
//wowPlayerInfo.Serial = creature.AccountGuid;
//wowPlayerInfo.Password = creature.Password;
//wowPlayerInfo.Locked = creature.IsLocked;
//wowPlayerInfo.Banned = creature.IsBanned;
//m_Glob.AddPlayerInfo( wowPlayerInfo.Name, wowPlayerInfo );
}
LOGs.WriteLine(LogMessageType.MSG_INFO, "WOW帐号：读取数据库内全部的 邮件系统 完成");
}
/// <summary>
///
/// </summary>
private void SQL_LoadCreatureRespawn(ExecuteInfoNull sqlInfo)
{
XPQuery <CreatureBase> creatures = new XPQuery <CreatureBase>(OneDatabase.Session);
var creatureList = from creature in creatures
select creature;
foreach (CreatureBase creature in creatureList)
{
WowCreature wowPlayerInfo = new WowCreature();
//wowPlayerInfo.Name = creature.N;
//wowPlayerInfo.Serial = creature.AccountGuid;
//wowPlayerInfo.Password = creature.Password;
//wowPlayerInfo.Locked = creature.IsLocked;
//wowPlayerInfo.Banned = creature.IsBanned;
//m_Glob.AddPlayerInfo( wowPlayerInfo.Name, wowPlayerInfo );
}
LOGs.WriteLine(LogMessageType.MSG_INFO, "WOW帐号：读取数据库内全部的 怪物刷新系统 完成");
}
/// <summary>
///
/// </summary>
private void SQL_LoadGlobalPlayerInfo(ExecuteInfoNull sqlInfo)
{
XPQuery <CharacterBase> characters = new XPQuery <CharacterBase>(OneDatabase.Session);
var characterList = from character in characters
select character;
foreach (CharacterBase character in characterList)
{
WowCharacter wowPlayerInfo = new WowCharacter();
wowPlayerInfo.Serial = character.Oid;
wowPlayerInfo.CharacterGuid = character.Oid;
wowPlayerInfo.Name = character.CharacterName;
wowPlayerInfo.AccountGuid = character.Account.Oid;
wowPlayerInfo.IsBanned = character.IsBanned;
m_GlobalPlayerInfo.AddPlayerInfo(wowPlayerInfo.Name, wowPlayerInfo.Serial, wowPlayerInfo);
}
LOGs.WriteLine(LogMessageType.MSG_INFO, "WOW帐号：读取数据库内全部的 玩家信息 完成");
}
/// <summary>
///
/// </summary>
private static void SQL_ReloadAccount( ExecuteInfoNull sqlInfo )
{
s_UnitOfWork.ReloadChangedObjects();
XPQuery<Account> accounts = new XPQuery<Account>( s_UnitOfWork );
var accountList = from account in accounts
select account;
// 账号是不会删除的，人物会删除，所以只需要添加即可。
foreach ( Account account in accountList )
{
WowAccount wowAccount = new WowAccount();
wowAccount.AccountGuid = account.Oid;
wowAccount.AccountName = account.AccountName.ToUpper();
wowAccount.Password = account.Password;
wowAccount.Locked = account.IsLocked;
wowAccount.Banned = account.IsBanned;
wowAccount.AccessLevel = (AccessLevel)account.GMLevel;
wowAccount.IsTBC = account.IsTBC;
s_WowAccountManager.Add( wowAccount.AccountName, wowAccount );
}
LOGs.WriteLine( LogMessageType.MSG_INFO, "Wow帐号：读取数据库内的 Wow 帐号完成" );
}