I need to manually change the post date of a few posts in my forum and found the appropriate field in my table, but I don't know the actual breakdown. Can anyone lend a hand?
For example "1182456087" = "03:01:27 PM June 21, 2007" BUT how?
Well I figured out its a UTC (epoch/unix) date. So that sort of helps me. I added an topic to a board and modified the MySQL entry with the "correct" date and although the date is reflected when refreshing the page. It appears still on top in the board listing.
Any idea what I should be looking at next?
Go to Admin > Forum Maintenance and click on "Find and repair any errors." and "Recount all forum totals and statistics."
Does it help?