Don't show users with 0 posts in memberlist

[Gary King]

Please click on INSTALL if you installed this hack! Thanks!

What does this hack do?

It will remove all users with 0 posts from the members list, so that they can't be found by other members. This is useful if you want to show only the active users, who have made at least one post, instead of the ones who only register to use member-only functions ;)

*NOTE: Ported over from my own version of this hack for vBulletin 2.

Instructions

Open memberlist.php and find:
$condition = '1=1';


Below, add:$condition.=" and user.posts != 0";


That's it! All done! :D

[Allan]

thank You Gary to divide it :)

[FleaBag]

Nice and simple, but effective. Thanks.

[Dark_Wizard]

Nice and simple, but effective. Thanks.

Agreed! Nice little hack....

[Gary King]

Thanks :)

[Chris Gwynne]

Sweet little hack, will use this. :)

[mini2]

You could do this with conditionals too?

Edit memberlist_resultsbit.

For the first line put: <if condition="$userinfo[posts] != 0">
For the last line put: </if>

Job done, no files edited.

Just an alternative. A nice idea too, never thought of doing that but it could save on a lot of "noise" or useless entries.

[subduck]

^^ nice

[SmasherMaster]

This hack rocks, thanks for it!

/me hits install.

[Diva]

This is fantastic! My list went from 15 pages to 5.

[rebelsrock06]

This is fantastic! My list went from 15 pages to 5.
theres an option for this in the admin Cp

[rebelsrock06]

theres an option for this in the admin Cp
heres a screeny


its in VB options > user listing and profile viewing

[Gizmo]

Thx Gary, i've taken it for translating into french.

[Aleksey]

It says

Database error in vBulletin 3.0.0:

Invalid SQL:
SELECT COUNT(*) AS users
FROM user AS user
LEFT JOIN userfield AS userfield USING (userid)
WHERE and user.posts != 0
AND user.usergroupid IN (0,6,7,2,5)

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'and user.posts != 0
AND user.usergroupid IN (0,6,7,2,5)' at

mysql error number: 1064

Date: Sunday 28th of March 2004 09:45:09 PM
Script: http://www.hellforums.com/memberlist.php?
Referer: http://www.hellforums.com/
Username: Aleksey
IP Address: xx.xxx.xxx.x


why does it say that?

[Aleksey]

nvm I fixed it.

[JaNa]

Man, so small, yet so useful!

[Eternal2u]

heres a screeny


its in VB options > user listing and profile viewing


Read that guyz post..

this mod is REALLY un-nessary..i'm running vb 3.01 and it ++++s it when i tried rpling it through ftp..so yea..

And as rebelsrock said, it's already built into the admin panel, and it gives ALOT more options then this "simple" mod..

..Sorry man, but a big thumb's down on this one..

[Gossamer175]

Good job, this hack will definitely come in handy.

[M.C.]

PEOPLE!!!! YOU`re DEFINITLY BLIND :)

[JagFan]

Nice mod! :)

[Keyser S?ze]

You could do this with conditionals too?

Edit memberlist_resultsbit.

For the first line put: <if condition="$userinfo[posts] != 0">
For the last line put: </if>

Job done, no files edited.

Just an alternative. A nice idea too, never thought of doing that but it could save on a lot of "noise" or useless entries.


IMO this is much much better, template mods rock :D

but question what if i wanted to not display anyone under 7 posts? i tried !<7 but that didnt work

[Keyser S?ze]

Read that guyz post..

this mod is REALLY un-nessary..i'm running vb 3.01 and it ++++s it when i tried rpling it through ftp..so yea..

And as rebelsrock said, it's already built into the admin panel, and it gives ALOT more options then this "simple" mod..

..Sorry man, but a big thumb's down on this one..


gah i feel dumb ;p, need to go read the manual

[Flow Fusion]

Thanks this is great

[Infopro]

Yep its built in already. No need to hack.

[Noiz Pollution]

You'd think people might read the rest of the thread before replying...

[turbidblue]

thanks! i meant to click reply last week but forgot!!

very nice :)

* turbidblue finally clicks install ;)

[nexialys]

can we tag this thread as "INCLUDED IN 3.0.1" ??

btw, would be good to tag all hacks that already include in the last release...

[HakkieDEV]

Thanks mate, this comes in handy!

[Polo]

This should stay here... even though is already in the admincp I believe is only available on 3.0.1 and newer versions.. this might come handy for those who havent updated their vbulletin board..