Please Help Me! Member list request...

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

PHP Code:

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:

PHP Code:

   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 [DATE]1206136887[/DATE] at [TIME]1206136887[/TIME] ---------------

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.