Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 03-18-2006, 03:30 PM
SnappedAgain SnappedAgain is offline
 
Join Date: Aug 2004
Posts: 55
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default How to change the date of a post?

<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>
  #2  
Old 03-18-2006, 03:47 PM
Carnage Carnage is offline
 
Join Date: Jan 2005
Location: uk
Posts: 760
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
  #3  
Old 03-18-2006, 06:04 PM
SnappedAgain SnappedAgain is offline
 
Join Date: Aug 2004
Posts: 55
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Carnage-
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
  #4  
Old 03-18-2006, 06:32 PM
filburt1 filburt1 is offline
 
Join Date: Feb 2002
Location: Maryland, US
Posts: 6,144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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 .
  #5  
Old 03-18-2006, 06:57 PM
Code Monkey's Avatar
Code Monkey Code Monkey is offline
 
Join Date: May 2004
Posts: 1,080
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Why are you shouting like that?
  #6  
Old 03-18-2006, 07:10 PM
Tralala's Avatar
Tralala Tralala is offline
 
Join Date: Jan 2006
Posts: 1,207
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Carnage-
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
  #7  
Old 03-19-2006, 01:28 AM
SnappedAgain SnappedAgain is offline
 
Join Date: Aug 2004
Posts: 55
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by filburt1
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.

Quote:
Originally Posted by JumpD
Why are you shouting like that?
Shouting? LOL THIS IS SHOUTING

Thanks man
  #8  
Old 03-19-2006, 01:37 AM
Tralala's Avatar
Tralala Tralala is offline
 
Join Date: Jan 2006
Posts: 1,207
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by SnappedAgain
It's just a habit.
Strange habit.
  #9  
Old 03-19-2006, 02:21 AM
SnappedAgain SnappedAgain is offline
 
Join Date: Aug 2004
Posts: 55
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Tralala
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
  #10  
Old 03-19-2006, 05:43 AM
Tralala's Avatar
Tralala Tralala is offline
 
Join Date: Jan 2006
Posts: 1,207
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by SnappedAgain
haha my bad. Well I will try to remember not to do it on this forum

Funny how the stupidest things bother people

First sentence: well done, thanks, much appreciated.

Second sentence: not so much.
Closed Thread


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 07:30 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04493 seconds
  • Memory Usage 2,255KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (8)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete