View Full Version : Prune Private Messages
bashy
09-23-2006, 04:19 PM
Hi peeps
Is this already available as i cannot find anything for 3.5 or 3.6
I cannot find anything stock in the admincp either?
If not to both, would someone be willing to look into this
Perhaps be able to prun by x amount of days old?
Perhaps be able to select to prune certain members
Perhaps theres an aoption for members to be able to mass delete all the PMs from either of thier folders?
How does this sound to anyone please?
SCRIPT3R
09-23-2006, 08:20 PM
you can do this with queries.
bashy
09-23-2006, 08:32 PM
Sorry m8 I know little about nothing and queries com into this catergory,
Could really do with a hack of some sort, I am supprised it aint stock!
Although i could have sworn i have seen something to this effect!
SCRIPT3R
09-23-2006, 09:14 PM
to an extent, it is "stock" via queries. AdminCP >> Maintenance >> Execute SQL Query - for example,
TRUNCATE pm
TRUNCATE pmreceipt
TRUNCATE pmtext
will delete all private messages. more can be done via phpMyAdmin like...
EMPTY `PREFIX_pm`;
EMPTY `PREFIX_pmreceipt`;
EMPTY `PREFIX_pmtext`;
UPDATE `PREFIX_user` SET `pmtotal`='0', `pmunread`='0' WHERE 1;
but i see where you're going where you want to set conditionals. THAT would be an awesome hack.
P.S. here's (http://www.vbulletin.com/forum/showthread.php?t=167780) my suggestion thread over at vB.com a while back. feel free to bump and let vB know that this is actually a valid request.
Sadie Frost
10-20-2006, 01:20 AM
Is there a way via phpMyAdmin to do something like I think you suggested at vb.com to prune the pm's for people who haven't been on the site in x amount of time?
:)
bashy
10-20-2006, 05:16 AM
I think it was a suggestion only,
Hi geartripper, sorry, for some reason i have only just received the new post pm.
Either that or i blinked and missed the 1st 1 :o
Anyway, just added to your thread over in .com this could be an invaluable hack or addon as standard. Heres hoping :)
vBulletin® v3.8.12 by vBS, Copyright ©2000-2024, vBulletin Solutions Inc.