MyBB

shihrem · 2016-09-25, 11:10 AM

How can i change timestamp from all posts and threads?
Is a sql query or something what can help me to do it easy?
Thanks.

alfred702 · (This post was last modified: 2016-09-25, 09:50 PM by alfred702.)

Please view the answer below

nth · 2016-09-25, 09:34 PM

UPDATE `mybb_threads` SET `dateline` = 'YOUR_TIMESTAMP', `lastpost` = 'YOUR_TIMESTAMP';
UPDATE `mybb_posts` SET `dateline` = 'YOUR_TIMESTAMP';

shihrem · 2016-09-25, 10:36 PM

I changed "your_timesamp" to "today" And no show today show "Less than 1 minute ago"
I need to change merged posts

Any ideea?

Thanks

nth · 2016-09-25, 10:38 PM

It needs to be a timestamp, not "today" (or do you mean you have used Today's timestamp?)

shihrem · (This post was last modified: 2016-09-26, 06:52 PM by shihrem.)

I used timesamp code 1474707902
but no show TODAY it show 1 minute ago

Anny ideea?
Thanks