Extracting members with no home page URL

Ekka

Supporters
vBulletin Owner

#1 12-20-2007, 02:19 PM

Join Date: Aug 2007

Posts: 199

Location: Brisbane Australia

Extracting members with no home page URL

As a Christmas promotion I am going to make a single page SEO'd website for a winning member that doesn't have a website on my forum.

No Website? Enter draw here then for free one built by Ekka - Tree World

What I want to do is email or PM members that have that field empty in their profile.

Going through the various filters I noticed this option isn't there.

So, does anyone have an idea how I can do this other than sitting there going through all the members A to Z!?

--------------------
Public Tree Forum | Free Tree and Green Industry Links
Qualified Brisbane Tree Lopping
Brisbane Tree Care, Consultations and Arborist Reports

Quote |

acers

vBSetup Team
vBulletin Owner

#2 12-21-2007, 12:24 AM

Join Date: Dec 2006

Posts: 71

Re: Extracting members with no home page URL

A simple way of finding who all don't have the field filled up in their profile is to run this query in admincp (run sql query)

Quote:

SELECT userid, username FROM user where homepage = ''

if you used prefix, add that above in front of user

If you want to send a notification pm, you will have to add a similar code into a php file and depending on the number, send either a pm via a loop or use a delayed process so as not to overload your server.
Or maybe just set a flag that will be used to display a message to ask members to fill up that field.

--------------------
FunEnclave- Unlimited Fun!
TechEnclave- Technology Community!
Custom vBulletin Hacking