Edit post time?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • nzlyoung
    New Member
    • Feb 2003
    • 2

    Edit post time?

    Can anybody tell me if it's possible to edit the time of individual post?
  • vBR
    Senior Member
    • Apr 2002
    • 1768

    #2
    You can change a post time by running a query on the db

    UPDATE post SET dateline = UNIX_TIMESTAMP('YYYY-MM-DD HH:MM') WHERE postid = {your post}

    Be sure to back up first.

    Comment

    • tubedogg
      Senior Member
      • Feb 2001
      • 13602

      #3
      You can get the postid of a post by mousing over the Edit link.

      Comment

      • nzlyoung
        New Member
        • Feb 2003
        • 2

        #4
        Originally posted by tubedogg
        You can get the postid of a post by mousing over the Edit link.
        Come on..... Plz be gentle with a newbie. What is the postid and how can I change the time with it?

        Comment

        • Steve Machol
          Former Customer Support Manager
          • Jul 2000
          • 154488

          #5
          This question has been answered. You find the postid by placing your mouse over the 'edit' link and looking at the URL in the browser window. Then to change the time you need to run the query vBR posted.

          To run queries you need phpMyAdmin. PhpMyAdmin is a MySQL database management tool. Most web hosts provide this as part of the web site management tools such as CPanel, Plesk or Ensim. Look for a link to SQL or MySQL Databases. If you can't find it I suggest you ask your host about this.

          If for some reason they do not provide phpMyAdmin or an equivalent MySQL manager, then you can download and install phpMyAdmin yourself from this location:

          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

          • sinjix_media
            Senior Member
            • Apr 2006
            • 199
            • 3.5.x

            #6
            this isnt working for 3.6.4
            3D Resources - A list of resources for 3D Developers
            After Effects Resources - A list of resources for design in motion with Adobe After Effects

            Comment

            • Steve Machol
              Former Customer Support Manager
              • Jul 2000
              • 154488

              #7
              That may be because you are responding to a thread that is almost 4 years old.
              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

              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
              Working...