Changing order of threads

[zachb]

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?

[Steve Machol]

You would have to manually change the date of these posts in the database.

[zachb]

And if I did, they would fall into the right place, correct? If so, you saved me a lot of trouble.

[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

[zachb]

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.

[zachb]

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?

[Wayne Luke]

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.

[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

[zachb]

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.

[Steve Machol]

Try this instead:

update thread set dateline = UNIX_TIMESTAMP ('1998-09-18') where threadid = 320

[zachb]

thanks!

[zachb]

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

[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

[Wayne Luke]

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.

[Steve Machol]

Ah, thanks for that Wayne. I got the 'addslashes' from one of the php files. I should have known better!