How to find users with links in signature

[gregorym]

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]

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]

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

[gregorym]

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]

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.