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

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)

- - hacking memberlist file...Help please (https://vborg.vbsupport.ru/showthread.php?t=67922)

hacking memberlist file...Help please

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

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

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:

<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

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:

<td class="alt2Active">

                $userinfo[field5]

</td>

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!

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 ;))

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

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';

}

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

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!

anyone else care to help me with this?

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!

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)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 (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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01020 seconds Memory Usage 1,746KB 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 (4)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 (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
Messages: