MyBB Community Forums

Full Version: Prune old PMs + optimize DB v1.0.0
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2 3 4 5
It is only the first "beta" version Smile more things will be added in future, but I will leave pruning globally not only for some groups/users... you can add this by yourself, it shouldnt be difficult.

New v0.5 added
- automatically optimizes only PM table after cleaning old PMs
- optimize all tables in database is disabled by default (enable it manually in task manager)
New v0.7 added
- optimize code (less code) - thx @Supryk
- add recounting for inbox+sentbox+drafts+trash box
- db optimization deleted -> use separate task
Thank you very much, I think the mybb group would add a default prune system to PM's Wink

Thanks for this plugin.
You are welcome. I have same opinion about this in mybb core...
Dude, When I try to activate your pluggin I've got this error message:
Parse error: syntax error, unexpected $end in /home/****/public_html/inc/tasks/task_prunepms.php on line 31

Could you help me?
I will check it. Thanks for a report.

EDIT: No problem for me. Could you try this version?
I open task_prunepms.php in notepad++ and I show you how I see it:
[attachment=33457]

It that ok?
Before line 31 all code are gray such commented.  Sad

Could be the problem?

_________
Note: this capture it is not from version 0.7 you upload here: http://community.mybb.com/thread-162704-...pid1130776

(2015-01-08, 11:57 PM)Eldenroot Wrote: [ -> ]EDIT: No problem for me. Could you try this version?

I downloaded and uploaded the 0.7 version and everything is OK.
Pluggin installed Big Grin

Thanks
You are missing a " (double quote) there.
$db->delete_query("mybb_privatemessages", "(dateline<".(TIME_NOW-$secs)." AND readtime>0) OR dateline<".(TIME_NOW-$usecs)." AND (folder='1' OR folder='2' OR folder='3' OR folder='4')");
@Omar G. - thx, I will fix it.
Is it working fine for everybody? I will upload a new version soon with @Omar fix and some improvements.
Pages: 1 2 3 4 5