Mini Mods - Sort Memberlist by Usergroup

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&groupid=' . $groupid . '' . $vbulletin->session->vars['sessionurl'] . $sortaddon; 


than find this code

PHP Code:

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


Replace it with this code

PHP Code:

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


Save and re-upload overwrite to forum folder.

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

Edit memberlist_letter template and REPLACE all of content with this 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

<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

<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

[Hasann]

Reserved.

[fahl]

Getting error

Parse error: syntax error, unexpected T_STRING in /home/warez08/public_html/forums/memberlist.php on line 490

[Hasann]

Originally Posted by fahl

Getting error

Parse error: syntax error, unexpected T_STRING in /home/warez08/public_html/forums/memberlist.php on line 490

did you made all file edits?

which version of vbulletin do you use?

[TandyServices]

database errors here.

Database error in vBulletin 3.8.1:
Invalid SQL:
SELECT vb_usergroup.usergroupid, vb_usergroup.title,
COUNT(vb_user.userid) AS membercount
FROM vb_usergroup
LEFT JOIN vb_user
ON vb_user.usergroupid=vb_usergroup.usergroupid
OR FIND_IN_SET(vb_usergroup.usergroupid, vb_user.membergroupids)
WHERE (usergroup.genericoptions & 4)
GROUP BY vb_usergroup.usergroupid
ORDER BY vb_usergroup.title ASC;
MySQL Error   : Unknown column 'usergroup.genericoptions' in 'where clause'
Error Number  : 1054
Request Date  : Monday, February 23rd 2009 @ 04:16:37 AM
Error Date    : Monday, February 23rd 2009 @ 04:16:37 AM
Script        : http://www.mysite.com/memberlist.php
Referrer      : http://www.mysite.com/index.php
IP Address    : 72.60.249.137
Username      : WebGuy
Classname     : vB_Database
MySQL Version : 5.0.75-community-log

[Hasann]

MySQL Error : Unknown column 'usergroup.genericoptions' in 'where clause'

you have there tableprefix error I had forget to add the tableprefix to the sql

it is fixed now please re-import product .xml file and "edited memberlist.php" file added to the zip if you dont want file edits you can just upload overwrite this file.

[TandyServices]

done.. fixed and works now.. thanks alot..

[digicom]

Thanks Hasann installed great job :up:

[adhmwagde]

always you are a good worker

installed

[Marco van Herwaarden]

Attachment removed as it is not allowed to distribute vBulletin files.