/// <summary>
///
/// </summary>
private static void SQL_HandleCharLogin( CharLoginSQL sqlInfo )
{
//////////////////////////////////////////////////////////////////////////
// 读取人物基础信息(CharacterBase)
// 读取人物状态信息(CharacterBase)
// 读取道具信息(CharacterItem)
// 读取技能信息(CharacterSkill)
// 读取法术信息(CharacterSpell)
// 读取天赋信息(CharactersGift)
// 读取宠物信息(CharacterPet)
// 读取探索信息(CharacterExplore)
// 读取声望信息(CharacterReputation)
// 读取邮件信息(Mail)
// 读取飞行点信息(CharactersTaxi)
// 读取快捷按钮信息(CharacterActionBar)
// 读取好友信息(CharacterSocial)
// 读取行会信息(Guild)/
// 读取团队信息(Group)
// 读取组队信息 ?
// 计算攻防信息
// 读取人物增益/减益信息(CharacterAura)
// 读取法书/道具冷却信息(CharacterSpellCooldown)
//////////////////////////////////////////////////////////////////////////
// 读取人物基础信息(CharacterBase)
XPQuery<CharacterBase> characters = new XPQuery<CharacterBase>( OneDatabase.Session );
var characterList = from character in characters
where character.Oid == sqlInfo.LoginCharGuid
select character;
bool bIsFinde = false;
WowCharacter wowCharacter = new WowCharacter();
foreach ( CharacterBase character in characterList )
{
//////////////////////////////////////////////////////////////////////////
// 读取人物状态信息(CharacterBase)
wowCharacter.GuildGuid = character.Oid;
wowCharacter.Name = character.CharacterName;
wowCharacter.Level = (uint)character.Level;
wowCharacter.Race = (uint)character.Race;
wowCharacter.Class = (uint)character.Class;
wowCharacter.ZoneId = (uint)character.ZoneId;
wowCharacter.MapId = (uint)character.MapId;
wowCharacter.X = character.PositionX;
wowCharacter.Y = character.PositionY;
wowCharacter.Z = character.PositionZ;
wowCharacter.Gender = (uint)character.Gender;
wowCharacter.Face = (uint)character.Face;
wowCharacter.HairStyle = (uint)character.HairStyle;
wowCharacter.HairColor = (uint)character.HairColor;
wowCharacter.FacialHair = (uint)character.FacialHair;
//////////////////////////////////////////////////////////////////////////
// 读取道具信息(CharacterItem)
XPQuery<CharacterItem> characterItems = new XPQuery<CharacterItem>( OneDatabase.Session );
var characterItemList = from characterItem in characterItems
where characterItem.Owner == character && characterItem.BagId > InventorySlotBag.InventorySlotEquipmentBag && characterItem.BagId < InventorySlotBag.InventorySlotMainBag
select characterItem;
foreach ( CharacterItem characterItem in characterItemList )
{
if ( characterItem.SlotId != BaseItem.SlotNotSet )
continue;
WowItemContainer wowItemContainer = wowCharacter.BagManager.FindContainerAtSlot( characterItem.BagId ) as WowItemContainer;
if ( wowItemContainer != null )
continue;
else
{
WowItemTemplate wowItemTemplate = ProcessServer.WowZoneCluster.World.ItemTemplateManager.GetItemTemplate( (Serial)characterItem.ItemTemplateGuid ) as WowItemTemplate;
if ( wowItemTemplate == null )
continue;
wowItemContainer = new WowItemContainer();
wowItemContainer.InitContainerSlot( 0, wowItemTemplate.ContainerSlots );
wowItemContainer.Item = new WowItem();
wowItemContainer.Item.Serial = characterItem.Oid;
wowItemContainer.Item.ItemTemplate = wowItemTemplate;
wowCharacter.BagManager.AddContainer( characterItem.BagId, wowItemContainer );
}
}
characterItemList = from characterItem in characterItems
select characterItem;
foreach ( CharacterItem characterItem in characterItemList )
{
if ( characterItem.SlotId != BaseItem.SlotNotSet )
continue;
WowItem wowItem = new WowItem();
wowItem.Serial = characterItem.Oid;
if ( characterItem.BagId == InventorySlotBag.InventorySlotEquipmentBag )
{
if ( characterItem.SlotId == BaseItem.SlotNotSet ||
characterItem.SlotId < EquipmentSlot.EquipmentSlotStart ||
characterItem.SlotId >= EquipmentSlot.EquipmentSlotEnd )
continue;
if ( wowCharacter.BagManager.EquipmentBag.FindSubItemAtSlot( characterItem.SlotId ) != null )
continue;
wowCharacter.BagManager.EquipmentBag.AddSubItem( characterItem.SlotId, wowItem );
}
else if ( characterItem.BagId == InventorySlotBag.InventorySlotMainBag )
{
if ( characterItem.SlotId == BaseItem.SlotNotSet ||
characterItem.SlotId < BagSlotItem.BagSlotItemStart ||
characterItem.SlotId >= BagSlotItem.BagSlotItemEnd )
continue;
if ( wowCharacter.BagManager.EquipmentBag.FindSubItemAtSlot( characterItem.SlotId ) != null )
continue;
wowCharacter.BagManager.MainBag.AddSubItem( characterItem.SlotId, wowItem );
}
else
{
WowItemContainer wowItemContainer = wowCharacter.BagManager.FindContainerAtSlot( characterItem.BagId ) as WowItemContainer;
if ( wowItemContainer == null )
continue;
else
{
if ( wowItemContainer.FindSubItemAtSlot( characterItem.SlotId ) != null )
continue;
wowItemContainer.AddSubItem( characterItem.SlotId, wowItem );
}
}
}
//////////////////////////////////////////////////////////////////////////
// 读取技能信息(CharacterSkill)
XPQuery<CharacterSkill> characterSkills = new XPQuery<CharacterSkill>( OneDatabase.Session );
var characterSkillList = from characterSkill in characterSkills
where characterSkill.Owner == character
select characterSkill;
foreach ( CharacterSkill characterSkill in characterSkillList )
{
WowSkill wowSkill = new WowSkill();
wowSkill.Serial = characterSkill.SkillId;
wowCharacter.SkillManager.AddSkill( wowSkill.Serial, wowSkill );
}
//////////////////////////////////////////////////////////////////////////
// 读取法术信息(CharacterSpell)
XPQuery<CharacterSpell> characterSpells = new XPQuery<CharacterSpell>( OneDatabase.Session );
var characterSpellList = from characterSpell in characterSpells
where characterSpell.Owner == character
select characterSpell;
foreach ( CharacterSpell characterSpell in characterSpellList )
{
WowSpell wowSpell = new WowSpell();
wowSpell.Serial = characterSpell.SpellId;
wowCharacter.SpellManager.AddSpell( wowSpell.Serial, wowSpell );
}
//////////////////////////////////////////////////////////////////////////
// 读取天赋信息(CharactersGift)
XPQuery<CharactersGift> charactersGifts = new XPQuery<CharactersGift>( OneDatabase.Session );
var charactersGiftList = from charactersGift in charactersGifts
where charactersGift.Owner == character
select charactersGift;
foreach ( CharactersGift charactersGift in charactersGiftList )
{
WowTalent wowTalent = new WowTalent();
wowTalent.Serial = charactersGift.Oid;
wowCharacter.TalentManager.AddTalent( wowTalent.Serial, wowTalent );
}
//////////////////////////////////////////////////////////////////////////
// 读取宠物信息(CharacterPet)
XPQuery<CharacterPet> characterPets = new XPQuery<CharacterPet>( OneDatabase.Session );
var characterPetList = from characterPet in characterPets
where characterPet.Owner == character
select characterPet;
foreach ( CharacterPet characterPet in characterPetList )
{
WowPet wowPet = new WowPet();
}
//////////////////////////////////////////////////////////////////////////
// 读取探索信息(CharacterExplore)
XPQuery<CharacterExplore> characterExplores = new XPQuery<CharacterExplore>( OneDatabase.Session );
var characterExploreList = from characterExplore in characterExplores
where characterExplore.Owner == character
select characterExplore;
foreach ( CharacterExplore characterExplore in characterExploreList )
{
}
//////////////////////////////////////////////////////////////////////////
// 读取声望信息(CharacterReputation)
XPQuery<CharacterReputation> characterReputations = new XPQuery<CharacterReputation>( OneDatabase.Session );
var characterReputationList = from characterReputation in characterReputations
where characterReputation.Owner == character
select characterReputation;
foreach ( CharacterReputation characterReputation in characterReputationList )
{
}
//////////////////////////////////////////////////////////////////////////
// 读取邮件信息(Mail)
XPQuery<Mail> mails = new XPQuery<Mail>( OneDatabase.Session );
var mailList = from mail in mails
where mail.Receiver == character
select mail;
foreach ( Mail mail in mailList )
{
}
//////////////////////////////////////////////////////////////////////////
// 读取飞行点信息(CharactersTaxi)
XPQuery<CharactersTaxi> charactersTaxis = new XPQuery<CharactersTaxi>( OneDatabase.Session );
var charactersTaxiList = from charactersTaxi in charactersTaxis
where charactersTaxi.Owner == character
select charactersTaxi;
foreach ( CharactersTaxi charactersTaxi in charactersTaxiList )
{
}
//////////////////////////////////////////////////////////////////////////
// 读取快捷按钮信息(CharacterActionBar)
XPQuery<CharacterActionBar> characterActionBars = new XPQuery<CharacterActionBar>( OneDatabase.Session );
var characterActionBarList = from characterActionBar in characterActionBars
where characterActionBar.Owner == character
select characterActionBar;
foreach ( CharacterActionBar characterActionBar in characterActionBarList )
{
}
//////////////////////////////////////////////////////////////////////////
// 读取好友信息(CharacterSocial)
XPQuery<CharacterSocial> characterSocials = new XPQuery<CharacterSocial>( OneDatabase.Session );
var characterSocialList = from characterSocial in characterSocials
where characterSocial.Owner == character
select characterSocial;
foreach ( CharacterSocial characterSocial in characterSocialList )
{
}
//////////////////////////////////////////////////////////////////////////
// 读取行会信息(Guild)
XPQuery<Guild> guilds = new XPQuery<Guild>( OneDatabase.Session );
var guildList = from guild in guilds
where guild.Leader == character
select guild;
foreach ( Guild guild in guildList )
{
}
//////////////////////////////////////////////////////////////////////////
// 读取团队信息(Group)
XPQuery<Group> groups = new XPQuery<Group>( OneDatabase.Session );
var groupList = from groupItem in groups
where groupItem.Leader == character
select groupItem;
foreach ( Group group in groupList )
{
}
//////////////////////////////////////////////////////////////////////////
// 读取组队信息 ?
//////////////////////////////////////////////////////////////////////////
// 计算攻防信息
//////////////////////////////////////////////////////////////////////////
// 读取人物增益/减益信息(CharacterAura)
XPQuery<CharacterAura> characterAuras = new XPQuery<CharacterAura>( OneDatabase.Session );
var characterAuraList = from characterAura in characterAuras
where characterAura.Owner == character
select characterAura;
foreach ( CharacterAura characterAura in characterAuraList )
{
}
//////////////////////////////////////////////////////////////////////////
// 读取法书/道具冷却信息(CharacterSpellCooldown)
XPQuery<CharacterSpellCooldown> characterSpellCooldowns = new XPQuery<CharacterSpellCooldown>( OneDatabase.Session );
var characterSpellCooldownList = from characterSpellCooldown in characterSpellCooldowns
where characterSpellCooldown.Owner == character
select characterSpellCooldown;
foreach ( CharacterSpellCooldown characterSpellCooldown in characterSpellCooldownList )
{
}
bIsFinde = true;
break;
}
if ( bIsFinde == false )
{
Debug.WriteLine( "CHAR_LOGIN_FAILED error!" );
sqlInfo.NetState.Send( new Word_PlayerLoginFailedResponse( ResponseCodes.CHAR_LOGIN_FAILED ) );
return;
}
sqlInfo.NetState.Send( new Word_PlayerDungeonDifficulty( InstanceMode.MODE_NORMAL ) );
sqlInfo.NetState.Send( new Word_PlayerLoginVerifyWorld( wowCharacter.MapId, wowCharacter.X, wowCharacter.Y, wowCharacter.Z, wowCharacter.O ) );
AccountData[] accountDataArray = new AccountData[8];
for ( int iIndex = 0; iIndex < accountDataArray.Length; iIndex++ )
accountDataArray[iIndex] = new AccountData();
sqlInfo.NetState.Send( new Word_PlayerAccountDataMd5( accountDataArray ) );
sqlInfo.NetState.Send( new Word_PlayerVoiceSystemStatus( 0 ) );// 需要连接套接字
sqlInfo.NetState.Send( new Word_PlayerTriggerCinematic( 0 ) );
sqlInfo.NetState.Send( new Word_PlayerBroadcastMsg( "ookk1234567" ) );
sqlInfo.NetState.Send( new Word_PlayerSetRestStart() );
sqlInfo.NetState.Send( new Word_PlayerBindPointUpdate( wowCharacter.X, wowCharacter.Y, wowCharacter.Z, wowCharacter.MapId, wowCharacter.ZoneId ) );
uint[] uiTutorialArray = new uint[8];
for ( int iIndex = 0; iIndex < uiTutorialArray.Length; iIndex++ )
uiTutorialArray[iIndex] = 0;
sqlInfo.NetState.Send( new Word_PlayerTutorialFlags( uiTutorialArray ) );
sqlInfo.NetState.Send( new Word_PlayerInitialSpells( wowCharacter.SpellManager.ToArray(), wowCharacter.SpellCooldownManager.ToArray() ) );
sqlInfo.NetState.Send( new Word_PlayerActionButtons( wowCharacter.ActionBarManager.ToArray() ) );
sqlInfo.NetState.Send( new Word_PlayerInitializeFactions( wowCharacter.ReputationManager.ToArray() ) );
sqlInfo.NetState.Send( new Word_PlayerInitWorldStates( wowCharacter.MapId, wowCharacter.ZoneId, 0 ) );
sqlInfo.NetState.Send( new Word_PlayerLoginSetTimeSpeed( DateTime.Now ) );
}
/// <summary>
///
/// </summary>
private static void SQL_HandleCharLogin(CharLoginSQL sqlInfo)
{
//////////////////////////////////////////////////////////////////////////
// 读取人物基础信息(CharacterBase)
// 读取人物状态信息(CharacterBase)
// 读取道具信息(CharacterItem)
// 读取技能信息(CharacterSkill)
// 读取法术信息(CharacterSpell)
// 读取天赋信息(CharactersGift)
// 读取宠物信息(CharacterPet)
// 读取探索信息(CharacterExplore)
// 读取声望信息(CharacterReputation)
// 读取邮件信息(Mail)
// 读取飞行点信息(CharactersTaxi)
// 读取快捷按钮信息(CharacterActionBar)
// 读取好友信息(CharacterSocial)
// 读取行会信息(Guild)/
// 读取团队信息(Group)
// 读取组队信息 ?
// 计算攻防信息
// 读取人物增益/减益信息(CharacterAura)
// 读取法书/道具冷却信息(CharacterSpellCooldown)
//////////////////////////////////////////////////////////////////////////
// 读取人物基础信息(CharacterBase)
XPQuery <CharacterBase> characters = new XPQuery <CharacterBase>(OneDatabase.Session);
var characterList = from character in characters
where character.Oid == sqlInfo.LoginCharGuid
select character;
bool bIsFinde = false;
WowCharacter wowCharacter = new WowCharacter();
foreach (CharacterBase character in characterList)
{
//////////////////////////////////////////////////////////////////////////
// 读取人物状态信息(CharacterBase)
wowCharacter.GuildGuid = character.Oid;
wowCharacter.Name = character.CharacterName;
wowCharacter.Level = (uint)character.Level;
wowCharacter.Race = (uint)character.Race;
wowCharacter.Class = (uint)character.Class;
wowCharacter.ZoneId = (uint)character.ZoneId;
wowCharacter.MapId = (uint)character.MapId;
wowCharacter.X = character.PositionX;
wowCharacter.Y = character.PositionY;
wowCharacter.Z = character.PositionZ;
wowCharacter.Gender = (uint)character.Gender;
wowCharacter.Face = (uint)character.Face;
wowCharacter.HairStyle = (uint)character.HairStyle;
wowCharacter.HairColor = (uint)character.HairColor;
wowCharacter.FacialHair = (uint)character.FacialHair;
//////////////////////////////////////////////////////////////////////////
// 读取道具信息(CharacterItem)
XPQuery <CharacterItem> characterItems = new XPQuery <CharacterItem>(OneDatabase.Session);
var characterItemList = from characterItem in characterItems
where characterItem.Owner == character && characterItem.BagId > InventorySlotBag.InventorySlotEquipmentBag && characterItem.BagId < InventorySlotBag.InventorySlotMainBag
select characterItem;
foreach (CharacterItem characterItem in characterItemList)
{
if (characterItem.SlotId != BaseItem.SlotNotSet)
{
continue;
}
WowItemContainer wowItemContainer = wowCharacter.BagManager.FindContainerAtSlot(characterItem.BagId) as WowItemContainer;
if (wowItemContainer != null)
{
continue;
}
else
{
WowItemTemplate wowItemTemplate = ProcessServer.WowZoneCluster.World.ItemTemplateManager.GetItemTemplate((Serial)characterItem.ItemTemplateGuid) as WowItemTemplate;
if (wowItemTemplate == null)
{
continue;
}
wowItemContainer = new WowItemContainer();
wowItemContainer.InitContainerSlot(0, wowItemTemplate.ContainerSlots);
wowItemContainer.Item = new WowItem();
wowItemContainer.Item.Serial = characterItem.Oid;
wowItemContainer.Item.ItemTemplate = wowItemTemplate;
wowCharacter.BagManager.AddContainer(characterItem.BagId, wowItemContainer);
}
}
characterItemList = from characterItem in characterItems
select characterItem;
foreach (CharacterItem characterItem in characterItemList)
{
if (characterItem.SlotId != BaseItem.SlotNotSet)
{
continue;
}
WowItem wowItem = new WowItem();
wowItem.Serial = characterItem.Oid;
if (characterItem.BagId == InventorySlotBag.InventorySlotEquipmentBag)
{
if (characterItem.SlotId == BaseItem.SlotNotSet ||
characterItem.SlotId < EquipmentSlot.EquipmentSlotStart ||
characterItem.SlotId >= EquipmentSlot.EquipmentSlotEnd)
{
continue;
}
if (wowCharacter.BagManager.EquipmentBag.FindSubItemAtSlot(characterItem.SlotId) != null)
{
continue;
}
wowCharacter.BagManager.EquipmentBag.AddSubItem(characterItem.SlotId, wowItem);
}
else if (characterItem.BagId == InventorySlotBag.InventorySlotMainBag)
{
if (characterItem.SlotId == BaseItem.SlotNotSet ||
characterItem.SlotId < BagSlotItem.BagSlotItemStart ||
characterItem.SlotId >= BagSlotItem.BagSlotItemEnd)
{
continue;
}
if (wowCharacter.BagManager.EquipmentBag.FindSubItemAtSlot(characterItem.SlotId) != null)
{
continue;
}
wowCharacter.BagManager.MainBag.AddSubItem(characterItem.SlotId, wowItem);
}
else
{
WowItemContainer wowItemContainer = wowCharacter.BagManager.FindContainerAtSlot(characterItem.BagId) as WowItemContainer;
if (wowItemContainer == null)
{
continue;
}
else
{
if (wowItemContainer.FindSubItemAtSlot(characterItem.SlotId) != null)
{
continue;
}
wowItemContainer.AddSubItem(characterItem.SlotId, wowItem);
}
}
}
//////////////////////////////////////////////////////////////////////////
// 读取技能信息(CharacterSkill)
XPQuery <CharacterSkill> characterSkills = new XPQuery <CharacterSkill>(OneDatabase.Session);
var characterSkillList = from characterSkill in characterSkills
where characterSkill.Owner == character
select characterSkill;
foreach (CharacterSkill characterSkill in characterSkillList)
{
WowSkill wowSkill = new WowSkill();
wowSkill.Serial = characterSkill.SkillId;
wowCharacter.SkillManager.AddSkill(wowSkill.Serial, wowSkill);
}
//////////////////////////////////////////////////////////////////////////
// 读取法术信息(CharacterSpell)
XPQuery <CharacterSpell> characterSpells = new XPQuery <CharacterSpell>(OneDatabase.Session);
var characterSpellList = from characterSpell in characterSpells
where characterSpell.Owner == character
select characterSpell;
foreach (CharacterSpell characterSpell in characterSpellList)
{
WowSpell wowSpell = new WowSpell();
wowSpell.Serial = characterSpell.SpellId;
wowCharacter.SpellManager.AddSpell(wowSpell.Serial, wowSpell);
}
//////////////////////////////////////////////////////////////////////////
// 读取天赋信息(CharactersGift)
XPQuery <CharactersGift> charactersGifts = new XPQuery <CharactersGift>(OneDatabase.Session);
var charactersGiftList = from charactersGift in charactersGifts
where charactersGift.Owner == character
select charactersGift;
foreach (CharactersGift charactersGift in charactersGiftList)
{
WowTalent wowTalent = new WowTalent();
wowTalent.Serial = charactersGift.Oid;
wowCharacter.TalentManager.AddTalent(wowTalent.Serial, wowTalent);
}
//////////////////////////////////////////////////////////////////////////
// 读取宠物信息(CharacterPet)
XPQuery <CharacterPet> characterPets = new XPQuery <CharacterPet>(OneDatabase.Session);
var characterPetList = from characterPet in characterPets
where characterPet.Owner == character
select characterPet;
foreach (CharacterPet characterPet in characterPetList)
{
WowPet wowPet = new WowPet();
}
//////////////////////////////////////////////////////////////////////////
// 读取探索信息(CharacterExplore)
XPQuery <CharacterExplore> characterExplores = new XPQuery <CharacterExplore>(OneDatabase.Session);
var characterExploreList = from characterExplore in characterExplores
where characterExplore.Owner == character
select characterExplore;
foreach (CharacterExplore characterExplore in characterExploreList)
{
}
//////////////////////////////////////////////////////////////////////////
// 读取声望信息(CharacterReputation)
XPQuery <CharacterReputation> characterReputations = new XPQuery <CharacterReputation>(OneDatabase.Session);
var characterReputationList = from characterReputation in characterReputations
where characterReputation.Owner == character
select characterReputation;
foreach (CharacterReputation characterReputation in characterReputationList)
{
}
//////////////////////////////////////////////////////////////////////////
// 读取邮件信息(Mail)
XPQuery <Mail> mails = new XPQuery <Mail>(OneDatabase.Session);
var mailList = from mail in mails
where mail.Receiver == character
select mail;
foreach (Mail mail in mailList)
{
}
//////////////////////////////////////////////////////////////////////////
// 读取飞行点信息(CharactersTaxi)
XPQuery <CharactersTaxi> charactersTaxis = new XPQuery <CharactersTaxi>(OneDatabase.Session);
var charactersTaxiList = from charactersTaxi in charactersTaxis
where charactersTaxi.Owner == character
select charactersTaxi;
foreach (CharactersTaxi charactersTaxi in charactersTaxiList)
{
}
//////////////////////////////////////////////////////////////////////////
// 读取快捷按钮信息(CharacterActionBar)
XPQuery <CharacterActionBar> characterActionBars = new XPQuery <CharacterActionBar>(OneDatabase.Session);
var characterActionBarList = from characterActionBar in characterActionBars
where characterActionBar.Owner == character
select characterActionBar;
foreach (CharacterActionBar characterActionBar in characterActionBarList)
{
}
//////////////////////////////////////////////////////////////////////////
// 读取好友信息(CharacterSocial)
XPQuery <CharacterSocial> characterSocials = new XPQuery <CharacterSocial>(OneDatabase.Session);
var characterSocialList = from characterSocial in characterSocials
where characterSocial.Owner == character
select characterSocial;
foreach (CharacterSocial characterSocial in characterSocialList)
{
}
//////////////////////////////////////////////////////////////////////////
// 读取行会信息(Guild)
XPQuery <Guild> guilds = new XPQuery <Guild>(OneDatabase.Session);
var guildList = from guild in guilds
where guild.Leader == character
select guild;
foreach (Guild guild in guildList)
{
}
//////////////////////////////////////////////////////////////////////////
// 读取团队信息(Group)
XPQuery <Group> groups = new XPQuery <Group>(OneDatabase.Session);
var groupList = from groupItem in groups
where groupItem.Leader == character
select groupItem;
foreach (Group group in groupList)
{
}
//////////////////////////////////////////////////////////////////////////
// 读取组队信息 ?
//////////////////////////////////////////////////////////////////////////
// 计算攻防信息
//////////////////////////////////////////////////////////////////////////
// 读取人物增益/减益信息(CharacterAura)
XPQuery <CharacterAura> characterAuras = new XPQuery <CharacterAura>(OneDatabase.Session);
var characterAuraList = from characterAura in characterAuras
where characterAura.Owner == character
select characterAura;
foreach (CharacterAura characterAura in characterAuraList)
{
}
//////////////////////////////////////////////////////////////////////////
// 读取法书/道具冷却信息(CharacterSpellCooldown)
XPQuery <CharacterSpellCooldown> characterSpellCooldowns = new XPQuery <CharacterSpellCooldown>(OneDatabase.Session);
var characterSpellCooldownList = from characterSpellCooldown in characterSpellCooldowns
where characterSpellCooldown.Owner == character
select characterSpellCooldown;
foreach (CharacterSpellCooldown characterSpellCooldown in characterSpellCooldownList)
{
}
bIsFinde = true;
break;
}
if (bIsFinde == false)
{
Debug.WriteLine("CHAR_LOGIN_FAILED error!");
sqlInfo.NetState.Send(new Word_PlayerLoginFailedResponse(ResponseCodes.CHAR_LOGIN_FAILED));
return;
}
sqlInfo.NetState.Send(new Word_PlayerDungeonDifficulty(InstanceMode.MODE_NORMAL));
sqlInfo.NetState.Send(new Word_PlayerLoginVerifyWorld(wowCharacter.MapId, wowCharacter.X, wowCharacter.Y, wowCharacter.Z, wowCharacter.O));
AccountData[] accountDataArray = new AccountData[8];
for (int iIndex = 0; iIndex < accountDataArray.Length; iIndex++)
{
accountDataArray[iIndex] = new AccountData();
}
sqlInfo.NetState.Send(new Word_PlayerAccountDataMd5(accountDataArray));
sqlInfo.NetState.Send(new Word_PlayerVoiceSystemStatus(0)); // 需要连接套接字
sqlInfo.NetState.Send(new Word_PlayerTriggerCinematic(0));
sqlInfo.NetState.Send(new Word_PlayerBroadcastMsg("ookk1234567"));
sqlInfo.NetState.Send(new Word_PlayerSetRestStart());
sqlInfo.NetState.Send(new Word_PlayerBindPointUpdate(wowCharacter.X, wowCharacter.Y, wowCharacter.Z, wowCharacter.MapId, wowCharacter.ZoneId));
uint[] uiTutorialArray = new uint[8];
for (int iIndex = 0; iIndex < uiTutorialArray.Length; iIndex++)
{
uiTutorialArray[iIndex] = 0;
}
sqlInfo.NetState.Send(new Word_PlayerTutorialFlags(uiTutorialArray));
sqlInfo.NetState.Send(new Word_PlayerInitialSpells(wowCharacter.SpellManager.ToArray(), wowCharacter.SpellCooldownManager.ToArray()));
sqlInfo.NetState.Send(new Word_PlayerActionButtons(wowCharacter.ActionBarManager.ToArray()));
sqlInfo.NetState.Send(new Word_PlayerInitializeFactions(wowCharacter.ReputationManager.ToArray()));
sqlInfo.NetState.Send(new Word_PlayerInitWorldStates(wowCharacter.MapId, wowCharacter.ZoneId, 0));
sqlInfo.NetState.Send(new Word_PlayerLoginSetTimeSpeed(DateTime.Now));
}
