vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Please Help Me! Member list request... (https://vborg.vbsupport.ru/showthread.php?t=173740)

jpapadpapa 03-21-2008 06:21 PM
Please Help Me! Member list request...
 
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 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 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 03-22-2008 02:03 AM
This post is better suited for programming discussions. Moved.

jpapadpapa 03-23-2008 12:37 AM
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:

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 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 03-23-2008 02:47 PM
Quote:
Originally Posted by jpapadpapa (Post 1472120)
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:

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 (Post 1472154)
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 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.


All times are GMT. The time now is 09:30 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01108 seconds
  • Memory Usage 1,780KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (6)bbcode_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (8)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete