[RELEASE v2] 0-Posters, active posters, inactive posters display hack.

Hello,
This hack will display members that have 0 posts, or are inactive, or are active in the memberlist.
(members that are longer than one month registered, and haven't been posted for a month will be displayed)

Tested on php 4.0.4pl1 and vB 2.0.1
I am still trying to make a hack to display the top 10 thread starters, if somebody can make this, please reply.

01. memberlist.php

Find,

PHP Code:

  if ($what=="datejoined") {
    $orderby="joindate";
    $direction="DESC";
  } 


Under it add,

PHP Code:

// memberlist hack v1.0 by demolition, aka addict
  if ($what=="0-posters") {
    $condition.=" AND posts<'1'";
    $orderby="";
    $direction="";
  }
  if ($what=="active") {
    $condition.=" AND posts>'0'";
    $orderby="posts";
    $direction="DESC";
  }
  if ($what=="inactive") {
    $lastmonth = mktime (0,0,0,date("m")-1,date("d"),date("Y"));
    $lastmonth2 = date("Y-m-d", $lastmonth);
    $condition.=" AND joindate<UNIX_TIMESTAMP('".addslashes(strtolower($lastmonth2))."') AND lastpost<UNIX_TIMESTAMP('".addslashes(strtolower($lastmonth2))."')";
    $orderby="posts";
    $direction="DESC";
  }
// end memberlist hack v1.0 by demolition, aka addict 


02. open index.php

Find,

PHP Code:

$numbermembers=$numbersmembers['users']; 


Under it add,

PHP Code:

// memberlist hack v1.0 by demolition, aka addict
$snonposters=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user WHERE posts=0');
$nonposters=$snonposters['users'];
$activemembers=$numbermembers-$nonposters;

$lastmonth = mktime (0,0,0,date("m")-1,date("d"),date("Y"));
$lastmonth2 = date("Y-m-d", $lastmonth);
$sinactive=$DB_site->query_first("SELECT COUNT(*) AS users,MAX(userid) AS max FROM user WHERE joindate<UNIX_TIMESTAMP('".addslashes(strtolower($lastmonth2))."') AND lastpost<UNIX_TIMESTAMP('".addslashes(strtolower($lastmonth2))."')");
$inactive=$sinactive['users'];
// end memberlist hack v1.0 by demolition, aka addict 


03. open your forumhome template, and place this code somewhere.

<A HREF="memberlist.php?s=$session[sessionhash]&what=0-posters">$nonposters 0-posters</A> | 
<A HREF="memberlist.php?s=$session[sessionhash]&what=active">$activemembers active members</A> | 
<A HREF="memberlist.php?s=$session[sessionhash]&what=inactive">$inactive non-active members</A>

04. done

[Admin]

[QUOTE]Originally posted by ShadowTech
One small bug I noticed ... the Active users also counts the Non-Active in the total number.

I dunno if it is just me.. so someone else who installed this .. add up the 3 numbers (0-posters, Active + Non active) and see if it's the same as your total registered members.

I tried changing the

PHP Code:

$activemembers=$numbermembers-$nonposters; 


to

PHP Code:

$activemembers=$numbermembers-$nonposters-$inactive; 

or

$activemembers=$numbermembers-($nonposters+$inactive); 


but it still didn't give me the right number for Active - inactive. All the original code is doing i removing the 0-posters from the total registered to get active.. so if a board has a lot of inactive members that have at least posted one.. you'll get some numbers that add up to a lot higher than total registered.

Again.. it's just a small bug.. but would be great to see a fix.

How do you reset this hack for a new month ??

I mean i've just been setting the board up and installed this hack and it shows 9 of my members as 0-posters ??? which i need to reset it to so 0 0-posters ???????

[mister]

Originally posted by FireFly

I'm having the same problem.

Yea.
I'm having the problem with the active + inactive != total

[mister]

i changed the calculation to this:

PHP Code:

$activemembers=$numbermembers-$inactive; 


and it seems to work, that is, inactive+active=total

would it be possible to add the number of users that have been banned or restricted???

[wolfe]

erm well its not working right because some of the inactive members are in the active members screen aswell someone help