Mass change date of all posts/threads?
 

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:

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.