Go Back   vBulletin Setup > vBulletinSetup Information > vBulletin Questions


Please Register to get full access to the forums.
Post New Thread  Reply



#1   12-20-2007, 02:19 PM
Ekka has a spectacular aura about 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!?
Quote   |  



#2   12-21-2007, 12:24 AM
acers will become famous soon enough 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
Quote   |  



#3   12-21-2007, 10:45 PM
Ekka has a spectacular aura about Join Date: Aug 2007 Posts: 199 Location: Brisbane Australia
Re: Extracting members with no home page URL


Phew, couldn't pull that off so I sort of compromised with a Christmas email plus the competition.

Thanks anyway, those SQl query thing SUCK frankly.
Quote   |  
Post New Thread  Reply
vBulletin Setup > vBulletinSetup Information > vBulletin Questions


Thread Tools
Display Modes

 
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
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Is the home page messed up ? Brandon Feedback and Suggestions 11 10-28-2007 03:01 PM
Removing CSS code from home page Cleck vBulletin SEO Tips and SEO Questions 3 07-08-2007 03:21 PM
how do I show sub-forums im home-page? sghackx vBulletin Questions 4 03-03-2007 01:26 PM
I need help removing a gap on the home page... aj8690 vBulletin Questions 4 01-13-2007 10:26 PM


All times are GMT -6. The time now is 04:32 AM.

vBulletin Setup, vBulletin Setup Forums, vBulletin Services, vBulletin Blogs, vBulletin SEO, vBulletin Questions
vBulletin Skins, Styles, Templates, vBulletin Monetization, Blogs, vBulletin Link Directory,Quality Link Directory