[RedGTiVR6]

https://vborg.vbsupport.ru/showpost....&postcount=292

This is the post I take it?

The provided code is a bit off, but I figured it out.

I've entered the code as follows, but now my memberlist.php page doesn't even show up...

In memberlist.php:


FIND:

PHP Code:

    $profilefields = $db->query_read_slave("
        SELECT *
        FROM " . TABLE_PREFIX . "profilefield
        WHERE searchable = 1
            WHERE form = 0 " 


REPLACE WITH:

PHP Code:

    $profilefields = $db->query_read_slave("
        SELECT *
        FROM " . TABLE_PREFIX . "profilefield
        WHERE searchable = 1
            WHERE form = 0 OR form = 6 " 


FIND:

PHP Code:

    // get extra profile fields
    $profilefields = $db->query_read_slave("
        SELECT *
        FROM " . TABLE_PREFIX . "profilefield
        WHERE searchable = 1
            AND form = 0 


REPLACE WITH:

PHP Code:

    // get extra profile fields
    $profilefields = $db->query_read_slave("
        SELECT *
        FROM " . TABLE_PREFIX . "profilefield
        WHERE searchable = 1
            AND form = 0 OR form = 6 


The correct code should be as follows for the first replacement, the second one is right.

PHP Code:

    $profilefields = $db->query_read_slave("
        SELECT profilefieldid, type, data, optional, memberlist, searchable
        FROM " . TABLE_PREFIX . "profilefield
            WHERE form = 0 OR form = 6"