|
Joined: Jun 2000
Posts: 190
Enthusiast
|
Enthusiast
Joined: Jun 2000
Posts: 190 |
I had a message posted back on July 17th of 2003, which was made sticky on that date. Recently, I unstickied that post, but the original date wasn't returned. It now says July 17, 2004. Is there a way to change the date of this post back to it's correct original date?
Jeff
Artificial Intelligence is no match for natural stupidity!
|
|
|
|
Joined: Mar 2000
Posts: 528
Junior Member
|
Junior Member
Joined: Mar 2000
Posts: 528 |
UPDATE w3t_Posts SET B_Posted='1058421600' WHERE B_Number='post#'
Just have to know the Post # itself and use the above.
|
|
|
|
Joined: Jun 2000
Posts: 190
Enthusiast
|
Enthusiast
Joined: Jun 2000
Posts: 190 |
Medar, That didn't work??? Here's the URL for the post: http://www.the-highway.com/forum/showthr...=14&fpart=1 And here's the command line I ran in the Admin Database utility: UPDATE w3t_Posts SET B_Posted='1058421600' WHERE B_Number='23570' So, this brings up two questions: 1) What happened when I ran that command; i.e., what did I screw up? hehe 2) What command will effect the change back to 2003? CLARIFICATION: When you actually view the post itself, the date shows correctly in the header. But when you view the list of threads for that Forum, in the "LAST POST" column, the date is incorrect; 2004 instead of 2003, and consequently, it is displayed as a recent post. I hope that bit of information helps? Jeff
Last edited by Pilgrim; 02/18/2004 5:02 PM.
Artificial Intelligence is no match for natural stupidity!
|
|
|
|
Joined: Mar 2000
Posts: 528
Junior Member
|
Junior Member
Joined: Mar 2000
Posts: 528 |
Change B_Posted to B_Last_Post, that should do the trick.
|
|
|
|
Joined: Jun 2000
Posts: 190
Enthusiast
|
Enthusiast
Joined: Jun 2000
Posts: 190 |
Artificial Intelligence is no match for natural stupidity!
|
|
|
|
Joined: Mar 2000
Posts: 528
Junior Member
|
Junior Member
Joined: Mar 2000
Posts: 528 |
woot! I didn't stop to think about the fact it would have to "possibly" be changed in both places. But in your case, it did.
|
|
|
|
Joined: Mar 2000
Posts: 180
Member
|
Member
Joined: Mar 2000
Posts: 180 |
[]UPdate w3t_posts SET B_posted='1058421600' WHERE B_Number='post#'[/]
In that command to change the post date, how does "1058421600" correspond to July 17, 2003? That is, I'm wanting to use this command, but how do I set the B_posted to a certain date?
Thanks!
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
That's Epoch time, which is what's used in the Post table. Epoch time is the number of seconds since like Jan 1, 1970. I have a little time converter here for your use if needed; http://www.joshuapettit.com/time.php
|
|
|
|
Joined: Mar 2000
Posts: 180
Member
|
Member
Joined: Mar 2000
Posts: 180 |
As usual, many thanks, Josh!
|
|
|
|
Joined: Mar 2000
Posts: 180
Member
|
Member
Joined: Mar 2000
Posts: 180 |
I'm playing around with the merge threads mod and changing the post dates...I executed both commands above, but the time/date on the main forum page doesn't change? And, it's kinda screwing with the merge feature...how do I fix that?
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
Well the stuff on the main index (last post info) would be stored in the w3t_Boards table. That shouldn't have any effect on the merge threads mod. I won't make any guarantees that you can change the date and merge an old thread into a new. I had oodles of errors and problems before this mod checked for that. I'm not positive that Threads can display the posts (numerically) out of order without "undefined index errors". So use caution. I haven't tested doing that, but something does remind me that there were issues before I added checking for such things.
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 69
Joined: January 2001
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|