FUDforum: FUDforum Suggestions » Find user with lowercase

Home » FUDforum » FUDforum Suggestions » Find user with lowercase

Show: Today's Messages :: Polls :: Message Navigator

Find user with lowercase [message #17961]

Tue, 27 April 2004 19:45

Gribnif

Messages: 82
Registered: December 2003

Karma:

Member

It seems that the LIKE operator is case-sensitive, so if a user look for "gribnif" they won't find me, since my name is "Gribnif". To avoid this problem, I just made the following change to line 35 of pmuserloc.php.t:

$c = uq("SELECT alias FROM {SQL_TABLE_PREFIX}users WHERE ucase(alias) LIKE '".addslashes(str_replace('\\', '\\\\', strtoupper($usr_login)))."%' AND id>1");

I suggest making this change in the CVS. I think the same change should be made to finduser, as well, at line 47:

$qry = "ucase(alias) LIKE '".addslashes(htmlspecialchars(str_replace('\\', '\\\\', strtoupper($usr_login))))."%' AND";

Report message to a moderator

[Message index]

		Find user with lowercase By: Gribnif on Tue, 27 April 2004 19:45
		Re: Find user with lowercase By: Ilia on Tue, 27 April 2004 20:10
		Re: Find user with lowercase By: Gribnif on Tue, 27 April 2004 20:17
		Re: Find user with lowercase By: Ilia on Tue, 27 April 2004 20:18
		Re: Find user with lowercase --> full wildcards By: wfjmueller on Wed, 28 April 2004 06:59
		Re: Find user with lowercase --> full wildcards By: Ilia on Wed, 28 April 2004 13:29
		Re: Find user with lowercase By: Gribnif on Wed, 28 April 2004 13:38
		Re: Find user with lowercase By: Ilia on Wed, 28 April 2004 13:44

Previous Topic:	Rebuild all themes
Next Topic:	Semi-anonymous user

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 01:59:35 GMT 2024

Total time taken to generate the page: 0.05178 seconds