Alpha Sort Custom Profile Field in Member List
Mod Version: 1.00, by jpapadpapa
This modification is in the archives.
| vB Version: 3.6.8 | Rating:  (0 vote - 0 average) |
Installs: 0 |
| Released: 23 Mar 2008 | Last Update: Never | Downloads: 1 |
 Not Supported
 Code Changes
Re-usable Code
Translations
|
||
Note: I came up with this very recently and am currently testing it on my board and running into issues after doing a member search. Please do not use this until I have it figured out. If you can help me figure out what is wrong, I would appreciate it! I am very new at this.
Well, I can't believe I have actually done something worthy of being posted. I have shocked myself.
Admittedly, I did have a little help from my husband. (Thanks, Honey!)
Anyway, this is a modification for sorting a custom profile field by the letter/alpha sort at the top of the member list. Some forums, such as mine, are better sorted by another field. My forum is for a local group of people who already know one another. So, it makes more sense for them to see everyone alphabetized by their real names. However, we also wanted to allow everyone to pick their own usernames, rather than require them to use real names.
To do this, you must first use this hack to allow your custom field to be shown (without showing all of your custom fields) in the member list.
Once you have that working, you can move it to the first column by changing this code in the memberlist.php (thanks to Andreas for this part):
First, find this:
Replace it with this (where "X" is the custom field you want to appear and "lastname" is the name of that field):
Then, find this:
Replace it with this (where "lastname" is the name of the profile field you are using):
Now you should have your specific custom field listed on your member list as the first column. Finally, to make it sort by the alpha list at the top, you will need to do the following:
Find this code in the memberlist.php:
Replace it with this (again, using your specific custom field number and name instead of "fieldX" and "lastname"):
That's it! I hope this helps someone else. If there are any problems with it, let me know. It was quite a process for this newbie to figure it all out and it's possible I may have missed a step here.
Well, I can't believe I have actually done something worthy of being posted. I have shocked myself.
Admittedly, I did have a little help from my husband. (Thanks, Honey!)Anyway, this is a modification for sorting a custom profile field by the letter/alpha sort at the top of the member list. Some forums, such as mine, are better sorted by another field. My forum is for a local group of people who already know one another. So, it makes more sense for them to see everyone alphabetized by their real names. However, we also wanted to allow everyone to pick their own usernames, rather than require them to use real names.
To do this, you must first use this hack to allow your custom field to be shown (without showing all of your custom fields) in the member list.
Once you have that working, you can move it to the first column by changing this code in the memberlist.php (thanks to Andreas for this part):
First, find this:
PHP Code:
default:
$sqlsort = 'user.username';
$sortfield = 'username';
Replace it with this (where "X" is the custom field you want to appear and "lastname" is the name of that field):
PHP Code:
default:
$sqlsort = 'userfield.[COLOR="Red"]fieldX[/COLOR]';
$sortfield = '[COLOR="Red"]lastname[/COLOR]'
Then, find this:
PHP Code:
// set defaults and sensible values
if ($sortfield == '')
{
$sortfield = 'username';
}
Replace it with this (where "lastname" is the name of the profile field you are using):
PHP Code:
// set defaults and sensible values
if ($sortfield == '')
{
$sortfield = '[COLOR="Red"]lastname[/COLOR]';
}
Now you should have your specific custom field listed on your member list as the first column. Finally, to make it sort by the alpha list at the top, you will need to do the following:
Find this code in the memberlist.php:
PHP Code:
if ($ltr != '')
{
if ($ltr == '#')
{
$condition = "username NOT REGEXP(\"^[a-zA-Z]\")";
}
else
{
$ltr = chr(intval(ord($ltr)));
$condition = 'username LIKE("' . $db->escape_string_like($ltr) . '%")';
}
}
Replace it with this (again, using your specific custom field number and name instead of "fieldX" and "lastname"):
PHP Code:
if ($ltr != '')
{
if ($ltr == '#')
{
if ($sortfield == '[COLOR="Red"]lastname[/COLOR]')
{
$condition = "[COLOR="Red"]fieldX[/COLOR] NOT REGEXP(\"^[a-zA-Z]\")";
}
else
{
$condition = "username NOT REGEXP(\"^[a-zA-Z]\")";
}
}
else
{
$ltr = chr(intval(ord($ltr)));
if ($sortfield == [COLOR="Red"]'lastname'[/COLOR])
{
$condition = '[COLOR="Red"]fieldX[/COLOR] LIKE("' . $db->escape_string_like($ltr) . '%")';
}
else
{
$condition = 'username LIKE("' . $db->escape_string_like($ltr) . '%")';
}
}
}
Download
No files for download.