Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 08 Oct 2012, 12:26
gregorym gregorym is offline
 
Join Date: Oct 2005
Question 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
Reply With Quote
  #2  
Old 09 Oct 2012, 11: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 12:44.
Reply With Quote
  #3  
Old 10 Oct 2012, 16: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
  #4  
Old 14 Oct 2012, 21: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 21:09.
Reply With Quote
  #5  
Old 14 Oct 2012, 22: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
Reply



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 05:36.

Layout Options | Width: Wide Color: