vb.org Archive - hacking memberlist file...Help please

I had a functionality requirement similiar to btappan's, but I needed the custom field to only be visible to those users who had permissions to view private custom fields.

To accomplish this, I modified KirbyDE's hack. I'm reposting Kirby's hack with my modifications (I hope this is proper procedure - this is the first time I've posted code) - thanks KirbyDE!!

The following steps will set up your Member List to display the Company Name (user field 5 in this example) as the first column and sort by it if the user has permissions to see private custom fields (assuming that user field 5 is a private custom field of course ;) ), and display the default Member List if the user does not have permissions to see private custom fields.

In memberlist.php FIND

PHP Code:


		
			
// set defaults and sensible values 



if ($sortfield == '') 

{ 

        $sortfield = 'username'; 

}

REPLACE that WITH

PHP Code:


		
			
// set defaults and sensible values



if ($sortfield == '')

{

    if ($permissions['genericpermissions'] & CANSEEHIDDENCUSTOMFIELDS)

    {

        $sortfield = 'companyname';

    }

    else

    {

        $sortfield = 'username';

    }

}

then FIND

PHP Code:


		
			
switch ($sortfield) 

{ 

         case 'username': 

                 $sqlsort = 'user.username'; 

                 break;

BELOW that ADD

PHP Code:


		
			
case 'companyname': 

                 $sqlsort = 'userfield.field5'; 

                 break;

Revert to the original versions of your memberlist and memberlist_resultsbit templates.

Set your Company Name field to NOT show up on members list

In template memberlist FIND

Code:

<td class="thead" align="$stylevar[left]" nowrap="nowrap"><a href="$sorturl&amp;order=ASC&amp;sort=username&amp;pp=$perpage&amp;ltr=$  ltr$usergrouplink">$vbphrase[username]</a> $sortarrow[username]</td>

ABOVE that ADD

Code:

<if condition="$permissions['genericpermissions'] & CANSEEHIDDENCUSTOMFIELDS">

<td class="thead" align="$stylevar[left]" nowrap="nowrap"><a href="$sorturl&amp;order=ASC&amp;sort=companyname&amp;pp=$perpage&amp;ltr=$ltr$usergrouplink">Company Name</a> $sortarrow[companyname]

</td></if>

In template memberlist_resultsbit FIND

Code:

<td class="alt1Active" align="$stylevar[left]" id="u$userinfo[userid]">

                <a href="member.php?$session[sessionurl]u=$userinfo[userid]">$userinfo[musername]</a>

                <if condition="$show['usertitlecol']"><div class="smallfont">$userinfo[usertitle]</div></if>

        </td>

ABOVE that ADD

Code:

<if condition="$permissions['genericpermissions'] & CANSEEHIDDENCUSTOMFIELDS">

<td class="alt2Active" align="$stylevar[left]"> $userinfo[field5]

</td></if>

EDIT:
The following will allow the alpha search at the top of the memberlist page to sort by the added userfield.
In memberlist.php FIND

PHP Code:


		
			
    if ($ltr != '')

    {

        if ($ltr == '#')

        {

            $condition = "username NOT REGEXP(\"^[a-zA-Z]\")";

        }

        else

        {

            $ltr = chr(intval(ord($ltr)));

            $condition = 'username LIKE("' . addslashes_like($ltr) . '%")';

        }

    }

REPLACE that WITH

PHP Code:


		
			
    if ($ltr != '')

    {

        if ($ltr == '#')

        {

            if (($sortfield == 'companyname') OR ($sortfield != 'username' AND ($permissions['genericpermissions'] & CANSEEHIDDENCUSTOMFIELDS))) 

            {

                $condition = "field5 NOT REGEXP(\"^[a-zA-Z]\")";

            }

            else

            {

                $condition = "username NOT REGEXP(\"^[a-zA-Z]\")";

            }

        }

        else

        {

            $ltr = chr(intval(ord($ltr)));



            if (($sortfield == 'companyname') OR ($sortfield != 'username' AND ($permissions['genericpermissions'] & CANSEEHIDDENCUSTOMFIELDS))) 

            {

                $condition = 'field5 LIKE("' . addslashes_like($ltr) . '%")';

            }

            else

            {    

                $condition = 'username LIKE("' . addslashes_like($ltr) . '%")';

            }

        }

    }

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01075 seconds Memory Usage 1,749KB 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 (5)bbcode_code_printable (6)bbcode_php_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 (3)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: