[For 1.8] Prune old PMs + optimize DB v1.0.0

[Eldenroot]

It is only the first "beta" version 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)

[Eldenroot]

New v0.7 added
- optimize code (less code) - thx @Supryk
- add recounting for inbox+sentbox+drafts+trash box
- db optimization deleted -> use separate task

[Foo_]

Thank you very much, I think the mybb group would add a default prune system to PM's

Thanks for this plugin.

[Eldenroot]

You are welcome. I have same opinion about this in mybb core...

[Foo_]

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?

[Eldenroot]

I will check it. Thanks for a report.

EDIT: No problem for me. Could you try this version?

[Foo_]

I open task_prunepms.php in notepad++ and I show you how I see it:
   

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

Could be the problem?

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

---

EDIT: No problem for me. Could you try this version?

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

Thanks

[Omar G.]

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')");

[Eldenroot]

@Omar G. - thx, I will fix it.

[Eldenroot]

Is it working fine for everybody? I will upload a new version soon with @Omar fix and some improvements.