Register Members List Search Today's Posts Mark Forums Read

Thread Tools
Old 08 Oct 2012, 11:26
gregorym gregorym is offline
Join Date: Oct 2005
Question How to find users with links in signature


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.

Reply With Quote
Old 09 Oct 2012, 10:14
Simon Lloyd's Avatar
Simon Lloyd Simon Lloyd is offline
Join Date: Aug 2008
Real name: Simon
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
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

dont forget to change vb_ for your table prefix or remove it altogether if you dont use one.
Kind regards,
Simon Microsoft Office Help
My Mods: Find my modifications here
Please do not pm me for support unless i have invited you to!

Last edited by Simon Lloyd; 09 Oct 2012 at 11:44.
Reply With Quote
Old 10 Oct 2012, 15:13
squidsk's Avatar
squidsk squidsk is offline
Join Date: Nov 2010
The first condition in the where clause is redundant since you are performing the join on those fields.
Reply With Quote
Old 14 Oct 2012, 20:03
gregorym gregorym is offline
Join Date: Oct 2005
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.

Last edited by gregorym; 14 Oct 2012 at 20:09.
Reply With Quote
Old 14 Oct 2012, 21:40
kpmedia's Avatar
kpmedia kpmedia is offline
Join Date: Jan 2008
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.
FAQ: What are some HostGator alternatives? And who is EIG?
FAQ: What are the best web hosts and why?
And to all the vB plugin authors ... Thanks for making this a great app!
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

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

New To Site? Need Help?

All times are GMT. The time now is 21:02.

Layout Options | Width: Wide Color: