Conditional Member List Display?

[sktung]

I just recently purchased VBulletin and find it does almost everything I need out of the box. However, I am struggling with something that seems like it should be fairly simple.

I have created an optional profile field with a text input which works great.

What I would like to do is have the Members List ONLY display users that have chosen to fill that particular optional profile field (do not display the member if the field is blank).

I am not sure if I should edit the memberlist.php or the template? In the members.php, I have identified the field as profilefieldid=7 but not really sure where to progress from here.

Also, I have tried playing with conditionals but can not seem to get this to work properly.

Any help would be greatly appreciated.

[Lynne]

Probably just hook into the two queries (userlist count and actual list) and add into the WHERE clause to only grab users where that field is not null.

[sktung]

Lynne,

Thanks for the prompt response but I am fairly incompetent at this.

I assume that you are talking about conditionals in the memberlist or memberlist_resultsbit template?

Can you show me an example of how to do the WHERE conditional using Not Null as the condition?

Thanks for any input - I have been struggling with this for quite some time now...

[Lynne]

No, I was actually thinking you would have to write a couple of plugins - Plugin System - using those hook locations I mentioned. I'm not really sure since it's nothing I've ever tried, but looking at the memberlist.php page, that is what it looks like you could do (that is where the queries are).