The Arcive of Official vBulletin Modifications Site.

jpapadpapa · #1 03-21-2008, 06:21 PM

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 · #2 03-21-2008, 07:21 PM

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 · #3 03-21-2008, 08:32 PM

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.

King Kovifor · #4 03-22-2008, 02:03 AM

This post is better suited for programming discussions. Moved.

jpapadpapa · #5 03-23-2008, 12:37 AM

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.

Lynne · #6 03-23-2008, 01:51 AM

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 · #7 03-23-2008, 02:47 PM

Quote:

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.

Quote:

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.

jpapadpapa · #8 03-23-2008, 04:35 PM

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.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04235 seconds Memory Usage 2,277KB Queries Executed 13 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (6)bbcode_php (2)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (8)post_thanks_box (8)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (8)post_thanks_postbit_info (8)postbit (8)postbit_onlinestatus (8)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!