is there a Mod for deleting all the PM's
 

Not just one user's PM's, but board wide deletion. every pm in every user's box with one click

I doubt any such mod exists, there isn't going to be much call for such a thing.

There was a hack a few years back made for the early versions that allowed you thru your AdminCP, to schedule daily, weekly or monthly mass PM's deletions. I remember it because I installed on 4 boards. But I can't seem to find it now.

Or Is there a way to manually purge the SQL PM Database with a query and if so, what whould that query code look like?

Or can you simply just goto your Database and just "Empty" that sql...

Thanks for the Help....

<a href="http://www.vbulletin.com/forum/showthread.php?t=231405" target="_blank">http://www.vbulletin.com/forum/showthread.php?t=231405</a>

i had this request yesterday: http://www.vbulletin.com/forum/showthread.php?t=245300

i released the answer here: http://www.vb-hacks.org/forum/showthread.php?t=656

Perfect, Thank You!!!!!

Unfortunately, like an add-on I was working on a while back (see https://vborg.vbsupport.ru/showthread.php?t=142308), your solution doesn't update PM counts as it deletes PMs.

I've also looked for a database query that could be run separately to recount remaining PMs on a member by member basis, with no success yet.

Any thoughts?

my script was built for mega large pm db, and for that i dropped the recount of pm... but it is simple... a lot... ;)

you will have to duplicate the function build_pm_counters(), because that actual one is working only with userinfo, the actual user, not in batch process...

i did not include it because it would overhead the server... and actually, each time a member will post or receive a new pm, the count is updated... that's why i did not do it.

How would you do that exactly? I'd be willing to share authorship or give authorship to you for that matter for a script that worked and that would run as a cron job.

See https://vborg.vbsupport.ru/showthread.php?t=142308

You might want to take a look at the queries in this thread: http://www.vbulletin.com/forum/showt...light=pmunread

(Although, if you have actually deleted all the PMs, can't you just make a simple query and set pmtotal and pmunread both equal to zero for everyone?)