Announcement

Collapse
No announcement yet.

Changing order of threads

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

  • Changing order of threads

    Hi, is there a way to put threads in between threads? We are making a news archive with a vB forum and some of the updates were missed, but all of the posts are made in order by date (which goes back to 1999) SO we need a way to stick the ones we missed into the right places, along with the month/year/ etc. Is there anyway to do that?

  • #2
    You would have to manually change the date of these posts in the database.
    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
      And if I did, they would fall into the right place, correct? If so, you saved me a lot of trouble.

      Comment


      • #4
        If you do it right, yes. You need to go into phpMyAdmin and modify the dateline column in the post table and enter the unix timestamp that you want. You can use this online tool to convert dates and times to Unix Timestamps:

        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


        • #5
          Originally posted by Steve Machol
          If you do it right, yes. You need to go into phpMyAdmin and modify the dateline column in the post table and enter the unix timestamp that you want. You can use this online tool to convert dates and times to Unix Timestamps:

          http://www.onlineconversion.com/unix_time.htm
          Thank you so much! This is exactly what I needed.

          I may be back soon if I mess anything up, though.

          Comment


          • #6
            whew, ok. i'm lost already. how do i find a date for a specific post within the dateline column in the post table? i found the column and selected change and all I see is some drop down options and some testboxes. what now?

            Comment


            • #7
              Originally posted by zachb
              Thank you so much! This is exactly what I needed.

              I may be back soon if I mess anything up, though.
              update thread set dateline = UNIX_TIMESTAMP ('YYYY-MM-DD') where threadid = XX

              Use the appropriate date and change XX for each thread as appropriate.
              Translations provided by Google.

              Wayne Luke
              The Rabid Badger - a vBulletin Cloud demonstration site.
              vBulletin 5 API - Full / Mobile
              Vote for your favorite feature requests and the bugs you want to see fixed.

              Comment


              • #8
                update thread set dateline = 906106734 ('1998-09-18') where threadid = 320

                that is the query i ran in phpmyadmin, and i got an error. what did i do wrong?

                here is the error:

                You have an error in your SQL syntax near '('1998-09-18') where threadid = 320' at line 1

                Comment


                • #9
                  Originally posted by zachb
                  update thread set dateline = 906106734 ('1998-09-18') where threadid = 320

                  that is the query i ran in phpmyadmin, and i got an error. what did i do wrong?

                  here is the error:

                  You have an error in your SQL syntax near '('1998-09-18') where threadid = 320' at line 1
                  bump.

                  Comment


                  • #10
                    Try this instead:

                    update thread set dateline = UNIX_TIMESTAMP ('1998-09-18') where threadid = 320
                    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


                    • #11
                      thanks!

                      Comment


                      • #12
                        nope, still getting the same error, only with UNIX_TIMESTAMP instead of the numbers.

                        Comment


                        • #13
                          Well it's Wayne's query so I'm not quite sure what may be wrong. Try this:

                          update thread set dateline = UNIX_TIMESTAMP('".addslashes(YYYY-MM-DD)."') where threadid = xxx
                          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


                          • #14
                            Originally posted by Steve Machol
                            Well it's Wayne's query so I'm not quite sure what may be wrong. Try this:

                            update thread set dateline = UNIX_TIMESTAMP('".addslashes(YYYY-MM-DD)."') where threadid = xxx
                            Addslashes won't work as that is a PHP function not a MySQL function. You need to remove the space from between UNIX_TIMESTAMP and the Opening Parenthesis. With that simple change, it works fine on my database. I guess the MySQL interpretor is whitespace sensitive. Very bad design move.
                            Translations provided by Google.

                            Wayne Luke
                            The Rabid Badger - a vBulletin Cloud demonstration site.
                            vBulletin 5 API - Full / Mobile
                            Vote for your favorite feature requests and the bugs you want to see fixed.

                            Comment


                            • #15
                              Ah, thanks for that Wayne. I got the 'addslashes' from one of the php files. I should have known better!
                              Last edited by Steve Machol; Wed 27 Nov '02, 8:32pm.
                              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

                              Loading...
                              Working...
                              X