The Arcive of Official vBulletin Modifications Site.

Sort Memberlist by Usergroup · **Released**: 02-22-2009

Sort Memberlist by Usergroup by

This Product brought to you by
www.vbulletin-turkey.com

Description: This plugin will sort the memberlist by Usergroup

Install Instructions

Open your memberlist.php file with an editor and find this code

PHP Code:


			
$sorturl = 'memberlist.php?' . $vbulletin->session->vars['sessionurl'] . $sortaddon;

Replace it with this code

PHP Code:


			
$sorturl = 'memberlist.php?do=getall&amp;groupid=' . $groupid . '' . $vbulletin->session->vars['sessionurl'] . $sortaddon;

than find this code

PHP Code:


			
. (!empty($vbulletin->GPC['perpage']) ? "&amp;pp=$perpage" : "")

Replace it with this code

PHP Code:


			
. (!empty($vbulletin->GPC['groupid']) ? "&amp;groupid=$groupid" : "")

. (!empty($vbulletin->GPC['perpage']) ? "&amp;pp=$perpage" : "")

Save and re-upload overwrite to forum folder.

------------------------------------------------------------------------------------------------

Edit memberlist_letter template and REPLACE all of content with this code

HTML Code:

<if condition="$show['selectedletter']">
<td class="alt1" width="3%">[<strong>$currentletter</strong>]</td>
<else />
<td class="alt2" width="3%"><a href="memberlist.php?$session[sessionurl]do=getall&amp;groupid=$groupid&amp;ltr=$linkletter&amp;pp=$perpage&amp;sort=$sortfield&amp;order=$sortorder$usergrouplink$ltrurl">$currentletter</a></td>
</if>

Edit memberlist template and find this code

HTML Code:

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr align="center">
    $letterbits
</tr>
</table>

Replace it with this code

HTML Code:

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<td colspan="30" height="16" class="thead">
<tr align="center">
    $letterbits
</tr>
</table>
<br/>
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<td colspan="30" height="16" class="thead">
<tr align="center">
<td class="alt2" width="15%" valign="middle" align="left">
<div class="smallfont"><b>$vbphrase[usergroups]:</b></div>
</td>
<td class="alt1" width="85%" valign="middle" align="center">
<div class="smallfont">$usergrouplinks</div></td>
</tr>
</table>

And Save.

at least import the .xml product .xml file via admincp / product manager.

Tested on: vBulletin 3.8.1

Online Demo: www.vbulletin-turkey.com/forum/memberlist.php?langid=1

FFTFTCEd · #22 03-22-2009, 12:08 AM

Nice Mod, works fine... Is there a way to select only certain usergroups to be displayed?? I have some that I don't need showing and want to disable the mod for those.

Thanks,
Ed

oz_girl · #23 07-13-2009, 10:25 AM

Reserved

archet1337 · #24 09-17-2009, 06:57 PM

How to add another usergroup?

I've been looking at this without figuring out how to add another group. I would like to have usergroup #9 to this list.

I'm a novice when it comes to php, so it would be awesome if someone could point me in the right direction

PHP Code:


			
// Sort Memberlist by Usergroups by Hasann

$usergrouplinks = '';

