Best way to obtain username from userid

[mangus580]

What is the best method of getting a username when you have the userid?

I am working on a watermark plugin, that uses the hook attachment_display. It seems I can come up with the userid that posted the attachment quite easily, but I am unable to easily turn that into a username which is what I ultimately want.

Can anyone suggest anything?

Thanks!

[Lynne]

If this is a continuation of your attachment mod from another thread, it might have been smart to keep this question in there so users have all the information. In this particular case, you should just JOIN the user table in the attachment query to grab the username at the same time all the other info about the user is grabbed. It looks like the hook to use would be attachment_start. It's always best to take a look at the code around any hook you are using (in this case the attachment_display hook) and see what else is going on (I said that before in regards to finding the userid).

[mangus580]

I started a new tread, as I felt it was a different topic really... sorry :-(

What you describe sounds like an edit to a core file, is this true? I am really trying to avoid that if possible....

[James Birkett]

Hooks are used to use custom code without having to edit source files.
Admin CP -> Plugins & Products -> Add New Plugin
Product: vBulletin
Hook: attachment_start
Title: Whatever you like
PHP Code: {Your code}
Plugin is Active: Yes

[Lynne]

Originally Posted by mangus580

What you describe sounds like an edit to a core file, is this true? I am really trying to avoid that if possible....

Nope, just a plugin as James describes below:

Originally Posted by James Birkett

Hooks are used to use custom code without having to edit source files.
Admin CP -> Plugins & Products -> Add New Plugin
Product: vBulletin
Hook: attachment_start
Title: Whatever you like
PHP Code: {Your code}
Plugin is Active: Yes

PHP Code:

$hook_query_fields = ",user.username ";
$hook_query_joins = join the user table here ; 


[mangus580]

Got it, THANKS!!