Worked fine for me usingFor those with vB forums [...] you can run the following queries:
UPDATE post SET dateline = dateline - 43200 WHERE postid <= ID OF LAST AFFECTED POST and postid >= ID OF FIRST AFFECTED POST
Then you'll need to update your thread and forum counters in the vBulletin Admin CP
I post these with no guarantee that they won't blow your server up, ruin your forum, steal your girlfriend, kill your fish etc! I recommend you do a backup and do a SELECT first to make sure you're affecting the right entries the database!
Edit: You can check the times of the timestamps in the database by using this convertor; http://www.onlineconversion.com/unix_time.htm
SET dateline = dateline - 43200
WHERE dateline > time of first bad post
Maybe 'cause I had no redfish.
Neither girlfriend that could be lost. :D
But it would really be nice to nevermore face that situation...