Is this a customization here at DP or is there an add-on for vBulletin that allows one to regularly prune PMs by age?
There is one at vBulletin.org. Mass Delete Old Private messages By default it deletes all private messages more than 60 days old. It has a time variable in it, so if you want a different time you can adjust the variable. It can be put in a cron job to run automatically or you can run it manually when you want to prune.
Thanks, Jaqueline. That script needs some updating to work with 3.6x but it gives me a starting point.
Oops! I didn't even look at how old that was. It is the only thing I found. The query is a bit more complex than it was in the older version due to the addition of read receipts. I posted over there with a bit of pseudo-code that may help.
Thanks, J. I had a look and posted where I'd got to so far... not yet working. I'm at a very basic level when it comes to SQL queries...
There is a great forum Called --->>>http://www.vbulletin-faq.com/ Maybe you can ask there j/k I am surprised Joey didn't know...thought he was the master Maybe Shawn will chime in... Good luck though finding the answer...someone has to know between those 2 forums
Only way to do it is with a hack - although I know this is under consideration as a built in feature of the next major upgrade.
I'm about 80% there with an add-on, with the help of Jaqueline and Sarah from TAZ. Needs a bit more tweaking as soon as I get time.