vb.org Archive - Search for image URL?

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

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

- - Search for image URL? (https://vborg.vbsupport.ru/showthread.php?t=325327)

Dan49

07-04-2017 06:37 PM

Search for image URL?

Is there a way to search the forum for specific image URLs? The photobucket situation left me scrambling to replace pics and I need to be able to find them.

PinkMilk

07-06-2017 06:23 PM

I would suggest a database query to search:

Code:

SELECT * FROM prefix_post WHERE pagetext LIKE '%www.photobucket.com%';

% are wild cards meaning you are likely to get more than one result, if you know the exact string of text your looking for they can be removed, they simply help with not having to worry about knowing weather the url starts with http or https in the first instance and any thing after in the second.

or to search and replace:

Code:

UPDATE prefix_post SET pagetext = REPLACE(pagetext, 'photobucket', 'tinypic');

if you have table prefixes you will need to add these to query lines as highlighted else remove.

Always remember to make backup of db.

All times are GMT. The time now is 12:11 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01477 seconds Memory Usage 1,707KB 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 (2)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (2)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: