public void ReloadBuddies() { mBuddies.Clear(); using (DatabaseClient dbClient = IonEnvironment.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 static MessengerBuddy Parse(DataRow row) { MessengerBuddy buddy = new MessengerBuddy(); try { buddy.mID = (uint)row["id"]; buddy.mUsername = (string)row["username"]; buddy.mFigure = (string)row["figure"]; buddy.mMotto = (string)row["motto"]; return buddy; } catch (Exception ex) { IonEnvironment.GetLog().WriteUnhandledExceptionError("MessengerBuddy.Parse", ex); } return null; }
public List <MessengerBuddy> SearchHabbos(string criteria) { List <MessengerBuddy> matches = new List <MessengerBuddy>(); using (DatabaseClient dbClient = IonEnvironment.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); }
public static MessengerBuddy Parse(DataRow row) { MessengerBuddy buddy = new MessengerBuddy(); try { buddy.mID = (uint)row["id"]; buddy.mUsername = (string)row["username"]; buddy.mFigure = (string)row["figure"]; buddy.mMotto = (string)row["motto"]; return(buddy); } catch (Exception ex) { IonEnvironment.GetLog().WriteUnhandledExceptionError("MessengerBuddy.Parse", ex); } return(null); }