Please Help Me! Member list request...

[jpapadpapa]

I really need to figure out how to organize my members alphabetically by their last names in the member list! We need to be able to click on those letters at the top and have them sort by last names instead of usernames. I already figured out how to add just the last name custom field to the listing, but I still don't know how to make it alphabetized by that field. I thought I found the answer in the link below (post #11), but I tried it and had problems.

https://vborg.vbsupport.ru/showthread.php?t=67922

Can anyone please help me? I need to get this done very soon!:( I have a re-launch in a couple weeks and we're doing a test group tomorrow. I would really like to have this done by then!

[Lynne]

Maybe paste the code here that you already tried and tell us what went wrong. It is probably easier for us to help you if we see what you've done and know what isn't working. Unfortunately, it doesn't look like there is a well placed hook to help with the sorting.

[jpapadpapa]

Okay, I will try. To be honest, my brain is a little fried from minimal sleep and staring at the computer for days! So, I don't think I can even tell you at this point how I got the custom field "last name" to show up, but I can tell you what I tried for getting that field to be used for the letter sort at the top.

I first found this code in memberlist.php:

if ($ltr != '')
{
if ($ltr == '#')
{
$condition = "username NOT REGEXP(\"^[a-zA-Z]\")";
}
else
{
$ltr = chr(intval(ord($ltr)));
$condition = 'username LIKE("' . addslashes_like($ltr) . '%")';
}
}

I then replaced it with this:

if ($ltr != '')
{
if ($ltr == '#')
{
if (($sortfield == 'lastname') OR ($sortfield != 'username' AND ($permissions['genericpermissions'] & CANSEEHIDDENCUSTOMFIELDS)))
{
$condition = "field20 NOT REGEXP(\"^[a-zA-Z]\")";
}
else
{
$condition = "username NOT REGEXP(\"^[a-zA-Z]\")";
}
}
else
{
$ltr = chr(intval(ord($ltr)));

if (($sortfield == 'lastname') OR ($sortfield != 'username' AND ($permissions['genericpermissions'] & CANSEEHIDDENCUSTOMFIELDS)))
{
$condition = 'field20 LIKE("' . addslashes_like($ltr) . '%")';
}
else
{
$condition = 'username LIKE("' . addslashes_like($ltr) . '%")';
}
}
}

But, after I did it and it didn't work, I realized that the code this guy wrote was for something more specific than what I need. If I were functioning at full capacity, I might be able to figure it out, but...that is not the case today!;) Plus, I am a little scared of messing stuff up, since I am still new at this. I'm guessing I need to change something else somewhere, too, and take out some of these conditionals (think that's what you call them).

--------------- Added 1206136887 at 1206136887 ---------------

I did discover that it appears to be organizing them by last name within each letter. So, for example, my username "Jpapadpapa" is listed under the "J"s, but within that it is sorted by my last name, which starts with a "P". So, I guess I'm on the right track somehow.

[King Kovifor]

This post is better suited for programming discussions. Moved.

[jpapadpapa]

I did it!!:D

Here is how, in case someone else needs to do this. Basically, I took the code from that other thread and pulled out what I didn't need and changed one thing that was wrong (because it was a function...or whatever it's called...from an older version of vBulletin).

First, I followed the directions in the other thread to get the last names field to appear as the first column. Then, I found this code in memberlist.php:

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) . '%")';
}
}

I replaced it with this:

if ($ltr != '')
{
if ($ltr == '#')
{
if ($sortfield == 'lastname')
{
$condition = "field20 NOT REGEXP(\"^[a-zA-Z]\")";
}
else
{
$condition = "username NOT REGEXP(\"^[a-zA-Z]\")";
}
}
else
{
$ltr = chr(intval(ord($ltr)));

if ($sortfield == 'lastname')
{
$condition = 'field20 LIKE("' . $db->escape_string_like($ltr) . '%")';
}
else
{
$condition = 'username LIKE("' . $db->escape_string_like($ltr) . '%")';
}
}
}

I must say that I am quite proud of myself.:) Had a bit of help from my husband, but mostly did it on my own.

[Lynne]

That's wonderful! And it's also great that you shared it. So often people fix their problem but don't say how.

[King Kovifor]

I did it!!:D

Here is how, in case someone else needs to do this. Basically, I took the code from that other thread and pulled out what I didn't need and changed one thing that was wrong (because it was a function...or whatever it's called...from an older version of vBulletin).

First, I followed the directions in the other thread to get the last names field to appear as the first column. Then, I found this code in memberlist.php:

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) . '%")';
}
}

I replaced it with this:

if ($ltr != '')
{
if ($ltr == '#')
{
if ($sortfield == 'lastname')
{
$condition = "field20 NOT REGEXP(\"^[a-zA-Z]\")";
}
else
{
$condition = "username NOT REGEXP(\"^[a-zA-Z]\")";
}
}
else
{
$ltr = chr(intval(ord($ltr)));

if ($sortfield == 'lastname')
{
$condition = 'field20 LIKE("' . $db->escape_string_like($ltr) . '%")';
}
else
{
$condition = 'username LIKE("' . $db->escape_string_like($ltr) . '%")';
}
}
}

I must say that I am quite proud of myself.:) Had a bit of help from my husband, but mostly did it on my own.

Feel free to share where most users look, the Modifications forum. :)

That's wonderful! And it's also great that you shared it. So often people fix their problem but don't say how.

Unfortunately, that is the case. :(

[jpapadpapa]

I just knew how much it would have meant to me to find it or to have gotten help with it, so hopefully this will help someone else.:) I will post it in the Modifications forum, also.