ProfilePic ForumHome Conditional

[paul41598]

I need this code, somehow put in a plugin, global start Im presuming, But I dont think its 100% accurate, cuz I already tried it,and got erros

PHP Code:

        $profilepic = $DB_site->query_first("
            SELECT userid, dateline
            FROM " . TABLE_PREFIX . "customprofilepic
            WHERE userid = $vbulletin->userinfo[userid]
        ");

        $show['profilepic'] = iif($profilepic, true, false); 


I can't use this conditional in forumhome, cuz it doesnt work
<if condition="$show['profilepic']">

I know using a plugin will help make it so I can use that conditional in any template. Can anyone help?

My goal here is to say on the forumhome. If user doesnt have a custom profile pic, mention to them that they outta upload one.