[King Kovifor]

Originally Posted by jpapadpapa

I did it!!

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:

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


I replaced it with this:

PHP Code:

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.

Originally Posted by Lynne

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.