Don't show users with 0 posts in memberlist

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:

PHP Code:

$condition = '1=1'; 


Below, add:

PHP Code:

$condition.=" and user.posts != 0"; 


That's it! All done!

[rebelsrock06]

Originally Posted by Diva

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

theres an option for this in the admin Cp

[rebelsrock06]

Originally Posted by 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]

Originally Posted by rebelsrock06

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!