MyBB Community Forums

Withdrawn

You've to do this through phpMyAdmin.

cPanel > Database management > phpMyAdmin > Select your forum's database > Then mybb_posts table (make sure that your table prefix is mybb_ ?) > then in dateline column, edit the post's dateline with UNIX timestamp.

You've to convert Date to UNIX timestamp first. For this you may use this tool: http://www.onlineconversion.com/unix_time.htm

(2012-11-19, 06:29 PM)Yaldaram Wrote: [ -> ]You've to do this through phpMyAdmin.

cPanel > Database management > phpMyAdmin > Select your forum's database > Then mybb_posts table (make sure that your table prefix is mybb_ ?) > then in dateline column, edit the post's dateline with UNIX timestamp.

You've to convert Date to UNIX timestamp first. For this you may use this tool: http://www.onlineconversion.com/unix_time.htm

.....

if you know the PID then just run this query

UPDATE mybb_posts SET dateline = UNIX_TIMESTAMP('2007-11-30 10:30:19') WHERE pid = XXX

however, why do you need to do this? it has potential to impact last post time in threads and forums tables, mess up a ton of queries that are reliant on dateline, alter sorting outputs, pagination, etc