vb.org Archive - How to find users with links in signature

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

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

- - How to find users with links in signature (https://vborg.vbsupport.ru/showthread.php?t=288772)

gregorym

10-08-2012 10:26 AM

How to find users with links in signature

Hi,

Is there a way to retrieve the list of users that have a link in their signature?
I'd like to mass PM them but can't find a way to segment only those with links in their sigs.

Thanks

Simon Lloyd

10-09-2012 09:14 AM

Hmmm, you'd have to do a join query to get the username from the username table but in order to get a list of those with links in thier signature this should work in admincp>maintainance>execute sql query

PHP Code:


		
			
select distinct f.username 
from vb_user f 
inner join vb_sigparsed u 
on u.userid = f.userid 
where u.userid= f.userid AND signatureparsed like"%<a href%" OR signatureparsed like"%http://%" OR signatureparsed like "%www.%"

dont forget to change vb_ for your table prefix or remove it altogether if you dont use one.

squidsk

10-10-2012 02:13 PM

The first condition in the where clause is redundant since you are performing the join on those fields.

gregorym

10-14-2012 07:03 PM

I tried this query but it returns an error:
'mydaabase.vb_user' doesn't exist
Any idea how to fix this error?

Edit: I have not prefix for some reason :) that's why. Thanks.

kpmedia

10-14-2012 08:40 PM

You can mass mail easily. Just search for "url" instead of by username or other criteria.

You could also search for users, export the returned user list, and then copy/paste users into a PM "to". Be sure your PM permissions are (at least temporarily) large enough to allow more than the standard 5 concurrent recipients.

In my opinion, both are easier than rewriting PHP (or writing plugins), unless this is more than a one-off activity.

Several ways to skin this cat. :)

All times are GMT. The time now is 06:48 AM.

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