Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 01-05-2006, 05:25 PM
amoree amoree is offline
 
Join Date: Jan 2005
Posts: 6
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Replace the date in entire database

Hello,

Is there a way to replace the date in entire database ?

I have marage two database to my forum but i need to change all date that its on the old database from 2003 to 2005 because my old database its old and i need to change all the date from mysql Query by a command line such as

UPDATE post SET pagetext = REPLACE(pagetext,'2004','2005')

and if that command i sued its right how can i update it in my from so it will be shown with the new date?

also is there a way to change none english LANG in mysql because i used arabic fonts by using the same command but it wont work

Thanks and best regards
Reply With Quote
  #2  
Old 01-05-2006, 07:59 PM
AN-net's Avatar
AN-net AN-net is offline
 
Join Date: Dec 2003
Location: AnimationTalk.com
Posts: 2,367
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

the of the post or dates in posts?

if you want to change the date of post your query wont work as all dates are stored as EPOX timestamps which are calculated in seconds since 1969. a query that should work is
[sql]
UPDATE ~TABLEPREFIX~posts SET timestamp=timestamp+94348800
[/sql]
Reply With Quote
  #3  
Old 01-05-2006, 08:09 PM
amoree amoree is offline
 
Join Date: Jan 2005
Posts: 6
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hello,

Thanks for the fast replay

I need to change the user registertion and user post
from 2002 To 2005

For example if i want to change all posts year date that were made at 2002 to 2005 , what will be the correct formula? , in addition what i need to type in the timestamp , in the following code i wrote 2002 , also when i try to submit the query i get sql error , so whats the tableprefix that need to be typed? in the following code i removed the prefix and put post only cause there is no table called posts , just post.
also is this correct (94348800=3 years from 2003 to 2005 )?

HTML Code:
UPDATE post SET timestamp=2002+125798400
Reply With Quote
  #4  
Old 01-07-2006, 01:56 PM
amoree amoree is offline
 
Join Date: Jan 2005
Posts: 6
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hello,

No Answer (((
Reply With Quote
  #5  
Old 01-08-2006, 12:19 AM
AN-net's Avatar
AN-net AN-net is offline
 
Join Date: Dec 2003
Location: AnimationTalk.com
Posts: 2,367
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

sorry i really came up with that query out of my ass
but i was close
anyways here is what you're looking for
PLEASE KNOW THIS WILL UPDATE ALL POSTS!!!
[sql]
UPDATE ~TABLE_PREFIX~post SET dateline=dateline+9434880
[/sql]
replace ~TABLE_PREFIX~ with your table prefix you defined in config.php or if you do not have one just remove it.
Reply With Quote
Reply

Thread Tools
Display Modes

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 12:08 AM.


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.03832 seconds
  • Memory Usage 2,192KB
  • 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
  • (1)bbcode_html
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete