hacking memberlist file...Help please

[btappan]

i needed to move one of my custom profile fields (which was "company name") to be the first column in the member list instead of the username being first. i did it using this:

http://www.vbulletin.com/forum/showthread.php?t=112058

.......now i need to have it sort alphabetically by this field as well...
can anyone help me do what Jake suggest and modify the memberlist.php file to sort by my "field 5" as well? I need this very badly for my site! thanks for your help

[Andreas]

In memberlist.php 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

<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

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

In template memberlist_resultsbit FIND

<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

<td class="alt2Active">
		$userinfo[field5]
</td>

[btappan]

ahhh perfect. i'll be glad when i've learned enough to accomplish things like that on my own. one more quick question. can i make it defualt to be sorted by that field when a user first visits the member list link? as it stands now, it is still sorted by username by default.

thanks so much for your help and quick response!

[Andreas]

Yes. In memberlist.php, just some lines below the place where you added the code there is

PHP Code:

default:
        $sqlsort = 'user.username';
        $sortfield = 'username'; 


Replace that with

PHP Code:

default:
        $sqlsort = 'userfield.field5';
        $sortfield = 'companyname'; 


(Untested as I was too lazy to test, but theoretically it should work )

[btappan]

seems to have made no change :ermm: maybe something else?

[Andreas]

Yeah, there is another default being set earlier 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 == '')
{
        $sortfield = 'companyname';
} 


[btappan]

Voila! all worky now! thanks so much for your persistent help....

[btappan]

Hey KirbyDE, can you help Warhorse and I get the alpha search at the top of the memberlist page to sort by the added userfield, in this case, "company name" instead of by the username? It'd be greatly appreciated!

[btappan]

anyone else care to help me with this?

[Tbird66]

also looking for help getting the alpha search at the top of the memberlist page to sort by the added userfield.

any suggestions would be welcome!