The date and time of posts

[chris1979]

Because I cannot bulk import my old forum into my new vBulletin forum, I'm planning to manually add at least the most recent 100 threads so that my members will have some discussions to continue with on the day the changes go live.

My plan is to copy and paste old posts in all from my account. Afterwards, I'll go through the database and correct the poster ids so that the right people appear as the posters. (That will be much quicker than logging in and out for each post, I think.)

Can I change the times too? I've noticed that times are encoded somehow. On the forum it says "Today at 03:56:03 am" but in the database it says "1161687363".

Is there a way to change the date and time of posts?

[Steve Machol]

The dateline column is in Unix timestamp format, which is the number of seconds since midnight Jan. 1, 1970. You can use this online tool to convert Unix Timestamps to date and time:

http://www.onlineconversion.com/unix_time.htm

[chris1979]

OK. Before I do this - which will be a lot of work - can you think of any easier way to update the poster id, time and date for posts? I remember in an older version of vbulletin being able to just edit them in the system.

[Marco van Herwaarden]

AFAIK that has never been a standard function of vBulletin. You might had a modification installed for this.

[chris1979]

Do you know if such a modification is available now?

[Marco van Herwaarden]

Sorry but i don't know. You could try to search at www.vbulletin.org (http://www.vbulletin.org).

[Jerry]

Because I cannot bulk import my old forum into my new vBulletin forum, ......

Out of interest, why not? What system is it?

[chris1979]

There are details here Jerry:
http://www.vbulletin.com/forum/showthread.php?t=207075

[Jerry]

Ah cart before the horse, I didn't make the connection.