/// <summary>
/// The load buddy list.
/// </summary>
/// <param name="charId">
/// The char Id.
/// </param>
/// <returns>
/// Buddy list
/// </returns>
public static Collection<BuddyListEntry> LoadBuddyList(int charId)
{
Collection<BuddyListEntry> buddyList = new Collection<BuddyListEntry>();
SqlWrapper ms = new SqlWrapper();
string sqlQuery = "SELECT `BuddyID` FROM `buddylist` WHERE PlayerID = " + "'" + charId + "'";
DataTable dt = ms.ReadDatatable(sqlQuery);
foreach (DataRow buddyRow in dt.Rows)
{
BuddyListEntry buddylistentry = new BuddyListEntry();
buddylistentry.BuddyId = uint.Parse(buddyRow["BuddyID"].ToString());
buddyList.Add(buddylistentry);
}
return buddyList;
}
/// <summary>
/// The load buddy list.
/// </summary>
/// <param name="charId">
/// The char Id.
/// </param>
/// <returns>
/// Buddy list
/// </returns>
public static Collection <BuddyListEntry> LoadBuddyList(int charId)
{
Collection <BuddyListEntry> buddyList = new Collection <BuddyListEntry>();
SqlWrapper ms = new SqlWrapper();
string sqlQuery = "SELECT `BuddyID` FROM `buddylist` WHERE PlayerID = " + "'" + charId + "'";
DataTable dt = ms.ReadDatatable(sqlQuery);
foreach (DataRow buddyRow in dt.Rows)
{
BuddyListEntry buddylistentry = new BuddyListEntry();
buddylistentry.BuddyId = uint.Parse(buddyRow["BuddyID"].ToString());
buddyList.Add(buddylistentry);
}
return(buddyList);
}
