You should not have to run a query since $userinfo will have all the users data.
The code below will work fine
PHP Code:
if ($userinfo['usergroupid'] == '42')
{
if ($userinfo['field54'] == 'grey')
{
$prepared['rank'] = '<img src="/forums/images/elite_user_ranks/userbar-elite-grey.png" alt="NextGenUpdate Elite Member" border="0" />';
}
if ($userinfo['field54'] == 'red')
{
$prepared['rank'] = '<img src="/forums/images/elite_user_ranks/userbar-elite-red.png" alt="NextGenUpdate Elite Member" border="0" />';
}
}
--------------- Added [DATE]1397778374[/DATE] at [TIME]1397778374[/TIME] ---------------
the code you have works on my forum "vb 4.2.2 pl 1" but use my code you don't need the query
--------------- Added [DATE]1397778920[/DATE] at [TIME]1397778920[/TIME] ---------------
if they are in multiply usergroups i would use this
PHP Code:
if (is_member_of($userinfo, 42))
{
if ($userinfo['field54'] == 'grey')
{
$prepared['rank'] = '<img src="/forums/images/elite_user_ranks/userbar-elite-grey.png" alt="NextGenUpdate Elite Member" border="0" />';
}
if ($userinfo['field54'] == 'red')
{
$prepared['rank'] = '<img src="/forums/images/elite_user_ranks/userbar-elite-red.png" alt="NextGenUpdate Elite Member" border="0" />';
}
}