MyBB Community Forums

Full Version: Change timestamps within a single thread?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Is it possible to change the timestamps of a single thread?

Like, let's say I want to take x seconds away from every post in the thread, without effecting the rest of the forum. Is this possible?
How do I make it so it takes away x seconds from each post? It seems as if what this does is changes all the posts to the same time.

EDIT: Where did your reply go?
*bumps*
Please backup your database before trying this.

UPDATE `mybb_threads` SET `dateline` = `dateline` - 'X', `lastpost` = `lastpost` - 'X' WHERE `tid` = 'Y';
UPDATE `mybb_posts` SET `dateline` = `dateline` - 'X' WHERE `tid` = 'Y';

Change X to the number of seconds to remove, and Y to the ID of the thread.
Thanks! This will help a lot, with a few threads.