public void LoadGuildMemberIds(int guildid, ref List<int> MemberIDs)
{
try
{
//Make sure we start with a clean list
if (MemberIDs != null)
//If not null clear the list
MemberIDs.Clear();
//Create new query to get guild member information
MsSQL ms = new MsSQL("SELECT * FROM guild_members WHERE guild_id='" + guildid + "'");
//Create sql data reader to read database content
using (System.Data.SqlClient.SqlDataReader reader = ms.Read())
{
//While the reader is reading
while (reader.Read())
{
//Add member id to the list
MemberIDs.Add(reader.GetInt32(2));
}
}
}
//Catch any bad exception error
catch (Exception ex)
{
//Write information to debug log
Systems.Debugger.Write(ex);
}
}