Miscellaneous Hacks - Memberlist -- Custom Profile Field Sorting

Memberlist -- Custom Profile Field Sorting
For vBulletin 3.6.0


Description
By default, vBulletin cannot show just a single custom field on the memberlist, nevermind make it sortable. It's all or nothing.. I wanted to display just the location field and make it sortable, because I use the CountryFlag modification. I searched vbulletin.org to see if this was possible, but all that I could find was unanswered questions similarly asking how to do it. So I took it on myself to get something usable and working.


Instructions
Upload the PLUGIN, and edit it via the Plugin Manager.

Find:

	case 'urlname':

Change urlname to the variable you want to be used in the URL of the memberlist sorting. My example is location.

Find:

		$sqlsort = 'userfield.fieldX';

Change X to the field number of your custom profile field. My example is 2.

Now you have 2 templates to edit. First, memberlist.

Find:

	<if condition="$show['homepagecol']"><td class="thead" nowrap="nowrap">$vbphrase[home_page]</td></if>

Above it, add:

	<td class="thead" nowrap="nowrap"><a href="$sorturl&amp;order=DESC&amp;sort=urlname&amp;pp=$perpage$usergrouplink">Title</a> $sortarrow[urlname]</td>

Use DESC or ASC depending on which default sort order that you wish to use. Change both instances of urlname to the variable that you specified in the plugin earlier (location). Change Title to the title of the field that you wish to be displayed. My example is Location.

Now edit the memberlist_resultsbit template.

Find:

	<if condition="$show['homepagecol'] AND exec_switch_bg()"><td class="$bgclass"><if condition="$show['homepagelink']"><a href="$userinfo[homepage]" target="_blank"><img src="$stylevar[imgdir_button]/home.gif" alt="home.gif" title="<phrase 1="$userinfo[username]">$vbphrase[visit_xs_homepage]</phrase>"  border="0" /></a><else />&nbsp;</if></td></if>

Above it, add:

	<if condition="exec_switch_bg()"><td class="$bgclass"><if condition="$userinfo[fieldX]"><div class="smallfont">$userinfo[fieldX]</div></if></td></if>

Change both instances of X to the field number that you specified in the plugin earlier (2).


Final Comment
It's not pretty, it's not clever but it works..

[D Holzwarth]

Does this work with vb 3.6.5

[jacobi]

It works on my site.

[D Holzwarth]

Works on mine now too. Very sweet. Was able to delete additional databases due to this feature. Thank you.

[baderandsonsco]

Thank you very much!

[VikesRule]

On this part:

Change both instances of urlname to the variable that you specified in the plugin earlier (location).

If I'm doing this for a custom field, do I put say "field4" in for the urlname or whatever field number corresponds with it?

And what do I do to add more than one custom field that is sortable?

[VikesRule]

Bump..........................

[ganima]

Does anybody know how to change sort from DESC to ASC when clicking on the link in the forum?

Untill now I only can specify which order to sort at the first click. But it should go revers on click #2.

Need some help.

[MjrNuT]

This works like a charm for v3.8.4

@ganima -- Not possible I guess. Mine will not resort either. Not critical for me though.

[joshskeety]

Originally Posted by ganima

Does anybody know how to change sort from DESC to ASC when clicking on the link in the forum?

Untill now I only can specify which order to sort at the first click. But it should go revers on click #2.

Need some help.

Once you've clicked it once you have to click the arrow next to the title to sort up or down

[Jim Westergren]

Does this work with vBulletin 4?