Announcement

Collapse
No announcement yet.

The date and time of posts

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • The date and time of posts

    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?

  • #2
    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
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      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.

      Comment


      • #4
        AFAIK that has never been a standard function of vBulletin. You might had a modification installed for this.
        Want to take your board beyond the standard vBulletin features?
        Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

        Comment


        • #5
          Do you know if such a modification is available now?

          Comment


          • #6
            Sorry but i don't know. You could try to search at www.vbulletin.org.
            Want to take your board beyond the standard vBulletin features?
            Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

            Comment


            • #7
              Originally posted by chris1979 View Post
              Because I cannot bulk import my old forum into my new vBulletin forum, ......
              Out of interest, why not? What system is it?
              I wrote ImpEx.

              Blog | Me

              Comment


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

                Comment


                • #9
                  Ah cart before the horse, I didn't make the connection.
                  I wrote ImpEx.

                  Blog | Me

                  Comment

                  Loading...
                  Working...
                  X