Please Help Me! Member list request...

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