MyBB Community Forums

Well, my board got a lot of PMs, about 200k, so I want to delete older ones.

How do I delete messages older than 1/2 or 3 month(s)?

Thank you!

Any help?

you can use SQL query similar to below

DELETE FROM `mybb_privatemessages` WHERE `uid` = X AND `dateline` < unixtimestamp

eg.

DELETE FROM `mybb_privatemessages` WHERE `uid` = 1 AND `dateline` < 1325397600

1325397600 is unix time stamp of 1st Jan 2012 (0h:0m EST) ; see also unix time stamp