public void ReloadBuddies()
{
mBuddies.Clear();
using (DatabaseClient dbClient = AleedaEnvironment.GetDatabase().GetClient())
{
dbClient.AddParamWithValue("@userid", mClient.GetHabbo().ID);
foreach (DataRow row in dbClient.ReadDataTable("SELECT id,username,figure,motto FROM users WHERE id IN(SELECT buddyid FROM messenger_buddylist WHERE userid = @userid AND accepted = 0x01) OR id IN(SELECT userid FROM messenger_buddylist WHERE buddyid = @userid AND accepted = 0x01);").Rows)
{
MessengerBuddy buddy = MessengerBuddy.Parse(row);
if (buddy != null)
{
mBuddies.Add(buddy);
}
}
}
}
public List <MessengerBuddy> SearchHabbos(string criteria)
{
List <MessengerBuddy> matches = new List <MessengerBuddy>();
using (DatabaseClient dbClient = AleedaEnvironment.GetDatabase().GetClient())
{
dbClient.AddParamWithValue("@criteria", criteria + "%");
foreach (DataRow row in dbClient.ReadDataTable("SELECT id,username,figure,motto FROM users WHERE username LIKE @criteria;").Rows)
{
MessengerBuddy match = MessengerBuddy.Parse(row);
if (match != null)
{
matches.Add(match);
}
}
}
return(matches);
}