[OnyxChase]

Hi guys,

I am working on a plugin which will show the latest awards recently given, but the database does not contain the member's username. It only contains the user ID. Is there a way to get the username from the userID?

Here is my current code:

PHP Code:

    $query = $vbulletin->db->query_read("
        SELECT award_user.issue_id, award_user.award_id, award_user.userid, award_user.issue_reason, award_user.issue_time
        FROM " . TABLE_PREFIX . "award_user as award_user
        ORDER BY issue_id DESC
        LIMIT $limit"
);


    // reset variables
    $counter = 0;
    $latest_award_bits = '';
    
    while ($row = $vbulletin->db->fetch_array($query))
    {

        $issueid = $row['issue_id'];
        $awardid = $row['award_id'];
        $userid = $row['userid'];
        $reason = $row['issue_reason'];
        $issuetime = $row['issue_time'];


        $show['latest_break'] = $counter++;

eval('$latest_award_bits .= "' . fetch_template('latest_awards_bit') . '";');
        
    } 


Thanks, any help would be greatly appreciated!