Search for User Email in usermgr.php

[JohannM]

Hi there

Can someone help me perhaps.

How and where can I change the script in usermgr.php to be able to search for a users email address (same as when you would search for Username) ?

Thank you in advance.

[Αndré]

Open bridge/udb_base.inc.php, find

Code Select Expand

$options['search'] = 'WHERE u.'.$f['username'].' LIKE "%'.$options['search'].'%" ';
and replace with

Code Select Expand

$options['search'] = 'WHERE u.'.$f['username'].' LIKE "%'.$options['search'].'%" OR u.'.$f['email'].' LIKE "%'.$options['search'].'%" ';

[JohannM]

Hi André

Thanx so much. Btw, Happy New Year ....

What would we do without you here ?

Thanx yet again ...

[JohannM]

Hi André

Hope you can help with this one as well please, if you don't mind.

I have fixed my language file.

I have altered my usermgr.php to show only the fileds I needed to see, since I am the only one publishing photos.

I have looked through the file, but were not able to figure out what to do in order to have the "User Email" sorting Ascending or Desending in the
column. I get a critical database error.

Any ideas ?

Thanx in Advance.

JohannM
(www.unp.boy-idols.com)

[JohannM]

André

I figured it out ...

in udb_base.inc.php

find

// Sort codes
        $sort_codes = array('name_a' => 'user_name ASC',

and add after "'lv_d' => 'user_lastvisit DESC',"

'email_a' => 'user_email ASC',
'email_d' => 'user_email DESC',


Thanx anyway

JohannM

[Αndré]

I was just about to reply, glad it works now