[PMs] Username Finder

[Daniel]

Hey all,

So we know that by default, when we begin typing in a username in the Private Message system the system will pull up a list of the usernames we might be trying to send to.

e.g. I'm typing "Dani" and the username "Daniel" is displayed in a pop-up box.



Is there a way to change this, so that when I type in "Dani" the usernames pulled up would also include usernames like "Ladani" or "Ladanioso"

If you have any guidance or code know-how, please don't hesitate to share. It's all much appreciated! Thank you!

[Dave]

ajax.php, around line 128 to 133 you have this:

PHP Code:

        $users = $db->query_read_slave("
            SELECT user.userid, user.username FROM " . TABLE_PREFIX . "user
            AS user WHERE username LIKE('" . $db->escape_string_like($fragment) . "%')
            ORDER BY username
            LIMIT 15
        "); 


Modify it to this:

PHP Code:

        $users = $db->query_read_slave("
            SELECT user.userid, user.username FROM " . TABLE_PREFIX . "user
            AS user WHERE username LIKE('%" . $db->escape_string_like($fragment) . "%')
            ORDER BY username
            LIMIT 15
        "); 


[Daniel]

Works like a charm. Thanks a million Dave.