Must have Photo in MemberSearch

[T3MEDIA]

anyone? Why do they force you to come here if NO ONE will even try to help?

[T3MEDIA]

Guys.. wtf... its that hard? I know I have no idea. OK tell me at least what points to the graphics on a profile field... I'll try myself.

[T3MEDIA]

Helllp! Like Help!

[sabret00the]

don't you want this for vB3 anyway?

[Andreas]

For vB3 I'd modify the query to make a join on customprofilepic and check if a row does exist.

[T3MEDIA]

Originally Posted by KirbyDE

For vB3 I'd modify the query to make a join on customprofilepic and check if a row does exist.

Yes I want it for Vb3...

So Kirby you think this idea you said could work?

[Andreas]

Yes, it does work (in theory, didn't write the code and test it)

[T3MEDIA]

yeah.... looking for code.

[Andreas]

OK, this is just spin-off and untested

In memberlist.php FIND

PHP Code:

'usergroupid' => INT 


REPLACE that with

PHP Code:

'usergroupid' => INT,
'haspic' => INT 


FIND

PHP Code:

if ($vboptions['usememberlistadvsearch'])
{ 


BELOW that ADD

PHP Code:

if ($haspic) {
  $condition .= " AND NOT ISNULL(customprofilepic.userid) ";
} 


FIND

PHP Code:

$userscount = $DB_site->query_first("
        SELECT COUNT(*) AS users
        FROM " . TABLE_PREFIX . "user AS user
        LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield USING (userid)
        WHERE $condition
                AND     user.usergroupid IN ($ids)
"); 


REPLACE that with

PHP Code:

$userscount = $DB_site->query_first("
        SELECT COUNT(*) AS users
        FROM " . TABLE_PREFIX . "user AS user
        LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield USING (userid)
        " . iif($haspic, "LEFT JOIN " . TABLE_PREFIX . "customprofilepic AS customprofilepic ON (customprofilepic.userid=user.userid)") . "
        WHERE $condition
                AND     user.usergroupid IN ($ids)
"); 


FIND

PHP Code:

" . iif($show['profilepiccol'], "LEFT JOIN " . TABLE_PREFIX . "customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid) ") . " 


REPLACE that with

PHP Code:

" . iif($show['profilepiccol'] OR $haspic, "LEFT JOIN " . TABLE_PREFIX . "customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid) ") . " 


In Template memberlist_search create a checkbox named haspic with value 1 (whereever you want to have it):

<label for="cb_haspic"><input type="checkbox" name="haspic" value="1" id="cb_haspict" />Show only members who have a profile picture</label>

... I think that's it.

[T3MEDIA]

crazy of me to test on my board but.... it works sometimes... LOL
I freaked at first but it started to only do it sometimes.
why would that happen?