[Hobbit Stomper]

Hi there,

I have a forum running (4.1.0) with about 6600 posts and 300 threads. Back when I created the forum in december, the server had the wrong year. I am about to fix the date on the server, but I would also like to change all the threads and posts in the mysql database by exactly one year.

How could I do that? Is there a script I can run to change all unix timestamps for posts/threads?

--------------- Added [DATE]1305084681[/DATE] at [TIME]1305084681[/TIME] ---------------

I could write my own php script that simple reads all dates of all posts of the mysql fields and then simply add the number 31536000 (amount of seconds for 1 year) to the current unix timestamp, assuming vbulletin uses unix timestamp.

So far I found the following tables and fields that would need to be updated:

adminlog.dateline

editlog.dateline

forum.lastpost
forum.lastthread

moderatorlog.dateline

phrase.dateline
thread.lastpost
thread.dateline

poll.dateline
poll.lastvote

post.dateline

postedithistory.dateline

profilevisitor.dateline

reputation.dateline

stats.dateline

visitormessage.dateline

user.joindate
user.lastvisit
user.lastactivity
user.lastpost

Then I also found user.passworddate, which is not unix timestamp, plus I am not sure what it does (time user changed/created password?). Seems it's only important for the backend and won't affect the forum itself, right?

My question, which one of those fields really need to be updated to keep the forum clean, and which ones will not affect the users at all?
And which ones will be automatically updated when I run a system maintenance-> update counters?

Just so I get a rough idea on how not to break the forum

Thanks.