A user registered and spammed hundreds of private messages to everyone on our board.

Is there a way to:

1. Delete all of their messages.

2. Put in place some sensible restrictions, such as X private messages/day, or something to prevent this from happening again?

Thanks

yah

1. would be a coupla queries.. a) delete any ubbt_PRIVATE_MESSAGE_TOPICS where they started it b) delete any ubbt_PRIVATE_MESSAGE_POSTS that no longer have a TOPIC_ID c) delete any ubbt_PRIVATE_MESSAGE_USERS matching that USER_ID

2. add a group that is post based (10, 25 or whatevs) that is auto-joined when that number of posts occurs. then that group is allowed to PM. then make the normal Sign up group not allowed to PM.