Register Members List Search Today's Posts Mark Forums Read

Thread Tools
Old 01 Apr 2016, 12:58
joeychgo's Avatar
joeychgo joeychgo is offline
Join Date: Mar 2004
Real name: Joey
I want to clear some PMs - Need queries to do this

I want to clear some PMs. I actually want to do 2 things.

1. Delete all PMs from users who haven't visited the forum in 6 months or more;
2. Of the remaining users, I want to delete all pms in excess of 10 from each user.

The idea being, no user will have more then 10 PMs in their box, and if they haven't been to the site in 6 months, they will have zero.

So I'm looking for queries that will accomplish this.
Lincoln vs Cadillac Forums -
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

New To Site? Need Help?

All times are GMT. The time now is 22:40.

Layout Options | Width: Wide Color: