vb.org Archive

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)

btappan 08-02-2004 11:16 PM

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

Andreas 08-02-2004 11:45 PM

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>


btappan 08-03-2004 12:35 AM

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 08-03-2004 12:41 AM

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 08-03-2004 12:58 AM

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

Andreas 08-03-2004 01:04 AM

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 08-03-2004 02:10 AM

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

btappan 09-05-2004 08:39 PM

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 09-08-2004 05:01 PM

anyone else care to help me with this?

Tbird66 12-12-2004 07:08 AM

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!


All times are GMT. The time now is 01:41 AM.

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.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