View Full Version : How to change the date of a post?
SnappedAgain
03-18-2006, 03:30 PM
<font size="4">I had an issue with the date and time being set wrong on my computer so all posts that were made within the last 24 hours say they were posted on 4/16/06 when really it should have been 3/16/06 So now that the date is set correctly when people post in those threads the NEW POSTS go ABOVE the old posts.
So does anyone know how I can change the date of certain posts so that I can get them all in order? I am assuming that I should be able to edit the dateline in the database manually but how do you decode the dateline value? Example: dateline value of a post is 1142577636 = 3/16/06 @ 11:40PM So how would I go about decoding that so I can edit the other posts?
TIA</font>
Carnage
03-18-2006, 03:47 PM
the time 1142577636 represents the time in seconds since 1/1/1970
In theory to put the posts back a day, all you need to do is usbtract 86400 from each of the numbers you wish to change.
Alternativly there is an advanced edit hack on here that allows admins to change the timestmp of posts from within the edit menu.
SnappedAgain
03-18-2006, 06:04 PM
the time 1142577636 represents the time in seconds since 1/1/1970
In theory to put the posts back a day, all you need to do is usbtract 86400 from each of the numbers you wish to change.
Alternativly there is an advanced edit hack on here that allows admins to change the timestmp of posts from within the edit menu.
WOW LMAO That's a lot of math for just changing the dates around HAHA. I think I will look for that hack. Thank you for the input ;)
filburt1
03-18-2006, 06:32 PM
Please don't change your font size as you post.
THere's no calculation that you need to do. http://www.php.net/time and http://www.php.net/date .
Code Monkey
03-18-2006, 06:57 PM
Why are you shouting like that?
Tralala
03-18-2006, 07:10 PM
Alternativly there is an advanced edit hack on here that allows admins to change the timestmp of posts from within the edit menu.
I know of two hacks:
https://vborg.vbsupport.ru/showthread.php?t=96351
https://vborg.vbsupport.ru/showthread.php?t=98737
SnappedAgain
03-19-2006, 01:28 AM
Please don't change your font size as you post.
THere's no calculation that you need to do. http://www.php.net/time and http://www.php.net/date .
WOW Im not trying to be a ++++ but if it's such a problem why don't you have the admin disable the font size function! I mean seriously is it that big a deal :ermm: It's just a habit.
Why are you shouting like that?
Shouting? LOL THIS IS SHOUTING :p
I know of two hacks:
https://vborg.vbsupport.ru/showthread.php?t=96351
https://vborg.vbsupport.ru/showthread.php?t=98737
Thanks man ;)
Tralala
03-19-2006, 01:37 AM
It's just a habit.
Strange habit.
SnappedAgain
03-19-2006, 02:21 AM
Strange habit.
haha my bad. Well I will try to remember not to do it on this forum ;)
Funny how the stupidest things bother people :p
Tralala
03-19-2006, 05:43 AM
haha my bad. Well I will try to remember not to do it on this forum ;)
Funny how the stupidest things bother people :p
First sentence: well done, thanks, much appreciated.
Second sentence: not so much.
SnappedAgain
03-19-2006, 06:11 AM
Second sentence: not so much.
This comment fits right in there with my "Funny how the stupidest things bother people" comment ;)
Tralala
03-19-2006, 07:34 AM
Hilarious.
filburt1
03-19-2006, 02:04 PM
Alright already.
vBulletin® v3.8.12 by vBS, Copyright ©2000-2024, vBulletin Solutions Inc.