[wolfe]

heres a alteration to show the newest members in the usergroup colour

FIND: plugin manager > [vbTrends] Run Main Trends Code

        $vbtrends_newmembers_bit = '';    
        while($member = $db->fetch_array($vbtrends_last_x_joins_result))
        {
              $newuserid = $member['userid'];
              $newusername = $member['username'];
              eval('$vbtrends_newmembers_bit .= "' . fetch_template('forumhome_vbtrends_newmember_bit') . '";');
        }
    }

REPLACE WITH:

        $vbtrends_newmembers_bit = '';    
        while($member = $db->fetch_array($vbtrends_last_x_joins_result))
        {
              $newuserid = $member['userid'];
                        fetch_musername($member);
              $newusername = $member['musername'];
              eval('$vbtrends_newmembers_bit .= "' . fetch_template('forumhome_vbtrends_newmember_bit') . '";');
        }
    }

THEN FIND: plugin manager > [vbTrends] Default Last X Joins Hook

    // Last x joins
    $vbtrends_last_x_joins_result = $db->query_read("
        SELECT *
        FROM " . TABLE_PREFIX . "user              
        ORDER BY joindate DESC
        LIMIT " . $vbulletin->options['vbtrends_newmembers']
    );

REPLACE WITH:

    // Last x joins
    $vbtrends_last_x_joins_result = $db->query_read("
        SELECT username, userid, joindate, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
        FROM " . TABLE_PREFIX . "user AS user               
        ORDER BY joindate DESC
        LIMIT " . $vbulletin->options['vbtrends_newmembers']
    );

result atttached

asked bwt it a while bk and no response so made it my self