Thread: Add city and occupation search to Admin Panel search

This works on AE Dating 4.1 Patch 2

Remember to backup all files first

In Admin/profiles.php, find:

PHP Code:

if (strlen($search))
{
    if ($_GET[s_mail])
    $email_part = " AND `Email` LIKE '%$search%' ";
    elseif ($_GET[s_nickname])
    $email_part = " AND `NickName` LIKE '%$search%' ";
    elseif ($_GET[s_id]) 
        $email_part = " AND `ID` = '$search' "; 


Below the last line, add in:

PHP Code:

    elseif ($_GET[s_city])
    $email_part = " AND `City` LIKE '%$search%' ";
    elseif ($_GET[s_occupation])
    $email_part = " AND `Occupation` LIKE '%$search%' "; 


Find the following:

PHP Code:

<tr>
    <td align=right> <input class=text name='s_mail' type=submit value="Search by Email"> </td>
    <td align=center> <input class=text name='s_nickname' type=submit value="Search by Nickname"> </td>
    <td align=left> <input class=text name='s_id' type=submit value="Search by ID"> </td>
</tr> 


Below the last </tr> tag, paste the following:

PHP Code:

<tr>
    <td align=center> <input class=text name='s_city' type=submit value="City"> </td>
    <td align=left> <input class=text name='s_occupation' type=submit value="Occupation"> </td>
</tr> 


This can be modified to allow for additional fields to be searched for, should need be.