vb.org Archive
Page 3 of 4 12 3 4
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Mini Mods - Sort Memberlist by Usergroup (https://vborg.vbsupport.ru/showthread.php?t=206295)

FFTFTCEd 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 07-13-2009 10:25 AM
Reserved :)

archet1337 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 09-20-2009 05:29 PM
anyone?

Scalemotorcars 10-22-2009 04:20 PM
Quote:
Originally Posted by archet1337 (Post 1886572)
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 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 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 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 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 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,,


All times are GMT. The time now is 02:13 PM.
Page 3 of 4 12 3 4
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01038 seconds
  • Memory Usage 1,765KB
  • 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
  • (2)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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