$fetch_usergroups = $vbulletin->db->query_read_slave("

SELECT ".TABLE_PREFIX."usergroup.usergroupid, ".TABLE_PREFIX."usergroup.title,

COUNT(".TABLE_PREFIX."user.userid) AS membercount

FROM ".TABLE_PREFIX."usergroup

LEFT JOIN ".TABLE_PREFIX."user

ON ".TABLE_PREFIX."user.usergroupid=".TABLE_PREFIX."usergroup.usergroupid

OR FIND_IN_SET(".TABLE_PREFIX."usergroup.usergroupid, ".TABLE_PREFIX."user.membergroupids)

WHERE (".TABLE_PREFIX."usergroup.genericoptions & " . $vbulletin->bf_ugp_genericoptions['showmemberlist'] . ")

GROUP BY ".TABLE_PREFIX."usergroup.usergroupid

ORDER BY ".TABLE_PREFIX."usergroup.title ASC

");



while ($usergroups = $vbulletin->db->fetch_array($fetch_usergroups))

{

  $do_not_include = array(1,3,4);

    if (!in_array($usergroups['usergroupid'], $do_not_include))

    {

    $usergrouplinks .= '<a href="memberlist.php?do=getall&amp;groupid='.$usergroups['usergroupid'].'"><b>'.$usergroups['title'].'</b> (<b>'.$usergroups['membercount'].'</b>)</a>&nbsp;&nbsp;&nbsp;';    

    }

}



if (intval($groupid) > 0)

{

$condition .= ' AND (FIND_IN_SET(\''.$groupid.'\', membergroupids) OR user.usergroupid = '.$groupid.')';

}

archet1337 · #25 09-20-2009, 05:29 PM

anyone?

Scalemotorcars · #26 10-22-2009, 04:20 PM

Quote:

Originally Posted by archet1337

How to add another usergroup?

I've been looking at this without figuring out how to add another group. I would like to have usergroup #9 to this list.

I'm a novice when it comes to php, so it would be awesome if someone could point me in the right direction

PHP Code:


			
// Sort Memberlist by Usergroups by Hasann

$usergrouplinks = '';

$fetch_usergroups = $vbulletin->db->query_read_slave("

SELECT ".TABLE_PREFIX."usergroup.usergroupid, ".TABLE_PREFIX."usergroup.title,

COUNT(".TABLE_PREFIX."user.userid) AS membercount

FROM ".TABLE_PREFIX."usergroup

LEFT JOIN ".TABLE_PREFIX."user

ON ".TABLE_PREFIX."user.usergroupid=".TABLE_PREFIX."usergroup.usergroupid

OR FIND_IN_SET(".TABLE_PREFIX."usergroup.usergroupid, ".TABLE_PREFIX."user.membergroupids)

WHERE (".TABLE_PREFIX."usergroup.genericoptions & " . $vbulletin->bf_ugp_genericoptions['showmemberlist'] . ")

GROUP BY ".TABLE_PREFIX."usergroup.usergroupid

ORDER BY ".TABLE_PREFIX."usergroup.title ASC

");



while ($usergroups = $vbulletin->db->fetch_array($fetch_usergroups))

{

  $do_not_include = array(1,3,4);

    if (!in_array($usergroups['usergroupid'], $do_not_include))

    {

    $usergrouplinks .= '<a href="memberlist.php?do=getall&amp;groupid='.$usergroups['usergroupid'].'"><b>'.$usergroups['title'].'</b> (<b>'.$usergroups['membercount'].'</b>)</a>&nbsp;&nbsp;&nbsp;';    

    }

}



if (intval($groupid) > 0)

{

$condition .= ' AND (FIND_IN_SET(\''.$groupid.'\', membergroupids) OR user.usergroupid = '.$groupid.')';

}

If I understand correctly all you need to do is edit the usergroup and allow it to be seen in the member list.

Same goes for removing a usergroup from those displayed in the memberlist.

Hassan...

Great mod and exactly what I was looking for. Thanks. Installed. :up:

ClanAH · #27 01-01-2010, 09:04 AM

Is there a way to get the Usergroups that are listed to show up in a specific order to my choice as opposed to having it in alphabetical order? For instance, if I wanted to set it up so it shows in order of Highest to Lowest Rank on the forums (Usergroups = Ranks).

nando99 · #28 05-12-2010, 04:02 PM

great mod... i was wondering, how would i display the current user group being displayed?

thanks in advance...

Mike09 · #29 07-17-2010, 05:03 AM

Any plans for a v4.0 release, Hasann?
This is definitely useful and I would love to see an update.

Appreciate your work, thanks!

optimatez · #30 07-28-2010, 03:39 PM

I installed this and it works and i love it, but for some reason the theme on this page is making the colors of the boxs alternating colors. Is there a way to fix this?
http://www.teampulverize.com/forums/memberlist.php

you will notice the last 3 columns have a checkered box pattern. Each column should be one color.
thanks!

mgurain · #31 10-31-2010, 10:48 AM

Hi,
I was looking for a mod to list members of a group,
and I wonder why it is not a standard feature in the product ?
- Can you make this a product import only (no modification) ?
thanks,,

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04760 seconds Memory Usage 2,380KB Queries Executed 27 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (3)bbcode_html (6)bbcode_php (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (4)navbar_link (120)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (2)postbit_attachment (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_attachment postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!