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

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - [RELEASE v2] 0-Posters, active posters, inactive posters display hack. (https://vborg.vbsupport.ru/showthread.php?t=22281)

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.

Code:

<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

Nice Hack,
If u wanna see it visit our Board
(its on f2s till our webserver is rdy for php4)
i've translate it in german but u can see it working.

but there ist a small error in your code:

Quote:

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

it must be:

Quote:

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

sorry for my bad english

greets
AS_Eagle_1
(Sascha)

lol, forgot that sorry :D

btw, how did you do that clan listing in your memberlist?

this clan listing is verry simple.
i've greated a user profile field and make it as a necesarry field.
then i've added a new colume in the memberlist template and added in the memberlistbit

Quote:

<td bgcolor="#DFDFDF" align="center"><normalfont>$userinfo[field5]</normalfont></td>

[field5] must be replace with the id of the userfield.

if u wanna show the content of this field in the posts under the usrs name like location read this thread:
http://www.vbulletin.com/forum/showt...ld+%24userinfo

Maybe you'de like to combine it with my activity rate hack posted some time ago:
http://www.vbulletin.com/forum/showt...threadid=19227

this could be a nice hack to add to my board..

thx

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;

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.

I?ve modified this hack, now it shows users with one post.

01. memberlist.php

find

PHP Code:


		
			


  if ($what=="0-posters") {

    $condition.=" AND posts<'1'";

    $orderby="";

    $direction="";

  }

under it add

PHP Code:


		
			
  if ($what=="oneposters") {

    $condition.=" AND posts<'2' AND posts>'0'";

    $orderby="";

    $direction="";

  }

02. index.php

find

PHP Code:


		
			
$snonposters=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user WHERE posts=0');

$nonposters=$snonposters['users'];

$activemembers=$numbermembers-$nonposters;

under it add:

PHP Code:


		
			
$soneposters=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) FROM user WHERE posts=1');

$oneposters=$soneposters['users'];

03. forumhome template

find:

Quote:

<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>

under it add:

Quote:

<A HREF="memberlist.php?s=$session[sessionhash]&what=oneposters">$oneposters Users with one post</A>

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (10)bbcode_php_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01094 seconds Memory Usage 1,773KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (10)bbcode_php_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: