public void LoadGuildMembers()
{
//Wrap our code in a try to catch bad exception errors
try
{
//Load guild member id's
LoadGuildMemberIds(Character.Network.Guild.Guildid, ref Character.Network.Guild.Members);
//Repeat for each member in the guild member list
foreach (int Guildmember in Character.Network.Guild.Members)
{
//Set new guild player information
Global.guild_player PlayerGuild = new Global.guild_player();
//Set guildmember id
PlayerGuild.MemberID = Guildmember;
//Create new mssql query to get player information
Systems.MsSQL ms = new Systems.MsSQL("SELECT * FROM character WHERE id='" + Guildmember + "'");
//Create mssql data reader
using (System.Data.SqlClient.SqlDataReader reader = ms.Read())
{
//While the reader is reading
while (reader.Read())
{
//Get player model
PlayerGuild.Model = reader.GetInt32(3);
//Get player xsector
PlayerGuild.Xsector = reader.GetByte(16);
//Get player ysector
PlayerGuild.Ysector = reader.GetByte(17);
//Get player level
PlayerGuild.Level = reader.GetByte(5);
//Get player name
PlayerGuild.Name = reader.GetString(2);
//Get player online state
PlayerGuild.Online = (reader.GetInt32(47) == 1);
//If player is online
if (PlayerGuild.Online)
{
//Get detailed player information
Systems sys = GetPlayerMainid(Guildmember);
//Make sure sys is not null
if (sys != null)
//Add the character client to the client list
this.Character.Network.Guild.MembersClient.Add(sys.client);
}
}
}
//Create new query to select from table guild_members
ms = new Systems.MsSQL("SELECT * FROM guild_members WHERE guild_member_id='" + Guildmember + "'");
//Create new sql data reader
using (System.Data.SqlClient.SqlDataReader reader = ms.Read())
{
//While the sql data reader is reading
while (reader.Read())
{
//Get player rights
PlayerGuild.joinRight = (reader.GetByte(7) == 1);
PlayerGuild.withdrawRight = (reader.GetByte(8) == 1);
PlayerGuild.unionRight = (reader.GetByte(9) == 1);
PlayerGuild.guildstorageRight = (reader.GetByte(10) == 1);
PlayerGuild.noticeeditRight = (reader.GetByte(11) == 1);
PlayerGuild.FWrank = reader.GetByte(6);
//Get player donated gp
PlayerGuild.DonateGP = reader.GetInt32(4);
//Get player rank
PlayerGuild.Rank = reader.GetByte(3);
}
}
//Close mssql
ms.Close();
//Add our character to the guild member info
Character.Network.Guild.MembersInfo.Add(PlayerGuild);
}
}
//Catch bad exceptions
catch (Exception ex)
{
//Write error to the console
Console.WriteLine(ex);
//Write error to the debug log file
Systems.Debugger.Write(ex);
}
}