MyBB Community Forums

I am thinking of taking my old forum and restarting it. However, I don't want all of the posts that have been made so far to go to waste.

Is there a way that I can somehow change the timestamp of certain posts on a larger scale? Like an SQL query that would, for instance, change the month only?

You could add X amount of seconds to everything. I don't have time right now to give queries for everywhere they'd be needed, but this would be the syntax:

UPDATE `mybb_table` SET `timecolumn` = `timecolumn` + '2419200';

That would add 28 day's worth of seconds on. Goes without saying you'd need to backup your database before trying this, and make sure every column that contains a timestamp gets the same time added on.

OK thanks. I'll look into this. I'm basically looking for something like in WordPress, where you can republish a post as if it is brand new.