vb.org Archive - MySQL: Getting Username from UserID

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - MySQL: Getting Username from UserID (https://vborg.vbsupport.ru/showthread.php?t=168546)

OnyxChase

01-23-2008 09:38 AM

MySQL: Getting Username from UserID

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!

Dismounted

01-23-2008 09:56 AM

[sql]SELECT award_user.issue_id, award_user.award_id, award_user.userid, award_user.issue_reason, award_user.issue_time, user.username
FROM " . TABLE_PREFIX . "award_user AS award_user
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (userid)
ORDER BY issue_id DESC
LIMIT $limit[/sql]

OnyxChase

01-23-2008 10:16 AM

MMM for some reason this isn't giving me any results back... Sorry I'm new to this mySQL stuff!

Dismounted

01-23-2008 10:34 AM

Sorry, wrong query.
[sql]SELECT award_user.issue_id, award_user.award_id, award_user.userid, award_user.issue_reason, award_user.issue_time, user.username
FROM " . TABLE_PREFIX . "award_user AS award_user
LEFT JOIN " . TABLE_PREFIX . "user AS user USING (userid)
ORDER BY issue_id DESC
LIMIT $limit[/sql]
Replace your query with mine, then you can access the username using $row['username'].

OnyxChase

01-23-2008 10:37 AM

Ahh! Works great!!!! Thanks so much !!! :D Now the fun part begins .... editing the templates :)

All times are GMT. The time now is 07:02 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01167 seconds Memory Usage 1,725KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: