vb.org Archive - Replace text in all posts....like Replacing Phrases

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Replace text in all posts....like Replacing Phrases (https://vborg.vbsupport.ru/showthread.php?t=112179)

Jordan17

04-04-2006 08:35 PM

Replace text in all posts....like Replacing Phrases

I have just changed the name of my forum, and also the domain to it, I want to change all of the text in posts to the new name.

You may think its pointless, but people have got links all over the place that wont work anymore.

Is there any way I can do this by replacing, like when you search for text in phrases and replace it?

SaN-DeeP

04-05-2006 12:04 AM

to replace text in posts.

Code:

UPDATE post SET pagetext = REPLACE(pagetext,'www.olddomain.com','www.newdomain.com')

replace text in pms.

Code:

UPDATE pmtext SET message = REPLACE(message,'www.olddomain.com','www.newdomain.com')

to replace text in signatures.

Code:

UPDATE usertextfield SET signature = REPLACE(signature,'www.olddomain.com','www.newdomain.com')

you can acheive what you want from above queries :)

majorxp

05-22-2006 02:43 PM

Thanks...this is exactly what I was looking for.

I also ran this too:

PHP Code:


		
			
UPDATE smilie SET smiliepath = REPLACE(smiliepath, 'olddomain.com', 'newdomain.com')

All times are GMT. The time now is 07:52 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00964 seconds Memory Usage 1,711KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: