BuddyPress.org

Once in awhile a bot or user will get into the site and send out a bunch of unwanted messages to lots of users. Is there a way to delete all mail, clean up notifications, and clean up recipients, related to a specific user? I’ve gone into the db and eliminated the messages themselves, and the notifications, but I can’t figure a way to clean the table wp_bp_messages_recipients. Without setting this table straight, users see that they have unread messages, but since I deleted the messages they can’t do anything at that point. So they always think they have unread messages.